SELECT CONCAT(@rownum:=@rownum+1,'.') as `rank`, t.`name` as `team_name`, `match_all`,`win_all`,`tie_all`, `lost_all`, CONCAT(`goals_for_all`,':',`goals_ag_all`) as `score`, `points_all`, `final_prio` FROM (SELECT @rownum:=0) r, jmf_vs_teams t 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`, t.`name` as `team_name`, `match_all`,`win_all`,`tie_all`, `lost_all`, CONCAT(`goals_for_all`,':',`goals_ag_all`) as `score`, `points_all`, `final_prio` FROM (SELECT @rownum:=0) r, jmf_vs_teams t WHERE `vs_compt_id` = ORDER BY t.points_all DESC, t.final_prio DESC, goals_for_all-goals_ag_all DESC, goals_for_all DESC LIMIT 0, 9223372036854775807
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 t.points_all DESC, t.final_prio DESC, goals_for_all-goals_ag_all DESC, ' at line 1
