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

Овьедо



Испания
1926
Calle de Ricardo Vázquez Prada, Barrio de la Ería 33013 Oviedo

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

Дата Д/Г Т команда счет ПТ ВТ У Ж К
16.09.2018 Г Ч Луго 2 - 0 1-0 1-0 2-6 3-2 0-0
11.09.2018 Г К Мальорка 0 - 1 0-0 0-1 - 2-2 0-0
08.09.2018 Д Ч Сарагоса 0 - 4 0-1 0-3 10-6 1-2 0-0
01.09.2018 Г Ч Cádiz 1 - 1 0-0 1-1 2-5 2-1 0-0
25.08.2018 Г Ч Кордоба 4 - 2 2-0 2-2 3-6 4-3 0-0
19.08.2018 Д Ч Extremadura UD 1 - 1 1-0 0-1 9-1 1-1 0-0
02.06.2018 Д Ч Хуеска 2 - 1 1-0 1-1 7-4 3-6 0-0
27.05.2018 Г Ч Cultural Leonesa 0 - 2 0-1 0-1 6-4 8-3 0-0
19.05.2018 Д Ч Sevilla II 2 - 1 1-0 1-1 7-3 4-2 0-0
12.05.2018 Г Ч Осасуна 1 - 2 1-0 0-2 1-6 6-5 0-0
06.05.2018 Д Ч La Hoya Lorca 2 - 0 1-0 1-0 9-6 2-2 0-1
29.04.2018 Г Ч Нумансия 0 - 3 0-2 0-1 7-6 4-1 0-0
20.04.2018 Д Ч Вальядолид 1 - 2 0-0 1-2 1-3 3-2 0-0
15.04.2018 Д Ч Химнастик 1 - 0 1-0 0-0 1-4 5-7 0-1
08.04.2018 Г Ч Луго 1 - 0 0-0 1-0 2-2 3-6 0-1
31.03.2018 Д Ч Алькорон 0 - 1 0-0 0-1 7-8 2-5 0-0
24.03.2018 Г Ч Кордоба 1 - 1 1-0 0-1 2-7 5-2 0-0
18.03.2018 Д Ч Гранада 2 - 1 1-1 1-0 5-3 2-5 0-1
09.03.2018 Г Ч Тенерифе 1 - 3 0-2 1-1 1-1 4-3 0-0
02.03.2018 Д Ч Барселона II 0 - 0 0-0 0-0 5-4 4-1 0-0

Состав

Alfonso Herrero вратарь 270 3 3 0 0 0 0 0 0 0
N. Champagne вратарь 0 0 0 0 0 3 0 0 0 0
Diego Johannesson защитник 270 3 3 0 0 0 0 0 0 0
J. Forlín защитник 27 1 0 1 0 3 0 0 0 0
Mossa защитник 270 3 3 0 0 0 0 1 0 0
O. Alanís защитник 0 0 0 0 0 0 0 0 0 0
Carlos Hernández защитник 360 4 4 0 0 0 0 1 0 0
Javi защитник 0 0 0 0 0 3 0 0 0 0
Carlos Martínez защитник 0 0 0 0 0 2 0 0 0 0
Christian Fernández защитник 450 5 5 0 0 0 0 1 0 0
Javier Muñoz полузащитник 418 5 5 0 2 0 1 2 0 0
Saúl Berjón полузащитник 423 5 5 0 2 0 2 1 0 0
E. Barcenas полузащитник 236 3 3 0 2 0 2 1 0 0
R. Boateng полузащитник 368 5 5 0 3 0 0 0 0 0
Aaron Níguez полузащитник 77 4 0 4 0 4 0 0 0 0
E. Barcenas полузащитник 236 3 3 0 2 0 2 1 0 0
Tejera полузащитник 360 4 4 0 0 0 1 2 0 0
Edu Cortina полузащитник 0 0 0 0 0 3 0 0 0 0
Ramón Folch полузащитник 0 0 0 0 0 0 0 0 0 0
Joselu нападающий 212 5 2 3 1 3 1 1 0 0
Dani Sandoval нападающий 0 0 0 0 0 1 0 0 0 0
Toché нападающий 258 5 3 2 3 2 1 0 0 0
I. Baldé нападающий 36 2 0 2 0 5 0 0 0 0

(default) 9 queries took 418 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Country`.`code`, `Country`.`title_ru` FROM `user9368_football`.`countries` AS `Country` WHERE 1 = 12662663
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 `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` = 124 LIMIT 1114
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 1118
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` = 124 GROUP BY competition_title_id, season ORDER BY FIELD(competition_type, 'liga','cup','international','nation'), season DESC1818256
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` = 124 AND `FootballPlayerTeamsStat`.`competition_title_id` = 281 AND `FootballPlayerTeamsStat`.`season` = '2018/2019' GROUP BY player_id ORDER BY FIELD(position, 'attacker','midfielder','defender','goalkeeper') DESC232354
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` = 124) OR (`FootballMatch`.`team2_id` = 124)) ORDER BY `match_date` desc LIMIT 20202052
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 (90929, 92887, 90916, 90905, 90895, 90886, 74263, 74248, 74236, 74231, 74220, 74206, 74194, 74189, 74176, 74162, 74155, 74136, 74129, 74120)13313322
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 (90929, 92887, 90916, 90905, 90895, 90886, 74263, 74248, 74236, 74231, 74220, 74206, 74194, 74189, 74176, 74162, 74155, 74136, 74129, 74120)2215