SELECT CONCAT(@rownum:=@rownum+1,'.') as `rank`, t1.* FROM ( SELECT t2.`name` as `name`, t4.`short_name` as `team_name`, COUNT(*) as `cards` FROM jmf_vs_matches_events t INNER JOIN ( SELECT vs_match_id FROM jmf_vs_matches t LEFT JOIN jmf_vs_teams tt ON tt.vs_team_id = t.vs_team_a_id LEFT JOIN jmf_vs_teams ttt ON ttt.vs_team_id = t.vs_team_b_id WHERE tt.vs_compt_id = AND ttt.vs_compt_id = AND t.active =1 ) AS matches ON t.`vs_match_id` = matches.`vs_match_id` LEFT JOIN jmf_vs_players t2 ON t2.`vs_player_id` = t.`vs_player_id` LEFT JOIN jmf_vs_players_teams t3 ON t2.`vs_player_id` = t3.`vs_player_id` LEFT JOIN jmf_vs_teams t4 ON t3.`vs_team_id` = t4.`vs_team_id` WHERE t.`type` = 'red' AND t4.`vs_compt_id` = AND t2.`active` = 1 GROUP BY t2.`vs_player_id` ) as t1,(SELECT @rownum := 0) AS r
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 'AND ttt.vs_compt_id = AND t.active =1 ) AS matches ON t.`vs_match_id` = matches.' at line 1
SELECT CONCAT(@rownum:=@rownum+1,'.') as `rank`, t1.* FROM ( SELECT t2.`name` as `name`, t4.`short_name` as `team_name`, COUNT(*) as `cards` FROM jmf_vs_matches_events t INNER JOIN ( SELECT vs_match_id FROM jmf_vs_matches t LEFT JOIN jmf_vs_teams tt ON tt.vs_team_id = t.vs_team_a_id LEFT JOIN jmf_vs_teams ttt ON ttt.vs_team_id = t.vs_team_b_id WHERE tt.vs_compt_id = AND ttt.vs_compt_id = AND t.active =1 ) AS matches ON t.`vs_match_id` = matches.`vs_match_id` LEFT JOIN jmf_vs_players t2 ON t2.`vs_player_id` = t.`vs_player_id` LEFT JOIN jmf_vs_players_teams t3 ON t2.`vs_player_id` = t3.`vs_player_id` LEFT JOIN jmf_vs_teams t4 ON t3.`vs_team_id` = t4.`vs_team_id` WHERE t.`type` = 'red' AND t4.`vs_compt_id` = AND t2.`active` = 1 GROUP BY t2.`vs_player_id` ) as t1,(SELECT @rownum := 0) AS r ORDER BY cards DESC LIMIT 0, 1000
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 'AND ttt.vs_compt_id = AND t.active =1 ) AS matches ON t.`vs_match_id` = matches.' at line 1
