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
| Kdo podle vás vyhraje KP? | Celkem hlasů: 103 |
|---|---|
| Boskovice | 34 |
|
33%
|
|
| Mutěnice | 3 |
|
2.9%
|
|
| Start Brno | 39 |
|
37.9%
|
|
| Sparta Brno | 17 |
|
16.5%
|
|
| někdo jiný | 10 |
|
9.7%
|
|
Nebyly nalezeny žádné odpovídající položky.
