SELECT CONCAT(@rownum:=@rownum+1,'.') as `rank`,`name`,`match_home`,`win_home`,`tie_home`,`lost_home`,CONCAT(`goals_for_home`,':',`goals_ag_home`) as `score`,`points_home`
FROM jmf_vs_teams, (SELECT @rownum:=0) r
WHERE
`vs_compt_id` =
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
SELECT CONCAT(@rownum:=@rownum+1,'.') as `rank`,`name`,`match_home`,`win_home`,`tie_home`,`lost_home`,CONCAT(`goals_for_home`,':',`goals_ag_home`) as `score`,`points_home` FROM jmf_vs_teams, (SELECT @rownum:=0) r WHERE `vs_compt_id` =
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
SELECT CONCAT(@rownum:=@rownum+1,'.') as `rank`,`name`,`match_home`,`win_home`,`tie_home`,`lost_home`,CONCAT(`goals_for_home`,':',`goals_ag_home`) as `score`,`points_home` FROM jmf_vs_teams, (SELECT @rownum:=0) r WHERE `vs_compt_id` = ORDER BY points_home DESC, goals_for_home-goals_ag_home DESC, goals_for_home DESC LIMIT 0, 200
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY points_home DESC, goals_for_home-goals_ag_home DESC, goals_for_home DES' at line 1