4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Olympiada Lympion
TEMPORADA 2023/2024
TERCERA CHIPRE GRUPO 3
Equipo PJ GF GC Puntos
1 Kouris Erimi Kouris Erimi 29 43 30 42
2 Omonia Psevda Omonia 29 35 40 41
3 Geroskipou Geroskipou 29 26 31 38
4 ASPIS Pylas ASPIS Pylas 29 33 36 37
5 AEP Polemidion Polemidion 29 37 46 35
6 APEP APEP 29 32 42 31
7 Ethnikos Assias Ethnikos 29 40 52 27
8 Olympiada Lympion Olympiada 29 18 60 25
TEMPORADA 2022/2023
SEGUNDA CHIPRE GRUPO 3
Equipo PJ GF GC Puntos
1 Xylotympou Xylotympou 12 23 11 21
2 Ermis Aradippou Ermis 13 18 14 20
3 Anagennisi Anagennisi 12 19 22 20
4 Digenis Ypsonas Digenis 13 33 20 19
5 PAEEK PAEEK 12 19 14 17
6 Ayia Napa Ayia Napa 12 12 15 17
7 Olympiada Lympion Olympiada 12 13 32 7
8 Alki Oroklini Alki 2 1 10 0
TEMPORADA 2021/2022
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Karmiotissa Karmiotissa 30 52 20 63
2 Nea Salamis Nea Salamis 30 59 24 63
3 Akritas Chlorakas Akritas 30 49 26 58
4 Enosis Neon Paralimni Enosis Neon 30 48 24 57
5 Alki Oroklini Alki 30 36 38 47
6 Ermis Aradippou Ermis 30 43 42 44
7 Othellos Athienou Othellos 30 40 53 42
8 Xylotympou Xylotympou 30 39 42 38
9 Anagennisi Anagennisi 30 33 40 37
10 Omonia 29is Omonia 29is 30 31 33 36
11 Omonia Aradippou Omonia 30 30 44 35
12 Onisilos Onisilos 30 34 44 33
13 Ayia Napa Ayia Napa 30 41 52 31
14 Ahironas Ahironas 30 28 41 31
15 Olympiada Lympion Olympiada 30 23 44 28
16 ASIL Lysi ASIL Lysi 30 28 47 23
TEMPORADA 2020/2021
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Omonia 29is Omonia 29is 26 45 22 58
2 Olympiada Lympion Olympiada 25 49 16 53
3 Peyia Peyia 26 46 27 52
4 Ethnikos Assias Ethnikos 26 49 30 43
5 MEAP Nisou MEAP Nisou 25 39 31 38
6 Halkanoras Halkanoras 26 40 31 38
7 Ormideia Ormideia 25 42 36 37
8 Iraklis Yerolakkou Iraklis 25 37 33 35
9 APONA Anagias APONA 26 35 34 31
10 APEP APEP 26 30 34 31
11 Oroklini / Troulloi Oroklini 25 28 47 26
12 Elpida Astromeritis Elpida 25 27 45 25
13 ENAD ENAD 25 21 40 25
14 Amathous Amathous 26 23 37 24
15 Elia Lythrodonta Elia 26 34 45 23
16 O Kormakitis Kormakitis 25 20 57 12
TEMPORADA 2018/2019
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Digenis Morphou Digenis 30 62 26 62
2 Omonia Psevda Omonia 30 50 35 58
3 Digenis Ypsonas Digenis 30 52 27 53
4 Xylotympou Xylotympou 30 39 25 52
5 ENAD ENAD 30 45 35 47
6 Halkanoras Halkanoras 30 52 50 43
7 Ethnikos Assias Ethnikos 30 44 44 43
8 Kouris Erimi Kouris Erimi 30 39 39 42
9 Ormideia Ormideia 30 44 39 41
10 Ahironas Ahironas 30 42 42 40
11 Elpida Astromeritis Elpida 30 38 49 39
12 Amathous Amathous 30 37 42 38
13 APEA APEA 30 43 50 38
14 Olympiada Lympion Olympiada 30 43 53 33
15 Ethnikos Latsion Ethnikos 30 30 52 25
16 Peyia Peyia 30 25 77 9
TEMPORADA 2017/2018
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Onisilos Onisilos 30 60 22 68
2 MEAP Nisou MEAP Nisou 30 67 31 63
3 Akritas Chlorakas Akritas 30 44 22 58
4 Digenis Ypsonas Digenis 30 61 45 48
5 ENAD ENAD 30 47 35 47
6 Elpida Astromeritis Elpida 30 44 36 46
7 Peyia Peyia 30 41 48 45
8 APEA APEA 30 35 39 41
9 Ahironas Ahironas 30 41 47 38
10 Ormideia Ormideia 30 33 35 38
11 Ethnikos Latsion Ethnikos 30 45 55 37
12 Digenis Morphou Digenis 30 45 47 36
13 Olympiada Lympion Olympiada 30 45 60 35
14 APEP APEP 30 36 46 32
15 Foinikas Agia Marina Foinikas 30 23 51 20
16 Leivadiakós Leivadiakós 30 35 83 15
TEMPORADA 2016/2017
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Xylotympou Xylotympou 30 54 22 70
2 Digenis Voroklinis Digenis 30 57 35 57
3 Halkanoras Halkanoras 30 52 39 56
4 Ethnikos Latsion Ethnikos 30 59 25 54
5 Olympiada Lympion Olympiada 30 41 45 46
6 Digenis Ypsonas Digenis 30 42 45 43
7 Digenis Morphou Digenis 30 48 48 42
8 Ahironas Ahironas 30 38 38 39
9 Peyia Peyia 30 41 38 38
10 MEAP Nisou MEAP Nisou 30 34 44 36
11 Ormideia Ormideia 30 31 36 35
12 APEP APEP 30 32 40 35
13 Leivadiakós Leivadiakós 30 44 48 34
14 Iraklis Yerolakkou Iraklis 30 41 48 32
15 Elpida Astromeritis Elpida 30 36 54 29
16 Agiou Georgiou Vrysoúllon Agiou 30 27 72 18
TEMPORADA 2015/2016
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Akritas Chlorakas Akritas 30 72 21 67
2 Alki Oroklini Alki 30 62 25 67
3 Ethnikos Assias Ethnikos 30 64 34 57
4 MEAP Nisou MEAP Nisou 30 51 33 50
5 Ahironas Ahironas 30 44 36 49
6 Halkanoras Halkanoras 30 44 34 47
7 Xylotympou Xylotympou 30 36 43 44
8 Digenis Ypsonas Digenis 30 31 38 39
9 Iraklis Yerolakkou Iraklis 30 39 41 38
10 Olympiada Lympion Olympiada 30 38 48 38
11 Ormideia Ormideia 30 37 50 34
12 Digenis Morphou Digenis 30 44 59 34
13 Ethnikos Latsion Ethnikos 30 24 39 33
14 APEP APEP 30 38 55 33
15 Kouris Erimi Kouris Erimi 30 27 53 20
16 Amathous Amathous 30 26 68 17

  USO DE MEMORIA  
