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

Progreso

Entrenador: Carlos Canobbio

Temporada 2023/2024

TEMPORADA 2023/2024

APERTURA URUGUAY
Equipo		PJ	GF	GC	Puntos
1	Peñarol	11	24	6	29
2	Nacional	11	24	11	25
3	Progreso	11	23	16	24
4	Defensor	11	21	13	19
5	Cerro Largo	11	13	10	18
6	Boston River	11	15	13	18
7	Racing	11	17	16	15
8	Danubio	11	12	14	13
9	Liverpool	11	17	17	12
10	River Plate	11	15	17	12
11	Montevideo	11	12	16	12
12	Deportivo	11	12	15	11
13	Rampla	11	10	23	9
14	Cerro CA	11	11	21	8
15	Miramar	11	15	23	7
16	Fénix	11	5	15	4

TEMPORADA 2022/2023

SEGUNDA DIVISIÓN URUGUAY GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Miramar	32	52	24	66
2	Progreso	32	60	36	65
3	Uruguay	32	47	33	56
4	Juventud	32	38	30	51
5	Rentistas	32	39	27	47
6	Rampla	32	41	32	47
7	Oriental	32	40	39	47
8	Cerrito	32	38	56	41
9	Albion FC	32	44	41	41
10	Atenas	32	26	32	40
11	Tacuarembó	32	43	49	39
12	Bella Vista	32	24	48	29
13	América	32	26	45	26
14	Potencia	32	24	50	21

TEMPORADA 2021/2022

SEGUNDA DIVISIÓN URUGUAY GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Racing	27	40	18	57
2	La Luz FC	27	35	23	51
3	Uruguay	27	35	29	44
4	Cerro CA	27	31	30	41
5	Miramar	27	38	32	40
6	Rampla	27	32	31	35
7	América	27	27	38	33
8	Atenas	27	24	25	32
9	Progreso	27	23	27	31
10	Juventud	27	19	28	27
11	CSyD Villa.	27	27	37	27
12	Central	27	22	35	22

TEMPORADA 2020/2021

CLAUSURA URUGUAY
Equipo		PJ	GF	GC	Puntos
1	Peñarol	15	27	11	32
2	Nacional	15	23	15	30
3	Montevideo	15	23	18	27
4	Cerro Largo	15	24	11	26
5	Montevideo	15	26	19	25
6	Progreso	15	12	7	25
7	Boston River	15	24	25	22
8	Cerrito	15	20	22	21
9	Plaza	15	20	18	20
10	Fénix	15	18	18	19
11	Deportivo	15	13	18	17
12	River Plate	15	18	22	16
13	Liverpool	15	15	19	15
14	Rentistas	15	18	24	14
15	América	15	14	26	13
16	CSyD Villa.	15	12	34	6

TEMPORADA 2019/2020

TORNEO INTERMEDIO URUGUAY
Equipo		PJ	GF	GC	Puntos
1	Montevideo	7	13	8	14
2	Liverpool	7	14	12	12
3	Montevideo	7	13	10	10
4	Cerro Largo	7	8	5	10
5	Rentistas	7	7	6	9
6	Progreso	7	7	10	7
7	Plaza	7	8	11	6
8	Cerro CA	7	5	13	5
9	Nacional	7	11	6	15
10	River Plate	7	14	8	13
11	Peñarol	7	15	9	12
12	Fénix	7	7	6	10
13	Danubio	7	5	9	9
14	Deportivo	7	10	15	8
15	Defensor	7	5	10	6
16	Boston River	7	6	10	5

TEMPORADA 2018/2019

TORNEO INTERMEDIO URUGUAY
Equipo		PJ	GF	GC	Puntos
1	River Plate	6	6	3	12
2	Nacional	6	10	6	11
3	Peñarol	6	9	4	9
4	Progreso	6	9	7	9
5	Defensor	6	10	10	8
6	Juventud	6	5	7	6
7	Boston River	6	3	7	6
8	Danubio	6	5	13	1
9	Liverpool	6	15	5	15
10	Cerro Largo	6	10	5	13
11	Plaza	6	9	4	13
12	Fénix	6	7	9	9
13	Racing	6	8	12	7
14	Rampla	6	7	10	4
15	Cerro CA	6	2	7	4
16	Montevideo	6	9	15	4

TEMPORADA 2017/2018

TORNEO INTERMEDIO URUGUAY
Equipo		PJ	GF	GC	Puntos
1	Nacional	7	19	5	17
2	Cerro CA	7	9	5	13
3	Danubio	7	12	12	10
4	Racing	7	5	9	10
5	Montevideo	7	8	10	9
6	Liverpool	7	10	11	8
7	Rampla	7	9	14	6
8	Fénix	7	7	13	5
9	Montevideo	6	10	6	13
10	Peñarol	6	20	10	12
11	River Plate	6	5	9	9
12	Atenas	6	6	5	8
13	Progreso	6	5	7	6
14	Defensor	6	4	8	6
15	Boston River	6	2	7	4

TEMPORADA 2016/2017

SEGUNDA DIVISIÓN URUGUAY
Equipo		PJ	GF	GC	Puntos
1	Montevideo	28	48	23	56
2	Atenas	28	40	26	47
3	Progreso	28	39	27	42
4	Cerro Largo	28	30	27	42
5	Cerrito	28	26	35	42
6	Deportivo	28	29	31	39
7	Central	28	32	38	39
8	Rentistas	28	43	38	36
9	Villa Teresa	28	40	36	36
10	CSyD Villa.	28	26	27	35
11	Tacuarembó	28	33	34	34
12	Miramar	28	25	31	31
13	Huracán FC	28	33	43	30
14	Canadian	28	29	36	28
15	Oriental	28	31	52	28

TEMPORADA 2015/2016

SEGUNDA DIVISIÓN URUGUAY FORMATO ANTIGUO GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Rampla	14	22	14	31
2	CSyD Villa.	14	23	14	29
3	Boston River	14	21	13	26
4	Montevideo	14	26	20	23
5	Progreso	14	21	16	23
6	Atenas	14	25	19	22
7	Miramar	14	18	17	19
8	Tacuarembó	14	22	23	17
9	Cerro Largo	14	16	18	17
10	Central	14	17	20	17
11	Rocha FC	14	12	15	17
12	Deportivo	14	12	18	14
13	Oriental	14	12	20	14
14	Huracán FC	14	10	23	13
15	Canadian	14	16	23	12

Competiciones que juega

Apertura Uruguay

Pos	Equipos		Pts
1		Peñarol	29
2		Nacional	25
3		Progreso	24
4		Defensor Sporting	19
5		Cerro Largo	18
6		Boston River	18
7		Racing Montevideo	15
8		Danubio	13
9		Liverpool Montevideo	12
10		River Plate Montevideo	12
11		Montevideo Wanderers	12
12		Deportivo Maldonado	11
13		Rampla Juniors	9
14		Cerro CA	8
15		Miramar Misiones	7
16		Fénix	4

	Campeón : Peñarol

RIVALES EN Apertura Uruguay

RIVALES EN Copa Uruguay

USO DE MEMORIA

6,030,328 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1433
Total Execution Time	0.1445

CADENA URL

/historico/Progreso-Montevideo

GET DATOS

$_GET['/historico/Progreso-Montevideo']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0035	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 = 'Progreso-Montevideo' 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.0019	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=2020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=2020 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=2020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2020 AND type_rel = 2
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2020 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025	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 (95192,96985,97024,120228,488477) ORDER BY n.cover_points DESC, update_date DESC
0.0027	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 = '2020' ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '2020' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '2020' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023	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=2020 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023	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 (75068,73584,71542) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 75068 AND teamId = 2020
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 71542 AND teamId = 2020
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 73584 AND teamId = 2020
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 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 = 75068 AND t.round = 11 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024	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 = '2020' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2020' 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 = '2020' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036	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 = 75068 WHERE rp.league_id = 75068 AND rp.teamId = 2020 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.0028	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 = 75068 WHERE rp.league_id = 75068 AND rp.teamId = 2020 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2024 e ON e.player_id = p.id AND e.league_id = 75068 WHERE rp.league_id = 75068 AND rp.teamId = 2020 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 2020 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 71087 AND t.round = 7 ORDER BY team.conference ASC,t.position 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* `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 = 71381 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.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* `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 = 66698 AND t.round = 5 ORDER BY team.conference ASC,t.position 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* `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 = 67421 AND t.round = 22 ORDER BY team.conference ASC,t.position 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* `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 = 62425 AND t.round = 15 ORDER BY team.conference ASC,t.position 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* `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 = 64096 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042	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 = 53552 AND t.round = 15 ORDER BY team.conference ASC,t.position 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* `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 = 53553 AND t.round = 15 ORDER BY team.conference ASC,t.position 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* `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 = 59648 AND t.round = 7 ORDER BY team.conference ASC,t.position 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* `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 = 48930 AND t.round = 15 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* `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 = 50060 AND t.round = 15 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* `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 = 50145 AND t.round = 7 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* `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 = 42566 AND t.round = 15 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* `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 = 42567 AND t.round = 15 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* `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 = 43412 AND t.round = 7 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* `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 = 35302 AND t.round = 13 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* `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 = 38209 AND t.round = 30 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* `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 = 15508 AND t.round = 7 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* `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 = 20258 AND t.round = 15 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 = 75068 ORDER BY nameShow LIMIT 100

Progreso

Progreso

Selecciona un equipo

Competiciones que juega

Apertura Uruguay

RIVALES EN Apertura Uruguay

RIVALES EN Copa Uruguay