4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Eibar - Real Oviedo
Jornada 42
FINALIZADO
20
20
1742 Pts. Elo
48%
3º

1439 Pts. Elo
51%
6º

4-3
Domingo, 02 Junio 2024, 18:30
0 - 1
 5' Borja Sánchez
Ager Aketxe 25'
1 - 1
Sergio León 39'
2 - 1
2 - 2
 81' Borja Bastón
José Corpas 83'
3 - 2
Stoichkov 90'
4 - 2
4 - 3
 97' Borja Bastón

Eventos del partido

Goles

minuto 5'Borja SánchezGol de Borja Sánchez
Ager AketxeGol de penalti
Ager Aketxe
minuto 25'
Sergio LeónGol de
Sergio León
minuto 39'
minuto 81'Borja BastónGol de Borja Bastón
José CorpasGol de
José Corpas
minuto 83'
StoichkovGol de
Stoichkov
minuto 90'
minuto 97'Borja BastónGol de Borja Bastón

Tarjetas

minuto 25'PaulinoT. Amarilla Paulino
minuto 80'Jaime SeoaneT. Amarilla Jaime Seoane
José CorpasT. Amarilla
José Corpas
minuto 87'
Rober CorreaT. Amarilla
Rober Correa
minuto 89'

Ocasiones

StoichkovGol anulado
Stoichkov
minuto 36'

Cambios

minuto 46'MascaSale del partido Masca
minuto 46'J. DubasinEntra en el partido J. Dubasin
minuto 66'Sebas MoyanoEntra en el partido Sebas Moyano
minuto 66'PaulinoSale del partido Paulino
minuto 66'Borja SánchezSale del partido Borja Sánchez
minuto 66'Borja BastónEntra en el partido Borja Bastón
Sergio LeónSale del partido
Sergio León
minuto 69'
Rober CorreaEntra en el partido
Rober Correa
minuto 69'
Mario SorianoSale del partido
Mario Soriano
minuto 74'
A. MadariagaEntra en el partido
A. Madariaga
minuto 74'
Sergio ÁlvarezEntra en el partido
Sergio Álvarez
minuto 75'
Ager AketxeSale del partido
Ager Aketxe
minuto 75'
minuto 76'Carlos PomaresSale del partido Carlos Pomares
minuto 76'Abel BretonesEntra en el partido Abel Bretones
Unai VencedorEntra en el partido
Unai Vencedor
minuto 84'
F. VenâncioSale del partido
F. Venâncio
minuto 84'
J. RíosEntra en el partido
J. Ríos
minuto 85'
CristianSale del partido
Cristian
minuto 85'
minuto 86'AlemãoSale del partido Alemão
minuto 86'Álex MillánEntra en el partido Álex Millán

Otros

minuto 5'Viti RozadaAsistencia Viti Rozada
CristianAsistencia
Cristian
minuto 39'
minuto 81'AlemãoAsistencia Alemão
CristianAsistencia
Cristian
minuto 83'
Unai VencedorAsistencia
Unai Vencedor
minuto 90'
minuto 97'Sebas MoyanoAsistencia Sebas Moyano
minuto 23'PaulinoPenalti cometido Paulino

Alineaciones

Eibar

Eibar

4-5-1
Alineación Inicial
Suplentes
Real Oviedo

Real Oviedo

4-5-1
Alineación Inicial
Suplentes

Estadísticas del partido

Eibar Eibar Real Oviedo Real Oviedo
48%
Posesión del balón
 51%
4
Goles
 3
11
Tiros a puerta
 5
5
Tiros fuera
 12
20
Total tiros
 22
2
Paradas del portero
 7
7
Saques de esquina
 5
2
Fueras de juego
 3
0
Tarjetas Rojas
 0
3
Asistencias
 3
3
Sustituciones
 3
8
Faltas
 9
0
Penalti cometido
 1

