4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Nenzing - Egg
Jornada 7
FINALIZADO
20
10
152 Pts. Elo
10º

169 Pts. Elo
14º

0-0
Sábado, 17 Septiembre 2011, 16:00

Eventos del partido

Tarjetas

A. SimonerT. Amarilla
A. Simoner
minuto 27'
minuto 34'E. MeusburgerT. Amarilla E. Meusburger
Michael ZechT. Amarilla
Michael Zech
minuto 76'

Cambios

minuto 73'Markus MeusburgerSale del partido Markus Meusburger
minuto 73'Christian SchneiderEntra en el partido Christian Schneider
minuto 90'Christoph LangEntra en el partido Christoph Lang
minuto 90'M. MeusburgerSale del partido M. Meusburger

Alineaciones

Nenzing

Nenzing

4-4-2
Alineación Inicial
Suplentes
Egg

Egg

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,715,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.0873
Total Execution Time  0.0883
  CADENA URL  
/partido/Nenzing/Egg/2012
  GET DATOS  
$_GET['/partido/Nenzing/Egg/2012']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0020  SELECT data1 FROM stats2012 t WHERE league_id = 27222 AND teamId = 688549 and type = 33
0.0018  SELECT data1 FROM stats2012 t WHERE league_id = 27222 AND teamId = 688546 and type = 33
0.0022  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '265114' and rp.type = 2012 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 = 265114 AND year = 2012 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 265114 AND year = 2012 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='265114' AND `active` = 1 AND year = 2012
0.0037  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='27222' AND relp.team_id=688549 WHERE relp.in_squad=1 and mp.`match_id` = '265114' AND mp.year='2012' ORDER BY mp.`team` ASC, p.`role` ASC
0.0037  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='27222' AND relp.team_id=688546 WHERE relp.in_squad=1 and mp.`match_id` = '265114' AND mp.year='2012' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=265114 AND extraId = 27222 AND type_rel = 4
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 265114 AND league_id = 27222 AND year = 2012