4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Naval B
TEMPORADA 2023/2024
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 SD Gama SD Gama 7 6 1 17
2 SD Barreda Balompié Barreda 7 18 7 16
3 SD Textil Escudo Textil 7 10 4 13
4 CD Monte CD Monte 6 9 6 13
5 Peña Revilla SD Peña 7 7 4 11
6 SD San Martín Arena Martín 7 5 6 11
7 Cayón B Cayón B 7 10 10 10
8 Barquereño Barquereño 7 11 7 9
9 EMD Santillana Santillana 7 11 9 9
10 SD Solares B Solares 7 8 7 9
11 Ribamontán al Mar Ribamontán 7 6 4 8
12 FC Miengo FC Miengo 6 9 11 8
13 CD Naval B CD Naval B 7 7 10 6
14 Rayo Santa Cruz Rayo Santa. 7 8 12 6
15 Noja Noja 7 7 11 6
16 Arenas de Frajanas Arenas 7 3 8 6
17 Selaya Selaya 7 6 11 4
18 Estrella Roja Estrella 7 5 18 3
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
2ª REGIONAL CANTABRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Santiago Galas Santiago 28 73 25 66
2 CD Naval B CD Naval B 28 74 31 65
3 Bezana B Bezana B 28 77 33 64
4 Lope de Vega Lope Vega 28 87 33 63
5 AD Olimpia AD Olimpia 28 66 26 54
6 Buelna Buelna 28 61 46 45
7 Castroverde Castroverde 28 83 74 41
8 San Martín B Martín 28 51 51 40
9 CD Comillas CD Comillas 28 59 52 38
10 Rayo Santa Cruz B Rayo Santa. 28 53 57 35
11 Polanco CF Polanco CF 28 43 63 25
12 CD Valdáliga Valdáliga 28 35 58 21
13 Toranzo CD Toranzo CD 28 38 75 20
14 Iguña SD Iguña SD 28 16 87 16
15 Salla Indivisa Manent Salla 28 28 133 10
TEMPORADA 2020/2021
2ª REGIONAL CANTABRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Estrella Roja Estrella 12 34 13 29
2 CD Naval B CD Naval B 13 31 19 26
3 Castroverde Castroverde 12 29 18 26
4 AD Olimpia AD Olimpia 13 29 12 25
5 Rayo Santa Cruz B Rayo Santa. 12 23 13 24
6 Cuevas del Castillo Cuevas 13 21 13 24
7 Lope de Vega Lope Vega 13 18 18 23
8 Bezana B Bezana B 13 32 21 20
9 Toranzo CD Toranzo CD 13 25 21 20
10 At. España de Cueto B España 13 18 28 13
11 Buelna B Buelna B 13 16 38 7
12 CD Valdáliga Valdáliga 12 19 34 5
13 Iguña SD Iguña SD 13 8 23 4
14 Los Rios C Los Rios C 13 12 44 4
TEMPORADA 2019/2020
2ª REGIONAL CANTABRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Estrella Roja Estrella 22 55 20 49
2 SD San Martín Arena Martín 22 43 19 49
3 Atco. Mineros B Atco. 21 63 19 46
4 CD Valdáliga Valdáliga 22 52 28 44
5 Rayo Santa Cruz B Rayo Santa. 22 57 35 44
6 Escobedo B Escobedo B 22 47 31 30
7 CD Liendo CD Liendo 22 34 32 30
8 CD Naval B CD Naval B 21 31 26 26
9 San Justo CD Justo 22 31 58 22
10 Los Rios B Los Rios B 22 18 57 15
11 AD Cubas AD Cubas 22 28 78 13
12 Buelna B Buelna B 22 21 77 6

  USO DE MEMORIA  
5,293,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4208
Total Execution Time  0.4226
  CADENA URL  
/historico/Cd-Naval-B-Senior
  GET DATOS  
$_GET['/historico/Cd-Naval-B-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0157  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 = 'Cd-Naval-B-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.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=122233 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=122233 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=122233 AND type_rel = 2
0.0127  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 = '122233' ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '122233' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '122233' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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=122233 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (73447,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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 73447 AND teamId = 122233
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 68996 AND teamId = 122233
0.0128  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 = '122233' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '122233' and rp.type = 4
0.0130  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 = '122233' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0164  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 = 73447 WHERE rp.league_id = 73447 AND rp.teamId = 122233 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.0185  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 = 73447 WHERE rp.league_id = 73447 AND rp.teamId = 122233 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0163  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 = 73447 WHERE rp.league_id = 73447 AND rp.teamId = 122233 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 122233 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0133  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 = 73447 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0257  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.0131  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 = 63671 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 58935 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 51420 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC