Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

Quang Nam

Entrenador: Sy Son Van

Temporada 2018/2019

TEMPORADA 2018/2019

LIGA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Ha Noi FC	26	60	30	53
2	Chí Minh	26	41	29	48
3	Quang Ninh	26	41	33	39
4	Binh Duong	26	32	32	36
5	Sai Gon	26	37	40	36
6	Viettel	26	33	40	36
7	Song Nghe	26	32	26	35
8	Hoang	26	45	46	35
9	Quang Nam	26	43	38	34
10	Da Nang	26	38	38	33
11	Nam Dinh	26	32	41	31
12	Hai Phong	26	33	44	30
13	Thanh	26	36	52	26
14	Sanna Khanh	26	31	45	25

TEMPORADA 2017/2018

LIGA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Ha Noi FC	26	72	30	64
2	Thanh	26	43	29	46
3	Sanna Khanh	26	33	27	43
4	Song Nghe	26	38	32	42
5	Quang Ninh	26	40	39	35
6	Hai Phong	26	26	26	34
7	Binh Duong	26	39	36	33
8	Sai Gon	26	38	42	31
9	Da Nang	26	38	49	31
10	Hoang	26	41	53	31
11	Quang Nam	26	37	45	31
12	Chí Minh	26	37	45	27
13	Nam Dinh	26	33	45	24
14	Can Tho	26	26	43	21

TEMPORADA 2016/2017

LIGA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Thanh	26	44	29	48
2	Quang Nam	26	46	32	48
3	Ha Noi FC	26	54	31	46
4	Quang Ninh	26	42	34	43
5	Sai Gon	26	40	29	43
6	Sanna Khanh	26	38	37	41
7	Hai Phong	26	35	33	38
8	Song Nghe	26	36	36	34
9	Da Nang	26	36	34	33
10	Binh Duong	26	34	30	30
11	Hoang	26	34	43	30
12	Chí Minh	26	29	46	25
13	Can Tho	26	32	50	22
14	Long An	26	30	66	10

TEMPORADA 2015/2016

LIGA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Ha Noi FC	26	45	28	50
2	Hai Phong	26	47	32	50
3	Da Nang	26	49	33	49
4	Quang Ninh	26	39	31	44
5	Quang Nam	26	44	32	42
6	Thanh	26	51	42	42
7	Sanna Khanh	26	34	30	36
8	Sai Gon	26	34	32	36
9	Binh Duong	26	39	37	34
10	Can Tho	26	37	36	34
11	Song Nghe	26	34	36	34
12	Hoang	26	39	50	30
13	Long An	26	34	62	19
14	Dong Thap	26	22	67	8

TEMPORADA 2014/2015

LIGA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Binh Duong	26	57	33	52
2	Ha Noi FC	26	51	30	46
3	Thanh	26	42	44	44
4	Quang Ninh	26	39	31	42
5	Sanna Khanh	26	35	35	42
6	Hai Phong	26	31	28	41
7	Song Nghe	26	36	33	37
8	Quang Nam	26	49	39	36
9	Da Nang	26	42	32	36
10	Long An	26	39	42	33
11	Can Tho	26	32	52	25
12	Hoang	26	33	50	24
13	Dong Thap	26	34	54	24
14	Dong Nai	26	35	52	21

TEMPORADA 2013/2014

LIGA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Binh Duong	22	53	23	49
2	Ha Noi FC	22	66	40	47
3	Thanh	22	32	34	40
4	Da Nang	22	43	33	39
5	Song Nghe	22	38	26	36
6	Quang Ninh	22	43	44	29
7	Dong Nai	22	39	40	25
8	Quang Nam	22	34	52	25
9	Hoang	22	41	48	23
10	Hai Phong	22	26	37	21
11	Long An	22	29	45	21
12	An Giang	22	22	44	12
13	Vissai Ninh	0	0	0	0

TEMPORADA 2012/2013

SEGUNDA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Quang Nam	14	30	22	25
2	Quang Ninh	14	24	17	25
3	An Giang	14	26	22	24
4	Dong Thap	14	20	18	24
5	Can Tho	14	31	25	21
6	Binh Dinh	14	20	23	12
7	Binh Duong	14	13	24	12
8	Sai Gon	14	10	23	12

TEMPORADA 2011/2012

SEGUNDA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Long An	26	36	26	49
2	Sai Gon	26	35	30	48
3	Dong Nai	26	40	30	40
4	Quang Ninh	26	37	28	39
5	Can Tho	26	37	30	39
6	Binh Dinh	26	40	34	38
7	Da Nang II	26	42	39	37
8	Lam Dong	26	28	36	33
9	An Giang	26	30	29	32
10	Quang Nam	26	27	32	31
11	Ha Noi II	26	34	34	29
12	Mang Ninh	26	28	38	29
13	Binh Duong	26	27	37	29
14	Chí Minh	26	36	54	23

TEMPORADA 2010/2011

SEGUNDA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Xuan Thanh	26	65	35	54
2	Kienlongbank	26	44	26	47
3	Binh Dinh	26	31	18	45
4	Quang Ninh	26	45	37	42
5	An Giang	26	46	46	37
6	Dong Nai	26	34	35	36
7	Can Tho	26	33	42	36
8	Sai Gon	26	38	38	33
9	Quang Nam	26	30	33	30
10	Chí Minh	26	29	36	28
11	Binh Duong	26	32	43	28
12	Mang Ninh	26	34	40	27
13	Nam Dinh	26	29	41	27
14	Huda Hue	26	31	51	20

TEMPORADA 2009/2010

SEGUNDA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Ha Noi ACB	24	50	33	45
2	Quang Ninh	24	38	27	43
3	Binh Dinh	24	44	32	40
4	An Giang	24	35	28	39
5	Quang Nam	24	28	22	38
6	Can Tho	24	27	28	33
7	Binh Duong	24	35	37	29
8	Mang Ninh	24	39	51	29
9	Sai Gon	24	36	43	27
10	Huda Hue	24	27	38	27
11	Chí Minh	24	28	42	27
12	Tien Giang	24	31	33	26
13	Dong Nai	24	27	31	26

TEMPORADA 2008/2009

SEGUNDA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Vissai Ninh	24	36	9	53
2	Hoa Phat	24	37	22	44
3	Can Tho	24	32	26	37
4	Binh Dinh	24	39	36	37
5	Huda Hue	24	21	16	34
6	Mang Ninh	24	30	37	31
7	Quang Ninh	24	33	30	30
8	Ha Noi ACB	24	29	35	29
9	Dong Nai	24	26	30	28
10	Tien Giang	24	26	33	27
11	An Giang	24	20	31	27
12	Quang Nam	24	23	34	23
13	Xuan Thanh	24	19	32	22

TEMPORADA 2006/2007

LIGA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Binh Duong	26	42	22	55
2	Long An	26	46	31	44
3	Hoang	26	40	33	41
4	Nam Dinh	26	35	31	38
5	Quang Nam	26	33	28	37
6	Binh Dinh	26	34	36	36
7	Song Nghe	26	38	35	35
8	Chí Minh	26	41	40	34
9	Khatoco	26	30	31	34
10	Thanh	26	27	30	34
11	Sai Gon	26	30	36	31
12	Hoa Phat	26	31	41	30
13	Dong Thap	26	21	35	20
14	Huda Hue	26	25	44	20

Competiciones que juega

Liga Vietnam

Pos	Equipos		Pts
1		Ha Noi FC	53
2		Ho Chí Minh	48
3		Quang Ninh	39
4		Binh Duong	36
5		Sai Gon	36
6		Viettel	36
7		Song Lam Nghe An	35
8		Hoang Anh Gia Lai	35
9		Quang Nam	34
10		Da Nang	33
11		Nam Dinh	31
12		Hai Phong	30
13		Thanh Hoa FC	26
14		Sanna Khanh Hoa	25

	AFC Champions League : Ha Noi FC
	Descenso : Sanna Khanh Hoa

RIVALES EN Copa Vietnam

RIVALES EN Liga Vietnam

USO DE MEMORIA

6,140,936 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1596
Total Execution Time	0.1608

CADENA URL

/historico/Quang-Nam/2019

GET DATOS

$_GET['/historico/Quang-Nam/2019']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0028	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 = 'Quang-Nam' AND l.year = 2019 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=17313 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=17313 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=17313 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042	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 = 48695
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 = 48694
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17313 AND type_rel = 2
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=401 AND type_rel = 3
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 401 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022	SELECT /53 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 (1252215,971196,946785,864980,846433) 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 = '17313' ORDER BY l.year DESC,cat.coefficient DESC
0.0024	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '17313' AND l.year = 2019 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 = '17313' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 48694 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	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 = 48695 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0032	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=17313 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (59397,53803,49506,43754) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 59397 AND teamId = 17313
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 53803 AND teamId = 17313
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 43754 AND teamId = 17313
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 17313
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 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 = 48695 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023	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 = '17313' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17313' and rp.type = 4
0.0024	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 = '17313' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0054	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 events2019 e ON e.player_id = p.id AND e.league_id = 48695 WHERE rp.league_id = 48695 AND rp.teamId = 17313 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.0074	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 events2019 e ON e.player_id = p.id AND e.league_id = 48695 WHERE rp.league_id = 48695 AND rp.teamId = 17313 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0044	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 events2019 e ON e.player_id = p.id AND e.league_id = 48695 WHERE rp.league_id = 48695 AND rp.teamId = 17313 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035	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 = 17313 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 48695 AND t.round = 26 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* `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 = 43100 AND t.round = 26 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* `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 = 37672 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 20225 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 9210 AND t.round = 26 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* `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 = 3563 AND t.round = 26 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 = 16209 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 16208 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 16207 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036	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 = 16206 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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 = 16205 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0052	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 = 9822 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 48695 ORDER BY nameShow LIMIT 100

Quang Nam

Quang Nam

Selecciona un equipo

Competiciones que juega

Liga Vietnam

RIVALES EN Copa Vietnam

RIVALES EN Liga Vietnam