4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Celta - Málaga
Jornada 26
FINALIZADO
30
40
2826 Pts. Elo
4º

2022 Pts. Elo
13º

0-0
Domingo, 17 Febrero 2002, 20:00

Eventos del partido

Tarjetas

P. LuccinT. Amarilla
P. Luccin
minuto 10'
E. GiovanellaT. Amarilla
E. Giovanella
minuto 19'
minuto 28'M. RomeroT. Amarilla M. Romero
F. CáceresT. Amarilla
F. Cáceres
minuto 35'
minuto 59'JosemiT. Amarilla Josemi
minuto 90'CanabalT. Amarilla Canabal
minuto 90'Miguel ÁngelT. Amarilla Miguel Ángel

Cambios

minuto 63'EdgarSale del partido Edgar
minuto 63'ZárateEntra en el partido Zárate
V. KarpinEntra en el partido
V. Karpin
minuto 67'
E. GiovanellaSale del partido
E. Giovanella
minuto 67'
DorivaEntra en el partido
Doriva
minuto 67'
P. LuccinSale del partido
P. Luccin
minuto 67'
JesuliSale del partido
Jesuli
minuto 75'
Florian MauriceEntra en el partido
Florian Maurice
minuto 75'
minuto 76'CanabalEntra en el partido Canabal
minuto 76'Darío SilvaSale del partido Darío Silva
minuto 85'Dely ValdésSale del partido Dely Valdés
minuto 85'I. LekoEntra en el partido I. Leko

Alineaciones

Celta

Celta

Alineación Inicial
Suplentes
Málaga

Málaga

5-3-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,908,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.0843
Total Execution Time  0.0853
  CADENA URL  
/partido/Celta/Malaga/2002
  GET DATOS  
$_GET['/partido/Celta/Malaga/2002']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0022  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=561 AND rdh.league_id=37 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 = '561' 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 = 561 AND year = 2002 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 561 AND year = 2002 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='561' AND `active` = 1 AND year = 2002
0.0091  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` = '561' AND mp.year='2002' ORDER BY mp.`team` ASC, p.`role` ASC
0.0031  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=1629 WHERE relp.in_squad=1 and mp.`match_id` = '561' AND mp.year='2002' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=561 AND extraId = 37 AND type_rel = 4
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 561 AND league_id = 37 AND year = 2002