4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del I-Sky Yuen Long
TEMPORADA 2023/2024
PRIMERA HONG KONG
Equipo PJ GF GC Puntos
1 Kowloon City Kowloon City 19 48 19 47
2 Central & Western Central 19 62 26 43
3 I-Sky Yuen Long I-Sky Yuen. 20 41 28 34
4 South China AA South China 18 39 20 30
5 Citizen AA Citizen AA 19 32 28 30
6 3 Sing 3 Sing 19 32 24 29
7 Shatin Shatin 19 40 39 25
8 Wing Yee Wing Yee 20 26 40 22
9 Eastern District SA Eastern 19 35 43 17
10 Hoi King Hoi King 19 19 46 14
11 Sai Kung DSA Kung 18 17 44 13
12 Wong Tai Sin Wong 19 21 55 12
TEMPORADA 2022/2023
PRIMERA HONG KONG
Equipo PJ GF GC Puntos
1 Central & Western Central 22 63 15 60
2 Kowloon City Kowloon City 22 58 21 50
3 South China AA South China 22 58 28 38
4 Wing Yee Wing Yee 22 41 22 37
5 North District North 21 41 23 34
6 I-Sky Yuen Long I-Sky Yuen. 19 32 24 33
7 Hoi King Hoi King 22 52 37 31
8 Shatin Shatin 22 38 45 30
9 Citizen AA Citizen AA 22 39 37 27
10 Happy Valley AA Happy Valley 21 37 60 25
11 Eastern District SA Eastern 21 38 49 22
12 Wong Tai Sin Wong 22 23 47 17
13 Dreams Metro Gallery Dreams Metro 22 20 59 11
14 Kwai Tsing Kwai Tsing 22 19 92 8
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
LIGA HONG KONG
Equipo PJ GF GC Puntos
1 Kitchee FC Kitchee FC 11 27 9 22
2 R&F FC R&F FC 9 35 10 22
3 Lee Man Warriors Warriors 9 18 14 19
4 Southern District Southern 10 23 19 18
5 Eastern SC Eastern SC 9 15 11 16
6 Wofoo Tai Po FC Wofoo 9 16 22 9
7 Pegasus Pegasus 9 12 19 6
8 Happy Valley AA Happy Valley 10 8 23 6
9 I-Sky Yuen Long I-Sky Yuen. 9 11 23 5
10 Rangers Rangers 9 11 26 5
TEMPORADA 2018/2019
LIGA HONG KONG
Equipo PJ GF GC Puntos
1 Wofoo Tai Po FC Wofoo 18 43 22 41
2 R&F FC R&F FC 18 51 26 36
3 Southern District Southern 18 30 24 32
4 Kitchee FC Kitchee FC 18 44 20 32
5 Eastern SC Eastern SC 18 38 21 31
6 Pegasus Pegasus 18 34 33 22
7 I-Sky Yuen Long I-Sky Yuen. 18 36 37 18
8 HK Sapling HK Sapling 18 29 53 16
9 Lee Man Warriors Warriors 18 12 36 11
10 Hoi King Hoi King 18 13 58 8
TEMPORADA 2017/2018
LIGA HONG KONG
Equipo PJ GF GC Puntos
1 Kitchee FC Kitchee FC 18 67 12 50
2 Wofoo Tai Po FC Wofoo 18 36 21 37
3 Pegasus Pegasus 18 37 26 34
4 Eastern SC Eastern SC 18 34 25 28
5 Southern District Southern 18 28 27 26
6 I-Sky Yuen Long I-Sky Yuen. 18 21 30 23
7 R&F FC R&F FC 18 27 35 22
8 Lee Man Warriors Warriors 18 22 36 15
9 HK Sapling HK Sapling 18 18 40 15
10 Rangers Rangers 18 12 50 6
TEMPORADA 2016/2017
LIGA HONG KONG
Equipo PJ GF GC Puntos
1 Kitchee FC Kitchee FC 20 54 8 51
2 Eastern SC Eastern SC 20 60 25 49
3 Southern District Southern 20 48 21 36
4 South China AA South China 20 34 26 35
5 I-Sky Yuen Long I-Sky Yuen. 20 36 23 31
6 Wofoo Tai Po FC Wofoo 20 29 21 31
7 Rangers Rangers 20 31 33 26
8 Pegasus Pegasus 20 35 35 26
9 HK Sapling HK Sapling 20 24 55 10
10 R&F FC R&F FC 20 13 53 10
11 Hong Kong FC Hong Kong 20 13 77 6
TEMPORADA 2015/2016
LIGA HONG KONG
Equipo PJ GF GC Puntos
1 Eastern SC Eastern SC 16 35 13 38
2 Kitchee FC Kitchee FC 16 32 11 37
3 South China AA South China 16 26 21 29
4 Southern District Southern 16 26 21 23
5 Pegasus Pegasus 16 22 27 17
6 Dreams Metro Gallery Dreams Metro 16 19 30 16
7 I-Sky Yuen Long I-Sky Yuen. 16 21 32 15
8 Wong Tai Sin Wong 16 17 29 11
9 Rangers Rangers 16 15 29 11
TEMPORADA 2014/2015
LIGA HONG KONG
Equipo PJ GF GC Puntos
1 Kitchee FC Kitchee FC 16 40 18 36
2 Eastern SC Eastern SC 16 34 20 33
3 South China AA South China 16 30 17 27
4 Pegasus Pegasus 16 34 23 27
5 Dreams Metro Gallery Dreams Metro 16 25 29 26
6 I-Sky Yuen Long I-Sky Yuen. 16 20 31 17
7 Wong Tai Sin Wong 16 20 29 14
8 Rangers Rangers 16 20 33 14
9 Wofoo Tai Po FC Wofoo 16 17 40 7
TEMPORADA 2013/2014
LIGA HONG KONG
Equipo PJ GF GC Puntos
1 Kitchee FC Kitchee FC 18 47 12 48
2 TSW Pegasus FC Pegasus 18 40 28 32
3 South China AA South China 18 35 24 32
4 Eastern Salon Eastern 18 34 37 21
5 Southern District Southern 18 25 32 21
6 Rangers Rangers 18 23 32 21
7 I-Sky Yuen Long I-Sky Yuen. 18 25 33 20
8 Sun Hei SC Sun Hei SC 18 32 41 19
9 Citizen AA Citizen AA 18 25 33 18
10 Dreams Metro Gallery Dreams Metro 18 25 39 13
11 Happy Valley AA Happy Valley 0 0 0 0
12 Tuen Mun SA Tuen Mun SA 0 0 0 0
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
PRIMERA HONG KONG
Equipo PJ GF GC Puntos
1 Rangers Rangers 22 69 24 50
2 Southern District Southern 22 43 23 47
3 Hong Kong FC Hong Kong 22 46 23 46
4 Wanchai Wanchai 22 35 29 40
5 Double Flower Double 22 60 35 39
6 Happy Valley AA Happy Valley 22 34 30 35
7 Shatin Shatin 22 41 43 25
8 Tai Chung Tai Chung 22 35 56 25
9 I-Sky Yuen Long I-Sky Yuen. 22 26 43 22
10 Wing Yee Wing Yee 22 36 66 21
11 Kwun Tong Kwun Tong 22 20 43 16
12 Kwai Tsing Kwai Tsing 22 25 55 9
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  
5,894,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1283
Total Execution Time  0.1295
  CADENA URL  
/historico/I-Sky-Yuen-Long
  GET DATOS  
$_GET['/historico/I-Sky-Yuen-Long']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0032  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 = 'I-Sky-Yuen-Long' 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.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=14235 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=14235 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 = 74602
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=14235 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 14235 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019  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 (3918) 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 = '14235' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '14235' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '14235' 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 = 74602 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=14235 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (74602) 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 = 74602 AND teamId = 14235
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 `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 = 74602 AND t.round = 20 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '14235' 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 = '14235' and rp.type = 4
0.0021  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 = '14235' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 74602 WHERE rp.league_id = 74602 AND rp.teamId = 14235 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.0031  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 = 74602 WHERE rp.league_id = 74602 AND rp.teamId = 14235 AND (e.action = 4 or e.action = 5) 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 = 74602 WHERE rp.league_id = 74602 AND rp.teamId = 14235 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 = 14235 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 = 74602 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.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 = 70754 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 = 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.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 `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.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 = 49915 AND t.round = 12 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 = 43695 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 `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 = 38783 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 `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 = 33436 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 = 15711 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 4441 AND t.round = 18 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 `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 = 3023 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 `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.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 = 23964 AND t.round = 22 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 = 23966 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 = 74602 ORDER BY nameShow LIMIT 100