4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Kasem Bundit
TEMPORADA 2023/2024
THAI LEAGUE 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Bangkok Bangkok 26 59 19 61
2 North Bangkok North 26 44 17 57
3 Samut Sakhon FC Samut Sakhon 26 65 21 56
4 Thonburi United Thonburi 26 56 32 56
5 Kasem Bundit Kasem Bundit 26 64 19 52
6 Prime Bangkok Prime 26 52 23 48
7 Welfare Royal Air Force Welfare 26 41 47 30
8 Chamchuri United Chamchuri 26 28 41 26
9 Muangnont Muangnont 26 18 35 21
10 Army FC Army FC 26 27 59 21
11 Inter Bangkok Inter 26 24 49 20
12 Samut Prakan Samut Prakan 26 20 59 20
13 Nonthaburi Nonthaburi 26 26 50 17
14 Icon RSU Icon RSU 26 19 72 16
TEMPORADA 2022/2023
THAI LEAGUE 3 GRUPO 1
Equipo PJ GF GC Puntos
1 North Bangkok North 26 39 16 53
2 Samut Sakhon FC Samut Sakhon 26 48 35 53
3 Bangkok Bangkok 26 45 28 51
4 Prime Bangkok Prime 26 36 22 46
5 Chamchuri United Chamchuri 26 33 31 38
6 Kasem Bundit Kasem Bundit 26 30 29 37
7 Samut Prakan Samut Prakan 26 33 27 36
8 Nonthaburi Nonthaburi 26 35 36 31
9 Army FC Army FC 26 25 39 30
10 Inter Bangkok Inter 26 26 28 27
11 Muangnont Muangnont 26 28 38 26
12 Thonburi United Thonburi 26 25 35 25
13 Welfare Royal Air Force Welfare 26 31 49 21
14 Siam Siam 26 17 38 20
TEMPORADA 2021/2022
THAI LEAGUE 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Bangkok Bangkok 26 55 19 53
2 North Bangkok North 26 41 13 53
3 Nonthaburi Nonthaburi 26 51 29 47
4 Chamchuri United Chamchuri 26 44 23 46
5 Kasem Bundit Kasem Bundit 26 35 29 44
6 Siam Siam 26 26 32 35
7 Prime Bangkok Prime 26 27 30 34
8 Army FC Army FC 26 24 23 33
9 Muangnont Muangnont 26 29 40 33
10 Welfare Royal Air Force Welfare 26 23 30 31
11 Thonburi United Thonburi 26 32 33 28
12 Inter Bangkok Inter 26 16 60 16
13 Samut Prakan Samut Prakan 26 23 38 15
14 Grakcu Sai Mai United Grakcu 26 27 54 15
TEMPORADA 2020/2021
THAI LEAGUE 3 GRUPO 1
Equipo PJ GF GC Puntos
1 North Bangkok North 12 23 5 29
2 Chamchuri United Chamchuri 12 33 9 27
3 Nonthaburi Nonthaburi 12 21 7 26
4 Bangkok Bangkok 12 26 13 24
5 Muangnont Muangnont 12 16 6 23
6 Prime Bangkok Prime 12 16 16 21
7 Kasem Bundit Kasem Bundit 12 14 15 20
8 Thonburi United Thonburi 12 20 18 16
9 Grakcu Sai Mai United Grakcu 12 13 17 13
10 Welfare Royal Air Force Welfare 12 12 26 13
11 Army FC Army FC 12 11 25 12
12 Samut Prakan Samut Prakan 12 11 30 5
13 Siam Siam 12 12 26 4
14 Inter Bangkok Inter 12 9 24 4
TEMPORADA 2019/2020
THAI LEAGUE 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Bangkok Bangkok 2 6 1 6
2 North Bangkok North 2 2 0 4
3 Pattani Pattani 2 4 3 4
4 Pathum Thani University Pathum Thani 2 2 1 4
5 Trang Trang 2 2 1 4
6 Kasem Bundit Kasem Bundit 2 5 3 3
7 Raj Pracha Raj Pracha 2 2 2 3
8 Krabi Krabi 2 1 2 1
9 Nakhon Si United Nakhon 2 1 2 1
10 Nara United Nara United 2 0 1 1
11 BTU United BTU United 2 2 4 1
12 Banbueng Banbueng 2 1 8 0
TEMPORADA 2018/2019
THAI LEAGUE 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Nakhon Pathom Nakhon 26 57 18 61
2 Ranong Ranong 26 45 20 50
3 Nara United Nara United 26 42 26 44
4 Trang Trang 26 31 27 41
5 Phuket City Phuket City 26 34 35 40
6 North Bangkok North 26 28 21 37
7 Krabi Krabi 26 34 29 36
8 Kasem Bundit Kasem Bundit 26 36 36 35
9 BTU United BTU United 26 36 31 33
10 Nakhon Si United Nakhon 26 29 38 32
11 Chamchuri United Chamchuri 26 33 42 29
12 Raj Pracha Raj Pracha 26 19 33 27
13 Army FC Army FC 26 29 45 19
14 Surat Thani Surat Thani 26 20 72 8
TEMPORADA 2017/2018
THAI LEAGUE 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Customs United Customs 26 43 23 54
2 Nara United Nara United 26 45 18 50
3 Trang Trang 26 34 16 50
4 Chamchuri United Chamchuri 26 32 27 41
5 Banbung United Banbung 26 29 23 40
6 BTU United BTU United 26 38 32 38
7 Army FC Army FC 26 30 31 35
8 Nakhon Si United Nakhon 26 31 31 34
9 Ranong Ranong 26 30 33 31
10 Surat Thani Surat Thani 26 34 49 26
11 Kasem Bundit Kasem Bundit 26 26 33 25
12 Bangkok U. Deffo Bangkok 26 24 36 23
13 Raj Pracha Raj Pracha 26 25 42 23
14 Simork Simork 26 30 57 23
TEMPORADA 2016/2017
THAI LEAGUE 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Samut Sakhon FC Samut Sakhon 28 54 25 65
2 Trang Trang 28 47 19 61
3 Bangkok U. Deffo Bangkok 28 49 32 50
4 Army FC Army FC 28 46 39 45
5 Nara United Nara United 28 39 28 44
6 Ranong Ranong 28 36 34 42
7 Chamchuri United Chamchuri 28 50 38 42
8 Nakhon Si United Nakhon 28 25 30 38
9 Customs United Customs 28 32 40 35
10 Banbung United Banbung 28 29 48 30
11 Surat Thani Surat Thani 28 34 40 30
12 Kasem Bundit Kasem Bundit 28 40 48 30
13 Simork Simork 28 31 42 27
14 Raj Pracha Raj Pracha 28 26 52 22
15 Krung Thonburi Krung 28 43 66 21
TEMPORADA 2015/2016
SEGUNDA TAILANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Raj Pracha Raj Pracha 18 27 5 37
2 Customs United Customs 18 34 13 33
3 Banbung United Banbung 18 30 19 32
4 Kasem Bundit Kasem Bundit 18 32 24 30
5 Look Esan Look Esan 18 25 24 24
6 Samut Prakan United Samut Prakan 18 26 31 22
7 Pattaya FC Pattaya FC 18 16 35 19
8 Royal Thai Fleet Royal Thai. 18 14 26 17
9 Pathum Thani United Pathum Thani 18 22 35 17
10 Sinthana Kabinburi Sinthana 18 15 29 14
11 Inter Pattaya Inter 0 0 0 0
TEMPORADA 2014/2015
SEGUNDA TAILANDIA GRUPO 1
Equipo PJ GF GC Puntos
1 Customs United Customs 26 48 25 54
2 Christian College Christian 26 37 22 49
3 Chamchuri United Chamchuri 26 47 35 46
4 Assumption Assumption 26 39 30 42
5 Kasetsart Kasetsart 26 34 27 41
6 Kasem Bundit Kasem Bundit 26 41 40 40
7 Army FC Army FC 26 31 25 39
8 Rangsit Rangsit 26 35 31 36
9 Rangsit JW Rangsit JW 26 27 31 32
10 Rayong United Rayong 26 40 46 32
11 North Bangkok North 26 26 31 28
12 Bangkok U. Deffo Bangkok 26 38 40 26
13 R-BAC R-BAC 26 26 58 22
14 Dome Dome 26 19 47 15
TEMPORADA 2013/2014
SEGUNDA TAILANDIA GRUPO 2
Equipo PJ GF GC Puntos
1 Thai Honda Thai Honda 26 63 16 67
2 Christian College Christian 26 35 15 53
3 Samut Prakan United Samut Prakan 26 39 24 48
4 Chamchuri United Chamchuri 26 47 34 46
5 Paknampho NSRU Paknampho 26 43 20 43
6 Customs United Customs 26 46 36 40
7 R-BAC R-BAC 26 43 34 40
8 North Bangkok North 26 31 22 39
9 Rangsit Rangsit 26 27 25 30
10 Assumption Assumption 26 29 36 29
11 Kasem Bundit Kasem Bundit 26 24 46 27
12 Rangsit JW Rangsit JW 26 25 48 18
13 Rayong United Rayong 26 26 62 16
14 Raj-Vithi Raj-Vithi 26 14 74 7

  USO DE MEMORIA  
6,308,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1246
Total Execution Time  0.1258
  CADENA URL  
/historico/Kasem-Bundit
  GET DATOS  
$_GET['/historico/Kasem-Bundit']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0030  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 = 'Kasem-Bundit' 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.0018  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=62063 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62063 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62063 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62063 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=62063 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 74097
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 = 73915
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62063 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1929 AND type_rel = 3
0.0023  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 = '62063' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '62063' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '62063' 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 = 74095 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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 = 73915 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 = 74097 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=62063 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (74097,74095,73915,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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 74097 AND teamId = 62063
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73915 AND teamId = 62063
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 74095 AND teamId = 62063
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 62063
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 = 74097 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '62063' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '62063' and rp.type = 4
0.0019  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 = '62063' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 74097 WHERE rp.league_id = 74097 AND rp.teamId = 62063 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.0019  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 = 74097 WHERE rp.league_id = 74097 AND rp.teamId = 62063 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 74097 WHERE rp.league_id = 74097 AND rp.teamId = 62063 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 62063 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74097 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.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 `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 = 69589 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.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 = 64308 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.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 `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 = 60176 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.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 `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 = 55382 AND t.round = 2 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 `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 = 48916 AND t.round = 26 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 = 42645 AND t.round = 26 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 `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 = 37989 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 = 20618 AND t.round = 22 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 `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 = 9732 AND t.round = 26 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 = 16122 AND t.round = 26 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 = 74097 ORDER BY nameShow LIMIT 100