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

Тосно - Амкар 0-2

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

Тосно   

0-2 (0-1)

   Амкар

Турнир Премьер лига
Дата 22.04.2018 16:30
Тур 27
Стадион Stadion Petrovskiy (Sankt-Peterburg (St. Petersburg))
Зрителей 4331
Голы     Видео голов
0 - 1 A. Ryazantsev (пен)   17'
0 - 2 M. Kostyukov   90+2'
Составы
16.
10.
34'
4.
56'
22.
73'  
88.
15.
82'
21.
26.
24.
8.
25.
77'  

Замены
28.
29.
82'
Nuno Rocha
31.
64.
23.
19.
14.
11.
56'
I. Zhigulev
9.
5.
1.
77.
34'
G. Melkadze
1.
90+1'  
9.
76'
17.
20.
71'
5.
88' 87'  
91.
19.
3.
2.
18.
41.

Замены
26.
76'
D. Bodul
27.
88'
J. Gol
32.
66.
71' 87'  
P. Komolov
15.
14.
13.
11.
10.
6.
95.
Тренер
Арбитры
Главный A. Eskov
Ассистенты D. Mosyakin
N. Eremin
4-ый I. Fedotov
Статистика
6 Угловые 2
1 Удары в створ ворот 2
10 Удары мимо ворот 6
12 Фолы 18
1 Оффсайды 1
60 Владение мячом 40
Последние матчи
Дата Д/Г Т команда счет ПТ ВТ У Ж К
13.05.2018 Г Ч Уфа 0 - 5 0-2 0-3 5-3 2-3 0-0
09.05.2018 Г К Авангард Курск 1 - 2 1-1 0-1 1-5 3-3 0-0
05.05.2018 Д Ч Динамо М 1 - 2 0-0 1-2 3-5 4-2 0-0
29.04.2018 Г Ч Ростов 0 - 2 0-0 0-2 2-9 3-2 1-0
22.04.2018 Д Ч Амкар 0 - 2 0-1 0-1 6-2 2-3 0-0
18.04.2018 Г К Спартак М 1 - 1 0-0 1-1 3-12 5-1 0-0
13.04.2018 Г Ч Ахмат 0 - 1 0-0 0-1 3-2 2-3 0-0
08.04.2018 Д Ч Урал 2 - 2 1-1 1-1 6-1 2-3 0-0
31.03.2018 Г Ч Спартак М 1 - 2 0-1 1-1 5-6 1-2 0-0
17.03.2018 Г Ч Анжи 0 - 2 0-2 0-0 3-4 1-0 0-0
10.03.2018 Д Ч Рубин 0 - 1 0-0 0-1 2-4 0-2 0-0
04.03.2018 Г Ч СКА Хабаровск 1 - 0 0-0 1-0 4-2 4-3 0-0
28.02.2018 Д К Луч Владивосток 2 - 1 2-0 0-1 6-0 2-2 0-0
11.12.2017 Д Ч Локомотив М 1 - 3 0-1 1-2 10-7 2-2 1-0
01.12.2017 Г Ч ЦСКА 0 - 6 0-3 0-3 3-6 1-0 0-0
25.11.2017 Д Ч Арсенал Тула 3 - 2 0-1 3-1 3-8 0-1 0-0
19.11.2017 Г Ч Зенит 0 - 5 0-1 0-4 3-4 2-1 0-0
04.11.2017 Д Ч Краснодар 1 - 3 1-3 0-0 6-2 2-0 0-0
29.10.2017 Г Ч Динамо М 1 - 0 1-0 0-0 1-13 6-1 0-0
25.10.2017 Д К Томь 0 - 0 0-0 0-0 9-0 1-4 0-0
Дата Д/Г Т команда счет ПТ ВТ У Ж К
13.05.2018 Д Ч Ахмат 0 - 0 0-0 0-0 7-3 2-0 0-1
06.05.2018 Г Ч Урал 2 - 0 1-0 1-0 4-4 4-3 0-0
29.04.2018 Д Ч Спартак М 0 - 2 0-1 0-1 4-5 3-2 0-0
22.04.2018 Г Ч Тосно 2 - 0 1-0 1-0 2-6 3-2 0-0
18.04.2018 Г Ч ЦСКА 0 - 3 0-2 0-1 9-5 1-0 0-0
14.04.2018 Д Ч Рубин 0 - 3 0-2 0-1 5-6 2-2 0-0
07.04.2018 Г Ч СКА Хабаровск 2 - 0 1-0 1-0 - 1-0 0-1
31.03.2018 Д Ч Локомотив М 2 - 1 0-1 2-0 9-3 1-1 0-1
09.03.2018 Д Ч Арсенал Тула 0 - 2 0-1 0-1 3-3 1-2 2-0
03.03.2018 Г Ч Зенит 0 - 0 0-0 0-0 4-5 4-4 1-2
27.02.2018 Д К Авангард Курск 0 - 0 0-0 0-0 6-3 4-0 0-0
10.12.2017 Д Ч Краснодар 1 - 3 0-2 1-1 11-1 1-1 0-0
03.12.2017 Г Ч Уфа 0 - 3 0-0 0-3 3-4 0-3 0-0
24.11.2017 Д Ч Динамо М 2 - 1 0-0 2-1 2-7 1-5 0-0
19.11.2017 Г Ч Ростов 0 - 0 0-0 0-0 4-2 3-1 0-0
05.11.2017 Д Ч Анжи 1 - 2 1-2 0-0 1-4 5-4 0-1
29.10.2017 Д Ч Урал 1 - 1 1-0 0-1 2-5 1-1 0-0
25.10.2017 Г К Ростов 1 - 1 1-1 0-0 1-8 1-1 0-0
21.10.2017 Г Ч Спартак М 0 - 0 0-0 0-0 1-7 2-0 0-0
16.10.2017 Д Ч Тосно 0 - 0 0-0 0-0 2-6 4-5 0-0

