Menu
Anketa
Galerie
Červené karty
Nebyly nalezeny žádné odpovídající položky.
Slavíme
90 let FC Veselí n.M.
90 let Slavoj Rohatec
90 let Slovan Bzenec
90 let FC Veverská Bítýška
60 let Viktoria Želešice
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
File: /users/zalohovane/6293/jihomoravskyfotbal.cz/subdomeny/www/framework/modules/list/module.list.php (Line: 180) Function: query File: /users/zalohovane/6293/jihomoravskyfotbal.cz/subdomeny/www/framework/modules/list/module.list.php (Line: 81) Function: GetAjax File: /users/zalohovane/6293/jihomoravskyfotbal.cz/subdomeny/www/pages/results/table-redcards/page.table-redcards.php (Line: 59) Function: GetHTML File: /users/zalohovane/6293/jihomoravskyfotbal.cz/subdomeny/www/framework/class.presentation.php (Line: 56) Function: GetHTML File: /users/zalohovane/6293/jihomoravskyfotbal.cz/subdomeny/www/index.php (Line: 257) Function: GetHTML
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
File: /users/zalohovane/6293/jihomoravskyfotbal.cz/subdomeny/www/framework/class.database.php (Line: 91) Function: query File: /users/zalohovane/6293/jihomoravskyfotbal.cz/subdomeny/www/framework/modules/list/module.list.php (Line: 214) Function: TestQuery File: /users/zalohovane/6293/jihomoravskyfotbal.cz/subdomeny/www/framework/modules/list/module.list.php (Line: 81) Function: GetAjax File: /users/zalohovane/6293/jihomoravskyfotbal.cz/subdomeny/www/pages/results/table-redcards/page.table-redcards.php (Line: 59) Function: GetHTML File: /users/zalohovane/6293/jihomoravskyfotbal.cz/subdomeny/www/framework/class.presentation.php (Line: 56) Function: GetHTML File: /users/zalohovane/6293/jihomoravskyfotbal.cz/subdomeny/www/index.php (Line: 257) Function: GetHTML
Nebyly nalezeny žádné odpovídající položky.
90 let FC Veselí n.M.
90 let Slavoj Rohatec
90 let Slovan Bzenec
90 let FC Veverská Bítýška
60 let Viktoria Želešice