4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sham Shui Po
TEMPORADA 2023/2024
LIGA HONG KONG
Equipo PJ GF GC Puntos
1 Lee Man Warriors Warriors 17 50 13 45
2 Kitchee FC Kitchee FC 18 54 10 43
3 Wofoo Tai Po FC Wofoo 16 33 9 38
4 Eastern SC Eastern SC 18 38 9 38
5 Southern District Southern 17 36 16 30
6 Rangers Rangers 18 34 33 18
7 North District North 16 26 35 18
8 Hong Kong FC Hong Kong 15 15 38 14
9 Sham Shui Po Sham Shui 17 17 46 10
10 Hong Kong U23 XI Hong Kong 17 9 62 6
11 Resources Capital Resources 17 12 53 5
TEMPORADA 2022/2023
LIGA HONG KONG
Equipo PJ GF GC Puntos
1 Kitchee FC Kitchee FC 18 76 7 46
2 Lee Man Warriors Warriors 18 50 13 44
3 Rangers Rangers 18 41 16 33
4 Southern District Southern 18 24 25 31
5 Eastern SC Eastern SC 18 32 13 31
6 Hong Kong FC Hong Kong 18 18 22 26
7 Wofoo Tai Po FC Wofoo 18 20 27 20
8 Resources Capital Resources 18 15 34 18
9 Sham Shui Po Sham Shui 18 4 62 7
10 Hong Kong U23 XI Hong Kong 18 6 67 1
TEMPORADA 2021/2022
PRIMERA HONG KONG
Equipo PJ GF GC Puntos
1 Wofoo Tai Po FC Wofoo 13 37 12 28
2 Shatin Shatin 13 31 19 27
3 I-Sky Yuen Long I-Sky Yuen. 13 27 9 26
4 North District North 13 29 10 25
5 Eastern District SA Eastern 13 25 17 25
6 Sham Shui Po Sham Shui 13 20 12 22
7 Wing Yee Wing Yee 13 19 12 21
8 Hoi King Hoi King 13 15 22 17
9 Central & Western Central 13 19 24 16
10 South China AA South China 12 16 22 14
11 Happy Valley AA Happy Valley 13 24 31 13
12 Citizen AA Citizen AA 13 12 27 10
13 Wong Tai Sin Wong 13 12 32 10
14 Dreams Metro Gallery Dreams Metro 12 7 44 0
TEMPORADA 2020/2021
PRIMERA HONG KONG
Equipo PJ GF GC Puntos
1 Hong Kong FC Hong Kong 13 47 4 39
2 North District North 13 31 13 32
3 Sham Shui Po Sham Shui 13 33 17 24
4 South China AA South China 13 31 15 24
5 Shatin Shatin 13 24 19 20
6 Wing Yee Wing Yee 13 22 27 18
7 I-Sky Yuen Long I-Sky Yuen. 13 26 29 17
8 Citizen AA Citizen AA 13 24 27 16
9 Central & Western Central 13 23 28 16
10 Hoi King Hoi King 13 23 32 15
11 Eastern District SA Eastern 13 19 20 13
12 Wofoo Tai Po FC Wofoo 13 20 32 8
13 Dreams Metro Gallery Dreams Metro 13 19 52 8
14 Wong Tai Sin Wong 13 20 47 7
TEMPORADA 2019/2020
PRIMERA HONG KONG
Equipo PJ GF GC Puntos
1 Resources Capital Resources 13 29 11 30
2 HK Sapling HK Sapling 13 44 27 25
3 Hong Kong FC Hong Kong 12 38 18 25
4 South China AA South China 13 30 19 24
5 Eastern District SA Eastern 11 29 14 22
6 Central & Western Central 13 22 24 21
7 Wing Yee Wing Yee 12 27 27 18
8 Citizen AA Citizen AA 13 34 33 16
9 Hoi King Hoi King 12 23 20 15
10 Shatin Shatin 13 24 27 14
11 North District North 12 14 23 12
12 Dreams Metro Gallery Dreams Metro 12 14 38 11
13 Wong Tai Sin Wong 13 21 36 10
14 Sham Shui Po Sham Shui 12 7 39 3
TEMPORADA 2018/2019
SEGUNDA HONG KONG
Equipo PJ GF GC Puntos
1 North District North 26 67 20 66
2 Sham Shui Po Sham Shui 26 60 27 55
3 Kwun Tong Kwun Tong 26 54 29 54
4 Leaper FC Leaper FC 26 57 34 49
5 Kwong Wah AA Kwong 26 51 33 42
6 Tuen Mun SA Tuen Mun SA 26 46 46 39
7 Lucky Mile Lucky Mile 26 46 43 37
8 Fu Moon AA Fu Moon AA 26 36 43 35
9 Yau Tsim Yau Tsim 26 39 45 32
10 Wanchai Wanchai 26 33 47 29
11 Kowloon City Kowloon City 26 28 46 27
12 Tung Sing Tung Sing 26 36 53 26
13 Sun Source FC Source 26 25 59 20
14 Sun Hei SC Sun Hei SC 26 21 74 12
TEMPORADA 2017/2018
SEGUNDA HONG KONG
Equipo PJ GF GC Puntos
1 Happy Valley AA Happy Valley 26 58 16 63
2 Central & Western Central 26 48 21 51
3 Tuen Mun SA Tuen Mun SA 26 34 35 46
4 Sun Source FC Source 26 48 44 44
5 Fu Moon AA Fu Moon AA 26 35 42 39
6 Sham Shui Po Sham Shui 26 36 24 38
7 Kowloon City Kowloon City 26 43 42 36
8 Kwong Wah AA Kwong 26 34 31 34
9 Yau Tsim Yau Tsim 26 29 44 30
10 Lucky Mile Lucky Mile 26 38 43 26
11 Kwai Tsing Kwai Tsing 26 27 42 26
12 Fukien AC Fukien AC 26 20 26 24
13 Sai Kung DSA Kung 26 28 45 24
14 Sai Kung Sai Kung 26 25 48 24
TEMPORADA 2016/2017
SEGUNDA HONG KONG
Equipo PJ GF GC Puntos
1 Sparta Asia FC Sparta Asia 22 43 20 50
2 Central & Western Central 22 46 14 46
3 Hoi King Hoi King 22 46 22 44
4 Lucky Mile Lucky Mile 22 38 25 44
5 Kowloon City Kowloon City 22 28 21 38
6 Sham Shui Po Sham Shui 22 21 27 29
7 Sun Source FC Source 22 33 31 28
8 Tuen Mun SA Tuen Mun SA 22 27 31 27
9 Sai Kung DSA Kung 22 13 36 17
10 Kwong Wah AA Kwong 22 15 41 15
11 Kwok Keung Kwok Keung 22 18 35 15
12 Tuen Mun FC Tuen Mun FC 22 25 50 15
TEMPORADA 2015/2016
SEGUNDA HONG KONG
Equipo PJ GF GC Puntos
1 Tung Sing Tung Sing 22 57 27 51
2 Eastern District SA Eastern 22 65 24 49
3 Sparta Asia FC Sparta Asia 22 39 18 45
4 Sham Shui Po Sham Shui 22 32 22 43
5 Kowloon City Kowloon City 22 31 26 32
6 Kwong Wah AA Kwong 22 29 34 30
7 Sai Kung DSA Kung 22 31 29 28
8 Kwok Keung Kwok Keung 22 26 35 23
9 Tuen Mun SA Tuen Mun SA 22 33 52 23
10 Tuen Mun FC Tuen Mun FC 22 32 49 18
11 Happy Valley AA Happy Valley 22 15 50 14
12 Tsuen Wan Tsuen Wan 22 26 50 12
TEMPORADA 2014/2015
SEGUNDA HONG KONG
Equipo PJ GF GC Puntos
1 Wing Yee Wing Yee 22 76 21 59
2 Sparta Asia FC Sparta Asia 22 63 18 47
3 Kowloon City Kowloon City 22 50 20 43
4 Sai Kung DSA Kung 22 50 24 41
5 Eastern District SA Eastern 22 38 23 36
6 Kwong Wah AA Kwong 22 41 27 34
7 Sham Shui Po Sham Shui 22 46 37 30
8 Tsuen Wan Tsuen Wan 22 31 44 26
9 Tuen Mun FC Tuen Mun FC 22 42 57 25
10 Kwok Keung Kwok Keung 22 35 63 17
11 Fire Services Fire 22 20 43 13
12 New Fair Kui Tan Fair 22 8 123 1
TEMPORADA 2012/2013
PRIMERA HONG KONG
Equipo PJ GF GC Puntos
1 I-Sky Yuen Long I-Sky Yuen. 18 67 12 48
2 Tai Chung Tai Chung 18 51 21 39
3 Happy Valley AA Happy Valley 18 47 20 38
4 Eastern SC Eastern SC 18 38 20 38
5 Hong Kong FC Hong Kong 18 44 31 31
6 Wing Yee Wing Yee 18 29 34 27
7 Shatin Shatin 18 27 22 25
8 Double Flower Double 19 19 59 11
9 Wanchai Wanchai 18 22 41 9
10 Sham Shui Po Sham Shui 19 15 55 9
11 Tuen Mun FC Tuen Mun FC 18 25 69 7
TEMPORADA 2011/2012
LIGA HONG KONG
Equipo PJ GF GC Puntos
1 Kitchee FC Kitchee FC 18 44 20 42
2 TSW Pegasus FC Pegasus 18 48 25 38
3 South China AA South China 18 47 17 36
4 Sun Hei SC Sun Hei SC 18 29 22 28
5 Tuen Mun SA Tuen Mun SA 18 26 22 23
6 Citizen AA Citizen AA 18 29 31 23
7 Dreams Metro Gallery Dreams Metro 18 31 38 22
8 Wofoo Tai Po FC Wofoo 18 24 40 20
9 HK Sapling HK Sapling 18 17 53 10
10 Sham Shui Po Sham Shui 18 9 36 6
TEMPORADA 2010/2011
PRIMERA HONG KONG
Equipo PJ GF GC Puntos
1 Sparta Asia FC Sparta Asia 22 80 27 52
2 Sham Shui Po Sham Shui 22 57 15 52
3 Double Flower Double 22 46 29 43
4 Shatin Shatin 22 40 29 42
5 Happy Valley AA Happy Valley 22 38 35 35
6 Southern District Southern 22 37 33 33
7 Rangers Rangers 22 37 38 31
8 Wing Yee Wing Yee 22 38 50 27
9 I-Sky Yuen Long I-Sky Yuen. 22 26 41 18
10 Kwai Tsing Kwai Tsing 22 26 50 18
11 Fukien AC Fukien AC 22 21 56 17
12 Lucky Mile Lucky Mile 22 21 64 10

  USO DE MEMORIA  
