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

M. Bakaev



Россия
05.08.1987
31 год
полузащитник
178
75
правая

Сезон Команда Турнир
2017/2018 Анжи Premier League 1216 16 13 3 2 7 0 0 0 0
2017 Кайрат Premier League 1126 17 12 5 3 13 0 2 0 0
2016 Кайрат Premier League 2393 29 25 4 0 5 0 3 0 0
2015 Кайрат Premier League 2322 26 26 0 3 1 0 4 0 0
2014 Кайрат Premier League 2474 28 27 1 0 1 0 2 0 0
2013/2014 Alaniya FNL 1174 16 13 3 2 3 0 1 0 0
2012/2013 Alaniya Premier League 983 21 8 13 2 22 0 3 0 0
2011/2012 Анжи Premier League 163 7 1 6 0 13 0 1 0 0
2011/2012 Alaniya FNL 2520 29 28 1 2 1 3 9 1 0
2010 Анжи Premier League 2481 29 28 1 5 1 1 6 0 0
2009 Анжи FNL 2820 33 32 1 3 0 2 5 0 1
2008 Alaniya FNL ? 0 ? ? ? ? 1 ? ? ?

Сезон Команда Турнир
2017/2018 Анжи Play-offs 1/2 90 1 1 0 0 1 0 1 0 0
2017 Кайрат Cup 343 4 4 0 1 0 0 0 0 0
2017 Кайрат Super Cup 90 1 1 0 0 0 0 0 0 0
2016 Кайрат Cup 450 5 5 0 0 0 0 1 0 0
2016 Кайрат Super Cup 120 1 1 0 0 0 0 0 0 0
2015 Кайрат Cup 451 5 5 0 1 0 0 0 0 0
2015 Кайрат Super Cup 120 1 1 0 0 0 0 0 0 0
2014 Кайрат Cup 360 4 4 0 0 0 0 0 0 0
2013/2014 Alaniya Cup 90 1 1 0 0 0 1 0 0 0
2012/2013 Alaniya Cup 90 1 1 0 0 0 0 1 0 0
2010/2011 Анжи Cup 90 1 1 0 0 0 0 0 0 0

Сезон Команда Турнир
2017/2018 Кайрат UEFA Europa League 270 3 3 0 0 1 0 1 0 0
2016/2017 Кайрат UEFA Europa League 360 4 4 0 0 0 1 1 0 0
2015/2016 Кайрат UEFA Europa League 360 4 4 0 0 0 1 1 0 0
2014/2015 Кайрат UEFA Europa League 360 4 4 0 0 0 0 1 0 0
2011/2012 Alaniya UEFA Europa League 180 2 2 0 0 0 0 0 0 0

Сезон Команда Турнир

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

Трофеи

Клубы
Cup 2015, 2014
Super Cup 2017, 2016
FNL 2009

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

Дата Т
13.05.2018 Ч ЦСКА 2 - 1 Анжи
21.04.2018 Ч Анжи 0 - 1 Урал
14.04.2018 Ч Зенит 1 - 0 Анжи
08.04.2018 Ч Анжи 1 - 4 Спартак М
01.04.2018 Ч Краснодар 1 - 1 Анжи
17.03.2018 Ч Анжи 2 - 0 Тосно
10.03.2018 Ч Уфа 3 - 2 Анжи
02.03.2018 Ч Анжи 1 - 1 Рубин
09.12.2017 Ч Динамо М 2 - 0 Анжи
03.12.2017 Ч Анжи 4 - 0 СКА Хабаровск
26.11.2017 Ч Ростов 2 - 0 Анжи
19.11.2017 Ч Анжи 0 - 1 Локомотив М
05.11.2017 Ч Амкар 1 - 2 Анжи
30.10.2017 Ч Ахмат 1 - 1 Анжи
22.10.2017 Ч Анжи 3 - 2 Арсенал Тула
14.10.2017 Ч Урал 2 - 1 Анжи
01.10.2017 Ч Анжи 2 - 2 Зенит
23.09.2017 Ч Спартак М 2 - 2 Анжи
16.09.2017 Ч Анжи 1 - 5 Краснодар
09.09.2017 Ч Тосно 2 - 2 Анжи

(default) 14 queries took 117 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 = 12662660
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` = 22895 LIMIT 1112
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` = 22895 AND `FootballPlayerTeamsStat`.`competition_type` = 'liga' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC12129
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` = 22895 AND `FootballPlayerTeamsStat`.`competition_type` = 'cup' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC11116
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` = 22895 AND `FootballPlayerTeamsStat`.`competition_type` = 'international' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC556
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` = 22895 AND `FootballPlayerTeamsStat`.`competition_type` = 'nation' ORDER BY `season` DESC, `FootballPlayerTeamsStat`.`id` DESC006
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` = 22895 AND `competition_type` = 'club'333
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` = 22895 AND `competition_type` = 'club_international'001
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` = 22895 AND `competition_type` = 'national'002
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` = 'RUS') OR (`code3` = 'RUS')) LIMIT 1110
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` = 22895 ORDER BY `match_date` desc LIMIT 20202051
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` = 22895 AND `FootballMatchGoalPlayer`.`football_match_id` IN (58313, 58288, 58280, 58272, 58264, 58256, 58248, 58240, 58239, 58224, 58216, 58209, 58200, 58192, 58184, 58176, 58168, 58160, 58152, 58144) ORDER BY `FootballMatchGoalPlayer`.`minute` ASC, `FootballMatchGoalPlayer`.`extra_minute` ASC0022
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` = 22895 AND `FootballMatchCardPlayer`.`football_match_id` IN (58313, 58288, 58280, 58272, 58264, 58256, 58248, 58240, 58239, 58224, 58216, 58209, 58200, 58192, 58184, 58176, 58168, 58160, 58152, 58144)009