4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Clasificación

Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 C Real Madrid 30 102 18 82
2 Torrejón Sub 19 Torrejón 30 80 42 66
3 Chopera Alcobendas Sub 19 Chopera 29 73 42 59
4 Santa Ana Sub 19 Santa 30 63 49 54
5 Las Rozas Sub 19 B Rozas 29 46 40 48
6 Aravaca Sub 19 Aravaca 29 62 61 46
7 Rayo C. Alcobendas Sub 19 C Rayo 29 45 39 45
8 Boadilla Sub 19 Boadilla 29 55 47 44
9 Atlético Madrid Sub 19 C Atlético 29 55 57 39
10 Tres Cantos Sub 19 Tres Cantos 30 57 69 38
11 Nuevo Boadilla Sub 19 Nuevo 29 47 62 38
12 Unión Adarve Sub 19 B Unión 30 39 49 37
13 Rayo Mjdh. Sub 19 C Rayo Mjdh. 30 45 66 29
14 Coslada Sub 19 Coslada 30 38 61 29
15 San Fernando Sub 19 Fernando 30 36 55 28
16 Pozuelo Alarcón Sub 19 Pozuelo 29 34 59 24
17 Canillas Sub 19 Canillas 29 38 65 24
18 San Sebastian Reyes Sub 19 Sebastian 29 47 81 23

  USO DE MEMORIA  
4,849,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  0.2212
Total Execution Time  0.2241
  CADENA URL  
/primera_madrid_autonomica_juvenil2024/grupo1/calendario
  GET DATOS  
$_GET['/primera_madrid_autonomica_juvenil2024/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0127  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 = 74253 ORDER BY round ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 22:51:05' 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=2 AND last_update > '2024-04-27 22:51:05' 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-27 22:51:05' 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=3 AND last_update > '2024-04-27 22:51:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
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 = 74253 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74253 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.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 = 74253 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74253 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
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 = 74253 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74253 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0259  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 = 74253 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC