4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ethnikos Assias
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
TERCERA CHIPRE GRUPO 2
Equipo PJ GF GC Puntos
1 ENAD ENAD 14 32 14 33
2 Digenis Morphou Digenis 14 30 11 28
3 ASIL Lysi ASIL Lysi 14 22 11 26
4 APEA APEA 14 15 15 19
5 Iraklis Yerolakkou Iraklis 14 13 19 17
6 ASPIS Pylas ASPIS Pylas 14 18 31 15
7 Ethnikos Assias Ethnikos 14 15 34 12
8 AEP Polemidion Polemidion 14 12 22 7
TEMPORADA 2021/2022
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Peyia Peyia 26 42 12 57
2 MEAP Nisou MEAP Nisou 26 41 23 49
3 Digenis Ypsonas Digenis 26 41 26 48
4 AE Zakakiou AE Zakakiou 26 44 26 47
5 Digenis Morphou Digenis 26 45 25 43
6 Elia Lythrodonta Elia 26 35 36 35
7 Iraklis Yerolakkou Iraklis 26 35 40 32
8 Kouris Erimi Kouris Erimi 26 29 36 29
9 EN THOI Lakatamia THOI 26 32 35 29
10 APEP APEP 26 32 40 29
11 Ethnikos Assias Ethnikos 26 26 43 28
12 Ormideia Ormideia 26 27 42 28
13 Halkanoras Halkanoras 26 28 44 25
14 Omonia Psevda Omonia 26 33 62 21
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 2019/2020
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Ahironas Ahironas 22 49 26 49
2 PAEEK PAEEK 22 48 20 46
3 Kouris Erimi Kouris Erimi 22 43 23 45
4 EN THOI Lakatamia THOI 22 39 23 41
5 Halkanoras Halkanoras 22 45 31 39
6 MEAP Nisou MEAP Nisou 22 47 31 37
7 Elpida Astromeritis Elpida 22 39 36 36
8 Elia Lythrodonta Elia 22 31 25 32
9 Iraklis Yerolakkou Iraklis 22 29 25 30
10 APONA Anagias APONA 22 26 36 28
11 Ormideia Ormideia 22 33 26 25
12 Ethnikos Assias Ethnikos 22 32 41 23
13 Amathous Amathous 22 21 42 17
14 O Kormakitis Kormakitis 22 20 45 17
15 Digenis Voroklinis Digenis 22 20 59 9
16 ENAD ENAD 22 18 51 8
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
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Enosis Neon Paralimni Enosis Neon 26 54 20 60
2 Anagennisi Anagennisi 26 53 23 59
3 Othellos Athienou Othellos 26 45 19 54
4 Ayia Napa Ayia Napa 26 43 33 42
5 AE Zakakiou AE Zakakiou 26 36 26 41
6 Omonia Aradippou Omonia 26 39 33 38
7 Karmiotissa Karmiotissa 26 41 36 37
8 ASIL Lysi ASIL Lysi 26 32 35 32
9 PAEEK PAEEK 26 33 40 31
10 Digenis Voroklinis Digenis 26 30 50 28
11 EN THOI Lakatamia THOI 26 25 39 26
12 Xylotympou Xylotympou 26 29 44 26
13 Ethnikos Assias Ethnikos 26 22 42 18
14 Halkanoras Halkanoras 26 23 65 12
TEMPORADA 2016/2017
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Alki Oroklini Alki 26 60 16 64
2 Pafos Pafos 26 51 24 57
3 Olympiakos Nicosia Olympiakos 26 44 23 54
4 Othellos Athienou Othellos 26 53 33 49
5 Ayia Napa Ayia Napa 26 52 28 46
6 Enosis Neon Paralimni Enosis Neon 26 41 32 44
7 EN THOI Lakatamia THOI 26 32 34 33
8 ASIL Lysi ASIL Lysi 26 27 33 30
9 PAEEK PAEEK 26 26 38 24
10 Ethnikos Assias Ethnikos 26 24 52 23
11 Omonia Aradippou Omonia 26 16 30 22
12 Akritas Chlorakas Akritas 26 24 45 19
13 ENAD ENAD 26 26 52 19
14 EN Parekklisias Parekklisias 26 28 64 19
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
TEMPORADA 2014/2015
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 EN THOI Lakatamia THOI 26 46 17 57
2 ASIL Lysi ASIL Lysi 26 37 16 46
3 Digenis Ypsonas Digenis 26 36 29 41
4 PAEEK PAEEK 26 36 30 41
5 MEAP Nisou MEAP Nisou 26 33 32 39
6 Akritas Chlorakas Akritas 26 37 37 36
7 Ahironas Ahironas 26 33 29 35
8 Ethnikos Latsion Ethnikos 26 28 31 34
9 Amathous Amathous 26 40 46 33
10 Ethnikos Assias Ethnikos 26 30 36 33
11 Chalkanoras Idaliou Chalkanoras 26 37 41 30
12 Ormideia Ormideia 26 32 38 28
13 Digenis Morphou Digenis 26 21 37 23
14 Foinikas Agia Marina Foinikas 26 20 47 13
TEMPORADA 2013/2014
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Elpida Astromeritis Elpida 26 43 10 62
2 ENAD ENAD 26 59 20 60
3 EN THOI Lakatamia THOI 26 58 24 54
4 Ahironas Ahironas 26 42 25 45
5 MEAP Nisou MEAP Nisou 26 35 40 38
6 Ormideia Ormideia 26 32 31 36
7 Foinikas Agia Marina Foinikas 26 41 40 36
8 Ethnikos Assias Ethnikos 26 37 46 35
9 Akritas Chlorakas Akritas 26 25 35 32
10 Ethnikos Latsion Ethnikos 26 27 38 30
11 Digenis Morphou Digenis 26 24 40 25
12 Spartakos Kitiou Spartakos 26 31 52 25
13 Adonis Idaliou Adonis 26 33 51 17
14 Constantinos Constantinos 26 31 66 12
TEMPORADA 2012/2013
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Aris Limassol Aris 26 64 21 55
2 Ermis Aradippou Ermis 26 41 23 52
3 AE Kouklion AE Kouklion 26 55 28 50
4 Anagennisi Anagennisi 26 28 23 43
5 APEP APEP 26 35 25 42
6 N&S Erimis N&S Erimis 26 37 33 41
7 Omonia Aradippou Omonia 26 40 40 35
8 Othellos Athienou Othellos 26 28 35 34
9 PAEEK PAEEK 26 35 37 33
10 AE Zakakiou AE Zakakiou 26 34 45 32
11 Halkanoras Halkanoras 26 34 42 29
12 Onisilos Onisilos 26 21 32 29
13 Akritas Chlorakas Akritas 26 23 42 14
14 Ethnikos Assias Ethnikos 26 25 74 12
TEMPORADA 2011/2012
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Doxa Katokopias Doxa 26 36 20 50
2 Ayia Napa Ayia Napa 26 39 17 49
3 Pafos Pafos 26 40 23 49
4 APOP Kinyras APOP Kinyras 26 41 23 43
5 PAEEK PAEEK 26 24 28 36
6 Othellos Athienou Othellos 26 30 31 34
7 Akritas Chlorakas Akritas 26 37 40 34
8 Onisilos Onisilos 26 23 26 34
9 Ethnikos Assias Ethnikos 26 29 38 34
10 APEP APEP 26 26 38 33
11 Omonia Aradippou Omonia 26 40 34 32
12 Halkanoras Halkanoras 26 28 29 32
13 EN Parekklisias Parekklisias 26 21 33 28
14 Atromitos Yeroskipou Atromitos 26 10 44 7
TEMPORADA 2010/2011
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Ethnikos Assias Ethnikos 26 43 23 52
2 EN Parekklisias Parekklisias 26 49 29 48
3 Ayia Napa Ayia Napa 26 39 14 47
4 ENAD ENAD 26 36 24 47
5 Spartakos Kitiou Spartakos 26 38 33 40
6 AEK Kouklia AEK Kouklia 26 32 36 39
7 Frenaros 2000 Frenaros 26 28 23 34
8 AE Zakakiou AE Zakakiou 26 35 46 33
9 Anagennisi Germasogeias Anagennisi 26 31 38 31
10 N&S Erimis N&S Erimis 26 33 41 29
11 Elpida Astromeritis Elpida 26 25 34 29
12 Digenis Voroklinis Digenis 26 31 41 24
13 MEAP Nisou MEAP Nisou 26 31 44 21
14 Iraklis Yerolakkou Iraklis 26 24 49 17
TEMPORADA 2009/2010
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Halkanoras Halkanoras 26 74 24 59
2 Adonis Idaliou Adonis 26 47 28 47
3 Anagennisi Anagennisi 26 42 29 46
4 AE Zakakiou AE Zakakiou 26 42 41 37
5 AE Kouklion AE Kouklion 26 37 39 35
6 ENAD ENAD 26 38 37 34
7 Elpida Astromeritis Elpida 26 25 32 34
8 Spartakos Kitiou Spartakos 26 41 36 33
9 Ethnikos Assias Ethnikos 26 32 40 32
10 Iraklis Yerolakkou Iraklis 26 40 50 32
11 Digenis Voroklinis Digenis 26 36 50 31
12 Kissos Kissonergas Kissos 26 31 36 29
13 EN THOI Lakatamia THOI 26 37 48 27
14 Ahironas Ahironas 26 20 52 21
TEMPORADA 2008/2009
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Ermis Aradippou Ermis 26 47 26 50
2 Aris Limassol Aris 26 56 25 49
3 Nea Salamis Nea Salamis 26 38 21 49
4 Olympiakos Nicosia Olympiakos 26 39 21 48
5 Digenis Morphou Digenis 26 38 28 44
6 Omonia Aradippou Omonia 26 33 41 37
7 MEAP Nisou MEAP Nisou 26 25 28 36
8 Onisilos Onisilos 26 30 36 31
9 Ayia Napa Ayia Napa 26 23 31 31
10 ASIL Lysi ASIL Lysi 26 29 30 30
11 PAEEK PAEEK 26 27 31 29
12 EN THOI Lakatamia THOI 26 31 46 25
13 Halkanoras Halkanoras 26 28 48 25
14 Ethnikos Assias Ethnikos 26 30 62 17
TEMPORADA 2001/2002
LIGA CHIPRE
Equipo PJ GF GC Puntos
1 APOEL APOEL 26 66 22 59
2 Anorthosis Anorthosis 26 71 31 58
3 AEL Limassol Limassol 26 47 27 54
4 Omonia Nicosia Omonia 25 55 33 53
5 Olympiakos Nicosia Olympiakos 26 53 45 42
6 AEK Larnaca AEK Larnaca 26 56 42 41
7 Ethnikos Achnas Ethnikos 25 44 37 39
8 Enosis Neon Paralimni Enosis Neon 26 42 38 39
9 Apollon Limassol Apollon 26 56 48 36
10 Pafos Pafos 26 54 46 36
11 Alki Alki 26 37 37 31
12 Ethnikos Assias Ethnikos 26 40 70 18
13 Doxa Katokopias Doxa 26 30 84 9
14 Ermis Aradippou Ermis 26 16 107 1
TEMPORADA 1999/2000
LIGA CHIPRE
Equipo PJ GF GC Puntos
1 Anorthosis Anorthosis 26 82 28 65
2 Omonia Nicosia Omonia 26 71 27 59
3 APOEL APOEL 26 58 31 46
4 Nea Salamis Nea Salamis 26 58 34 43
5 Apollon Limassol Apollon 26 49 44 42
6 AEL Limassol Limassol 26 45 42 42
7 AEK Larnaca AEK Larnaca 26 42 38 41
8 Enosis Neon Paralimni Enosis Neon 26 50 50 36
9 Olympiakos Nicosia Olympiakos 26 57 58 36
10 Ethnikos Achnas Ethnikos 26 42 36 35
11 APOP Paphos APOP Paphos 26 38 47 32
12 Ethnikos Assias Ethnikos 26 35 38 31
13 Anagennisi Anagennisi 26 22 87 12
14 Alki Alki 26 20 109 3

  USO DE MEMORIA  
6,853,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1019
Total Execution Time  0.1032
  CADENA URL  
/historico/Ethnikos-Assias
  GET DATOS  
$_GET['/historico/Ethnikos-Assias']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
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 = 73512
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 = 75147
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17255 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=578 AND type_rel = 3
0.0022  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 = '17255' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 73512 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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 = 17255 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 = 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.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 `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 = 69229 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.0025  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 = 70986 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.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 `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 = 64646 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.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 `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.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 `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 = 51095 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 `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.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 `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 = 38801 AND t.round = 26 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 `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 = 33687 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 `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
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 = 4165 AND t.round = 26 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 `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 = 3551 AND t.round = 26 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 `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 = 8746 AND t.round = 26 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 = 8744 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 23920 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 23921 AND t.round = 26 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 `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 = 8740 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 `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 = 8721 AND t.round = 26 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 `tables2000` 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 = 8713 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC