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

CD Monte

Entrenador: José Manuel Saldaña

Temporada 2023/2024
TEMPORADA 2023/2024
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 SD Barreda Balompié Barreda 31 79 37 64
2 SD Gama SD Gama 31 42 23 59
3 SD Textil Escudo Textil 31 43 30 57
4 Barquereño Barquereño 31 61 29 56
5 Selaya Selaya 31 45 30 54
6 CD Monte CD Monte 31 43 32 53
7 Ribamontán al Mar Ribamontán 31 58 38 50
8 SD Solares B Solares 31 42 38 48
9 Arenas de Frajanas Arenas 31 35 39 42
10 Peña Revilla SD Peña 31 46 42 41
11 EMD Santillana Santillana 31 45 50 39
12 Rayo Santa Cruz Rayo Santa. 31 35 46 37
13 Cayón B Cayón B 31 38 44 37
14 FC Miengo FC Miengo 31 39 59 34
15 Noja Noja 31 28 42 32
16 SD San Martín Arena Martín 31 18 28 29
17 Estrella Roja Estrella 31 35 76 17
18 CD Naval B CD Naval B 31 21 70 16
TEMPORADA 2022/2023
PREFERENTE CANTABRIA
Equipo PJ GF GC Puntos
1 Atlético Mineros Atlético 34 77 31 78
2 Velarde CF Velarde CF 34 64 29 72
3 CD Bezana CD Bezana 34 80 48 68
4 CD Colindres Colindres 34 70 38 64
5 SD Barreda Balompié Barreda 34 65 45 62
6 Barquereño Barquereño 34 64 39 59
7 Selaya Selaya 34 49 32 58
8 Ribamontán al Mar Ribamontán 34 51 47 48
9 CD Monte CD Monte 34 55 49 47
10 Rayo Santa Cruz Rayo Santa. 34 50 50 45
11 Noja Noja 34 50 51 44
12 Arenas de Frajanas Arenas 34 38 58 35
13 SD San Martín Arena Martín 34 38 72 34
14 EMD Santillana Santillana 34 39 50 32
15 Estrella Roja Estrella 34 38 69 32
16 Vimenor B Vimenor B 34 31 53 29
17 CD Ramales CD Ramales 34 35 76 29
18 SD Nueva Montaña Nueva 34 26 83 20
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
1ª REGIONAL CANTABRIA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Monte CD Monte 15 42 11 36
2 Cayón B Cayón B 15 30 11 31
3 SD San Martín Arena Martín 15 27 8 28
4 Cd Montañas Del Pas Montañas 14 18 17 21
5 Textil Escudo B Textil 16 16 26 18
6 SD Solares B Solares 15 15 20 17
7 CD Calasanz CD Calasanz 15 22 34 16
8 Santiago Galas Santiago 15 9 39 9
9 Santoña CF Santoña CF 14 10 23 8
TEMPORADA 2019/2020
1ª REGIONAL CANTABRIA
Equipo PJ GF GC Puntos
1 Rayo Santa Cruz Rayo Santa. 24 76 33 50
2 Arenas de Frajanas Arenas 25 64 31 50
3 Rio Gandara CD Gandara 25 55 40 49
4 SD Solares B Solares 25 51 29 48
5 Ampuero FC Ampuero FC 25 56 33 47
6 Santoña CF Santoña CF 25 48 30 44
7 Atlético España De Cueto Atlético 24 48 40 42
8 Cd Montañas Del Pas Montañas 25 35 29 42
9 Vimenor B Vimenor B 25 35 33 38
10 Ayrón Club Ayrón Club 25 50 38 37
11 Textil Escudo B Textil 25 41 44 37
12 CD Monte CD Monte 25 45 45 32
13 Cayón B Cayón B 25 39 60 26
14 Minerva Fc Minerva Fc 25 36 58 24
15 Fortuna Camargo Fortuna 25 32 58 21
16 Reocin Reocin 25 40 59 18
17 Santillana B Santillana 25 22 56 11
18 Santiago Galas Santiago 25 19 76 7
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
1ª REGIONAL CANTABRIA
Equipo PJ GF GC Puntos
1 CD Monte CD Monte 34 80 35 75
2 Vimenor B Vimenor B 34 73 27 73
3 Valle Lebaniego Valle 34 78 41 66
4 SD Torina SD Torina 34 71 35 65
5 Ayrón Club Ayrón Club 34 46 44 50
6 UC Cartes UC Cartes 34 53 56 50
7 CD Comillas CD Comillas 34 52 53 47
8 Rio Gandara CD Gandara 34 67 68 47
9 SD San Martín Arena Martín 34 51 52 45
10 Juventud Atlético San Roman Juventud 34 45 51 45
11 Ampuero FC Ampuero FC 33 38 45 41
12 CD Ramales CD Ramales 34 44 68 40
13 Atco. Deva Atco. Deva 34 34 54 40
14 Marina de Cudeyo Marina 34 45 54 40
15 CD Valdáliga Valdáliga 34 45 60 39
16 Cd Montañas Del Pas Montañas 34 35 52 38
17 CD Limpias CD Limpias 34 52 72 33
18 Bezana B Bezana B 33 27 69 18
TEMPORADA 2014/2015
1ª REGIONAL CANTABRIA
Equipo PJ GF GC Puntos
1 Internacional FC Santander Internaciona 34 72 22 77
2 Atlético España De Cueto Atlético 34 68 31 72
3 Cayón B Cayón B 34 70 42 69
4 Ayrón Club Ayrón Club 34 61 33 67
5 Vimenor B Vimenor B 34 53 32 58
6 CD Monte CD Monte 34 56 39 58
7 Atco. Deva Atco. Deva 34 65 53 52
8 CD Valdáliga Valdáliga 34 61 66 48
9 CD Limpias CD Limpias 34 63 72 41
10 Juventud Atlético San Roman Juventud 34 43 49 39
11 Cd Montañas Del Pas Montañas 34 34 59 38
12 Marina de Cudeyo Marina 34 54 77 37
13 Unión Club Unión Club 34 51 60 36
14 CD Ramales CD Ramales 34 60 84 36
15 CD Comillas CD Comillas 34 49 58 35
16 UC Cartes UC Cartes 34 49 69 35
17 CD Calasanz CD Calasanz 34 47 78 34
18 CD Liendo CD Liendo 34 41 73 31

  USO DE MEMORIA  
6,330,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4693
Total Execution Time  0.4705
  CADENA URL  
/historico/Cd-Monte
  GET DATOS  
$_GET['/historico/Cd-Monte']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
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-Monte' 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.0111  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=20014 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  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=20014 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=20014 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0226  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 = 73447
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20014 AND type_rel = 2
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=129 AND type_rel = 3
0.0114  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 = '20014' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0113  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 = '20014' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0120  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 = 73447 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0122  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=20014 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0113  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,71759) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73447 AND teamId = 20014
0.0113  SELECT count(id) as num_players from rel_players WHERE league_id = 71759 AND teamId = 20014
0.0115  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 = '20014' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0110  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '20014' and rp.type = 4
0.0110  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 = '20014' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0114  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 = 71759 WHERE rp.league_id = 71759 AND rp.teamId = 20014 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.0111  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 = 71759 WHERE rp.league_id = 71759 AND rp.teamId = 20014 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0108  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 = 71759 WHERE rp.league_id = 71759 AND rp.teamId = 20014 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0108  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 = 20014 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0213  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.0216  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 = 68550 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.0114  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.0109  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 = 58852 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.0113  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 = 51303 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.0114  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.0112  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.0112  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 = 16775 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 4322 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC