¿Eres mayor de edad?

SI NO

Confirma si tienes 18 años

Faldón apuestas
4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Real Oviedo - Granada
Jornada 15
FINALIZADO
31
20
1216 Pts. Elo
28%
16º

1755 Pts. Elo
72%
8º

1-0
Domingo, 06 Noviembre 2022, 16:15
Sergi Enrich 80'
1 - 0

Eventos del partido

Goles

Sergi EnrichGol de
Sergi Enrich
minuto 80'

Tarjetas

minuto 17'Alberto PereaT. Amarilla Alberto Perea
A. AcevesTarjeta Roja a
A. Aceves
minuto 39'
Samu ObengT. Amarilla
Samu Obeng
minuto 45'
Ángel MontoroT. Amarilla
Ángel Montoro
minuto 45'
minuto 63'Víctor DíazT. Amarilla Víctor Díaz
Quentin BraatT. Amarilla
Quentin Braat
minuto 87'

Ocasiones

David CostasTiro al palo
David Costas
minuto 12'
minuto 42'José CallejónTiro al palo José Callejón

Cambios

minuto 23'Óscar MelendoEntra en el partido Óscar Melendo
minuto 23'Yann BodigerSale del partido Yann Bodiger
Jimmy SuárezEntra en el partido
Jimmy Suárez
minuto 46'
Samu ObengSale del partido
Samu Obeng
minuto 46'
minuto 59'Antonio PuertasEntra en el partido Antonio Puertas
minuto 59'Bryan ZaragozaSale del partido Bryan Zaragoza
minuto 59'Myrto UzuniEntra en el partido Myrto Uzuni
minuto 59'José CallejónSale del partido José Callejón
Sergi EnrichEntra en el partido
Sergi Enrich
minuto 59'
Borja BastónSale del partido
Borja Bastón
minuto 59'
minuto 75'Jonathan SilvaEntra en el partido Jonathan Silva
minuto 75'Carlos NevaSale del partido Carlos Neva
minuto 75'Matías ArezoEntra en el partido Matías Arezo
minuto 75'Alberto PereaSale del partido Alberto Perea
MangelEntra en el partido
Mangel
minuto 92'
Ángel MontoroSale del partido
Ángel Montoro
minuto 92'

Otros

minuto 22'Yann BodigerLesionado Yann Bodiger
Lucas AhijadoAsistencia
Lucas Ahijado
minuto 80'

Alineaciones

Real Oviedo

Real Oviedo

4-4-2
Alineación Inicial
Suplentes
Granada

Granada

4-5-1
Alineación Inicial
Suplentes

Estadísticas del partido

Real Oviedo Real Oviedo Granada Granada
28%
Posesión del balón
 72%
1
Goles
 0
1
Tiros a puerta
 3
2
Tiros fuera
 13
3
Total tiros
 16
3
Paradas del portero
 0
1
Saques de esquina
 7
3
Tarjetas Amarillas
 2
1
Tarjetas Rojas
 0
1
Asistencias
 0
1
Tiros al palo
 1
0
Lesiones
 1
3
Sustituciones
 3
10
Faltas
 10

Partido televisado en...
Canal Medio Idioma País
LaLiga SmartBank TVLaLiga SmartBank TV TV Castellano es
Movistar+ LiteMovistar+ Lite TV Castellano es
Star+Star+ TV Latino cl
Star+Star+ TV Latino bo

  USO DE MEMORIA  
7,382,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Match / Index )  0.4794
Total Execution Time  0.4810
  CADENA URL  
/partido/Real-Oviedo/Granada/1978?section=legal
  GET DATOS  
$_GET['/partido/Real-Oviedo/Granada/1978']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0151   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 = 'Real-Oviedo' AND dt2.basealias = 'Granada'
0.0144   SELECT c.*, c.stadium as real_stadium, 2025 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 calendars2025 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 = 'Real-Oviedo' AND dt2.basealias = 'Granada'
0.0107  SELECT data1 FROM stats2023 t WHERE league_id = 67780 AND teamId = 6516902 and type = 33
0.0107  SELECT data1 FROM stats2023 t WHERE league_id = 67780 AND teamId = 6516891 and type = 33
0.0112  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '49728' and rp.type = 2023 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 = 49728 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0106  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 49728 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0105  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='49728' AND `active` = 1 AND year = 2023
0.0202  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='67780' AND relp.team_id=6516902 WHERE relp.in_squad=1 and mp.`match_id` = '49728' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0192  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='67780' AND relp.team_id=6516891 WHERE relp.in_squad=1 and mp.`match_id` = '49728' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0106  SELECT * FROM futbol.calendars_lineups WHERE id = 49728 AND league_id = 67780 AND year = 2023