4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Real Jaén - Numancia
Jornada 17
FINALIZADO
20
50
1076 Pts. Elo
13º

1445 Pts. Elo
15º

1-2
Sábado, 01 Diciembre 2001, 00:00
0 - 1
 16' Ojeda
0 - 2
 42' Curro Montoya
Pepelu 89'
1 - 2

Eventos del partido

Goles

minuto 16'OjedaGol de penalti Ojeda
minuto 42' Curro Montoya Gol de (p.p)
Curro Montoya
PepeluGol de penalti
Pepelu
minuto 89'

Tarjetas

Luis LópezT. Amarilla
Luis López
minuto
minuto L. RosuT. Amarilla L. Rosu
J. ZahínosT. Amarilla
J. Zahínos
minuto
minuto CulebrasT. Amarilla Culebras
minuto GustavoT. Amarilla Gustavo
minuto JaumeT. Amarilla Jaume
minuto Álvaro NúñezT. Amarilla Álvaro Núñez

Cambios

ChumillaEntra en el partido
Chumilla
minuto 45'
PucheSale del partido
Puche
minuto 45'
RuedaEntra en el partido
Rueda
minuto 60'
Carlos TorresSale del partido
Carlos Torres
minuto 60'
NonoSale del partido
Nono
minuto 68'
minuto 68'L. RosuSale del partido L. Rosu
PepeluEntra en el partido
Pepelu
minuto 68'
minuto 68'ElíasEntra en el partido Elías
minuto 73'OjedaSale del partido Ojeda
minuto 73'AlbertoEntra en el partido Alberto
minuto 86'Curro VacasSale del partido Curro Vacas
minuto 86'OctavioEntra en el partido Octavio

Alineaciones

Real Jaén

Real Jaén

4-4-2
Alineación Inicial
Suplentes
Numancia

Numancia

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,852,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.1678
Total Execution Time  0.1688
  CADENA URL  
/partido/Real-Jaen/Numancia/2002
  GET DATOS  
$_GET['/partido/Real-Jaen/Numancia/2002']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0025  SELECT rdh.pos, rdh.playerId AS player_id, rdh.team, dp.alias, dp.role, dp.name, dp.nick, dp.last_name, '' AS num FROM rel_dreamteam_historical AS rdh INNER JOIN dataplayers AS dp ON rdh.playerId=dp.id WHERE rdh.match_id=4751 AND rdh.league_id=574 ORDER BY rdh.team ASC, rdh.pos ASC, dp.nick ASC
0.0022  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '4751' and rp.type = 2002 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 = 4751 AND year = 2002 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 4751 AND year = 2002 AND channel = 'Footters' LIMIT 1
0.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='4751' AND `active` = 1 AND year = 2002
0.0021  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='574' AND relp.team_id=14204 WHERE relp.in_squad=1 and mp.`match_id` = '4751' AND mp.year='2002' ORDER BY mp.`team` ASC, p.`role` ASC
0.0023  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='574' AND relp.team_id=14209 WHERE relp.in_squad=1 and mp.`match_id` = '4751' AND mp.year='2002' ORDER BY mp.`team` ASC, p.`role` ASC
0.0019  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '574' AND id_match = '4751'
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4751 AND extraId = 574 AND type_rel = 4
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 4751 AND league_id = 574 AND year = 2002