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

Атлетико М - Эйбар 2-2

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

Атлетико М   

2-2 (1-1)

   Эйбар

Турнир Примера
Дата 20.05.2018 19:30
Тур 38
Стадион Estadio Wanda Metropolitano (Madrid)
Зрителей 63229
Голы
0 - 1 Kike   35'  (Joan Jordán)
Fernando Torres   42'  (Á. Correa) 1 - 1
Fernando Torres   60'  (Diego Costa) 2 - 1
2 - 2 Rubén Peña   70'
Составы
13.
11.
59'
9.
61'  
6.
59'
8.
23.
66'
14.
19.
8'   63'  
15.
83'  
3.
22'  
20.

Замены
24.
66'
Vitolo
21.
18.
59' 71'  
Á. Correa
7.
59'
Koke
5.
2.
25.
25.
17.
90+3'
20.
Ivi
78'
24.
11.
5.
14.
56'  
2.
12.
15.
22.
66' 65'  

Замены
41.
90+3'
Kike
19.
78'
Ivi
18.
66'
Lombán
9.
7.
1.
4.
Тренер
Арбитры
Главный Alfonso Álvarez
Ассистенты Juan Barranco
Joan Méndez
4-ый Antonio Santos
Статистика
2 Угловые 2
2 Удары в створ ворот 4
4 Удары мимо ворот 7
14 Фолы 14
5 Оффсайды 0
45 Владение мячом 55
Последние матчи
Дата Д/Г Т команда счет ПТ ВТ У Ж К
18.09.2018 Г ЛЧ Монако 2 - 1 2-1 0-0 6-4 2-3 0-0
15.09.2018 Д Ч Эйбар 1 - 1 0-0 1-1 14-3 2-2 0-0
01.09.2018 Г Ч Сельта 0 - 2 0-0 0-2 8-2 4-4 1-0
25.08.2018 Д Ч Райо Вальекано 1 - 0 0-0 1-0 8-5 1-1 0-0
20.08.2018 Г Ч Валенсия 1 - 1 1-0 0-1 10-4 3-2 0-0
20.05.2018 Д Ч Эйбар 2 - 2 1-1 1-1 2-2 5-2 1-0
16.05.2018 Г ЛЕ Марсель 3 - 0 1-0 2-0 6-1 2-3 0-0
12.05.2018 Г Ч Хетафе 1 - 0 1-0 0-0 2-8 2-3 0-0
06.05.2018 Д Ч Эспаньол 0 - 2 0-0 0-2 6-3 1-3 0-0
03.05.2018 Д ЛЕ Арсенал 1 - 0 1-0 0-0 6-4 3-3 0-0
29.04.2018 Г Ч Алавес 1 - 0 0-0 1-0 4-3 5-6 1-0
26.04.2018 Г ЛЕ Арсенал 1 - 1 0-0 1-1 0-11 1-0 1-0
22.04.2018 Д Ч Бетис 0 - 0 0-0 0-0 8-3 2-5 0-0
19.04.2018 Г Ч Реал Сосьедад 0 - 3 0-1 0-2 6-6 0-1 0-0
15.04.2018 Д Ч Леванте 3 - 0 1-0 2-0 8-3 2-1 0-0
12.04.2018 Г ЛЕ Спортинг 0 - 1 0-1 0-0 2-10 2-4 0-0
08.04.2018 Г Ч Реал М 1 - 1 0-0 1-1 2-11 3-2 0-0
05.04.2018 Д ЛЕ Спортинг 2 - 0 2-0 0-0 8-3 3-3 0-0
01.04.2018 Д Ч Депортиво 1 - 0 1-0 0-0 9-7 2-3 0-0
18.03.2018 Г Ч Вильяреал 1 - 2 1-0 0-2 4-5 3-6 1-0
Дата Д/Г Т команда счет ПТ ВТ У Ж К
15.09.2018 Г Ч Атлетико М 1 - 1 0-0 1-1 3-14 2-2 0-0
31.08.2018 Д Ч Реал Сосьедад 2 - 1 1-1 1-0 4-2 3-2 0-0
24.08.2018 Г Ч Хетафе 0 - 2 0-1 0-1 5-5 1-2 0-0
19.08.2018 Д Ч Хуеска 1 - 2 0-2 1-0 7-0 1-1 0-0
20.05.2018 Г Ч Атлетико М 2 - 2 1-1 1-1 2-2 2-5 0-1
12.05.2018 Д Ч Лас Пальмас 1 - 0 1-0 0-0 3-11 3-1 0-0
05.05.2018 Г Ч Жирона 4 - 1 2-0 2-1 5-6 5-2 0-0
29.04.2018 Г Ч Валенсия 0 - 0 0-0 0-0 2-8 3-2 0-0
21.04.2018 Д Ч Хетафе 0 - 1 0-1 0-0 8-3 4-1 0-0
18.04.2018 Г Ч Эспаньол 1 - 0 1-0 0-0 6-3 2-3 0-0
15.04.2018 Д Ч Алавес 0 - 1 0-1 0-0 12-1 2-1 0-0
07.04.2018 Г Ч Бетис 0 - 2 0-1 0-1 8-7 2-2 0-0
01.04.2018 Д Ч Реал Сосьедад 0 - 0 0-0 0-0 8-1 4-2 0-0
16.03.2018 Г Ч Леванте 1 - 2 0-1 1-1 5-4 3-4 0-0
10.03.2018 Д Ч Реал М 1 - 2 0-1 1-1 8-6 1-1 0-0
03.03.2018 Г Ч Депортиво 1 - 1 1-1 0-0 9-2 2-1 0-1
28.02.2018 Д Ч Вильяреал 1 - 0 1-0 0-0 6-4 4-2 0-0
24.02.2018 Г Ч Сельта 0 - 2 0-0 0-2 9-3 3-2 0-0
17.02.2018 Д Ч Барселона 0 - 2 0-1 0-1 6-0 2-1 1-0
10.02.2018 Г Ч Леганьес 1 - 0 0-0 1-0 10-1 2-3 0-1

(default) 20 queries took 179 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Country`.`code`, `Country`.`title_ru` FROM `user9368_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 `user9368_football`.`countries` AS `Country` WHERE 1 = 12662666
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`.`date_updated`, `FootballMatch`.`date_created`, `FootballTeam1`.`id`, `FootballTeam1`.`title`, `FootballTeam1`.`title_ru`, `FootballTeam1`.`country`, `FootballTeam1`.`external_main_id`, `FootballTeam1`.`founded`, `FootballTeam1`.`address`, `FootballTeam1`.`img`, `FootballTeam1`.`date_updated`, `FootballTeam2`.`id`, `FootballTeam2`.`title`, `FootballTeam2`.`title_ru`, `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 `user9368_football`.`football_matches` AS `FootballMatch` LEFT JOIN `user9368_football`.`football_teams` AS `FootballTeam1` ON (`FootballMatch`.`team1_id` = `FootballTeam1`.`id`) LEFT JOIN `user9368_football`.`football_teams` AS `FootballTeam2` ON (`FootballMatch`.`team2_id` = `FootballTeam2`.`id`) LEFT JOIN `user9368_football`.`football_competitions` AS `FootballCompetition` ON (`FootballMatch`.`football_competition_id` = `FootballCompetition`.`id`) LEFT JOIN `user9368_football`.`football_stadia` AS `FootballStadium` ON (`FootballMatch`.`stadium_id` = `FootballStadium`.`id`) LEFT JOIN `user9368_football`.`football_referees` AS `FootballMainReferee` ON (`FootballMatch`.`main_referee_id` = `FootballMainReferee`.`id`) LEFT JOIN `user9368_football`.`football_referees` AS `FootballAssistantReferee1` ON (`FootballMatch`.`assistant_referee1_id` = `FootballAssistantReferee1`.`id`) LEFT JOIN `user9368_football`.`football_referees` AS `FootballAssistantReferee2` ON (`FootballMatch`.`assistant_referee2_id` = `FootballAssistantReferee2`.`id`) LEFT JOIN `user9368_football`.`football_referees` AS `FootballFourthReferee` ON (`FootballMatch`.`fourth_referee_id` = `FootballFourthReferee`.`id`) WHERE `FootballMatch`.`id` = 73802 LIMIT 1115
4SELECT `FootballMatchCard`.`id`, `FootballMatchCard`.`football_match_id`, `FootballMatchCard`.`team_id`, `FootballMatchCard`.`player_id`, `FootballMatchCard`.`type`, `FootballMatchCard`.`minute`, `FootballMatchCard`.`extra_minute` FROM `user9368_football`.`football_match_cards` AS `FootballMatchCard` WHERE `FootballMatchCard`.`football_match_id` = (73802)885
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 `user9368_football`.`football_match_goals` AS `FootballMatchGoal` WHERE `FootballMatchGoal`.`football_match_id` = (73802) ORDER BY `FootballMatchGoal`.`minute` ASC, `FootballMatchGoal`.`extra_minute` ASC442
6SELECT `Video`.`id`, `Video`.`title`, `Video`.`title_ru`, `Video`.`url`, `Video`.`image`, `Video`.`country`, `Video`.`match_id`, `Video`.`date_created` FROM `user9368_football`.`videos` AS `Video` WHERE `Video`.`match_id` = (73802)006
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 `user9368_football`.`match_koeffs` AS `MatchKoeff` WHERE `match_id` = 73802001
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 `user9368_football`.`football_match_players` AS `FootballMatchPlayer` WHERE `FootballMatchPlayer`.`football_match_id` = 73802 AND `FootballMatchPlayer`.`team_id` = 97 ORDER BY `main` desc18186
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 `user9368_football`.`football_match_players` AS `FootballMatchPlayer` WHERE `FootballMatchPlayer`.`football_match_id` = 73802 AND `FootballMatchPlayer`.`team_id` = 104 ORDER BY `main` desc18187
10SELECT * FROM `user9368_football`.`football_match_coaches` AS `FootballMatchCoach` LEFT JOIN `user9368_football`.`football_coaches` AS `FootballCoach` ON (`FootballMatchCoach`.`coach_id` = `FootballCoach`.`id`) LEFT JOIN `user9368_football`.`countries` AS `Country` ON (`FootballCoach`.`country` = `Country`.`code`) WHERE `FootballMatchCoach`.`football_match_id` = 73802 AND `FootballMatchCoach`.`team_id` = 97 LIMIT 1111
11SELECT * FROM `user9368_football`.`football_match_coaches` AS `FootballMatchCoach` LEFT JOIN `user9368_football`.`football_coaches` AS `FootballCoach` ON (`FootballMatchCoach`.`coach_id` = `FootballCoach`.`id`) LEFT JOIN `user9368_football`.`countries` AS `Country` ON (`FootballCoach`.`country` = `Country`.`code`) WHERE `FootballMatchCoach`.`football_match_id` = 73802 AND `FootballMatchCoach`.`team_id` = 104 LIMIT 1114
12SELECT * FROM `user9368_football`.`football_match_players` AS `FootballMatchPlayer` LEFT JOIN `user9368_football`.`football_players` AS `FootballPlayer` ON (`FootballMatchPlayer`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user9368_football`.`football_players` AS `FootballSubstitutionPlayer` ON (`FootballMatchPlayer`.`substitution_player_id` = `FootballSubstitutionPlayer`.`id`) LEFT JOIN `user9368_football`.`countries` AS `Country` ON (`FootballPlayer`.`country` = `Country`.`code`) WHERE `FootballMatchPlayer`.`football_match_id` = 73802363613
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`.`date_updated`, `FootballMatch`.`date_created`, `FootballTeam1`.`id`, `FootballTeam1`.`title`, `FootballTeam1`.`title_ru`, `FootballTeam1`.`country`, `FootballTeam1`.`external_main_id`, `FootballTeam1`.`founded`, `FootballTeam1`.`address`, `FootballTeam1`.`img`, `FootballTeam1`.`date_updated`, `FootballTeam2`.`id`, `FootballTeam2`.`title`, `FootballTeam2`.`title_ru`, `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 `user9368_football`.`football_matches` AS `FootballMatch` LEFT JOIN `user9368_football`.`football_teams` AS `FootballTeam1` ON (`FootballMatch`.`team1_id` = `FootballTeam1`.`id`) LEFT JOIN `user9368_football`.`football_teams` AS `FootballTeam2` ON (`FootballMatch`.`team2_id` = `FootballTeam2`.`id`) LEFT JOIN `user9368_football`.`football_competitions` AS `FootballCompetition` ON (`FootballMatch`.`football_competition_id` = `FootballCompetition`.`id`) WHERE `ready` = 1 AND ((`FootballMatch`.`team1_id` = 97) OR (`FootballMatch`.`team2_id` = 97)) ORDER BY `match_date` desc LIMIT 20202049
14SELECT `FootballMatchCard`.`id`, `FootballMatchCard`.`football_match_id`, `FootballMatchCard`.`team_id`, `FootballMatchCard`.`player_id`, `FootballMatchCard`.`type`, `FootballMatchCard`.`minute`, `FootballMatchCard`.`extra_minute` FROM `user9368_football`.`football_match_cards` AS `FootballMatchCard` WHERE `FootballMatchCard`.`football_match_id` IN (95320, 90530, 90522, 90512, 90507, 73802, 78044, 73790, 73776, 78033, 73773, 78032, 73763, 73745, 73737, 78022, 73729, 78021, 73716, 73709)1101102
15SELECT `Video`.`id`, `Video`.`title`, `Video`.`title_ru`, `Video`.`url`, `Video`.`image`, `Video`.`country`, `Video`.`match_id`, `Video`.`date_created` FROM `user9368_football`.`videos` AS `Video` WHERE `Video`.`match_id` IN (95320, 90530, 90522, 90512, 90507, 73802, 78044, 73790, 73776, 78033, 73773, 78032, 73763, 73745, 73737, 78022, 73729, 78021, 73716, 73709)28287
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`.`date_updated`, `FootballMatch`.`date_created`, `FootballTeam1`.`id`, `FootballTeam1`.`title`, `FootballTeam1`.`title_ru`, `FootballTeam1`.`country`, `FootballTeam1`.`external_main_id`, `FootballTeam1`.`founded`, `FootballTeam1`.`address`, `FootballTeam1`.`img`, `FootballTeam1`.`date_updated`, `FootballTeam2`.`id`, `FootballTeam2`.`title`, `FootballTeam2`.`title_ru`, `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 `user9368_football`.`football_matches` AS `FootballMatch` LEFT JOIN `user9368_football`.`football_teams` AS `FootballTeam1` ON (`FootballMatch`.`team1_id` = `FootballTeam1`.`id`) LEFT JOIN `user9368_football`.`football_teams` AS `FootballTeam2` ON (`FootballMatch`.`team2_id` = `FootballTeam2`.`id`) LEFT JOIN `user9368_football`.`football_competitions` AS `FootballCompetition` ON (`FootballMatch`.`football_competition_id` = `FootballCompetition`.`id`) WHERE `ready` = 1 AND ((`FootballMatch`.`team1_id` = 104) OR (`FootballMatch`.`team2_id` = 104)) ORDER BY `match_date` desc LIMIT 20202049
17SELECT `FootballMatchCard`.`id`, `FootballMatchCard`.`football_match_id`, `FootballMatchCard`.`team_id`, `FootballMatchCard`.`player_id`, `FootballMatchCard`.`type`, `FootballMatchCard`.`minute`, `FootballMatchCard`.`extra_minute` FROM `user9368_football`.`football_match_cards` AS `FootballMatchCard` WHERE `FootballMatchCard`.`football_match_id` IN (90530, 90520, 90509, 90504, 73802, 73792, 73781, 73767, 73758, 73748, 73742, 73730, 73721, 73706, 73695, 73687, 73682, 73674, 73658, 73645)95951
18SELECT `Video`.`id`, `Video`.`title`, `Video`.`title_ru`, `Video`.`url`, `Video`.`image`, `Video`.`country`, `Video`.`match_id`, `Video`.`date_created` FROM `user9368_football`.`videos` AS `Video` WHERE `Video`.`match_id` IN (90530, 90520, 90509, 90504, 73802, 73792, 73781, 73767, 73758, 73748, 73742, 73730, 73721, 73706, 73695, 73687, 73682, 73674, 73658, 73645)21214
19SELECT `Country`.`code`, `Country`.`title_ru` FROM `user9368_football`.`countries` AS `Country` WHERE 1 = 12662665
20SELECT `Video`.`id`, `Video`.`title`, `Video`.`title_ru`, `Video`.`url`, `Video`.`image`, `Video`.`country`, `Video`.`match_id`, `Video`.`date_created` FROM `user9368_football`.`videos` AS `Video` WHERE `match_id` = 73802 LIMIT 1006