4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Newcastle Sub 23 Newcastle
Datos equipo
Nombre Newcastle Sub 23
Nombre completo Newcastle Sub 23
Nombre corto NSB
País
Total plantilla 37
Reading Sub 23 Reading
Datos equipo
Nombre Reading Sub 23
Nombre completo Reading Sub 23
Nombre corto REA
País
Total plantilla 49
West Ham Sub 23 West
Datos equipo
Nombre West Ham Sub 23
Nombre completo West Ham United Sub 23
Nombre corto WHU
País
Total plantilla 36
Man. Utd Sub 23 Man.
Datos equipo
Nombre Man. Utd Sub 23
Nombre completo Manchester United Sub 23
Nombre corto MUN
País
Total plantilla 41
Sunderland Sub 23 Sunderland
Datos equipo
Nombre Sunderland Sub 23
Nombre completo Sunderland Sub 23
Nombre corto SUN
País
Total plantilla 37
Swansea Sub 23 Swansea
Datos equipo
Nombre Swansea Sub 23
Nombre completo Swansea City Sub 23
Nombre corto SWA
País
Total plantilla 42
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 36
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 37
Middlesbrough Sub 23 Middlesbroug
Datos equipo
Nombre Middlesbrough Sub 23
Nombre completo Middlesbrough Sub 23
Nombre corto MID
País
Total plantilla 43
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 45
Fulham Sub 23 Fulham
Datos equipo
Nombre Fulham Sub 23
Nombre completo Fulham Sub 23
Nombre corto FUL
País
Total plantilla 43
Clasificación
Equipo PJ GF GC Puntos
1 West Ham Sub 23 West 18 58 21 46
2 Man. Utd Sub 23 Man. 17 45 17 43
3 West Bromwich Albion Sub 23 West 16 38 22 34
4 Stoke City Sub 23 Stoke City 18 32 27 27
5 Middlesbrough Sub 23 Middlesbroug 18 34 43 26
6 Newcastle Sub 23 Newcastle 18 29 32 25
7 Aston Villa Sub 23 Aston Villa 17 27 28 22
8 Swansea Sub 23 Swansea 17 22 32 21
9 Reading Sub 23 Reading 18 35 37 20
10 Fulham Sub 23 Fulham 18 26 32 20
11 Norwich City Sub 23 Norwich City 17 23 35 17
12 Sunderland Sub 23 Sunderland 18 10 53 1
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,031,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.2769
Total Execution Time  0.2791
  CADENA URL  
/premier_league_2_division_two2020/grupo1/equipos
  GET DATOS  
$_GET['/premier_league_2_division_two2020/grupo1/equipos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0104  SELECT type FROM routes WHERE alias = 'premier_league_2_division_two2020'
0.0212  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 = 2020 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=1978 AND type_rel = 3
0.0108  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.0107  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.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 = 51028 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0114  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 = 51028 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 15:56:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 15:56:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 15:56:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 15:56:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  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 = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0155  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 = 51028 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51028 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.0144  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 = 51028 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51028 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0110  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 = 51028 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51028 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0116  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 51028 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC