Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Agrotikos Asteras Agrotikos 22 33 8 48
2 Pandramaikos Pandramaikos 22 38 20 39
3 Apollon Paralimniou Apollon 22 34 22 35
4 Thermaikos Thermis Thermaikos 22 24 25 32
5 Aris Avato Aris Avato 22 28 21 32
6 Ethnikos Sochos Ethnikos 22 21 13 31
7 Doxa Dramas Doxa Dramas 22 25 19 30
8 Nestos Chrisoupolis Nestos 22 25 27 29
9 Antheias-Aristinou Antheias-Ari 22 27 38 23
10 Orfeas Xanthi Orfeas 22 22 43 22
11 Alexandroupolis FC Alexandroupo 22 13 27 18
12 Anagennisi Plagia Anagennisi 22 17 44 17
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Orfeas Xanthi Orfeas 15 27 11 35
2 Iraklis Ampelokipoi Iraklis 14 29 7 30
3 Aetos Orfani Aetos Orfani 15 27 11 28
4 Pandramaikos Pandramaikos 15 20 13 26
5 Antheias-Aristinou Antheias-Ari 15 22 16 25
6 Apollon Paralimniou Apollon 15 18 12 24
7 Nestos Chrisoupolis Nestos 15 15 9 24
8 Alexandroupolis FC Alexandroupo 15 17 22 22
9 Aris Avato Aris Avato 15 20 12 21
10 Elpida Sapes Elpida Sapes 15 16 18 19
11 Ethnikos Sochos Ethnikos 14 15 13 17
12 Evosmou Evosmou 14 13 18 17
13 Ampelokipon Drama Ampelokipon 15 18 29 17
14 AE Didymoteicho Didymoteicho 15 17 21 16
15 Anagennisi Thalassias Anagennisi 14 6 38 3
16 D. Neo Sidirochori Sidirochori 11 2 32 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Panserraikos FC Panserraikos 22 65 14 58
2 Nestos Chrisoupolis Nestos 22 34 28 44
3 Apollon Paralimniou Apollon 21 31 17 40
4 Aetos Orfani Aetos Orfani 22 41 22 38
5 Pandramaikos Pandramaikos 21 30 20 37
6 Aris Avato Aris Avato 21 32 22 34
7 Doxa Kato Kamila Doxa Kato K. 21 39 29 32
8 Antheias-Aristinou Antheias-Ari 21 21 24 32
9 Orfeas Xanthi Orfeas 21 23 35 26
10 Keravnos Pernis Keravnos 21 26 52 15
11 Kilkisiakos Kilkisiakos 21 20 49 13
12 Iraklis Zygou Iraklis 21 12 30 10
13 Doxa Theologos Doxa 21 12 44 9
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Kavala Kavala 26 66 9 66
2 Nestos Chrisoupolis Nestos 26 53 14 65
3 Panserraikos FC Panserraikos 26 42 24 46
4 Apollon Paralimniou Apollon 26 40 21 45
5 Aetos Orfani Aetos Orfani 26 44 34 39
6 Orfeas Xanthi Orfeas 26 34 25 39
7 Aris Avato Aris Avato 26 27 22 38
8 Alexandros Kilkis Alexandros 26 26 20 37
9 Keravnos Pernis Keravnos 26 29 28 35
10 Kalampaki Kalampaki 26 19 29 29
11 Ethnikos Alexandroupoli Ethnikos 26 26 51 24
12 Aspida Xanthi Aspida 26 19 59 20
13 PAO Kosmio PAO Kosmio 26 21 65 13
14 Ethnikos Sidirokastro Ethnikos 26 12 57 13
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Apollon Paralimniou Apollon 22 38 13 48
2 Aetos Orfani Aetos Orfani 22 35 25 42
3 Kavala Kavala 22 35 19 41
4 Elpis Skoutari Elpis 22 31 19 39
5 Nestos Chrisoupolis Nestos 22 23 16 32
6 Orfeas Xanthi Orfeas 22 30 25 32
7 Aris Avato Aris Avato 22 21 17 32
8 AE Didymoteicho Didymoteicho 22 18 22 31
9 M. Alexandros Xiropotamos Alexandros 22 18 32 21
10 Doxa Proskyniton Doxa 22 23 36 20
11 D. Neo Sidirochori Sidirochori 22 18 40 19
12 M. Alexandros Karperi Alexandros 22 14 40 10
Ver
TEMPORADA 2016/2017
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
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Aris Thessaloniki Aris 32 76 17 87
2 Nestos Chrisoupolis Nestos 32 66 35 66
3 Doxa Dramas Doxa Dramas 32 47 24 63
4 Kavala Kavala 32 53 24 58
5 Apollon Pontou Apollon 32 46 29 53
6 Langadas Langadas 32 50 35 53
7 Ethnikos Neo Agioneri FC Ethnikos 32 35 25 50
8 Kampaniakos Chalastra Kampaniakos 32 45 31 47
9 Eordaikos Eordaikos 32 35 35 46
10 AEP Kozani AEP Kozani 32 41 49 44
11 Byzantio Kokkinokhóma Byzantio 32 47 51 37
12 Thyella Filotas Thyella 32 32 38 35
13 Apollon Krya Vrysi Apollon Krya 32 27 43 34
14 Iraklis Ampelokipoi Iraklis 32 33 57 28
15 Ethnikos Alexandroupoli Ethnikos 32 20 45 27
16 Evros Soufli Evros Soufli 32 32 86 22
17 Ethnikos Gazoros Ethnikos 32 10 71 11
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Panserraikos FC Panserraikos 30 52 15 74
2 Aris Thessaloniki Aris 30 51 12 71
3 Kavala Kavala 30 54 16 67
4 Doxa Dramas Doxa Dramas 30 43 26 52
5 Kampaniakos Chalastra Kampaniakos 30 53 34 47
6 Ethnikos Neo Agioneri FC Ethnikos 30 40 34 42
7 Iraklis Ampelokipoi Iraklis 30 32 30 41
8 Thyella Filotas Thyella 30 32 31 40
9 Byzantio Kokkinokhóma Byzantio 30 44 49 40
10 Ethnikos Alexandroupoli Ethnikos 30 28 28 38
11 Evros Soufli Evros Soufli 30 32 34 37
12 Aris Akropotamos Aris 30 32 45 34
13 Apollon Arnaia Apollon 30 26 45 27
14 Orfeas Eleftheroupoli Orfeas 30 26 43 22
15 Anagennisi Giannitsa Anagennisi 30 19 62 20
16 Kastoria Kastoria 30 15 75 10
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Agrotikos Asteras Agrotikos 30 47 16 72
2 Panserraikos FC Panserraikos 30 57 21 67
3 Aris Akropotamos Aris 30 41 35 50
4 Iraklis Ampelokipoi Iraklis 30 39 27 48
5 Byzantio Kokkinokhóma Byzantio 30 25 22 46
6 Ethnikos Neo Agioneri FC Ethnikos 30 31 32 46
7 Evros Soufli Evros Soufli 30 39 35 45
8 Kilkisiakos Kilkisiakos 30 39 23 44
9 Nestos Chrisoupolis Nestos 30 51 38 44
10 Orfeas Eleftheroupoli Orfeas 30 39 26 44
11 Digenis Lakkomata Digenis 30 57 56 39
12 Doxa Petrousas Doxa 30 27 32 34
13 Ethnikos Sidirokastro Ethnikos 30 31 45 30
14 Moudania Moudania 30 37 59 30
15 Makedonikos Makedonikos 30 25 48 25
16 PAO Kosmio PAO Kosmio 30 14 84 3
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Apollon Pontou Apollon 22 33 12 48
2 Anagennisi Karditsas Anagennisi 22 42 19 47
3 Kassiopi FC Kassiopi FC 22 35 13 45
4 Aiginiakos Aiginiakos 22 34 21 37
5 Tyrnavos Tyrnavos 22 28 26 35
6 Vataniakos Vataniakos 22 27 30 31
7 Odysseas Kordeliou FC Odysseas 22 35 28 29
8 Zakynthos Zakynthos 22 22 25 29
9 Ethnikos Sidirokastro Ethnikos 22 23 24 27
10 Doxa Kranoula Doxa 22 23 35 18
11 Tilikratis Tilikratis 22 17 37 15
12 Oikonomos Tsaritsani Oikonomos 22 6 55 6
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Apollon Smyrnis Apollon 20 28 12 40
2 Paniliakos Paniliakos 20 24 16 35
3 Glyfada Glyfada 20 24 19 29
4 Zakynthos Zakynthos 20 20 25 29
5 Kalamata FC Kalamata FC 20 13 15 28
6 Rouvas Rouvas 20 18 22 25
7 Chania Chania 20 18 20 24
8 Asteras Magoula Asteras 20 19 22 23
9 Proodeftiki FC Proodeftiki 20 16 20 22
10 Ilysiakos AO Ilysiakos 20 17 22 21
11 PAO Rouf PAO Rouf 20 22 26 19
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Panachaiki Panachaiki 30 48 20 61
2 Vyzas Megara Vyzas Megara 30 41 19 57
3 Iraklis Psachna Iraklis 30 41 24 56
4 Rodos Rodos 30 38 23 53
5 Platanias Platanias 30 42 23 52
6 PAS Korinthos Korinthos 30 38 24 50
7 Apollon Smyrnis Apollon 30 37 25 50
8 Panegialios Panegialios 30 29 32 43
9 Chania Chania 30 42 40 42
10 Aias Salamina Aias 30 34 39 40
11 PAO Rouf PAO Rouf 30 34 32 37
12 Paniliakos Paniliakos 30 24 26 37
13 Enosi Panaspropyrgiakos Dox Enosi 30 30 38 34
14 Olympiakos Chersonisos Olympiakos 30 21 32 26
15 Agia Paraskevi Agia 30 13 62 16
16 Keravnos Kerateas Keravnos 30 11 64 9
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Trikala Trikala 32 40 11 64
2 Veria NPS Veria NPS 31 49 21 64
3 Anagennisi Giannitsa Anagennisi 32 60 36 58
4 Anagennisi Epanomi Anagennisi 31 39 23 58
5 Eordaikos Eordaikos 31 40 20 56
6 Makedonikos Makedonikos 31 35 22 52
7 Pyrsos Grevena Pyrsos 32 39 28 49
8 Ethnikos Filippiada Ethnikos 31 39 35 48
9 Fokikos Fokikos 32 31 27 47
10 Niki Volos Niki Volos 33 31 38 41
11 Doxa Kranoula Doxa 32 26 30 39
12 Odysseas Anagennisi Odysseas 32 33 31 37
13 AEP Kozani AEP Kozani 33 24 28 36
14 Pao Neon Epivaton Neon 31 26 38 33
15 Visaltiakos Visaltiakos 32 30 42 28
16 Thermaikos Thermis Thermaikos 32 25 59 20
17 Kastoria Kastoria 32 7 85 4
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Doxa Dramas Doxa Dramas 34 68 22 76
2 Panaitolikos Panaitolikos 34 56 14 70
3 Eordaikos Eordaikos 33 46 17 65
4 Makedonikos Makedonikos 34 47 25 56
5 Pao Neon Epivaton Neon 34 44 25 55
6 Zakynthos Zakynthos 34 39 27 54
7 Niki Volos Niki Volos 34 32 26 49
8 Anagennisi Giannitsa Anagennisi 34 35 36 48
9 Odysseas Anagennisi Odysseas 34 35 30 47
10 Ethnikos Filippiada Ethnikos 34 33 35 47
11 Pyrsos Grevena Pyrsos 34 37 28 46
12 Fokikos Fokikos 33 38 34 46
13 Thermaikos Thermis Thermaikos 32 48 41 45
14 Preveza Preveza 34 26 23 44
15 Lamia Lamia 34 34 34 42
16 Ethnikos Katerini Ethnikos 34 25 68 21
17 Anagennisi Arta Anagennisi 34 15 78 17
18 Enosi Thraki Enosi Thraki 34 3 98 0
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Kavala Kavala 32 49 18 72
2 Anagennisi Karditsas Anagennisi 31 43 19 60
3 Paone Paone 32 42 23 59
4 Olympiakos Volou Olympiakos 31 36 32 53
5 Thermaikos Thermis Thermaikos 32 42 31 52
6 Enosi Thraki Enosi Thraki 32 27 26 47
7 Preveza Preveza 32 39 28 45
8 Ethnikos Katerini Ethnikos 32 35 27 45
9 Anagennisi Giannitsa Anagennisi 32 46 39 45
10 Niki Volos Niki Volos 32 37 33 44
11 Eordaikos Eordaikos 32 26 29 43
12 Anagennisi Arta Anagennisi 32 39 36 41
13 Lamia Lamia 32 30 32 40
14 Polykastro Polykastro 32 26 41 31
15 GS Prosotsani Prosotsani 31 25 36 30
16 AE Giannina AE Giannina 31 30 42 24
17 Doxa Dramas Doxa Dramas 32 6 86 6
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Pierikos Pierikos 32 64 23 75
2 Olympiakos Volos Olympiakos 32 56 17 73
3 Lamia Lamia 31 46 34 62
4 Thermaikos Thermis Thermaikos 31 46 21 61
5 Kavala Kavala 32 35 31 47
6 Anagennisi Karditsas Anagennisi 32 35 34 45
7 Doxa Dramas Doxa Dramas 32 23 23 41
8 Polykastro Polykastro 32 24 31 40
9 Enosi Thraki Enosi Thraki 32 34 29 39
10 AE Giannina AE Giannina 32 30 31 39
11 Ethnikos Katerini Ethnikos 32 32 41 39
12 Paone Paone 31 31 35 37
13 Anagennisi Arta Anagennisi 32 31 38 37
14 Trikala Trikala 31 30 40 36
15 Gravia Gravia 32 31 39 31
16 Nafpaktiakos Asteras Nafpaktiakos 32 23 51 24
17 Gratini Gratini 32 18 71 17
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Agrotikos Asteras Agrotikos 30 63 18 70
2 Panthrakikos Panthrakikos 30 44 21 66
3 PAS Giannina Giannina 29 52 13 65
4 Pierikos Pierikos 30 42 30 46
5 AE Giannina AE Giannina 30 31 22 44
6 Doxa Dramas Doxa Dramas 30 41 36 43
7 Kavala Kavala 29 24 33 40
8 Anagennisi Arta Anagennisi 30 31 33 38
9 Enosi Thraki Enosi Thraki 30 33 37 38
10 Thermaikos Thermis Thermaikos 30 32 41 34
11 Anagennisi Karditsas Anagennisi 30 20 34 33
12 Trikala Trikala 30 32 42 30
13 Lamia Lamia 30 26 37 30
14 Polykastro Polykastro 29 24 40 29
15 AEP Kozani AEP Kozani 30 33 52 28
16 Eordaikos Eordaikos 29 20 59 16
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Veria NPS Veria NPS 32 65 28 69
2 PAS Giannina Giannina 32 56 29 65
3 Kavala Kavala 32 49 36 56
4 Anagennisi Arta Anagennisi 32 50 34 54
5 Lamia Lamia 31 44 44 50
6 Enosi Thraki Enosi Thraki 32 35 35 49
7 Doxa Dramas Doxa Dramas 32 37 34 48
8 AEP Kozani AEP Kozani 31 38 39 47
9 Panaitolikos Panaitolikos 32 38 32 45
10 Agrotikos Asteras Agrotikos 32 47 42 45
11 Thermaikos Thermis Thermaikos 32 35 33 44
12 Anagennisi Karditsas Anagennisi 32 36 35 43
13 Eordaikos Eordaikos 32 22 35 39
14 Pavlos Melas Pavlos Melas 31 33 46 36
15 Pandramaikos Pandramaikos 31 18 45 25
16 Apollon Larisas Apollon 32 21 48 23
17 Iltex Lykoi Iltex Lykoi 32 28 57 20
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Kastoria Kastoria 38 67 27 80
2 Apollon Larisas Apollon 38 58 34 77
3 Ilysiakos AO Ilysiakos 38 65 26 76
4 Thrasyvoulos Thrasyvoulos 38 51 28 71
5 Agrotikos Asteras Agrotikos 38 54 39 61
6 Rodos Rodos 38 59 43 59
7 Aharnaikos Aharnaikos 38 46 38 59
8 Veria NPS Veria NPS 38 46 38 57
9 Atsalenios Atsalenios 38 48 42 54
10 Doxa Dramas Doxa Dramas 38 40 38 50
11 Chalkida Chalkida 38 39 43 50
12 Marko Marko 38 42 42 49
13 Agios Dimitrios Agios 38 46 50 47
14 Thyella Patras Thyella 38 29 35 47
15 Vyzas Megara Vyzas Megara 38 37 52 44
16 Iltex Lykoi Iltex Lykoi 38 41 44 43
17 Kavala Kavala 38 31 44 43
18 Leonidio Leonidio 38 27 59 31
19 Pontiakos Pontiakos 38 19 70 27
20 Kilkisiakos Kilkisiakos 38 26 79 24
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Poseidon Neon Poron Poseidon 38 77 40 82
2 Ergotelis Ergotelis 37 74 28 79
3 Levadiakos Levadiakos 38 63 41 78
4 Niki Volos Niki Volos 38 39 26 67
5 Agrotikos Asteras Agrotikos 38 58 40 62
6 Thrasyvoulos Thrasyvoulos 38 51 29 60
7 Kilkisiakos Kilkisiakos 38 67 47 60
8 Agios Dimitrios Agios 38 49 39 57
9 Aharnaikos Aharnaikos 38 45 45 57
10 Marko Marko 38 44 40 56
11 Leonidio Leonidio 37 37 31 54
12 Iltex Lykoi Iltex Lykoi 38 43 42 53
13 Kastoria Kastoria 38 38 42 48
14 Vyzas Megara Vyzas Megara 38 35 39 46
15 Apollon Larisas Apollon 38 33 41 46
16 Ethnikos Piraeus Ethnikos 38 30 50 39
17 Hania Hania 38 37 66 39
18 Agios Nikolaos Agios 38 31 37 37
19 Trikala Trikala 38 24 70 19
20 Nafpaktiakos Asteras Nafpaktiakos 38 23 105 12
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Kerkyra Kerkyra 30 44 17 63
2 Kassandra FC Kassandra 29 42 18 62
3 Fostiras Fostiras 30 51 28 59
4 Kavala Kavala 29 49 21 54
5 Atromitos Atromitos 30 44 29 51
6 Kilkisiakos Kilkisiakos 30 35 27 47
7 Apollon Larisas Apollon 30 37 34 42
8 Ethnikos Piraeus Ethnikos 30 38 41 41
9 Marko Marko 30 37 41 41
10 Chania Chania 30 35 37 40
11 Panelefsiniakos Panelefsinia 30 24 43 32
12 Leonidio Leonidio 30 25 35 28
13 Trikala Trikala 30 17 32 28
14 Nafpaktiakos Asteras Nafpaktiakos 30 24 37 26
15 Panaitolikos Panaitolikos 30 24 46 25
16 Apollon K.V. Apollon K.V. 30 14 54 14
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 Patraikos Patraikos 30 69 20 74
2 Halkidona Halkidona 31 56 25 60
3 Atromitos Atromitos 30 62 29 59
4 Ethnikos Piraeus Ethnikos 30 58 33 59
5 Leonidio Leonidio 30 58 35 55
6 Marko Marko 30 50 31 51
7 Apollon K.V. Apollon K.V. 30 48 47 47
8 Naoussa Naoussa 30 36 37 46
9 Kilkisiakos Kilkisiakos 30 47 43 45
10 Aharnaikos Aharnaikos 30 42 43 43
11 AEP Kozani AEP Kozani 30 44 48 38
12 Veria NPS Veria NPS 30 39 51 37
13 Ambelokipoi Ambelokipoi 30 36 54 36
14 Lamia Lamia 29 27 36 30
15 Anagennisi Karditsas Anagennisi 30 25 50 26
16 Iltex Lykoi Iltex Lykoi 30 22 49 20
17 Pierikos Pierikos 30 24 55 17
18 Ialysos Ialysos 30 22 79 16

  USO DE MEMORIA  
7,510,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.5064
Total Execution Time  0.5086
  CADENA URL  
/3_league_grecia2022/grupo1/historico
  GET DATOS  
$_GET['/3_league_grecia2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0105  SELECT type FROM routes WHERE alias = '3_league_grecia2022'
0.0213  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 = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0106  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 = 65484 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 344 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0109  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 = 65484 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.0112  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 = 59057 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.0112  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 = 51441 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.0109  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 = 45473 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 40660 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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.0110  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 = 15926 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 12485 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 12262 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  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 `tables2013` 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 = 2781 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 24775 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2011` 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 = 24791 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables2010` 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 = 24842 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 `tables2009` 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 = 24846 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 `tables2008` 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 = 24849 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 `tables2007` 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 = 24851 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 `tables2006` 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 = 24853 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables2005` 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 = 24855 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 `tables2004` 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 = 24857 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 `tables2003` 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 = 24858 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 `tables2002` 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 = 24859 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 `tables2001` 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 = 24860 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-18 10:17:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-18 10:17:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-18 10:17:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-18 10:17:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0120  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 = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0117  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 events2022 e ON e.player_id = p.id AND e.league_id = 65484 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65484 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.0116  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 events2022 e ON e.player_id = p.id AND e.league_id = 65484 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65484 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0106  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 events2022 e ON e.player_id = p.id AND e.league_id = 65484 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65484 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0115  SELECT *,(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 = 65484 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