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 2
Equipo PJ GF GC Puntos
1 AEK Larnaca AEK Larnaca 8 11 3 19
2 Omonia Nicosia Omonia 8 11 6 16
3 APOEL APOEL 8 8 6 13
4 Pafos Pafos 8 10 11 10
5 Anorthosis Anorthosis 8 7 14 5
6 Aris Limassol Aris 8 5 12 5
TEMPORADA 2022/2023
LIGA CHIPRE GRUPO 2
Equipo PJ GF GC Puntos
1 Aris Limassol Aris 36 65 28 74
2 APOEL APOEL 36 52 26 71
3 AEK Larnaca AEK Larnaca 36 55 37 66
4 Pafos Pafos 36 60 30 63
5 Apollon Limassol Apollon 35 47 37 62
6 Omonia Nicosia Omonia 36 43 42 49
TEMPORADA 2021/2022
LIGA CHIPRE GRUPO 2
Equipo PJ GF GC Puntos
1 Apollon Limassol Apollon 32 50 33 58
2 AEK Larnaca AEK Larnaca 32 44 29 54
3 APOEL APOEL 32 48 41 52
4 Aris Limassol Aris 32 37 32 50
5 Anorthosis Anorthosis 32 48 40 49
6 Pafos Pafos 32 39 30 46
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 3
Equipo PJ GF GC Puntos
1 Karmiotissa Karmiotissa 6 15 7 15
2 Aris Limassol Aris 6 7 4 13
3 Ayia Napa Ayia Napa 6 4 2 11
4 Ermis Aradippou Ermis 6 9 8 10
5 Onisilos Onisilos 6 6 8 7
6 ASIL Lysi ASIL Lysi 6 3 5 5
7 Othellos Athienou Othellos 6 7 13 4
8 Anagennisi Anagennisi 6 8 12 3
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
LIGA CHIPRE GRUPO 1
Equipo PJ GF GC Puntos
1 APOEL APOEL 26 72 25 63
2 Apollon Limassol Apollon 26 67 15 61
3 Anorthosis Anorthosis 26 41 17 56
4 AEK Larnaca AEK Larnaca 26 57 24 53
5 AEL Limassol Limassol 26 35 17 48
6 Omonia Nicosia Omonia 26 51 38 44
7 Doxa Katokopias Doxa 26 35 40 34
8 Ermis Aradippou Ermis 26 35 49 30
9 Pafos Pafos 26 23 38 26
10 Nea Salamis Nea Salamis 26 28 46 24
11 Alki Oroklini Alki 26 30 57 23
12 Olympiakos Nicosia Olympiakos 26 22 55 20
13 Aris Limassol Aris 26 19 49 16
14 Ethnikos Achnas Ethnikos 26 19 64 8
TEMPORADA 2016/2017
LIGA CHIPRE GRUPO 3
Equipo PJ GF GC Puntos
1 Nea Salamis Nea Salamis 10 11 11 45
2 Ethnikos Achnas Ethnikos 10 15 20 43
3 Ermis Aradippou Ermis 10 16 20 42
4 Aris Limassol Aris 10 17 13 41
5 Doxa Katokopias Doxa 10 20 14 37
6 Karmiotissa Karmiotissa 10 17 18 37
TEMPORADA 2015/2016
LIGA CHIPRE GRUPO 3
Equipo PJ GF GC Puntos
1 AEL Limassol Limassol 10 16 11 18
2 Ermis Aradippou Ermis 10 14 12 18
3 Ethnikos Achnas Ethnikos 10 16 14 15
4 Doxa Katokopias Doxa 10 15 18 11
5 Aris Limassol Aris 10 14 15 10
6 Pafos Pafos 10 6 11 9
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
LIGA CHIPRE GRUPO 1
Equipo PJ GF GC Puntos
1 AEL Limassol Limassol 26 48 16 62
2 Apollon Limassol Apollon 26 47 19 59
3 APOEL APOEL 26 56 18 59
4 Ermis Aradippou Ermis 26 44 28 52
5 Omonia Nicosia Omonia 26 45 22 47
6 Anorthosis Anorthosis 26 46 36 38
7 Nea Salamis Nea Salamis 26 26 31 38
8 AEK Larnaca AEK Larnaca 26 37 28 37
9 Doxa Katokopias Doxa 26 33 45 28
10 Ethnikos Achnas Ethnikos 26 27 38 23
11 Enosis Neon Paralimni Enosis Neon 26 29 45 22
12 AEK Kouklia AEK Kouklia 26 27 64 21
13 Aris Limassol Aris 26 29 40 20
14 Alki Alki 26 14 78 2
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
LIGA CHIPRE GRUPO 4
Equipo PJ GF GC Puntos
1 Ethnikos Achnas Ethnikos 6 10 7 40
2 Olympiakos Nicosia Olympiakos 6 7 10 39
3 Enosis Neon Paralimni Enosis Neon 6 9 5 38
4 Aris Limassol Aris 6 5 9 32

  USO DE MEMORIA  
6,634,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6829
Total Execution Time  0.6842
  CADENA URL  
/historico/Aris-Limassol-Fc
  GET DATOS  
$_GET['/historico/Aris-Limassol-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0253  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 = 75461
0.0132  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.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6491 AND type_rel = 2
0.0142  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6491 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 (158668,1028830,1038354,1145240,1162994) ORDER BY n.cover_points DESC, update_date DESC
0.0137  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 = '6491' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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.0128  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.0143  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=6491 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 (75461,74229,73873,72537,72104,72095,71432,67756) 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.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 75461 AND teamId = 6491
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 73873 AND teamId = 6491
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 72095 AND teamId = 6491
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 72104 AND teamId = 6491
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 67756 AND teamId = 6491
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 74229 AND teamId = 6491
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 72537 AND teamId = 6491
0.0141  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6491
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 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 = 73873 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '6491' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6491' and rp.type = 4
0.0127  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 = '6491' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0134  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 = 73873 WHERE rp.league_id = 73873 AND rp.teamId = 6491 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.0134  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 = 73873 WHERE rp.league_id = 73873 AND rp.teamId = 6491 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 73873 WHERE rp.league_id = 73873 AND rp.teamId = 6491 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 = 6491 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75461 AND t.round = 9 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 = 71175 AND t.round = 10 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 = 66907 AND t.round = 10 ORDER BY team.conference ASC,t.position 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 `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 = 51093 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.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 `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 = 55493 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.0144  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.0149  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 = 38697 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 `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.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 `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 = 38058 AND t.round = 10 ORDER BY team.conference 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 `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 = 15731 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 `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 = 15733 AND t.round = 10 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 `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.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 `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 = 10218 AND t.round = 10 ORDER BY team.conference 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 `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 = 2769 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.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 `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 = 10261 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC