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

Resultados de Fútbol

Deportes Temuco

Temporada 2020/2021

TEMPORADA 2020/2021

PRIMERA B CHILE
Equipo		PJ	GF	GC	Puntos
1	Coquimbo	30	42	22	55
2	Deportes	30	49	36	52
3	Santiago	30	43	26	51
4	Deportes	30	44	28	49
5	Puerto Montt	30	34	30	48
6	Deportes	30	36	37	45
7	Magallanes	30	38	34	41
8	Deportes	30	52	45	40
9	Fernández	30	45	39	40
10	Luis	30	33	32	40
11	Unión	30	34	40	36
12	Rangers	30	34	42	35
13	Univ.	30	32	37	33
14	Cobreloa	30	35	41	33
15	Barnechea	30	28	44	24
16	Marcos Arica	30	14	60	16

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 CHILE
Equipo		PJ	GF	GC	Puntos
1	Católica	30	39	25	61
2	Univ.	30	45	31	58
3	Univ Chile	30	45	37	57
4	Antofagasta	30	48	33	53
5	Colo-Colo	30	40	38	43
6	Unión	30	38	38	43
7	Unión	30	44	42	41
8	O'Higgins	30	41	41	41
9	Huachipato	30	39	32	39
10	Audax	30	40	40	34
11	Everton	30	39	44	34
12	Curicó	30	35	40	34
13	Palestino	30	41	45	32
14	Deportes	30	34	42	32
15	Deportes	30	29	45	28
16	Luis	30	24	48	23

TEMPORADA 2016/2017

TORNEO DE TRANSICIÓN CHILE
Equipo		PJ	GF	GC	Puntos
1	Colo-Colo	15	33	13	33
2	Unión	15	18	12	31
3	Univ Chile	15	21	18	30
4	Everton	15	24	19	26
5	Audax	15	24	19	25
6	Deportes	15	15	12	22
7	Antofagasta	15	14	13	21
8	Curicó	15	11	14	18
9	Luis	15	15	20	18
10	Univ.	15	16	15	17
11	Católica	15	17	19	16
12	Huachipato	15	11	17	16
13	Santiago	15	16	17	15
14	O'Higgins	15	15	24	15
15	Palestino	15	18	24	13
16	Deportes	15	8	20	9

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 1 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Curicó	6	10	6	40
2	Deportes	6	10	6	38
3	Concepción	6	5	8	35
4	Santiago	6	5	11	31
5	CDSC Iberia	6	10	10	30
6	Rangers	6	7	4	28
7	Lota	6	6	8	16

TEMPORADA 2013/2014

PRIMERA B CHILE - CLAUSURA FASE 2
Equipo		PJ	GF	GC	Puntos
1	Marcos Arica	13	21	8	28
2	Coquimbo	13	21	14	28
3	Lota	13	10	8	21
4	Deportes	13	16	17	21
5	La Serena	13	17	16	19
6	Curicó	13	14	13	19
7	Barnechea	13	15	10	18
8	Magallanes	13	21	22	16
9	Santiago	13	13	17	15
10	Naval	13	12	17	15
11	Concepción	13	13	14	14
12	Deportes	13	14	18	14
13	Luis	13	16	22	10
14	Unión	13	12	19	8

TEMPORADA 2012/2013

SEGUNDA CHILE
Equipo		PJ	GF	GC	Puntos
1	CDSC Iberia	22	40	21	48
2	Trasandino	22	36	24	43
3	Audax	22	51	34	42
4	Deportes	22	45	30	42
5	Antonio	22	39	27	37
6	Colo Colo	22	38	31	36
7	Puerto Montt	22	33	25	30
8	Deportes	22	26	29	26
9	Linares	22	35	39	24
10	Ñublense	22	28	57	17
11	Melipilla	22	31	55	15
12	Unión	22	24	54	14

TEMPORADA 2011/2012

SEGUNDA CHILE
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2010/2011

TERCERA A CHILE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ovalle	14	27	21	27
2	Municipal	14	25	15	25
3	Antonio	14	25	20	25
4	Barnechea	14	23	11	24
5	Trasandino	14	26	19	24
6	Provincial	14	20	25	18
7	Deportes	14	10	28	7
8	Melipilla	14	10	27	4
9	CDSC Iberia	14	29	16	28
10	Fernández	14	25	22	23
11	Provincial	14	30	17	22
12	Deportes	14	22	23	22
13	Deportes	14	22	16	20
14	Unión Santa	14	21	25	16
15	Colchagua	14	18	22	14
16	Pudahuel	14	12	38	8

Competiciones que juega

Primera B Chile

Pos	Equipos		Pts
1		Coquimbo Unido	55
2		Deportes Copiapó	52
3		Santiago Morning	51
4		Deportes Temuco	49
5		Puerto Montt	48
6		Deportes Santa Cruz	45
7		Magallanes	41
8		Deportes Iquique	40
9		Fernández Vial	40
10		San Luis de Quillota	40
11		Unión San Felipe	36
12		Rangers Talca	35
13		Univ. Concepción	33
14		Cobreloa	33
15		Barnechea	24
16		San Marcos Arica	16

	Ascenso : Coquimbo Unido
	Playoff Ascenso : Deportes Copiapó, Santiago Morning, Deportes Temuco, Puerto Montt
	Descenso : San Marcos Arica

RIVALES EN Copa Chile

RIVALES EN Primera B Chile

USO DE MEMORIA

6,313,720 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1418
Total Execution Time	0.1431

CADENA URL

/historico/Deportes-Temuco/2021

GET DATOS

$_GET['/historico/Deportes-Temuco/2021']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0036	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 = 'Deportes-Temuco' AND l.year = 2021 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=16425 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=16425 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=16425 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=16425 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024	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 = 65967
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16425 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 16425 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 (47509,61224,71300,74849,89034) ORDER BY n.cover_points DESC, update_date DESC
0.0030	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 = '16425' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '16425' 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 = 61982 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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=16425 AND l.year in (2020,2021,2022) 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 (66979,66687) 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 = 66687 AND teamId = 16425
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 66979 AND teamId = 16425
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* `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 = 61982 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023	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 = '16425' 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 = '16425' 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 = '16425' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0037	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 events2021 e ON e.player_id = p.id AND e.league_id = 61982 WHERE rp.league_id = 61982 AND rp.teamId = 16425 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.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 events2021 e ON e.player_id = p.id AND e.league_id = 61982 WHERE rp.league_id = 61982 AND rp.teamId = 16425 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 events2021 e ON e.player_id = p.id AND e.league_id = 61982 WHERE rp.league_id = 61982 AND rp.teamId = 16425 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 = 16425 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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.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* `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.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* `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 = 42540 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 29174 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 = 36658 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 = 38839 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* `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.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 = 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.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 = 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.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 = 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.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* `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.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* `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.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* `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 = 3199 AND t.round = 7 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* `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 = 3279 AND t.round = 7 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 = 3200 AND t.round = 13 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 = 3680 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* `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 = 24344 AND t.round = 22 ORDER BY team.conference 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* `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 = 24347 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* `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 = 24746 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

Deportes Temuco

Deportes Temuco

Selecciona un equipo

Competiciones que juega

Primera B Chile

RIVALES EN Copa Chile

RIVALES EN Primera B Chile