Футбольная статистика

Фейенорд - Dinamo Tbilisi 4-0

Общая информация

Фейенорд   

4-0 (1-0)

   Dinamo Tbilisi

Турнир Лига Европы УЕФА
Дата 08.08.2019 20:30
Раунд 3-ий квалификационный раунд
Стадион Stadion Feijenoord (Rotterdam)
Зрителей 36500
Голы
Notice (8): Undefined variable: flag [APP/View/Football/match.ctp, line 135]
L. Sinisterra   42' 1 - 0
D. Kobouri (автогол)   81' 2 - 0
S. Berghuis (пен)   85' 3 - 0
L. Narsingh   87' 4 - 0
Составы
1.
17.
72'
11.
10.
23.
20.
77' 51'  
19.
2.
46'
5.
67'  
33.
6.

Замены
24.
35.
77'
R. Tapia
38.
46'
B. Nieuwkoop
15.
21.
8.
7.
72'
L. Sinisterra
1.
10.
46'
38.
86'
15.
8.
77' 28'  
19.
36'  
32.
5.
3.
16.
65'  
2.

Замены
11.
46' 76'  
L. Shengelia
12.
4.
14.
7.
6.
77'
G. Kukhianidze
9.
86'
N. Kavtaradze
Тренер
Арбитры
Главный S. Boyko
Ассистенты A. Skrypka
S. Shlonchak
4-ый V. Romanov
Статистика
5 Угловые 3
4 Удары в створ ворот 3
9 Удары мимо ворот 1
17 Фолы 14
1 Оффсайды 1
59 Владение мячом 41
Последние матчи
Дата Д/Г Т команда счет ПТ ВТ У Ж К
08.03.2020 Д Ч Виллем II 2 - 0 2-0 0-0 - 4-1 0-0
01.03.2020 Г Ч ПСВ 1 - 1 1-0 0-1 8-3 2-1 0-0
22.02.2020 Д Ч Fortuna Sittard 2 - 1 0-0 2-1 9-2 0-0 0-0
16.02.2020 Г Ч Зволле 4 - 3 1-2 3-1 5-2 2-2 0-0
01.02.2020 Д Ч Emmen 3 - 0 1-0 2-0 6-5 3-1 0-0
25.01.2020 Г Ч Хераклес 3 - 2 0-1 3-1 9-7 0-1 0-0
18.01.2020 Д Ч Херенвен 3 - 1 3-1 0-0 6-3 2-2 0-0
22.12.2019 Г Ч Утрехт 2 - 1 1-1 1-0 3-8 1-3 0-1
15.12.2019 Д Ч ПСВ 3 - 1 2-0 1-1 4-8 3-4 0-0
12.12.2019 Г ЛЕ Порто 2 - 3 2-3 0-0 5-5 2-3 0-0
08.12.2019 Г Ч Витесс 0 - 0 0-0 0-0 3-4 3-3 0-0
01.12.2019 Д Ч Зволле 1 - 0 1-0 0-0 7-5 0-0 0-0
28.11.2019 Д ЛЕ Рейнджерс 2 - 2 1-0 1-2 8-5 0-2 0-0
24.11.2019 Г Ч Гронинген 1 - 1 1-0 0-1 5-8 1-2 0-0
10.11.2019 Д Ч RKC Waalwijk 3 - 2 2-2 1-0 5-4 3-5 0-1
07.11.2019 Д ЛЕ Янг Бойз 1 - 1 1-0 0-1 5-5 4-3 0-0
03.11.2019 Г Ч VVV 3 - 0 2-0 1-0 5-2 1-2 0-1
27.10.2019 Г Ч Аякс 0 - 4 0-4 0-0 4-6 0-0 0-0
24.10.2019 Г ЛЕ Янг Бойз 0 - 2 0-2 0-0 9-8 5-1 0-0
20.10.2019 Д Ч Хераклес 1 - 1 1-0 0-1 7-6 3-3 0-0
Дата Д/Г Т команда счет ПТ ВТ У Ж К
15.08.2019 Д ЛЕ Фейенорд 1 - 1 0-0 1-1 3-4 4-2 0-0
08.08.2019 Г ЛЕ Фейенорд 0 - 4 0-1 0-3 3-5 4-2 0-0
01.08.2019 Д ЛЕ Qabala 3 - 0 0-0 3-0 11-3 1-2 0-0
25.07.2019 Г ЛЕ Qabala 2 - 0 1-0 1-0 2-2 5-6 0-0
18.07.2019 Г ЛЕ Engordany 1 - 0 0-0 1-0 4-3 0-2 0-0
11.07.2019 Д ЛЕ Engordany 6 - 0 2-0 4-0 4-2 2-5 0-0
31.10.2018 Д Ч Торпедо 0 - 1 0-1 0-0 - 3-3 0-0
18.08.2018 Д Ч Samtredia 0 - 0 0-0 0-0 - 2-2 0-0
12.08.2018 Г Ч Lokomotivi Tbilisi 4 - 2 3-0 1-2 - 2-0 0-0
03.08.2018 Д Ч Rustavi 2 - 1 2-0 0-1 - 1-2 0-0
19.07.2018 Д ЛЕ DAC 1 - 2 1-0 0-2 8-8 2-3 0-0
12.07.2018 Г ЛЕ DAC 1 - 1 1-1 0-0 1-10 1-1 0-0
05.07.2018 Д Ч Dila 5 - 0 4-0 1-0 - 0-2 0-1
29.06.2018 Г Ч Kolkheti Poti 6 - 3 - 6-3 - 0-0 0-0
23.06.2018 Д Ч Sioni 2 - 1 - 2-1 - 0-0 0-0
17.06.2018 Г Ч Saburtalo 0 - 1 - 0-1 - 0-0 0-0
10.06.2018 Д Ч Chikhura 1 - 0 - 1-0 - 0-0 0-0
25.05.2018 Г Ч Торпедо 1 - 1 - 1-1 - 0-0 0-0
19.05.2018 Г Ч Samtredia 2 - 1 - 2-1 - 0-0 0-0
13.05.2018 Д Ч Lokomotivi Tbilisi 0 - 1 - 0-1 - 0-0 0-0

(default) 21 queries took 37 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Country`.`code`, `Country`.`title_ru` FROM `user28770_football`.`countries` AS `Country` WHERE 1 = 12662660
2SELECT `Country`.`code`, `Country`.`code2`, `Country`.`title_ru`, `Country`.`title_en`, `Country`.`title_ru_full`, `Country`.`code_num`, `Country`.`code3` FROM `user28770_football`.`countries` AS `Country` WHERE 1 = 12662660
3SELECT `FootballMatch`.`id`, `FootballMatch`.`football_competition_id`, `FootballMatch`.`round`, `FootballMatch`.`team1_id`, `FootballMatch`.`team2_id`, `FootballMatch`.`score_titile`, `FootballMatch`.`score1`, `FootballMatch`.`score2`, `FootballMatch`.`half_score1`, `FootballMatch`.`half_score2`, `FootballMatch`.`external_main_id`, `FootballMatch`.`match_date`, `FootballMatch`.`stadium_id`, `FootballMatch`.`attendance`, `FootballMatch`.`main_referee_id`, `FootballMatch`.`assistant_referee1_id`, `FootballMatch`.`assistant_referee2_id`, `FootballMatch`.`fourth_referee_id`, `FootballMatch`.`corner1`, `FootballMatch`.`corner2`, `FootballMatch`.`shots_target1`, `FootballMatch`.`shots_target2`, `FootballMatch`.`shots_wide1`, `FootballMatch`.`shots_wide2`, `FootballMatch`.`fouls1`, `FootballMatch`.`fouls2`, `FootballMatch`.`offsides1`, `FootballMatch`.`offsides2`, `FootballMatch`.`ready`, `FootballMatch`.`extra_score1`, `FootballMatch`.`extra_score2`, `FootballMatch`.`penalty_score1`, `FootballMatch`.`penalty_score2`, `FootballMatch`.`possession1`, `FootballMatch`.`possession2`, `FootballMatch`.`elo_raring_1`, `FootballMatch`.`elo_raring_2`, `FootballMatch`.`date_updated`, `FootballMatch`.`date_created`, `FootballTeam1`.`id`, `FootballTeam1`.`title`, `FootballTeam1`.`title_ru`, `FootballTeam1`.`title_ru_parimatch`, `FootballTeam1`.`country`, `FootballTeam1`.`external_main_id`, `FootballTeam1`.`founded`, `FootballTeam1`.`address`, `FootballTeam1`.`img`, `FootballTeam1`.`date_updated`, `FootballTeam2`.`id`, `FootballTeam2`.`title`, `FootballTeam2`.`title_ru`, `FootballTeam2`.`title_ru_parimatch`, `FootballTeam2`.`country`, `FootballTeam2`.`external_main_id`, `FootballTeam2`.`founded`, `FootballTeam2`.`address`, `FootballTeam2`.`img`, `FootballTeam2`.`date_updated`, `FootballCompetition`.`id`, `FootballCompetition`.`title`, `FootballCompetition`.`title_ru`, `FootballCompetition`.`year_from`, `FootballCompetition`.`year_to`, `FootballCompetition`.`country`, `FootballCompetition`.`type`, `FootballCompetition`.`subtype`, `FootballCompetition`.`external_main_id`, `FootballCompetition`.`image`, `FootballCompetition`.`country_order`, `FootballCompetition`.`main_order`, `FootballCompetition`.`parent_id`, `FootballCompetition`.`child_order`, `FootballStadium`.`id`, `FootballStadium`.`title`, `FootballStadium`.`title_ru`, `FootballStadium`.`country`, `FootballMainReferee`.`id`, `FootballMainReferee`.`name`, `FootballMainReferee`.`name_ru`, `FootballMainReferee`.`external_main_id`, `FootballMainReferee`.`country`, `FootballAssistantReferee1`.`id`, `FootballAssistantReferee1`.`name`, `FootballAssistantReferee1`.`name_ru`, `FootballAssistantReferee1`.`external_main_id`, `FootballAssistantReferee1`.`country`, `FootballAssistantReferee2`.`id`, `FootballAssistantReferee2`.`name`, `FootballAssistantReferee2`.`name_ru`, `FootballAssistantReferee2`.`external_main_id`, `FootballAssistantReferee2`.`country`, `FootballFourthReferee`.`id`, `FootballFourthReferee`.`name`, `FootballFourthReferee`.`name_ru`, `FootballFourthReferee`.`external_main_id`, `FootballFourthReferee`.`country` FROM `user28770_football`.`football_matches` AS `FootballMatch` LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam1` ON (`FootballMatch`.`team1_id` = `FootballTeam1`.`id`) LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam2` ON (`FootballMatch`.`team2_id` = `FootballTeam2`.`id`) LEFT JOIN `user28770_football`.`football_competitions` AS `FootballCompetition` ON (`FootballMatch`.`football_competition_id` = `FootballCompetition`.`id`) LEFT JOIN `user28770_football`.`football_stadia` AS `FootballStadium` ON (`FootballMatch`.`stadium_id` = `FootballStadium`.`id`) LEFT JOIN `user28770_football`.`football_referees` AS `FootballMainReferee` ON (`FootballMatch`.`main_referee_id` = `FootballMainReferee`.`id`) LEFT JOIN `user28770_football`.`football_referees` AS `FootballAssistantReferee1` ON (`FootballMatch`.`assistant_referee1_id` = `FootballAssistantReferee1`.`id`) LEFT JOIN `user28770_football`.`football_referees` AS `FootballAssistantReferee2` ON (`FootballMatch`.`assistant_referee2_id` = `FootballAssistantReferee2`.`id`) LEFT JOIN `user28770_football`.`football_referees` AS `FootballFourthReferee` ON (`FootballMatch`.`fourth_referee_id` = `FootballFourthReferee`.`id`) WHERE `FootballMatch`.`id` = 104651 LIMIT 1111
4SELECT `FootballMatchCard`.`id`, `FootballMatchCard`.`football_match_id`, `FootballMatchCard`.`team_id`, `FootballMatchCard`.`player_id`, `FootballMatchCard`.`type`, `FootballMatchCard`.`minute`, `FootballMatchCard`.`extra_minute` FROM `user28770_football`.`football_match_cards` AS `FootballMatchCard` WHERE `FootballMatchCard`.`football_match_id` = (104651)661
5SELECT `FootballMatchGoal`.`id`, `FootballMatchGoal`.`football_match_id`, `FootballMatchGoal`.`team_id`, `FootballMatchGoal`.`player_id`, `FootballMatchGoal`.`assist_player_id`, `FootballMatchGoal`.`minute`, `FootballMatchGoal`.`extra_minute`, `FootballMatchGoal`.`penalty`, `FootballMatchGoal`.`autogoal` FROM `user28770_football`.`football_match_goals` AS `FootballMatchGoal` WHERE `FootballMatchGoal`.`football_match_id` = (104651) ORDER BY `FootballMatchGoal`.`minute` ASC, `FootballMatchGoal`.`extra_minute` ASC441
6SELECT `Video`.`id`, `Video`.`title`, `Video`.`title_ru`, `Video`.`url`, `Video`.`image`, `Video`.`country`, `Video`.`match_id`, `Video`.`date_created` FROM `user28770_football`.`videos` AS `Video` WHERE `Video`.`match_id` = (104651)0012
7SELECT `FootballCompetition`.`id`, `FootballCompetition`.`title`, `FootballCompetition`.`title_ru`, `FootballCompetition`.`year_from`, `FootballCompetition`.`year_to`, `FootballCompetition`.`country`, `FootballCompetition`.`type`, `FootballCompetition`.`subtype`, `FootballCompetition`.`external_main_id`, `FootballCompetition`.`image`, `FootballCompetition`.`country_order`, `FootballCompetition`.`main_order`, `FootballCompetition`.`parent_id`, `FootballCompetition`.`child_order` FROM `user28770_football`.`football_competitions` AS `FootballCompetition` WHERE `FootballCompetition`.`id` = 1043 LIMIT 1110
8SELECT `MatchKoeff`.`id`, `MatchKoeff`.`match_id`, `MatchKoeff`.`type`, `MatchKoeff`.`fora1`, `MatchKoeff`.`fora1_koeff`, `MatchKoeff`.`fora2`, `MatchKoeff`.`fora2_koeff`, `MatchKoeff`.`total`, `MatchKoeff`.`total_u_koeff`, `MatchKoeff`.`total_l_koeff`, `MatchKoeff`.`win1_koeff`, `MatchKoeff`.`draw_koeff`, `MatchKoeff`.`win2_koeff`, `MatchKoeff`.`1x_koeff`, `MatchKoeff`.`12_koeff`, `MatchKoeff`.`x2_koeff`, `MatchKoeff`.`total_team_1`, `MatchKoeff`.`total_team_1_u_koeff`, `MatchKoeff`.`total_team_1_l_koeff`, `MatchKoeff`.`total_team_2`, `MatchKoeff`.`total_team_2_u_koeff`, `MatchKoeff`.`total_team_2_l_koeff` FROM `user28770_football`.`match_koeffs` AS `MatchKoeff` WHERE `match_id` = 104651000
9SELECT `FootballMatchPlayer`.`id`, `FootballMatchPlayer`.`football_match_id`, `FootballMatchPlayer`.`team_id`, `FootballMatchPlayer`.`player_id`, `FootballMatchPlayer`.`shirtnumber`, `FootballMatchPlayer`.`main`, `FootballMatchPlayer`.`substitution_player_id`, `FootballMatchPlayer`.`substitution_minute`, `FootballMatchPlayer`.`extra_substitution_minute` FROM `user28770_football`.`football_match_players` AS `FootballMatchPlayer` WHERE `FootballMatchPlayer`.`football_match_id` = 104651 AND `FootballMatchPlayer`.`team_id` = 274 ORDER BY `main` desc18182
10SELECT `FootballMatchPlayer`.`id`, `FootballMatchPlayer`.`football_match_id`, `FootballMatchPlayer`.`team_id`, `FootballMatchPlayer`.`player_id`, `FootballMatchPlayer`.`shirtnumber`, `FootballMatchPlayer`.`main`, `FootballMatchPlayer`.`substitution_player_id`, `FootballMatchPlayer`.`substitution_minute`, `FootballMatchPlayer`.`extra_substitution_minute` FROM `user28770_football`.`football_match_players` AS `FootballMatchPlayer` WHERE `FootballMatchPlayer`.`football_match_id` = 104651 AND `FootballMatchPlayer`.`team_id` = 702 ORDER BY `main` desc18181
11SELECT * FROM `user28770_football`.`football_match_coaches` AS `FootballMatchCoach` LEFT JOIN `user28770_football`.`football_coaches` AS `FootballCoach` ON (`FootballMatchCoach`.`coach_id` = `FootballCoach`.`id`) LEFT JOIN `user28770_football`.`countries` AS `Country` ON (`FootballCoach`.`country` = `Country`.`code`) WHERE `FootballMatchCoach`.`football_match_id` = 104651 AND `FootballMatchCoach`.`team_id` = 274 LIMIT 1111
12SELECT * FROM `user28770_football`.`football_match_coaches` AS `FootballMatchCoach` LEFT JOIN `user28770_football`.`football_coaches` AS `FootballCoach` ON (`FootballMatchCoach`.`coach_id` = `FootballCoach`.`id`) LEFT JOIN `user28770_football`.`countries` AS `Country` ON (`FootballCoach`.`country` = `Country`.`code`) WHERE `FootballMatchCoach`.`football_match_id` = 104651 AND `FootballMatchCoach`.`team_id` = 702 LIMIT 1111
13SELECT * FROM `user28770_football`.`football_match_players` AS `FootballMatchPlayer` LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballMatchPlayer`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballSubstitutionPlayer` ON (`FootballMatchPlayer`.`substitution_player_id` = `FootballSubstitutionPlayer`.`id`) LEFT JOIN `user28770_football`.`countries` AS `Country` ON (`FootballPlayer`.`country` = `Country`.`code`) WHERE `FootballMatchPlayer`.`football_match_id` = 10465136365
14SELECT `FootballMatch`.`id`, `FootballMatch`.`football_competition_id`, `FootballMatch`.`round`, `FootballMatch`.`team1_id`, `FootballMatch`.`team2_id`, `FootballMatch`.`score_titile`, `FootballMatch`.`score1`, `FootballMatch`.`score2`, `FootballMatch`.`half_score1`, `FootballMatch`.`half_score2`, `FootballMatch`.`external_main_id`, `FootballMatch`.`match_date`, `FootballMatch`.`stadium_id`, `FootballMatch`.`attendance`, `FootballMatch`.`main_referee_id`, `FootballMatch`.`assistant_referee1_id`, `FootballMatch`.`assistant_referee2_id`, `FootballMatch`.`fourth_referee_id`, `FootballMatch`.`corner1`, `FootballMatch`.`corner2`, `FootballMatch`.`shots_target1`, `FootballMatch`.`shots_target2`, `FootballMatch`.`shots_wide1`, `FootballMatch`.`shots_wide2`, `FootballMatch`.`fouls1`, `FootballMatch`.`fouls2`, `FootballMatch`.`offsides1`, `FootballMatch`.`offsides2`, `FootballMatch`.`ready`, `FootballMatch`.`extra_score1`, `FootballMatch`.`extra_score2`, `FootballMatch`.`penalty_score1`, `FootballMatch`.`penalty_score2`, `FootballMatch`.`possession1`, `FootballMatch`.`possession2`, `FootballMatch`.`elo_raring_1`, `FootballMatch`.`elo_raring_2`, `FootballMatch`.`date_updated`, `FootballMatch`.`date_created`, `FootballTeam1`.`id`, `FootballTeam1`.`title`, `FootballTeam1`.`title_ru`, `FootballTeam1`.`title_ru_parimatch`, `FootballTeam1`.`country`, `FootballTeam1`.`external_main_id`, `FootballTeam1`.`founded`, `FootballTeam1`.`address`, `FootballTeam1`.`img`, `FootballTeam1`.`date_updated`, `FootballTeam2`.`id`, `FootballTeam2`.`title`, `FootballTeam2`.`title_ru`, `FootballTeam2`.`title_ru_parimatch`, `FootballTeam2`.`country`, `FootballTeam2`.`external_main_id`, `FootballTeam2`.`founded`, `FootballTeam2`.`address`, `FootballTeam2`.`img`, `FootballTeam2`.`date_updated`, `FootballCompetition`.`id`, `FootballCompetition`.`title`, `FootballCompetition`.`title_ru`, `FootballCompetition`.`year_from`, `FootballCompetition`.`year_to`, `FootballCompetition`.`country`, `FootballCompetition`.`type`, `FootballCompetition`.`subtype`, `FootballCompetition`.`external_main_id`, `FootballCompetition`.`image`, `FootballCompetition`.`country_order`, `FootballCompetition`.`main_order`, `FootballCompetition`.`parent_id`, `FootballCompetition`.`child_order` FROM `user28770_football`.`football_matches` AS `FootballMatch` LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam1` ON (`FootballMatch`.`team1_id` = `FootballTeam1`.`id`) LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam2` ON (`FootballMatch`.`team2_id` = `FootballTeam2`.`id`) LEFT JOIN `user28770_football`.`football_competitions` AS `FootballCompetition` ON (`FootballMatch`.`football_competition_id` = `FootballCompetition`.`id`) WHERE `ready` = 1 AND ((`FootballMatch`.`team1_id` = 274) OR (`FootballMatch`.`team2_id` = 274)) ORDER BY `match_date` desc LIMIT 2020200
15SELECT `FootballMatchCard`.`id`, `FootballMatchCard`.`football_match_id`, `FootballMatchCard`.`team_id`, `FootballMatchCard`.`player_id`, `FootballMatchCard`.`type`, `FootballMatchCard`.`minute`, `FootballMatchCard`.`extra_minute` FROM `user28770_football`.`football_match_cards` AS `FootballMatchCard` WHERE `FootballMatchCard`.`football_match_id` IN (103655, 103645, 103633, 103629, 103605, 103597, 103587, 103582, 103573, 106289, 103563, 103554, 106142, 103545, 103539, 106287, 103528, 103521, 106286, 103509)81810
16SELECT `Video`.`id`, `Video`.`title`, `Video`.`title_ru`, `Video`.`url`, `Video`.`image`, `Video`.`country`, `Video`.`match_id`, `Video`.`date_created` FROM `user28770_football`.`videos` AS `Video` WHERE `Video`.`match_id` IN (103655, 103645, 103633, 103629, 103605, 103597, 103587, 103582, 103573, 106289, 103563, 103554, 106142, 103545, 103539, 106287, 103528, 103521, 106286, 103509)550
17SELECT `FootballMatch`.`id`, `FootballMatch`.`football_competition_id`, `FootballMatch`.`round`, `FootballMatch`.`team1_id`, `FootballMatch`.`team2_id`, `FootballMatch`.`score_titile`, `FootballMatch`.`score1`, `FootballMatch`.`score2`, `FootballMatch`.`half_score1`, `FootballMatch`.`half_score2`, `FootballMatch`.`external_main_id`, `FootballMatch`.`match_date`, `FootballMatch`.`stadium_id`, `FootballMatch`.`attendance`, `FootballMatch`.`main_referee_id`, `FootballMatch`.`assistant_referee1_id`, `FootballMatch`.`assistant_referee2_id`, `FootballMatch`.`fourth_referee_id`, `FootballMatch`.`corner1`, `FootballMatch`.`corner2`, `FootballMatch`.`shots_target1`, `FootballMatch`.`shots_target2`, `FootballMatch`.`shots_wide1`, `FootballMatch`.`shots_wide2`, `FootballMatch`.`fouls1`, `FootballMatch`.`fouls2`, `FootballMatch`.`offsides1`, `FootballMatch`.`offsides2`, `FootballMatch`.`ready`, `FootballMatch`.`extra_score1`, `FootballMatch`.`extra_score2`, `FootballMatch`.`penalty_score1`, `FootballMatch`.`penalty_score2`, `FootballMatch`.`possession1`, `FootballMatch`.`possession2`, `FootballMatch`.`elo_raring_1`, `FootballMatch`.`elo_raring_2`, `FootballMatch`.`date_updated`, `FootballMatch`.`date_created`, `FootballTeam1`.`id`, `FootballTeam1`.`title`, `FootballTeam1`.`title_ru`, `FootballTeam1`.`title_ru_parimatch`, `FootballTeam1`.`country`, `FootballTeam1`.`external_main_id`, `FootballTeam1`.`founded`, `FootballTeam1`.`address`, `FootballTeam1`.`img`, `FootballTeam1`.`date_updated`, `FootballTeam2`.`id`, `FootballTeam2`.`title`, `FootballTeam2`.`title_ru`, `FootballTeam2`.`title_ru_parimatch`, `FootballTeam2`.`country`, `FootballTeam2`.`external_main_id`, `FootballTeam2`.`founded`, `FootballTeam2`.`address`, `FootballTeam2`.`img`, `FootballTeam2`.`date_updated`, `FootballCompetition`.`id`, `FootballCompetition`.`title`, `FootballCompetition`.`title_ru`, `FootballCompetition`.`year_from`, `FootballCompetition`.`year_to`, `FootballCompetition`.`country`, `FootballCompetition`.`type`, `FootballCompetition`.`subtype`, `FootballCompetition`.`external_main_id`, `FootballCompetition`.`image`, `FootballCompetition`.`country_order`, `FootballCompetition`.`main_order`, `FootballCompetition`.`parent_id`, `FootballCompetition`.`child_order` FROM `user28770_football`.`football_matches` AS `FootballMatch` LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam1` ON (`FootballMatch`.`team1_id` = `FootballTeam1`.`id`) LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam2` ON (`FootballMatch`.`team2_id` = `FootballTeam2`.`id`) LEFT JOIN `user28770_football`.`football_competitions` AS `FootballCompetition` ON (`FootballMatch`.`football_competition_id` = `FootballCompetition`.`id`) WHERE `ready` = 1 AND ((`FootballMatch`.`team1_id` = 702) OR (`FootballMatch`.`team2_id` = 702)) ORDER BY `match_date` desc LIMIT 2020200
18SELECT `FootballMatchCard`.`id`, `FootballMatchCard`.`football_match_id`, `FootballMatchCard`.`team_id`, `FootballMatchCard`.`player_id`, `FootballMatchCard`.`type`, `FootballMatchCard`.`minute`, `FootballMatchCard`.`extra_minute` FROM `user28770_football`.`football_match_cards` AS `FootballMatchCard` WHERE `FootballMatchCard`.`football_match_id` IN (104652, 104651, 104530, 104529, 102565, 102563, 86997, 86993, 86988, 86981, 78265, 78264, 86978, 86972, 86967, 86962, 86958, 86951, 86944, 86943)60600
19SELECT `Video`.`id`, `Video`.`title`, `Video`.`title_ru`, `Video`.`url`, `Video`.`image`, `Video`.`country`, `Video`.`match_id`, `Video`.`date_created` FROM `user28770_football`.`videos` AS `Video` WHERE `Video`.`match_id` IN (104652, 104651, 104530, 104529, 102565, 102563, 86997, 86993, 86988, 86981, 78265, 78264, 86978, 86972, 86967, 86962, 86958, 86951, 86944, 86943)000
20SELECT `Country`.`code`, `Country`.`title_ru` FROM `user28770_football`.`countries` AS `Country` WHERE 1 = 12662660
21SELECT `Video`.`id`, `Video`.`title`, `Video`.`title_ru`, `Video`.`url`, `Video`.`image`, `Video`.`country`, `Video`.`match_id`, `Video`.`date_created` FROM `user28770_football`.`videos` AS `Video` WHERE `match_id` = 104651 LIMIT 10012