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

Rangers Talca

Temporada 2018/2019

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 B CHILE - CLAUSURA FASE 2
Equipo		PJ	GF	GC	Puntos
1	Luis	13	18	8	30
2	Unión	13	29	18	23
3	CDSC Iberia	13	17	11	23
4	Concepción	13	17	16	23
5	Everton	13	13	11	22
6	Deportes	13	15	18	20
7	Santiago	13	20	12	18
8	Coquimbo	13	24	21	17
9	Deportes	13	14	17	16
10	La Serena	13	14	19	16
11	Lota	13	14	14	15
12	Rangers	13	12	13	15
13	Magallanes	13	4	18	6
14	Curicó	13	9	24	6

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 CHILE - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Colo-Colo	17	32	14	33
2	Univ Chile	17	32	20	33
3	Rangers	17	27	19	30
4	Palestino	17	22	18	30
5	Deportes	17	24	27	30
6	Huachipato	17	23	21	25
7	Unión	17	28	28	24
8	Audax	17	29	26	23
9	Católica	17	24	23	23
10	Cobresal	17	22	24	22
11	Unión	17	19	21	21
12	Cobreloa	17	23	24	20
13	Antofagasta	17	26	29	20
14	O'Higgins	17	22	27	20
15	Santiago	17	27	28	19
16	Unión	17	11	18	15
17	Univ.	17	17	28	15
18	La Serena	17	20	33	12

TEMPORADA 2010/2011

PRIMERA B CHILE - APERTURA FASE 1
Equipo		PJ	GF	GC	Puntos
1	Coquimbo	6	9	6	11
2	Everton	6	9	5	10
3	Antofagasta	6	5	8	10
4	Deportes	6	5	5	9
5	Luis	6	6	4	8
6	Magallanes	6	7	9	7
7	Marcos Arica	6	9	13	4
8	Rangers	6	9	3	15
9	Concepción	6	8	4	12
10	Naval	6	7	6	10
11	Unión	6	6	6	7
12	Curicó	6	6	10	7
13	Puerto Montt	6	5	8	5
14	Lota	6	2	6	4

Competiciones que juega

Primera B Chile

Pos	Equipos		Pts
1		Santiago Wanderers	46
2		La Serena	43
3		Ñublense	42
4		Barnechea	40
5		Cobreloa	39
6		CD Melipilla	39
7		Unión San Felipe	39
8		Deportes Temuco	38
9		Deportes Copiapó	38
10		Puerto Montt	37
11		Deportes Santa Cruz	37
12		Santiago Morning	34
13		Rangers Talca	28
14		San Luis de Quillota	27
15		Magallanes	25
16		Deportes Valdivia	19

	Ascenso : Santiago Wanderers
	Playoff Ascenso : La Serena, Ñublense, Barnechea, Cobreloa, CD Melipilla, Unión San Felipe, Deportes Temuco, Deportes Copiapó, Puerto Montt
	Descenso : Deportes Valdivia

RIVALES EN Copa Chile

RIVALES EN Primera B Chile

USO DE MEMORIA

6,195,544 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.1908
Total Execution Time	0.1919

CADENA URL

/historico/Csd-Rangers/2019

GET DATOS

$_GET['/historico/Csd-Rangers/2019']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0039	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 = 'Csd-Rangers' AND l.year = 2019 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.0019	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=9270 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=9270 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=9270 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0044	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 = 43355
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9270 AND type_rel = 2
0.0022	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9270 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0028	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 (2909,241993,274016,272767,652960) ORDER BY n.cover_points DESC, update_date DESC
0.0042	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 = '9270' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0073	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 = '9270' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0035	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 = 43355 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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 = 48775 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0048	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=9270 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0027	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 (61087,49506,49336) 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.0033	SELECT count(id) as num_players from rel_players WHERE league_id = 61087 AND teamId = 9270
0.0036	SELECT count(id) as num_players from rel_players WHERE league_id = 49336 AND teamId = 9270
0.0284	SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 9270
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024	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 = '9270' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9270' 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 = '9270' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0041	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 events2019 e ON e.player_id = p.id AND e.league_id = 48775 WHERE rp.league_id = 48775 AND rp.teamId = 9270 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.0038	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 events2019 e ON e.player_id = p.id AND e.league_id = 48775 WHERE rp.league_id = 48775 AND rp.teamId = 9270 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	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 events2019 e ON e.player_id = p.id AND e.league_id = 48775 WHERE rp.league_id = 48775 AND rp.teamId = 9270 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034	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 = 9270 AND l.year <= 2019 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* `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.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* `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.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 = 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.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 = 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.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* `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.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* `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.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* `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 = 9012 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* `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 = 4009 AND t.round = 7 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 = 4914 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 9280 AND t.round = 13 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 = 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 = 1558 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 = 1940 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* `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 = 24553 AND t.round = 13 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* `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 = 24565 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* `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 = 24573 AND t.round = 13 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* `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 = 24544 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 48775 ORDER BY nameShow LIMIT 100

Rangers Talca

Rangers Talca

Selecciona un equipo

Competiciones que juega

Primera B Chile

RIVALES EN Copa Chile

RIVALES EN Primera B Chile