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.

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

Chainat Hornbill

Temporada 2023/2024

TEMPORADA 2023/2024

THAI LEAGUE 2
Equipo		PJ	GF	GC	Puntos
1	Nakhon	34	64	27	73
2	Nong	34	80	39	72
3	Rayong FC	34	62	34	60
4	Chiangmai	34	55	34	59
5	Nakhon	34	60	40	59
6	Ayutthaya	34	52	36	57
7	Pattaya	34	45	36	55
8	Lampang	34	50	41	54
9	Chiangmai	34	52	41	49
10	Suphanburi	34	36	41	43
11	Chanthaburi	34	44	44	40
12	Phrae United	34	37	53	40
13	Kanchanaburi	34	43	52	38
14	Chainat	34	32	46	37
15	Samut Prakan	34	39	57	35
16	Kasetsart	34	31	84	22
17	Customs	34	26	63	21
18	Krabi	34	23	63	20

TEMPORADA 2022/2023

THAI LEAGUE 2
Equipo		PJ	GF	GC	Puntos
1	Nakhon	34	32	20	60
2	Trat FC	34	55	34	60
3	Uthai Thani	34	70	36	59
4	Customs	34	45	31	58
5	Chiangmai	34	36	32	54
6	Suphanburi	34	36	35	52
7	Rayong FC	34	41	30	52
8	Nakhon	34	48	42	51
9	Phrae United	34	50	43	51
10	Ayutthaya	34	50	43	51
11	Chiangmai	34	49	41	46
12	Krabi	34	46	46	42
13	Chainat	34	44	48	41
14	Kasetsart	34	35	42	37
15	Samut Prakan	34	32	42	37
16	Raj Pracha	34	29	41	37
17	Ranong	34	28	64	27
18	Udon Thani	34	31	87	21

TEMPORADA 2021/2022

THAI LEAGUE 2
Equipo		PJ	GF	GC	Puntos
1	Lamphun	34	66	30	74
2	Sukhothai	34	78	44	73
3	Trat FC	34	55	33	68
4	Lampang	34	67	38	57
5	Chainat	34	58	46	57
6	Phrae United	34	51	35	54
7	Muangkan	34	70	62	52
8	Udon Thani	34	53	58	47
9	Rayong FC	34	45	41	46
10	Nakhon	34	42	47	42
11	Ayutthaya	34	40	50	41
12	Ranong	34	35	45	41
13	Kasetsart	34	32	47	39
14	Chiangmai	34	39	55	38
15	Customs	34	44	63	35
16	Raj Pracha	34	34	44	33
17	Khonkaen	34	32	60	24
18	Siam Navy	34	28	71	11

TEMPORADA 2019/2020

THAI LEAGUE 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Nong	30	56	13	67
2	Chiangmai	30	57	25	63
3	Nakhon	30	61	31	55
4	Chainat	30	55	39	50
5	Phrae United	30	40	24	50
6	Chiangmai	30	46	40	49
7	Khon Kaen U.	30	43	33	48
8	Ranong	30	39	38	45
9	Ayutthaya	30	39	40	40
10	Khonkaen	30	32	33	40
11	Siam Navy	30	43	47	36
12	Sisaket	30	34	38	36
13	Customs	30	34	55	36
14	Kasetsart	30	30	46	34
15	Lampang	30	35	41	33
16	Udon Thani	30	39	42	31
17	Uthai Thani	30	31	41	24
18	Samut Sakhon	30	22	110	8

TEMPORADA 2018/2019

THAI LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Chiangrai	30	53	28	58
2	Buriram	30	51	25	58
3	Port FC	30	55	36	53
4	Bangkok	30	55	32	50
5	Muang Thong	30	45	42	46
6	Samut Prakan	30	44	50	43
7	Chonburi	30	43	45	40
8	Ratchaburi	30	48	48	38
9	Prachuap	30	32	44	37
10	Trat FC	30	47	47	35
11	PTT Rayong	30	33	46	35
12	Sukhothai	30	37	37	34
13	Nakhon	30	45	51	34
14	Suphanburi	30	29	44	32
15	Chainat	30	31	50	30
16	Chiangmai	30	39	62	28

TEMPORADA 2017/2018

THAI LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Buriram	34	76	25	87
2	Bangkok	34	68	36	71
3	Port FC	34	73	45	61
4	Muang Thong	34	65	53	59
5	Chiangrai	34	52	36	55
6	Prachuap	34	56	46	53
7	Nakhon	34	36	44	47
8	Samut Prakan	34	50	62	46
9	Chonburi	34	45	53	46
10	Suphanburi	34	43	35	46
11	Sukhothai	34	53	63	43
12	Ratchaburi	34	50	53	43
13	Chainat	34	46	52	42
14	Pathum	34	55	46	42
15	Police Tero	34	53	66	36
16	Siam Navy	34	44	85	30
17	Ubon UMT	34	39	58	26
18	Force	34	32	78	16

TEMPORADA 2016/2017

THAI LEAGUE 2
Equipo		PJ	GF	GC	Puntos
1	Chainat	32	64	40	67
2	Force	32	61	40	62
3	Prachuap	32	58	40	59
4	Ang Thong	32	65	46	53
5	PTT Rayong	32	54	50	50
6	Lampang	32	45	47	47
7	Nakhon	32	43	38	42
8	Nong	32	45	47	41
9	Royal Thai.	32	53	57	39
10	Chiangmai	32	46	52	39
11	Krabi	32	50	62	38
12	Rayong FC	32	55	56	38
13	Trat FC	32	49	59	37
14	Kasetsart	32	61	72	37
15	Samut	32	42	57	35
16	Songkhla	32	38	49	34
17	Bangkok	32	47	64	29
18	BBCU	0	0	0	0

TEMPORADA 2015/2016

THAI LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Muang Thong	31	73	24	80
2	Bangkok	31	71	36	75
3	Pathum	31	62	41	57
4	Buriram	30	55	38	55
5	Chonburi	31	52	33	51
6	Ratchaburi	30	52	35	49
7	Sukhothai	31	50	44	45
8	Chiangrai	31	42	43	45
9	Police Tero	30	42	52	41
10	Suphanburi	31	33	35	38
11	Nakhon	31	30	44	35
12	Samut Prakan	31	46	66	34
13	Sisaket	31	41	52	33
14	Siam Navy	31	24	40	31
15	Super Power	31	45	71	31
16	Royal Thai.	31	34	46	30
17	Chainat	31	46	61	30
18	BBCU	30	32	69	13

TEMPORADA 2014/2015

THAI LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Buriram	34	98	24	84
2	Muang Thong	34	81	35	71
3	Suphanburi	34	60	39	59
4	Chonburi	34	62	44	57
5	Bangkok	34	59	47	57
6	Pathum	34	47	38	56
7	Ratchaburi	34	48	50	55
8	Nakhon	34	37	43	49
9	Chiangrai	34	42	57	44
10	Royal Thai.	34	43	47	41
11	Super Power	34	40	54	39
12	Chainat	34	42	53	37
13	Sisaket	34	30	47	36
14	Police Tero	34	42	51	35
15	Saraburi	34	41	56	35
16	Siam Navy	34	42	65	35
17	Port FC	34	31	49	33
18	TOT	34	25	71	16

TEMPORADA 2013/2014

THAI LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Buriram	38	69	26	79
2	Chonburi	38	62	33	76
3	Police Tero	38	66	41	68
4	Ratchaburi	38	62	42	65
5	Muang Thong	38	66	36	62
6	Suphanburi	38	55	49	59
7	Chiangrai	38	55	47	55
8	Bangkok	38	55	56	54
9	Royal Thai.	38	52	55	53
10	Pathum	38	70	65	49
11	Super Power	38	53	49	48
12	Sisaket	38	48	59	46
13	Port FC	38	44	52	45
14	Chainat	38	43	50	44
15	TOT	38	38	51	43
16	Police	38	58	64	43
17	PTT Rayong	38	49	60	42
18	Songkhla	38	39	72	32
19	Force	38	35	63	30
20	Samut	38	32	81	19

TEMPORADA 2012/2013

THAI LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Buriram	32	73	23	78
2	Muang Thong	32	61	33	71
3	Chonburi	32	61	35	62
4	Suphanburi	32	40	31	51
5	Pathum	32	40	31	50
6	Royal Thai.	32	48	40	48
7	Police Tero	32	56	49	48
8	Super Power	32	38	43	39
9	Police	32	40	37	38
10	Chainat	32	42	43	38
11	Chiangrai	32	32	45	34
12	Songkhla	32	30	47	32
13	Bangkok	32	38	61	31
14	TOT	32	27	54	31
15	Ratchaburi	32	31	39	30
16	Samut	32	22	41	30
17	Samut Prakan	32	39	66	29
18	Sisaket	0	0	0	0

TEMPORADA 2011/2012

THAI LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Muang Thong	34	78	31	84
2	Chonburi	34	65	33	70
3	Police Tero	34	53	43	57
4	Buriram	34	60	40	54
5	Super Power	34	55	48	52
6	Sisaket	34	41	42	47
7	Samut	34	37	39	46
8	Pathum	34	53	39	45
9	Chiangrai	34	40	47	44
10	Royal Thai.	34	34	38	43
11	Police	34	37	38	42
12	TOT	34	43	46	42
13	Songkhla	34	46	54	41
14	Chainat	34	59	72	39
15	Samut Prakan	34	35	47	37
16	Port FC	34	32	48	33
17	BBCU	34	32	63	25
18	TTM Lopburi	34	25	57	18

TEMPORADA 2010/2011

THAI LEAGUE 2
Equipo		PJ	GF	GC	Puntos
1	Songkhla	34	84	18	83
2	Chainat	34	68	42	66
3	BBCU	34	39	25	63
4	PTT Rayong	34	54	28	59
5	Songkhala	34	54	39	56
6	Bangkok	34	54	49	51
7	Saraburi	34	41	31	50
8	Raj Pracha	34	40	54	46
9	Phuket	34	45	47	45
10	Suphanburi	34	40	37	44
11	Bangkok	34	56	63	42
12	Chanthaburi	34	39	48	41
13	Rangsit JW	34	31	42	40
14	Force	34	36	53	40
15	Customs	34	41	55	36
16	Chiangmai	34	36	55	30
17	RBAC	34	25	61	25
18	Thai Honda	34	33	69	24

Competiciones que juega

Thai League 2

Pos	Equipos		Pts
1		Nakhon Ratchasima	73
2		Nong Bua Pitchaya	72
3		Rayong FC	60
4		Chiangmai	59
5		Nakhon Si United	59
6		Ayutthaya United	57
7		Pattaya Dolphins	55
8		Lampang	54
9		Chiangmai Utd	49
10		Suphanburi	43
11		Chanthaburi	40
12		Phrae United	40
13		Kanchanaburi	38
14		Chainat Hornbill	37
15		Samut Prakan City	35
16		Kasetsart	22
17		Customs Ladkrabang	21
18		Krabi	20

	Ascenso : Nakhon Ratchasima, Nong Bua Pitchaya
	Playoff Ascenso : Rayong FC, Chiangmai, Nakhon Si United, Ayutthaya United
	Descenso : Kasetsart, Customs Ladkrabang, Krabi

RIVALES EN Thai League 2

USO DE MEMORIA

6,816,992 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1141
Total Execution Time	0.1154

CADENA URL

/historico/Chainat-Fc

GET DATOS

$_GET['/historico/Chainat-Fc']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13509 AND type_rel = 2
0.0019	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13509 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	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 (177906,313969,578181,830707) ORDER BY n.cover_points DESC, update_date DESC
0.0025	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 = '13509' 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 = '13509' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023	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=13509 AND l.year in (2023,2024,2025) 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 (73186,71432,69562,68820) 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 = 73186 AND teamId = 13509
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 69562 AND teamId = 13509
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 68820 AND teamId = 13509
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13509
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 = '13509' 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 = '13509' 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 = '13509' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0049	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 = 73186 WHERE rp.league_id = 73186 AND rp.teamId = 13509 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 events2024 e ON e.player_id = p.id AND e.league_id = 73186 WHERE rp.league_id = 73186 AND rp.teamId = 13509 AND (e.action = 4 or e.action = 5) 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 = 73186 WHERE rp.league_id = 73186 AND rp.teamId = 13509 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 = 13509 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0038	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 = 68168 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.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* `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 = 64197 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.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* `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 = 55278 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* `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 = 48753 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* `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 = 42548 AND t.round = 34 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 = 37900 AND t.round = 34 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 = 20616 AND t.round = 34 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* `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 = 9514 AND t.round = 34 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* `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 = 3568 AND t.round = 38 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* `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 = 2879 AND t.round = 34 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* `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 = 8673 AND t.round = 34 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 = 16116 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Chainat Hornbill

Chainat Hornbill

Selecciona un equipo

Competiciones que juega

Thai League 2

RIVALES EN Thai League 2