4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA BELGA GRUPO 3
Equipo PJ GF GC Puntos
1 KAA Gent KAA Gent 6 17 6 39
2 KV Mechelen KV Mechelen 6 12 10 33
3 Sint-Truidense V.V. Sint-Truiden 6 9 9 28
4 OH Leuven OH Leuven 6 6 8 23
5 Standard de Liège Standard 6 8 12 22
6 KVC Westerlo Westerlo 6 8 15 17
TEMPORADA 2022/2023
LIGA BELGA GRUPO 3
Equipo PJ GF GC Puntos
1 KAA Gent KAA Gent 6 17 6 44
2 Cercle Brugge Cercle 6 13 9 36
3 KVC Westerlo Westerlo 6 10 15 30
4 Standard de Liège Standard 6 4 14 30
TEMPORADA 2021/2022
LIGA BELGA GRUPO 3
Equipo PJ GF GC Puntos
1 KAA Gent KAA Gent 6 9 5 43
2 Genk Genk 6 10 8 37
3 Charleroi Charleroi 6 10 12 34
4 KV Mechelen KV Mechelen 6 6 10 30
TEMPORADA 2020/2021
LIGA BELGA GRUPO 3
Equipo PJ GF GC Puntos
1 KAA Gent KAA Gent 6 13 6 38
2 KV Mechelen KV Mechelen 6 15 11 35
3 KV Oostende KV Oostende 6 15 16 34
4 Standard de Liège Standard 6 7 17 28
TEMPORADA 2019/2020
LIGA BELGA
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 29 58 14 70
2 KAA Gent KAA Gent 29 59 34 55
3 Charleroi Charleroi 29 49 23 54
4 Antwerp Antwerp 29 49 32 53
5 Standard de Liège Standard 29 47 32 49
6 KV Mechelen KV Mechelen 29 46 43 44
7 Genk Genk 29 45 42 44
8 Anderlecht Anderlecht 29 45 29 43
9 Zulte-Waregem Zulte-Warege 29 41 49 36
10 Mouscron Mouscron 29 38 40 36
11 Kortrijk Kortrijk 29 40 44 33
12 Sint-Truidense V.V. Sint-Truiden 29 33 50 33
13 KAS Eupen KAS Eupen 29 28 51 30
14 Cercle Brugge Cercle 29 27 54 23
15 KV Oostende KV Oostende 29 29 58 22
16 SK Beveren SK Beveren 29 21 60 20
TEMPORADA 2018/2019
LIGA BELGA GRUPO 2
Equipo PJ GF GC Puntos
1 Genk Genk 10 19 8 52
2 Club Brugge Club Brugge 10 19 11 50
3 Standard de Liège Standard 10 17 16 40
4 Antwerp Antwerp 10 12 16 39
5 KAA Gent KAA Gent 10 10 15 35
6 Anderlecht Anderlecht 10 8 19 32
TEMPORADA 2017/2018
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 30 68 33 67
2 Anderlecht Anderlecht 30 49 42 55
3 Charleroi Charleroi 30 46 30 51
4 KAA Gent KAA Gent 30 45 27 50
5 Genk Genk 30 44 36 44
6 Standard de Liège Standard 30 43 41 44
7 Kortrijk Kortrijk 30 42 39 42
8 Antwerp Antwerp 30 38 40 41
9 Zulte-Waregem Zulte-Warege 30 47 52 37
10 Sint-Truidense V.V. Sint-Truiden 30 29 41 37
11 KV Oostende KV Oostende 30 42 41 36
12 SK Beveren SK Beveren 30 50 51 35
13 Lokeren Lokeren 30 33 49 31
14 Mouscron Mouscron 30 40 59 30
15 KAS Eupen KAS Eupen 30 40 57 27
16 KV Mechelen KV Mechelen 30 31 49 27
TEMPORADA 2016/2017
LIGA BELGA GRUPO 2
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 10 14 6 52
2 Club Brugge Club Brugge 10 16 14 45
3 KAA Gent KAA Gent 10 16 11 41
4 KV Oostende KV Oostende 10 14 17 37
5 Charleroi Charleroi 10 10 13 35
6 Zulte-Waregem Zulte-Warege 10 12 21 33
TEMPORADA 2015/2016
LIGA BELGA GRUPO 2
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 10 25 9 54
2 Anderlecht Anderlecht 10 15 16 47
3 KAA Gent KAA Gent 10 10 15 42
4 Genk Genk 10 20 13 40
5 KV Oostende KV Oostende 10 14 19 36
6 Zulte-Waregem Zulte-Warege 10 11 23 27
TEMPORADA 2014/2015
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 30 69 28 61
2 KAA Gent KAA Gent 30 52 29 57
3 Anderlecht Anderlecht 30 51 30 57
4 Standard de Liège Standard 30 49 39 53
5 Kortrijk Kortrijk 30 54 35 51
6 Charleroi Charleroi 30 44 31 49
7 Genk Genk 30 38 28 49
8 Lokeren Lokeren 30 38 32 42
9 KV Mechelen KV Mechelen 30 37 39 41
10 KV Oostende KV Oostende 30 40 52 38
11 KVC Westerlo Westerlo 30 42 63 33
12 Zulte-Waregem Zulte-Warege 30 41 54 31
13 Mouscron Mouscron 30 32 51 26
14 SK Beveren SK Beveren 30 30 49 26
15 Cercle Brugge Cercle 30 21 45 24
16 Lierse SK Lierse SK 30 30 63 22
TEMPORADA 2013/2014
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Standard de Liège Standard 30 59 17 67
2 Club Brugge Club Brugge 30 54 28 63
3 Anderlecht Anderlecht 30 61 31 57
4 Zulte-Waregem Zulte-Warege 30 51 38 53
5 Lokeren Lokeren 30 48 31 51
6 Genk Genk 30 42 39 45
7 KAA Gent KAA Gent 30 39 37 44
8 Kortrijk Kortrijk 30 42 44 39
9 Charleroi Charleroi 30 36 41 34
10 KV Oostende KV Oostende 30 28 46 34
11 Cercle Brugge Cercle 30 29 55 33
12 Lierse SK Lierse SK 30 36 53 32
13 SK Beveren SK Beveren 30 28 35 31
14 KV Mechelen KV Mechelen 30 34 51 31
15 OH Leuven OH Leuven 30 30 47 27
16 Mons Mons 30 29 53 22

  USO DE MEMORIA  
