4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 26 53 9 66
2 PAOK PAOK 26 50 23 59
3 AEK Athens AEK Athens 26 42 22 51
4 Panathinaikos Panathinaiko 26 35 23 44
5 OFI OFI 26 35 35 34
6 Aris Thessaloniki Aris 26 38 32 34
7 Atromitos Atromitos 26 31 36 32
8 AE Larisa AE Larisa 26 28 33 30
9 Asteras Tripolis Asteras 26 33 37 30
10 Lamia Lamia 26 19 33 27
11 Volos New Football Volos 26 23 42 27
12 Xanthi Xanthi 26 21 32 18
13 Panaitolikos Panaitolikos 26 20 42 17
14 Panionios Panionios 26 16 45 11
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
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 30 50 12 70
2 PAOK PAOK 30 59 19 64
3 Olympiacos Piraeus Olympiacos 30 63 28 57
4 Atromitos Atromitos 30 43 21 56
5 Asteras Tripolis Asteras 30 39 24 45
6 Xanthi Xanthi 30 31 30 45
7 Panionios Panionios 30 32 31 40
8 Panaitolikos Panaitolikos 30 31 40 35
9 PAS Giannina Giannina 30 31 34 34
10 Levadiakos Levadiakos 30 23 34 34
11 Panathinaikos Panathinaiko 30 30 30 32
12 AE Larisa AE Larisa 30 22 41 31
13 Lamia Lamia 30 20 34 30
14 Apollon Smyrnis Apollon 30 23 36 29
15 Kerkyra Kerkyra 30 19 51 22
16 Platanias Platanias 30 14 65 10
TEMPORADA 2016/2017
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 6 5 3 12
2 PAOK PAOK 6 7 5 11
3 Panathinaikos Panathinaiko 6 6 7 7
4 Panionios Panionios 6 3 6 4
TEMPORADA 2015/2016
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 PAOK PAOK 6 8 3 12
2 Panathinaikos Panathinaiko 6 8 6 11
3 AEK Athens AEK Athens 6 5 7 9
4 Panionios Panionios 6 2 7 4
TEMPORADA 2014/2015
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 34 79 23 78
2 Panathinaikos Panathinaiko 34 59 31 66
3 PAOK PAOK 34 57 42 65
4 Asteras Tripolis Asteras 34 52 37 59
5 Atromitos Atromitos 34 43 27 54
6 PAS Giannina Giannina 34 47 33 53
7 Panaitolikos Panaitolikos 34 41 28 52
8 Xanthi Xanthi 34 44 41 47
9 Platanias Platanias 34 32 30 44
10 Kerkyra Kerkyra 34 39 38 44
11 Kalloni Kalloni 34 34 39 44
12 Levadiakos Levadiakos 34 41 34 43
13 Panionios Panionios 34 43 42 43
14 Veria NPS Veria NPS 34 45 54 43
15 Panthrakikos Panthrakikos 34 35 44 43
16 Ergotelis Ergotelis 34 35 60 32
17 OFI OFI 33 26 72 0
18 Niki Volos Niki Volos 33 7 84 0
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 2
Equipo PJ GF GC Puntos
1 PAOK PAOK 6 7 7 13
2 Atromitos Atromitos 6 8 5 11
3 Asteras Tripolis Asteras 6 6 7 9
4 PAS Giannina Giannina 6 6 8 7

  USO DE MEMORIA  
6,380,416 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1786
Total Execution Time  0.1797
  CADENA URL  
/historico/Paok/2023
  GET DATOS  
$_GET['/historico/Paok/2023']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0048  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 = 'Paok' AND l.year = 2023 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.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=1919 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=1919 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=1919 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=1919 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=1919 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=1919 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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 = 71244
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1919 AND type_rel = 2
0.0026  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1919 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (856,4342,5781,6198,6331) ORDER BY n.cover_points DESC, update_date DESC
0.0038  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 = '1919' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0045  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 = '1919' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 68776 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 67777 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0044  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=1919 AND l.year in (2022,2023,2024) 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,74792,73551,72103,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.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 75536 AND teamId = 1919
0.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 74792 AND teamId = 1919
0.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 73551 AND teamId = 1919
0.0036  SELECT count(id) as num_players from rel_players WHERE league_id = 72103 AND teamId = 1919
0.0169  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1919
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0048  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 events2023 e ON e.player_id = p.id AND e.league_id = 67777 WHERE rp.league_id = 67777 AND rp.teamId = 1919 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.0048  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 events2023 e ON e.player_id = p.id AND e.league_id = 67777 WHERE rp.league_id = 67777 AND rp.teamId = 1919 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 events2023 e ON e.player_id = p.id AND e.league_id = 67777 WHERE rp.league_id = 67777 AND rp.teamId = 1919 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0041  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 = 1919 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 `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.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 `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.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.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 `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.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 `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 = 38720 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 `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 = 33417 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 38412 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 26596 AND t.round = 6 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 `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 = 14092 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 3825 AND t.round = 34 ORDER BY team.conference 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 `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 = 10446 AND t.round = 6 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 `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.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 `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 `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 = 10445 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 67777 ORDER BY nameShow LIMIT 100