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

Валюр - FC Santa Coloma 3-0

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

Валюр   

3-0 (0-0)

   FC Santa Coloma

Турнир Лига Европы УЕФА
Дата 02.08.2018 23:00
Раунд 2-ой квалификационный раунд
Стадион Vodafonevöllurinn (Valsvöllur) (Reykjavík)
Зрителей 825
Голы
S. Lárusson   53' 1 - 0
B. Eiríksson   62' 2 - 0
A. Adolphsson   90+4' 3 - 0
Составы
1.
16.
31'  
9.
90'
11.
79'
77.
7.
82'  
10.
67' 47'  
6.
32.
21.
2.
42'  

Замены
25.
19.
90'
P. Pedersen
17.
79'
S. Lárusson
8.
4.
67'
G. Lýdsson
3.
71.
66.
45+1'  
17.
43'  
8.
80'
7.
6.
2.
20'  
20.
66'
4.
84'  
11.
54' 44'  
5.
10'  

Замены
24.
85'  
22.
19.
54'
Albert Mercadé
13.
9.
80'
Aleix Cistero
16.
66'
Jaime Noguerol
Тренер
Арбитры
Главный I. Peljto
Ассистенты S. Ibrišimbegović
S. Udovičić
4-ый A. Šehović
Статистика
3 Угловые 3
3 Удары в створ ворот 4
6 Удары мимо ворот 2
19 Фолы 17
2 Оффсайды 0
63 Владение мячом 37
Последние матчи
Дата Д/Г Т команда счет ПТ ВТ У Ж К
16.09.2018 Д Ч ÍBV 5 - 1 0-1 5-0 7-3 1-2 0-0
02.09.2018 Г Ч KA 3 - 3 1-2 2-1 8-5 3-3 0-0
29.08.2018 Г Ч Stjarnan 1 - 1 1-1 0-0 3-3 2-3 0-0
25.08.2018 Д Ч Fjölnir 5 - 3 1-0 4-3 6-9 3-2 0-0
20.08.2018 Г Ч Breidablik 3 - 1 2-0 1-1 5-7 3-1 0-0
16.08.2018 Д ЛЕ Шериф 2 - 1 1-0 1-1 5-2 2-5 0-0
13.08.2018 Д Ч Grindavík 4 - 0 2-0 2-0 6-6 0-2 0-0
09.08.2018 Г ЛЕ Шериф 0 - 1 0-0 0-1 2-8 4-0 0-0
02.08.2018 Д ЛЕ FC Santa Coloma 3 - 0 0-0 3-0 3-3 4-7 0-0
30.07.2018 Г Ч Fylkir 0 - 0 0-0 0-0 10-4 1-5 0-0
26.07.2018 Г ЛЕ FC Santa Coloma 0 - 1 0-0 0-1 6-6 2-4 0-0
22.07.2018 Д Ч Víkingur Reykjavík 4 - 1 2-0 2-1 - 0-1 0-0
18.07.2018 Г ЛЧ Русенборг 1 - 3 0-0 1-3 3-8 3-0 1-0
11.07.2018 Д ЛЧ Русенборг 1 - 0 0-0 1-0 5-10 0-0 0-0
05.07.2018 Г Ч KR 1 - 1 1-1 0-0 - 1-2 1-0
01.07.2018 Г Ч Keflavík 2 - 0 - 2-0 - 0-0 0-0
20.06.2018 Д Ч Хабнарфьордюр 2 - 1 - 2-1 - 0-0 0-0
13.06.2018 Г Ч ÍBV 1 - 0 - 1-0 - 0-0 0-0
09.06.2018 Д Ч KA 3 - 1 - 3-1 - 0-0 0-0
04.06.2018 Г Ч Fjölnir 2 - 0 - 2-0 - 0-0 0-0
Дата Д/Г Т команда счет ПТ ВТ У Ж К
16.09.2018 Д Ч Lusitanos 0 - 0 - 0-0 - 0-0 0-0
02.08.2018 Г ЛЕ Валюр 0 - 3 0-0 0-3 3-3 7-4 0-0
26.07.2018 Д ЛЕ Валюр 1 - 0 0-0 1-0 6-6 4-2 0-0
26.06.2018 Д ЛЧ Drita 0 - 2 - 0-2 - 0-0 0-0
18.03.2018 Д Ч Inter Club d'Escaldes 1 - 0 - 1-0 - 0-0 0-0
11.03.2018 Г Ч Encamp 5 - 0 - 5-0 - 0-0 0-0
04.03.2018 Г Ч Lusitanos 0 - 2 - 0-2 - 0-0 0-0
25.02.2018 Д Ч Engordany 1 - 1 - 1-1 - 0-0 0-0
18.02.2018 Г Ч Sant Julià 1 - 3 - 1-3 - 0-0 0-0
11.02.2018 Д Ч UE Santa Coloma 2 - 0 - 2-0 - 0-0 0-0
04.02.2018 Г Ч Penya Encarnada 3 - 0 - 3-0 - 0-0 0-0
28.01.2018 Г Ч Inter Club d'Escaldes 2 - 0 - 2-0 - 0-0 0-0
17.12.2017 Д Ч Encamp 2 - 0 - 2-0 - 0-0 0-0
13.12.2017 Г Ч Engordany 1 - 0 - 1-0 - 0-0 0-0
10.12.2017 Д Ч Lusitanos 5 - 3 - 5-3 - 0-0 0-0
26.11.2017 Д Ч Sant Julià 1 - 0 - 1-0 - 0-0 0-0
19.11.2017 Г Ч UE Santa Coloma 2 - 0 - 2-0 - 0-0 0-0
12.11.2017 Д Ч Penya Encarnada 7 - 0 - 7-0 - 0-0 0-0
05.11.2017 Д Ч Inter Club d'Escaldes 3 - 0 - 3-0 - 0-0 0-0
29.10.2017 Г Ч Encamp 7 - 1 - 7-1 - 0-0 0-0

(default) 21 queries took 141 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 = 12662664
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` = 90354 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` = (90354)11114
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` = (90354) ORDER BY `FootballMatchGoal`.`minute` ASC, `FootballMatchGoal`.`extra_minute` ASC333
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` = (90354)005
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 `user9368_football`.`football_competitions` AS `FootballCompetition` WHERE `FootballCompetition`.`id` = 809 LIMIT 1114
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 `user9368_football`.`match_koeffs` AS `MatchKoeff` WHERE `match_id` = 90354003
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` = 90354 AND `FootballMatchPlayer`.`team_id` = 731 ORDER BY `main` desc18189
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 `user9368_football`.`football_match_players` AS `FootballMatchPlayer` WHERE `FootballMatchPlayer`.`football_match_id` = 90354 AND `FootballMatchPlayer`.`team_id` = 549 ORDER BY `main` desc16162
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` = 90354 AND `FootballMatchCoach`.`team_id` = 731 LIMIT 1114
12SELECT * 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` = 90354 AND `FootballMatchCoach`.`team_id` = 549 LIMIT 1114
13SELECT * 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` = 90354343420
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`.`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` = 731) OR (`FootballMatch`.`team2_id` = 731)) ORDER BY `match_date` desc LIMIT 20202039
15SELECT `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 (87316, 87308, 87285, 87300, 87298, 90420, 87292, 90419, 90354, 87277, 90353, 87269, 78145, 78144, 87260, 87255, 87252, 87245, 87242, 87236)68681
16SELECT `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 (87316, 87308, 87285, 87300, 87298, 90420, 87292, 90419, 90354, 87277, 90353, 87269, 78145, 78144, 87260, 87255, 87252, 87245, 87242, 87236)226
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`.`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` = 549) OR (`FootballMatch`.`team2_id` = 549)) 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 `user9368_football`.`football_match_cards` AS `FootballMatchCard` WHERE `FootballMatchCard`.`football_match_id` IN (91904, 90354, 90353, 78111, 66002, 65998, 65996, 65992, 65988, 65983, 65981, 65976, 65973, 65965, 65966, 65961, 65955, 65953, 65946, 65942)17170
19SELECT `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 (91904, 90354, 90353, 78111, 66002, 65998, 65996, 65992, 65988, 65983, 65981, 65976, 65973, 65965, 65966, 65961, 65955, 65953, 65946, 65942)0011
20SELECT `Country`.`code`, `Country`.`title_ru` FROM `user9368_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 `user9368_football`.`videos` AS `Video` WHERE `match_id` = 90354 LIMIT 10011