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

Unión San Felipe

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA B CHILE
Equipo		PJ	GF	GC	Puntos
1	Rangers	10	14	7	22
2	La Serena	10	13	7	22
3	Deportes	9	19	8	19
4	Barnechea	10	18	12	18
5	Antofagasta	10	16	12	16
6	Magallanes	10	14	11	16
7	Deportes	10	17	17	16
8	Recoleta	10	12	14	15
9	Santiago	9	13	11	13
10	Luis	8	15	17	13
11	Marcos Arica	10	14	15	12
12	Santiago	9	13	15	11
13	Deportes	10	9	15	10
14	Univ.	9	7	15	9
15	Curicó	10	7	14	8
16	Unión	10	10	21	3

TEMPORADA 2022/2023

PRIMERA B CHILE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Cobreloa	30	41	30	54
2	Deportes	30	54	39	52
3	Santiago	30	37	28	51
4	Deportes	30	39	36	50
5	Antofagasta	30	50	38	46
6	Luis	30	43	31	44
7	La Serena	30	38	39	44
8	Unión	30	40	34	41
9	Barnechea	30	40	41	41
10	Marcos Arica	30	51	52	40
11	Rangers	30	35	47	36
12	Santiago	30	32	38	34
13	Univ.	30	36	49	34
14	Deportes	30	27	36	33
15	Recoleta	30	34	43	30
16	Puerto Montt	30	25	41	30

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 B CHILE
Equipo		PJ	GF	GC	Puntos
1	Coquimbo	30	42	22	55
2	Deportes	30	49	36	52
3	Santiago	30	43	26	51
4	Deportes	30	44	28	49
5	Puerto Montt	30	34	30	48
6	Deportes	30	36	37	45
7	Magallanes	30	38	34	41
8	Deportes	30	52	45	40
9	Fernández	30	45	39	40
10	Luis	30	33	32	40
11	Unión	30	34	40	36
12	Rangers	30	34	42	35
13	Univ.	30	32	37	33
14	Cobreloa	30	35	41	33
15	Barnechea	30	28	44	24
16	Marcos Arica	30	14	60	16

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

PRIMERA B CHILE
Equipo		PJ	GF	GC	Puntos
1	Unión	15	25	11	34
2	Deportes	15	24	18	26
3	Cobreloa	15	30	28	23
4	Coquimbo	15	18	16	22
5	Barnechea	15	26	25	22
6	Magallanes	15	18	19	21
7	Puerto Montt	15	18	20	21
8	Cobresal	15	23	20	20
9	Unión	15	14	14	20
10	Marcos Arica	15	20	21	20
11	La Serena	15	20	20	19
12	Ñublense	15	11	13	18
13	CDSC Iberia	15	25	28	18
14	Santiago	15	17	23	17
15	Deportes	15	11	17	15
16	Rangers	15	14	21	13

TEMPORADA 2015/2016

PRIMERA B CHILE - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Curicó	15	35	15	33
2	Deportes	15	26	18	28
3	Concepción	15	23	16	27
4	Puerto Montt	15	23	20	26
5	Rangers	15	20	16	24
6	CDSC Iberia	15	21	13	23
7	Deportes	15	21	19	21
8	Coquimbo	15	30	30	20
9	Cobreloa	15	21	22	20
10	Unión	15	14	14	18
11	La Serena	15	21	24	18
12	Everton	15	17	20	16
13	Ñublense	15	16	25	16
14	Santiago	15	20	26	14
15	Magallanes	15	18	29	13
16	Barnechea	15	11	30	11

TEMPORADA 2014/2015

PRIMERA B CHILE - CLAUSURA FASE 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Luis	6	6	8	51
2	Unión	6	12	9	49
3	Everton	6	7	8	40
4	Deportes	6	9	7	36
5	Magallanes	6	8	7	35
6	La Serena	6	11	12	27
7	Coquimbo	6	8	10	23

TEMPORADA 2013/2014

PRIMERA B CHILE - CLAUSURA FASE 2
Equipo		PJ	GF	GC	Puntos
1	Marcos Arica	13	21	8	28
2	Coquimbo	13	21	14	28
3	Lota	13	10	8	21
4	Deportes	13	16	17	21
5	La Serena	13	17	16	19
6	Curicó	13	14	13	19
7	Barnechea	13	15	10	18
8	Magallanes	13	21	22	16
9	Santiago	13	13	17	15
10	Naval	13	12	17	15
11	Concepción	13	13	14	14
12	Deportes	13	14	18	14
13	Luis	13	16	22	10
14	Unión	13	12	19	8

Competiciones que juega

Primera B Chile

Pos	Equipos		Pts
1		Rangers Talca	22
2		La Serena	22
3		Deportes Limache	19
4		Barnechea	18
5		Antofagasta	16
6		Magallanes	16
7		Deportes Santa Cruz	16
8		Recoleta	15
9		Santiago Morning	13
10		San Luis de Quillota	13
11		San Marcos Arica	12
12		Santiago Wanderers	11
13		Deportes Temuco	10
14		Univ. Concepción	9
15		Curicó Unido	8
16		Unión San Felipe	3

	Ascenso : Rangers Talca
	Playoff Ascenso : La Serena
	Siguiente Ronda : Deportes Limache, Barnechea, Antofagasta, Magallanes, Deportes Santa Cruz, Recoleta
	Descenso : Unión San Felipe

RIVALES EN Copa Chile

RIVALES EN Primera B Chile

USO DE MEMORIA

6,317,240 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.5687
Total Execution Time	0.5700

CADENA URL

/historico/Union-San-Felipe

GET DATOS

$_GET['/historico/Union-San-Felipe']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0122	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 = 'Union-San-Felipe' 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.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=4392 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=4392 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=4392 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4392 AND type_rel = 2
0.0107	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4392 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0108	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 (1205,81602,130848,231548,240710) ORDER BY n.cover_points DESC, update_date DESC
0.0115	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 = '4392' ORDER BY l.year DESC,cat.coefficient DESC
0.0111	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 = '4392' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0112	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 = '4392' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108	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 = 75087 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111	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=4392 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 (75877,75087) 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.0110	SELECT count(id) as num_players from rel_players WHERE league_id = 75087 AND teamId = 4392
0.0105	SELECT count(id) as num_players from rel_players WHERE league_id = 75877 AND teamId = 4392
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 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 = 75087 AND t.round = 10 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0109	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 = '4392' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0107	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4392' and rp.type = 4
0.0111	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 = '4392' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0122	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 = 75087 WHERE rp.league_id = 75087 AND rp.teamId = 4392 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.0119	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 = 75087 WHERE rp.league_id = 75087 AND rp.teamId = 4392 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0121	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 = 75087 WHERE rp.league_id = 75087 AND rp.teamId = 4392 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0113	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 = 4392 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 75087 AND t.round = 10 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* `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 = 70890 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.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* `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.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* `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 = 61982 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.0116	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.0116	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.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* `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 = 33434 AND t.round = 15 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* `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 = 36662 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120	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 = 38842 AND t.round = 15 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* `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 = 15792 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123	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 = 20203 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* `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 = 9280 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120	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 = 4010 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125	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 = 4914 AND t.round = 13 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* `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 = 9008 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 3278 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 3198 AND t.round = 7 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* `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 = 3200 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 3680 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Unión San Felipe

Unión San Felipe

Selecciona un equipo

Competiciones que juega

Primera B Chile

RIVALES EN Copa Chile

RIVALES EN Primera B Chile