4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Panargiakos Argos Panargiakos 34 49 13 76
2 PAS Korinthos Korinthos 34 58 29 70
3 Thyella D Rafina Thyella 34 52 28 65
4 Ellas Syros Ellas Syros 34 66 30 63
5 Kyanos Asteras Vari Kyanos 34 55 22 62
6 Marko Marko 34 42 36 56
7 Ialysos Ialysos 34 40 34 55
8 Rodos Rodos 34 51 29 55
9 Panegialios Panegialios 34 56 43 55
10 AE Mykonou AE Mykonou 34 51 35 51
11 Afantou Afantou 34 42 36 50
12 PAO Vardas PAO Vardas 33 30 49 40
13 Pyliou Pyliou 34 35 48 37
14 Panelefsiniakos Panelefsinia 34 36 66 35
15 Vyzas Megara Vyzas Megara 33 32 61 33
16 Erani Filiatra Erani 34 35 54 23
17 Ermionidas-Ermis Ermionidas-E 34 24 58 22
18 Missolonghi Missolonghi 34 16 99 3
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Tilikratis Tilikratis 26 58 15 59
2 Ypatou Ypatou 26 44 9 58
3 Panelefsiniakos Panelefsinia 26 60 17 57
4 Fikis Fikis 26 40 24 46
5 Vyzas Megara Vyzas Megara 26 44 23 42
6 Trikala Trikala 26 36 32 40
7 Asteras Petriti Asteras 26 26 34 38
8 Zakynthos Zakynthos 26 33 34 36
9 AE Lefkimmi AE Lefkimmi 26 30 34 36
10 Panagriniakos Panagriniako 26 39 42 28
11 Apollon Parga Apollon 26 29 35 23
12 Digenis Neochori Digenis 26 15 35 22
13 Chalkis Chalkis 26 15 74 14
14 Nafpaktiakos Asteras Nafpaktiakos 26 9 70 9
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Iraklis Larissa Iraklis 22 35 13 52
2 Ypatou Ypatou 22 38 11 50
3 Elassona Elassona 22 32 20 37
4 APO Amvrysseas Amvrysseas 22 27 13 35
5 Dimitra Efxeinoupolis Dimitra 22 33 21 35
6 Fikis Fikis 22 26 25 34
7 Ethnikos Neou Keramidiou Ethnikos 22 23 14 33
8 Nea Artaki Nea Artaki 22 25 17 32
9 Atromitos Palamas Atromitos 22 27 22 30
10 Thiseas Agria Thiseas 22 18 31 20
11 Atalanti Atalanti 22 15 50 12
12 Aetos Makrychoriou Aetos 22 3 65 1
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Anagennisi Karditsas Anagennisi 14 40 5 38
2 AE Karitsa AE Karitsa 14 28 7 35
3 Ethnikos Neou Keramidiou Ethnikos 14 16 17 25
4 Aetos Makrychoriou Aetos 14 24 11 24
5 AEP Kozani AEP Kozani 14 17 15 23
6 Atromitos Palamas Atromitos 14 17 14 22
7 Iraklis Larissa Iraklis 14 23 15 20
8 Fikis Fikis 14 22 17 20
9 Elassona Elassona 14 16 16 19
10 AO Sellana AO Sellana 14 15 15 16
11 Dias Diou Dias Diou 14 11 23 13
12 Ermis Amyntaio Ermis 14 12 36 12
13 Meteora Meteora 14 11 24 10
14 Oikonomos Tsaritsani Oikonomos 14 14 29 9
15 Makedonikos Foufas Makedonikos 14 12 34 9
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Pierikos Pierikos 23 45 6 56
2 Thiseas Agria Thiseas 23 46 31 43
3 AE Karitsa AE Karitsa 23 39 16 41
4 Iraklis Larissa Iraklis 23 33 26 40
5 Atromitos Palamas Atromitos 23 26 21 36
6 GS Almyros GS Almyros 23 25 20 35
7 AO Sellana AO Sellana 23 24 23 35
8 Atalanti Atalanti 23 29 34 32
9 Meteora Meteora 23 25 24 28
10 Diagoras Stefanovik Diagoras 23 22 28 27
11 Oikonomos Tsaritsani Oikonomos 23 19 26 26
12 Dias Diou Dias Diou 23 18 37 25
13 Digenis Neochori Digenis 23 31 41 22
14 Potamia Potamia 23 7 56 2
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Kronos Argyrades Kronos 24 28 9 48
2 Thesprotos Thesprotos 24 38 13 47
3 Acheron Kanalaki Acheron 24 37 17 47
4 AE Lefkimmi AE Lefkimmi 24 43 19 42
5 Makedonikos Foufas Makedonikos 24 40 22 42
6 Nafpaktiakos Asteras Nafpaktiakos 24 37 22 40
7 Tilikratis Tilikratis 24 32 21 39
8 Souli Paramythia Souli 23 30 20 37
9 M. Alexandros Kallithea Alexandros 24 33 29 32
10 Thriamvos Serviana Thriamvos 24 29 23 30
11 Makedonikos Siatista Makedonikos 24 24 37 22
12 Grevena Aerata Grevena 24 9 86 5
13 Floriada Floriada 23 0 62 2
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Tilikratis Tilikratis 23 38 15 48
2 Panamvrakakikos A-M Panamvrakaki 24 45 20 47
3 Makedonikos Foufas Makedonikos 24 31 18 46
4 Ermis Amyntaio Ermis 24 36 24 45
5 Thesprotos Thesprotos 24 38 15 42
6 AE Lefkimmi AE Lefkimmi 24 32 23 41
7 Doxa Kranoula Doxa 24 25 22 37
8 Ethnikos Filippiada Ethnikos 24 18 28 27
9 AEP Karagiannia Karagiannia 24 25 36 27
10 Panlefkadios Panlefkadios 24 16 24 21
11 Skoufas Kompoti Skoufas 24 15 29 21
12 Asteras Parapotamos Asteras 24 17 44 14
13 Kastoria Kastoria 23 10 48 9
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Panachaiki Panachaiki 28 47 9 65
2 Chalkida Chalkida 28 34 22 52
3 PAO Vardas PAO Vardas 28 36 26 48
4 Ermionidas-Ermis Ermionidas-E 28 40 31 43
5 Asteras Amaliadas Asteras 28 25 30 38
6 AO Thiva AO Thiva 28 32 29 37
7 Fostiras Fostiras 28 25 20 36
8 Achaiki Achaiki 28 30 33 36
9 Aiolikos Aiolikos 28 31 25 35
10 Panarkadikos Panarkadikos 28 21 25 35
11 Panargiakos Argos Panargiakos 28 24 32 35
12 Pylou AO Tsiklitiras Pylou 28 24 30 32
13 Loutraki Loutraki 28 22 35 31
14 Zevgolateio Zevgolateio 28 15 37 26
15 Doxa Megalopoli Doxa 28 24 46 25
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Sparti Sparti 26 43 16 59
2 Panargiakos Argos Panargiakos 26 45 23 51
3 Panarkadikos Panarkadikos 26 38 17 51
4 Aiolikos Aiolikos 26 55 24 47
5 PAO Vardas PAO Vardas 26 39 27 44
6 Loutraki Loutraki 26 35 24 41
7 Doxa Nea Manolada Doxa 26 35 30 40
8 Ermionidas-Ermis Ermionidas-E 26 33 28 38
9 Chalkis Chalkis 26 29 16 37
10 Kalamata FC Kalamata FC 26 27 31 31
11 Vyzas Megara Vyzas Megara 26 25 48 30
12 Levante Levante 26 22 62 17
13 Kanaris Nenita Kanaris 26 17 48 16
14 Iraklis Psachna Iraklis 26 7 56 10
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Panelefsiniakos Panelefsinia 28 60 12 68
2 Panargiakos Argos Panargiakos 28 54 16 63
3 Aiolikos Aiolikos 28 43 26 49
4 Zakynthiakos Zakynthiakos 28 47 34 48
5 Doxa Nea Manolada Doxa 28 37 24 48
6 Panarkadikos Panarkadikos 28 47 31 47
7 Kalamata FC Kalamata FC 28 36 24 46
8 Loutraki Loutraki 28 31 25 44
9 PAO Vardas PAO Vardas 28 43 37 39
10 Vyzas Megara Vyzas Megara 28 38 24 38
11 Achaiki Achaiki 28 36 48 31
12 Ermis Kiveri Ermis Kiveri 28 28 37 30
13 Asteras Magoula Asteras 27 19 62 12
14 Mandraikos Mandraikos 27 12 54 7
15 Kymi Kymi 28 1 78 0
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Lamia Lamia 28 60 25 66
2 Achilleas Neokaisareia Achilleas 28 48 20 62
3 Kymi Kymi 28 32 17 53
4 EAP Makrochori Makrochori 28 40 33 46
5 Lefkadia Lefkadia 28 30 23 45
6 Dotieas Agias Dotieas 28 41 27 44
7 Rigas Feraios Rigas 28 40 27 44
8 Trikala Trikala 28 30 20 44
9 Machitis Terpsithea Machitis 28 42 31 39
10 Naoussa Naoussa 28 41 37 38
11 Chalkis Chalkis 28 38 33 37
12 Achilleas Domokou Achilleas 28 29 57 25
13 Karditsa Karditsa 28 28 44 23
14 Ambeloniakos Ambeloniakos 28 28 56 17
15 Pyrgetos Pyrgetos 28 6 83 0
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Oikonomos Tsaritsani Oikonomos 6 7 3 12
2 Niki Volos Niki Volos 6 12 6 11
3 Zakynthos Zakynthos 6 8 9 5
4 Paniliakos Paniliakos 6 7 16 3

  USO DE MEMORIA  
6,214,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0964
Total Execution Time  0.0985
  CADENA URL  
/3_league_grecia2024/grupo3/historico
  GET DATOS  
$_GET['/3_league_grecia2024/grupo3/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0018  SELECT type FROM routes WHERE alias = '3_league_grecia2024'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '3_league_grecia' AND (l.group_code = 3 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=3 DESC LIMIT 1
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=344 ORDER BY order_id ASC
0.0020  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73589 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 344 AND group_code = 3 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 73589 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 `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 = 70497 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 `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 = 65486 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 `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 = 59059 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.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 `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 = 51443 AND t.round = 23 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 `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 = 45475 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 = 40662 AND t.round = 26 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 = 36069 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 `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 = 15928 AND t.round = 26 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 `tables2015` 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 = 12487 AND t.round = 30 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 `tables2014` 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 = 12264 AND t.round = 30 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 `tables2012` 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 = 24787 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 18:08:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 18:08:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 18:08:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 18:08:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73589 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73589 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73589 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73589 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 73589 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73589 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0044  SELECT *,(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 = 73589 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