4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
CD Teruel - Rayo Majadahonda
Jornada 26
FINALIZADO
40
30
411 Pts. Elo
19º

458 Pts. Elo
20º

1-0
Sábado, 02 Marzo 2024, 18:00
Borja Martínez 30'
1 - 0

CD Teruel

4-5-1
Alineación Inicial
Suplentes

Rayo Majadahonda

4-5-1
Alineación Inicial
Suplentes

Eventos del partido

Goles

Gol de
Borja Martínez
minuto 30'

Tarjetas

minuto 27'T. Amarilla Alberto Fernández
minuto 33'T. Amarilla Sergi García
T. Amarilla
Victor Sanchis
minuto 47'
minuto 61'T. Amarilla Raúl Tavares
T. Amarilla
Nacho Castillo
minuto 73'
T. Amarilla
Fran Tena
minuto 78'
T. Amarilla
Julen
minuto 95'

Ocasiones

minuto 88'Tiro al palo Rubén Enri

Cambios

minuto 58'Entra en el partido J. Cortés
minuto 58'Sale del partido Pablo Pérez
Entra en el partido
Facu García
minuto 64'
Sale del partido
Borja Romero
minuto 64'
Entra en el partido
G. Naranjo
minuto 71'
Sale del partido
Toni Gabarre
minuto 71'
minuto 78'Entra en el partido Samu Expósito
minuto 78'Sale del partido Pelayo Suárez
Entra en el partido
Villa
minuto 81'
Sale del partido
David Aparicio
minuto 81'
minuto 88'Entra en el partido Jeisson Martínez
minuto 88'Sale del partido Sergi García
minuto 88'Entra en el partido Rubén Enri
minuto 88'Sale del partido Raúl Tavares

Otros

Asistencia
David Aparicio
minuto 30'

Estadísticas del partido

CD Teruel CD Teruel Rayo Majadahonda Rayo
1
Goles
 0
3
Tarjetas Amarillas
 2
0
Tarjetas Rojas
 0
1
Asistencias
 0
0
Tiros al palo
 1
3
Sustituciones
 3
0 Comentarios + 2 respuestas

No hay comentarios


Partido televisado en...
Canal Medio Idioma País
FEF TV TV Castellano

  USO DE MEMORIA  
6,992,136 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Match / Index )  0.3428
Total Execution Time  0.3442
  CADENA URL  
/partido/Teruel/Rayo-Majadahonda
  GET DATOS  
$_GET['/partido/Teruel/Rayo-Majadahonda']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72358 AND teamId = 6587545 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72358 AND teamId = 6587547 and type = 33
0.0019  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '193478' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 193478 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 193478 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='193478' AND `active` = 1 AND year = 2024
0.0064  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='72358' AND relp.team_id=6587545 WHERE relp.in_squad=1 and mp.`match_id` = '193478' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0065  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='72358' AND relp.team_id=6587547 WHERE relp.in_squad=1 and mp.`match_id` = '193478' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=193478 AND extraId = 72358 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2468 AND type_rel = 3
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 193478 AND league_id = 72358 AND year = 2024