4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 33 75 30 75
2 Panathinaikos Panathinaiko 33 79 30 71
3 Olympiacos Piraeus Olympiacos 33 73 31 70
4 PAOK PAOK 32 76 30 68
5 Aris Thessaloniki Aris 33 45 40 49
6 Lamia Lamia 34 40 71 35
TEMPORADA 2022/2023
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 36 69 17 83
2 Panathinaikos Panathinaiko 36 47 16 78
3 Olympiacos Piraeus Olympiacos 36 70 24 73
4 PAOK PAOK 36 57 32 67
5 Aris Thessaloniki Aris 36 55 41 51
6 Volos New Football Volos 36 35 66 40
TEMPORADA 2021/2022
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 36 62 26 83
2 PAOK PAOK 36 58 33 64
3 Aris Thessaloniki Aris 36 39 28 62
4 Panathinaikos Panathinaiko 36 52 26 61
5 AEK Athens AEK Athens 36 56 42 56
6 PAS Giannina Giannina 36 34 42 46
TEMPORADA 2020/2021
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 36 82 19 90
2 PAOK PAOK 36 60 34 64
3 Aris Thessaloniki Aris 36 41 26 61
4 AEK Athens AEK Athens 36 53 45 60
5 Panathinaikos Panathinaiko 36 41 34 53
6 Asteras Tripolis Asteras 36 36 38 51
TEMPORADA 2019/2020
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 10 21 7 91
2 PAOK PAOK 10 8 6 73
3 AEK Athens AEK Athens 10 17 10 69
4 Panathinaikos Panathinaiko 10 8 9 58
5 Aris Thessaloniki Aris 10 10 19 42
6 OFI OFI 10 8 21 36
TEMPORADA 2018/2019
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 PAOK PAOK 30 66 14 80
2 Olympiacos Piraeus Olympiacos 30 71 17 75
3 AEK Athens AEK Athens 30 50 19 57
4 Atromitos Atromitos 30 41 28 52
5 Aris Thessaloniki Aris 30 46 33 49
6 Panionios Panionios 30 27 45 38
7 Lamia Lamia 30 28 37 37
8 Panathinaikos Panathinaiko 30 38 30 36
9 Panaitolikos Panaitolikos 30 34 48 36
10 AE Larisa AE Larisa 30 26 34 34
11 Asteras Tripolis Asteras 30 25 30 33
12 Xanthi Xanthi 30 22 34 32
13 OFI OFI 30 30 42 32
14 PAS Giannina Giannina 30 19 38 27
15 Levadiakos Levadiakos 30 15 45 21
16 Apollon Smyrnis Apollon 30 11 55 10
TEMPORADA 2017/2018
FOOTBALL LEAGUE GRECIA
Equipo PJ GF GC Puntos
1 OFI OFI 34 86 14 86
2 Aris Thessaloniki Aris 34 65 13 85
3 Panachaiki Panachaiki 34 50 21 73
4 Chania Chania 34 64 32 64
5 Doxa Dramas Doxa Dramas 34 57 25 63
6 Trikala Trikala 34 31 22 58
7 Apollon Pontou Apollon 34 43 27 53
8 Karaiskakis Karaiskakis 34 35 32 48
9 Ergotelis Ergotelis 34 56 47 46
10 Apollon Larisas Apollon 34 45 54 43
11 Aiginiakos Aiginiakos 34 36 54 37
12 Sparti Sparti 34 29 46 34
13 Anagennisi Karditsas Anagennisi 34 32 41 34
14 Panserraikos FC Panserraikos 34 43 52 27
15 Panegialios Panegialios 34 29 57 25
16 Athens Kallithea Athens 34 26 40 21
17 Veria NPS Veria NPS 33 13 70 5
18 Acharnaikos Acharnaikos 33 2 95 0
TEMPORADA 2016/2017
FOOTBALL LEAGUE GRECIA
Equipo PJ GF GC Puntos
1 Apollon Smyrnis Apollon 34 61 14 83
2 Lamia Lamia 34 55 11 80
3 Aris Thessaloniki Aris 34 58 17 77
4 OFI OFI 34 68 20 72
5 Trikala Trikala 34 65 19 71
6 Agrotikos Asteras Agrotikos 34 49 35 52
7 Sparti Sparti 34 38 42 45
8 Panserraikos FC Panserraikos 34 38 44 44
9 Panegialios Panegialios 34 33 28 44
10 Aiginiakos Aiginiakos 34 44 52 41
11 Chania Chania 34 29 38 40
12 Anagennisi Karditsas Anagennisi 34 26 38 39
13 Acharnaikos Acharnaikos 34 38 51 36
14 Chania Chania 34 37 60 35
15 Athens Kallithea Athens 34 42 49 33
16 Panelefsiniakos Panelefsinia 34 21 56 28
17 Kalloni Kalloni 34 21 75 7
18 Panthrakikos Panthrakikos 34 7 81 0
TEMPORADA 2015/2016
TERCERA GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Aris Thessaloniki Aris 32 76 17 87
2 Nestos Chrisoupolis Nestos 32 66 35 66
3 Doxa Dramas Doxa Dramas 32 47 24 63
4 Kavala Kavala 32 53 24 58
5 Apollon Pontou Apollon 32 46 29 53
6 Langadas Langadas 32 50 35 53
7 Ethnikos Neo Agioneri FC Ethnikos 32 35 25 50
8 Kampaniakos Chalastra Kampaniakos 32 45 31 47
9 Eordaikos Eordaikos 32 35 35 46
10 AEP Kozani AEP Kozani 32 41 49 44
11 Byzantio Kokkinokhóma Byzantio 32 47 51 37
12 Thyella Filotas Thyella 32 32 38 35
13 Apollon Krya Vrysi Apollon Krya 32 27 43 34
14 Iraklis Ampelokipoi Iraklis 32 33 57 28
15 Ethnikos Alexandroupoli Ethnikos 32 20 45 27
16 Evros Soufli Evros Soufli 32 32 86 22
17 Ethnikos Gazoros Ethnikos 32 10 71 11
TEMPORADA 2014/2015
TERCERA GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Panserraikos FC Panserraikos 30 52 15 74
2 Aris Thessaloniki Aris 30 51 12 71
3 Kavala Kavala 30 54 16 67
4 Doxa Dramas Doxa Dramas 30 43 26 52
5 Kampaniakos Chalastra Kampaniakos 30 53 34 47
6 Ethnikos Neo Agioneri FC Ethnikos 30 40 34 42
7 Iraklis Ampelokipoi Iraklis 30 32 30 41
8 Thyella Filotas Thyella 30 32 31 40
9 Byzantio Kokkinokhóma Byzantio 30 44 49 40
10 Ethnikos Alexandroupoli Ethnikos 30 28 28 38
11 Evros Soufli Evros Soufli 30 32 34 37
12 Aris Akropotamos Aris 30 32 45 34
13 Apollon Arnaia Apollon 30 26 45 27
14 Orfeas Eleftheroupoli Orfeas 30 26 43 22
15 Anagennisi Giannitsa Anagennisi 30 19 62 20
16 Kastoria Kastoria 30 15 75 10
TEMPORADA 2013/2014
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 34 88 19 86
2 PAOK PAOK 34 68 37 69
3 Panathinaikos Panathinaiko 34 57 28 66
4 Atromitos Atromitos 34 54 25 66
5 Asteras Tripolis Asteras 34 46 35 58
6 Ergotelis Ergotelis 34 39 40 44
7 OFI OFI 34 30 39 44
8 Panaitolikos Panaitolikos 34 32 33 42
9 Levadiakos Levadiakos 34 42 61 42
10 PAS Giannina Giannina 34 34 43 41
11 Panthrakikos Panthrakikos 34 39 52 41
12 Panionios Panionios 34 33 42 39
13 Kalloni Kalloni 34 31 62 39
14 Platanias Platanias 34 39 48 38
15 Veria NPS Veria NPS 34 31 51 38
16 Xanthi Xanthi 34 44 54 38
17 Apollon Smyrnis Apollon 34 43 54 36
18 Aris Thessaloniki Aris 34 26 53 22
TEMPORADA 2012/2013
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 64 16 77
2 PAOK PAOK 30 46 19 62
3 Asteras Tripolis Asteras 30 41 25 56
4 Atromitos Atromitos 30 26 22 46
5 PAS Giannina Giannina 30 28 24 44
6 Panathinaikos Panathinaiko 30 32 30 40
7 Xanthi Xanthi 30 28 26 40
8 Panionios Panionios 30 35 42 36
9 Platanias Platanias 30 29 42 36
10 Panthrakikos Panthrakikos 30 30 33 36
11 Levadiakos Levadiakos 30 21 35 34
12 Veria NPS Veria NPS 30 30 35 33
13 Aris Thessaloniki Aris 30 32 40 33
14 OFI OFI 30 33 46 32
15 AEK Athens AEK Athens 30 21 36 27
16 Kerkyra Kerkyra 30 16 41 20
TEMPORADA 2011/2012
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 70 17 73
2 Panathinaikos Panathinaiko 30 54 23 66
3 Atromitos Atromitos 30 32 26 50
4 PAOK PAOK 30 45 27 50
5 AEK Athens AEK Athens 30 36 30 48
6 Asteras Tripolis Asteras 30 30 34 45
7 Levadiakos Levadiakos 30 33 42 39
8 PAS Giannina Giannina 30 30 35 38
9 Aris Thessaloniki Aris 30 29 33 37
10 OFI OFI 30 27 32 37
11 Xanthi Xanthi 30 31 35 36
12 Panionios Panionios 30 26 34 33
13 Kerkyra Kerkyra 30 31 44 32
14 Ergotelis Ergotelis 30 27 44 29
15 Panaitolikos Panaitolikos 30 23 37 28
16 Doxa Dramas Doxa Dramas 30 11 42 17
TEMPORADA 2010/2011
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 65 18 73
2 Panathinaikos Panathinaiko 30 47 26 60
3 AEK Athens AEK Athens 30 46 37 50
4 PAOK PAOK 30 32 29 48
5 Olympiakos Volos Olympiakos 30 40 28 47
6 Aris Thessaloniki Aris 30 29 29 45
7 Kavala Kavala 30 29 27 40
8 Ergotelis Ergotelis 30 32 38 39
9 Xanthi Xanthi 30 29 35 36
10 Iraklis Thessaloniki Iraklis 30 22 28 35
11 Panionios Panionios 30 25 35 35
12 Atromitos Atromitos 30 30 34 34
13 Kerkyra Kerkyra 30 30 40 33
14 Asteras Tripolis Asteras 30 21 29 31
15 AE Larisa AE Larisa 30 29 47 25
16 Panserraikos FC Panserraikos 30 22 48 24
TEMPORADA 2009/2010
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Panathinaikos Panathinaiko 30 54 17 70
2 Olympiacos Piraeus Olympiacos 30 47 18 64
3 PAOK PAOK 30 41 16 62
4 AEK Athens AEK Athens 30 43 31 53
5 Aris Thessaloniki Aris 30 35 28 46
6 Kavala Kavala 30 31 32 39
7 Atromitos Atromitos 30 34 36 38
8 Panionios Panionios 30 34 35 37
9 Iraklis Thessaloniki Iraklis 30 39 41 37
10 AE Larisa AE Larisa 30 31 42 37
11 Ergotelis Ergotelis 30 37 41 36
12 Asteras Tripolis Asteras 30 29 36 36
13 Xanthi Xanthi 30 27 36 35
14 Levadiakos Levadiakos 30 31 44 34
15 PAS Giannina Giannina 30 27 46 28
16 Panthrakikos Panthrakikos 30 21 62 12

  USO DE MEMORIA  
7,018,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1566
Total Execution Time  0.1579
  CADENA URL  
/historico/Aris
  GET DATOS  
$_GET['/historico/Aris']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0046  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Aris' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0021  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=254 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=254 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=254 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=254 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=254 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=254 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=254 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 72102
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=254 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 254 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 (87912,98672,105444,107998,112001) ORDER BY n.cover_points DESC, update_date DESC
0.0028  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 = '254' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '254' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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=254 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (75536,73551,72102,71432) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 75536 AND teamId = 254
0.0043  SELECT count(id) as num_players from rel_players WHERE league_id = 73551 AND teamId = 254
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 72102 AND teamId = 254
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 254
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 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 = 75536 AND t.round = 8 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '254' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '254' and rp.type = 4
0.0020  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 = '254' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0029  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 = 75536 WHERE rp.league_id = 75536 AND rp.teamId = 254 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.0027  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 = 75536 WHERE rp.league_id = 75536 AND rp.teamId = 254 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 75536 WHERE rp.league_id = 75536 AND rp.teamId = 254 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 254 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 67777 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.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 = 71244 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.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 = 63207 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.0027  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 = 66928 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.0027  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 = 58673 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.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 `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 = 61824 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.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 `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 = 49866 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.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 `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 = 55620 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.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 `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 = 44207 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 = 39254 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 35326 AND t.round = 34 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 `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 = 15926 AND t.round = 34 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 `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 = 12485 AND t.round = 30 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 `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 = 2517 AND t.round = 34 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 `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 = 2040 AND t.round = 30 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 = 1552 AND t.round = 30 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 `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 = 1196 AND t.round = 30 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 `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 = 868 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 75536 ORDER BY nameShow LIMIT 100