4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Real Zaragoza - Celta
Jornada 36
FINALIZADO
20
30
2530 Pts. Elo
19º

2816 Pts. Elo
4º

0-1
Domingo, 28 Abril 2002, 00:00
0 - 1
 54' Jesuli

Eventos del partido

Goles

minuto 54'JesuliGol de Jesuli

Tarjetas

P. JémezT. Amarilla
P. Jémez
minuto 60'
minuto 69'Gustavo LópezT. Amarilla Gustavo López
JuaneleT. Amarilla
Juanele
minuto 75'
minuto 77'CatanhaT. Amarilla Catanha
minuto 90'P. CavalleroT. Amarilla P. Cavallero

Cambios

GaritanoSale del partido
Garitano
minuto 55'
CoronaEntra en el partido
Corona
minuto 55'
Paulo JamelliEntra en el partido
Paulo Jamelli
minuto 60'
CuarteroSale del partido
Cuartero
minuto 60'
minuto 65'A. MostovoiSale del partido A. Mostovoi
minuto 65'J. VelascoEntra en el partido J. Velasco
minuto 71'EduEntra en el partido Edu
minuto 71'Gustavo LópezSale del partido Gustavo López
Marcos ValesSale del partido
Marcos Vales
minuto 74'
M. BilicEntra en el partido
M. Bilic
minuto 74'
minuto 89'CatanhaSale del partido Catanha
minuto 89'CoiraEntra en el partido Coira

Alineaciones

Real Zaragoza

Real Zaragoza

4-4-2
Alineación Inicial
Suplentes
Celta

Celta

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,916,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.2844
Total Execution Time  0.2854
  CADENA URL  
/partido/Real-Zaragoza/Celta/2002
  GET DATOS  
$_GET['/partido/Real-Zaragoza/Celta/2002']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0146  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=666 AND rdh.league_id=37 ORDER BY rdh.team ASC, rdh.pos ASC, dp.nick ASC
0.0146  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '666' and rp.type = 2002 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 666 AND year = 2002 AND channel = 'Footters' LIMIT 1
0.0144  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 666 AND year = 2002 AND channel = 'Footters' LIMIT 1
0.0145  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='666' AND `active` = 1 AND year = 2002
0.0154  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='37' AND relp.team_id=1628 WHERE relp.in_squad=1 and mp.`match_id` = '666' AND mp.year='2002' ORDER BY mp.`team` ASC, p.`role` ASC
0.0199  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='37' AND relp.team_id=1634 WHERE relp.in_squad=1 and mp.`match_id` = '666' AND mp.year='2002' ORDER BY mp.`team` ASC, p.`role` ASC
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=666 AND extraId = 37 AND type_rel = 4
0.0144  SELECT * FROM futbol.calendars_lineups WHERE id = 666 AND league_id = 37 AND year = 2002