Cantabria Alevín Futsal 2022
2021/2022

Grupo Único

Cantabria Alevín Futsal 2022

  • CD Amigos de la Merced
  • CDEMuslera / Gsw
  • CDE Fuente Salin B
  • CDE Muslera B
  • Fuente Salin
  • CDE El Muelle
  • Castro Urdiales
Fuente Salin Fuente Salin
Datos equipo
Nombre Fuente Salin
Nombre completo CD E Fuente Salin
Nombre corto FUE
País
Castro Urdiales Castro
Datos equipo
Nombre Castro Urdiales
Nombre completo CFS Castro Urdiales
Nombre corto CAS
País
CDE Fuente Salin B Fuente Salin
Datos equipo
Nombre CDE Fuente Salin B
Nombre corto CDE
País
CDEMuslera / Gsw CDEMuslera
Datos equipo
Nombre CDEMuslera / Gsw
Nombre corto CDE
País
CD Amigos de la Merced Amigos
Datos equipo
Nombre CD Amigos de la Merced
Nombre completo CD Amigos de la Merced
Nombre corto CAM
País
CDE El Muelle Muelle
Datos equipo
Nombre CDE El Muelle
Nombre completo CDE El Muelle
Nombre corto CDM
País
CDE Muslera B Muslera
Datos equipo
Nombre CDE Muslera B
Nombre completo CDE Muslera B
Nombre corto CDM
País
Clasificación
Equipo PJ GF GC Puntos
1 CD Amigos de la Merced Amigos 12 56 19 27
2 CDEMuslera / Gsw CDEMuslera 12 42 26 20
3 CDE Fuente Salin B Fuente Salin 12 44 30 19
4 CDE Muslera B Muslera 12 44 33 19
5 Fuente Salin Fuente Salin 12 55 56 17
6 CDE El Muelle Muelle 12 54 49 16
7 Castro Urdiales Castro 12 19 101 1
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
4,602,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0036
Controller Execution Time ( Home / Category )  0.4351
Total Execution Time  0.4387
  CADENA URL  
/cantabria_alevin_futsal2022/grupo1/equipos
  GET DATOS  
$_GET['/cantabria_alevin_futsal2022/grupo1/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0109  SELECT type FROM routes WHERE alias = 'cantabria_alevin_futsal2022'
0.0224  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'cantabria_alevin_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.0119  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1069 AND type_rel = 3
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1069 ORDER BY order_id ASC
0.0140  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1069 GROUP BY l.categoryId
0.0110  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1069 GROUP BY l.year ORDER BY l.year DESC
0.0169  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 = 64787 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0112  SELECT t.id,t.teamId,t.total_players,dt.* FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 64787 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 08:04:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 08:04:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 08:04:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 08:04:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0119  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'cantabria_alevin_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.0112  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 = 64787 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64787 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.0108  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 = 64787 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64787 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0111  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 = 64787 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64787 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  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 = 64787 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC