Autonómica Cantabria Futsal 2022
2021/2022

Grupo Único

Autonómica Cantabria Futsal 2022

  • CDEFS Samano
  • CD Naval FS B
  • Lely Parbayon B
  • Portus Amanus
  • Ribamontán al Mar CF
  • Aislamientos San Felices
  • CDE Peña Gedio
  • CDE Valle Lebaniego
  • Samser Meruelo
  • CDE Herrera Moderno B
  • CDE Mar Rock B
  • SD Buelna
  • Adal Treto
  • CD Milinde Reocin B
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Cueva de Morin/Villaescusa Cueva 26 125 36 67
2 CD Milinde CD Milinde 26 133 53 64
3 Somahoz Somahoz 26 113 66 63
4 Guriezo Guriezo 26 77 60 48
5 Aislamientos San Felices Aislamientos 26 103 80 47
6 Valle Lebaniego B Valle 26 91 86 40
7 AD San Miguel Cobo-Lely Miguel 26 77 61 37
8 Samser Meruelo Samser 26 89 94 36
9 Adal Treto / Autobuses Madr Adal Treto. 26 65 93 30
10 CDEFS Samano CDEFS Samano 26 70 104 25
11 Herrera Herrera 26 77 93 21
12 Ribamontan Al Mar Ribamontan 26 70 125 19
13 El Duesoes El Duesoes 26 85 152 17
14 La Folia La Folia 26 64 136 15
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Rayo Sanfe Rayo Sanfe 25 136 30 70
2 Somahoz Somahoz 23 107 56 56
3 E Union Castreña Union 23 100 53 54
4 Aislamientos San Felices Aislamientos 24 94 70 41
5 Cueva de Morin/Villaescusa Cueva 23 61 55 38
6 AD San Miguel Cobo-Lely Miguel 23 86 95 28
7 Samano Samano 24 58 89 28
8 El Duesoes El Duesoes 24 97 130 28
9 Ribamontan Al Mar Ribamontan 22 58 65 27
10 Samser Meruelo Samser 24 77 97 27
11 Herrera Herrera 24 66 87 24
12 UD Adal Treto Adal Treto 23 41 91 10
13 CD La Folia FS Folia 23 41 98 8
14 La Viesca La Viesca 1 0 6 0
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Cdfs Buciero/ Proboca Santo Cdfs 28 254 56 81
2 La Vuelta Pub Vuelta 26 155 54 63
3 AD San Miguel Cobo-Lely Miguel 28 127 96 53
4 Crc/ Nuevo Matadero Reinosa Crc/ Nuevo. 28 125 103 51
5 E Union Castreña Union 26 101 88 45
6 Somahoz Somahoz 28 104 108 41
7 Aislamientos San Felices Aislamientos 28 114 101 39
8 Ajo Quintres Quintres 28 86 87 39
9 Samser Meruelo Samser 28 105 126 39
10 Cueva de Morin/Villaescusa Cueva 27 87 92 37
11 Herrera Herrera 27 71 80 31
12 El Duesoes El Duesoes 28 107 172 22
13 La Viesca La Viesca 22 54 95 21
14 Montañas del Pas Apleman Montañas 26 105 178 18
15 Cafe Bar Bolero Cafe Bolero 28 78 237 8
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 El Minchon Talleres Fergar Minchon 18 69 28 45
2 CDE Mar Rock Rock 18 62 43 36
3 Montecio Oxford Montecio 18 49 35 34
4 Union Castreña Union 18 47 47 30
5 AD San Miguel Cobo-Lely Miguel 18 50 48 28
6 Somahoz Somahoz 18 48 52 27
7 Herrera Herrera 18 35 44 21
8 Cueva de Morin Villaescusa Cueva Morin 18 44 57 20
9 La Viesca La Viesca 18 50 62 16
10 Samser Meruelo Samser 18 35 73 3

  USO DE MEMORIA  
5,154,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3056
Total Execution Time  0.3075
  CADENA URL  
/autonomica_cantabria_futsal2022/grupo1/historico
  GET DATOS  
$_GET['/autonomica_cantabria_futsal2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0105  SELECT type FROM routes WHERE alias = 'autonomica_cantabria_futsal2022'
0.0213  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'autonomica_cantabria_futsal' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=807 AND type_rel = 3
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=807 ORDER BY order_id ASC
0.0107  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 64785 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 807 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0106  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 = 64785 AND t.round = 26 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 `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 = 41053 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 36263 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 17431 AND t.round = 30 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 = 5118 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 11:35:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 11:35:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 11:35:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 11:35:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'autonomica_cantabria_futsal' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0107  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 64785 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64785 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0106  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 64785 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64785 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0106  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 64785 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64785 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0116  SELECT *,(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 = 64785 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC