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

Resultados de Fútbol

Juventud

Entrenador: Juan Carrasco

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA DIVISIÓN URUGUAY
Equipo		PJ	GF	GC	Puntos
1	Juventud	6	10	6	13
2	Albion FC	6	7	3	11
3	Tacuarembó	5	6	3	10
4	Oriental	5	9	8	9
5	Uruguay	6	7	8	6
6	La Luz FC	6	2	5	6
7	América	6	2	10	3
8	Montevideo	6	9	2	14
9	Rentistas	6	4	3	10
10	Plaza	6	7	8	8
11	Colón FC	6	5	7	8
12	Cerrito	6	4	4	7
13	CSyD Cooper	6	6	8	5
14	Atenas	6	3	6	3

TEMPORADA 2022/2023

SEGUNDA DIVISIÓN URUGUAY GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Progreso	6	11	2	14
2	Rampla	6	10	6	13
3	Oriental	6	8	4	10
4	Albion FC	6	8	12	7
5	América	6	7	10	6
6	Uruguay	6	5	9	6
7	Atenas	6	3	9	4
8	Juventud	6	9	2	13
9	Miramar	6	12	8	12
10	Rentistas	6	7	3	11
11	Bella Vista	6	7	8	7
12	Potencia	6	8	12	5
13	Cerrito	6	5	10	5
14	Tacuarembó	6	8	13	4

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

SEGUNDA DIVISIÓN URUGUAY GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Albion FC	22	31	18	44
2	Danubio	22	24	14	41
3	Racing	22	27	16	38
4	Defensor	22	33	21	37
5	Cerro CA	22	26	20	37
6	Central	22	29	29	33
7	Juventud	22	27	27	29
8	Uruguay	22	21	27	25
9	Atenas	22	20	17	24
10	Rampla	22	14	32	21
11	Villa Teresa	22	17	32	18
12	Rocha FC	22	20	36	15

TEMPORADA 2019/2020

SEGUNDA DIVISIÓN URUGUAY GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Cerrito	22	38	23	41
2	CSyD Villa.	22	35	24	37
3	Juventud	22	24	17	32
4	Rampla	22	27	23	32
5	Racing	22	25	26	30
6	América	22	30	33	28
7	Central	22	25	25	27
8	Rocha FC	22	20	23	27
9	Villa Teresa	22	19	29	26
10	Atenas	22	23	29	24
11	Tacuarembó	22	19	27	23
12	Albion FC	22	22	28	22

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

SEGUNDA DIVISIÓN URUGUAY
Equipo		PJ	GF	GC	Puntos
1	Cerro Largo	26	33	16	51
2	Juventud	26	46	24	50
3	Plaza	26	35	28	44
4	Cerrito	26	30	37	37
5	Villa Teresa	26	39	31	36
6	Tacuarembó	26	33	32	35
7	Deportivo	26	32	27	35
8	América	26	32	30	35
9	Central	26	30	31	32
10	CSyD Villa.	26	32	40	29
11	Rentistas	26	31	43	28
12	Albion FC	26	27	36	27
13	Miramar	26	26	41	26
14	Oriental	26	29	39	24

TEMPORADA 2016/2017

CLAUSURA URUGUAY GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Peñarol	15	39	7	42
2	Defensor	15	27	17	33
3	Nacional	15	29	15	29
4	River Plate	15	23	16	24
5	América	15	26	24	22
6	Danubio	15	18	24	20
7	Cerro CA	15	17	24	20
8	Boston River	15	13	15	19
9	Rampla	15	15	19	18
10	Fénix	15	17	17	17
11	Liverpool	15	23	25	17
12	Racing	15	18	22	17
13	Montevideo	15	21	26	16
14	Tanque	15	15	22	16
15	Juventud	15	14	28	11
16	Plaza	15	12	26	9

TEMPORADA 2015/2016

