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

Akritas Chlorakas

Entrenador: Denis Laktionov

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA CHIPRE GRUPO 3
Equipo PJ GF GC Puntos
1 PAEEK PAEEK 14 30 10 32
2 Digenis Morphou Digenis 14 27 13 32
3 Akritas Chlorakas Akritas 14 20 11 23
4 MEAP Nisou MEAP Nisou 14 18 19 18
5 Achyronas-Onisilos Achyronas-On 13 15 17 16
6 ENAD ENAD 13 17 19 13
7 Ermis Aradippou Ermis 14 11 28 13
8 Xylotympou Xylotympou 14 12 33 6
TEMPORADA 2022/2023
LIGA CHIPRE GRUPO 3
Equipo PJ GF GC Puntos
1 Anorthosis Anorthosis 40 52 44 63
2 Nea Salamis Nea Salamis 40 51 55 58
3 AEL Limassol Limassol 39 35 40 49
4 Karmiotissa Karmiotissa 40 37 54 48
5 Doxa Katokopias Doxa 40 32 56 39
6 Enosis Neon Paralimni Enosis Neon 40 40 52 37
7 Akritas Chlorakas Akritas 40 37 73 34
8 Olympiakos Nicosia Olympiakos 40 30 62 28
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
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Aris Limassol Aris 34 50 22 70
2 PAEEK PAEEK 34 68 28 70
3 Othellos Athienou Othellos 34 55 32 69
4 Ayia Napa Ayia Napa 34 51 36 60
5 Alki Oroklini Alki 34 56 38 53
6 Onisilos Onisilos 34 61 51 51
7 Omonia Aradippou Omonia 34 55 49 51
8 ASIL Lysi ASIL Lysi 34 34 34 46
9 Ahironas Ahironas 34 43 43 45
10 Anagennisi Anagennisi 34 50 50 44
11 Akritas Chlorakas Akritas 34 41 47 43
12 Xylotympou Xylotympou 34 42 45 41
13 Kouris Erimi Kouris Erimi 34 50 56 39
14 Digenis Morphou Digenis 34 43 53 37
15 Omonia Psevda Omonia 34 44 62 34
16 AE Zakakiou AE Zakakiou 34 32 51 34
17 EN THOI Lakatamia THOI 34 35 68 20
18 Digenis Ypsonas Digenis 34 32 77 19
TEMPORADA 2019/2020
SEGUNDA CHIPRE GRUPO 4
Equipo PJ GF GC Puntos
1 Alki Oroklini Alki 6 12 5 12
2 AE Zakakiou AE Zakakiou 6 5 1 12
3 Omonia Aradippou Omonia 6 9 6 11
4 Xylotympou Xylotympou 6 8 6 11
5 Digenis Morphou Digenis 6 6 7 9
6 Akritas Chlorakas Akritas 6 6 7 7
7 Digenis Ypsonas Digenis 6 5 11 5
8 Omonia Psevda Omonia 6 6 14 0
TEMPORADA 2018/2019
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Ethnikos Achnas Ethnikos 30 72 23 71
2 Olympiakos Nicosia Olympiakos 30 77 29 69
3 Aris Limassol Aris 30 62 33 68
4 Othellos Athienou Othellos 30 66 35 50
5 Anagennisi Anagennisi 30 46 33 46
6 Omonia Aradippou Omonia 30 46 39 45
7 ASIL Lysi ASIL Lysi 30 43 38 45
8 Onisilos Onisilos 30 42 49 39
9 Karmiotissa Karmiotissa 30 47 64 37
10 AE Zakakiou AE Zakakiou 30 42 55 37
11 Ayia Napa Ayia Napa 30 44 45 35
12 Akritas Chlorakas Akritas 30 37 61 35
13 EN THOI Lakatamia THOI 30 27 57 32
14 MEAP Nisou MEAP Nisou 30 42 55 28
15 PAEEK PAEEK 30 35 65 22
16 Digenis Voroklinis Digenis 30 28 75 14
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
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
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Aris Limassol Aris 26 41 20 50
2 Nea Salamis Nea Salamis 26 45 19 48
3 Omonia Aradippou Omonia 26 37 27 47
4 Anagennisi Anagennisi 26 28 25 42
5 Othellos Athienou Othellos 26 28 22 41
6 Atromitos Yeroskipou Atromitos 26 35 26 40
7 PAEEK PAEEK 26 36 36 36
8 Akritas Chlorakas Akritas 26 34 38 34
9 APEP APEP 26 33 34 33
10 Halkanoras Halkanoras 26 41 44 33
11 Onisilos Onisilos 26 26 30 32
12 ASIL Lysi ASIL Lysi 26 20 41 23
13 Digenis Morphou Digenis 26 24 45 21
14 Adonis Idaliou Adonis 26 24 45 19
TEMPORADA 2009/2010
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Alki Alki 26 44 24 55
2 AEK Larnaca AEK Larnaca 26 41 20 47
3 Olympiakos Nicosia Olympiakos 26 45 34 44
4 Othellos Athienou Othellos 26 31 28 39
5 Atromitos Yeroskipou Atromitos 26 35 31 37
6 Digenis Morphou Digenis 26 35 33 36
7 Omonia Aradippou Omonia 26 26 28 36
8 PAEEK PAEEK 26 24 27 36
9 ASIL Lysi ASIL Lysi 26 29 29 35
10 Onisilos Onisilos 26 30 31 33
11 Akritas Chlorakas Akritas 26 25 26 32
12 Frenaros 2000 Frenaros 26 26 32 28
13 Ayia Napa Ayia Napa 26 19 41 20
14 MEAP Nisou MEAP Nisou 26 19 45 14
TEMPORADA 2008/2009
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Akritas Chlorakas Akritas 26 46 23 54
2 Frenaros 2000 Frenaros 26 52 29 48
3 Othellos Athienou Othellos 26 35 23 46
4 AE Zakakiou AE Zakakiou 26 42 35 39
5 Digenis Voroklinis Digenis 26 36 32 39
6 AEK Kouklia AEK Kouklia 26 33 27 38
7 Kissos Kissonergas Kissos 26 36 38 38
8 Spartakos Kitiou Spartakos 26 48 37 37
9 Adonis Idaliou Adonis 26 39 31 36
10 Elpida Astromeritis Elpida 26 34 40 33
11 Anagennisi Anagennisi 26 32 35 32
12 Anagennisi Trahoniou Anagennisi 26 38 51 31
13 Orfeas FC Levkosia Orfeas 26 24 44 25
14 Olympos Xylofagou FC Olympos 26 26 76 7
TEMPORADA 2007/2008
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Pafos Pafos 26 46 22 54
2 APEP APEP 26 45 26 51
3 Digenis Morphou Digenis 26 44 26 46
4 Atromitos Yeroskipou Atromitos 26 41 23 46
5 Onisilos Onisilos 26 32 23 38
6 Ermis Aradippou Ermis 26 51 43 38
7 Ayia Napa Ayia Napa 26 32 32 34
8 Omonia Aradippou Omonia 26 25 24 33
9 ASIL Lysi ASIL Lysi 26 20 24 32
10 EN THOI Lakatamia THOI 26 28 40 31
11 MEAP Nisou MEAP Nisou 26 32 49 31
12 Anagennisi Anagennisi 26 21 35 30
13 Akritas Chlorakas Akritas 26 22 39 22
14 Olympos Olympos 26 23 56 16

  USO DE MEMORIA  
6,994,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5277
Total Execution Time  0.5290
  CADENA URL  
/historico/Akritas
  GET DATOS  
$_GET['/historico/Akritas']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0231  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 = 73446
0.0110  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17249 AND type_rel = 2
0.0127  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 = '17249' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0116  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 = 74229 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0113  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 = 73446 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111  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=17249 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (75145,74229,71432,71176) 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.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 71176 AND teamId = 17249
0.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 75145 AND teamId = 17249
0.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 74229 AND teamId = 17249
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17249
0.0107  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 = '17249' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0107  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17249' and rp.type = 4
0.0107  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 = '17249' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0115  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 = 73446 WHERE rp.league_id = 73446 AND rp.teamId = 17249 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.0114  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 = 73446 WHERE rp.league_id = 73446 AND rp.teamId = 17249 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  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 = 73446 WHERE rp.league_id = 73446 AND rp.teamId = 17249 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 17249 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0125  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 = 73446 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.0123  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 = 67847 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.0124  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 = 71176 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.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 `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 = 57796 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.0123  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 = 51094 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.0116  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 = 55494 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114  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 = 44927 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  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.0125  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.0124  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.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 `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.0135  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.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 `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.0124  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.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 `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 = 8743 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116  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 = 8742 AND t.round = 26 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 `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 = 23922 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 `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 = 8739 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC