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

Quang Nam

Entrenador: Sy Son Van

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Nam Dinh	15	34	22	32
2	Công Nhân	15	24	13	28
3	Binh Duong	15	16	13	27
4	Binh Dinh	15	27	19	25
5	Thanh	15	22	20	22
6	Ha Noi FC	15	22	21	22
7	Hong Linh T.	15	14	17	20
8	Chí Minh	15	16	18	19
9	Hai Phong	15	22	21	18
10	Viettel	15	13	20	17
11	Quang Nam	15	17	19	16
12	Hoang	15	12	19	15
13	Song Nghe	15	15	21	14
14	Sanna Khanh	15	9	20	10

TEMPORADA 2022/2023

SEGUNDA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Quang Nam	18	40	15	37
2	PVF-CAND	18	30	14	37
3	Long An	18	32	24	31
4	Hoa Binh FC	18	17	15	24
5	Binh Thuan	18	23	44	23
6	Bong	18	19	19	21
7	Phu Dong	18	16	21	19
8	Phu Tho	18	18	25	18
9	Bình	18	23	30	16
10	Vung	18	13	24	16

TEMPORADA 2021/2022

SEGUNDA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Công Nhân	22	37	15	43
2	Sanna Khanh	22	30	16	42
3	Quang Nam	22	30	22	40
4	PVF-CAND	22	40	22	38
5	Vung	22	30	19	38
6	Long An	22	36	28	32
7	Bong	22	20	31	25
8	Can Tho	22	25	40	23
9	Phu Tho	22	19	32	21
10	Bình	22	19	24	19
11	Dak Lak	22	18	32	18
12	Phu Dong	22	21	44	18

TEMPORADA 2020/2021

SEGUNDA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Sanna Khanh	7	8	2	15
2	Vung	6	8	4	13
3	Long An	7	5	2	12
4	Phu Dong	6	5	1	11
5	Dak Lak	6	7	5	9
6	Công Nhân	6	7	6	9
7	Bong	6	6	4	8
8	Can Tho	6	5	10	7
9	Quang Nam	7	7	8	6
10	Phu Tho	6	3	4	6
11	Bình	6	6	8	6
12	PVF-CAND	6	2	6	3
13	An Giang	7	2	11	1

TEMPORADA 2019/2020

LIGA VIETNAM GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Quang Nam	5	11	9	9
2	Song Nghe	5	7	5	8
3	Da Nang	5	7	7	7
4	Hai Phong	5	7	8	6
5	Thanh	5	7	8	6
6	Nam Dinh	5	5	7	5

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		Nam Dinh	32
2		Công An Nhân Dân	28
3		Binh Duong	27
4		Binh Dinh	25
5		Thanh Hoa FC	22
6		Ha Noi FC	22
7		Hong Linh Hà Tinh	20
8		Ho Chí Minh	19
9		Hai Phong	18
10		Viettel	17
11		Quang Nam	16
12		Hoang Anh Gia Lai	15
13		Song Lam Nghe An	14
14		Sanna Khanh Hoa	10

	AFC Champions League : Nam Dinh
	Playoff Descenso : Song Lam Nghe An
	Descenso : Sanna Khanh Hoa

RIVALES EN Copa Vietnam

RIVALES EN Liga Vietnam

USO DE MEMORIA

6,575,464 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7429
Total Execution Time	0.7441

CADENA URL

/historico/Quang-Nam

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0153	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 = 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.0145	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.0145	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.0145	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.0298	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 = 74227
0.0154	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 = 74252
0.0146	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17313 AND type_rel = 2
0.0151	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 = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0149	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.0147	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 = 74252 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146	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 = 74227 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149	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 (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147	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 (74252,74227,71457) 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.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 74227 AND teamId = 17313
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 71457 AND teamId = 17313
0.0160	SELECT count(id) as num_players from rel_players WHERE league_id = 74252 AND teamId = 17313
0.0163	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 = 74227 AND t.round = 15 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0157	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.0150	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17313' and rp.type = 4
0.0150	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.0159	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 = 74227 WHERE rp.league_id = 74227 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.0154	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 = 74227 WHERE rp.league_id = 74227 AND rp.teamId = 17313 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158	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 = 74227 WHERE rp.league_id = 74227 AND rp.teamId = 17313 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149	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 <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0148	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 = 74227 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 71457 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 66877 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 53831 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	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 = 59397 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.0148	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.0149	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.0148	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.0149	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.0148	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.0147	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.0147	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.0150	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.0152	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.0148	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.0148	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.0149	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

Quang Nam

Quang Nam

Selecciona un equipo

Competiciones que juega

Liga Vietnam

RIVALES EN Copa Vietnam

RIVALES EN Liga Vietnam