Menu
Anketa
Galerie
Kompletní los
Nebyly nalezeny žádné odpovídající položky.
Slavíme
90 let FC Moravský Krumlov
90 let FK Baník Ratíškovice
SELECT
t.vs_match_id as `match_id`,
players.name as `name`,
events.vs_event_id as `event_id`,
events.minute as `minute`,
teams.short_name as `short_name`,
events.type as `type`
FROM 0910_jmf_vs_matches t
LEFT JOIN 0910_jmf_vs_matches_events events ON events.vs_match_id = t.vs_match_id
LEFT JOIN 0910_jmf_vs_players players ON players.vs_player_id = events.vs_player_id
LEFT JOIN 0910_jmf_vs_players_teams team ON team.vs_player_id = players.vs_player_id
LEFT JOIN 0910_jmf_vs_teams teams ON teams.vs_team_id = team.vs_team_id
WHERE
teams.vs_compt_id = AND
t.`active`= 1 AND
(events.type = 'goal' OR events.type = 'own')
GROUP BY event_id
ORDER BY
t.date,
events.minute
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 t.`active`= 1 AND (events.type = 'goal' OR events.type = 'own') ' at line 14
File: /users/zalohovane/6293/jihomoravskyfotbal.cz/subdomeny/www/framework/class.database.php (Line: 104) Function: query File: /users/zalohovane/6293/jihomoravskyfotbal.cz/subdomeny/www/pages/results/table-matches/page.table-matches.php (Line: 71) Function: FetchAllToArray 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 round, DATE_FORMAT(date,'%d. %m. %Y %H:%i') as `date`, CONCAT(tt.name,' - ',ttt.name) as `match`, CONCAT(t.goals_a,':',t.goals_b,' (',t.half_a,':',t.half_b,')') as `result`, t.vs_match_id as `match_id` FROM 0910_jmf_vs_matches t LEFT JOIN 0910_jmf_vs_teams tt ON tt.vs_team_id = t.vs_team_a_id LEFT JOIN 0910_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
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' 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-matches/page.table-matches.php (Line: 74) 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 round, DATE_FORMAT(date,'%d. %m. %Y %H:%i') as `date`, CONCAT(tt.name,' - ',ttt.name) as `match`, CONCAT(t.goals_a,':',t.goals_b,' (',t.half_a,':',t.half_b,')') as `result`, t.vs_match_id as `match_id` FROM 0910_jmf_vs_matches t LEFT JOIN 0910_jmf_vs_teams tt ON tt.vs_team_id = t.vs_team_a_id LEFT JOIN 0910_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 ORDER BY round, date LIMIT 0, 10000
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 ORDER BY round, date LIMIT 0, 10000' 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-matches/page.table-matches.php (Line: 74) 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 Moravský Krumlov
90 let FK Baník Ratíškovice