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

Racing Rioja

Entrenador: Guillermo Zangroniz

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 16
Equipo PJ GF GC Puntos
1 UD Logroñés B Logroñés 33 64 19 73
2 CD Alfaro CD Alfaro 33 77 35 73
3 Anguiano Anguiano 33 68 38 65
4 CD Calahorra B Calahorra 33 68 33 64
5 CD Varea CD Varea 33 57 30 58
6 Oyonesa Oyonesa 33 45 28 55
7 Casalarreina Casalarreina 33 56 47 55
8 CD Berceo CD Berceo 33 43 42 47
9 La Calzada La Calzada 33 50 42 45
10 Arnedo Arnedo 33 36 45 42
11 Racing Rioja Racing Rioja 33 37 52 39
12 Peña Balsamaiso CF Peña 33 46 58 39
13 River Ebro River Ebro 33 39 48 38
14 Vianés Vianés 33 30 61 33
15 Haro Deportivo Haro 33 35 50 28
16 CD Tedeón CD Tedeón 33 23 61 27
17 Comillas CF Comillas CF 33 34 54 24
18 Alberite Alberite 33 36 101 17
TEMPORADA 2022/2023
SEGUNDA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Sestao River Sestao River 34 55 17 72
2 Deportivo Alavés B Deportivo 34 40 23 59
3 SD Tarazona SD Tarazona 34 60 37 56
4 Utebo Utebo 34 39 32 53
5 SD Gernika SD Gernika 34 41 31 53
6 Tudelano Tudelano 34 39 32 52
7 Real Sociedad C Real 34 46 42 52
8 AD San Juan AD San Juan 34 33 27 51
9 Arenas de Getxo Arenas Getxo 34 39 42 48
10 Izarra Izarra 34 39 31 48
11 Mutilvera Mutilvera 34 44 37 46
12 Brea Brea 34 27 33 44
13 Beasain KE Beasain KE 34 40 40 41
14 Cirbonero Cirbonero 34 35 40 40
15 CD Alfaro CD Alfaro 34 35 54 34
16 UD Logroñés B Logroñés 34 27 54 32
17 Racing Rioja Racing Rioja 34 27 57 32
18 Arnedo Arnedo 34 28 65 24
TEMPORADA 2021/2022
SEGUNDA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Osasuna Promesas Osasuna 34 72 29 72
2 Sestao River Sestao River 34 53 22 70
3 Real Sociedad C Real 34 55 30 59
4 Rayo Cantabria Rayo 34 42 29 56
5 Arenas de Getxo Arenas Getxo 34 42 25 56
6 AD San Juan AD San Juan 34 47 39 51
7 Racing Rioja Racing Rioja 34 43 39 50
8 SD Gernika SD Gernika 34 50 42 49
9 Burgos CF B Burgos CF B 34 42 33 48
10 Izarra Izarra 34 33 34 45
11 Mutilvera Mutilvera 34 42 45 45
12 UD Logroñés B Logroñés 34 45 39 45
13 CD Laredo CD Laredo 34 41 36 45
14 Cayón Cayón 34 26 60 33
15 Tropezón Tropezón 34 40 68 27
16 Náxara Náxara 34 27 53 26
17 CF Ardoi CF Ardoi 34 29 61 25
18 Peña Sport Peña Sport 34 31 76 18
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 16
Equipo PJ GF GC Puntos
1 CD Alfaro CD Alfaro 20 35 14 45
2 Anguiano Anguiano 20 32 11 44
3 CD Varea CD Varea 20 48 12 41
4 Arnedo Arnedo 20 30 17 36
5 La Calzada La Calzada 20 30 26 27
6 Oyonesa Oyonesa 20 24 22 25
7 CD Berceo CD Berceo 20 26 36 24
8 Vianés Vianés 20 18 22 23
9 Agoncillo Agoncillo 20 29 36 22
10 Comillas CF Comillas CF 20 19 34 20
11 Villegas Villegas 20 7 68 2
12 Racing Rioja Racing Rioja 20 46 14 45
13 UD Logroñés B Logroñés 20 31 18 39
14 Náxara Náxara 20 43 22 39
15 CD Calahorra B Calahorra 20 30 14 35
16 Yagüe Yagüe 20 30 22 31
17 Casalarreina Casalarreina 20 27 26 27
18 River Ebro River Ebro 20 19 26 24
19 CD Tedeón CD Tedeón 20 16 30 22
20 Pradejón Pradejón 20 21 35 16
21 Calasancio Calasancio 20 12 43 13
22 Alberite Alberite 20 14 39 11
TEMPORADA 2019/2020
PREFERENTE LA RIOJA
Equipo PJ GF GC Puntos
1 Racing Rioja Racing Rioja 23 83 12 58
2 Agoncillo Agoncillo 22 53 14 55
3 CD Tedeón CD Tedeón 22 67 19 51
4 Autol Autol 22 66 25 49
5 San Marcial San Marcial 23 54 41 43
6 River Ebro B River Ebro 23 38 22 42
7 Rapid de Murillo Rapid 22 41 33 42
8 Haro Promesas Haro 21 46 29 36
9 Varea B Varea B 23 41 40 32
10 Alfaro B Alfaro B 23 40 49 26
11 Bañuelos Bañuelos 22 32 48 26
12 Cenicero Cenicero 23 36 43 21
13 Peña Balsamaiso CF Peña 22 29 49 17
14 Pradejon B Pradejon B 23 28 78 16
15 CD San Lorenzo Lorenzo 22 26 62 11
16 Aldeano Aldeano 23 20 70 11
17 Calasancio B Calasancio 23 26 92 8
TEMPORADA 2018/2019
PREFERENTE LA RIOJA
Equipo PJ GF GC Puntos
1 CD Calahorra B Calahorra 24 56 17 54
2 Comillas CF Comillas CF 24 47 26 51
3 Casalarreina Casalarreina 24 49 19 50
4 Villegas Villegas 24 40 23 48
5 CD Tedeón CD Tedeón 24 47 25 44
6 Cenicero Cenicero 24 37 23 40
7 Racing Rioja Racing Rioja 24 47 37 35
8 San Marcial San Marcial 24 29 46 27
9 Bañuelos Bañuelos 24 36 46 24
10 Haro Sport Club Haro Sport. 24 44 62 22
11 Aldeano Aldeano 24 30 57 21
12 Alfaro B Alfaro B 24 27 55 21
13 CD San Lorenzo Lorenzo 24 20 73 8

  USO DE MEMORIA  
5,733,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.1297
Total Execution Time  0.1313
  CADENA URL  
/historico/Racing-Rioja-Cf-Senior
  GET DATOS  
$_GET['/historico/Racing-Rioja-Cf-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0067  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 = 'Racing-Rioja-Cf-Senior' 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.0024  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=112849 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=112849 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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=112849 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0051  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 = 72276
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=112849 AND type_rel = 2
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0042  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 = '112849' ORDER BY l.year DESC,cat.coefficient DESC
0.0048  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 = '112849' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0043  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 = '112849' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0041  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=112849 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0027  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 (73168,72276,69563,67966) 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.0037  SELECT count(id) as num_players from rel_players WHERE league_id = 72276 AND teamId = 112849
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 67966 AND teamId = 112849
0.0056  SELECT count(id) as num_players from rel_players WHERE league_id = 69563 AND teamId = 112849
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 73168 AND teamId = 112849
0.0022  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 = '112849' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '112849' and rp.type = 4
0.0022  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 = '112849' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0041  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 = 72276 WHERE rp.league_id = 72276 AND rp.teamId = 112849 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.0034  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 = 72276 WHERE rp.league_id = 72276 AND rp.teamId = 112849 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 72276 WHERE rp.league_id = 72276 AND rp.teamId = 112849 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 112849 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72276 AND t.round = 33 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 = 67966 AND t.round = 34 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 `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 = 62381 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 51283 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0058  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 = 45240 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC