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

Coquimbo Unido

Entrenador: Fernando Díaz

Temporada 2009/2010

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

TEMPORADA 2007/2008

PRIMERA B CHILE - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Coquimbo	22	35	26	40
2	Puerto Montt	22	30	27	38
3	Curicó	22	28	22	36
4	Marcos Arica	22	33	33	33
5	Deportes	22	25	23	32
6	Unión	22	28	26	28
7	Santiago	22	27	25	28
8	Fernández	22	28	30	28
9	Deportes	22	25	27	26
10	Lota	22	25	33	26
11	Luis	22	32	39	25
12	Unión	22	34	39	23

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

TEMPORADA 2004/2005

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

TEMPORADA 2003/2004

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

TEMPORADA 2002/2003

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

TEMPORADA 2001/2002

PRIMERA CHILE - APERTURA
Equipo		PJ	GF	GC	Puntos
1	Colo-Colo	15	29	16	30
2	Católica	15	40	22	29
3	Palestino	15	29	21	26
4	Santiago	15	25	18	26
5	Univ Chile	15	27	23	25
6	Rangers	15	21	15	24
7	Deportes	15	33	28	22
8	Audax	15	18	21	21
9	Unión	15	21	24	18
10	Coquimbo	15	17	26	18
11	Cobreloa	15	26	27	17
12	Huachipato	15	24	31	16
13	Santiago	15	23	25	15
14	Concepción	15	18	28	14
15	Unión	15	17	27	14
16	Cobresal	15	19	35	13

TEMPORADA 2000/2001

PRIMERA CHILE
Equipo		PJ	GF	GC	Puntos
1	Santiago	30	66	33	66
2	Católica	30	60	29	60
3	Univ Chile	30	56	34	57
4	Colo-Colo	30	63	37	56
5	Cobreloa	30	39	28	48
6	Palestino	30	44	43	48
7	Huachipato	30	57	41	46
8	Unión	30	46	39	40
9	Unión	30	46	64	37
10	Coquimbo	30	29	39	35
11	Audax	30	27	40	32
12	Concepción	30	34	50	32
13	Rangers	30	38	46	30
14	Santiago	30	47	67	28
15	O'Higgins	30	40	68	25
16	Puerto Montt	30	31	65	21

TEMPORADA 1999/2000

PRIMERA CHILE
Equipo		PJ	GF	GC	Puntos
1	Univ Chile	30	62	27	61
2	Cobreloa	30	53	36	52
3	Colo-Colo	30	58	46	49
4	Unión	30	43	38	48
5	Católica	30	51	42	44
6	Concepción	30	28	30	43
7	Santiago	30	47	46	41
8	Audax	30	38	34	40
9	Palestino	30	45	44	40
10	Santiago	30	47	54	38
11	Coquimbo	30	36	47	37
12	O'Higgins	30	43	52	36
13	Huachipato	30	44	48	34
14	Puerto Montt	30	42	54	34
15	Everton	30	41	53	33
16	Provincial	30	37	64	23

Competiciones que juega

Grupo 8

Primera B Chile - Apertura Fase 1 Grupo 1

Pos	Equipos		Pts
1		Unión La Calera	45
2		Antofagasta	45
3		Puerto Montt	45
4		Unión Temuco	41
5		Concepción	36
6		Deportes Iquique	34
7		Lota Schwager	34
8		Curicó Unido	33
9		Naval de Talcahuano	29
10		Rangers Talca	28
11		San Marcos Arica	27
12		Coquimbo Unido	26
13		Deportes Copiapó	18
14		CD Provincial Osorno	18

RIVALES EN Copa Chile

RIVALES EN Primera B Chile.

USO DE MEMORIA

6,609,744 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.7140
Total Execution Time	0.7155

CADENA URL

/historico/Coquimbo-Unido/2010

GET DATOS

$_GET['/historico/Coquimbo-Unido/2010']

POST DATOS

No hay datos POST existentes

CONSULTAS (45)

0.0272	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 = 24547
0.0130	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 = 23430
0.0130	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 = 23432
0.0130	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 = 23433
0.0126	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9139 AND type_rel = 2
0.0127	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9139 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128	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,10008,22809,74142,97344) ORDER BY n.cover_points DESC, update_date DESC
0.0134	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 = '9139' 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 = 23430 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 = 24547 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=9139 AND l.year in (2009,2010,2011) 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 (43370,24579,24573,24565,24553,24548) 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.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 24553 AND teamId = 9139
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 24565 AND teamId = 9139
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 24573 AND teamId = 9139
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 24548 AND teamId = 9139
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 24579 AND teamId = 9139
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 43370 AND teamId = 9139
0.0132	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128	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 = '9139' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0124	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9139' and rp.type = 4
0.0126	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 = '9139' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0137	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 events2010 e ON e.player_id = p.id AND e.league_id = 24547 WHERE rp.league_id = 24547 AND rp.teamId = 9139 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.0133	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 events2010 e ON e.player_id = p.id AND e.league_id = 24547 WHERE rp.league_id = 24547 AND rp.teamId = 9139 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132	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 events2010 e ON e.player_id = p.id AND e.league_id = 24547 WHERE rp.league_id = 24547 AND rp.teamId = 9139 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134	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 = 9139 AND l.year <= 2010 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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.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* `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 = 24548 AND t.round = 19 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* `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.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* `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 = 24549 AND t.round = 22 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* `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 = 24580 AND t.round = 22 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* `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.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* `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.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* `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.0132	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.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* `tables2005` 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 = 13442 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 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* `tables2005` 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 = 9022 AND t.round = 19 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* `tables2004` 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 = 13443 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* `tables2004` 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 = 9023 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* `tables2003` 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 = 13444 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* `tables2003` 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 = 9024 AND t.round = 15 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* `tables2002` 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 = 13445 AND t.round = 15 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* `tables2002` 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 = 9025 AND t.round = 15 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* `tables2001` 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 = 13446 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* `tables2000` 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 = 13447 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Coquimbo Unido

Coquimbo Unido

Selecciona un equipo

Competiciones que juega

Primera B Chile - Apertura Fase 1 Grupo 1

RIVALES EN Copa Chile

RIVALES EN Primera B Chile.