¿Eres mayor de edad?

SI NO

Confirma si tienes 18 años

Faldón apuestas
4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Etzella Ettelbruck - Rumelange
FINALIZADO
10
41
266 Pts. Elo

238 Pts. Elo
10º

3-0
Jueves, 25 Marzo 2004, 00:00
C. Leweck 82'
1 - 0
Patrick Grettnich 84'
2 - 0

Eventos del partido

Goles

C. LeweckGol de
C. Leweck
minuto 82'
Patrick GrettnichGol de penalti
Patrick Grettnich
minuto 84'

Tarjetas

minuto 46'Antony SommenT. Amarilla Antony Sommen
C. FerreiraT. Amarilla
C. Ferreira
minuto 46'
minuto 46'Cyril DalsteinT. Amarilla Cyril Dalstein
minuto 46'Ernes MuhovicT. Amarilla Ernes Muhovic
minuto 46'Ludovic NeisT. Amarilla Ludovic Neis
minuto 83'K. RohmannTarjeta Roja a K. Rohmann

Cambios

minuto 42'Philippe DillmannSale del partido Philippe Dillmann
minuto 42'Fabrice MullerEntra en el partido Fabrice Muller
D. Alves Da MotaSale del partido
D. Alves Da Mota
minuto 50'
L. MischoEntra en el partido
L. Mischo
minuto 50'
minuto 75'R. SchaackEntra en el partido R. Schaack
minuto 75'M. BirsensSale del partido M. Birsens
minuto 84'J. WinckelEntra en el partido J. Winckel
minuto 84'Ludovic NeisSale del partido Ludovic Neis
P. PosingSale del partido
P. Posing
minuto 85'
G. EngeldingerEntra en el partido
G. Engeldinger
minuto 85'

Otros

minuto 42'Philippe DillmannLesionado Philippe Dillmann
minuto 75'M. BirsensLesionado M. Birsens
P. PosingAsistencia
P. Posing
minuto 82'

Alineaciones




  USO DE MEMORIA  
5,807,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.3496
Total Execution Time  0.3506
  CADENA URL  
/partido/Etzella-Ettelbruck/Rumelange/2004
  GET DATOS  
$_GET['/partido/Etzella-Ettelbruck/Rumelange/2004']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0105  SELECT data1 FROM stats2004 t WHERE league_id = 10731 AND teamId = 163999 and type = 33
0.0107  SELECT data1 FROM stats2004 t WHERE league_id = 10731 AND teamId = 164009 and type = 33
0.0107  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '31383' and rp.type = 2004 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 31383 AND year = 2004 AND channel = 'Footters' LIMIT 1
0.0106  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 31383 AND year = 2004 AND channel = 'Footters' LIMIT 1
0.0105  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='31383' AND `active` = 1 AND year = 2004
0.0127  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='10731' AND relp.team_id=163999 WHERE relp.in_squad=1 and mp.`match_id` = '31383' AND mp.year='2004' ORDER BY mp.`team` ASC, p.`role` ASC
0.0116  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='10731' AND relp.team_id=164009 WHERE relp.in_squad=1 and mp.`match_id` = '31383' AND mp.year='2004' ORDER BY mp.`team` ASC, p.`role` ASC
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=31383 AND extraId = 10731 AND type_rel = 4
0.0107  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=348 AND type_rel = 3
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 348 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0109  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 (900743,894718,835971,820066,738616) ORDER BY n.cover_points DESC, update_date DESC
0.0106  SELECT * FROM futbol.calendars_lineups WHERE id = 31383 AND league_id = 10731 AND year = 2004