Partido televisado en...
Canal Medio Idioma País
Amazon Prime VideoAmazon Prime Video TV Castellano es
DAZNDAZN TV Castellano es
LaLiga TV HypermotionLaLiga TV Hypermotion TV Castellano es
LaLiga TV BarLaLiga TV Bar TV Castellano es
LaLiga TV Hypermotion 2LaLiga TV Hypermotion 2 TV Castellano es
LaLiga TV M2LaLiga TV M2 TV Castellano es
Movistar Plus+ 2Movistar Plus+ 2 TV Castellano es
M+ LaLiga TVM+ LaLiga TV TV Castellano es
DGODGO TV - pe
DSportsDSports TV - pe
DGODGO TV - uy
DSportsDSports TV - uy

  USO DE MEMORIA  
7,421,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Match / Index )  0.4531
Total Execution Time  0.4545
  CADENA URL  
/partido/Eibar/Real-Oviedo/2018?section=legal
  GET DATOS  
$_GET['/partido/Eibar/Real-Oviedo/2018']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0163   SELECT c.*, c.stadium as real_stadium, 2024 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2024 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Eibar' AND dt2.basealias = 'Real-Oviedo'
0.0129  SELECT c.*, 2024 AS year, dt1.id AS dteam1_id, dt1.nameShow AS team1_name, dt1.basealias AS team1_basealias, dt1.fullName AS team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow AS team2_name, dt2.basealias AS team2_basealias, dt2.fullName AS team2_fullName, dt2.color1 AS team2_color1, t1.name AS team1_Oname, t2.name AS team2_Oname, s.id AS stadium_id, dt1.id AS stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2024 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Eibar' AND dt2.basealias = 'Real-Oviedo'
0.0109   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2024 AS ev WHERE ev.match_id=61215 ORDER BY (ev.action=1 OR ev.action=2 OR ev.action=6 OR ev.action=11 OR ev.action=12 OR ev.action=13) DESC,(ev.action=3 OR ev.action=4 OR ev.action=5) DESC,(ev.action=14 OR ev.action=15 OR ev.action=16 OR ev.action=17 OR ev.action=21) DESC,(ev.action=18 OR ev.action=19) DESC,(ev.action=20 OR ev.action=22) DESC, minute ASC, ev.real_date ASC, ev.id DESC, ev.action DESC
0.0124   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=72177 WHERE dp.id IN (222397,124623,82139,33665,116633,196831,314124,245395,108894,881449,875988,176275,852275,991675,62271,146823,873214,556622,178130,40798,630261,652752,325849,235191) AND (rp.team_id=6584336 OR rp.team_id=6584344)
0.0106   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2024 AS ev WHERE ev.match_id=61215 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0115   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=72177 WHERE dp.id IN (222397,235191,314124,124623,196831,82139,630261,881449,875988,176275,33665,108894,852275,991675,62271,146823,873214,245395,652752,116633,556622,178130,40798,325849) AND (rp.team_id=6584336 OR rp.team_id=6584344)
0.0105  SELECT data1 FROM stats2024 t WHERE league_id = 72177 AND teamId = 6584336 and type = 33
0.0104  SELECT data1 FROM stats2024 t WHERE league_id = 72177 AND teamId = 6584344 and type = 33
0.0107  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '61215' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 61215 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 61215 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0105  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='61215' AND `active` = 1 AND year = 2024
0.0182  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='72177' AND relp.team_id=6584336 WHERE relp.in_squad=1 and mp.`match_id` = '61215' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0184  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='72177' AND relp.team_id=6584344 WHERE relp.in_squad=1 and mp.`match_id` = '61215' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61215 AND extraId = 72177 AND type_rel = 4
0.0116  SELECT /*115 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points,u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' INNER JOIN bs_news_rel rel ON rel.newId = n.id AND rel.type_rel = 4 AND rel.typeId = 61215 AND rel.extraId = 72177 WHERE n.status = 1 AND n.ln='es' AND n.creation_date>'2024-04-03 18:30:00' AND n.creation_date<'2024-06-03 15:27:12' GROUP BY n.id ORDER BY n.cover_points DESC,n.creation_date DESC LIMIT 5
0.0105  SELECT * FROM futbol.calendars_lineups WHERE id = 61215 AND league_id = 72177 AND year = 2024