4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Irlanda - Rusia
Jornada 3
FINALIZADO
00
10
1108 Pts. Elo

818 Pts. Elo

0-0
Miércoles, 23 Marzo 1994, 00:00

Eventos del partido

Tarjetas

minuto 85'Dmitri KuznetsovT. Amarilla Dmitri Kuznetsov

Cambios

P. BonnerSale del partido
P. Bonner
minuto 46'
A. KellyEntra en el partido
A. Kelly
minuto 46'
minuto 58'Í. KornéyevSale del partido Í. Kornéyev
minuto 58'D. CheryshevEntra en el partido D. Cheryshev
D. KellySale del partido
D. Kelly
minuto 65'
T. CoyneEntra en el partido
T. Coyne
minuto 65'
minuto 87'D. RadchenkoSale del partido D. Radchenko
minuto 87'A. KosolapovEntra en el partido A. Kosolapov

Alineaciones

Irlanda

Irlanda

4-4-2
Alineación Inicial
Suplentes
Rusia

Rusia

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,715,520 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.1020
Total Execution Time  0.1030
  CADENA URL  
/partido/Seleccion-Republica-Irlanda/Seleccion-Rusia/1994
  GET DATOS  
$_GET['/partido/Seleccion-Republica-Irlanda/Seleccion-Rusia/1994']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0019  SELECT data1 FROM stats1994 t WHERE league_id = 39432 AND teamId = 801902 and type = 33
0.0019  SELECT data1 FROM stats1994 t WHERE league_id = 39432 AND teamId = 801965 and type = 33
0.0021  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '30163' and rp.type = 1994 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 = 30163 AND year = 1994 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 30163 AND year = 1994 AND channel = 'Footters' LIMIT 1
0.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='30163' AND `active` = 1 AND year = 1994
0.0063  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='39432' AND relp.team_id=801902 WHERE relp.in_squad=1 and mp.`match_id` = '30163' AND mp.year='1994' ORDER BY mp.`team` ASC, p.`role` ASC
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='39432' AND relp.team_id=801965 WHERE relp.in_squad=1 and mp.`match_id` = '30163' AND mp.year='1994' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30163 AND extraId = 39432 AND type_rel = 4
0.0018  SELECT position FROM tables1994 WHERE team=801902 AND league_id=39432 AND round=3
0.0018  SELECT position FROM tables1994 WHERE team=801965 AND league_id=39432 AND round=3
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 30163 AND league_id = 39432 AND year = 1994