4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA CHIPRE GRUPO 3
Equipo PJ GF GC Puntos
1 Ethnikos Achnas Ethnikos 11 25 15 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 11 12 19 8
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
TEMPORADA 2010/2011
TERCERA CHIPRE
Equipo PJ GF GC Puntos
TEMPORADA 2009/2010
TERCERA CHIPRE
Equipo PJ GF GC Puntos
TEMPORADA 2008/2009
TERCERA CHIPRE
Equipo PJ GF GC Puntos

  USO DE MEMORIA  
6,128,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  4.3497
Total Execution Time  4.3515
  CADENA URL  
/historico/Ae-Zakakiou
  GET DATOS  
$_GET['/historico/Ae-Zakakiou']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12546 AND type_rel = 2
0.1487  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.0020  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.1956  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '12546' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.2870  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.0248  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.0027  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 = 75462 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.2461  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.0164  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.1743  SELECT count(id) as num_players from rel_players WHERE league_id = 75462 AND teamId = 12546
0.0612  SELECT count(id) as num_players from rel_players WHERE league_id = 70914 AND teamId = 12546
0.4352  SELECT count(id) as num_players from rel_players WHERE league_id = 74229 AND teamId = 12546
0.1759  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12546
0.0759  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0228  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 = '12546' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0181  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12546' and rp.type = 4
0.0044  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 = '12546' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.3515  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.2394  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.1127  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.1982  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.0652  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.1093  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.0409  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.2790  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.0762  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.0649  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.1049  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.0848  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.0853  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.0974  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.1467  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.0377  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.1366  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.1366  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.1366  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.1366  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.1366  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.1366  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 75462 ORDER BY nameShow LIMIT 100