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

Ñublense

Entrenador: Mario Salas

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA CHILE
Equipo		PJ	GF	GC	Puntos
1	Univ Chile	9	15	7	21
2	Palestino	9	14	4	18
3	Unión	10	22	17	17
4	Deportes	9	18	14	16
5	Coquimbo	9	11	8	15
6	Everton	9	15	15	14
7	O'Higgins	10	11	13	14
8	Colo-Colo	9	10	8	13
9	Católica	10	9	8	13
10	Cobreloa	9	10	15	13
11	Huachipato	9	7	9	12
12	Ñublense	9	13	14	11
13	Audax	9	9	13	8
14	Deportes	10	12	20	7
15	Cobresal	9	11	15	6
16	Unión	9	6	13	6

TEMPORADA 2022/2023

PRIMERA CHILE
Equipo		PJ	GF	GC	Puntos
1	Huachipato	30	48	30	57
2	Cobresal	30	56	39	56
3	Colo-Colo	30	45	29	54
4	Palestino	30	46	40	49
5	Coquimbo	30	43	42	47
6	Everton	30	42	39	45
7	Católica	30	48	43	42
8	Unión	30	42	41	41
9	Univ Chile	30	40	42	40
10	Unión	30	40	36	39
11	O'Higgins	30	37	39	35
12	Ñublense	30	33	39	35
13	Audax	30	36	43	35
14	Deportes	30	32	45	34
15	Magallanes	30	36	49	29
16	Curicó	30	30	58	23

TEMPORADA 2021/2022

PRIMERA CHILE
Equipo		PJ	GF	GC	Puntos
1	Colo-Colo	30	54	17	63
2	Ñublense	30	46	32	52
3	Curicó	30	48	30	49
4	Cobresal	30	44	39	45
5	Católica	30	41	38	45
6	Audax	30	44	42	45
7	O'Higgins	30	31	31	44
8	Palestino	29	42	35	43
9	Everton	30	40	27	42
10	Unión	30	36	40	39
11	Unión	30	37	44	37
12	Huachipato	30	32	46	35
13	Univ Chile	30	35	50	30
14	Coquimbo	30	32	52	27
15	La Serena	30	28	56	27
16	Antofagasta	29	23	34	26

TEMPORADA 2020/2021

PRIMERA CHILE
Equipo		PJ	GF	GC	Puntos
1	Católica	32	65	34	68
2	Colo-Colo	32	49	26	62
3	Audax	32	39	31	54
4	Unión	32	41	40	51
5	Unión	32	48	50	48
6	Antofagasta	32	34	36	47
7	Ñublense	32	49	37	44
8	Palestino	32	48	50	41
9	Cobresal	32	40	39	40
10	La Serena	32	40	42	39
11	Univ Chile	32	34	37	39
12	Everton	32	29	35	39
13	O'Higgins	32	31	41	38
14	Curicó	32	37	39	37
15	Huachipato	32	36	41	37
16	Melipilla	32	39	51	32
17	Santiago	32	24	54	21

TEMPORADA 2019/2020

PRIMERA B CHILE
Equipo		PJ	GF	GC	Puntos
1	Ñublense	28	51	33	50
2	Unión	28	37	25	46
3	Rangers	28	43	39	45
4	Puerto Montt	28	36	28	42
5	Melipilla	28	30	23	42
6	Deportes	28	35	34	41
7	Marcos Arica	28	27	29	41
8	Magallanes	28	31	25	40
9	Deportes	28	48	46	39
10	Cobreloa	28	37	33	36
11	Luis	28	31	35	33
12	Santiago	28	29	39	31
13	Barnechea	28	39	45	30
14	Deportes	28	34	48	28
15	Deportes	28	28	54	22

TEMPORADA 2018/2019

PRIMERA B CHILE
Equipo		PJ	GF	GC	Puntos
1	Santiago	27	40	26	46
2	La Serena	27	35	27	43
3	Ñublense	27	38	32	42
4	Barnechea	27	26	27	40
5	Cobreloa	26	40	33	39
6	Melipilla	26	33	26	39
7	Unión	27	30	30	39
8	Deportes	27	31	24	38
9	Deportes	26	28	21	38
10	Puerto Montt	27	36	29	37
11	Deportes	27	32	37	37
12	Santiago	26	26	32	34
13	Rangers	27	28	36	28
14	Luis	26	25	37	27
15	Magallanes	26	23	33	25
16	Deportes	27	30	51	19

TEMPORADA 2017/2018

PRIMERA B CHILE
Equipo		PJ	GF	GC	Puntos
1	Coquimbo	30	47	31	57
2	Cobreloa	30	43	31	52
3	Cobresal	30	44	30	51
4	Deportes	30	45	37	47
5	Santiago	30	41	43	46
6	Santiago	30	34	36	45
7	Unión	30	32	28	42
8	Rangers	30	33	34	40
9	Barnechea	30	38	38	39
10	Melipilla	30	39	41	39
11	Puerto Montt	30	31	33	35
12	La Serena	30	37	41	35
13	Magallanes	30	37	41	34
14	Deportes	30	36	44	34
15	Ñublense	30	27	35	33
16	Marcos Arica	30	28	49	32

TEMPORADA 2016/2017

PRIMERA B CHILE
Equipo		PJ	GF	GC	Puntos
1	Unión	15	25	11	34
2	Deportes	15	24	18	26
3	Cobreloa	15	30	28	23
4	Coquimbo	15	18	16	22
5	Barnechea	15	26	25	22
6	Magallanes	15	18	19	21
7	Puerto Montt	15	18	20	21
8	Cobresal	15	23	20	20
9	Unión	15	14	14	20
10	Marcos Arica	15	20	21	20
11	La Serena	15	20	20	19
12	Ñublense	15	11	13	18
13	CDSC Iberia	15	25	28	18
14	Santiago	15	17	23	17
15	Deportes	15	11	17	15
16	Rangers	15	14	21	13

TEMPORADA 2015/2016

PRIMERA B CHILE - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Curicó	15	35	15	33
2	Deportes	15	26	18	28
3	Concepción	15	23	16	27
4	Puerto Montt	15	23	20	26
5	Rangers	15	20	16	24
6	CDSC Iberia	15	21	13	23
7	Deportes	15	21	19	21
8	Coquimbo	15	30	30	20
9	Cobreloa	15	21	22	20
10	Unión	15	14	14	18
11	La Serena	15	21	24	18
12	Everton	15	17	20	16
13	Ñublense	15	16	25	16
14	Santiago	15	20	26	14
15	Magallanes	15	18	29	13
16	Barnechea	15	11	30	11

TEMPORADA 2014/2015

PRIMERA CHILE - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Cobresal	17	29	20	34
2	Colo-Colo	17	32	21	32
3	Huachipato	17	29	28	31
4	Católica	17	40	31	29
5	Unión	17	33	26	27
6	Univ.	17	27	26	27
7	Univ Chile	17	36	27	26
8	Marcos Arica	17	26	19	24
9	O'Higgins	17	21	23	24
10	Unión	17	20	23	23
11	Cobreloa	17	22	23	22
12	Audax	17	23	24	21
13	Deportes	17	27	30	21
14	Antofagasta	17	25	27	20
15	Ñublense	17	19	21	19
16	Palestino	17	26	34	19
17	Santiago	17	21	26	17
18	Barnechea	17	13	40	8

TEMPORADA 2013/2014

PRIMERA CHILE - APERTURA
Equipo		PJ	GF	GC	Puntos
1	Católica	17	37	13	39
2	O'Higgins	17	28	13	39
3	Unión	17	21	15	28
4	Univ Chile	17	31	16	27
5	Palestino	17	26	26	27
6	Deportes	17	22	21	26
7	Ñublense	17	28	28	24
8	Colo-Colo	17	22	23	24
9	Cobresal	17	18	25	24
10	Cobreloa	17	19	18	23
11	Antofagasta	17	18	22	23
12	Univ.	17	21	19	22
13	Santiago	17	20	25	21
14	Audax	17	23	25	17
15	Everton	17	16	29	16
16	Unión	17	15	24	15
17	Rangers	17	20	32	15
18	Huachipato	17	9	20	13

TEMPORADA 2012/2013

TORNEO DE TRANSICIÓN CHILE
Equipo		PJ	GF	GC	Puntos
1	Unión	17	32	12	38
2	Católica	17	36	19	38
3	Cobreloa	17	33	18	34
4	O'Higgins	17	28	19	31
5	Univ Chile	17	37	29	30
6	Everton	17	25	24	27
7	Unión	17	25	26	26
8	Rangers	17	25	22	24
9	Santiago	17	22	28	23
10	Colo-Colo	17	26	27	21
11	Palestino	17	20	23	20
12	Ñublense	17	20	26	20
13	Antofagasta	17	31	34	19
14	Audax	17	24	29	19
15	Huachipato	17	24	31	19
16	Deportes	17	14	25	13
17	Marcos Arica	17	19	34	12
18	Cobresal	17	22	37	11

TEMPORADA 2011/2012

PRIMERA B CHILE - APERTURA FASE 2
Equipo		PJ	GF	GC	Puntos
1	Ñublense	13	26	15	29
2	Marcos Arica	13	30	14	26
3	Unión	13	17	12	20
4	Everton	13	25	20	19
5	Barnechea	13	18	18	18
6	Lota	13	17	16	17
7	Magallanes	13	15	20	17
8	Concepción	13	16	13	16
9	Coquimbo	13	19	19	16
10	Luis	13	17	21	16
11	Puerto Montt	13	15	22	15
12	Santiago	13	18	24	14
13	Naval	13	15	22	11
14	Curicó	13	15	27	11

Competiciones que juega

Primera Chile

Pos	Equipos		Pts
1		Univ de Chile	21
2		Palestino	18
3		Unión Española	17
4		Deportes Iquique	16
5		Coquimbo Unido	15
6		Everton	14
7		O'Higgins	14
8		Colo-Colo	13
9		U. Católica	13
10		Cobreloa	13
11		Huachipato	12
12		Ñublense	11
13		Audax Italiano	8
14		Deportes Copiapó	7
15		Cobresal	6
16		Unión La Calera	6

	Copa Libertadores : Univ de Chile
	: Palestino, Unión Española
	: Deportes Iquique, Coquimbo Unido, Everton, O'Higgins
	Descenso : Cobresal, Unión La Calera

RIVALES EN Primera Chile

USO DE MEMORIA

6,596,944 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1309
Total Execution Time	0.1321

CADENA URL

/historico/Nublense

GET DATOS

$_GET['/historico/Nublense']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9135 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9135 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023	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 (4674,89057,89264,96512,452491) ORDER BY n.cover_points DESC, update_date DESC
0.0028	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 = '9135' 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 = 75067 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029	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=9135 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 (75067,72457,71432,71357,71182) 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.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 75067 AND teamId = 9135
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 71357 AND teamId = 9135
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 72457 AND teamId = 9135
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 71182 AND teamId = 9135
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9135
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 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 = 75067 AND t.round = 10 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0030	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 = 75067 WHERE rp.league_id = 75067 AND rp.teamId = 9135 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.0036	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 = 75067 WHERE rp.league_id = 75067 AND rp.teamId = 9135 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 75067 WHERE rp.league_id = 75067 AND rp.teamId = 9135 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 9135 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 75067 AND t.round = 10 ORDER BY team.conference ASC,t.position 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* `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 = 70762 AND t.round = 30 ORDER BY team.conference ASC,t.position 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* `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 = 66255 AND t.round = 30 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* `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 = 55380 AND t.round = 30 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 = 48775 AND t.round = 30 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* `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 = 42541 AND t.round = 30 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* `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 = 33434 AND t.round = 15 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* `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 = 36662 AND t.round = 15 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* `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 = 38842 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0053	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 = 15792 AND t.round = 15 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 = 20203 AND t.round = 15 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* `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 = 3898 AND t.round = 17 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 = 8950 AND t.round = 17 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* `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 = 2527 AND t.round = 17 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* `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 = 2528 AND t.round = 17 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* `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 = 9059 AND t.round = 17 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* `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 = 24561 AND t.round = 7 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* `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 = 24571 AND t.round = 13 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* `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 = 1880 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Ñublense

Ñublense

Selecciona un equipo

Competiciones que juega

Primera Chile

RIVALES EN Primera Chile