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

Хетафе - Бетис 2-0

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

Хетафе   

2-0 (0-0)

   Бетис

Турнир Примера
Дата 28.10.2018 14:00
Тур 10
Стадион Coliseum Alfonso Pérez (Getafe)
Зрителей 12086
Голы
Notice (8): Undefined variable: flag [APP/View/Football/match.ctp, line 135]
Jorge Molina   60'  (Ángel) 1 - 0
D. Foulquier   62'  (M. Arambarri) 2 - 0
Составы
13.
11.
84'
19.
90'
9.
71'
18.
20.
2.
24.
6.
22.
38'  
3.

Замены
15.
84'
A. Diedhiou
10.
1.
4.
7.
71'
Ángel
23.
Ivi
17.
90'
Jorge Molina
1.
16.
9.
21.
49'  
14.
10.
61'
20.
5.
23.
12.
71'
19.
90+2'  

Замены
11.
71'
Sidnei
6.
61'
R. Boudebouz
37.
13.
34.
8.
4.
Арбитры
Главный Santiago Jaime
Ассистенты Jorge Bueno
Fernando Tresaco
4-ый Marcos Latorre
Статистика
5 Угловые 4
4 Удары в створ ворот 5
4 Удары мимо ворот 3
9 Фолы 14
5 Оффсайды 2
41 Владение мячом 59
Коэффициенты
Фора КФ Т Б М П1 X П2 1X 12 X2 Б М
Хетафе
Бетис
0
0
1.7
2.23
2 2.02 1.85 2.48 3.05 3.3 1.36 1.41 1.58 1
1
1.92
2.39
1.88
1.58
Последние матчи
Дата Д/Г Т команда счет ПТ ВТ У Ж К
07.03.2020 Д Ч Сельта 0 - 0 0-0 0-0 - 5-5 1-0
01.03.2020 Г Ч Мальорка 1 - 0 0-0 1-0 3-4 5-3 0-1
27.02.2020 Г ЛЕ Аякс 1 - 2 1-1 0-1 4-5 5-5 0-0
23.02.2020 Д Ч Севилья 0 - 3 0-1 0-2 5-3 7-4 0-0
20.02.2020 Д ЛЕ Аякс 2 - 0 1-0 1-0 5-3 4-3 0-0
15.02.2020 Г Ч Барселона 1 - 2 0-2 1-0 3-2 2-3 0-0
08.02.2020 Д Ч Валенсия 3 - 0 0-0 3-0 10-0 4-5 0-1
02.02.2020 Г Ч Атлетик 2 - 0 1-0 1-0 4-5 6-2 0-0
26.01.2020 Д Ч Бетис 1 - 0 0-0 1-0 8-4 2-5 0-1
17.01.2020 Г Ч Леганьес 3 - 0 3-0 0-0 4-4 4-6 0-0
11.01.2020 Г К Badalona 0 - 2 0-0 0-2 - 3-2 1-0
04.01.2020 Д Ч Реал М 0 - 3 0-1 0-2 7-4 3-2 0-0
21.12.2019 Г Ч Вильяреал 0 - 1 0-0 0-1 5-2 4-2 0-0
18.12.2019 Г К El Palmar 2 - 1 0-1 2-0 - 2-2 0-0
15.12.2019 Д Ч Вальядолид 2 - 0 1-0 1-0 4-3 3-3 0-0
12.12.2019 Д ЛЕ Краснодар 3 - 0 0-0 3-0 5-5 1-3 0-1
08.12.2019 Г Ч Эйбар 1 - 0 0-0 1-0 8-3 1-5 0-1
01.12.2019 Д Ч Леванте 4 - 0 0-0 4-0 6-7 2-3 0-0
28.11.2019 Г ЛЕ Трабзонспор 1 - 0 0-0 1-0 2-5 3-2 0-0
24.11.2019 Г Ч Эспаньол 1 - 1 1-1 0-0 3-3 4-3 0-0
Дата Д/Г Т команда счет ПТ ВТ У Ж К
08.03.2020 Д Ч Реал М 2 - 1 1-1 1-0 - 1-1 0-0
29.02.2020 Г Ч Валенсия 1 - 2 0-0 1-2 7-6 3-2 0-0
21.02.2020 Д Ч Мальорка 3 - 3 2-2 1-1 7-1 2-1 0-0
16.02.2020 Г Ч Леганьес 0 - 0 0-0 0-0 2-4 3-5 1-0
09.02.2020 Д Ч Барселона 2 - 3 2-2 0-1 0-8 4-4 1-1
02.02.2020 Г Ч Эйбар 1 - 1 1-1 0-0 7-2 2-2 0-0
26.01.2020 Г Ч Хетафе 0 - 1 0-0 0-1 4-8 5-2 1-0
23.01.2020 Г К Райо Вальекано 2 - 2 0-0 2-2 - 4-6 0-0
19.01.2020 Д Ч Реал Сосьедад 3 - 0 2-0 1-0 6-2 3-1 0-0
11.01.2020 Г К Portugalete 3 - 0 1-0 2-0 - 1-3 0-0
05.01.2020 Г Ч Алавес 1 - 1 0-1 1-0 6-3 4-7 1-0
22.12.2019 Д Ч Атлетико М 1 - 2 0-0 1-2 5-3 4-3 0-0
19.12.2019 Г К Antoniano 4 - 0 2-0 2-0 - 1-3 0-0
15.12.2019 Г Ч Эспаньол 2 - 2 1-2 1-0 5-7 1-4 0-0
08.12.2019 Д Ч Атлетик 3 - 2 3-1 0-1 3-3 2-4 0-0
30.11.2019 Г Ч Мальорка 2 - 1 2-0 0-1 5-6 4-2 0-1
23.11.2019 Д Ч Валенсия 2 - 1 1-1 1-0 5-4 2-2 0-0
10.11.2019 Д Ч Севилья 1 - 2 1-1 0-1 4-4 2-3 0-0
02.11.2019 Г Ч Реал М 0 - 0 0-0 0-0 4-9 4-2 0-0
30.10.2019 Д Ч Сельта 2 - 1 1-0 1-1 5-10 6-1 0-0

(default) 20 queries took 43 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` = 90595 LIMIT 1114
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` = (90595)331
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` = (90595) ORDER BY `FootballMatchGoal`.`minute` ASC, `FootballMatchGoal`.`extra_minute` ASC221
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` = (90595)1115
7SELECT `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` = 90595111
8SELECT `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` = 90595 AND `FootballMatchPlayer`.`team_id` = 106 ORDER BY `main` desc18183
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` = 90595 AND `FootballMatchPlayer`.`team_id` = 107 ORDER BY `main` desc18182
10SELECT * 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` = 90595 AND `FootballMatchCoach`.`team_id` = 106 LIMIT 1111
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` = 90595 AND `FootballMatchCoach`.`team_id` = 107 LIMIT 1111
12SELECT * 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` = 9059536367
13SELECT `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` = 106) OR (`FootballMatch`.`team2_id` = 106)) ORDER BY `match_date` desc LIMIT 2020200
14SELECT `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 (100569, 100559, 107935, 100549, 107934, 100535, 100529, 100514, 100508, 100498, 107625, 100488, 100482, 107522, 100469, 106262, 100456, 100449, 106260, 100436)1451450
15SELECT `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 (100569, 100559, 107935, 100549, 107934, 100535, 100529, 100514, 100508, 100498, 107625, 100488, 100482, 107522, 100469, 106262, 100456, 100449, 106260, 100436)21210
16SELECT `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` = 107) OR (`FootballMatch`.`team2_id` = 107)) ORDER BY `match_date` desc LIMIT 2020200
17SELECT `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 (100567, 100563, 100547, 100538, 100526, 100516, 100508, 107686, 100496, 107619, 100484, 100475, 107534, 100468, 100455, 100450, 100434, 100428, 100420, 100407)1221220
18SELECT `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 (100567, 100563, 100547, 100538, 100526, 100516, 100508, 107686, 100496, 107619, 100484, 100475, 107534, 100468, 100455, 100450, 100434, 100428, 100420, 100407)20200
19SELECT `Country`.`code`, `Country`.`title_ru` FROM `user28770_football`.`countries` AS `Country` WHERE 1 = 12662660
20SELECT `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` = 90595 LIMIT 1117