4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Rosenborg BK - Stabæk
FINALIZADO
00
00
1660 Pts. Elo

1330 Pts. Elo
12º

2-0
Miércoles, 05 Mayo 2010, 19:00
  • Asistencia: 14.794 espectadores
R. Prica 11'
1 - 0
R. Prica 47'
2 - 0

Eventos del partido

Goles

R. PricaGol de
R. Prica
minuto 11'
R. PricaGol de
R. Prica
minuto 47'

Cambios

minuto 59'T. StenvollEntra en el partido T. Stenvoll
minuto 59'V. GunnarssonSale del partido V. Gunnarsson
A. TraoréEntra en el partido
A. Traoré
minuto 66'
P. SkjelbredSale del partido
P. Skjelbred
minuto 66'
minuto 76'E. HoffSale del partido E. Hoff
minuto 76'Bernt HulskerEntra en el partido Bernt Hulsker
K. SellinEntra en el partido
K. Sellin
minuto 78'
F. WinsnesSale del partido
F. Winsnes
minuto 78'
Trond OlsenEntra en el partido
Trond Olsen
minuto 90'
R. PricaSale del partido
R. Prica
minuto 90'

Otros

M. LustigAsistencia
M. Lustig
minuto 11'
M. LustigAsistencia
M. Lustig
minuto 47'

No hay comentarios



  USO DE MEMORIA  
5,865,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.1277
Total Execution Time  0.1287
  CADENA URL  
/partido/Rosenborg-Bk/Stabaek-If/2010
  GET DATOS  
$_GET['/partido/Rosenborg-Bk/Stabaek-If/2010']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0020  SELECT data1 FROM stats2010 t WHERE league_id = 1037 AND teamId = 23289 and type = 33
0.0019  SELECT data1 FROM stats2010 t WHERE league_id = 1037 AND teamId = 23281 and type = 33
0.0023  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '127870' and rp.type = 2010 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 = 127870 AND year = 2010 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 127870 AND year = 2010 AND channel = 'Footters' LIMIT 1
0.0020  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='127870' AND `active` = 1 AND year = 2010
0.0163  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='1037' AND relp.team_id=23289 WHERE relp.in_squad=1 and mp.`match_id` = '127870' AND mp.year='2010' ORDER BY mp.`team` ASC, p.`role` ASC
0.0121  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='1037' AND relp.team_id=23281 WHERE relp.in_squad=1 and mp.`match_id` = '127870' AND mp.year='2010' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=127870 AND extraId = 1037 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18 AND type_rel = 3
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 127870 AND league_id = 1037 AND year = 2010