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

Nam Dinh

Entrenador: Hong Viet Vu

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

LIGA VIETNAM GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ha Noi FC	20	35	22	38
2	Công Nhân	20	39	21	38
3	Viettel	20	23	17	32
4	Thanh	20	27	22	31
5	Nam Dinh	20	19	19	29
6	Hai Phong	20	20	23	26
7	Binh Dinh	20	23	28	24
8	Hong Linh T.	20	24	30	23

TEMPORADA 2021/2022

LIGA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Ha Noi FC	24	47	21	51
2	Hai Phong	24	39	26	48
3	Binh Dinh	24	37	22	47
4	Viettel	24	29	14	39
5	Song Nghe	24	29	28	33
6	Hoang	24	26	24	32
7	Binh Duong	24	32	41	28
8	Thanh	24	27	27	28
9	Chí Minh	24	23	34	25
10	Da Nang	24	18	35	25
11	Hong Linh T.	24	26	33	24
12	Nam Dinh	24	21	33	23
13	Sai Gon	24	26	42	22

TEMPORADA 2020/2021

LIGA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Hoang	12	23	9	29
2	Viettel	12	16	9	26
3	Quang Ninh	12	12	11	19
4	Nam Dinh	12	23	21	18
5	Thanh	12	18	15	17
6	Binh Duong	12	14	17	17
7	Ha Noi FC	12	17	14	16
8	Binh Dinh	12	10	9	16
9	Da Nang	12	11	11	16
10	Hong Linh T.	12	16	17	15
11	Chí Minh	12	14	17	14
12	Hai Phong	12	7	15	14
13	Sai Gon	12	6	14	13
14	Song Nghe	12	7	15	10

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

SEGUNDA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Nam Dinh	12	17	14	23
2	Bong	12	21	10	20
3	Bình	12	11	12	19
4	Viettel	12	15	9	18
5	Dak Lak	12	14	18	15
6	Mang Ninh	12	13	20	11
7	Dong Thap	12	15	23	7

TEMPORADA 2015/2016

SEGUNDA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Chí Minh	18	39	15	39
2	Viettel	18	31	12	32
3	Nam Dinh	18	25	15	32
4	Dong Nai	18	24	17	30
5	Mang Ninh	18	23	25	25
6	Dak Lak	18	31	30	23
7	Bong	18	29	26	22
8	Bình	18	29	36	16
9	Phu Yen	18	20	41	16
10	CA Mau	18	13	47	8

TEMPORADA 2014/2015

SEGUNDA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Sai Gon	14	21	8	28
2	Chí Minh	14	19	13	24
3	Huda Hue	14	16	10	24
4	Nam Dinh	14	13	18	18
5	Dak Lak	14	13	19	16
6	Phu Yen	14	16	19	15
7	Bình	14	19	25	15
8	Công Nhân	14	12	17	13

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

LIGA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Ha Noi FC	26	35	25	46
2	Hai Phong	26	41	34	45
3	Dong Thap	26	43	34	44
4	Long An	26	43	31	43
5	Khatoco	26	42	42	43
6	Da Nang	26	41	44	40
7	Hoang	26	34	27	39
8	Song Nghe	26	36	26	37
9	Binh Duong	26	48	40	37
10	Hoa Phat	26	41	44	36
11	Vissai Ninh	26	33	34	34
12	Thanh	26	36	46	31
13	Navibank	26	21	39	20
14	Nam Dinh	26	19	47	12

TEMPORADA 2008/2009

LIGA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Da Nang	26	48	30	50
2	Binh Duong	26	49	35	43
3	Song Nghe	26	39	28	43
4	Ha Noi FC	26	44	35	39
5	Dong Thap	26	43	30	38
6	Hoang	26	44	45	37
7	Hai Phong	26	29	35	36
8	Khatoco	26	36	35	35
9	The Cong	26	40	46	35
10	Long An	26	43	37	34
11	Navibank	26	35	44	33
12	Nam Dinh	26	32	36	31
13	Chí Minh	26	34	44	29
14	Thanh	26	32	68	19

TEMPORADA 2007/2008

LIGA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Binh Duong	26	32	18	47
2	Long An	26	51	37	45
3	Hai Phong	26	47	25	44
4	Da Nang	26	44	34	42
5	Khatoco	26	34	29	39
6	Hoang	26	36	35	39
7	Chí Minh	26	35	35	39
8	The Cong	26	28	28	38
9	Song Nghe	26	46	35	36
10	Thanh	26	25	32	33
11	Nam Dinh	26	24	32	31
12	Binh Dinh	26	31	48	28
13	Sai Gon	26	26	48	19
14	Hoa Phat	26	21	44	15

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

TEMPORADA 2005/2006

LIGA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Long An	24	38	32	40
2	Binh Duong	24	33	25	39
3	Binh Dinh	24	32	22	36
4	Hoang	24	24	21	36
5	Song Nghe	24	27	27	36
6	Khatoco	24	30	25	35
7	Da Nang	24	32	27	34
8	Sai Gon	24	28	31	33
9	Nam Dinh	24	22	28	32
10	Cang	24	35	38	29
11	Hoa Phat	24	30	41	27
12	Hai Phong	24	31	36	24
13	Tien Giang	24	17	26	23

TEMPORADA 2004/2005

LIGA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Long An	22	43	25	42
2	Da Nang	22	33	19	38
3	Binh Duong	22	40	32	38
4	Hoang	22	30	24	32
5	Song Nghe	22	33	28	31
6	Nam Dinh	22	27	31	28
7	Hai Phong	22	31	34	27
8	Cang	22	26	30	27
9	Binh Dinh	22	17	21	25
10	Hoa Phat	22	24	29	25
11	Sai Gon	22	18	27	24
12	Dong Thap	22	18	40	15

TEMPORADA 2003/2004

LIGA VIETNAM
Equipo		PJ	GF	GC	Puntos
1	Hoang	22	40	15	46
2	Nam Dinh	22	30	23	44
3	Long An	22	41	33	38
4	Song Nghe	22	38	17	37
5	Ha Noi ACB	22	30	26	36
6	Binh Duong	22	24	24	28
7	Binh Dinh	22	22	30	27
8	Dong Thap	22	23	29	25
9	Da Nang	22	27	28	24
10	Hai Phong	22	22	37	22
11	The Cong	22	20	39	20
12	Ngan Hang D.	22	22	38	18

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,709,592 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1530
Total Execution Time	0.1544

CADENA URL

/historico/Nam-Dinh

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (48)

0.0029	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 = 'Nam-Dinh' 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.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=60368 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=60368 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=60368 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023	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=60368 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041	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.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 = 74252
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60368 AND type_rel = 2
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=401 AND type_rel = 3
0.0020	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.0021	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.0029	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 = '60368' ORDER BY l.year DESC,cat.coefficient DESC
0.0033	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 = '60368' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '60368' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 74252 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 74227 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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=60368 AND l.year in (2023,2024,2025) 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 (74252,74227,71432) 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.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 74227 AND teamId = 60368
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 74252 AND teamId = 60368
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 60368
0.0020	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '60368' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60368' 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 = '60368' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034	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 = 60368 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.0027	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 = 60368 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74227 WHERE rp.league_id = 74227 AND rp.teamId = 60368 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	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 = 60368 AND l.year <= 2024 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* `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.0021	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 70846 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.0020	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72529 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `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 = 66818 AND t.round = 26 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 = 60876 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.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 = 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.0020	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.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* `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.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* `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.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* `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 = 38068 AND t.round = 14 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 = 22223 AND t.round = 18 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* `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 = 11807 AND t.round = 14 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 = 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.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* `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 = 9819 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* `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 = 9820 AND t.round = 26 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* `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 = 9821 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* `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.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* `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 = 16202 AND t.round = 26 ORDER BY team.conference 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* `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 = 16203 AND t.round = 22 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* `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 = 23828 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Nam Dinh

Nam Dinh

Selecciona un equipo

Competiciones que juega

Liga Vietnam

RIVALES EN Copa Vietnam

RIVALES EN Liga Vietnam