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 UB Conquense Sub 19 Conquense 31 90 26 78
2 Albacete Balompié Sub 19 B Albacete 31 77 23 69
3 CD Cazalegas Sub 19 Cazalegas 31 62 43 58
4 CD Toledo Sub 19 Toledo 31 57 36 57
5 CD Azuqueca Sub 19 Azuqueca 31 68 47 54
6 CD Alameda MESA Sub 19 Alameda MESA 31 52 36 51
7 Guadalajara Sub 19 Guadalajara 31 71 37 51
8 EFUD Albacer Sub 19 EFUD Albacer 31 53 51 50
9 Almansa Sub 19 Almansa 31 64 57 47
10 AD Illescas Sub 19 Illescas 31 46 49 44
11 Atlético Puertollano Sub 19 Atlético 31 47 66 43
12 Arges Sub 19 Arges 31 44 49 41
13 EFFB Ciudad Real Sub 19 EFFB Ciudad 31 48 52 32
14 Jesus de La Ossa Sub 19 Jesus Ossa 31 42 69 31
15 Talavera de la Reina Sub 19 Talavera 31 41 62 29
16 Odelot Toletum Sub 19 Odelot 31 46 74 23
17 Torrijos CD Sub 19 Torrijos 31 26 57 23
18 CD Miguelturreño Sub 19 Miguelturre 31 24 124 8

  USO DE MEMORIA  
7,507,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3467
Total Execution Time  0.3487
  CADENA URL  
/nacional_juvenil2024/grupo15/jugadores
  GET DATOS  
$_GET['/nacional_juvenil2024/grupo15/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0147  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 = 73391 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73391 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0477  SELECT dp.nick,dp.alias,dp.role,p.id,p.teamId,dp.height,dp.weight,p.team_id,p.player_id,p.squadNumber,dp.CountryCode,dp.age FROM rel_players p INNER JOIN dataplayers dp ON dp.id = p.player_id INNER JOIN datateams dt ON dt.id = p.teamId WHERE p.league_id = 73391 AND dt.id IN (4913,5065,5073,6304,6307,10971,5085,6301,3520,19454,10970,41825,41807,140764,140740,153532,140762,159985) ORDER BY dt.relations DESC,dp.role ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 17:43:39' 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 17:43:39' 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 17:43:39' 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=3 AND last_update > '2024-04-28 17:43:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0315  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 = 73391 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73391 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.0274  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 = 73391 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73391 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0162  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 = 73391 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73391 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0161  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 = 73391 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC