4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del UM Escobedo A
TEMPORADA 2023/2024
1ª CANTABRIA JUVENIL
Equipo PJ GF GC Puntos
1 CD Arenas De Frajanas A Arenas 1 5 0 3
2 CD Bezana B CD Bezana B 1 5 2 3
3 SD Noja SD Noja 1 3 0 3
4 CD Monte B CD Monte B 1 3 2 3
5 CD Marina Sport B Marina Sport 1 2 1 3
6 Cultd Guarnizo A Cultd 1 2 1 3
7 R.S. Gimnástica B R.S. 1 2 1 3
8 SD Solares-Medio Cudeyo B Solares-Medi 1 1 0 3
9 Ampuero FC A Ampuero 1 1 1 1
10 CDE Atlético Mineros A Atlético 1 1 1 1
11 EDM Santillana A Santillana 1 2 3 0
12 CD Amistad Sniace B Amistad 1 1 2 0
13 CDE Rayo Santa Cruz A Rayo Santa. 1 1 2 0
14 UM Escobedo A Escobedo 1 1 2 0
15 SD Gama SD Gama 1 0 1 0
16 CD Tropezon B Tropezon 1 2 5 0
17 Cayón Sub 19 Cayón 1 0 3 0
18 U.C. Cartes A U.C. Cartes 1 0 5 0
TEMPORADA 2022/2023
1ª CANTABRIA JUVENIL
Equipo PJ GF GC Puntos
1 CD Naval Sub 19 Naval 34 83 39 76
2 Velarde CF Sub 19 Velarde 34 74 34 69
3 SD Nueva Montaña Sub 19 Nueva 34 101 63 69
4 SD Gama SD Gama 34 99 53 68
5 Cultd Guarnizo A Cultd 34 73 33 68
6 CDE Atlético Mineros A Atlético 33 85 51 65
7 CD Tropezon B Tropezon 34 109 63 64
8 SD Solares-Medio Cudeyo B Solares-Medi 33 70 36 60
9 CD Bezana B CD Bezana B 34 66 54 55
10 CD Amistad Sniace B Amistad 34 44 46 45
11 CDE Rayo Santa Cruz A Rayo Santa. 34 51 63 42
12 Cayón Sub 19 Cayón 34 49 76 41
13 CD Monte B CD Monte B 34 54 66 35
14 UM Escobedo A Escobedo 34 48 74 34
15 FC Rinconeda Polanco Rinconeda 34 48 100 28
16 SD Textil Escudo Sub 19 Textil 34 24 100 17
17 CD Cervantes Sub 19 Cervantes 33 38 100 15
18 Colindres B Colindres B 33 33 98 15
TEMPORADA 2021/2022
1ª CANTABRIA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 RS Gimnástica Sub 19 B Gimnástica 18 58 26 45
2 SD Gama SD Gama 18 36 14 37
3 SD Peña Revilla Sub 19 Peña 18 53 16 36
4 Velarde CF Sub 19 Velarde 18 34 36 27
5 UM Escobedo A Escobedo 18 31 26 26
6 Colindres B Colindres B 18 29 36 22
7 Calasanz A Calasanz A 18 39 48 18
8 SD Nueva Montaña Sub 19 Nueva 18 27 38 16
9 EMF Meruelo EMF Meruelo 18 22 53 15
10 Ribamontán Al Mar Sub 19 Ribamontán 18 20 56 8
TEMPORADA 2018/2019
1ª CANTABRIA JUVENIL
Equipo PJ GF GC Puntos
1 Ribamontán Al Mar Sub 19 Ribamontán 34 121 48 78
2 CF Vimenor Sub 19 Vimenor 34 117 50 78
3 CD Revilla Sub 19 Revilla 34 95 44 68
4 RS Gimnástica Sub 19 B Gimnástica 34 86 50 68
5 Gama SD Gama SD 34 83 61 67
6 CD Tropezon B Tropezon 34 78 45 64
7 CD Amistad Sniace B Amistad 34 75 68 54
8 Colindres B Colindres B 34 77 59 53
9 SD Peña Revilla Sub 19 Peña 34 62 76 49
10 CD Marina Sport B Marina Sport 34 65 62 46
11 EDM Santillana A Santillana 34 65 79 44
12 UM Escobedo A Escobedo 34 60 73 40
13 Solares-Medio Cudeyo B Solares-Medi 34 53 78 37
14 Calasanz A Calasanz A 34 65 89 36
15 Edel Pisueña Edel 34 58 81 35
16 CDE Rayo Santa Cruz A Rayo Santa. 34 49 87 32
17 Cervantes B Cervantes B 34 52 86 30
18 Arenas de Frajanas Sub 19 Arenas 34 22 147 1
TEMPORADA 2017/2018
1ª CANTABRIA JUVENIL
Equipo PJ GF GC Puntos
1 Atlético Perines Sub 19 B Atlético 34 121 45 84
2 CD Marina Sport B Marina Sport 34 93 52 68
3 Cayón Sub 19 Cayón 34 96 54 67
4 CD Monte Sub 19 Monte 34 80 59 66
5 RS Gimnástica Sub 19 B Gimnástica 34 73 49 61
6 Meruelo EMF Meruelo EMF 34 71 60 60
7 CD Amistad Sniace B Amistad 34 65 51 58
8 CD Tropezon B Tropezon 34 62 74 50
9 Gama SD Gama SD 34 60 60 47
10 CF Vimenor Sub 19 Vimenor 34 71 75 47
11 UM Escobedo A Escobedo 34 66 61 45
12 CD Calasanz Santander Calasanz 34 58 62 45
13 CD Revilla Sub 19 Revilla 34 78 66 43
14 Edel Pisueña Edel 34 61 81 43
15 Cervantes B Cervantes B 34 53 55 39
16 Edm Santillana Santillana 34 44 95 21
17 La Marisma AAVV Marisma AAVV 34 44 106 18
18 Santoña CF Santoña CF 34 32 123 12
TEMPORADA 2016/2017
2ª CANTABRIA JUVENIL
Equipo PJ GF GC Puntos
1 CD Marina Sport B Marina Sport 32 127 26 82
2 Gama SD Gama SD 32 84 36 66
3 UM Escobedo A Escobedo 32 75 43 66
4 Ribamontán Al Mar Sub 19 Ribamontán 32 103 50 62
5 Ampuero FC A Ampuero 32 73 57 59
6 CD Naval Sub 19 Naval 32 65 45 55
7 Monte B Monte B 32 82 58 52
8 Tropezon C Tropezon C 32 70 54 49
9 U.C. Cartes A U.C. Cartes 33 75 59 48
10 Solares-Medio Cudeyo B Solares-Medi 32 60 63 46
11 Colindres B Colindres B 32 93 78 41
12 Bezana B Bezana B 32 64 66 39
13 Cuevas del Castillo Cuevas 33 48 81 37
14 Cayon B Cayon B 32 58 77 34
15 Vimenor B Vimenor B 32 49 87 30
16 Santiago Galas Santiago 32 33 90 13
17 La Encina CDB Encina 32 14 201 2
TEMPORADA 2015/2016
2ª CANTABRIA JUVENIL
Equipo PJ GF GC Puntos
1 Santoña CF Santoña CF 36 108 38 93
2 Textil Escudo B Textil 36 122 37 93
3 Solares-Medio Cudeyo B Solares-Medi 36 112 27 87
4 La Marisma AAVV Marisma AAVV 36 95 52 73
5 Colindres B Colindres B 36 76 58 66
6 Velarde Camargo Velarde 36 94 65 62
7 La Encina CDB Encina 36 89 60 59
8 Vimenor B Vimenor B 36 74 63 57
9 CD Naval Sub 19 Naval 36 65 58 53
10 Cuevas del Castillo Cuevas 36 67 87 45
11 Cayon B Cayon B 36 62 79 45
12 Santiago Galas Santiago 36 62 77 43
13 UM Escobedo A Escobedo 36 54 81 39
14 Bezana B Bezana B 36 51 85 36
15 Ampuero FC A Ampuero 36 52 82 35
16 España de Cueto España 36 63 119 29
17 Ramales CD Ramales CD 36 54 89 27
18 Arenas de Frajanas B Arenas 36 45 113 25
19 Arenas de Iguña Arenas 36 53 128 12
TEMPORADA 2014/2015
3ª CANTABRIA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 La Encina CDB Encina 25 121 27 69
2 Arenas de Frajanas B Arenas 25 124 29 68
3 UM Escobedo A Escobedo 26 84 47 49
4 Club Parayas SD Club Parayas 25 78 51 45
5 Ramales CD Ramales CD 24 70 55 45
6 Los Rios CD Los Rios CD 24 57 63 35
7 Villaescusa EDM Villaescusa 25 71 56 34
8 Castroverde CD Castroverde 25 57 57 29
9 Ribamontan Al Mar B Ribamontan 25 41 55 26
10 Calasanz B Calasanz B 25 47 67 26
11 San Justo CD Justo 25 42 52 24
12 Entrambasaguas EDM Entrambasagu 25 46 79 23
13 Guriezo CD Guriezo CD 24 26 129 3
14 Union Club SD Union Club 11 2 99 0

  USO DE MEMORIA  
5,527,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4919
Total Execution Time  0.4931
  CADENA URL  
/historico/Escobedo-Um-Juvenil
  GET DATOS  
$_GET['/historico/Escobedo-Um-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0134  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 = 'Escobedo-Um-Juvenil' 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.0134  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=28780 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=28780 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0256  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 = 74591
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=28780 AND type_rel = 2
0.0134  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=798 AND type_rel = 3
0.0130  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 798 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0131  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 (908345,205976) ORDER BY n.cover_points DESC, update_date 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 = '28780' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '28780' 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 = '28780' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 74591 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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=28780 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (74591) 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.0126  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74591 AND teamId = 28780
0.0126  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 = 74591 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '28780' 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 = '28780' and rp.type = 4
0.0128  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 = '28780' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  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 = 28780 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024_base` 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 = 74591 AND t.round = 1 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 `tables2023_base` 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 = 69000 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.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 `tables2022_base` 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 = 64740 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.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 `tables2019_base` 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 = 45709 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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_base` 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 = 39887 AND t.round = 34 ORDER BY team.conference 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 `tables2017_base` 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 = 34282 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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_base` 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 = 17118 AND t.round = 38 ORDER BY team.conference 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 `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 = 5106 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 74591 ORDER BY nameShow LIMIT 100