TORNEO DE TRANSICIÓN URUGUAY
Equipo		PJ	GF	GC	Puntos
1	Nacional	15	27	12	34
2	Montevideo	15	22	14	29
3	Danubio	15	24	19	29
4	Defensor	15	22	15	25
5	Liverpool	15	16	13	24
6	Boston River	15	19	11	22
7	Cerro CA	15	16	15	22
8	Racing	15	24	26	20
9	Fénix	15	19	19	19
10	River Plate	15	18	28	18
11	Juventud	15	9	11	17
12	América	15	17	20	17
13	Rampla	15	9	16	17
14	Peñarol	15	17	20	15
15	Plaza	15	16	24	12
16	CSyD Villa.	15	14	26	7

TEMPORADA 2014/2015

CLAUSURA URUGUAY
Equipo		PJ	GF	GC	Puntos
1	Peñarol	15	28	13	31
2	River Plate	15	30	17	29
3	Defensor	15	20	16	27
4	Danubio	15	17	12	26
5	Juventud	15	25	17	25
6	Tacuarembó	15	23	22	24
7	Cerro CA	15	21	23	24
8	América	15	19	19	22
9	Nacional	15	24	21	21
10	Fénix	15	18	16	20
11	Tanque	15	17	25	16
12	Montevideo	15	19	18	15
13	Atenas	15	27	37	14
14	Rampla	15	18	28	14
15	Rentistas	15	16	27	14
16	Racing	15	17	28	13

TEMPORADA 2013/2014

APERTURA URUGUAY
Equipo		PJ	GF	GC	Puntos
1	River Plate	16	33	18	34
2	Danubio	15	24	13	32
3	Nacional	15	29	18	30
4	Montevideo	16	26	18	30
5	Rentistas	18	26	28	29
6	Tanque	16	22	17	24
7	Liverpool	16	18	16	22
8	Peñarol	16	25	23	19
9	Cerro Largo	16	20	25	19
10	Cerro CA	15	21	25	17
11	América	15	16	21	17
12	Defensor	16	23	28	16
13	Fénix	15	18	20	15
14	Racing	15	18	23	15
15	Juventud	16	21	30	14
16	Miramar	16	12	29	13

Competiciones que juega

Segunda División Uruguay

Pos	Equipos		Pts
1		Montevideo City Torque	14
2		Juventud	13
3		Albion FC	11
4		Tacuarembó FC	10
5		Rentistas	10
6		Oriental	9
7		Plaza Colonia	8
8		Colón FC	8
9		Cerrito	7
10		Uruguay Montevideo	6
11		La Luz FC	6
12		CSyD Cooper	5
13		Atenas	3
14		Sud América	3

	Series Finales : Montevideo City Torque

RIVALES EN Copa Uruguay

RIVALES EN Segunda División.

USO DE MEMORIA

6,197,192 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1353
Total Execution Time	0.1366

CADENA URL

/historico/Juventud

GET DATOS

$_GET['/historico/Juventud']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0028	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 = 'Juventud' 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.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=1426 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=1426 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=1426 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042	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 = 75545
0.0026	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 = 73584
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1426 AND type_rel = 2
0.0019	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1426 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	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 (6462,6464,8061,8203,8602) ORDER BY n.cover_points DESC, update_date 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 = '1426' 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 = '1426' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	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 = 73584 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019	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 = 75545 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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=1426 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (75545,73584) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 75545 AND teamId = 1426
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 73584 AND teamId = 1426
0.0032	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 = 75545 WHERE rp.league_id = 75545 AND rp.teamId = 1426 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.0026	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 = 75545 WHERE rp.league_id = 75545 AND rp.teamId = 1426 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 75545 WHERE rp.league_id = 75545 AND rp.teamId = 1426 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 = 1426 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 75545 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.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* `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.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 = 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.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 = 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 = 62797 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.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* `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 = 55517 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.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 = 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.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* `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.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 = 42967 AND t.round = 26 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* `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 = 37744 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* `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 = 38472 AND t.round = 7 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* `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 = 39306 AND t.round = 15 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 = 15472 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* `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 = 20175 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* `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 = 34701 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* `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 = 4058 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* `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 = 9063 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* `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 = 3281 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

Juventud

Juventud

Selecciona un equipo

Competiciones que juega

Segunda División Uruguay

RIVALES EN Copa Uruguay

RIVALES EN Segunda División.