Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Dalian Pro

Temporada 2022/2023

TEMPORADA 2022/2023

SUPERLIGA CHINA
Equipo		PJ	GF	GC	Puntos
1	Shanghái	30	61	30	63
2	Shandong	30	59	25	58
3	Zhejiang FC	30	57	34	55
4	Chengdu	30	51	32	53
5	Shanghai	30	34	31	52
6	Beijing	30	53	35	51
7	Wuhan Three	30	51	35	51
8	Tianjin	30	40	29	48
9	Changchun	30	44	48	39
10	Henan FC	30	38	40	36
11	Meizhou	30	42	54	34
12	Cangzhou	30	29	60	31
13	Qingdao	30	34	45	28
14	Nantong	30	26	42	22
15	Dalian Pro	30	25	47	20
16	Shenzhen FC	30	22	79	12

TEMPORADA 2021/2022

SUPERLIGA CHINA
Equipo		PJ	GF	GC	Puntos
1	Wuhan Three	34	91	28	78
2	Shandong	34	87	29	78
3	Zhejiang FC	34	64	28	65
4	Shanghái	34	55	25	65
5	Chengdu	34	49	28	65
6	Henan FC	34	60	32	59
7	Beijing	34	57	49	58
8	Tianjin	34	45	42	49
9	Meizhou	34	43	41	49
10	Shanghai	34	42	34	47
11	Dalian Pro	34	49	53	45
12	Cangzhou	34	47	51	44
13	Changchun	34	49	50	44
14	Shenzhen FC	34	29	74	30
15	Guangzhou	34	32	62	23
16	Wuhan FC	34	34	71	19
17	Guangzhou	34	24	63	17
18	Hebei FC	34	18	115	-3

TEMPORADA 2020/2021

SUPERLIGA CHINA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Shanghai	22	34	22	37
2	Henan FC	22	19	20	30
3	Cangzhou	22	25	32	24
4	Tianjin	22	18	35	21
5	Chongqing	22	21	36	20
6	Wuhan FC	22	23	30	20
7	Dalian Pro	22	21	37	19
8	Qingdao FC	22	13	52	11

TEMPORADA 2019/2020

SUPERLIGA CHINA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Guangzhou	14	31	12	34
2	Jiangsu FC	14	23	15	26
3	Shandong	14	19	11	24
4	Shanghai	14	16	15	21
5	Shenzhen FC	14	20	20	17
6	Guangzhou	14	14	28	15
7	Dalian Pro	14	18	21	11
8	Henan FC	14	14	33	6
9	Shanghái	14	26	11	32
10	Beijing	14	36	19	28
11	Chongqing	14	22	19	24
12	Hebei FC	14	25	23	24
13	Wuhan FC	14	16	16	17
14	Cangzhou	14	18	21	17
15	Qingdao FC	14	15	27	10
16	Tianjin	14	8	30	3

TEMPORADA 2018/2019

SUPERLIGA CHINA
Equipo		PJ	GF	GC	Puntos
1	Guangzhou	30	68	24	72
2	Beijing	30	60	26	70
3	Shanghái	30	62	26	66
4	Jiangsu FC	30	60	41	53
5	Shandong	30	55	35	51
6	Wuhan FC	30	41	41	44
7	Tianjin	30	43	45	41
8	Henan FC	30	41	46	41
9	Dalian Pro	30	44	51	38
10	Chongqing	30	36	47	36
11	Hebei FC	30	37	55	33
12	Guangzhou	30	54	72	32
13	Shanghai	30	43	57	30
14	Tianjin	30	40	53	25
15	Shenzhen FC	30	31	57	21
16	Beijing	30	26	65	14

TEMPORADA 2017/2018

SUPERLIGA CHINA
Equipo		PJ	GF	GC	Puntos
1	Shanghái	30	77	33	68
2	Guangzhou	30	82	36	63
3	Shandong	30	57	39	58
4	Beijing	30	64	45	53
5	Jiangsu FC	30	48	33	48
6	Hebei FC	30	46	50	39
7	Shanghai	30	44	53	38
8	Beijing	30	33	46	37
9	Tianjin	30	41	48	36
10	Guangzhou	30	49	61	36
11	Dalian Pro	30	37	57	35
12	Henan FC	30	30	45	34
13	Chongqing	30	40	46	32
14	Tianjin	30	41	54	32
15	Changchun	30	45	56	32
16	Guizhou	30	34	66	24

TEMPORADA 2016/2017

LIGA UNO CHINA
Equipo		PJ	GF	GC	Puntos
1	Dalian Pro	30	48	23	64
2	Beijing	30	48	21	62
3	Cangzhou	30	48	33	54
4	Qingdao FC	30	56	40	52
5	Wuhan FC	30	47	40	47
6	Shenzhen FC	30	56	37	46
7	Shanghai	30	52	42	40
8	Beijing BSU	30	43	50	37
9	Zhejiang FC	30	31	39	36
10	Mongol	30	40	47	35
11	Xinjiang	30	37	52	35
12	Meizhou	30	33	39	33
13	Shaoxing	30	35	46	32
14	Baoding	30	41	51	31
15	Dalian	30	34	58	31
16	Yunnan	30	31	62	21

TEMPORADA 2015/2016

LIGA UNO CHINA
Equipo		PJ	GF	GC	Puntos
1	Tianjin	30	61	27	59
2	Guizhou	30	48	27	59
3	Qingdao FC	30	52	42	59
4	Beijing	30	49	35	49
5	Dalian Pro	30	43	44	45
6	Wuhan FC	30	31	33	43
7	Beijing BSU	30	40	38	41
8	Mongol	30	37	35	41
9	Shanghai	30	54	48	40
10	Shenzhen FC	30	36	43	40
11	Meizhou	30	48	50	39
12	Xinjiang	30	31	36	39
13	Dalian	30	32	36	38
14	Shaoxing	30	39	49	38
15	Qingdao	30	30	43	33
16	Hunan	30	16	61	12

TEMPORADA 2014/2015

LIGA UNO CHINA
Equipo		PJ	GF	GC	Puntos
1	Yanbian	30	59	24	61
2	Hebei FC	30	53	30	60
3	Dalian Pro	30	46	22	58
4	Beijing BSU	30	48	29	56
5	Shaoxing	30	43	31	47
6	Mongol	30	38	32	43
7	Qingdao	30	30	38	41
8	Xinjiang	30	43	51	39
9	Wuhan FC	30	31	30	36
10	Tianjin	30	28	33	36
11	Qingdao FC	30	26	39	33
12	Shenzhen FC	30	37	48	31
13	Guizhou	30	38	55	30
14	Hunan	30	32	48	29
15	Beijing	30	40	64	29
16	Jiangxi	30	32	50	23

TEMPORADA 2013/2014

SUPERLIGA CHINA
Equipo		PJ	GF	GC	Puntos
1	Guangzhou	30	76	28	70
2	Beijing	30	50	25	67
3	Guangzhou	30	67	39	57
4	Shandong	30	41	29	48
5	Shanghái	30	47	39	48
6	Beijing	30	33	35	41
7	Tianjin	30	41	44	39
8	Jiangsu FC	30	37	45	37
9	Shanghai	30	33	45	35
10	Liaoning	30	33	48	33
11	Shanghai	30	26	42	33
12	Changchun	30	33	40	32
13	Zhejiang FC	30	43	60	32
14	Henan FC	30	32	39	30
15	Dalian Pro	30	32	45	29
16	Shaoxing	30	35	56	21

TEMPORADA 2012/2013

SUPERLIGA CHINA
Equipo		PJ	GF	GC	Puntos
1	Guangzhou	30	78	18	77
2	Shandong	30	55	35	59
3	Beijing	30	54	31	51
4	Beijing	30	40	41	44
5	Dalian Pro	30	40	43	41
6	Guangzhou	30	45	47	40
7	Shanghai	30	31	42	40
8	Shanghai	30	36	36	38
9	Shanghái	30	38	35	37
10	Liaoning	30	35	44	35
11	Tianjin	30	35	39	34
12	Zhejiang FC	30	34	42	34
13	Jiangsu FC	30	32	39	32
14	Changchun	30	29	41	32
15	Qingdao	30	26	41	31
16	Wuhan FC	30	24	58	16

TEMPORADA 2011/2012

SUPERLIGA CHINA
Equipo		PJ	GF	GC	Puntos
1	Guangzhou	30	51	30	58
2	Jiangsu FC	30	49	29	54
3	Beijing	30	34	35	48
4	Beijing	30	44	33	45
5	Dalian Pro	30	51	46	44
6	Changchun	30	37	40	44
7	Guangzhou	30	47	49	42
8	Tianjin	30	29	30	40
9	Shanghai	30	39	34	38
10	Shandong	30	46	43	36
11	Liaoning	30	40	41	36
12	Qingdao	30	26	34	36
13	Zhejiang FC	30	34	46	36
14	Dalian Shide	30	39	49	34
15	Shanghai	30	36	35	30
16	Henan FC	30	28	56	26

TEMPORADA 2010/2011

LIGA UNO CHINA
Equipo		PJ	GF	GC	Puntos
1	Dalian Pro	26	45	20	54
2	Guangzhou	26	36	27	47
3	Guangdong	26	42	29	46
4	Hunan	26	39	35	42
5	Hohhot	26	32	25	37
6	Shenyang	26	32	31	36
7	Wuhan FC	26	26	28	33
8	Chongqing	26	30	35	33
9	Shanghái	26	29	25	32
10	Beijing BSU	26	18	28	30
11	Yanbian	26	30	37	29
12	Tianjin	26	23	31	25
13	Beijing	26	15	33	24
14	Guizhou	26	15	28	20

Competiciones que juega

Superliga China

Pos	Equipos		Pts
1		Shanghái Port	63
2		Shandong Taishan	58
3		Zhejiang FC	55
4		Chengdu Rongcheng	53
5		Shanghai Shenhua	52
6		Beijing Guoan	51
7		Wuhan Three Towns	51
8		Tianjin Jinmen Tiger	48
9		Changchun Yatai	39
10		Henan FC	36
11		Meizhou Hakka	34
12		Cangzhou Mighty Lions	31
13		Qingdao Hainiu	28
14		Nantong Zhiyun	22
15		Dalian Pro	20
16		Shenzhen FC	12

	: Shanghái Port, Shanghai Shenhua
	: Shandong Taishan
	: Zhejiang FC
	Descenso : Dalian Pro, Shenzhen FC

RIVALES EN Copa China FA

RIVALES EN Superliga China

USO DE MEMORIA

6,559,312 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1889
Total Execution Time	0.1902

CADENA URL

/historico/Dalian-Aerbin

GET DATOS

$_GET['/historico/Dalian-Aerbin']

POST DATOS

No hay datos POST existentes

CONSULTAS (65)

0.0026	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 = 'Dalian-Aerbin' 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.0068	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 = 'Dalian-Aerbin' 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=6424 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=6424 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=6424 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=6424 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0031	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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 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=6424 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=6424 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=6424 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=6424 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=6424 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=6424 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6424 AND type_rel = 2
0.0024	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6424 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023	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 (42351,43527,87573,105361,140417) 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 = '6424' ORDER BY l.year DESC,cat.coefficient DESC
0.0023	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '6424' AND l.year = 2023 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 = '6424' 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 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=6424 AND l.year in (2022,2023,2024) 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 (71650,71453) 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 = 71453 AND teamId = 6424
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 71650 AND teamId = 6424
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 = '6424' 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 = '6424' and rp.type = 4
0.0020	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '6424' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0035	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 events2023 e ON e.player_id = p.id AND e.league_id = 71453 WHERE rp.league_id = 71453 AND rp.teamId = 6424 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.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 events2023 e ON e.player_id = p.id AND e.league_id = 71453 WHERE rp.league_id = 71453 AND rp.teamId = 6424 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 events2023 e ON e.player_id = p.id AND e.league_id = 71453 WHERE rp.league_id = 71453 AND rp.teamId = 6424 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 6424 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 71453 AND t.round = 30 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* `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.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* `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.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* `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.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* `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.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 = 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.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 = 42427 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* `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.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* `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.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 = 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.0028	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.0028	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.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

Dalian Pro

Dalian Pro

Selecciona un equipo

Competiciones que juega

Superliga China

RIVALES EN Copa China FA

RIVALES EN Superliga China