(default) 20 queries took 299 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Country`.`code`, `Country`.`title_ru` FROM `user9368_football`.`countries` AS `Country` WHERE 1 = 12662663
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 = 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`.`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` = 58292 LIMIT 11111
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` = (58292)5512
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` = (58292) ORDER BY `FootballMatchGoal`.`minute` ASC, `FootballMatchGoal`.`extra_minute` ASC224
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` = (58292)1112
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` = 58292001
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` = 58292 AND `FootballMatchPlayer`.`team_id` = 1793 ORDER BY `main` desc23238
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` = 58292 AND `FootballMatchPlayer`.`team_id` = 242 ORDER BY `main` desc22227
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` = 58292 AND `FootballMatchCoach`.`team_id` = 1793 LIMIT 1118
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` = 58292 AND `FootballMatchCoach`.`team_id` = 242 LIMIT 1118
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` = 58292454519
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` = 1793) OR (`FootballMatch`.`team2_id` = 1793)) ORDER BY `match_date` desc LIMIT 20202076
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 (58317, 78040, 58308, 58300, 58292, 78025, 58284, 58276, 58268, 58256, 58251, 58241, 77477, 58232, 58226, 58219, 58211, 58204, 58196, 77374)85855
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 (58317, 78040, 58308, 58300, 58292, 78025, 58284, 58276, 58268, 58256, 58251, 58241, 77477, 58232, 58226, 58219, 58211, 58204, 58196, 77374)34348
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` = 242) OR (`FootballMatch`.`team2_id` = 242)) ORDER BY `match_date` desc LIMIT 20202082
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 (58319, 58310, 58301, 58292, 58260, 58283, 58274, 58265, 58253, 58245, 77475, 58237, 58230, 58223, 58215, 58200, 58198, 77371, 58189, 58180)90900
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 (58319, 58310, 58301, 58292, 58260, 58283, 58274, 58265, 58253, 58245, 77475, 58237, 58230, 58223, 58215, 58200, 58198, 77371, 58189, 58180)27274
19SELECT `Country`.`code`, `Country`.`title_ru` FROM `user9368_football`.`countries` AS `Country` WHERE 1 = 12662668
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` = 58292 LIMIT 11123