4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Tenerife - Celta
Jornada 5
FINALIZADO
20
30
2401 Pts. Elo
11º

2125 Pts. Elo
13º

0-0
Domingo, 03 Octubre 1993, 00:00

Eventos del partido

Tarjetas

Percy OlivaresT. Amarilla
Percy Olivares
minuto
minuto SalvaT. Amarilla Salva
minuto LuizinhoT. Amarilla Luizinho
minuto Santiago CañizaresT. Amarilla Santiago Cañizares
Ezequiel CastilloT. Amarilla
Ezequiel Castillo
minuto

Cambios

Julio LlorenteEntra en el partido
Julio Llorente
minuto 19'
C. AguileraSale del partido
C. Aguilera
minuto 19'
minuto 63'GudeljEntra en el partido Gudelj
minuto 63'LosadaSale del partido Losada
minuto 63'RatkovicSale del partido Ratkovic
minuto 63'LuizinhoEntra en el partido Luizinho
D. LatorreEntra en el partido
D. Latorre
minuto 70'
PinillaSale del partido
Pinilla
minuto 70'

Alineaciones

Tenerife

Tenerife

4-4-2
Alineación Inicial
Suplentes
Celta

Celta

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,724,824 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3921
Total Execution Time  0.3931
  CADENA URL  
/partido/Tenerife/Celta/1994
  GET DATOS  
$_GET['/partido/Tenerife/Celta/1994']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0044  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=47 AND rdh.league_id=166 ORDER BY rdh.team ASC, rdh.pos ASC, dp.nick ASC
0.0025  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '47' and rp.type = 1994 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0024  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 47 AND year = 1994 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 47 AND year = 1994 AND channel = 'Footters' LIMIT 1
0.0113  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='47' AND `active` = 1 AND year = 1994
0.0096  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='166' AND relp.team_id=4761 WHERE relp.in_squad=1 and mp.`match_id` = '47' AND mp.year='1994' ORDER BY mp.`team` ASC, p.`role` ASC
0.0028  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='166' AND relp.team_id=4772 WHERE relp.in_squad=1 and mp.`match_id` = '47' AND mp.year='1994' ORDER BY mp.`team` ASC, p.`role` ASC
0.0019  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '166' AND id_match = '47'
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=47 AND extraId = 166 AND type_rel = 4
0.2611  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0029  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1317335,1317332,1317322,1278031,1317324) ORDER BY n.cover_points DESC, update_date DESC
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 47 AND league_id = 166 AND year = 1994