4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bella Vista Tucuman
TEMPORADA 2023/2024
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 5
Equipo PJ GF GC Puntos
1 Graneros Graneros 6 9 4 11
2 Concepción FC Concepción 6 8 6 10
3 Deportivo Llorens Deportivo 6 8 12 9
4 Sportivo Guzmán Sportivo 6 6 9 4
5 Bella Vista Tucuman Bella Vista 6 12 6 13
6 Atlético San Pablo Atlético 6 6 5 9
7 SD La Florida Florida 6 5 6 8
8 Atlético Concepción Atlético 6 3 9 2
9 Altos Hornos Zapla Altos Hornos 4 17 0 12
10 Racing Ojo de Agua Racing Agua 4 3 9 6
11 Def. Belgrano Tilcara Def. 4 1 12 0
12 Talleres Perico Talleres 4 8 1 10
13 Atletico San Pedro Atletico 4 8 2 7
14 La Mona 44 La Mona 44 4 0 13 0
15 Herminio Arrieta Herminio 4 8 6 7
16 Tiro Gimnasia San Pedro Tiro 4 7 8 6
17 Defensores de Yuto Defensores 4 6 7 4
18 Camioneros Argentinos Camioneros 6 10 2 14
19 Juventud Unida Juventud 6 2 1 9
20 Libertad De San Carlos Libertad 6 4 10 5
21 San Agustín Agustín 6 5 8 3
22 La Merced Salta Merced Salta 6 8 0 12
23 Villa San Antonio Villa 6 8 3 11
24 Atlético Chicoana Atlético 6 3 7 7
25 Mitre de Salta Mitre Salta 6 3 12 3
26 Talleres de Metán Talleres 6 9 1 15
27 Atlético General Guemes Atlético 6 11 4 10
28 Deportivo YPF Deportivo 6 6 8 8
29 Deportivo San Antonio Deportivo 6 2 15 1
30 Sportivo Pocitos Sportivo 6 17 1 16
31 Aviación Aviación 6 6 9 9
32 Independiente HY Independient 6 6 13 6
33 Boroquímica Boroquímica 6 3 9 4
TEMPORADA 2021/2022
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 7
Equipo PJ GF GC Puntos
1 Concepción El Cóndor Concepción 4 5 4 7
2 Deportivo Santa Catalina Deportivo 4 4 4 5
3 Terry Terry 4 4 5 4
4 Gimnasia y Tiro Orán Gimnasia 6 9 7 9
5 Sportivo Alberdi Sportivo 6 12 9 7
6 Def. Fraile Pintado Def. Fraile 6 8 7 7
7 Unión Madereros Unión 6 6 12 6
8 Altos Hornos Zapla Altos Hornos 6 6 4 11
9 Talleres Perico Talleres 6 10 6 10
10 Ciudad de Nieva Ciudad Nieva 6 10 9 7
11 Monterrico San Vicente Monterrico 6 2 9 5
12 Redes De La Patria Redes Patria 4 5 3 6
13 Atletico San Pedro Atletico 4 5 4 6
14 Tiro Gimnasia San Pedro Tiro 4 3 6 2
15 Juventud Unida Juventud 6 11 1 14
16 San Martín Salta Martín 6 16 5 12
17 San Agustín Agustín 6 10 7 7
18 San Isidro San Isidro 6 2 26 0
19 Juventud Antoniana Juventud 6 10 2 12
20 Villa San Antonio Villa 6 4 7 8
21 Deportivo YPF Deportivo 6 5 7 7
22 La Merced Salta Merced Salta 6 6 9 4
23 Talleres de Metán Talleres 6 15 7 10
24 Atletico Normal Rosarino Atletico 6 10 11 9
25 Atletico Barrio Obrero Atletico 6 10 13 6
26 Deportivo El Galpon Deportivo 6 6 10 4
27 Bella Vista Tucuman Bella Vista 6 10 3 13
28 Unión del Norte Unión Norte 6 10 6 10
29 Deportivo Llorens Deportivo 5 4 6 5
30 Atlético Amalia Atlético 5 4 13 3
TEMPORADA 2018/2019
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 3
Equipo PJ GF GC Puntos
1 Monterrico San Vicente Monterrico 10 25 11 22
2 AA La Viña AA La Viña 10 26 13 19
3 Atletico Cuyaya Atletico 10 21 16 19
4 Racing Ojo de Agua Racing Agua 10 37 23 16
5 Sportivo Santa Clara Sportivo 10 16 20 10
6 Atletico Inter Atletico 10 11 53 1
7 Talleres Perico Talleres 8 16 9 17
8 Atletico San Pedro Atletico 8 17 8 15
9 San Francisco Bancario Francisco 8 14 9 14
10 Tiro Gimnasia San Pedro Tiro 8 11 19 5
11 Mitre Calilegua Mitre 8 5 18 4
12 Central Norte Central 10 29 7 23
13 Atletico Peñarol Atletico 10 16 14 18
14 Villa San Antonio Villa 10 17 11 15
15 Mitre de Salta Mitre Salta 10 14 21 15
16 Olimpia Oriental Olimpia 10 18 25 11
17 Los Cachorros de Salta Cachorros 10 10 26 1
18 Deportivo El Galpon Deportivo 10 27 10 19
19 Atletico Barrio Obrero Atletico 10 10 13 16
20 La Merced Salta Merced Salta 10 20 23 14
21 Atlético Progreso Atlético 10 18 16 12
22 Atletico Normal Rosarino Atletico 10 12 17 10
23 Deportivo YPF Deportivo 10 16 24 10
24 Tabacal Orán Tabacal 8 15 7 19
25 Independiente HY Independient 8 17 12 14
26 River de Embarcacion River 8 13 13 13
27 Roby Manero Roby Manero 8 12 21 7
28 Deportivo Guarani Deportivo 8 13 17 4
29 Atlético Amalia Atlético 6 7 6 11
30 Sportivo Guzmán Sportivo 6 12 8 10
31 Atlético Concepción Atlético 6 8 6 10
32 Bella Vista Tucuman Bella Vista 6 6 13 2
33 Ñuñorco Ñuñorco 8 9 5 15
34 Concepción FC Concepción 8 11 6 14
35 Deportivo Marapa Deportivo 8 12 9 13
36 Deportivo Aguilares Deportivo 8 7 11 8
37 Deportivo Llorens Deportivo 8 5 13 5
TEMPORADA 2016/2017
TORNEO FEDERAL B - TRANSICIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Talleres Perico Talleres 16 20 10 32
2 Mitre de Salta Mitre Salta 16 23 10 31
3 Independiente HP Independient 16 24 15 27
4 Camioneros Argentinos Camioneros 16 19 19 20
5 Def. Fraile Pintado Def. Fraile 16 15 15 19
6 Atlético Pellegrini Atlético 16 16 20 19
7 Tiro y Gimnasia San Pedro Tiro 16 14 19 18
8 Tabacal Orán Tabacal 16 19 22 17
9 ATD Rio Grande Grande 16 12 32 9
10 Central Norte Central 15 35 9 38
11 Almirante Brown de Lules Almirante 14 23 14 27
12 Atlético Progreso Atlético 16 18 27 22
13 CA San Antonio Antonio 15 12 18 20
14 Bella Vista Tucuman Bella Vista 13 14 10 18
15 Sportivo Guzmán Sportivo 15 14 15 16
16 Lastenia Lastenia 16 13 19 16
17 Atlético Amalia Atlético 16 10 18 15
18 Atlético Chicoana Atlético 16 14 23 13
TEMPORADA 2014/2015
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 8
Equipo PJ GF GC Puntos
1 Club Atlético Güemes Club 20 25 9 43
2 Almirante Brown de Lules Almirante 20 34 19 38
3 Villa Cubas Villa Cubas 20 37 21 34
4 Atlético Amalia Atlético 20 29 21 33
5 CD Comercio CD Comercio 20 30 23 33
6 Sportivo Guzmán Sportivo 20 20 18 32
7 Lastenia Lastenia 20 22 18 30
8 Sarmiento La Banda Sarmiento 20 30 27 29
9 Unión Santiago Unión 20 20 17 29
10 Atlético Progreso Atlético 20 17 16 29
11 Juventud Unida Charata Juventud 20 26 31 28
12 Atlético Policial Atlético 20 25 27 27
13 Instituto Santiago Instituto 20 26 28 26
14 Bella Vista Tucuman Bella Vista 20 26 23 25
15 Comercio Central Unidos Comercio 20 27 26 25
16 Deportivo Aguilares Deportivo 20 26 30 24
17 Talleres de Frias Talleres 20 27 32 24
18 Atlético Concepción Atlético 19 15 26 16
19 Club San Carlos Club Carlos 19 19 46 10
20 Famaillá Famaillá 20 8 31 8

  USO DE MEMORIA  
5,949,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0981
Total Execution Time  0.0994
  CADENA URL  
/historico/Bella-Vista-Tucuman
  GET DATOS  
$_GET['/historico/Bella-Vista-Tucuman']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0030  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 = 'Bella-Vista-Tucuman' 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=20710 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=20710 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=20710 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0038  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 = 74435
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20710 AND type_rel = 2
0.0022  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 = '20710' ORDER BY l.year DESC,cat.coefficient DESC
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 = '20710' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '20710' 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 = 74435 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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=20710 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 (74781) 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 = 74781 AND teamId = 20710
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 `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 = 74435 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '20710' 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 = '20710' 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 = '20710' 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 events2024 e ON e.player_id = p.id AND e.league_id = 74435 WHERE rp.league_id = 74435 AND rp.teamId = 20710 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.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 = 74435 WHERE rp.league_id = 74435 AND rp.teamId = 20710 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 74435 WHERE rp.league_id = 74435 AND rp.teamId = 20710 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 20710 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 `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 = 74435 AND t.round = 6 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 = 66005 AND t.round = 6 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 `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 = 49515 AND t.round = 10 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 = 39149 AND t.round = 18 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 = 34129 AND t.round = 18 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 = 4482 AND t.round = 14 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 `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 = 15590 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC