Wolverhampton Sub 23 Wolverhampto
Datos equipo
Nombre Wolverhampton Sub 23
Nombre completo Wolverhampton Sub 23
Nombre corto WOL
País
Total plantilla 43
Newcastle Sub 23 Newcastle
Datos equipo
Nombre Newcastle Sub 23
Nombre completo Newcastle Sub 23
Nombre corto NSB
País
Total plantilla 39
Reading Sub 23 Reading
Datos equipo
Nombre Reading Sub 23
Nombre completo Reading Sub 23
Nombre corto REA
País
Total plantilla 62
Southampton Sub 23 Southampton
Datos equipo
Nombre Southampton Sub 23
Nombre completo Southampton Sub 23
Nombre corto SOU
País
Total plantilla 46
Sunderland Sub 23 Sunderland
Datos equipo
Nombre Sunderland Sub 23
Nombre completo Sunderland Sub 23
Nombre corto SUN
País
Total plantilla 52
Norwich City Sub 23 Norwich City
Datos equipo
Nombre Norwich City Sub 23
Nombre completo Norwich City Sub 23
Nombre corto NOR
País
Total plantilla 35
Stoke City Sub 23 Stoke City
Datos equipo
Nombre Stoke City Sub 23
Nombre completo Stoke City Sub 23
Nombre corto STO
País
Total plantilla 49
Aston Villa Sub 23 Aston Villa
Datos equipo
Nombre Aston Villa Sub 23
Nombre completo Aston Villa Sub 23
Nombre corto ASV
País
Total plantilla 43
Middlesbrough Sub 23 Middlesbroug
Datos equipo
Nombre Middlesbrough Sub 23
Nombre completo Middlesbrough Sub 23
Nombre corto MID
País
Total plantilla 49
West Bromwich Albion Sub 23 West
Datos equipo
Nombre West Bromwich Albion Sub 23
Nombre completo West Bromwich Albion Sub 23
Nombre corto WBA
País
Total plantilla 44
Fulham Sub 23 Fulham
Datos equipo
Nombre Fulham Sub 23
Nombre completo Fulham Sub 23
Nombre corto FUL
País
Total plantilla 40
Nottingham Forest Sub 23 Nottingham
Datos equipo
Nombre Nottingham Forest Sub 23
Nombre completo Nottingham Forest Sub 23
Nombre corto NOT
País
Total plantilla 47
Birmingham City Sub 23 Birmingham
Datos equipo
Nombre Birmingham City Sub 23
Nombre completo Birmingham City Sub 23
Nombre corto BCS
País
Total plantilla 55
Burnley Sub 23 Burnley
Datos equipo
Nombre Burnley Sub 23
Nombre completo Burnley Sub 23
Nombre corto BUR
País
Total plantilla 40
Clasificación
Equipo PJ GF GC Puntos
1 Fulham Sub 23 Fulham 26 64 27 62
2 Wolverhampton Sub 23 Wolverhampto 26 46 37 47
3 Stoke City Sub 23 Stoke City 26 34 36 43
4 Nottingham Forest Sub 23 Nottingham 26 52 31 42
5 Norwich City Sub 23 Norwich City 26 64 52 39
6 Burnley Sub 23 Burnley 26 46 39 39
7 Southampton Sub 23 Southampton 26 45 42 39
8 Newcastle Sub 23 Newcastle 26 51 56 38
9 West Bromwich Albion Sub 23 West 26 44 54 35
10 Aston Villa Sub 23 Aston Villa 26 53 51 32
11 Birmingham City Sub 23 Birmingham 26 34 51 26
12 Middlesbrough Sub 23 Middlesbroug 26 31 50 26
13 Sunderland Sub 23 Sunderland 26 35 49 24
14 Reading Sub 23 Reading 26 32 56 23
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
5,185,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1596
Total Execution Time  0.1615
  CADENA URL  
/premier_league_2_division_two2022/grupo1/equipos
  GET DATOS  
$_GET['/premier_league_2_division_two2022/grupo1/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0034  SELECT type FROM routes WHERE alias = 'premier_league_2_division_two2022'
0.0075  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_2_division_two' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0034  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1978 AND type_rel = 3
0.0037  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1978 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0038  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1224714,1224709,1218237,1208523,1162705) ORDER BY n.cover_points DESC, update_date DESC
0.0035  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1978 ORDER BY order_id ASC
0.0036  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 = 63585 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0040  SELECT t.id,t.teamId,t.total_players,dt.* FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 63585 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 13:35:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 13:35:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 13:35:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 13:35:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_2_division_two' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0268  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 events2022 e ON e.player_id = p.id AND e.league_id = 63585 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63585 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.0290  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 events2022 e ON e.player_id = p.id AND e.league_id = 63585 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63585 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0053  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 events2022 e ON e.player_id = p.id AND e.league_id = 63585 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63585 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0079  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 63585 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC