4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Wuhan FC
TEMPORADA 2021/2022
SUPERLIGA CHINA
Equipo PJ GF GC Puntos
1 Wuhan Three Towns Wuhan Three 34 91 28 78
2 Shandong Taishan Shandong 34 87 29 78
3 Zhejiang FC Zhejiang FC 34 64 28 65
4 Shanghái Port Shanghái 34 55 25 65
5 Chengdu Rongcheng Chengdu 34 49 28 65
6 Henan FC Henan FC 34 60 32 59
7 Beijing Guoan Beijing 34 57 49 58
8 Tianjin Jinmen Tiger Tianjin 34 45 42 49
9 Meizhou Hakka Meizhou 34 43 41 49
10 Shanghai Shenhua Shanghai 34 42 34 47
11 Dalian Pro Dalian Pro 34 49 53 45
12 Cangzhou Mighty Lions Cangzhou 34 47 51 44
13 Changchun Yatai Changchun 34 49 50 44
14 Shenzhen FC Shenzhen FC 34 29 74 30
15 Guangzhou City Guangzhou 34 32 62 23
16 Wuhan FC Wuhan FC 34 34 71 19
17 Guangzhou FC Guangzhou 34 24 63 17
18 Hebei FC Hebei FC 34 18 115 -3
TEMPORADA 2020/2021
SUPERLIGA CHINA GRUPO 3
Equipo PJ GF GC Puntos
1 Shanghai Shenhua Shanghai 22 34 22 37
2 Henan FC Henan FC 22 19 20 30
3 Cangzhou Mighty Lions Cangzhou 22 25 32 24
4 Tianjin Jinmen Tiger Tianjin 22 18 35 21
5 Chongqing Liangjiang Chongqing 22 21 36 20
6 Wuhan FC Wuhan FC 22 23 30 20
7 Dalian Pro Dalian Pro 22 21 37 19
8 Qingdao FC Qingdao FC 22 13 52 11
TEMPORADA 2019/2020
SUPERLIGA CHINA GRUPO 1
Equipo PJ GF GC Puntos
1 Guangzhou FC Guangzhou 14 31 12 34
2 Jiangsu FC Jiangsu FC 14 23 15 26
3 Shandong Taishan Shandong 14 19 11 24
4 Shanghai Shenhua Shanghai 14 16 15 21
5 Shenzhen FC Shenzhen FC 14 20 20 17
6 Guangzhou City Guangzhou 14 14 28 15
7 Dalian Pro Dalian Pro 14 18 21 11
8 Henan FC Henan FC 14 14 33 6
9 Shanghái Port Shanghái 14 26 11 32
10 Beijing Guoan Beijing 14 36 19 28
11 Chongqing Liangjiang Chongqing 14 22 19 24
12 Hebei FC Hebei FC 14 25 23 24
13 Wuhan FC Wuhan FC 14 16 16 17
14 Cangzhou Mighty Lions Cangzhou 14 18 21 17
15 Qingdao FC Qingdao FC 14 15 27 10
16 Tianjin Jinmen Tiger Tianjin 14 8 30 3
TEMPORADA 2018/2019
SUPERLIGA CHINA
Equipo PJ GF GC Puntos
1 Guangzhou FC Guangzhou 30 68 24 72
2 Beijing Guoan Beijing 30 60 26 70
3 Shanghái Port Shanghái 30 62 26 66
4 Jiangsu FC Jiangsu FC 30 60 41 53
5 Shandong Taishan Shandong 30 55 35 51
6 Wuhan FC Wuhan FC 30 41 41 44
7 Tianjin Jinmen Tiger Tianjin 30 43 45 41
8 Henan FC Henan FC 30 41 46 41
9 Dalian Pro Dalian Pro 30 44 51 38
10 Chongqing Liangjiang Chongqing 30 36 47 36
11 Hebei FC Hebei FC 30 37 55 33
12 Guangzhou City Guangzhou 30 54 72 32
13 Shanghai Shenhua Shanghai 30 43 57 30
14 Tianjin Tianhai Tianjin 30 40 53 25
15 Shenzhen FC Shenzhen FC 30 31 57 21
16 Beijing Renhe Beijing 30 26 65 14
TEMPORADA 2017/2018
LIGA UNO CHINA
Equipo PJ GF GC Puntos
1 Wuhan FC Wuhan FC 30 60 25 63
2 Shenzhen FC Shenzhen FC 30 57 34 53
3 Zhejiang FC Zhejiang FC 30 53 38 51
4 Qingdao FC Qingdao FC 30 63 44 49
5 Beijing BSU Beijing BSU 30 43 34 47
6 Cangzhou Mighty Lions Cangzhou 30 43 38 45
7 Liaoning Whowin Liaoning 30 35 44 41
8 Heilongjiang Ice City Heilongjiang 30 37 33 41
9 Meizhou Hakka Meizhou 30 40 43 40
10 Yanbian Longding Yanbian 30 34 36 38
11 Shanghai Shenxin Shanghai 30 37 45 37
12 Shaoxing Keqiao Yuejia Shaoxing 30 43 53 37
13 Meizhou Meixian Techand Meizhou 30 41 44 34
14 Nei Mongol Zhongyou Mongol 30 36 54 34
15 Dalian Transcendence Dalian 30 28 48 28
16 Xinjiang Tianshan Xinjiang 30 24 61 18
TEMPORADA 2016/2017
LIGA UNO CHINA
Equipo PJ GF GC Puntos
1 Dalian Pro Dalian Pro 30 48 23 64
2 Beijing Renhe Beijing 30 48 21 62
3 Cangzhou Mighty Lions Cangzhou 30 48 33 54
4 Qingdao FC Qingdao FC 30 56 40 52
5 Wuhan FC Wuhan FC 30 47 40 47
6 Shenzhen FC Shenzhen FC 30 56 37 46
7 Shanghai Shenxin Shanghai 30 52 42 40
8 Beijing BSU Beijing BSU 30 43 50 37
9 Zhejiang FC Zhejiang FC 30 31 39 36
10 Nei Mongol Zhongyou Mongol 30 40 47 35
11 Xinjiang Tianshan Xinjiang 30 37 52 35
12 Meizhou Hakka Meizhou 30 33 39 33
13 Shaoxing Keqiao Yuejia Shaoxing 30 35 46 32
14 Baoding Yingli Baoding 30 41 51 31
15 Dalian Transcendence Dalian 30 34 58 31
16 Yunnan Lijiang Yunnan 30 31 62 21
TEMPORADA 2015/2016
LIGA UNO CHINA
Equipo PJ GF GC Puntos
1 Tianjin Tianhai Tianjin 30 61 27 59
2 Guizhou Zhicheng Guizhou 30 48 27 59
3 Qingdao FC Qingdao FC 30 52 42 59
4 Beijing Renhe Beijing 30 49 35 49
5 Dalian Pro Dalian Pro 30 43 44 45
6 Wuhan FC Wuhan FC 30 31 33 43
7 Beijing BSU Beijing BSU 30 40 38 41
8 Nei Mongol Zhongyou Mongol 30 37 35 41
9 Shanghai Shenxin Shanghai 30 54 48 40
10 Shenzhen FC Shenzhen FC 30 36 43 40
11 Meizhou Hakka Meizhou 30 48 50 39
12 Xinjiang Tianshan Xinjiang 30 31 36 39
13 Dalian Transcendence Dalian 30 32 36 38
14 Shaoxing Keqiao Yuejia Shaoxing 30 39 49 38
15 Qingdao Hainiu Qingdao 30 30 43 33
16 Hunan Billows FC Hunan 30 16 61 12
TEMPORADA 2014/2015
LIGA UNO CHINA
Equipo PJ GF GC Puntos
1 Yanbian Longding Yanbian 30 59 24 61
2 Hebei FC Hebei FC 30 53 30 60
3 Dalian Pro Dalian Pro 30 46 22 58
4 Beijing BSU Beijing BSU 30 48 29 56
5 Shaoxing Keqiao Yuejia Shaoxing 30 43 31 47
6 Nei Mongol Zhongyou Mongol 30 38 32 43
7 Qingdao Hainiu Qingdao 30 30 38 41
8 Xinjiang Tianshan Xinjiang 30 43 51 39
9 Wuhan FC Wuhan FC 30 31 30 36
10 Tianjin Tianhai Tianjin 30 28 33 36
11 Qingdao FC Qingdao FC 30 26 39 33
12 Shenzhen FC Shenzhen FC 30 37 48 31
13 Guizhou Zhicheng Guizhou 30 38 55 30
14 Hunan Billows FC Hunan 30 32 48 29
15 Beijing Technology Beijing 30 40 64 29
16 Jiangxi Lushan Jiangxi 30 32 50 23
TEMPORADA 2013/2014
LIGA UNO CHINA
Equipo PJ GF GC Puntos
1 Chongqing Liangjiang Chongqing 30 60 24 61
2 Yongchang Junhao Yongchang 30 42 25 57
3 Wuhan FC Wuhan FC 30 47 31 57
4 Beijing BSU Beijing BSU 30 45 27 55
5 Qingdao Hainiu Qingdao 30 43 29 53
6 Hunan Billows FC Hunan 30 38 33 45
7 Tianjin Tianhai Tianjin 30 39 33 43
8 Shenzhen FC Shenzhen FC 30 35 38 37
9 Beijing Technology Beijing 30 46 57 37
10 Xinjiang Tianshan Xinjiang 30 29 33 35
11 Shenyang Shenbei Shenyang 30 27 31 33
12 Qingdao FC Qingdao FC 30 36 47 31
13 Guangdong Guangdong 30 36 47 30
14 Hebei FC Hebei FC 30 31 54 29
15 Chengdu Blades Chengdu 30 30 46 27
16 Yanbian Longding Yanbian 30 29 58 18
TEMPORADA 2012/2013
SUPERLIGA CHINA
Equipo PJ GF GC Puntos
1 Guangzhou FC Guangzhou 30 78 18 77
2 Shandong Taishan Shandong 30 55 35 59
3 Beijing Guoan Beijing 30 54 31 51
4 Beijing Renhe Beijing 30 40 41 44
5 Dalian Pro Dalian Pro 30 40 43 41
6 Guangzhou City Guangzhou 30 45 47 40
7 Shanghai Shenxin Shanghai 30 31 42 40
8 Shanghai Shenhua Shanghai 30 36 36 38
9 Shanghái Port Shanghái 30 38 35 37
10 Liaoning Whowin Liaoning 30 35 44 35
11 Tianjin Jinmen Tiger Tianjin 30 35 39 34
12 Zhejiang FC Zhejiang FC 30 34 42 34
13 Jiangsu FC Jiangsu FC 30 32 39 32
14 Changchun Yatai Changchun 30 29 41 32
15 Qingdao Hainiu Qingdao 30 26 41 31
16 Wuhan FC Wuhan FC 30 24 58 16
TEMPORADA 2011/2012
LIGA UNO CHINA
Equipo PJ GF GC Puntos
1 Shanghai Tellace Shanghai 30 47 25 59
2 Wuhan FC Wuhan FC 30 40 29 54
3 Fujian Fujian 30 41 32 46
4 Shaoxing Keqiao Yuejia Shaoxing 30 53 43 45
5 Chongqing Liangjiang Chongqing 30 50 45 45
6 Tianjin Tianhai Tianjin 30 27 24 45
7 Shenzhen FC Shenzhen FC 30 46 41 42
8 Chongqing Chongqing 30 40 37 41
9 Chengdu Blades Chengdu 30 33 40 41
10 Shenyang Shenbei Shenyang 30 36 38 38
11 Hunan Billows FC Hunan 30 33 37 38
12 Guangdong Guangdong 30 41 46 38
13 Yanbian Longding Yanbian 30 39 51 34
14 Beijing Technology Beijing 30 27 41 32
15 Beijing BSU Beijing BSU 30 34 46 31
16 Hohhot Dongjin Hohhot 30 30 42 27
TEMPORADA 2010/2011
LIGA UNO CHINA
Equipo PJ GF GC Puntos
1 Dalian Pro Dalian Pro 26 45 20 54
2 Guangzhou City Guangzhou 26 36 27 47
3 Guangdong Guangdong 26 42 29 46
4 Hunan Billows FC Hunan 26 39 35 42
5 Hohhot Dongjin Hohhot 26 32 25 37
6 Shenyang Shenbei Shenyang 26 32 31 36
7 Wuhan FC Wuhan FC 26 26 28 33
8 Chongqing Liangjiang Chongqing 26 30 35 33
9 Shanghái Port Shanghái 26 29 25 32
10 Beijing BSU Beijing BSU 26 18 28 30
11 Yanbian Longding Yanbian 26 30 37 29
12 Tianjin Tianhai Tianjin 26 23 31 25
13 Beijing Technology Beijing 26 15 33 24
14 Guizhou Zhicheng Guizhou 26 15 28 20
TEMPORADA 2009/2010
LIGA UNO CHINA
Equipo PJ GF GC Puntos
1 Guangzhou FC Guangzhou 24 61 21 57
2 Chengdu Blades Chengdu 24 56 15 56
3 Yanbian Longding Yanbian 24 30 21 40
4 Shanghái Port Shanghái 24 25 18 37
5 Wuhan FC Wuhan FC 24 30 24 37
6 Hunan Billows FC Hunan 24 21 24 35
7 Beijing BSU Beijing BSU 24 24 24 34
8 Shenyang Dongjin Shenyang 24 23 23 30
9 Shenyang Shenbei Shenyang 24 17 36 24
10 Pudong Zhongbang Pudong 24 22 37 23
11 Guangdong Guangdong 24 34 39 22
12 Beijing Technology Beijing 24 22 40 18
13 Nanjing Yoyo Nanjing Yoyo 24 19 62 14

  USO DE MEMORIA  
6,555,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4784
Total Execution Time  0.4796
  CADENA URL  
/historico/Wuhan-Zall
  GET DATOS  
$_GET['/historico/Wuhan-Zall']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0213  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 = 68824
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7496 AND type_rel = 2
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7496 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0109  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 (84385,153093,177664,195127,317129) ORDER BY n.cover_points DESC, update_date DESC
0.0109  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 = '7496' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108  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 = '7496' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108  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 = 68824 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  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 = 67317 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  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=7496 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (68824,67317) 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.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 67317 AND teamId = 7496
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 68824 AND teamId = 7496
0.0111  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 67317 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107  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 = '7496' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7496' and rp.type = 4
0.0106  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 = '7496' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0117  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 events2022 e ON e.player_id = p.id AND e.league_id = 67317 WHERE rp.league_id = 67317 AND rp.teamId = 7496 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.0114  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 events2022 e ON e.player_id = p.id AND e.league_id = 67317 WHERE rp.league_id = 67317 AND rp.teamId = 7496 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0113  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 events2022 e ON e.player_id = p.id AND e.league_id = 67317 WHERE rp.league_id = 67317 AND rp.teamId = 7496 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0111  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 = 7496 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0111  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 = 67317 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.0109  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 = 60926 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 66087 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 55355 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 48533 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 42964 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 37753 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 20327 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 11707 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116  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 = 3762 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117  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 = 2322 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117  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 = 1740 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0119  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 = 16480 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116  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 `tables2010` 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 = 16481 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC