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

Chinato

Temporada 2023/2024

TEMPORADA 2023/2024

1ª REGIONAL EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Chinato	22	53	22	44
2	Amanecer	22	29	18	39
3	Ciudad	22	30	22	37
4	Moraleja	22	38	30	36
5	Malpartida	22	35	26	34
6	Talayuela	22	33	24	34
7	Casar	22	28	36	29
8	Torreorgaz	22	34	34	29
9	Plasencia	22	28	31	28
10	Valdefuentes	22	33	42	23
11	Moralo B	22	27	43	22
12	Torrejoncill	22	14	54	6

TEMPORADA 2022/2023

1ª REGIONAL EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CF Jaraíz	22	49	13	53
2	Moraleja	22	39	34	42
3	Moralo B	22	41	26	39
4	Amanecer	22	34	23	35
5	Chinato	22	32	33	35
6	Talayuela	22	29	21	31
7	Malpartida	22	26	23	27
8	Casar	22	21	31	24
9	Ciudad	22	22	37	23
10	Cacereño B	22	23	33	20
11	Valdefuentes	22	24	49	17
12	Puente	22	14	31	15

TEMPORADA 2021/2022

1ª REGIONAL EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Montehermoso	22	50	11	49
2	Moraleja	22	56	19	45
3	CF Jaraíz	22	44	14	44
4	Amanecer	22	39	25	42
5	Talayuela	22	29	18	41
6	CF Caceres	22	34	24	31
7	Chinato	22	28	30	30
8	Valdefuentes	22	35	40	26
9	Ciudad	22	25	42	24
10	Malpartida	22	22	40	17
11	Piornal	22	19	60	15
12	Cabezuela	22	15	73	8

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	UD Montijo	20	34	5	49
2	CD Coria	20	36	14	45
3	Moralo	20	28	9	42
4	Extremadura	20	28	17	32
5	Plasencia	20	27	14	30
6	Aceuchal	20	22	25	26
7	Calamonte	20	23	25	23
8	Chinato	20	17	32	15
9	Campanario	20	13	35	15
10	CP Valdivia	20	14	44	13
11	AD Lobón	20	10	32	12
12	Cacereño	20	43	9	50
13	Diocesano	20	37	12	44
14	Jerez	20	23	16	36
15	Miajadas	20	21	19	28
16	Arroyo	20	15	24	25
17	CD Azuaga	20	18	25	23
18	Llerenense	20	14	26	22
19	Trujillo	20	25	28	19
20	Racing	20	13	33	19
21	Olivenza	20	20	26	18
22	Fuente	20	18	29	16

TEMPORADA 2019/2020

1ª REGIONAL EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Chinato	25	47	24	57
2	Amanecer	25	55	17	50
3	Montehermoso	25	38	29	48
4	Serván	25	49	40	46
5	Álvaro	25	61	38	44
6	Valdefuentes	25	68	39	43
7	Guareña	25	48	40	38
8	Malpartida	24	39	30	37
9	Talayuela	24	44	38	34
10	Moraleja	24	47	42	33
11	CF Jaraíz	24	34	45	29
12	Calamonte	25	37	51	28
13	Atlético	24	29	55	19
14	Hurdes	25	32	64	19
15	CD Zarceño	25	33	74	17
16	Piornal	24	16	51	16

TEMPORADA 2018/2019

1ª REGIONAL EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Trujillo	30	74	23	74
2	Montehermoso	30	42	18	62
3	Miajadas	30	51	19	60
4	Amanecer	30	60	29	59
5	Chinato	30	56	28	59
6	Santa Amalia	30	70	52	58
7	Talayuela	29	53	22	56
8	Malpartida	30	53	46	43
9	Olympic	30	33	46	34
10	Piornal	30	32	63	34
11	Hernán	30	39	48	30
12	Moraleja	30	44	62	30
13	Valdefuentes	30	46	67	23
14	Jorge	29	50	82	23
15	Hurdes	30	26	70	12
16	Ciudad	30	25	79	9

TEMPORADA 2017/2018

1ª REGIONAL EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Montehermoso	30	58	12	71
2	Miajadas	30	61	23	65
3	Chinato	30	47	26	54
4	Hernán	30	42	26	51
5	Moraleja	30	41	36	49
6	Talayuela	30	59	53	42
7	Álvaro	30	52	53	40
8	Hurdes	30	47	46	38
9	Olympic	30	54	56	38
10	Ciudad	30	36	45	38
11	Malpartida	30	46	51	35
12	Jorge	30	51	57	35
13	Piornal	30	37	55	33
14	Torviscal	30	42	60	31
15	Emérita	30	44	60	26
16	Plus Ultra	30	33	91	16

TEMPORADA 2016/2017

1ª REGIONAL EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Trujillo	30	66	21	72
2	Montehermoso	30	86	33	70
3	Diocesano	30	83	28	69
4	Ciudad	30	60	32	58
5	Miajadas	30	52	30	55
6	Hernán	30	41	42	46
7	Chinato	30	47	33	44
8	Talayuela	30	51	51	40
9	Jorge	30	54	62	37
10	Hurdes	29	33	46	37
11	Olympic	30	45	58	33
12	Plus Ultra	30	51	59	32
13	Moraleja	30	30	69	28
14	CF Jaraíz	29	32	73	21
15	Amanecer B	30	31	72	19
16	Navalmoral	30	38	91	15

TEMPORADA 2015/2016

PREFERENTE EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Plasencia	30	84	29	69
2	Trujillo	30	59	25	66
3	Diocesano	30	57	35	59
4	Ciudad	30	45	29	55
5	Serván	30	54	32	52
6	Miajadas	30	61	35	49
7	Jorge	30	59	48	45
8	Arroyo Cp B	30	48	37	45
9	Montehermoso	30	33	47	38
10	Talayuela	30	35	51	37
11	Hurdes	30	42	62	34
12	Chinato	30	40	55	31
13	Alburquerque	30	31	54	29
14	CF Jaraíz	30	34	63	27
15	Navalmoral	30	34	60	27
16	Ciconia	30	26	80	12

TEMPORADA 2014/2015

PREFERENTE EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Amanecer	30	66	15	75
2	Calamonte	30	83	20	63
3	Cacereño B	30	67	37	61
4	Diocesano	30	57	32	51
5	Jorge	30	60	57	43
6	Navalmoral	30	36	44	42
7	Talayuela	30	47	44	41
8	Arroyo Cp B	30	39	38	40
9	Ciudad	30	29	33	38
10	Chinato	30	42	57	37
11	Montehermoso	30	39	51	35
12	Ciconia	30	34	48	33
13	Trujillo	30	36	60	28
14	Miajadas	30	33	60	27
15	Moraleja	30	30	58	24
16	Malpartida	30	22	66	19

TEMPORADA 2013/2014

PREFERENTE EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sanvicenteñ	30	69	20	74
2	Moralo	30	80	21	71
3	Malpartida	30	55	26	64
4	Alburquerque	30	63	27	62
5	Talayuela	30	61	30	58
6	Arroyo Cp B	30	48	26	55
7	Moraleja	30	32	38	36
8	Montehermoso	30	40	55	36
9	Diocesano	30	46	45	35
10	Amanecer	30	30	56	30
11	Trujillo	30	41	60	30
12	Ciconia	30	30	58	29
13	Hurdes	30	29	67	27
14	Chinato	30	27	50	24
15	Casar	30	31	56	21
16	Valdefuentes	30	20	67	21

TEMPORADA 2012/2013

PREFERENTE EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sanvicenteñ	30	82	21	71
2	Diocesano	30	67	35	64
3	Malpartida	30	61	28	60
4	Montehermoso	30	50	30	59
5	Alburquerque	30	66	30	58
6	Casar	30	54	30	58
7	Arroyo Cp B	30	57	45	41
8	Valdefuentes	30	39	46	38
9	Trujillo	30	38	49	37
10	Cp Amanecer	30	40	51	36
11	Chinato	30	41	53	34
12	Ciconia	30	34	72	29
13	Moralo B	30	35	48	28
14	CF Jaraíz	30	35	74	22
15	CD Coria B	30	31	63	20
16	Talayuela	30	31	86	12

TEMPORADA 2011/2012

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Arroyo	38	100	22	95
2	Diter Zafra	38	63	38	81
3	Extremadura	38	75	23	78
4	Benito	38	63	29	78
5	Jerez	38	56	34	69
6	Miajadas	38	52	52	56
7	Deportivo	38	53	49	53
8	Mérida UD	38	42	43	53
9	CD Coria	38	49	55	50
10	Ciudad	38	45	46	45
11	Valdelacalza	38	31	42	45
12	Plasencia	38	41	62	45
13	Santa Amalia	38	53	67	44
14	Hernán	38	28	39	42
15	Pueblonuevo	38	59	83	41
16	Moralo	38	32	43	40
17	José	38	60	67	39
18	Sanvicenteñ	38	45	77	36
19	Villafranca	38	45	74	29
20	Chinato	38	27	74	20

TEMPORADA 2010/2011

PREFERENTE EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Hernán	38	74	27	81
2	Chinato	38	80	32	78
3	Roque	38	73	39	76
4	Castuera	38	74	39	74
5	Cacereño B	38	75	39	73
6	CP Valdivia	38	55	40	73
7	Malpartida	38	60	39	71
8	Montehermoso	38	63	47	66
9	Trujillo	38	70	66	56
10	Navalmoral	38	45	58	53
11	CD Coria B	38	60	61	52
12	Orellana	38	54	54	49
13	Amanecer	38	41	63	40
14	Olympic	38	51	58	39
15	Campanario	38	57	85	39
16	Moraleja	38	44	59	38
17	San Benito	38	50	72	36
18	Ciudad	38	31	71	30
19	Cumbre	38	33	95	25
20	Guareña	38	38	84	20

TEMPORADA 2009/2010

PREFERENTE EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Plasencia	38	119	29	96
2	Santa Amalia	38	89	27	89
3	Cacereño B	38	83	43	78
4	Castuera	38	71	41	76
5	Ciudad	38	74	37	67
6	CP Valdivia	38	67	39	66
7	Hernán	38	54	46	65
8	Orellana	38	59	49	59
9	Gimnástico	38	66	56	55
10	Moraleja	38	64	59	52
11	Chinato	38	56	61	51
12	Amanecer	38	50	60	49
13	Sagrada Cena	38	67	83	45
14	Navalmoral	38	45	58	42
15	Malpartida	38	38	52	42
16	Olympic	38	41	69	39
17	Trujillo	38	56	85	39
18	Talayuela	38	64	114	32
19	Torviscal	38	49	122	20
20	Gargáligas	38	26	108	13

TEMPORADA 2008/2009

PREFERENTE EXTREMADURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Coria	38	124	44	88
2	Montehermoso	38	84	33	84
3	Arroyo	38	105	45	78
4	Ciudad	38	72	33	75
5	Amanecer	38	59	39	69
6	Castuera	38	74	57	62
7	Gimnástico	37	57	39	61
8	Trujillo	38	66	60	55
9	Hernán	38	54	54	52
10	Sagrada Cena	38	72	74	51
11	Chinato	38	61	74	50
12	Talayuela	38	45	74	45
13	Moraleja	38	56	74	44
14	Santa Amalia	38	55	66	43
15	Gargáligas	38	51	76	41
16	Orellana	37	44	69	39
17	Malpartida	38	43	68	39
18	Ciudad	38	48	82	34
19	Zurbarán	38	46	81	33
20	Brocense	38	21	95	19

Competiciones que juega

RIVALES EN 1ª Regional Extr.

USO DE MEMORIA

6,683,528 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.6308
Total Execution Time	0.6328

CADENA URL

/historico/Chinato

GET DATOS

$_GET['/historico/Chinato']

POST DATOS

No hay datos POST existentes

CONSULTAS (37)

0.0175	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 = 'Chinato' 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.0133	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=763 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=763 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=763 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0256	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 = 75916
0.0126	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=763 AND type_rel = 2
0.0135	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 = '763' ORDER BY l.year DESC,cat.coefficient DESC
0.0137	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 = '763' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0150	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 = '763' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135	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 = 75916 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146	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=763 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0131	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 (75916,67320) 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.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 75916 AND teamId = 763
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 763
0.0128	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 = 75916 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0129	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 = '763' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '763' and rp.type = 4
0.0135	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 = '763' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139	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 = 75916 WHERE rp.league_id = 75916 AND rp.teamId = 763 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.0136	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 = 75916 WHERE rp.league_id = 75916 AND rp.teamId = 763 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140	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 = 75916 WHERE rp.league_id = 75916 AND rp.teamId = 763 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157	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 = 763 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0136	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 = 68800 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.0171	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 = 63716 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.0129	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 = 58593 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.0130	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 = 51306 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 44628 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 39344 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 34427 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 16716 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 4099 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 2689 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 2200 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 1450 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138	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 = 1245 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 951 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 296 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Chinato

Chinato

Selecciona un equipo

Competiciones que juega

RIVALES EN 1ª Regional Extr.