| 1 | SELECT `Country`.`code`, `Country`.`title_ru` FROM `user28770_football`.`countries` AS `Country` WHERE 1 = 1 | | 266 | 266 | 0 |
| 2 | SELECT `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 = 1 | | 266 | 266 | 0 |
| 3 | SELECT `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` = 18457 LIMIT 1 | | 1 | 1 | 3 |
| 4 | SELECT `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` = (18457) | | 1 | 1 | 1 |
| 5 | SELECT `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` = (18457) ORDER BY `FootballMatchGoal`.`minute` ASC, `FootballMatchGoal`.`extra_minute` ASC | | 0 | 0 | 1 |
| 6 | SELECT `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` = (18457) | | 0 | 0 | 14 |
| 7 | SELECT `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` = 18457 | | 0 | 0 | 1 |
| 8 | SELECT `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` = 18457 AND `FootballMatchPlayer`.`team_id` = 395 ORDER BY `main` desc | | 18 | 18 | 2 |
| 9 | SELECT `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` = 18457 AND `FootballMatchPlayer`.`team_id` = 376 ORDER BY `main` desc | | 18 | 18 | 2 |
| 10 | SELECT * 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` = 18457 AND `FootballMatchCoach`.`team_id` = 395 LIMIT 1 | | 0 | 0 | 1 |
| 11 | SELECT * 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` = 18457 AND `FootballMatchCoach`.`team_id` = 376 LIMIT 1 | | 0 | 0 | 1 |
| 12 | SELECT * 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` = 18457 | | 36 | 36 | 7 |
| 13 | SELECT `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` = 395) OR (`FootballMatch`.`team2_id` = 395)) ORDER BY `match_date` desc LIMIT 20 | | 20 | 20 | 0 |
| 14 | SELECT `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 (100052, 100184, 100160, 100150, 100137, 100125, 100117, 100104, 100088, 100084, 107647, 100064, 107605, 100043, 100039, 100016, 100006, 99992, 107453, 99988) | | 43 | 43 | 0 |
| 15 | SELECT `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 (100052, 100184, 100160, 100150, 100137, 100125, 100117, 100104, 100088, 100084, 107647, 100064, 107605, 100043, 100039, 100016, 100006, 99992, 107453, 99988) | | 2 | 2 | 0 |
| 16 | SELECT `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` = 376) OR (`FootballMatch`.`team2_id` = 376)) ORDER BY `match_date` desc LIMIT 20 | | 20 | 20 | 0 |
| 17 | SELECT `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 (99640, 99509, 99616, 99604, 99592, 99580, 107892, 99569, 99553, 107661, 99529, 107642, 99521, 99410, 107578, 99478, 99473, 99452, 99448, 99436) | | 53 | 53 | 0 |
| 18 | SELECT `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 (99640, 99509, 99616, 99604, 99592, 99580, 107892, 99569, 99553, 107661, 99529, 107642, 99521, 99410, 107578, 99478, 99473, 99452, 99448, 99436) | | 4 | 4 | 0 |
| 19 | SELECT `Country`.`code`, `Country`.`title_ru` FROM `user28770_football`.`countries` AS `Country` WHERE 1 = 1 | | 266 | 266 | 0 |
| 20 | SELECT `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` = 18457 LIMIT 1 | | 0 | 0 | 14 |
26'
