4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Zhejiang FC

Zhejiang FC

Entrenador: Jordi Vinyals

Temporada 2020/2021
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 UNO CHINA GRUPO 1
Equipo PJ GF GC Puntos
1 Chengdu Rongcheng Chengdu 10 15 7 25
2 Taizhou Yuanda Taizhou 10 13 8 18
3 Beijing Renhe Beijing 10 14 12 16
4 Beijing BSU Beijing BSU 10 14 14 11
5 Nei Mongol Zhongyou Mongol 10 5 12 7
6 Suzhou Dongwu Suzhou 10 7 15 7
7 Meizhou Hakka Meizhou 10 20 9 22
8 Zhejiang FC Zhejiang FC 10 19 8 19
9 Shaanxi Chang'an Shaanxi 10 11 10 15
10 Guizhou Zhicheng Guizhou 10 9 12 10
11 Liaoning Tieren Liaoning 10 9 14 9
12 Jiangxi Lushan Jiangxi 10 6 21 5
13 Changchun Yatai Changchun 10 20 7 21
14 Kunshan FC Kunshan FC 10 10 7 18
15 Nantong Zhiyun Nantong 10 9 9 16
16 Heilongjiang Ice City Heilongjiang 10 5 6 10
17 Shenzhen Peng City Shenzhen 10 8 12 9
18 Xinjiang Tianshan Xinjiang 10 5 16 3
TEMPORADA 2018/2019
LIGA UNO CHINA
Equipo PJ GF GC Puntos
1 Qingdao FC Qingdao FC 30 59 36 57
2 Cangzhou Mighty Lions Cangzhou 30 59 42 56
3 Guizhou Zhicheng Guizhou 30 46 28 54
4 Heilongjiang Ice City Heilongjiang 30 46 34 54
5 Changchun Yatai Changchun 30 52 42 53
6 Zhejiang FC Zhejiang FC 30 49 40 51
7 Nei Mongol Zhongyou Mongol 30 35 30 51
8 Beijing BSU Beijing BSU 30 51 30 46
9 Shaanxi Chang'an Shaanxi 30 39 37 44
10 Meizhou Hakka Meizhou 30 44 41 39
11 Meizhou Meixian Techand Meizhou 30 41 50 36
12 Nantong Zhiyun Nantong 30 35 38 33
13 Xinjiang Tianshan Xinjiang 30 39 55 33
14 Sichuan Annapurna Sichuan 30 36 52 31
15 Liaoning Whowin Liaoning 30 33 57 21
16 Shanghai Shenxin Shanghai 30 30 82 12
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
SUPERLIGA CHINA
Equipo PJ GF GC Puntos
1 Guangzhou FC Guangzhou 30 62 19 64
2 Jiangsu FC Jiangsu FC 30 53 33 57
3 Shanghái Port Shanghái 30 56 32 52
4 Shanghai Shenhua Shanghai 30 46 31 48
5 Beijing Guoan Beijing 30 34 26 43
6 Hebei FC Hebei FC 30 34 38 40
7 Guangzhou City Guangzhou 30 47 50 40
8 Yanbian Longding Yanbian 30 39 41 37
9 Chongqing Liangjiang Chongqing 30 43 50 37
10 Tianjin Jinmen Tiger Tianjin 30 38 50 36
11 Liaoning Whowin Liaoning 30 38 47 36
12 Changchun Yatai Changchun 30 30 44 35
13 Henan FC Henan FC 30 26 44 35
14 Shandong Taishan Shandong 30 38 45 34
15 Zhejiang FC Zhejiang FC 30 28 37 32
16 Cangzhou Mighty Lions Cangzhou 30 28 53 30
TEMPORADA 2014/2015
SUPERLIGA CHINA
Equipo PJ GF GC Puntos
1 Guangzhou FC Guangzhou 30 71 28 67
2 Shanghái Port Shanghái 30 63 35 65
3 Shandong Taishan Shandong 30 66 41 59
4 Beijing Guoan Beijing 30 46 26 56
5 Henan FC Henan FC 30 35 30 46
6 Shanghai Shenhua Shanghai 30 42 44 42
7 Cangzhou Mighty Lions Cangzhou 30 34 31 39
8 Changchun Yatai Changchun 30 39 47 35
9 Jiangsu FC Jiangsu FC 30 39 48 35
10 Chongqing Liangjiang Chongqing 30 37 52 35
11 Zhejiang FC Zhejiang FC 30 27 35 33
12 Guangzhou City Guangzhou 30 35 41 31
13 Tianjin Jinmen Tiger Tianjin 30 39 46 31
14 Liaoning Whowin Liaoning 30 30 46 31
15 Beijing Renhe Beijing 30 39 52 29
16 Shanghai Shenxin Shanghai 30 30 70 17
TEMPORADA 2013/2014
SUPERLIGA CHINA
Equipo PJ GF GC Puntos
1 Guangzhou FC Guangzhou 30 76 28 70
2 Beijing Guoan Beijing 30 50 25 67
3 Guangzhou City Guangzhou 30 67 39 57
4 Shandong Taishan Shandong 30 41 29 48
5 Shanghái Port Shanghái 30 47 39 48
6 Beijing Renhe Beijing 30 33 35 41
7 Tianjin Jinmen Tiger Tianjin 30 41 44 39
8 Jiangsu FC Jiangsu FC 30 37 45 37
9 Shanghai Shenhua Shanghai 30 33 45 35
10 Liaoning Whowin Liaoning 30 33 48 33
11 Shanghai Shenxin Shanghai 30 26 42 33
12 Changchun Yatai Changchun 30 33 40 32
13 Zhejiang FC Zhejiang FC 30 43 60 32
14 Henan FC Henan FC 30 32 39 30
15 Dalian Pro Dalian Pro 30 32 45 29
16 Shaoxing Keqiao Yuejia Shaoxing 30 35 56 21
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
SUPERLIGA CHINA
Equipo PJ GF GC Puntos
1 Guangzhou FC Guangzhou 30 51 30 58
2 Jiangsu FC Jiangsu FC 30 49 29 54
3 Beijing Guoan Beijing 30 34 35 48
4 Beijing Renhe Beijing 30 44 33 45
5 Dalian Pro Dalian Pro 30 51 46 44
6 Changchun Yatai Changchun 30 37 40 44
7 Guangzhou City Guangzhou 30 47 49 42
8 Tianjin Jinmen Tiger Tianjin 30 29 30 40
9 Shanghai Shenhua Shanghai 30 39 34 38
10 Shandong Taishan Shandong 30 46 43 36
11 Liaoning Whowin Liaoning 30 40 41 36
12 Qingdao Hainiu Qingdao 30 26 34 36
13 Zhejiang FC Zhejiang FC 30 34 46 36
14 Dalian Shide Dalian Shide 30 39 49 34
15 Shanghai Shenxin Shanghai 30 36 35 30
16 Henan FC Henan FC 30 28 56 26
TEMPORADA 2010/2011
SUPERLIGA CHINA
Equipo PJ GF GC Puntos
1 Guangzhou FC Guangzhou 30 67 23 68
2 Beijing Guoan Beijing 30 49 21 53
3 Liaoning Whowin Liaoning 30 38 23 50
4 Jiangsu FC Jiangsu FC 30 43 28 47
5 Shandong Taishan Shandong 30 37 31 47
6 Qingdao Hainiu Qingdao 30 37 33 45
7 Changchun Yatai Changchun 30 33 31 45
8 Zhejiang FC Zhejiang FC 30 28 32 39
9 Beijing Renhe Beijing 30 34 41 38
10 Tianjin Jinmen Tiger Tianjin 30 37 41 37
11 Shanghai Shenhua Shanghai 30 31 41 37
12 Henan FC Henan FC 30 29 35 32
13 Dalian Shide Dalian Shide 30 27 43 32
14 Shanghai Shenxin Shanghai 30 20 41 29
15 Chengdu Blades Chengdu 30 27 47 27
16 Shenzhen FC Shenzhen FC 30 27 53 23
TEMPORADA 2009/2010
SUPERLIGA CHINA
Equipo PJ GF GC Puntos
1 Shandong Taishan Shandong 30 59 34 63
2 Tianjin Jinmen Tiger Tianjin 30 37 29 50
3 Zhejiang FC Zhejiang FC 30 38 30 48
4 Shanghai Shenhua Shanghai 30 44 41 48
5 Beijing Guoan Beijing 30 35 29 46
6 Dalian Shide Dalian Shide 30 40 37 42
7 Liaoning Whowin Liaoning 30 39 36 40
8 Henan FC Henan FC 30 31 31 40
9 Changchun Yatai Changchun 30 40 41 38
10 Beijing Renhe Beijing 30 33 36 37
11 Jiangsu FC Jiangsu FC 30 27 27 35
12 Shanghai Shenxin Shanghai 30 33 35 32
13 Shenzhen FC Shenzhen FC 30 34 41 32
14 Chongqing Liangjiang Chongqing 30 36 48 30
15 Qingdao Hainiu Qingdao 30 31 44 30
16 Guangzhou City Guangzhou 30 24 42 30
TEMPORADA 2008/2009
SUPERLIGA CHINA
Equipo PJ GF GC Puntos
1 Beijing Guoan Beijing 30 48 28 51
2 Changchun Yatai Changchun 30 38 31 50
3 Henan FC Henan FC 30 35 26 48
4 Shanghai Shenhua Shanghai 30 39 29 45
5 Tianjin Jinmen Tiger Tianjin 30 36 29 45
6 Shandong Taishan Shandong 30 35 30 45
7 Chengdu Blades Chengdu 30 32 39 39
8 Dalian Shide Dalian Shide 30 27 31 38
9 Beijing Renhe Beijing 30 26 24 37
10 Guangzhou Yiyao Guangzhou 30 38 38 37
11 Jiangsu FC Jiangsu FC 30 30 30 37
12 Shenzhen FC Shenzhen FC 30 36 40 37
13 Qingdao Hainiu Qingdao 30 36 36 36
14 Changsha Ginde Changsha 30 23 31 33
15 Zhejiang FC Zhejiang FC 30 30 43 32
16 Chongqing Liangjiang Chongqing 30 27 51 29
TEMPORADA 2007/2008
SUPERLIGA CHINA
Equipo PJ GF GC Puntos
1 Shandong Taishan Shandong 30 54 25 63
2 Shanghai Shenhua Shanghai 30 58 29 61
3 Beijing Guoan Beijing 30 44 27 58
4 Tianjin Jinmen Tiger Tianjin 30 54 29 57
5 Beijing Renhe Beijing 30 39 29 52
6 Changchun Yatai Changchun 30 53 45 45
7 Guangzhou FC Guangzhou 30 41 42 40
8 Zhejiang FC Zhejiang FC 30 38 32 39
9 Qingdao Hainiu Qingdao 30 39 36 39
10 Henan FC Henan FC 30 30 31 36
11 Guangzhou City Guangzhou 30 28 36 34
12 Shenzhen FC Shenzhen FC 30 35 34 33
13 Chengdu Blades Chengdu 30 30 37 32
14 Dalian Shide Dalian Shide 30 30 40 30
15 Liaoning Whowin Liaoning 30 32 47 27
16 Wuhan Guanggu Wuhan 30 0 86 0
TEMPORADA 2006/2007
SUPERLIGA CHINA
Equipo PJ GF GC Puntos
1 Changchun Yatai Changchun 28 48 25 55
2 Beijing Guoan Beijing 28 45 19 54
3 Shandong Taishan Shandong 28 53 29 48
4 Shanghai Shenhua Shanghai 28 35 29 46
5 Tianjin Jinmen Tiger Tianjin 28 31 22 44
6 Dalian Shide Dalian Shide 28 36 31 44
7 Wuhan Guanggu Wuhan 28 29 31 40
8 Qingdao Hainiu Qingdao 28 36 42 36
9 Liaoning Whowin Liaoning 28 26 36 35
10 Guangzhou City Guangzhou 28 17 24 34
11 Zhejiang FC Zhejiang FC 28 25 35 28
12 Henan FC Henan FC 28 20 28 27
13 Beijing Renhe Beijing 28 24 29 26
14 Shenzhen FC Shenzhen FC 28 21 42 25
15 Xiamen Lanshi Xiamen 28 22 46 20
TEMPORADA 2005/2006
LIGA UNO CHINA
Equipo PJ GF GC Puntos
1 Henan FC Henan FC 24 38 13 59
2 Zhejiang FC Zhejiang FC 24 41 18 55
3 Guangzhou FC Guangzhou 24 45 25 48
4 Chengdu Blades Chengdu 24 27 18 38
5 Nanjing Yoyo Nanjing Yoyo 24 24 20 35
6 Jiangsu FC Jiangsu FC 24 37 31 33
7 Qingdao Hailifeng Qingdao 24 25 32 31
8 Yanbian Longding Yanbian 24 26 22 29
9 TIbet Huitong TIbet 24 32 41 26
10 Shanghai Kangbo Shanghai 24 15 35 22
11 Shanghai Shenxin Shanghai 24 11 27 20
12 Beijing BSU Beijing BSU 24 18 40 19
13 Hunan Billows FC Hunan 24 16 33 15
TEMPORADA 2004/2005
LIGA UNO CHINA
Equipo PJ GF GC Puntos
1 Changchun Yatai Changchun 26 71 22 64
2 Xiamen Lanshi Xiamen 26 61 23 64
3 Guangdong Guangdong 26 50 22 52
4 Zhejiang FC Zhejiang FC 26 49 25 52
5 Jiangsu Shuntian Jiangsu 26 43 21 47
6 Qingdao Hisense Qingdao 26 35 32 41
7 Yanbian Longding Yanbian 26 45 40 36
8 Nanjing Yoyo Nanjing Yoyo 26 41 39 34
9 Shanghai 9th City Shanghai 26 46 54 29
10 Henan FC Henan FC 26 27 36 27
11 Chengdu Blades Chengdu 26 40 57 26
12 Hunan Billows FC Hunan 26 24 56 19
13 Dalian Changbo Dalian 26 20 54 16
14 Shaanxi Guoli Shaanxi 26 2 73 4
TEMPORADA 2003/2004
LIGA UNO CHINA
Equipo PJ GF GC Puntos
1 Wuhan Guanggu Wuhan 32 53 28 65
2 Wuxi Zhongbang Wuxi 32 56 36 62
3 Xiamen Hongshi Xiamen 32 38 26 53
4 Guangdong Guangdong 32 45 29 52
5 Changchun Yatai Changchun 32 53 34 51
6 Jiangsu FC Jiangsu FC 32 35 24 50
7 Henan FC Henan FC 32 29 27 45
8 Zhejiang FC Zhejiang FC 32 38 39 45
9 Nanjing Yoyo Nanjing Yoyo 32 44 46 43
10 Shenzhen Kejian Shenzhen 32 44 40 39
11 Qingdao Hisense Qingdao 32 36 39 39
12 Shaanxi Guoli Shaanxi 32 44 59 39
13 Chengdu Wuniu Chengdu 32 46 57 31
14 Hunan Billows FC Hunan 32 34 51 31
15 Dalian Changbo Dalian 32 22 35 30
16 Guangdong Dongguan Guangdong 32 38 56 30
17 Xian Anxinyuan Xian 32 30 59 22

  USO DE MEMORIA  
7,591,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1784
Total Execution Time  0.1796
  CADENA URL  
/historico/Hangzhou/2021
  GET DATOS  
$_GET['/historico/Hangzhou/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (54)  
0.0040  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 = 'Hangzhou' AND l.year = 2021 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.0020  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=7490 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=7490 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=7490 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=7490 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=7490 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 62116
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 = 63317
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 = 66296
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 = 63699
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7490 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7490 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (44577,85686,96984,99063,336733) ORDER BY n.cover_points DESC, update_date DESC
0.0030  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 = '7490' ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '7490' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '7490' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 66296 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 = 63699 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 = 62116 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=7490 AND l.year in (2020,2021,2022) 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 (68824,67317,66296,63317,49506) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 67317 AND teamId = 7490
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 63317 AND teamId = 7490
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 66296 AND teamId = 7490
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 68824 AND teamId = 7490
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 7490
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '7490' 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 = '7490' 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 = '7490' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032  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 events2021 e ON e.player_id = p.id AND e.league_id = 62116 WHERE rp.league_id = 62116 AND rp.teamId = 7490 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.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 events2021 e ON e.player_id = p.id AND e.league_id = 62116 WHERE rp.league_id = 62116 AND rp.teamId = 7490 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 events2021 e ON e.player_id = p.id AND e.league_id = 62116 WHERE rp.league_id = 62116 AND rp.teamId = 7490 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 = 7490 AND l.year <= 2021 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 `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.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 `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.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 `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 = 59789 AND t.round = 5 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 `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 = 55670 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.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 `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 = 49167 AND t.round = 30 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 = 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.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 = 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.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 = 20264 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 `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 = 9543 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 `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 = 3629 AND t.round = 30 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 `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.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 = 1583 AND t.round = 30 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 `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 = 1097 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 `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 = 892 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 `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 = 242 AND t.round = 30 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 `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 = 8816 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 `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 = 8815 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 `tables2006` 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 = 16485 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 `tables2005` 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 = 16486 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 `tables2004` 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 = 16487 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC