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

Antofagasta

Entrenador: John Armijo

Temporada 2017/2018

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

TEMPORADA 2010/2011

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

TEMPORADA 2009/2010

PRIMERA B CHILE - APERTURA FASE 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Unión	24	39	24	45
2	Antofagasta	24	37	22	45
3	Deportes	24	30	25	34
4	Curicó	24	34	29	33
5	Marcos Arica	24	41	55	27
6	Coquimbo	24	24	34	26
7	Deportes	24	28	44	18
8	Puerto Montt	24	34	22	45
9	Unión	24	35	27	41
10	Concepción	24	31	24	36
11	Lota	24	31	29	34
12	Naval	24	27	26	29
13	Rangers	24	26	33	28
14	Provincial	24	17	40	18

TEMPORADA 2008/2009

PRIMERA B CHILE - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Luis	19	24	12	39
2	Santiago	19	29	12	38
3	Unión	19	32	15	36
4	Concepción	19	27	31	29
5	Melipilla	19	35	30	28
6	Marcos Arica	19	29	30	26
7	Provincial	19	35	31	25
8	Antofagasta	19	24	21	25
9	Coquimbo	19	28	31	25
10	Naval	19	16	26	21
11	Puerto Montt	19	21	24	19
12	Unión	19	19	29	17
13	Lota	19	18	30	16
14	Deportes	19	15	30	13

Competiciones que juega

Primera Chile

Pos	Equipos		Pts
1		U. Católica	61
2		Univ. Concepción	58
3		Univ de Chile	57
4		Antofagasta	53
5		Colo-Colo	43
6		Unión La Calera	43
7		Unión Española	41
8		O'Higgins	41
9		Huachipato	39
10		Audax Italiano	34
11		Everton	34
12		Curicó Unido	34
13		Palestino	32
14		Deportes Iquique	32
15		Deportes Temuco	28
16		San Luis de Quillota	23

	Copa Libertadores : U. Católica, Univ. Concepción, Univ de Chile
	Liguilla Sudamericana : Antofagasta, Colo-Colo, Unión La Calera, Unión Española
	Descenso : Deportes Temuco, San Luis de Quillota

RIVALES EN Copa Chile

RIVALES EN Primera Chile

USO DE MEMORIA

6,283,728 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.8178
Total Execution Time	0.8191

CADENA URL

/historico/Antofagasta/2018

GET DATOS

$_GET['/historico/Antofagasta/2018']

POST DATOS

No hay datos POST existentes

CONSULTAS (51)

0.0155	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 = 'Antofagasta' AND l.year = 2018 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.0129	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=9947 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=9947 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=9947 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0268	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 = 42540
0.0152	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 = 38762
0.0128	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9947 AND type_rel = 2
0.0132	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9947 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0131	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 (4086,9042,45798,74142,75904) ORDER BY n.cover_points DESC, update_date DESC
0.0136	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 = '9947' ORDER BY l.year DESC,cat.coefficient DESC
0.0132	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 = '9947' AND l.year = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0132	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 = '9947' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127	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 = 38762 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126	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 = 42540 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132	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=9947 AND l.year in (2017,2018,2019) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (48720,48414,43355,38839,36658,29174) 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.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 48720 AND teamId = 9947
0.0141	SELECT count(id) as num_players from rel_players WHERE league_id = 29174 AND teamId = 9947
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 36658 AND teamId = 9947
0.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 38839 AND teamId = 9947
0.0137	SELECT count(id) as num_players from rel_players WHERE league_id = 48414 AND teamId = 9947
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 43355 AND teamId = 9947
0.0150	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0136	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 = '9947' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9947' and rp.type = 4
0.0138	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 = '9947' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0186	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 events2018 e ON e.player_id = p.id AND e.league_id = 42540 WHERE rp.league_id = 42540 AND rp.teamId = 9947 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.0187	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 events2018 e ON e.player_id = p.id AND e.league_id = 42540 WHERE rp.league_id = 42540 AND rp.teamId = 9947 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0172	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 events2018 e ON e.player_id = p.id AND e.league_id = 42540 WHERE rp.league_id = 42540 AND rp.teamId = 9947 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0174	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 = 9947 AND l.year <= 2018 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0146	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.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* `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.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* `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.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* `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.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* `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 = 15421 AND t.round = 15 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* `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 = 20173 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140	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.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* `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.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 = 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.0139	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.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* `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.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* `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.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* `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.0127	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.0127	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.0127	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.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* `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.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* `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 = 24556 AND t.round = 14 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* `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 = 24547 AND t.round = 28 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* `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 = 24579 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 42540 ORDER BY nameShow LIMIT 100

Antofagasta

Antofagasta

Selecciona un equipo

Competiciones que juega

Primera Chile

RIVALES EN Copa Chile

RIVALES EN Primera Chile