4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rioja Juniors
TEMPORADA 2023/2024
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 1
Equipo PJ GF GC Puntos
1 Rioja Juniors Rioja 6 8 3 15
2 Defensores de Boca Defensores 6 8 3 12
3 Los Andes De Los Sarmiento Andes 6 3 5 6
4 Defensores de la Plata Defensores 6 2 10 3
5 Barrio Argentino Barrio 6 13 7 10
6 Américo Tesorieri Américo 6 11 10 10
7 San Martín De Villa Unión Martín 6 6 6 9
8 Facundo Villa Unión Facundo 6 9 16 6
9 Andino Andino 4 7 0 8
10 Deportivo Malanzán Deportivo 4 3 1 8
11 Federación Agraria Argentin Federación 4 1 10 0
12 San Lorenzo Alem Lorenzo Alem 4 11 0 12
13 Ferrocarril del Estado Chum Ferrocarril 4 3 5 6
14 Atlético Tapso Atlético 4 1 10 0
15 Villa Cubas Villa Cubas 6 12 7 13
16 Coronel Daza Coronel Daza 6 11 6 12
17 Sportivo Villa Dolores Sportivo 6 6 11 6
18 San Martín De El Bañado Martín 6 7 12 4
19 San Lorenzo Huachaschi Lorenzo 6 11 4 14
20 Boulevard Norte Boulevard 6 10 3 13
21 River Unido el Pajonal River Unido 6 7 14 4
22 Racing Belen Racing Belen 6 5 12 3
23 Alumni Villa Maria Alumni Villa 6 9 5 12
24 Sarmiento Leones Sarmiento 6 9 5 12
25 Unión Alicia Unión 6 6 8 7
26 Almafuerte Varillas Almafuerte 6 4 10 4
27 Deportivo Colón Deportivo 6 6 3 10
28 Deportivo Comercio Deportivo 5 6 2 9
29 Sportivo Forchieri Sportivo 5 3 4 5
30 Bernardino Rivadavia Bernardino 6 2 8 5
31 Atlético Las Palmas Atlético 6 12 3 12
32 Universitario de Cordoba Universitari 6 13 6 9
33 Unión Oncativo Unión 6 3 9 7
34 Vélez Oliva Vélez Oliva 6 6 16 3
35 General Paz Juniors General 4 3 1 6
36 Deportivo Brinkmann Deportivo 4 3 3 4
37 Tiro Federal Morteros Tiro Federal 4 2 4 3
38 Lautaro Roncedo Lautaro 4 9 3 10
39 Belgrano Berrotarán Belgrano 4 6 8 6
40 Cultural Alberdi Cultural 4 2 6 1
41 9 de Julio Rio Tercero Julio 6 10 3 13
42 Gutierrez la Palestina Gutierrez 6 11 7 8
43 Talleres Etruria Talleres 6 7 9 7
44 Vecinos Unidos Vecinos 6 3 12 5
45 Atlético Lambert Atlético 6 10 5 13
46 Toro Toro 6 12 8 13
47 Deportivo Municipal AM Deportivo 6 10 9 7
48 Villa Plomo Serrano Villa Plomo 6 3 13 1
49 Tintina Tintina 4 5 3 7
50 Platense Añatuya Platense 3 3 4 4
51 Ensenada Quimili Ensenada 3 3 4 3
52 Unión Santiago Unión 6 8 2 11
53 Vélez de San Ramón Vélez 6 10 6 10
54 25 de Mayo Termas Mayo Termas 6 7 11 7
55 Atlético Los Dorados Atlético 6 5 11 5
56 Sarmiento La Banda Sarmiento 6 20 1 16
57 Comercio Central Unidos Comercio 6 6 4 13
58 San Jose del Boqueron Jose 6 2 12 4
59 Fida el Arenal Fida Arenal 6 0 11 1
60 Sportivo Fernández Sportivo 4 7 2 12
61 Independiente Fernández Independient 4 8 7 4
62 Instituto Tráfico Instituto 4 3 9 1
TEMPORADA 2019/2020
TORNEO REGIONAL FEDERAL AMATEUR GRUPO 1
Equipo PJ GF GC Puntos
1 Sportivo Fernández Sportivo 6 13 7 13
2 Unión Santiago Unión 6 15 7 10
3 Independiente de Beltrán Independient 6 9 10 8
4 La Costanera Costanera 6 6 19 2
5 Vélez de San Ramón Vélez 6 14 3 14
6 Atlético La Quemado Atlético 6 7 11 8
7 Talleres De Nueva Esperanza Talleres 6 10 13 5
8 Tintina Tintina 6 8 12 5
9 San Lorenzo Alem Lorenzo Alem 4 7 2 10
10 Instituto Tráfico Instituto 4 6 7 4
11 Unión Sportiva De Recreo Unión 4 8 12 3
12 San Martín De El Bañado Martín 4 7 4 8
13 Atlético Policial Atlético 4 8 6 5
14 Dep. Bañado de Ovanta Dep. Bañado 4 5 10 2
15 San Lorenzo De Pomán Lorenzo 4 4 2 7
16 Tiro Federal y Gimnasia Tiro Federal 3 3 1 6
17 Peñarol De Belén Peñarol 3 1 5 1
18 San Martín De Villa Unión Martín 6 8 5 10
19 Los Andes De Los Sarmiento Andes 6 13 8 9
20 San Buenaventura Buenaventura 6 9 11 6
21 Federación Agraria Argentin Federación 6 5 11 4
22 Andino Andino 6 14 7 14
23 Américo Tesorieri Américo 5 11 9 7
24 Rioja Juniors Rioja 6 7 11 4
25 Barrio Argentino Barrio 5 5 10 2
26 Argentino Peñarol Argentino 6 13 2 14
27 Sportivo Colonia Tirolesa Sportivo 6 15 11 10
28 Deportivo Comercio Deportivo 6 6 6 9
29 Independiente De Cosquín Independient 6 7 22 0
30 Belgrano Vicuña Mackenna Belgrano 6 12 7 11
31 CSyB Atenas CSyB Atenas 6 11 10 9
32 Sportivo 9 de Julio Sportivo 6 10 10 7
33 Atlético Río Tercero Atlético 6 7 13 5
34 Racing Córdoba Racing 6 13 2 16
35 Atlético Las Palmas Atlético 6 8 6 9
36 9 De Julio Olímpico Julio 6 5 10 4
37 9 de Julio Morteros Julio 6 3 11 4
38 Atlético Bell Atlético 6 11 4 11
39 Sarmiento Leones Sarmiento 6 7 6 10
40 Uniiversitario De Villa Mar Uniiversitar 6 7 8 9
41 Newbery y Everton Newbery 6 6 13 4
42 General Paz Juniors General 6 13 5 10
43 Unión De Oncativo Unión 6 16 13 10
44 Juventud Agrario Juventud 6 11 10 10
45 Defensores De Pilar Defensores 6 11 23 4

  USO DE MEMORIA  
5,946,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1023
Total Execution Time  0.1035
  CADENA URL  
/historico/Rioja-Juniors-Fc
  GET DATOS  
$_GET['/historico/Rioja-Juniors-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0032  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 = 'Rioja-Juniors-Fc' 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=127865 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=127865 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=127865 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 = 74425
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 = 74781
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=127865 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1814 AND type_rel = 3
0.0031  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1814 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0027  SELECT /*53 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 (972114,959057,847992,847587,838566) ORDER BY n.cover_points DESC, update_date DESC
0.0023  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 = '127865' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '127865' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '127865' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027  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 = 74781 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=127865 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 (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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 74781 AND teamId = 127865
0.0037  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 = 74425 AND t.round = 6 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 = '127865' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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 = '127865' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 74425 WHERE rp.league_id = 74425 AND rp.teamId = 127865 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.0021  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 = 74425 WHERE rp.league_id = 74425 AND rp.teamId = 127865 AND (e.action = 4 or e.action = 5) 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 = 74425 WHERE rp.league_id = 74425 AND rp.teamId = 127865 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 = 127865 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0044  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 = 74425 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.0035  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 = 53813 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