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

Y. Benzia



Франция
08.09.1994
24 года
нападающий
179
71
правая

Сезон Команда Турнир
2018/2019 Фенербахче Süper Lig 86 1 1 0 1 0 0 0 0 0
2018/2019 Лилль Ligue 1 162 2 2 0 2 0 0 0 0 0
2017/2018 Lille II National 2 0 0 0 0 0 0 0 0 0 0
2017/2018 Лилль Ligue 1 2308 31 30 1 22 4 1 8 0 0
2016/2017 Lille II National 2 180 2 2 0 0 0 0 0 0 0
2016/2017 Лилль Ligue 1 1641 25 21 4 17 7 3 3 0 0
2015/2016 Лион Ligue 1 0 0 0 0 0 1 0 0 0 0
2015/2016 Lille II National 3 79 1 1 0 1 0 1 0 0 0
2015/2016 Лилль Ligue 1 1340 25 17 8 15 12 5 4 0 0
2014/2015 Olympique Lyonnais II National 2 607 8 8 0 3 0 3 0 0 0
2014/2015 Лион Ligue 1 318 10 3 7 3 10 2 0 0 0
2013/2014 Olympique Lyonnais II National 2 802 10 10 0 4 0 5 3 0 1
2013/2014 Лион Ligue 1 419 11 4 7 4 9 2 0 0 0
2012/2013 Olympique Lyonnais II National 2 687 8 8 0 4 0 5 3 0 0
2012/2013 Лион Ligue 1 322 16 3 13 3 23 0 4 0 0
2011/2012 Olympique Lyonnais II National 2 665 12 7 5 4 5 6 1 0 0
2011/2012 Лион Ligue 1 3 1 0 1 0 1 0 0 0 0

Сезон Команда Турнир
2017/2018 Лилль Coupe de France 79 1 1 0 1 0 0 0 0 0
2017/2018 Лилль Coupe de la Ligue 79 1 1 0 1 1 1 0 0 0
2016/2017 Лилль Coupe de France 90 1 1 0 0 0 0 0 0 0
2016/2017 Лилль Coupe de la Ligue 80 1 1 0 1 0 0 0 0 0
2015/2016 Лион Trophée des Champions 67 1 1 0 1 0 0 0 0 0
2015/2016 Лилль Coupe de France 120 1 1 0 0 0 0 0 0 0
2015/2016 Лилль Coupe de la Ligue 162 3 2 1 2 2 1 0 0 0
2014/2015 Лион Coupe de la Ligue 62 1 0 1 0 1 0 0 0 0
2013/2014 Лион Coupe de France 45 2 1 1 1 1 0 0 0 0
2013/2014 Лион Coupe de la Ligue 5 1 0 1 0 1 0 0 0 0
2012/2013 Лион Coupe de France 0 0 0 0 0 1 0 0 0 0
2012/2013 Лион Trophée des Champions 24 1 0 1 0 1 0 0 0 0

Сезон Команда Турнир
2016/2017 Лилль UEFA Europa League 80 2 0 2 0 2 0 0 0 0
2015 Лион Club Friendlies 18 1 0 1 0 1 0 0 0 0
2015 Лион Emirates Cup 90 1 1 0 0 0 0 1 0 0
2014/2015 Лион UEFA Europa League 110 2 1 1 0 2 0 0 0 0
2013/2014 Лион UEFA Champions League 113 3 2 1 2 1 0 0 0 0
2013/2014 Лион UEFA Europa League 40 2 0 2 0 2 0 0 0 0
2012/2013 Лион UEFA Europa League 187 3 2 1 2 3 2 0 0 0

Сезон Команда Турнир
2018 Russia Algeria WC Qualification Africa 0 0 0 0 0 2 0 0 0 0
2017 Gabon Algeria Africa Cup of Nations Qualification ? 0 ? ? ? ? 1 ? ? ?
2015 Cz… France U21 UEFA U21 Championship 273 4 3 1 2 1 4 0 0 0
2013 Li… France U19 UEFA U19 Championship 902 11 10 1 1 1 6 2 0 0
2011 Mexico France U17 U17 World Cup 374 5 4 1 1 1 5 1 0 0

Последнее обновление 19.09.2018

Трофеи

Клубы
Trophée des Champions 2012/2013
Algarve Football Cup 2018

Последние матчи


(default) 14 queries took 171 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 `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 `user9368_football`.`football_players` AS `FootballPlayer` LEFT JOIN `user9368_football`.`countries` AS `Country` ON (`FootballPlayer`.`country` = `Country`.`code`) WHERE `FootballPlayer`.`id` = 6701 LIMIT 1114
4SELECT `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`.`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 `user9368_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user9368_football`.`football_teams` AS `FootballTeam` ON (`FootballPlayerTeamsStat`.`team_id` = `FootballTeam`.`id`) LEFT JOIN `user9368_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTeamsStat`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user9368_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`player_id` = 6701 AND `FootballPlayerTeamsStat`.`competition_type` = 'liga' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC17174
5SELECT `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`.`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 `user9368_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user9368_football`.`football_teams` AS `FootballTeam` ON (`FootballPlayerTeamsStat`.`team_id` = `FootballTeam`.`id`) LEFT JOIN `user9368_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTeamsStat`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user9368_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`player_id` = 6701 AND `FootballPlayerTeamsStat`.`competition_type` = 'cup' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC121220
6SELECT `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`.`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 `user9368_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user9368_football`.`football_teams` AS `FootballTeam` ON (`FootballPlayerTeamsStat`.`team_id` = `FootballTeam`.`id`) LEFT JOIN `user9368_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTeamsStat`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user9368_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`player_id` = 6701 AND `FootballPlayerTeamsStat`.`competition_type` = 'international' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC778
7SELECT `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`.`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 `user9368_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user9368_football`.`football_teams` AS `FootballTeam` ON (`FootballPlayerTeamsStat`.`team_id` = `FootballTeam`.`id`) LEFT JOIN `user9368_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTeamsStat`.`player_id` = `FootballPlayer`.`id`) LEFT JOIN `user9368_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`player_id` = 6701 AND `FootballPlayerTeamsStat`.`competition_type` = 'nation' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC558
8SELECT `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 `user9368_football`.`football_player_trophies` AS `FootballPlayerTrophy` LEFT JOIN `user9368_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTrophy`.`competition_title_id` = `CompetitionTitle`.`id`) LEFT JOIN `user9368_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTrophy`.`player_id` = `FootballPlayer`.`id`) WHERE `FootballPlayerTrophy`.`player_id` = 6701 AND `competition_type` = 'club'225
9SELECT `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 `user9368_football`.`football_player_trophies` AS `FootballPlayerTrophy` LEFT JOIN `user9368_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTrophy`.`competition_title_id` = `CompetitionTitle`.`id`) LEFT JOIN `user9368_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTrophy`.`player_id` = `FootballPlayer`.`id`) WHERE `FootballPlayerTrophy`.`player_id` = 6701 AND `competition_type` = 'club_international'009
10SELECT `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 `user9368_football`.`football_player_trophies` AS `FootballPlayerTrophy` LEFT JOIN `user9368_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTrophy`.`competition_title_id` = `CompetitionTitle`.`id`) LEFT JOIN `user9368_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayerTrophy`.`player_id` = `FootballPlayer`.`id`) WHERE `FootballPlayerTrophy`.`player_id` = 6701 AND `competition_type` = 'national'005
11SELECT `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 ((`code` = 'FRA') OR (`code3` = 'FRA')) LIMIT 1119
12SELECT *, `FootballMatch`.`id` 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`) INNER JOIN `user9368_football`.`football_match_players` AS `FootballMatchPlayer` ON (`FootballMatch`.`id` = `FootballMatchPlayer`.`football_match_id`) WHERE `ready` = 1 AND `FootballMatchPlayer`.`player_id` = 6701 ORDER BY `match_date` desc LIMIT 20202063
13SELECT `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 `user9368_football`.`football_match_goals` AS `FootballMatchGoalPlayer` WHERE `FootballMatchGoalPlayer`.`player_id` = 6701 AND `FootballMatchGoalPlayer`.`football_match_id` IN (83596, 82008, 81997, 62105, 62092, 62087, 62070, 62062, 62050, 62040, 62031, 62023, 62011, 62005, 61981, 61974, 61952, 61947, 61932, 61918) ORDER BY `FootballMatchGoalPlayer`.`minute` ASC, `FootballMatchGoalPlayer`.`extra_minute` ASC1110
14SELECT `FootballMatchCardPlayer`.`id`, `FootballMatchCardPlayer`.`football_match_id`, `FootballMatchCardPlayer`.`team_id`, `FootballMatchCardPlayer`.`player_id`, `FootballMatchCardPlayer`.`type`, `FootballMatchCardPlayer`.`minute`, `FootballMatchCardPlayer`.`extra_minute` FROM `user9368_football`.`football_match_cards` AS `FootballMatchCardPlayer` WHERE `FootballMatchCardPlayer`.`player_id` = 6701 AND `FootballMatchCardPlayer`.`football_match_id` IN (83596, 82008, 81997, 62105, 62092, 62087, 62070, 62062, 62050, 62040, 62031, 62023, 62011, 62005, 61981, 61974, 61952, 61947, 61932, 61918)4422