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

AE Zakakiou

Entrenador: Vladica Petrovic

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA CHIPRE GRUPO 3
Equipo PJ GF GC Puntos
1 Ethnikos Achnas Ethnikos 12 26 17 21
2 Apollon Limassol Apollon 11 18 9 21
3 AEL Limassol Limassol 11 21 16 20
4 Karmiotissa Karmiotissa 11 23 17 19
5 Doxa Katokopias Doxa 11 12 13 19
6 Othellos Athienou Othellos 11 21 20 12
7 Nea Salamis Nea Salamis 12 14 20 11
8 AE Zakakiou AE Zakakiou 11 9 32 1
TEMPORADA 2022/2023
SEGUNDA CHIPRE GRUPO 2
Equipo PJ GF GC Puntos
1 Othellos Athienou Othellos 14 23 13 29
2 Ethnikos Achnas Ethnikos 14 22 8 26
3 AE Zakakiou AE Zakakiou 14 23 12 25
4 Omonia 29is Omonia 29is 14 14 11 25
5 Achyronas-Onisilos Achyronas-On 14 16 21 13
6 Peyia Peyia 14 7 17 13
7 MEAP Nisou MEAP Nisou 14 11 26 11
8 Omonia Aradippou Omonia 14 7 15 9
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
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
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
LIGA CHIPRE GRUPO 1
Equipo PJ GF GC Puntos
1 APOEL APOEL 26 62 16 62
2 AEK Larnaca AEK Larnaca 26 54 19 58
3 Apollon Limassol Apollon 26 56 19 57
4 AEL Limassol Limassol 26 40 22 51
5 Omonia Nicosia Omonia 26 56 37 50
6 Anorthosis Anorthosis 26 39 27 39
7 Ermis Aradippou Ermis 26 35 41 35
8 Nea Salamis Nea Salamis 26 22 33 31
9 Ethnikos Achnas Ethnikos 26 42 46 30
10 Karmiotissa Karmiotissa 26 30 53 27
11 Aris Limassol Aris 26 30 52 24
12 Doxa Katokopias Doxa 26 20 38 20
13 AE Zakakiou AE Zakakiou 26 20 63 11
14 Anagennisi Anagennisi 26 18 58 7
TEMPORADA 2015/2016
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Olympiakos Nicosia Olympiakos 26 51 19 62
2 Karmiotissa Karmiotissa 26 54 19 61
3 Anagennisi Anagennisi 26 50 18 59
4 AE Zakakiou AE Zakakiou 26 47 19 58
5 Othellos Athienou Othellos 26 55 24 56
6 PAEEK PAEEK 26 32 29 33
7 ENAD ENAD 26 30 32 33
8 EN THOI Lakatamia THOI 26 44 49 33
9 Omonia Aradippou Omonia 26 28 29 32
10 EN Parekklisias Parekklisias 26 35 37 27
11 ASIL Lysi ASIL Lysi 26 32 36 26
12 Elpida Astromeritis Elpida 26 24 60 15
13 N&S Erimis N&S Erimis 26 13 79 9
14 Digenis Voroklinis Digenis 26 16 61 8
TEMPORADA 2014/2015
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Pafos Pafos 26 55 19 62
2 Enosis Neon Paralimni Enosis Neon 26 55 14 60
3 Aris Limassol Aris 26 35 25 52
4 AE Zakakiou AE Zakakiou 26 29 19 44
5 Karmiotissa Karmiotissa 26 36 29 38
6 Anagennisi Anagennisi 26 27 26 38
7 Olympiakos Nicosia Olympiakos 26 34 42 35
8 Elpida Astromeritis Elpida 26 29 34 34
9 ENAD ENAD 26 30 30 29
10 N&S Erimis N&S Erimis 26 35 48 29
11 Omonia Aradippou Omonia 26 35 37 28
12 EN Parekklisias Parekklisias 26 28 38 28
13 Digenis Voroklinis Digenis 26 16 49 18
14 APEP APEP 26 18 52 14
TEMPORADA 2013/2014
SEGUNDA CHIPRE GRUPO 2
Equipo PJ GF GC Puntos
1 Karmiotissa Karmiotissa 18 40 16 36
2 EN Parekklisias Parekklisias 18 21 18 31
3 Chalkanoras Idaliou Chalkanoras 18 26 22 27
4 AE Zakakiou AE Zakakiou 18 17 28 23
5 Digenis Voroklinis Digenis 18 20 18 22
6 Onisilos Onisilos 18 15 23 20
7 PAEEK PAEEK 18 15 17 19
8 ASIL Lysi ASIL Lysi 18 14 26 19
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
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 AEK Kouklia AEK Kouklia 26 62 16 61
2 N&S Erimis N&S Erimis 26 42 26 53
3 AE Zakakiou AE Zakakiou 26 43 28 52
4 ASIL Lysi ASIL Lysi 26 56 26 46
5 Adonis Idaliou Adonis 26 43 33 42
6 ENAD ENAD 26 39 33 38
7 Spartakos Kitiou Spartakos 26 36 28 37
8 Digenis Morphou Digenis 26 33 35 33
9 Frenaros 2000 Frenaros 26 29 33 32
10 Elpida Astromeritis Elpida 26 26 36 31
11 Ormideia Ormideia 26 27 33 30
12 Ahironas Ahironas 26 32 46 28
13 Anagennisi Germasogeias Anagennisi 26 21 38 23
14 Maroniou Maroniou 26 0 78 0
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
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

  USO DE MEMORIA  
6,642,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.5818
Total Execution Time  0.5835
  CADENA URL  
/historico/Ae-Zakakiou
  GET DATOS  
$_GET['/historico/Ae-Zakakiou']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0285  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 = 74229
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12546 AND type_rel = 2
0.0138  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12546 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0129  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (157404) ORDER BY n.cover_points DESC, update_date DESC
0.0138  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 = '12546' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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 = 72108 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136  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=12546 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (75462,74229,71432,70914) 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.0138  SELECT count(id) as num_players from rel_players WHERE league_id = 75462 AND teamId = 12546
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 70914 AND teamId = 12546
0.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 74229 AND teamId = 12546
0.0144  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12546
0.0175  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 = 75462 WHERE rp.league_id = 75462 AND rp.teamId = 12546 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.0154  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 = 75462 WHERE rp.league_id = 75462 AND rp.teamId = 12546 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 75462 WHERE rp.league_id = 75462 AND rp.teamId = 12546 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 = 12546 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75462 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 69228 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.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 `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 = 70914 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.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 `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.0131  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.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 `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.0129  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.0130  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.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 `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.0129  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 = 33682 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 15734 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 `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 = 4169 AND t.round = 26 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 `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 = 2771 AND t.round = 28 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 `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.0131  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 = 23919 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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.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 `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.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 `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