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

Эспаньол



Испания
1900
Avenida Baix Llobregat 100 08940 Barcelona

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

Дата Д/Г Т команда счет ПТ ВТ У Ж К
16.09.2018 Д Ч Леванте 1 - 0 0-0 1-0 5-4 1-2 0-0
02.09.2018 Г Ч Алавес 1 - 2 1-0 0-2 12-0 3-4 0-0
26.08.2018 Д Ч Валенсия 2 - 0 0-0 2-0 6-10 1-1 0-0
18.08.2018 Г Ч Сельта 1 - 1 1-0 0-1 7-8 2-3 0-0
20.05.2018 Г Ч Атлетик 1 - 0 1-0 0-0 7-7 1-0 0-0
13.05.2018 Д Ч Малага 4 - 1 3-1 1-0 5-3 0-2 0-0
06.05.2018 Г Ч Атлетико М 2 - 0 0-0 2-0 3-6 3-1 0-0
28.04.2018 Д Ч Лас Пальмас 1 - 1 0-1 1-0 6-7 2-4 0-0
22.04.2018 Г Ч Жирона 2 - 0 1-0 1-0 0-10 2-1 0-0
18.04.2018 Д Ч Эйбар 0 - 1 0-1 0-0 3-6 3-2 0-0
15.04.2018 Г Ч Хетафе 0 - 1 0-0 0-1 3-4 2-5 0-1
08.04.2018 Г Ч Валенсия 0 - 1 0-1 0-0 3-4 2-3 0-0
01.04.2018 Д Ч Алавес 0 - 0 0-0 0-0 6-5 5-2 0-0
17.03.2018 Г Ч Бетис 0 - 3 0-1 0-2 5-3 3-1 0-0
11.03.2018 Д Ч Реал Сосьедад 2 - 1 0-1 2-0 6-4 0-4 0-0
04.03.2018 Г Ч Леванте 1 - 1 0-0 1-1 1-2 3-0 0-0
27.02.2018 Д Ч Реал М 1 - 0 0-0 1-0 3-8 1-1 0-0
23.02.2018 Г Ч Депортиво 0 - 0 0-0 0-0 2-4 1-5 0-0
18.02.2018 Д Ч Вильяреал 1 - 1 0-1 1-0 2-5 1-7 0-0
11.02.2018 Г Ч Сельта 2 - 2 1-1 1-1 1-9 4-4 0-0

Состав

Diego López вратарь 270 3 3 0 0 0 0 0 0 0
Roberto Jiménez вратарь 0 0 0 0 0 4 0 0 0 0
Javi López защитник 348 4 4 0 1 0 0 0 0 0
David López защитник 270 3 3 0 0 0 0 0 0 0
Sergio Sánchez защитник 0 0 0 0 0 0 0 0 0 0
Mario Hermoso защитник 270 3 3 0 0 0 1 1 0 0
Dídac Vilá защитник 360 4 4 0 0 0 0 2 0 0
R. Rosales защитник 0 0 0 0 0 1 0 0 0 0
Ó. Duarte защитник 0 0 0 0 0 3 0 0 0 0
Naldo защитник 0 0 0 0 0 1 0 0 0 0
Víctor Sánchez полузащитник 113 3 1 2 0 3 0 0 0 0
Alejandro López полузащитник 0 0 0 0 0 1 0 0 0 0
Granero полузащитник 237 3 3 0 2 0 1 0 0 0
P. Piatti полузащитник 120 4 1 3 1 3 0 0 0 0
Óscar Melendo полузащитник 23 1 0 1 0 3 0 0 0 0
Sergi Darder полузащитник 347 4 4 0 1 0 0 1 0 0
Marc Roca полузащитник 263 3 3 0 1 0 0 1 0 0
Borja Iglesias нападающий 335 4 4 0 2 0 1 1 0 0
Álvaro Vázquez нападающий 0 0 0 0 0 0 0 0 0 0
Léo Baptistão нападающий 327 4 4 0 2 0 1 1 0 0
Sergio García нападающий 252 4 3 1 2 1 1 0 0 0
Javier Puado нападающий 9 1 0 1 0 3 0 0 0 0
H. Pérez нападающий 56 4 0 4 0 4 0 0 0 0

(default) 9 queries took 157 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 = 12662661
3SELECT `FootballTeam`.`id`, `FootballTeam`.`title`, `FootballTeam`.`title_ru`, `FootballTeam`.`country`, `FootballTeam`.`external_main_id`, `FootballTeam`.`founded`, `FootballTeam`.`address`, `FootballTeam`.`img`, `FootballTeam`.`date_updated` FROM `user9368_football`.`football_teams` AS `FootballTeam` WHERE `FootballTeam`.`id` = 105 LIMIT 1111
4SELECT `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` = 'ESP') OR (`code3` = 'ESP')) LIMIT 1110
5SELECT * FROM `user9368_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user9368_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`team_id` = 105 GROUP BY competition_title_id, season ORDER BY FIELD(competition_type, 'liga','cup','international','nation'), season DESC292980
6SELECT * FROM `user9368_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` INNER JOIN `user9368_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayer`.`id` = `FootballPlayerTeamsStat`.`player_id`) LEFT JOIN `user9368_football`.`countries` AS `Country` ON (`FootballPlayer`.`country` = `Country`.`code`) WHERE `FootballPlayerTeamsStat`.`team_id` = 105 AND `FootballPlayerTeamsStat`.`competition_title_id` = 476 AND `FootballPlayerTeamsStat`.`season` = '2018/2019' GROUP BY player_id ORDER BY FIELD(position, 'attacker','midfielder','defender','goalkeeper') DESC232311
7SELECT `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` = 105) OR (`FootballMatch`.`team2_id` = 105)) ORDER BY `match_date` desc LIMIT 20202058
8SELECT `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 (90535, 90526, 90514, 90501, 73796, 73787, 73776, 73774, 73757, 73748, 73739, 73728, 73715, 73714, 73700, 73693, 73676, 73671, 73663, 73650)93931
9SELECT `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 (90535, 90526, 90514, 90501, 73796, 73787, 73776, 73774, 73757, 73748, 73739, 73728, 73715, 73714, 73700, 73693, 73676, 73671, 73663, 73650)20205