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 | 1 |
3 | SELECT `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated`, `Country`.`code`, `Country`.`code2`, `Country`.`title_ru`, `Country`.`title_en`, `Country`.`title_ru_full`, `Country`.`code_num`, `Country`.`code3` FROM `user28770_football`.`football_players` AS `FootballPlayer` LEFT JOIN `user28770_football`.`countries` AS `Country` ON (`FootballPlayer`.`country` = `Country`.`code`) WHERE `FootballPlayer`.`id` = 19700 LIMIT 1 | | 1 | 1 | 1 |
4 | SELECT `FootballPlayerTeamsStat`.`id`, `FootballPlayerTeamsStat`.`player_id`, `FootballPlayerTeamsStat`.`team_id`, `FootballPlayerTeamsStat`.`competition_title_id`, `FootballPlayerTeamsStat`.`season`, `FootballPlayerTeamsStat`.`competition_type`, `FootballPlayerTeamsStat`.`minutes`, `FootballPlayerTeamsStat`.`appearances`, `FootballPlayerTeamsStat`.`lineups`, `FootballPlayerTeamsStat`.`substitute_in`, `FootballPlayerTeamsStat`.`substitute_out`, `FootballPlayerTeamsStat`.`substitute_on_bench`, `FootballPlayerTeamsStat`.`goals`, `FootballPlayerTeamsStat`.`yellow`, `FootballPlayerTeamsStat`.`yellow_red`, `FootballPlayerTeamsStat`.`red`, `FootballPlayerTeamsStat`.`date_created`, `FootballPlayerTeamsStat`.`date_updated`, `FootballTeam`.`id`, `FootballTeam`.`title`, `FootballTeam`.`title_ru`, `FootballTeam`.`title_ru_parimatch`, `FootballTeam`.`country`, `FootballTeam`.`external_main_id`, `FootballTeam`.`founded`, `FootballTeam`.`address`, `FootballTeam`.`img`, `FootballTeam`.`date_updated`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country` FROM `user28770_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam` ON (`FootballPlayerTeamsStat`.`team_id` = `FootballTeam`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTeamsStat`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`player_id` = 19700 AND `FootballPlayerTeamsStat`.`competition_type` = 'liga' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC | | 10 | 10 | 2 |
5 | SELECT `FootballPlayerTeamsStat`.`id`, `FootballPlayerTeamsStat`.`player_id`, `FootballPlayerTeamsStat`.`team_id`, `FootballPlayerTeamsStat`.`competition_title_id`, `FootballPlayerTeamsStat`.`season`, `FootballPlayerTeamsStat`.`competition_type`, `FootballPlayerTeamsStat`.`minutes`, `FootballPlayerTeamsStat`.`appearances`, `FootballPlayerTeamsStat`.`lineups`, `FootballPlayerTeamsStat`.`substitute_in`, `FootballPlayerTeamsStat`.`substitute_out`, `FootballPlayerTeamsStat`.`substitute_on_bench`, `FootballPlayerTeamsStat`.`goals`, `FootballPlayerTeamsStat`.`yellow`, `FootballPlayerTeamsStat`.`yellow_red`, `FootballPlayerTeamsStat`.`red`, `FootballPlayerTeamsStat`.`date_created`, `FootballPlayerTeamsStat`.`date_updated`, `FootballTeam`.`id`, `FootballTeam`.`title`, `FootballTeam`.`title_ru`, `FootballTeam`.`title_ru_parimatch`, `FootballTeam`.`country`, `FootballTeam`.`external_main_id`, `FootballTeam`.`founded`, `FootballTeam`.`address`, `FootballTeam`.`img`, `FootballTeam`.`date_updated`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country` FROM `user28770_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam` ON (`FootballPlayerTeamsStat`.`team_id` = `FootballTeam`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTeamsStat`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`player_id` = 19700 AND `FootballPlayerTeamsStat`.`competition_type` = 'cup' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC | | 9 | 9 | 1 |
6 | SELECT `FootballPlayerTeamsStat`.`id`, `FootballPlayerTeamsStat`.`player_id`, `FootballPlayerTeamsStat`.`team_id`, `FootballPlayerTeamsStat`.`competition_title_id`, `FootballPlayerTeamsStat`.`season`, `FootballPlayerTeamsStat`.`competition_type`, `FootballPlayerTeamsStat`.`minutes`, `FootballPlayerTeamsStat`.`appearances`, `FootballPlayerTeamsStat`.`lineups`, `FootballPlayerTeamsStat`.`substitute_in`, `FootballPlayerTeamsStat`.`substitute_out`, `FootballPlayerTeamsStat`.`substitute_on_bench`, `FootballPlayerTeamsStat`.`goals`, `FootballPlayerTeamsStat`.`yellow`, `FootballPlayerTeamsStat`.`yellow_red`, `FootballPlayerTeamsStat`.`red`, `FootballPlayerTeamsStat`.`date_created`, `FootballPlayerTeamsStat`.`date_updated`, `FootballTeam`.`id`, `FootballTeam`.`title`, `FootballTeam`.`title_ru`, `FootballTeam`.`title_ru_parimatch`, `FootballTeam`.`country`, `FootballTeam`.`external_main_id`, `FootballTeam`.`founded`, `FootballTeam`.`address`, `FootballTeam`.`img`, `FootballTeam`.`date_updated`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country` FROM `user28770_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam` ON (`FootballPlayerTeamsStat`.`team_id` = `FootballTeam`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTeamsStat`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`player_id` = 19700 AND `FootballPlayerTeamsStat`.`competition_type` = 'international' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC | | 4 | 4 | 1 |
7 | SELECT `FootballPlayerTeamsStat`.`id`, `FootballPlayerTeamsStat`.`player_id`, `FootballPlayerTeamsStat`.`team_id`, `FootballPlayerTeamsStat`.`competition_title_id`, `FootballPlayerTeamsStat`.`season`, `FootballPlayerTeamsStat`.`competition_type`, `FootballPlayerTeamsStat`.`minutes`, `FootballPlayerTeamsStat`.`appearances`, `FootballPlayerTeamsStat`.`lineups`, `FootballPlayerTeamsStat`.`substitute_in`, `FootballPlayerTeamsStat`.`substitute_out`, `FootballPlayerTeamsStat`.`substitute_on_bench`, `FootballPlayerTeamsStat`.`goals`, `FootballPlayerTeamsStat`.`yellow`, `FootballPlayerTeamsStat`.`yellow_red`, `FootballPlayerTeamsStat`.`red`, `FootballPlayerTeamsStat`.`date_created`, `FootballPlayerTeamsStat`.`date_updated`, `FootballTeam`.`id`, `FootballTeam`.`title`, `FootballTeam`.`title_ru`, `FootballTeam`.`title_ru_parimatch`, `FootballTeam`.`country`, `FootballTeam`.`external_main_id`, `FootballTeam`.`founded`, `FootballTeam`.`address`, `FootballTeam`.`img`, `FootballTeam`.`date_updated`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country` FROM `user28770_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user28770_football`.`football_teams` AS `FootballTeam` ON (`FootballPlayerTeamsStat`.`team_id` = `FootballTeam`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTeamsStat`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`player_id` = 19700 AND `FootballPlayerTeamsStat`.`competition_type` = 'nation' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC | | 5 | 5 | 1 |
8 | SELECT `FootballPlayerTrophy`.`id`, `FootballPlayerTrophy`.`player_id`, `FootballPlayerTrophy`.`competition_title_id`, `FootballPlayerTrophy`.`seasons`, `FootballPlayerTrophy`.`win_type`, `FootballPlayerTrophy`.`competition_type`, `FootballPlayerTrophy`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated` FROM `user28770_football`.`football_player_trophies` AS `FootballPlayerTrophy` LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTrophy`.`competition_title_id` = `CompetitionTitle`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTrophy`.`player_id` = `FootballPlayer`.`id`) WHERE `FootballPlayerTrophy`.`player_id` = 19700 AND `competition_type` = 'club' | | 3 | 3 | 1 |
9 | SELECT `FootballPlayerTrophy`.`id`, `FootballPlayerTrophy`.`player_id`, `FootballPlayerTrophy`.`competition_title_id`, `FootballPlayerTrophy`.`seasons`, `FootballPlayerTrophy`.`win_type`, `FootballPlayerTrophy`.`competition_type`, `FootballPlayerTrophy`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated` FROM `user28770_football`.`football_player_trophies` AS `FootballPlayerTrophy` LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTrophy`.`competition_title_id` = `CompetitionTitle`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTrophy`.`player_id` = `FootballPlayer`.`id`) WHERE `FootballPlayerTrophy`.`player_id` = 19700 AND `competition_type` = 'club_international' | | 0 | 0 | 1 |
10 | SELECT `FootballPlayerTrophy`.`id`, `FootballPlayerTrophy`.`player_id`, `FootballPlayerTrophy`.`competition_title_id`, `FootballPlayerTrophy`.`seasons`, `FootballPlayerTrophy`.`win_type`, `FootballPlayerTrophy`.`competition_type`, `FootballPlayerTrophy`.`date_updated`, `CompetitionTitle`.`id`, `CompetitionTitle`.`title`, `CompetitionTitle`.`title_ru`, `CompetitionTitle`.`country`, `FootballPlayer`.`id`, `FootballPlayer`.`name`, `FootballPlayer`.`name_ru`, `FootballPlayer`.`height`, `FootballPlayer`.`weight`, `FootballPlayer`.`foot`, `FootballPlayer`.`position`, `FootballPlayer`.`external_main_id`, `FootballPlayer`.`country`, `FootballPlayer`.`birthdate`, `FootballPlayer`.`img`, `FootballPlayer`.`team_id`, `FootballPlayer`.`date_updated` FROM `user28770_football`.`football_player_trophies` AS `FootballPlayerTrophy` LEFT JOIN `user28770_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTrophy`.`competition_title_id` = `CompetitionTitle`.`id`) LEFT JOIN `user28770_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTrophy`.`player_id` = `FootballPlayer`.`id`) WHERE `FootballPlayerTrophy`.`player_id` = 19700 AND `competition_type` = 'national' | | 0 | 0 | 1 |
11 | 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 ((`code` = 'GEO') OR (`code3` = 'GEO')) LIMIT 1 | | 1 | 1 | 0 |
12 | SELECT *, `FootballMatch`.`id` 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`) INNER JOIN `user28770_football`.`football_match_players` AS `FootballMatchPlayer` ON (`FootballMatch`.`id` = `FootballMatchPlayer`.`football_match_id`) WHERE `ready` = 1 AND `FootballMatchPlayer`.`player_id` = 19700 ORDER BY `match_date` desc LIMIT 20 | | 20 | 20 | 3 |
13 | SELECT `FootballMatchGoalPlayer`.`id`, `FootballMatchGoalPlayer`.`football_match_id`, `FootballMatchGoalPlayer`.`team_id`, `FootballMatchGoalPlayer`.`player_id`, `FootballMatchGoalPlayer`.`assist_player_id`, `FootballMatchGoalPlayer`.`minute`, `FootballMatchGoalPlayer`.`extra_minute`, `FootballMatchGoalPlayer`.`penalty`, `FootballMatchGoalPlayer`.`autogoal` FROM `user28770_football`.`football_match_goals` AS `FootballMatchGoalPlayer` WHERE `FootballMatchGoalPlayer`.`player_id` = 19700 AND `FootballMatchGoalPlayer`.`football_match_id` IN (104652, 104651, 104530, 104529, 102565, 102563, 86986, 86996, 86989, 86981, 86977, 27026, 27019, 27014, 27003, 26996, 26988, 26981, 26970, 26961) ORDER BY `FootballMatchGoalPlayer`.`minute` ASC, `FootballMatchGoalPlayer`.`extra_minute` ASC | | 0 | 0 | 1 |
14 | SELECT `FootballMatchCardPlayer`.`id`, `FootballMatchCardPlayer`.`football_match_id`, `FootballMatchCardPlayer`.`team_id`, `FootballMatchCardPlayer`.`player_id`, `FootballMatchCardPlayer`.`type`, `FootballMatchCardPlayer`.`minute`, `FootballMatchCardPlayer`.`extra_minute` FROM `user28770_football`.`football_match_cards` AS `FootballMatchCardPlayer` WHERE `FootballMatchCardPlayer`.`player_id` = 19700 AND `FootballMatchCardPlayer`.`football_match_id` IN (104652, 104651, 104530, 104529, 102565, 102563, 86986, 86996, 86989, 86981, 86977, 27026, 27019, 27014, 27003, 26996, 26988, 26981, 26970, 26961) | | 3 | 3 | 1 |