4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Beijing Technology
TEMPORADA 2023/2024
LIGA DOS CHINA
Equipo PJ GF GC Puntos
1 Shaanxi Union Shaanxi 6 16 3 14
2 Dalian K'un City Dalian K'un 6 11 5 13
3 Haimen Codion Haimen 6 11 6 12
4 Hubei Istar Hubei Istar 6 7 7 9
5 Beijing Technology Beijing 6 10 9 8
6 Langfang Glory City Langfang 6 5 5 6
7 Shandong Taishan B Shandong 6 4 6 6
8 Rizhao Yuqi Rizhao Yuqi 6 6 8 5
9 Taian Tiankuang Taian 6 3 10 5
10 Xi'an Ronghai Xi'an 6 4 18 2
11 Guangdong GZ-Power Guangdong 6 11 2 18
12 Ganzhou Ruishi Ganzhou 6 10 7 11
13 Guangxi Hengchen Guangxi 6 13 8 10
14 Hunan Billows FC Hunan 6 9 7 10
15 Shanghai Port B Shanghai 6 8 9 8
16 Shenzhen Junior Shenzhen 6 4 5 8
17 QZ Yassin QZ Yassin 6 6 9 8
18 Jiangxi Dark Horse Jiangxi Dark 6 8 10 5
19 Guangxi Lanhang Guangxi 6 5 8 4
20 Haikou Mingcheng Haikou 6 4 13 1
TEMPORADA 2022/2023
LIGA DOS CHINA GRUPO 3
Equipo PJ GF GC Puntos
1 Chongqing Tonglianglong Chongqing 22 49 14 49
2 Dalian Yingbo Dalian 22 30 12 47
3 Yunnan Yukun Yunnan Yukun 22 47 17 45
4 Qingdao Red Lions Qingdao 22 30 14 44
5 Guangxi Lanhang Guangxi 22 20 19 38
6 Beijing Technology Beijing 22 17 25 27
7 Jiangxi Dark Horse Jiangxi Dark 22 16 30 25
8 Hubei Istar Hubei Istar 22 20 28 23
TEMPORADA 2021/2022
LIGA UNO CHINA
Equipo PJ GF GC Puntos
1 Kunshan FC Kunshan FC 34 80 19 89
2 Qingdao Hainiu Qingdao 34 77 24 76
3 Nantong Zhiyun Nantong 34 62 22 70
4 Shijiazhuang Gongfu Shijiazhuang 34 50 31 66
5 Shaanxi Chang'an Shaanxi 34 55 32 62
6 Shenzhen Peng City Shenzhen 34 40 30 57
7 Suzhou Dongwu Suzhou 34 42 33 55
8 Nanjing City Nanjing City 34 45 38 50
9 Qingdao West Coast Qingdao West 34 47 44 48
10 Heilongjiang Ice City Heilongjiang 34 48 48 46
11 Jiangxi Lushan Jiangxi 34 40 51 39
12 Zibo Cuju Zibo Cuju 34 37 53 39
13 Guangxi Pingguo Haliao Guangxi 34 32 38 35
14 Liaoning Tieren Liaoning 34 34 53 35
15 Shanghai Jiading Huilong Shanghai 34 38 65 34
16 Beijing BSU Beijing BSU 34 24 59 24
17 Xinjiang Tianshan Xinjiang 34 31 83 21
18 Beijing Technology Beijing 34 18 77 10
TEMPORADA 2020/2021
LIGA UNO CHINA GRUPO 2
Equipo PJ GF GC Puntos
1 Wuhan Three Towns Wuhan Three 34 73 25 79
2 Meizhou Hakka Meizhou 34 79 35 75
3 Zhejiang FC Zhejiang FC 34 69 28 74
4 Chengdu Rongcheng Chengdu 34 81 28 71
5 Nantong Zhiyun Nantong 34 62 30 65
6 Shaanxi Chang'an Shaanxi 34 55 30 62
7 Heilongjiang Ice City Heilongjiang 34 50 40 56
8 Shenzhen Peng City Shenzhen 34 34 27 52
9 Kunshan FC Kunshan FC 34 56 35 51
10 Nanjing City Nanjing City 34 41 42 45
11 Zibo Cuju Zibo Cuju 34 32 52 39
12 Guizhou Zhicheng Guizhou 34 26 56 39
13 Suzhou Dongwu Suzhou 34 36 53 32
14 Jiangxi Lushan Jiangxi 34 29 68 29
15 Beijing BSU Beijing BSU 34 37 53 28
16 Liaoning Tieren Liaoning 34 30 62 25
17 Beijing Technology Beijing 34 24 82 14
18 Xinjiang Tianshan Xinjiang 34 16 84 9
TEMPORADA 2019/2020
LIGA DOS CHINA GRUPO 1
Equipo PJ GF GC Puntos
1 Nanjing City Nanjing City 9 16 4 25
2 Beijing Technology Beijing 9 15 6 18
3 Qingdao Hainiu Qingdao 9 14 7 16
4 Qingdao West Coast Qingdao West 9 11 9 14
5 Xi'an Wolves Xi'an Wolves 9 8 10 10
6 Shenzhen Bogang Shenzhen 9 11 15 10
7 Qingdao Red Lions Qingdao 9 4 7 8
8 Hebei Zhuoao Hebei Zhuoao 9 5 9 6
9 Inner Mongolia Inner 9 6 13 5
10 Jiangsu Yancheng Jiangsu 9 4 14 5
TEMPORADA 2018/2019
LIGA DOS CHINA GRUPO 2
Equipo PJ GF GC Puntos
TEMPORADA 2017/2018
LIGA DOS CHINA GRUPO 2
Equipo PJ GF GC Puntos
1 Shaanxi Chang'an Shaanxi 26 41 20 53
2 Jiangsu Yancheng Jiangsu 26 45 20 52
3 Liaoning Tieren Liaoning 26 51 28 52
4 Qingdao Hainiu Qingdao 26 44 23 51
5 Yinchuan Helanshan Yinchuan 26 45 23 49
6 Hebei Zhuoao Hebei Zhuoao 26 50 32 43
7 Jilin Baijia Jilin Baijia 26 41 33 43
8 Baoding Yingli Baoding 26 38 30 42
9 Dalian Boyoung Dalian 26 34 27 40
10 Zibo Cuju Zibo Cuju 26 34 31 35
11 Beijing Technology Beijing 26 39 50 26
12 Yanbian Beiguo Yanbian 26 29 49 24
13 Baotou Nanjiao Baotou 26 23 68 9
14 Shenyang Dongjin Shenyang 26 0 80 0
TEMPORADA 2016/2017
LIGA DOS CHINA GRUPO 2
Equipo PJ GF GC Puntos
TEMPORADA 2015/2016
LIGA DOS CHINA GRUPO 2
Equipo PJ GF GC Puntos
1 Yinchuan Helanshan Yinchuan 18 30 10 41
2 Hebei Zhuoao Hebei Zhuoao 18 32 15 38
3 Liaoning Tieren Liaoning 18 28 15 33
4 Baoding Yingli Baoding 18 28 16 32
5 Heilongjiang Ice City Heilongjiang 18 25 20 30
6 Baotou Nanjiao Baotou 18 22 29 19
7 Jingtie Locomotive Jingtie 18 16 24 16
8 Beijing Technology Beijing 18 16 28 16
9 Jiangsu Yancheng Jiangsu 18 13 26 13
10 Shenyang Dongjin Shenyang 18 14 41 8
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
LIGA UNO CHINA
Equipo PJ GF GC Puntos
1 Henan FC Henan FC 30 51 21 62
2 Shaoxing Keqiao Yuejia Shaoxing 30 55 29 60
3 Guangdong Guangdong 30 51 29 57
4 Chongqing Liangjiang Chongqing 30 45 27 56
5 Shenzhen FC Shenzhen FC 30 50 57 49
6 Shenyang Shenbei Shenyang 30 46 39 47
7 Beijing BSU Beijing BSU 30 35 42 41
8 Yongchang Junhao Yongchang 30 26 25 40
9 Yanbian Longding Yanbian 30 42 51 36
10 Tianjin Tianhai Tianjin 30 31 36 35
11 Beijing Technology Beijing 30 32 42 35
12 Hunan Billows FC Hunan 30 27 40 30
13 Xinjiang Tianshan Xinjiang 30 27 41 30
14 Chengdu Blades Chengdu 30 27 37 29
15 Chongqing Chongqing 30 23 36 28
16 Guizhou Zhicheng Guizhou 30 29 45 26
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
TEMPORADA 2008/2009
LIGA UNO CHINA
Equipo PJ GF GC Puntos
1 Liaoning Whowin Liaoning 24 49 17 57
2 Shanghai Shenxin Shanghai 24 48 22 47
3 Shanghái Port Shanghái 24 43 25 44
4 Shenyang Dongjin Shenyang 24 39 21 44
5 Guangdong Guangdong 24 37 37 35
6 Yanbian Longding Yanbian 24 29 30 29
7 Shenyang Shenbei Shenyang 24 35 44 29
8 Beijing Technology Beijing 24 29 33 28
9 Pudong Zhongbang Pudong 24 23 35 27
10 Qingdao Hailifeng Qingdao 24 38 45 26
11 Nanjing Yoyo Nanjing Yoyo 24 23 40 24
12 Beijing BSU Beijing BSU 24 26 36 22
13 Sichuan FC Sichuan FC 24 26 60 16
TEMPORADA 2007/2008
LIGA UNO CHINA
Equipo PJ GF GC Puntos
1 Jiangsu Shuntian Jiangsu 24 56 24 59
2 Chongqing Liangjiang Chongqing 24 34 19 43
3 Shanghai Shenxin Shanghai 24 37 24 42
4 Shenyang Shenbei Shenyang 24 33 37 30
5 Sichuan FC Sichuan FC 24 27 36 29
6 Shanghái Port Shanghái 24 26 30 28
7 Qingdao Hailifeng Qingdao 24 33 38 28
8 Yanbian Longding Yanbian 24 32 39 28
9 Beijing Technology Beijing 24 27 39 28
10 Nanjing Yoyo Nanjing Yoyo 24 35 38 27
11 Wuxi Zhongbang Wuxi 24 24 33 27
12 Beijing BSU Beijing BSU 24 24 24 26
13 Shaoxing Keqiao Yuejia Shaoxing 24 28 35 25
TEMPORADA 2006/2007
LIGA UNO CHINA
Equipo PJ GF GC Puntos
1 Guangzhou FC Guangzhou 24 65 15 61
2 Chengdu Blades Chengdu 24 54 14 55
3 Jiangsu Shuntian Jiangsu 24 41 21 48
4 Chongqing Liangjiang Chongqing 24 34 22 44
5 Shanghai Shenxin Shanghai 24 26 26 36
6 Yanbian Longding Yanbian 24 36 35 33
7 Qingdao Hailifeng Qingdao 24 27 36 33
8 Shanghai Kangbo Shanghai 24 26 37 26
9 Beijing BSU Beijing BSU 24 21 31 24
10 Nanjing Yoyo Nanjing Yoyo 24 26 39 24
11 Beijing Technology Beijing 24 27 40 22
12 Shaoxing Keqiao Yuejia Shaoxing 24 18 36 19
13 TIbet Huitong TIbet 24 8 57 0

  USO DE MEMORIA  
6,751,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1306
Total Execution Time  0.1318
  CADENA URL  
/historico/Bit
  GET DATOS  
$_GET['/historico/Bit']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0043  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 = 75650
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7493 AND type_rel = 2
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7493 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 (203645) ORDER BY n.cover_points DESC, update_date DESC
0.0033  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 = '7493' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = 75650 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0039  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=7493 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023  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 (75650,75481) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 75650 AND teamId = 7493
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 75481 AND teamId = 7493
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 = 75650 AND t.round = 7 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 = '7493' 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 = '7493' 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 = '7493' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 75650 WHERE rp.league_id = 75650 AND rp.teamId = 7493 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.0022  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 = 75650 WHERE rp.league_id = 75650 AND rp.teamId = 7493 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 75650 WHERE rp.league_id = 75650 AND rp.teamId = 7493 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 7493 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75650 AND t.round = 7 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 = 71552 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.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 = 73601 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.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 = 67704 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.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 = 62116 AND t.round = 10 ORDER BY team.conference ASC,t.position 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 `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 = 63317 AND t.round = 24 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 `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 = 63318 AND t.round = 9 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 `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 = 49503 AND t.round = 30 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 `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 = 47397 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 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 = 47400 AND t.round = 22 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 `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 = 47402 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 `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.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 `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.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 `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 = 2417 AND t.round = 30 ORDER BY team.conference 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 `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.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 = 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.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 `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
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 `tables2009` 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 = 16482 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 `tables2008` 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 = 16483 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 `tables2007` 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 = 16484 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC