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

O'Higgins

Entrenador: Víctor Fuentes

Temporada 2015/2016

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

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

TEMPORADA 2009/2010

PRIMERA CHILE
Equipo		PJ	GF	GC	Puntos
1	Católica	34	77	39	74
2	Colo-Colo	34	67	34	71
3	Audax	34	75	58	65
4	Univ Chile	34	75	48	64
5	Unión	34	58	50	52
6	Huachipato	34	44	40	48
7	Santiago	34	48	52	45
8	La Serena	34	45	59	45
9	Unión	34	38	47	43
10	Cobresal	34	47	52	42
11	Palestino	34	35	41	42
12	O'Higgins	34	46	44	41
13	Ñublense	34	54	66	40
14	Cobreloa	34	45	47	39
15	Univ.	34	39	50	38
16	Santiago	34	34	45	36
17	Everton	34	38	58	34
18	Luis	34	36	71	24

TEMPORADA 2008/2009

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

TEMPORADA 2007/2008

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

TEMPORADA 2006/2007

PRIMERA CHILE - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Colo-Colo	20	40	21	39
2	Cobresal	20	31	23	32
3	Palestino	20	27	23	26
4	La Serena	20	25	33	22
5	Santiago	20	15	43	17
6	Univ.	20	30	19	35
7	Católica	20	33	21	34
8	Melipilla	20	32	34	27
9	Concepción	20	32	41	25
10	Unión	20	26	36	17
11	Audax	20	47	20	47
12	Univ Chile	20	42	21	45
13	Cobreloa	20	35	29	31
14	Puerto Montt	20	18	22	21
15	Everton	20	20	36	13
16	O'Higgins	20	28	23	34
17	Ñublense	20	32	38	26
18	Antofagasta	20	22	21	25
19	Huachipato	20	30	36	25
20	Lota	20	22	28	19
21	Coquimbo	20	18	37	13

TEMPORADA 2005/2006

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

Competiciones que juega

RIVALES EN Copa Chile

RIVALES EN Conmebol Sudamer.

RIVALES EN Primera Chile -.

USO DE MEMORIA

6,959,280 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	1.0489
Total Execution Time	1.0501

CADENA URL

/historico/O-Higgins/2016

GET DATOS

$_GET['/historico/O-Higgins/2016']

POST DATOS

No hay datos POST existentes

CONSULTAS (60)

0.0161	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 = 'O-Higgins' AND l.year = 2016 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.0146	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=9948 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=9948 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=9948 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=9948 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=9948 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=9948 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=9948 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151	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 = 15421
0.0174	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 = 20173
0.0172	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 = 26487
0.0171	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 = 15816
0.0172	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 = 16705
0.0148	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9948 AND type_rel = 2
0.0149	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9948 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0149	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 (1730,4237,18986,21355,38189) ORDER BY n.cover_points DESC, update_date DESC
0.0153	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 = '9948' AND l.year = 2016 ORDER BY l.year DESC,cat.coefficient DESC
0.0154	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 = '9948' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147	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 = 15816 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152	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 = 33863 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148	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 = 26487 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149	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 = 15421 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149	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 = 20173 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0159	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=9948 AND l.year in (2015,2016,2017) ORDER BY l.id DESC, l.year DESC ;
0.0148	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 (38839,37834,37588,36658,33421,26487) 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.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 36658 AND teamId = 9948
0.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 38839 AND teamId = 9948
0.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 37588 AND teamId = 9948
0.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 37834 AND teamId = 9948
0.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 26487 AND teamId = 9948
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 33421 AND teamId = 9948
0.0148	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 33863 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0153	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 = '9948' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0147	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9948' and rp.type = 4
0.0156	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 = '9948' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0209	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 events2016 e ON e.player_id = p.id AND e.league_id = 33863 WHERE rp.league_id = 33863 AND rp.teamId = 9948 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.0153	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 events2016 e ON e.player_id = p.id AND e.league_id = 33863 WHERE rp.league_id = 33863 AND rp.teamId = 9948 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151	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 events2016 e ON e.player_id = p.id AND e.league_id = 33863 WHERE rp.league_id = 33863 AND rp.teamId = 9948 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158	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 = 9948 AND l.year <= 2016 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,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.0149	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.0152	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.0157	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.0160	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.0148	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.0150	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.0150	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.0153	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.0154	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 = 1295 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 1309 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 13500 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 1020 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157	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 = 1019 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157	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* `tables2008` 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 = 252 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163	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* `tables2008` 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 = 253 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0173	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* `tables2007` 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 = 9020 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167	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* `tables2007` 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 = 13440 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160	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* `tables2006` 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 = 9021 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162	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* `tables2006` 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 = 13441 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 33863 ORDER BY nameShow LIMIT 100

O'Higgins

O'Higgins

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa Chile

RIVALES EN Conmebol Sudamer.

RIVALES EN Primera Chile -.

RIVALES EN Primera Chile -.

RIVALES EN Primera Chile -.