5,696,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.4549
Total Execution Time  0.4564
  CADENA URL  
/historico/Olympiada-Lympion
  GET DATOS  
$_GET['/historico/Olympiada-Lympion']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0252  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 = 73512
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65805 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=578 AND type_rel = 3
0.0128  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 = '65805' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 73512 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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=65805 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (75147,70915,69546) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 70915 AND teamId = 65805
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 75147 AND teamId = 65805
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 69546 AND teamId = 65805
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 73512 AND t.round = 15 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '65805' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65805' and rp.type = 4
0.0126  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '65805' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0136  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 events2024 e ON e.player_id = p.id AND e.league_id = 73512 WHERE rp.league_id = 73512 AND rp.teamId = 65805 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.0134  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 events2024 e ON e.player_id = p.id AND e.league_id = 73512 WHERE rp.league_id = 73512 AND rp.teamId = 65805 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 events2024 e ON e.player_id = p.id AND e.league_id = 73512 WHERE rp.league_id = 73512 AND rp.teamId = 65805 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 65805 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  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 `tables2024` 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 = 73512 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2024` 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 = 75147 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2023` 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 = 69228 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2023` 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 = 70915 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2021` 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 = 58330 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2019` 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 = 44928 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2018` 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 = 39162 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2017` 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 = 33689 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2016` 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 = 15847 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC