4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Real Jaén - Pvo. El Ejido
Jornada 17
FINALIZADO
30
10
177 Pts. Elo
5º

138 Pts. Elo
15º

0-0
Domingo, 14 Enero 2024, 12:00

Eventos del partido

Tarjetas

Pablo De CastroT. Amarilla
Pablo De Castro
minuto 5'
Juanma PorroT. Amarilla
Juanma Porro
minuto 58'
minuto 67'Toni BadiaT. Amarilla Toni Badia
Javi MoyanoT. Amarilla
Javi Moyano
minuto 86'

Cambios

minuto 46'C. RomeroEntra en el partido C. Romero
minuto 46'R. FigueroaSale del partido R. Figueroa
minuto 58'A. NavarroEntra en el partido A. Navarro
minuto 58'Pablo MontesSale del partido Pablo Montes
F. RodríguezEntra en el partido
F. Rodríguez
minuto 61'
O. LozanoSale del partido
O. Lozano
minuto 61'
Pablo De CastroSale del partido
Pablo De Castro
minuto 61'
MauroEntra en el partido
Mauro
minuto 61'
Juanma PorroSale del partido
Juanma Porro
minuto 68'
minuto 68'D. SalasSale del partido D. Salas
Adrián RuizEntra en el partido
Adrián Ruiz
minuto 68'
Mario MartosSale del partido
Mario Martos
minuto 68'
minuto 68'J. LopezEntra en el partido J. Lopez
JuanpeEntra en el partido
Juanpe
minuto 68'
Javi MoyanoEntra en el partido
Javi Moyano
minuto 83'
CanceloSale del partido
Cancelo
minuto 83'
minuto 84'BrianSale del partido Brian
minuto 84'Iván FerrerEntra en el partido Iván Ferrer

Alineaciones

Real Jaén

Real Jaén

4-4-2
Alineación Inicial
Suplentes
Pvo. El Ejido

Pvo. El Ejido

4-4-2
Alineación Inicial
Suplentes


Partido televisado en...
Canal Medio Idioma País
7 TV Jaén7 TV Jaén TV Castellano es
Web DirectoWeb Directo WEB Castellano es

  USO DE MEMORIA  
6,849,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.2914
Total Execution Time  0.2926
  CADENA URL  
/partido/Real-Jaen/Cd-El-Ejido/2024?section=legal
  GET DATOS  
$_GET['/partido/Real-Jaen/Cd-El-Ejido/2024']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72268 AND teamId = 6586265 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72268 AND teamId = 6586258 and type = 33
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '456388' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 456388 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 456388 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0041  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72268 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='456388' AND `active` = 1 AND year = 2024
0.0080  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='72268' AND relp.team_id=6586265 WHERE relp.in_squad=1 and mp.`match_id` = '456388' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0057  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='72268' AND relp.team_id=6586258 WHERE relp.in_squad=1 and mp.`match_id` = '456388' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=456388 AND extraId = 72268 AND type_rel = 4
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 456388 AND league_id = 72268 AND year = 2024