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

CD Melipilla

Temporada 2013/2014

TEMPORADA 2013/2014

SEGUNDA CHILE
Equipo		PJ	GF	GC	Puntos
1	CDSC Iberia	22	59	24	48
2	Antonio	22	47	27	47
3	Puerto Montt	22	42	18	46
4	Melipilla	22	29	19	35
5	Deportes	22	34	28	33
6	Trasandino	22	42	39	33
7	Linares	22	35	34	33
8	Audax	22	39	32	29
9	Malleco	22	26	32	28
10	Unión	22	36	54	20
11	Colo Colo	22	28	63	14
12	Ñublense	22	18	65	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 3
Equipo		PJ	GF	GC	Puntos
1	Provincial	6	10	7	11
2	Deportes	6	8	9	10
3	Melipilla	6	6	9	7
4	Trasandino	6	12	11	6
5	Unión Santa	6	10	6	12
6	Deportes	6	8	5	12
7	Colchagua	6	9	9	9
8	Pudahuel	6	5	12	3

TEMPORADA 2009/2010

TERCERA A CHILE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Magallanes	14	39	16	31
2	Trasandino	14	27	20	29
3	Barnechea	14	25	13	26
4	CDSC Iberia	14	20	18	21
5	Melipilla	14	24	28	18
6	Municipal	14	17	25	16
7	Colchagua	14	18	26	14
8	Provincial	14	14	38	3

TEMPORADA 2008/2009

PRIMERA B CHILE - APERTURA FASE 1
Equipo		PJ	GF	GC	Puntos
1	Unión	19	35	18	40
2	Santiago	19	33	19	33
3	Luis	19	25	12	31
4	Melipilla	19	30	28	30
5	Marcos Arica	19	17	21	27
6	Coquimbo	19	21	20	26
7	Lota	19	21	25	26
8	Provincial	19	22	27	25
9	Antofagasta	19	26	26	23
10	Naval	19	20	24	23
11	Puerto Montt	19	26	30	20
12	Unión	19	27	31	19
13	Concepción	19	25	35	18
14	Deportes	19	12	24	17

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 B CHILE - APERTURA FASE 1
Equipo		PJ	GF	GC	Puntos
1	Melipilla	22	37	16	44
2	Lota	22	35	23	38
3	Luis	22	27	16	38
4	Curicó	22	25	20	37
5	Ñublense	22	37	27	35
6	Fernández	22	35	26	33
7	Unión	22	28	27	29
8	Unión	22	24	29	28
9	Deportes	22	30	38	22
10	Provincial	22	32	42	21
11	Deportes	22	23	36	18
12	Magallanes	22	11	44	11

TEMPORADA 2004/2005

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

TEMPORADA 2003/2004

PRIMERA B CHILE - CLAUSURA FASE 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Melipilla	12	17	9	28
2	Unión	12	22	16	20
3	Magallanes	12	18	13	20
4	Deportes	12	16	13	18
5	Ovalle	12	10	18	12
6	Antofagasta	12	13	14	11
7	Marcos Arica	12	12	25	8

TEMPORADA 2002/2003

PRIMERA B CHILE - APERTURA FASE 1 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	O'Higgins	6	12	5	11
2	Santiago	6	5	6	8
3	Provincial	6	7	11	7
4	Melipilla	6	6	8	6

Competiciones que juega

Segunda Chile

Pos	Equipos		Pts
1		CDSC Iberia	48
2		San Antonio Unido	47
3		Puerto Montt	46
4		CD Melipilla	35
5		Deportes Valdivia	33
6		Trasandino	33
7		Linares Unido	33
8		Audax Italiano II	29
9		Malleco Unido	28
10		Unión Española II	20
11		Colo Colo II	14
12		Ñublense II	8

RIVALES EN Segunda Chile

USO DE MEMORIA

5,812,824 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.3539
Total Execution Time	0.3558

CADENA URL

/historico/Cd-Melipilla/2014

GET DATOS

$_GET['/historico/Cd-Melipilla/2014']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0041	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 = 'Cd-Melipilla' AND l.year = 2014 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.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=688 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=688 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 24341
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=688 AND type_rel = 2
0.0027	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 688 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0026	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 (249016,352931,352329,355022,426461) ORDER BY n.cover_points DESC, update_date DESC
0.0045	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 = '688' ORDER BY l.year DESC,cat.coefficient DESC
0.0052	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 = '688' AND l.year = 2014 ORDER BY l.year DESC,cat.coefficient DESC
0.0048	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 = '688' 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 = 24341 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0038	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=688 AND l.year in (2013,2014,2015) 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 (24344) 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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 24344 AND teamId = 688
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 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 = 24341 AND t.round = 22 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 = '688' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '688' 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 = '688' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2014 e ON e.player_id = p.id AND e.league_id = 24341 WHERE rp.league_id = 24341 AND rp.teamId = 688 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.0027	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 events2014 e ON e.player_id = p.id AND e.league_id = 24341 WHERE rp.league_id = 24341 AND rp.teamId = 688 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	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 events2014 e ON e.player_id = p.id AND e.league_id = 24341 WHERE rp.league_id = 24341 AND rp.teamId = 688 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 688 AND l.year <= 2014 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* `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 = 24341 AND t.round = 22 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.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 = 24746 AND t.round = 14 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 = 24753 AND t.round = 6 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* `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 = 24688 AND t.round = 14 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* `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 = 24689 AND t.round = 14 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* `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.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* `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.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* `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.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* `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.0027	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.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* `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.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* `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 = 24552 AND t.round = 22 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* `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.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* `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.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* `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 = 27890 AND t.round = 10 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* `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 = 27848 AND t.round = 20 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* `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 = 27887 AND t.round = 14 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* `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 = 27840 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 24341 ORDER BY nameShow LIMIT 100

CD Melipilla

CD Melipilla

Selecciona un equipo

Competiciones que juega

Segunda Chile

RIVALES EN Segunda Chile