6,488,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2211
Total Execution Time  0.2230
  CADENA URL  
/historico/Kaa-Gent
  GET DATOS  
$_GET['/historico/Kaa-Gent']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (51)  
0.0055  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 = 'Kaa-Gent' 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.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=1431 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=1431 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=1431 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=1431 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1431 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0033  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=1431 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=1431 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=1431 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=1431 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1431 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0029  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 = 74792
0.0024  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 = 75663
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1431 AND type_rel = 2
0.0027  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1431 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 (8774,8790,11964,12268,12941) ORDER BY n.cover_points DESC, update_date DESC
0.0059  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 = '1431' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 72103 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 73881 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 72090 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0038  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=1431 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0035  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 (75663,74792,73206,72103,71432,67861,67754) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 75663 AND teamId = 1431
0.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 74792 AND teamId = 1431
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 67754 AND teamId = 1431
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 72103 AND teamId = 1431
0.0039  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 1431
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 67861 AND teamId = 1431
0.0192  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1431
0.0044  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 = 74792 WHERE rp.league_id = 74792 AND rp.teamId = 1431 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.0046  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 = 74792 WHERE rp.league_id = 74792 AND rp.teamId = 1431 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 74792 WHERE rp.league_id = 74792 AND rp.teamId = 1431 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0044  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 = 1431 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 `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 = 75663 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.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 `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 = 71534 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.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 `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 = 63065 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.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 `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 = 67299 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.0037  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 = 56829 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.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 `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 = 62244 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.0050  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 = 49865 AND t.round = 30 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 `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 = 43914 AND t.round = 30 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 `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 = 49311 AND t.round = 10 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 `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 = 43126 AND t.round = 10 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 = 38639 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 `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 = 33313 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 = 38066 AND t.round = 10 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 `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 = 15156 AND t.round = 30 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 `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 = 21698 AND t.round = 10 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 `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 = 11089 AND t.round = 10 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 `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 = 3814 AND t.round = 30 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 `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 = 2409 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC