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 Albacete Balompié Sub 19 B Albacete 24 53 21 50
2 Talavera de la Reina Sub 19 Talavera 25 64 40 50
3 Manchego C. Real Sub 19 Manchego 25 36 23 46
4 UB Conquense Sub 19 Conquense 25 40 27 44
5 CD Toledo Sub 19 B Toledo 25 45 32 43
6 AD Illescas Sub 19 Illescas 25 34 29 40
7 Sporting de Alcázar Sub 19 Sporting 25 27 24 39
8 CD Azuqueca Sub 19 Azuqueca 25 44 32 38
9 Elite Talavera Sub 19 Elite 24 42 33 38
10 Mora CF Sub 19 Mora 25 49 33 37
11 Hellín CF Sub 19 Hellín 25 36 37 32
12 Manzanares Sub 19 Manzanares 25 36 51 31
13 EFUD Albacer Sub 19 EFUD Albacer 25 30 35 30
14 Torrijos CD Sub 19 Torrijos 25 25 44 25
15 CDEFB Valdepeñas Sub 19 CDEFB 25 29 44 22
16 CS Puertollano Puertollano 25 27 44 21
17 Atlético Tomelloso Sub 19 Atlético 25 29 61 18
18 Dinamo Guadalajara Sub 19 Dinamo 25 24 60 18

  USO DE MEMORIA  
4,840,824 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2942
Total Execution Time  0.2962
  CADENA URL  
/nacional_juvenil2020/grupo15/calendario
  GET DATOS  
$_GET['/nacional_juvenil2020/grupo15/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0295  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'nacional_juvenil' AND (l.group_code = 15 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=15 DESC LIMIT 1
0.0146  SELECT id,name,alias,stepParent FROM categories WHERE parentId=112 ORDER BY order_id ASC
0.0148  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 = 50795 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  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 calendars2020 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 50795 ORDER BY round ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 12:24:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 12:24:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 12:24:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 12:24:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  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 events2020 e ON e.player_id = p.id AND e.league_id = 50795 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50795 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.0146  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 events2020 e ON e.player_id = p.id AND e.league_id = 50795 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50795 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0146  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 events2020 e ON e.player_id = p.id AND e.league_id = 50795 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50795 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0157  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020_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 = 50795 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC