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

CD Melipilla

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA CHILE
Equipo		PJ	GF	GC	Puntos
1	Melipilla	8	18	5	19
2	Puerto Montt	8	12	5	17
3	Provincial	8	13	10	16
4	Concepción	8	13	9	15
5	General	8	14	11	14
6	Antonio	9	12	15	14
7	Real	8	7	7	12
8	Deportes	8	13	11	11
9	Provincial	8	10	10	11
10	Lautaro Buin	8	9	12	7
11	Concón	9	7	15	7
12	Fernández	9	11	12	6
13	Linares	8	7	12	6
14	Trasandino	9	5	17	5

TEMPORADA 2022/2023

SEGUNDA CHILE
Equipo		PJ	GF	GC	Puntos
1	Deportes	26	45	18	61
2	Melipilla	26	41	28	47
3	Fernández	26	26	19	40
4	Antonio	26	32	32	40
5	Lautaro Buin	26	34	33	37
6	Provincial	26	27	28	34
7	Trasandino	26	32	35	34
8	Concepción	26	31	36	31
9	General	26	20	27	29
10	Real	26	25	35	29
11	Deportes	26	32	35	26
12	Deportes	26	25	36	26
13	Linares	26	27	37	25
14	CDSC Iberia	26	37	35	22

TEMPORADA 2021/2022

PRIMERA B CHILE
Equipo		PJ	GF	GC	Puntos
1	Magallanes	32	61	23	72
2	Cobreloa	32	41	24	68
3	Deportes	32	46	34	52
4	Unión	32	38	35	52
5	Puerto Montt	32	36	31	47
6	Univ.	32	42	34	46
7	Rangers	32	39	40	46
8	Barnechea	32	47	43	44
9	Santiago	32	37	37	42
10	Deportes	32	31	41	38
11	Deportes	32	34	39	36
12	Deportes	32	31	38	35
13	Recoleta	32	34	41	34
14	Santiago	32	37	47	34
15	Luis	32	27	42	34
16	Melipilla	32	30	49	30
17	Fernández	32	26	39	26

TEMPORADA 2020/2021

PRIMERA CHILE
Equipo		PJ	GF	GC	Puntos
1	Católica	32	65	34	68
2	Colo-Colo	32	49	26	62
3	Audax	32	39	31	54
4	Unión	32	41	40	51
5	Unión	32	48	50	48
6	Antofagasta	32	34	36	47
7	Ñublense	32	49	37	44
8	Palestino	32	48	50	41
9	Cobresal	32	40	39	40
10	La Serena	32	40	42	39
11	Univ Chile	32	34	37	39
12	Everton	32	29	35	39
13	O'Higgins	32	31	41	38
14	Curicó	32	37	39	37
15	Huachipato	32	36	41	37
16	Melipilla	32	39	51	32
17	Santiago	32	24	54	21

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 B CHILE
Equipo		PJ	GF	GC	Puntos
1	Coquimbo	30	47	31	57
2	Cobreloa	30	43	31	52
3	Cobresal	30	44	30	51
4	Deportes	30	45	37	47
5	Santiago	30	41	43	46
6	Santiago	30	34	36	45
7	Unión	30	32	28	42
8	Rangers	30	33	34	40
9	Barnechea	30	38	38	39
10	Melipilla	30	39	41	39
11	Puerto Montt	30	31	33	35
12	La Serena	30	37	41	35
13	Magallanes	30	37	41	34
14	Deportes	30	36	44	34
15	Ñublense	30	27	35	33
16	Marcos Arica	30	28	49	32

TEMPORADA 2016/2017

TORNEO TRANSICIÓN SEGUNDA CHILE
Equipo		PJ	GF	GC	Puntos
1	Deportes	20	26	16	38
2	Naval	20	24	18	32
3	Deportes	20	25	20	31
4	Antonio	20	25	23	30
5	Recoleta	20	27	23	28
6	Malleco	20	31	26	27
7	Colchagua	20	23	26	27
8	Melipilla	20	27	26	26
9	Independient	20	22	24	24
10	Deportes	20	17	30	20
11	Provincial	20	12	27	16

TEMPORADA 2015/2016

SEGUNDA CHILE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Malleco	12	21	18	51
2	Ovalle	12	17	16	48
3	Lota	12	18	13	44
4	Municipal	12	14	16	44
5	Colchagua	12	24	9	43
6	Melipilla	12	10	13	43
7	Linares	12	12	31	22

TEMPORADA 2014/2015

SEGUNDA CHILE GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Puerto Montt	11	25	15	25
2	Antonio	11	21	16	23
3	Malleco	11	26	16	21
4	Deportes	11	29	17	20
5	Melipilla	11	20	16	17
6	Ovalle	11	19	15	17
7	Naval	11	14	17	14
8	Trasandino	11	12	17	12
9	Deportes	11	20	26	11
10	Municipal	11	14	22	8
11	Linares	11	12	22	8
12	Deportes	11	13	26	8

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 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

Segunda Chile

Pos	Equipos		Pts
1		CD Melipilla	19
2		Puerto Montt	17
3		CD Provincial Osorno	16
4		Concepción	15
5		General Velásquez	14
6		San Antonio Unido	14
7		Real San Joaquín	12
8		Deportes Rengo	11
9		Provincial Ovalle	11
10		Lautaro de Buin	7
11		Concón National	7
12		Fernández Vial	6
13		Linares Unido	6
14		Trasandino	5

	Ascenso : CD Melipilla
	Descenso : Linares Unido, Trasandino

RIVALES EN Segunda Chile

USO DE MEMORIA

6,200,968 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5677
Total Execution Time	0.5690

CADENA URL

/historico/Cd-Melipilla

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0118	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 = 2024 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.0107	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.0105	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.0212	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 = 75317
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=688 AND type_rel = 2
0.0108	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.0107	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.0114	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.0109	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 = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0111	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.0107	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 = 75317 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110	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 (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106	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 (75317,71182) 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.0108	SELECT count(id) as num_players from rel_players WHERE league_id = 75317 AND teamId = 688
0.0109	SELECT count(id) as num_players from rel_players WHERE league_id = 71182 AND teamId = 688
0.0115	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 events2024 e ON e.player_id = p.id AND e.league_id = 75317 WHERE rp.league_id = 75317 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.0114	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 events2024 e ON e.player_id = p.id AND e.league_id = 75317 WHERE rp.league_id = 75317 AND rp.teamId = 688 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0111	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 events2024 e ON e.player_id = p.id AND e.league_id = 75317 WHERE rp.league_id = 75317 AND rp.teamId = 688 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0112	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 <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0108	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* `tables2024` 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 = 75317 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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* `tables2023` 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 = 71103 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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* `tables2022` 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 = 66687 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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* `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 = 61822 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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.0109	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.0111	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 = 42541 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 34702 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 37459 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 39322 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117	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 = 15520 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118	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 = 21329 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0121	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 = 15507 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 15510 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115	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 = 15511 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 15513 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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.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* `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.0106	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.0111	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.0107	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 = 75317 ORDER BY nameShow LIMIT 100

CD Melipilla

CD Melipilla

Selecciona un equipo

Competiciones que juega

Segunda Chile

RIVALES EN Segunda Chile