6,289,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1426
Total Execution Time  0.1439
  CADENA URL  
/historico/Sham-Shui-Po
  GET DATOS  
$_GET['/historico/Sham-Shui-Po']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0031  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 = 'Sham-Shui-Po' 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=6436 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=6436 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=6436 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=6436 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=6436 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 = 72289
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 = 74315
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 = 74318
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 = 74209
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6436 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=55 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 55 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  SELECT /*53 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 (1300602,1253811,1226737,818940,816235) ORDER BY n.cover_points DESC, update_date DESC
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 = '6436' 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 = '6436' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '6436' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 74315 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 = 72289 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 = 74209 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=6436 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 (74318,74315,74209,72289) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72289 AND teamId = 6436
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 74318 AND teamId = 6436
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 74315 AND teamId = 6436
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 74209 AND teamId = 6436
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 = 72289 AND t.round = 20 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '6436' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6436' 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 = '6436' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0030  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 = 72289 WHERE rp.league_id = 72289 AND rp.teamId = 6436 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.0026  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 = 72289 WHERE rp.league_id = 72289 AND rp.teamId = 6436 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 = 72289 WHERE rp.league_id = 72289 AND rp.teamId = 6436 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 = 6436 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 = 72289 AND t.round = 20 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 = 68878 AND t.round = 18 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 = 66270 AND t.round = 13 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 = 61912 AND t.round = 13 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 `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 = 50118 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 56404 AND t.round = 26 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 `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 = 56405 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 `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 = 56406 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 `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 = 56407 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 = 56408 AND t.round = 22 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 `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 = 23958 AND t.round = 20 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 `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 = 1587 AND t.round = 18 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 `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 = 23966 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC