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

¿Falta algún dato de este equipo?

Si tienes datos del equipo que no se encuentran en la página nos encantaría que los compartas con nosotros. Un editor de la página validará los datos y en el plazo de tiempo más breve posible completarán los datos actuales con los enviados.

Información sobre Bella Vista

Enviar Datos
Información
Otros Datos
  • Año de Fundación 1920
  • Patrocinador Rinde Dos
  • Patrocinador Secundario Iara - Antel
  • Marca de Ropa Matgeor
Internet

Información sobre el estadio

  • Nombre del estadio Parque José Nasazzi
  • Capacidad 15000
  • Dirección Avda. Agraciada 3100
  • Teléfono 2203 0615
  • Año de construcción 1929
Parque José Nasazzi

Partidos del Bella Vista

Ir al LIVESCORE
Apertura Uruguay Apertura Uruguay »
29 Jun 03  Finalizado Bella Vista Bella Vista
1 - 2
 Tacuarembó FC Tacuarembó FC 0
22 Jun 03  Finalizado Fénix Fénix
3 - 1
 Bella Vista Bella Vista 0
15 Jun 03  Finalizado Bella Vista Bella Vista
0 - 2
 Defensor Sporting Defensor Sporting 0
01 Jun 03  Finalizado Bella Vista Bella Vista
1 - 0
 Central Español FC Central Español FC 0
25 May 03  Finalizado Danubio Danubio
1 - 0
 Bella Vista Bella Vista 0
18 May 03  Finalizado Plaza Colonia Plaza Colonia
1 - 1
 Bella Vista Bella Vista 0
11 May 03  Finalizado Bella Vista Bella Vista
1 - 0
 Deportivo Colonia Deportivo Colonia 0
03 May 03  Finalizado Liverpool Montevideo Liverpool Montevideo
1 - 0
 Bella Vista Bella Vista 0
30 Abr 03  Finalizado Bella Vista Bella Vista
0 - 3
 Nacional Nacional 0
20 Abr 03  Finalizado Bella Vista Bella Vista
5 - 0
 Deportivo Maldonado Deportivo Maldonado 0
15 Abr 03  Finalizado Peñarol Peñarol
1 - 0
 Bella Vista Bella Vista 0
06 Abr 03  Finalizado River Plate Montevideo River Plate Montevideo
2 - 4
 Bella Vista Bella Vista 0
22 Mar 03  Finalizado Bella Vista Bella Vista
6 - 0
 Juventud Juventud 0
16 Mar 03  Finalizado CSyD Villa Española CSyD Villa Española
1 - 2
 Bella Vista Bella Vista 0
09 Mar 03  Finalizado Bella Vista Bella Vista
0 - 4
 Miramar Misiones Miramar Misiones 0
02 Mar 03  Finalizado Bella Vista Bella Vista
0 - 0
 Cerro CA Cerro CA 0
23 Feb 03  Finalizado Montevideo Wanderers Montevideo Wanderers
1 - 1
 Bella Vista Bella Vista 0
Clausura Uruguay Clausura Uruguay »
30 Nov 03  Finalizado Tacuarembó FC Tacuarembó FC
2 - 3
 Bella Vista Bella Vista 0
27 Nov 03  Finalizado Bella Vista Bella Vista
2 - 0
 Fénix Fénix 0
23 Nov 03  Finalizado Defensor Sporting Defensor Sporting
1 - 1
 Bella Vista Bella Vista 0
08 Nov 03  Finalizado Central Español FC Central Español FC
0 - 1
 Bella Vista Bella Vista 0
01 Nov 03  Finalizado Bella Vista Bella Vista
1 - 2
 Danubio Danubio 0
26 Oct 03  Finalizado Bella Vista Bella Vista
3 - 3
 Plaza Colonia Plaza Colonia 0
19 Oct 03  Finalizado Deportivo Colonia Deportivo Colonia
1 - 0
 Bella Vista Bella Vista 0
11 Oct 03  Finalizado Bella Vista Bella Vista
1 - 2
 Liverpool Montevideo Liverpool Montevideo 0
04 Oct 03  Finalizado Nacional Nacional
2 - 3
 Bella Vista Bella Vista 0
28 Sep 03  Finalizado Deportivo Maldonado Deportivo Maldonado
0 - 0
 Bella Vista Bella Vista 0
20 Sep 03  Finalizado Bella Vista Bella Vista
2 - 2
 Peñarol Peñarol 0
14 Sep 03  Finalizado Bella Vista Bella Vista
1 - 1
 River Plate Montevideo River Plate Montevideo 0
31 Ago 03  Finalizado Juventud Juventud
1 - 2
 Bella Vista Bella Vista 0
17 Ago 03  Finalizado Bella Vista Bella Vista
1 - 4
 CSyD Villa Española CSyD Villa Española 0
03 Ago 03  Finalizado Miramar Misiones Miramar Misiones
0 - 1
 Bella Vista Bella Vista 0
27 Jul 03  Finalizado Cerro CA Cerro CA
0 - 1
 Bella Vista Bella Vista 0
19 Jul 03  Finalizado Bella Vista Bella Vista
0 - 1
 Montevideo Wanderers Montevideo Wanderers 0

Noticias de Apertura Uruguay

Ver últimas noticias

Uruguay suspende su liga tras la agresión a un árbitro

BeSoccer - Lunes, 18 Marzo 2024
4 2.598

El Campeonato Uruguayo ha quedado suspendido de manera indefinida después de la agresión que sufrió este sábado un colegiado en el Racing-Peñarol.

El Istanbul Basaksehir se une al City Football Group

BeSoccer - Domingo, 18 Febrero 2024
9 13.065

El Istanbul Basaksehir anunció que ha llegado a un acuerdo con el City Football Group, que opera con clubes como el Manchester City o el Girona bajo su propiedad, en calidad de socio para "estrategia futbolística, planificación y sostenibilidad a largo plazo". La plataforma, de dueños emiratíes, enjuaga así sus relaciones institucionales con Turquía en un nivel diplomático para sus magnates y a uno deportivo para los integrantes de su estructura futbolística.

Xisco Jiménez anuncia su retirada

Juanma Velasco - Lunes, 29 Enero 2024
4 7.885

El jugador mallorquín Xisco Jiménez comunicó la tarde de este lunes su retirada del fútbol a los 37 años. El ya ex delantero, que formaba parte de la plantilla del Atlético Baleares, cuelga las botas tras más de 18 años de carrera.

Peñarol eliminó a Liverpool en 'semis' y jugará la final ¡contra Liverpool!

Carlos Torregrosa - Martes, 12 Diciembre 2023
5 8.634

En el fútbol uruguayo, Peñarol y Liverpool Montevideo se enfrentaron en una semifinal bastante insólita. Si la ganaban los negriazules, serían campeones del Campeonato Uruguayo 2023. Pero si eran los vencedores los aurinegros, como así fue, forzarían una final a doble partido ¡ante el mismo rival!

OFICIAL: Diego Godín cuelga las botas

Cristina Serrano de la Cruz - Lunes, 31 Julio 2023
13 8.789

Diego Godín dice basta. El uruguayo pone punto y final a su trayectoria deportiva a los 37 años, tras haber jugado en Cerro, Nacional, Villarreal, Atlético de Madrid, Inter, Cagliari, Atlético Mineiro y Vélez Sarsfield.

Ver más noticias del equipo»



  USO DE MEMORIA  
5,208,136 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1620
Total Execution Time  0.1639
  CADENA URL  
/Ca-Bella-Vista/2003
  GET DATOS  
$_GET['/Ca-Bella-Vista/2003']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0018  SELECT type FROM routes WHERE alias = 'ca-bella-vista'
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 = 'Ca-Bella-Vista' AND l.year = 2003 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=581 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=581 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=581 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 = 13533
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 = 13538
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=581 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 = '581' ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '581' AND l.year = 2003 ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '581' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 13538 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 13533 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2003 as c ON c.league_id = l.id WHERE (c.datateam1 = 581 or c.datateam2 = 581) AND l.year = 2003 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0029  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2003 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 581 or c.datateam2 = 581) AND l.year = 2003 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0022  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2003 as c ON c.league_id = l.id INNER JOIN events2003 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 581 or c.datateam2 = 581) AND l.year = 2003)
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=581 AND l.year in (2002,2003,2004) 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 (27665,13538) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 27665 AND teamId = 581
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 13538 AND teamId = 581
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 FROM `tables2003` 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 = 13533 AND t.round = 17 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 = '581' 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 = '581' 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 = '581' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2003 e ON e.player_id = p.id AND e.league_id = 13533 WHERE rp.league_id = 13533 AND rp.teamId = 581 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.0018  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 events2003 e ON e.player_id = p.id AND e.league_id = 13533 WHERE rp.league_id = 13533 AND rp.teamId = 581 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0018  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 events2003 e ON e.player_id = p.id AND e.league_id = 13533 WHERE rp.league_id = 13533 AND rp.teamId = 581 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 581 AND rp.league_id = 13533 AND l.year= 2003 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0018  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 581 AND rp.league_id = 13533 AND l.year= 2003 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0019  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 = 13533 ORDER BY nameShow LIMIT 100
0.0023  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 46 AND l.year = 2003 ORDER BY l.group_code ASC