4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Pierikos - Athinaikos
Jornada 11
FINALIZADO
30
40
248 Pts. Elo
16º

801 Pts. Elo
14º

0-3
Domingo, 29 Noviembre 1992, 00:00
0 - 1
 8' Mirosław Bąk
0 - 2
 76' Michalis Tsoumas
0 - 3
 80' Christos Dimopoulos

Eventos del partido

Goles

minuto 8'Mirosław BąkGol de Mirosław Bąk
minuto 76'Michalis TsoumasGol de Michalis Tsoumas
minuto 80'Christos DimopoulosGol de Christos Dimopoulos

Tarjetas

minuto 46'Damir ŠpicaT. Amarilla Damir Špica
minuto 46'Kostas TheodorakosT. Amarilla Kostas Theodorakos
Konstantinos MavridisT. Amarilla
Konstantinos Mavridis
minuto 46'
minuto 46'Dimitrios ThanopoulosT. Amarilla Dimitrios Thanopoulos
Panagiotis KonstantinidisT. Amarilla
Panagiotis Konstantinidis
minuto 46'
minuto 46'Michalis TsoumasT. Amarilla Michalis Tsoumas
Angelo KoutosT. Amarilla
Angelo Koutos
minuto 46'

Cambios

Giannis MakridisEntra en el partido
Giannis Makridis
minuto 37'
Stefanos TavouktsisSale del partido
Stefanos Tavouktsis
minuto 37'
Konstantinos MavridisEntra en el partido
Konstantinos Mavridis
minuto 46'
K. KonstantinidisSale del partido
K. Konstantinidis
minuto 46'
minuto 81'Konstantinos TsiavaliasEntra en el partido Konstantinos Tsiavalias
minuto 81'Christos DimopoulosSale del partido Christos Dimopoulos
minuto 83'Mirosław BąkSale del partido Mirosław Bąk
minuto 83'Michalis AlvertisEntra en el partido Michalis Alvertis

Alineaciones

Pierikos

Pierikos

4-4-2
Alineación Inicial
Suplentes
Athinaikos

Athinaikos

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,828,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.1032
Total Execution Time  0.1042
  CADENA URL  
/partido/Pierikos/Athinaikos/1993
  GET DATOS  
$_GET['/partido/Pierikos/Athinaikos/1993']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0018  SELECT data1 FROM stats1993 t WHERE league_id = 29004 AND teamId = 6200423 and type = 33
0.0018  SELECT data1 FROM stats1993 t WHERE league_id = 29004 AND teamId = 6200411 and type = 33
0.0021  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '25923' and rp.type = 1993 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 = 25923 AND year = 1993 AND channel = 'Footters' LIMIT 1
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 25923 AND year = 1993 AND channel = 'Footters' LIMIT 1
0.0040  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1993` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 29004 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='25923' AND `active` = 1 AND year = 1993
0.0044  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='29004' AND relp.team_id=6200423 WHERE relp.in_squad=1 and mp.`match_id` = '25923' AND mp.year='1993' ORDER BY mp.`team` ASC, p.`role` ASC
0.0060  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='29004' AND relp.team_id=6200411 WHERE relp.in_squad=1 and mp.`match_id` = '25923' AND mp.year='1993' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25923 AND extraId = 29004 AND type_rel = 4
0.0018  SELECT rating1, rating2 FROM calendars_elo WHERE id=25923 AND league_id=29004 AND year=1993
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 25923 AND league_id = 29004 AND year = 1993