4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Alemania Sub 18 - Turquia Sub 18
Jornada 11
FINALIZADO
00
10
479 Pts. Elo

324 Pts. Elo

4-2
Martes, 16 Noviembre 2010, 00:00
S. Parker 19'
1 - 0
S. Kittel 36'
2 - 0
2 - 1
 50' O. Derici
2 - 2
 61' A. Akcakin
J. Geis 76'
3 - 2
R. Ngankam 82'
4 - 2

Eventos del partido

Goles

S. ParkerGol de
S. Parker
minuto 19'
S. KittelGol de
S. Kittel
minuto 36'
minuto 50'O. DericiGol de O. Derici
minuto 61'A. AkcakinGol de A. Akcakin
J. GeisGol de
J. Geis
minuto 76'
R. NgankamGol de penalti
R. Ngankam
minuto 82'

Tarjetas

minuto 46'O. AzgarT. Amarilla O. Azgar

Cambios

N. FüllkrugEntra en el partido
N. Füllkrug
minuto 46'
J. GeisEntra en el partido
J. Geis
minuto 46'
P. SchmidtSale del partido
P. Schmidt
minuto 46'
D. Da CostaSale del partido
D. Da Costa
minuto 46'
S. GärtnerEntra en el partido
S. Gärtner
minuto 64'
E. ZengaSale del partido
E. Zenga
minuto 64'
R. NgankamEntra en el partido
R. Ngankam
minuto 68'
M. MendlerSale del partido
M. Mendler
minuto 68'
BildiriciEntra en el partido
Bildirici
minuto 81'
S. ParkerSale del partido
S. Parker
minuto 81'
D. HeintzSale del partido
D. Heintz
minuto 87'
L. BittencourtEntra en el partido
L. Bittencourt
minuto 87'
A. HoffmannEntra en el partido
A. Hoffmann
minuto 87'
S. KittelSale del partido
S. Kittel
minuto 87'

Alineaciones

Alemania Sub 18

Alemania Sub 18

4-4-2
Alineación Inicial
Suplentes
Turquia Sub 18

Turquia Sub 18

4-4-2



  USO DE MEMORIA  
5,773,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.1079
Total Execution Time  0.1090
  CADENA URL  
/partido/Alemania-Sub-18/Turquia-Sub-18/2010
  GET DATOS  
$_GET['/partido/Alemania-Sub-18/Turquia-Sub-18/2010']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0021  SELECT data1 FROM stats2010 t WHERE league_id = 43831 AND teamId = 6188200 and type = 33
0.0020  SELECT data1 FROM stats2010 t WHERE league_id = 43831 AND teamId = 6188201 and type = 33
0.0024  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '235902' and rp.type = 2010 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 = 235902 AND year = 2010 AND channel = 'Footters' LIMIT 1
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 235902 AND year = 2010 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='235902' AND `active` = 1 AND year = 2010
0.0035  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='43831' AND relp.team_id=6188200 WHERE relp.in_squad=1 and mp.`match_id` = '235902' AND mp.year='2010' ORDER BY mp.`team` ASC, p.`role` ASC
0.0024  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='43831' AND relp.team_id=6188201 WHERE relp.in_squad=1 and mp.`match_id` = '235902' AND mp.year='2010' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=235902 AND extraId = 43831 AND type_rel = 4
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1990 AND type_rel = 3
0.0026  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1990 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1201248,1200785,1186209,1091815,1067523) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT rating1, rating2 FROM calendars_elo WHERE id=235902 AND league_id=43831 AND year=2010
0.0019  SELECT position FROM tables2010 WHERE team=6188200 AND league_id=43831 AND round=11
0.0018  SELECT position FROM tables2010 WHERE team=6188201 AND league_id=43831 AND round=11
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 235902 AND league_id = 43831 AND year = 2010