4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Olympiacos Piraeus

Olympiacos Piraeus

Entrenador: José Luis Mendilibar

Temporada 1993/1994
TEMPORADA 1993/1994
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 34 63 28 79
2 Panathinaikos Panathinaiko 34 82 32 72
3 Olympiacos Piraeus Olympiacos 34 63 27 68
4 Aris Thessaloniki Aris 34 55 34 63
5 PAOK PAOK 34 45 38 51
6 Iraklis Thessaloniki Iraklis 34 59 45 49
7 OFI OFI 34 55 42 47
8 Xanthi Xanthi 34 62 63 45
9 Panionios Panionios 34 49 58 43
10 Levadiakos Levadiakos 34 38 45 42
11 AE Larisa AE Larisa 34 45 53 42
12 Apollon Smyrnis Apollon 34 30 41 40
13 Athinaikos Athinaikos 34 34 50 40
14 Edessaikos Edessaikos 34 41 56 39
15 Doxa Dramas Doxa Dramas 34 37 64 38
16 Panachaiki Panachaiki 34 36 56 37
17 Apollon Pontou Apollon 34 42 66 32
18 FAS Naousa FAS Naousa 34 38 76 18
TEMPORADA 1992/1993
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 34 78 27 78
2 Panathinaikos Panathinaiko 34 85 21 77
3 Olympiacos Piraeus Olympiacos 34 68 31 68
4 OFI OFI 34 64 32 66
5 PAOK PAOK 34 52 38 57
6 Iraklis Thessaloniki Iraklis 34 51 41 56
7 AE Larisa AE Larisa 34 36 42 43
8 Xanthi Xanthi 34 56 66 42
9 Aris Thessaloniki Aris 34 40 50 42
10 Panachaiki Panachaiki 34 41 50 39
11 Athinaikos Athinaikos 34 27 37 39
12 Apollon Smyrnis Apollon 34 27 49 37
13 Doxa Dramas Doxa Dramas 34 34 57 36
14 Apollon Pontou Apollon 34 28 44 35
15 Edessaikos Edessaikos 34 38 60 35
16 Pierikos Pierikos 34 35 62 34
17 Ionikos Nikea Ionikos 34 33 49 33
18 PAS Korinthos Korinthos 34 28 65 27
TEMPORADA 1991/1992
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 34 72 25 77
2 Olympiacos Piraeus Olympiacos 34 74 30 71
3 Panathinaikos Panathinaiko 34 66 21 69
4 PAOK PAOK 34 44 43 52
5 Apollon Smyrnis Apollon 34 35 34 49
6 OFI OFI 34 34 30 45
7 PAS Korinthos Korinthos 34 37 47 43
8 Aris Thessaloniki Aris 34 26 40 43
9 AE Larisa AE Larisa 34 40 46 42
10 Xanthi Xanthi 34 36 48 42
11 Iraklis Thessaloniki Iraklis 34 41 41 41
12 Panachaiki Panachaiki 34 42 56 41
13 Pierikos Pierikos 34 41 56 41
14 Athinaikos Athinaikos 34 36 41 40
15 Doxa Dramas Doxa Dramas 34 39 38 38
16 Panionios Panionios 34 32 51 38
17 Panserraikos FC Panserraikos 34 29 59 35
18 Ethnikos Piraeus Ethnikos 34 30 48 32
TEMPORADA 1990/1991
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Panathinaikos Panathinaiko 34 77 22 77
2 Olympiacos Piraeus Olympiacos 34 77 28 67
3 AEK Athens AEK Athens 34 59 33 60
4 PAOK PAOK 34 56 39 57
5 Athinaikos Athinaikos 34 40 33 53
6 Iraklis Thessaloniki Iraklis 34 40 36 51
7 Doxa Dramas Doxa Dramas 34 42 45 48
8 OFI OFI 34 37 38 45
9 Aris Thessaloniki Aris 34 34 38 44
10 Apollon Smyrnis Apollon 34 41 62 40
11 AE Larisa AE Larisa 34 38 46 39
12 Panionios Panionios 34 38 54 39
13 Panachaiki Panachaiki 34 36 48 37
14 Panserraikos FC Panserraikos 34 30 42 37
15 Levadiakos Levadiakos 34 35 51 37
16 Xanthi Xanthi 34 35 53 37
17 Ionikos Nikea Ionikos 34 37 50 36
18 PAS Giannina Giannina 34 20 54 33
TEMPORADA 1989/1990
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Panathinaikos Panathinaiko 34 75 35 74
2 AEK Athens AEK Athens 34 64 18 70
3 PAOK PAOK 34 49 26 65
4 Olympiacos Piraeus Olympiacos 34 60 37 63
5 Iraklis Thessaloniki Iraklis 34 43 35 53
6 OFI OFI 34 52 41 52
7 Aris Thessaloniki Aris 34 37 40 46
8 AE Larisa AE Larisa 34 35 38 46
9 Levadiakos Levadiakos 34 34 45 44
10 Xanthi Xanthi 34 33 51 41
11 Doxa Dramas Doxa Dramas 34 36 39 38
12 Panionios Panionios 34 43 52 38
13 Panserraikos FC Panserraikos 34 32 42 38
14 Apollon Smyrnis Apollon 34 33 35 36
15 Ionikos Nikea Ionikos 34 27 48 36
16 Apollon Pontou Apollon 34 30 38 34
17 Olympiakos Volos Olympiakos 34 32 63 32
18 Ethnikos Piraeus Ethnikos 34 20 52 27
TEMPORADA 1988/1989
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 30 45 20 63
2 Olympiacos Piraeus Olympiacos 30 54 25 57
3 Panathinaikos Panathinaiko 30 45 25 51
4 Iraklis Thessaloniki Iraklis 30 43 27 49
5 OFI OFI 30 45 36 47
6 Aris Thessaloniki Aris 30 31 26 44
7 AE Larisa AE Larisa 30 37 34 44
8 PAOK PAOK 30 34 30 43
9 Doxa Dramas Doxa Dramas 30 26 28 38
10 Panionios Panionios 30 32 36 37
11 Levadiakos Levadiakos 30 33 47 34
12 Olympiakos Volos Olympiakos 30 36 45 32
13 Apollon Smyrnis Apollon 30 29 38 30
14 Ethnikos Piraeus Ethnikos 30 31 49 29
15 Diagoras Diagoras 30 21 43 24
16 Apollon Pontou Apollon 30 24 57 21
TEMPORADA 1987/1988
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 AE Larisa AE Larisa 30 51 22 61
2 PAOK PAOK 30 60 27 56
3 AEK Athens AEK Athens 30 51 31 55
4 OFI OFI 30 54 41 54
5 Panathinaikos Panathinaiko 30 47 34 51
6 Iraklis Thessaloniki Iraklis 30 42 32 47
7 Ethnikos Piraeus Ethnikos 30 27 28 44
8 Olympiacos Piraeus Olympiacos 30 39 41 40
9 Aris Thessaloniki Aris 30 39 41 38
10 Panionios Panionios 30 32 34 34
11 Apollon Pontou Apollon 30 23 39 31
12 Diagoras Diagoras 30 25 38 30
13 Levadiakos Levadiakos 30 32 46 30
14 Veria NPS Veria NPS 30 24 53 30
15 Panserraikos FC Panserraikos 30 24 42 29
16 Panachaiki Panachaiki 30 32 53 28

  USO DE MEMORIA  
6,034,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1201
Total Execution Time  0.1213
  CADENA URL  
/historico/Olympiakos-Piraeus/1994
  GET DATOS  
$_GET['/historico/Olympiakos-Piraeus/1994']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0042  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Olympiakos-Piraeus' AND l.year = 1994 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1863 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1863 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1863 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 10962
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1863 AND type_rel = 2
0.0030  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1863 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  SELECT /*35 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 (408,1855,2676,3017,3042) ORDER BY n.cover_points DESC, update_date DESC
0.0048  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '1863' AND l.year = 1994 ORDER BY l.year DESC,cat.coefficient DESC
0.0040  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '1863' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 10962 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 29003 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0046  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=1863 AND l.year in (1993,1994,1995) ORDER BY l.id DESC, l.year DESC ;
0.0019  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (29004,11025,10963) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 29004 AND teamId = 1863
0.0039  SELECT count(id) as num_players from rel_players WHERE league_id = 10963 AND teamId = 1863
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 11025 AND teamId = 1863
0.0020  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1994` 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 = 10962 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0047  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1994 e ON e.player_id = p.id AND e.league_id = 10962 WHERE rp.league_id = 10962 AND rp.teamId = 1863 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0042  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1994 e ON e.player_id = p.id AND e.league_id = 10962 WHERE rp.league_id = 10962 AND rp.teamId = 1863 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0041  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1994 e ON e.player_id = p.id AND e.league_id = 10962 WHERE rp.league_id = 10962 AND rp.teamId = 1863 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 1863 AND l.year <= 1994 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0024  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 `tables1994` 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 = 29003 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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.0024  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 `tables1992` 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 = 29005 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables1991` 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 = 29006 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables1990` 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 = 29007 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1989` 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 = 29008 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables1988` 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 = 29009 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC