4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2024
 
División Honor Madrid Alevín F11 2024
2023/2024

Grupo 1

División Honor Madrid Alevín F11 2024

  • Getafe Sub 12 B
  • Rivas FC Sub 12
  • E. D. Moratalaz Sub 12
  • Atlético Sub 12 B
  • CD Leganés Sub 12 B
  • Fund Rayo Vallecano Sub 12
  • CD Carabanchel Sub 12
  • Seseña Sub 12
  • CD Móstoles URJC Sub 12 B
  • Parla Sub 12
  • Unión Carrascal Sub 12
  • Casarrubuelos Sub 12
  • Parque Sureste Sub 12
  • Alcalá Sub 12
  • EDM San Blas Sub 12
  • AFE Sub 12

Clasificación

Equipo PJ GF GC Puntos
1 Getafe Sub 12 B Getafe 26 86 13 65
2 Rivas FC Sub 12 Rivas 26 61 34 56
3 E. D. Moratalaz Sub 12 Moratalaz 26 66 27 54
4 Atlético Sub 12 B Atlético 26 67 34 54
5 CD Leganés Sub 12 B Leganés 26 48 35 51
6 Fund Rayo Vallecano Sub 12 Fund Rayo V. 26 57 38 49
7 CD Carabanchel Sub 12 Carabanchel 26 57 30 48
8 Seseña Sub 12 Seseña 26 57 39 48
9 CD Móstoles URJC Sub 12 B Móstoles 26 40 60 33
10 Parla Sub 12 Parla 26 46 37 32
11 Unión Carrascal Sub 12 Unión 26 37 62 27
12 Casarrubuelos Sub 12 Casarrubuelo 26 36 64 23
13 Parque Sureste Sub 12 Parque 26 28 55 19
14 Alcalá Sub 12 Alcalá 26 32 65 19
15 EDM San Blas Sub 12 Blas 26 29 76 18
16 AFE Sub 12 AFE Sub 12 26 20 98 1

  USO DE MEMORIA  
4,769,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.2954
Total Execution Time  0.2974
  CADENA URL  
/division-honor-madrid-alevin2024/grupo1/calendario
  GET DATOS  
$_GET['/division-honor-madrid-alevin2024/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0125  SELECT type FROM routes WHERE alias = 'division-honor-madrid-alevin2024'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'division-honor-madrid-alevin' 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.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2505 AND type_rel = 3
0.0129  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2505 ORDER BY order_id ASC
0.0135  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 = 74223 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 74223 ORDER BY round ASC
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 15:20:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 15:20:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 15:20:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 15:20:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'division-honor-madrid-alevin' 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.0127  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 = 74223 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74223 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.0126  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 = 74223 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74223 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  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 = 74223 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74223 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  SELECT *,(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 = 74223 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