4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2024
 
Professional Development League Sub 21 2024
2023/2024

Professional Development League Sub 21 2024

  • Sheffield United Sub 21
  • Birmingham City Sub 21
  • Sheffield Wednesday Sub 21
  • Barnsley Sub 21
  • Hull City Sub 21
  • Fleetwood Sub 21
  • Burnley Sub 21
  • Wigan Athletic Sub 21
  • Coventry City Sub 21
  • Peterborough United Sub 21
  • Crewe Alexandra Sub 21
  • Millwall Sub 21
  • Queens Park Rangers Sub 21
  • Swansea City Sub 21
  • AFC Bournemouth Sub 21
  • Ipswich Town Sub 21
  • Watford Sub 21
  • Cardiff City Sub 21
  • Charlton Athletic Sub 21
  • Bristol City Sub 21
  • Colchester United Sub 21

Clasificación

Equipo PJ GF GC Puntos
1 Sheffield United Sub 21 Sheffield 26 71 28 54
2 Birmingham City Sub 21 Birmingham 28 56 33 52
3 Sheffield Wednesday Sub 21 Sheffield 28 56 32 51
4 Barnsley Sub 21 Barnsley 27 59 44 45
5 Hull City Sub 21 Hull City 27 55 54 42
6 Fleetwood Sub 21 Fleetwood 27 47 47 42
7 Burnley Sub 21 Burnley 26 47 47 41
8 Wigan Athletic Sub 21 Wigan 27 42 56 26
9 Coventry City Sub 21 Coventry 26 34 59 22
10 Peterborough United Sub 21 Peterborough 27 42 69 22
11 Crewe Alexandra Sub 21 Crewe 26 34 72 16
12 Millwall Sub 21 Millwall 27 73 43 55
13 Queens Park Rangers Sub 21 Queens Park 27 63 40 46
14 Swansea City Sub 21 Swansea City 27 70 49 45
15 AFC Bournemouth Sub 21 Bournemouth 26 47 42 45
16 Ipswich Town Sub 21 Ipswich Town 27 58 57 43
17 Watford Sub 21 Watford 26 39 61 33
18 Cardiff City Sub 21 Cardiff City 27 49 59 30
19 Charlton Athletic Sub 21 Charlton 25 52 53 27
20 Bristol City Sub 21 Bristol City 26 33 58 26
21 Colchester United Sub 21 Colchester 25 37 61 22

  USO DE MEMORIA  
5,424,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.2949
Total Execution Time  0.2969
  CADENA URL  
/liga_desarrollo_sub_232024/grupo1/resumen/3
  GET DATOS  
$_GET['/liga_desarrollo_sub_232024/grupo1/resumen/3']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0105  SELECT type FROM routes WHERE alias = 'liga_desarrollo_sub_232024'
0.0213  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_desarrollo_sub_23' 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.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2424 AND type_rel = 3
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2424 ORDER BY order_id ASC
0.0107  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 = 73462 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0112  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 FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 73462 AND c.`round` = 3 ORDER BY shedule ASC LIMIT 200
0.0139  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 29 AND e.real_date IS NOT NULL AND e.league_id = 73462 ORDER BY total DESC LIMIT 100
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 23:45:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 23:45:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 23:45:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 23:45:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_desarrollo_sub_23' 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.0261  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 = 73462 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73462 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.0109  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 = 73462 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73462 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0115  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 = 73462 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73462 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0120  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 = 73462 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC