4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2024
 
1ª Aragón Femenina 2024
2023/2024

Grupo Único

1ª Aragón Femenina 2024

  • Ebro CD Fem
  • Ejea SD Fem
  • Huesca B Fem
  • Cosmos Aragón Fem
  • Fuensport Fem
  • Zaragoza C Fem
  • Peña Ferranca
  • Delicias CD Fem
  • Valdefierro CD B Fem
  • St. Casablanca Fem
  • Balsas Picarral UD Fem
  • El Gancho CF Fem
  • UD Fraga Fem
  • Villanueva CF Fem
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Ebro CD Fem Ebro CD Fem 25 79 12 65
2 Ejea SD Fem Ejea SD Fem 25 81 26 63
3 Huesca B Fem Huesca 25 63 30 57
4 Cosmos Aragón Fem Cosmos 25 55 38 46
5 Fuensport Fem Fuensport 25 69 46 45
6 Zaragoza C Fem Zaragoza 25 53 31 41
7 Peña Ferranca Peña 25 43 38 30
8 Delicias CD Fem Delicias 25 34 42 28
9 Valdefierro CD B Fem Valdefierro 25 35 53 28
10 St. Casablanca Fem Casablanca 25 44 58 26
11 Balsas Picarral UD Fem Balsas 25 54 74 25
12 El Gancho CF Fem Gancho 25 42 68 19
13 UD Fraga Fem Fraga 25 28 92 14
14 Villanueva CF Fem Villanueva 25 13 85 5
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Huesca B Fem Huesca 26 88 29 65
2 Ejea SD Fem Ejea SD Fem 26 92 29 64
3 Zaragoza C Fem Zaragoza 24 81 31 53
4 Casetas Fem Casetas Fem 26 69 40 48
5 Peña Ferranca Peña 26 43 25 46
6 Delicias Fem Delicias 25 49 39 46
7 Ebro Fem Ebro Fem 25 31 17 38
8 Valdefierro Fem Valdefierro 26 36 32 36
9 Villanueva CF Fem Villanueva 26 31 62 29
10 Fuensport Fem Fuensport 26 34 56 25
11 Peñas Oscenses Fem Peñas 26 32 60 20
12 Teruel Fem Teruel Fem 25 26 71 15
13 El Olivar Fem Olivar 24 17 62 11
14 Ciudad de Monzón Fem Ciudad 23 6 82 5

  USO DE MEMORIA  
4,912,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.0638
Total Execution Time  0.0661
  CADENA URL  
/primera-aragon-femenina2024/grupo1/historico
  GET DATOS  
$_GET['/primera-aragon-femenina2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0017  SELECT type FROM routes WHERE alias = 'primera-aragon-femenina2024'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera-aragon-femenina' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2500 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2500 ORDER BY order_id ASC
0.0019  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2500 GROUP BY l.categoryId
0.0019  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=2500 GROUP BY l.year ORDER BY l.year DESC
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2500 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0025  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 = 75514 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.0023  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 = 64341 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.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 05:27:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 05:27:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 05:27:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 05:27:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera-aragon-femenina' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  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 events2024 e ON e.player_id = p.id AND e.league_id = 75514 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75514 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.0019  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 events2024 e ON e.player_id = p.id AND e.league_id = 75514 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75514 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 events2024 e ON e.player_id = p.id AND e.league_id = 75514 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75514 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  SELECT *,(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 = 75514 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