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 »
09 Dic 06  Finalizado Liverpool Montevideo Liverpool Montevideo
2 - 4
 Bella Vista Bella Vista 0
05 Dic 06  Finalizado Bella Vista Bella Vista
2 - 1
 Rampla Juniors Rampla Juniors 0
25 Nov 06  Finalizado Rocha FC Rocha FC
0 - 1
 Bella Vista Bella Vista 0
18 Nov 06  Finalizado Bella Vista Bella Vista
3 - 1
 Montevideo Wanderers Montevideo Wanderers 0
11 Nov 06  Finalizado Rentistas Rentistas
3 - 0
 Bella Vista Bella Vista 0
28 Oct 06  Finalizado Bella Vista Bella Vista
1 - 0
 River Plate Montevideo River Plate Montevideo 0
21 Oct 06  Finalizado Peñarol Peñarol
2 - 1
 Bella Vista Bella Vista 0
14 Oct 06  Finalizado Bella Vista Bella Vista
0 - 2
 Defensor Sporting Defensor Sporting 0
07 Oct 06  Finalizado Tacuarembó FC Tacuarembó FC
0 - 3
 Bella Vista Bella Vista 0
30 Sep 06  Finalizado Bella Vista Bella Vista
3 - 2
 Danubio Danubio 0
16 Sep 06  Finalizado Central Español FC Central Español FC
1 - 0
 Bella Vista Bella Vista 0
09 Sep 06  Finalizado Bella Vista Bella Vista
0 - 0
 Nacional Nacional 0
02 Sep 06  Finalizado Cerrito Cerrito
0 - 2
 Bella Vista Bella Vista 0
26 Ago 06  Finalizado Bella Vista Bella Vista
3 - 0
 Progreso Progreso 0
19 Ago 06  Finalizado Miramar Misiones Miramar Misiones
1 - 2
 Bella Vista Bella Vista 0
Clausura Uruguay Clausura Uruguay »
12 May 07  Finalizado Bella Vista Bella Vista
2 - 1
 Liverpool Montevideo Liverpool Montevideo 0
05 May 07  Finalizado Rampla Juniors Rampla Juniors
2 - 1
 Bella Vista Bella Vista 0
28 Abr 07  Finalizado Bella Vista Bella Vista
4 - 0
 Rocha FC Rocha FC 0
25 Abr 07  Finalizado Montevideo Wanderers Montevideo Wanderers
3 - 1
 Bella Vista Bella Vista 0
21 Abr 07  Finalizado Bella Vista Bella Vista
3 - 2
 Rentistas Rentistas 0
14 Abr 07  Finalizado River Plate Montevideo River Plate Montevideo
3 - 1
 Bella Vista Bella Vista 0
07 Abr 07  Finalizado Bella Vista Bella Vista
2 - 5
 Peñarol Peñarol 0
31 Mar 07  Finalizado Defensor Sporting Defensor Sporting
1 - 0
 Bella Vista Bella Vista 0
17 Mar 07  Finalizado Bella Vista Bella Vista
2 - 0
 Tacuarembó FC Tacuarembó FC 0
14 Mar 07  Finalizado Danubio Danubio
2 - 1
 Bella Vista Bella Vista 0
10 Mar 07  Finalizado Bella Vista Bella Vista
1 - 0
 Central Español FC Central Español FC 0
06 Mar 07  Finalizado Nacional Nacional
1 - 1
 Bella Vista Bella Vista 0
03 Mar 07  Finalizado Cerrito Cerrito
0 - 2
 Bella Vista Bella Vista 0
24 Feb 07  Finalizado Progreso Progreso
2 - 2
 Bella Vista Bella Vista 0
17 Feb 07  Finalizado Bella Vista Bella Vista
0 - 1
 Miramar Misiones Miramar Misiones 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.057

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.882

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.633

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,117,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5341
Total Execution Time  0.5360
  CADENA URL  
/Ca-Bella-Vista/2007
  GET DATOS  
$_GET['/Ca-Bella-Vista/2007']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0125  SELECT type FROM routes WHERE alias = 'ca-bella-vista'
0.0146  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 = 2007 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.0126  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.0125  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.0127  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.0256  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 = 8435
0.0134  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 = 8434
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=581 AND type_rel = 2
0.0132  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 = 2007 ORDER BY l.year DESC,cat.coefficient DESC
0.0133  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.0129  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 = 8434 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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 = 8435 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  (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 calendars2007 as c ON c.league_id = l.id WHERE (c.datateam1 = 581 or c.datateam2 = 581) AND l.year = 2007 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0182  (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 calendars2007 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 = 2007 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0148  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2007 as c ON c.league_id = l.id INNER JOIN events2007 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 = 2007)
0.0149  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 (2006,2007,2008) ORDER BY l.id DESC, l.year DESC ;
0.0131  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 (13536,8435) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 8435 AND teamId = 581
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 13536 AND teamId = 581
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 8435 AND t.round = 15 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0137  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.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '581' and rp.type = 4
0.0126  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.0127  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 events2007 e ON e.player_id = p.id AND e.league_id = 8435 WHERE rp.league_id = 8435 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.0126  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 events2007 e ON e.player_id = p.id AND e.league_id = 8435 WHERE rp.league_id = 8435 AND rp.teamId = 581 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 events2007 e ON e.player_id = p.id AND e.league_id = 8435 WHERE rp.league_id = 8435 AND rp.teamId = 581 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 8435 AND l.year= 2007 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0126  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 = 8435 AND l.year= 2007 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1