4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Uruguay Montevideo

Uruguay Montevideo

Entrenador: Mario Szlafmyc

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA DIVISIÓN URUGUAY GRUPO 1
Equipo PJ GF GC Puntos
1 Juventud Juventud 6 10 6 13
2 Albion FC Albion FC 6 7 3 11
3 Tacuarembó FC Tacuarembó 6 8 5 11
4 Oriental Oriental 6 11 10 10
5 Uruguay Montevideo Uruguay 6 7 8 6
6 La Luz FC La Luz FC 6 2 5 6
7 Sud América América 6 2 10 3
8 Montevideo City Torque Montevideo 6 9 2 14
9 Rentistas Rentistas 6 4 3 10
10 Plaza Colonia Plaza 6 7 8 8
11 Colón FC Colón FC 6 5 7 8
12 Cerrito Cerrito 6 4 4 7
13 CSyD Cooper CSyD Cooper 6 6 8 5
14 Atenas Atenas 6 3 6 3
TEMPORADA 2022/2023
SEGUNDA DIVISIÓN URUGUAY GRUPO 3
Equipo PJ GF GC Puntos
1 Miramar Misiones Miramar 32 52 24 66
2 Progreso Progreso 32 60 36 65
3 Uruguay Montevideo Uruguay 32 47 33 56
4 Juventud Juventud 32 38 30 51
5 Rentistas Rentistas 32 39 27 47
6 Rampla Juniors Rampla 32 41 32 47
7 Oriental Oriental 32 40 39 47
8 Cerrito Cerrito 32 38 56 41
9 Albion FC Albion FC 32 44 41 41
10 Atenas Atenas 32 26 32 40
11 Tacuarembó FC Tacuarembó 32 43 49 39
12 Bella Vista Bella Vista 32 24 48 29
13 Sud América América 32 26 45 26
14 Potencia Potencia 32 24 50 21
TEMPORADA 2021/2022
SEGUNDA DIVISIÓN URUGUAY GRUPO 3
Equipo PJ GF GC Puntos
1 Racing Montevideo Racing 27 40 18 57
2 La Luz FC La Luz FC 27 35 23 51
3 Uruguay Montevideo Uruguay 27 35 29 44
4 Cerro CA Cerro CA 27 31 30 41
5 Miramar Misiones Miramar 27 38 32 40
6 Rampla Juniors Rampla 27 32 31 35
7 Sud América América 27 27 38 33
8 Atenas Atenas 27 24 25 32
9 Progreso Progreso 27 23 27 31
10 Juventud Juventud 27 19 28 27
11 CSyD Villa Española CSyD Villa. 27 27 37 27
12 Central Español FC Central 27 22 35 22
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN URUGUAY GRUPO 1
Equipo PJ GF GC Puntos
1 Albion FC Albion FC 22 31 18 44
2 Danubio Danubio 22 24 14 41
3 Racing Montevideo Racing 22 27 16 38
4 Defensor Sporting Defensor 22 33 21 37
5 Cerro CA Cerro CA 22 26 20 37
6 Central Español FC Central 22 29 29 33
7 Juventud Juventud 22 27 27 29
8 Uruguay Montevideo Uruguay 22 21 27 25
9 Atenas Atenas 22 20 17 24
10 Rampla Juniors Rampla 22 14 32 21
11 Villa Teresa Villa Teresa 22 17 32 18
12 Rocha FC Rocha FC 22 20 36 15
TEMPORADA 2016/2017
PRIMERA AMATEUR URUGUAY - CLAUSURA GRUPO 1
Equipo PJ GF GC Puntos
1 Colón FC Colón FC 7 10 5 16
2 Bella Vista Bella Vista 7 12 8 15
3 Albion FC Albion FC 7 19 9 14
4 Potencia Potencia 7 14 11 11
5 Parque del Plata Parque Plata 7 10 10 10
6 Uruguay Montevideo Uruguay 7 11 15 6
7 Artigas Artigas 7 5 9 4
8 Los Halcones Halcones 7 5 19 2
9 Platense Platense 6 10 2 14
10 Basáñez Basáñez 6 17 7 13
11 La Luz FC La Luz FC 6 7 8 10
12 Salus Salus 6 6 6 9
13 Rocha FC Rocha FC 6 8 7 7
14 Huracán Buceo Huracán 6 7 9 7
15 Alto Perú Alto Perú 6 3 19 0
TEMPORADA 2015/2016
PRIMERA AMATEUR URUGUAY - CLAUSURA
Equipo PJ GF GC Puntos
1 Cerrito Cerrito 6 5 1 12
2 Uruguay Montevideo Uruguay 6 8 7 8
3 Basáñez Basáñez 6 6 6 7
4 Colón FC Colón FC 6 7 12 2
TEMPORADA 2007/2008
SEGUNDA URUGUAY - APERTURA
Equipo PJ GF GC Puntos
1 Racing Montevideo Racing 17 43 5 47
2 Cerro Largo Cerro Largo 17 29 16 39
3 Atenas Atenas 17 28 20 32
4 Basáñez Basáñez 17 28 21 30
5 Plaza Colonia Plaza 17 17 16 26
6 El Tanque Sisley Tanque 16 22 22 26
7 Durazno FC Durazno FC 17 27 22 25
8 CSyD Villa Española CSyD Villa. 17 33 32 24
9 Cerrito Cerrito 17 22 18 23
10 Deportivo Maldonado Deportivo 17 26 24 23
11 Rocha FC Rocha FC 17 24 27 23
12 Boston River Boston River 17 23 28 19
13 Sud América América 17 12 20 17
14 Rentistas Rentistas 16 14 21 16
15 Huracán Buceo Huracán 17 16 31 15
16 La Luz FC La Luz FC 16 15 26 14
17 Platense Platense 16 15 27 14
18 Uruguay Montevideo Uruguay 17 12 30 10
TEMPORADA 2006/2007
SEGUNDA URUGUAY - APERTURA
Equipo PJ GF GC Puntos
1 Fénix Fénix 16 25 13 36
2 Cerro CA Cerro CA 14 25 9 32
3 Cerro Largo Cerro Largo 14 23 13 29
4 Deportivo Maldonado Deportivo 14 22 12 24
5 Uruguay Montevideo Uruguay 16 25 24 24
6 Atenas Atenas 15 20 17 23
7 Plaza Colonia Plaza 15 14 11 22
8 Juventud Juventud 16 14 13 21
9 Basáñez Basáñez 15 15 13 20
10 La Luz FC La Luz FC 15 17 17 18
11 Sud América América 15 16 17 18
12 Durazno FC Durazno FC 16 26 32 14
13 El Tanque Sisley Tanque 15 13 24 14
14 Paysandú FC Paysandú 15 22 36 13
15 Platense Platense 15 11 17 11
16 Racing Montevideo Racing 14 3 23 3

  USO DE MEMORIA  
5,620,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1056
Total Execution Time  0.1068
  CADENA URL  
/historico/Uruguay-Montevideo
  GET DATOS  
$_GET['/historico/Uruguay-Montevideo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0029  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 = 'Uruguay-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.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=63482 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=63482 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=63482 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=63482 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 75923
0.0025  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=63482 AND type_rel = 2
0.0028  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 = '63482' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0029  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 = '63482' 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,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 = 75923 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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=63482 AND l.year in (2023,2024,2025) 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 (75923,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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 75923 AND teamId = 63482
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 73584 AND teamId = 63482
0.0019  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 = 75923 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '63482' 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 = '63482' and rp.type = 4
0.0021  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 = '63482' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 75923 WHERE rp.league_id = 75923 AND rp.teamId = 63482 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 75923 WHERE rp.league_id = 75923 AND rp.teamId = 63482 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 75923 WHERE rp.league_id = 75923 AND rp.teamId = 63482 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 63482 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.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 `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.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 = 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.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 `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 = 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 `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 = 40295 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 `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 = 20710 AND t.round = 6 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 = 14399 AND t.round = 17 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 `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 = 14402 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC