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

Almopos Aridea

Entrenador: Giannis Pollaetidis

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Levadiakos Levadiakos 22 36 9 55
2 AE Larisa AE Larisa 22 32 12 49
3 Niki Volos Niki Volos 22 33 24 32
4 AEK Athens B Athens 22 23 17 32
5 Makedonikos Neapolis Makedonikos 22 24 23 31
6 PAOK B PAOK B 22 31 27 30
7 Anagennisi Karditsas Anagennisi 22 22 24 29
8 Iraklis Thessaloniki Iraklis 22 25 20 29
9 Kozani FC Kozani FC 22 10 17 24
10 Kampaniakos Chalastra Kampaniakos 22 18 32 23
11 Aiolikos Aiolikos 22 20 36 19
12 Apollon Pontou Apollon 22 12 45 11
13 Almopos Aridea Almopos 0 0 0 0
TEMPORADA 2022/2023
SEGUNDA GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Panserraikos FC Panserraikos 28 43 13 64
2 AE Larisa AE Larisa 28 50 19 58
3 Niki Volos Niki Volos 28 41 20 52
4 Iraklis Thessaloniki Iraklis 28 53 22 50
5 PAOK B PAOK B 28 51 33 49
6 Almopos Aridea Almopos 28 23 17 36
7 Anagennisi Karditsas Anagennisi 28 34 21 35
8 Makedonikos Neapolis Makedonikos 28 28 30 33
9 Panathinaikos B Panathinaiko 28 39 41 33
10 Diagoras Diagoras 28 38 42 33
11 Apollon Pontou Apollon 28 21 37 32
12 Veria NPS Veria NPS 28 28 32 31
13 Iraklis Larissa Iraklis 28 17 42 26
14 Thesprotos Thesprotos 28 26 49 17
15 Apollon Larisas Apollon 28 8 82 4
TEMPORADA 2021/2022
SEGUNDA GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Veria NPS Veria NPS 32 61 23 75
2 AE Larisa AE Larisa 32 42 15 67
3 Xanthi Xanthi 32 43 25 53
4 Niki Volos Niki Volos 32 38 20 52
5 Anagennisi Karditsas Anagennisi 32 47 34 51
6 Olympiacos Piraeus B Olympiacos 32 40 31 51
7 Iraklis Thessaloniki Iraklis 32 51 29 48
8 PAOK B PAOK B 32 41 32 44
9 Almopos Aridea Almopos 32 40 39 39
10 Apollon Pontou Apollon 32 34 38 37
11 Apollon Larisas Apollon 32 27 42 35
12 Thesprotos Thesprotos 32 34 43 34
13 Panserraikos FC Panserraikos 32 31 39 33
14 Pierikos Pierikos 32 36 49 32
15 Kavala Kavala 32 25 71 31
16 Olympiakos Volos Olympiakos 32 34 49 29
17 Trikala Trikala 32 17 62 21
TEMPORADA 2020/2021
FOOTBALL LEAGUE GRECIA
Equipo PJ GF GC Puntos
1 Veria NPS Veria NPS 18 24 6 38
2 Kavala Kavala 18 32 18 35
3 Panserraikos FC Panserraikos 18 21 12 31
4 Olympiakos Volos Olympiakos 18 23 21 29
5 Pierikos Pierikos 18 23 21 26
6 Thesprotos Thesprotos 18 19 24 22
7 Triglia Rafinas Triglia 18 14 16 21
8 Almopos Aridea Almopos 18 18 21 20
9 Apollon Pontou Apollon 18 16 25 19
10 AEP Kozani AEP Kozani 18 7 33 7
11 Kalamata FC Kalamata FC 18 20 7 35
12 Rodos Rodos 18 20 15 30
13 Athens Kallithea Athens 18 20 14 29
14 Episkopi Episkopi 18 15 10 27
15 Santorini Santorini 18 15 16 24
16 Ialysos Ialysos 18 16 22 24
17 Egaleo Egaleo 18 14 14 23
18 Niki Volos Niki Volos 18 18 14 22
19 Asteras Vlachioti Asteras 18 14 16 19
20 Enosis Aspropyrgos Enosis 18 10 34 8
TEMPORADA 2019/2020
TERCERA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Almopos Aridea Almopos 25 59 10 61
2 Makedonikos Neapolis Makedonikos 25 33 8 47
3 Poseidon Nea Michaniona Poseidon 25 44 26 46
4 Anagennisi Giannitsa Anagennisi 25 34 19 45
5 Thermaikos Thermis Thermaikos 25 40 21 43
6 Edessaikos Edessaikos 25 35 15 42
7 Keravnos Angelochoriou Keravnos 24 34 28 39
8 M. Alexandros Trikala Alexandros 26 25 20 39
9 Agrotikos Asteras Agrotikos 23 31 17 37
10 Nea Kallikrateia Kallikrateia 24 33 19 35
11 Niki Agkathia Niki 24 26 19 33
12 Florina Florina 25 27 41 29
13 Astrapi Mesopotamias Astrapi 25 15 58 13
14 Seirína Seirína 22 4 70 3
15 Palaiochori Fc Palaiochori 25 3 72 3
TEMPORADA 2018/2019
TERCERA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Elpis Skoutari Elpis 26 51 15 57
2 Triglia Rafinas Triglia 26 39 19 55
3 Niki Agkathia Niki 26 31 11 53
4 Palaiochori Fc Palaiochori 26 45 27 52
5 Edessaikos Edessaikos 26 45 14 45
6 Almopos Aridea Almopos 26 37 18 42
7 Anagennisi Giannitsa Anagennisi 26 31 25 37
8 Makedonikos Makedonikos 26 32 30 36
9 Agrotikos Asteras Agrotikos 26 25 29 34
10 PAO Koufalion Koufalion 26 20 39 22
11 Olympiakos Kyminion Olympiakos 26 13 33 22
12 Meliteas Melitis Meliteas 26 28 66 18
13 Ermis Amyntaio Ermis 26 21 53 13
14 Langadas Langadas 26 14 53 13
TEMPORADA 2017/2018
TERCERA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Iraklis Thessaloniki Iraklis 28 63 17 65
2 Palaiochori Fc Palaiochori 28 49 19 61
3 Makedonikos Makedonikos 28 32 22 47
4 Almopos Aridea Almopos 28 32 22 42
5 Edessaikos Edessaikos 28 30 28 41
6 Agrotikos Asteras Agrotikos 28 36 39 40
7 Pierikos Pierikos 28 25 29 40
8 Langadas Langadas 28 46 33 39
9 Kardias Kardias 28 38 33 39
10 Naoussa Naoussa 28 30 29 39
11 Kilkisiakos Kilkisiakos 28 31 32 37
12 AE Karitsa AE Karitsa 28 28 39 28
13 M. Alexandros Trikala Alexandros 28 22 47 25
14 Philippos Alexandreia Philippos 28 17 57 18
15 Kampaniakos Chalastra Kampaniakos 28 22 55 16
TEMPORADA 2016/2017
TERCERA GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Apollon Pontou Apollon 27 72 16 70
2 Doxa Dramas Doxa Dramas 28 67 16 69
3 Langadas Langadas 28 38 30 50
4 Nestos Chrisoupolis Nestos 28 37 35 45
5 Orfeas Xanthi Orfeas 28 31 22 44
6 Kavala Kavala 28 43 26 43
7 Apollon Paralimniou Apollon 28 44 23 42
8 Naoussa Naoussa 28 28 32 40
9 Kampaniakos Chalastra Kampaniakos 28 34 44 38
10 Kardias Kardias 27 33 35 37
11 Makedonikos Foufas Makedonikos 28 29 34 32
12 Almopos Aridea Almopos 28 24 31 30
13 Doxa Proskyniton Doxa 28 26 46 25
14 Eordaikos Eordaikos 28 23 68 17
15 Pontion Vatolakkou Pontion 28 4 75 5

  USO DE MEMORIA  
5,814,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1123
Total Execution Time  0.1135
  CADENA URL  
/historico/Almopos-Aridaia
  GET DATOS  
$_GET['/historico/Almopos-Aridaia']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0026  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 = 'Almopos-Aridaia' AND l.year = 2024 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.0018  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=96813 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=96813 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=96813 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 73551
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=96813 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2166 AND type_rel = 3
0.0021  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 = '96813' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '96813' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '96813' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0033  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 = 73551 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 73941 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=96813 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (73941,73551,67320) 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 = 73941 AND teamId = 96813
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73551 AND teamId = 96813
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 96813
0.0021  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 = 73941 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024  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 = '96813' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '96813' and rp.type = 4
0.0020  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 = '96813' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 73941 WHERE rp.league_id = 73941 AND rp.teamId = 96813 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.0020  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 = 73941 WHERE rp.league_id = 73941 AND rp.teamId = 96813 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 73941 WHERE rp.league_id = 73941 AND rp.teamId = 96813 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 96813 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73941 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `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 = 69284 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.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 `tables2022` 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 = 65350 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 60731 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `tables2020` 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 = 51442 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 45474 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 40661 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 `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 = 36065 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73941 ORDER BY nameShow LIMIT 100