4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Luzern - Aarau
Jornada 30
FINALIZADO
00
20
1124 Pts. Elo
11º

952 Pts. Elo
2º

1-2
Miércoles, 19 Junio 1985, 20:00
  • Asistencia: 6.350 espectadores
Remo Halter 11'
1 - 0
1 - 1
 16' Agapios Kaltaveridis
1 - 2
 28' Remo Halter

Eventos del partido

Goles

Remo HalterGol de
Remo Halter
minuto 11'
minuto 16'Agapios KaltaveridisGol de Agapios Kaltaveridis
minuto 28' Remo Halter Gol de (p.p)
Remo Halter

Tarjetas

minuto Walter SeilerT. Amarilla Walter Seiler
minuto Agapios KaltaveridisT. Amarilla Agapios Kaltaveridis

Cambios

Roland WidmerEntra en el partido
Roland Widmer
minuto 46'
Daniel WildisenSale del partido
Daniel Wildisen
minuto 46'
Bruno MartinelliSale del partido
Bruno Martinelli
minuto 65'
T. WyssEntra en el partido
T. Wyss
minuto 65'
minuto 80'Roberto FregnoSale del partido Roberto Fregno
minuto 80'Thomas ZwahlenSale del partido Thomas Zwahlen
minuto 80'Patrick TaudienEntra en el partido Patrick Taudien
minuto 80'Peter MartiEntra en el partido Peter Marti

Alineaciones

Luzern

Luzern

4-4-2
Alineación Inicial
Suplentes
Aarau

Aarau

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,805,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3754
Total Execution Time  0.3764
  CADENA URL  
/partido/Luzern/Fc-Aarau/1985
  GET DATOS  
$_GET['/partido/Luzern/Fc-Aarau/1985']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0128  SELECT data1 FROM stats1985 t WHERE league_id = 29644 AND teamId = 6217772 and type = 33
0.0124  SELECT data1 FROM stats1985 t WHERE league_id = 29644 AND teamId = 6217766 and type = 33
0.0127  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '16212' and rp.type = 1985 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 16212 AND year = 1985 AND channel = 'Footters' LIMIT 1
0.0127  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 16212 AND year = 1985 AND channel = 'Footters' LIMIT 1
0.0125  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='16212' AND `active` = 1 AND year = 1985
0.0131  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='29644' AND relp.team_id=6217772 WHERE relp.in_squad=1 and mp.`match_id` = '16212' AND mp.year='1985' ORDER BY mp.`team` ASC, p.`role` ASC
0.0129  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='29644' AND relp.team_id=6217766 WHERE relp.in_squad=1 and mp.`match_id` = '16212' AND mp.year='1985' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16212 AND extraId = 29644 AND type_rel = 4
0.0125  SELECT rating1, rating2 FROM calendars_elo WHERE id=16212 AND league_id=29644 AND year=1985
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 16212 AND league_id = 29644 AND year = 1985