4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Los Rios
TEMPORADA 2023/2024
2ª REGIONAL CANTABRIA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Valdáliga Valdáliga 27 74 29 62
2 Valle Lebaniego Valle 27 71 34 58
3 Bezana B Bezana B 26 60 23 57
4 Atco. Mineros B Atco. 27 63 35 53
5 Tropezón B Tropezón B 26 57 33 51
6 Rayo Santa Cruz B Rayo Santa. 26 66 38 47
7 Lope de Vega Lope Vega 27 46 52 43
8 San Martín B Martín 26 39 55 34
9 AD Olimpia AD Olimpia 27 53 48 34
10 CD Los Rios CD Los Rios 27 54 66 34
11 CD Comillas CD Comillas 27 44 50 32
12 Atco. Deva Atco. Deva 27 43 62 32
13 Iguña SD Iguña SD 27 40 48 31
14 Toranzo CD Toranzo CD 27 33 74 16
15 Salla Indivisa Manent Salla 26 34 68 13
16 Santillana B Santillana 26 18 80 8
TEMPORADA 2022/2023
1ª REGIONAL CANTABRIA
Equipo PJ GF GC Puntos
1 Cayón B Cayón B 34 72 41 69
2 FC Miengo FC Miengo 34 73 39 67
3 CD Naval B CD Naval B 33 69 37 65
4 Peña Revilla SD Peña 34 60 29 65
5 SD Solares B Solares 33 78 43 63
6 Santiago Galas Santiago 34 51 44 53
7 Ayrón Club Ayrón Club 34 72 52 52
8 Rio Gandara CD Gandara 34 62 68 51
9 Minerva Fc Minerva Fc 34 62 65 45
10 Escobedo B Escobedo B 33 62 55 44
11 CD Calasanz CD Calasanz 34 45 57 44
12 Marina de Cudeyo Marina 33 50 58 42
13 Atlético España De Cueto Atlético 34 40 47 39
14 Ampuero FC Ampuero FC 34 46 65 39
15 Rinconeda Rinconeda 34 50 70 35
16 Valle Lebaniego Valle 34 46 78 34
17 CD Los Rios CD Los Rios 34 48 83 30
18 Atco. Mineros B Atco. 34 32 87 11
TEMPORADA 2021/2022
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 SD Solares SD Solares 34 69 23 75
2 Revilla Revilla 34 68 30 69
3 SD Gama SD Gama 34 75 42 66
4 Velarde CF Velarde CF 34 72 28 65
5 CD Bezana CD Bezana 34 65 36 62
6 Atlético Mineros Atlético 34 60 48 55
7 CD Ramales CD Ramales 34 59 50 55
8 SD San Martín Arena Martín 34 52 51 52
9 Barquereño Barquereño 34 51 52 51
10 CD Monte CD Monte 34 48 58 47
11 Nueva Montaña Nueva 34 46 52 43
12 Arenas de Frajanas Arenas 34 48 61 39
13 Ribamontán al Mar Ribamontán 34 39 56 39
14 Rinconeda Rinconeda 34 48 67 37
15 FC Miengo FC Miengo 34 44 71 35
16 CD Los Rios CD Los Rios 34 51 86 31
17 Ampuero FC Ampuero FC 34 36 76 18
18 Ayrón Club Ayrón Club 34 31 75 18
TEMPORADA 2020/2021
PREFERENTE CANTABRIA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Naval CD Naval 16 51 7 43
2 Atlético Mineros Atlético 16 35 15 34
3 Velarde CF Velarde CF 16 30 16 27
4 Arenas de Frajanas Arenas 16 21 20 26
5 FC Miengo FC Miengo 16 21 21 21
6 CD Los Rios CD Los Rios 16 24 27 21
7 EMD Santillana Santillana 16 26 29 19
8 EMF Meruelo EMF Meruelo 16 11 36 5
9 Atco. Deva Atco. Deva 16 5 53 4
TEMPORADA 2019/2020
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 Revilla Revilla 25 51 17 53
2 Castro Castro 25 48 21 51
3 Rinconeda Rinconeda 25 46 21 51
4 FC Miengo FC Miengo 24 39 26 46
5 Nueva Montaña Nueva 25 55 39 40
6 Atlético Mineros Atlético 24 38 29 39
7 Noja Noja 25 32 30 36
8 CD Colindres Colindres 25 31 25 35
9 Velarde CF Velarde CF 25 39 35 35
10 CD Naval CD Naval 25 34 39 33
11 SD Gama SD Gama 25 28 31 30
12 Villaescusa SD Villaescusa 25 27 38 29
13 Valle Lebaniego Valle 25 33 50 28
14 EMF Meruelo EMF Meruelo 25 31 45 27
15 EMD Santillana Santillana 25 30 34 24
16 Atco. Deva Atco. Deva 25 28 45 22
17 CD Ramales CD Ramales 25 19 58 17
18 CD Los Rios CD Los Rios 25 23 49 15
TEMPORADA 2018/2019
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 Barquereño Barquereño 34 47 21 67
2 UC Cartes UC Cartes 34 46 25 65
3 Selaya Selaya 34 54 32 64
4 CD Colindres Colindres 34 76 42 64
5 Castro Castro 34 63 34 62
6 Atlético Mineros Atlético 34 61 41 56
7 SD Gama SD Gama 34 62 48 55
8 EMD Santillana Santillana 34 41 52 47
9 Nueva Montaña Nueva 34 49 65 41
10 CD Ramales CD Ramales 34 58 64 41
11 CD Los Rios CD Los Rios 34 46 55 40
12 Valle Lebaniego Valle 34 44 58 39
13 EMF Meruelo EMF Meruelo 34 41 59 38
14 Noja Noja 34 39 48 37
15 Ayrón Club Ayrón Club 34 46 69 37
16 Peña Revilla SD Peña 34 45 56 36
17 CD Monte CD Monte 34 42 60 36
18 Cayón B Cayón B 34 38 69 26
TEMPORADA 2017/2018
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 Revilla Revilla 34 62 27 72
2 SD Torina SD Torina 34 55 27 72
3 Rinconeda Rinconeda 34 61 40 65
4 Ribamontán al Mar Ribamontán 34 49 30 61
5 CD Naval CD Naval 34 51 41 53
6 Valle Lebaniego Valle 34 55 56 45
7 Ayrón Club Ayrón Club 34 46 48 45
8 CD Colindres Colindres 34 42 38 42
9 UC Cartes UC Cartes 34 57 50 42
10 SD Gama SD Gama 34 48 51 41
11 CD Los Rios CD Los Rios 34 56 68 40
12 Cayón B Cayón B 34 53 72 40
13 EMF Meruelo EMF Meruelo 33 42 50 39
14 CD Monte CD Monte 34 42 68 38
15 Nueva Montaña Nueva 34 54 57 37
16 Santoña CF Santoña CF 33 32 52 37
17 Vimenor B Vimenor B 34 28 43 35
18 Internacional FC Santander Internaciona 34 46 61 33
TEMPORADA 2016/2017
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 EMD Santillana Santillana 34 73 22 82
2 Sámano Sámano 34 71 33 77
3 SD Solares SD Solares 34 57 30 67
4 Valle Lebaniego Valle 34 68 52 58
5 CD Naval CD Naval 34 54 42 58
6 Vimenor B Vimenor B 34 52 44 52
7 SD Torina SD Torina 34 58 63 49
8 Nueva Montaña Nueva 34 54 56 48
9 Rinconeda Rinconeda 34 80 69 46
10 CD Los Rios CD Los Rios 34 66 65 43
11 Santoña CF Santoña CF 34 49 56 40
12 SD Gama SD Gama 34 41 56 37
13 Internacional FC Santander Internaciona 34 42 77 35
14 Cayón B Cayón B 34 54 65 34
15 CD Monte CD Monte 34 44 68 34
16 Arenas de Frajanas Arenas 34 47 69 33
17 Noja Noja 34 35 60 31
18 Atlético España De Cueto Atlético 34 47 65 30
TEMPORADA 2015/2016
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 SD Barreda Balompié Barreda 36 76 21 85
2 EMF Meruelo EMF Meruelo 36 66 31 76
3 Velarde CF Velarde CF 36 68 40 68
4 SD Solares SD Solares 36 43 30 63
5 EMD Santillana Santillana 36 66 38 61
6 Nueva Montaña Nueva 36 58 39 57
7 Atlético España De Cueto Atlético 36 59 43 52
8 Noja Noja 36 52 62 50
9 Rinconeda Rinconeda 36 58 49 47
10 Internacional FC Santander Internaciona 35 49 52 44
11 CD Pontejos CD Pontejos 36 49 59 44
12 Arenas de Frajanas Arenas 36 47 64 44
13 Cayón B Cayón B 36 50 71 43
14 Santoña CF Santoña CF 36 48 58 43
15 Minerva Fc Minerva Fc 36 59 67 42
16 CD Los Rios CD Los Rios 35 43 47 42
17 Barquereño Barquereño 36 41 67 35
18 Ribamontán al Mar Ribamontán 36 35 65 29
19 Buelna Buelna 36 25 89 15
TEMPORADA 2014/2015
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 CD Guarnizo CD Guarnizo 34 63 23 85
2 Sámano Sámano 34 69 39 68
3 CD Naval CD Naval 34 49 28 60
4 EMD Santillana Santillana 34 55 39 59
5 Velarde CF Velarde CF 34 61 45 58
6 Barquereño Barquereño 33 64 40 56
7 EMF Meruelo EMF Meruelo 34 50 29 56
8 Reocin Reocin 32 63 47 50
9 Ribamontán al Mar Ribamontán 34 47 53 49
10 Noja Noja 34 40 50 40
11 Rinconeda Rinconeda 33 45 57 38
12 Nueva Montaña Nueva 34 38 61 35
13 SD Solares SD Solares 34 27 36 34
14 CD Los Rios CD Los Rios 34 52 67 34
15 CD Pontejos CD Pontejos 34 29 52 34
16 Minerva Fc Minerva Fc 34 35 67 32
17 SD Torina SD Torina 34 41 65 28
18 SD San Martín Arena Martín 34 36 66 27

  USO DE MEMORIA  
6,041,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1823
Total Execution Time  0.1842
  CADENA URL  
/historico/Los-Rios
  GET DATOS  
$_GET['/historico/Los-Rios']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0035  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 = 'Los-Rios' 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=19025 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=19025 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19025 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=704 AND type_rel = 3
0.0036  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 = '19025' ORDER BY l.year DESC,cat.coefficient DESC
0.0050  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 = '19025' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '19025' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = 73508 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0051  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=19025 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022  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 (73508,68996) 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.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 68996 AND teamId = 19025
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 73508 AND teamId = 19025
0.0068  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 = 73508 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0030  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 = '19025' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0025  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19025' and rp.type = 4
0.0025  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 = '19025' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0026  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 = 73508 WHERE rp.league_id = 73508 AND rp.teamId = 19025 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.0027  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 = 73508 WHERE rp.league_id = 73508 AND rp.teamId = 19025 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 = 73508 WHERE rp.league_id = 73508 AND rp.teamId = 19025 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  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 = 19025 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0047  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 = 68996 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.0048  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 = 63670 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.0031  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 `tables2021` 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 = 58850 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0057  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 = 51274 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 44658 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 `tables2018` 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 = 39193 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 33972 AND t.round = 34 ORDER BY team.conference 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 `tables2016` 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 = 16698 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 4097 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 73508 ORDER BY nameShow LIMIT 100