4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2024
 
Championship 2024
2023/2024

efl championship, english football league championship, campeonato de la liga de futbol ingles, campeonato sky bet, segunda division inglesa, segunda division de inglaterra

Championship 2024

  • Leicester
  • Leeds United
  • Ipswich Town
  • Southampton
  • Norwich City
  • West Bromwich Albion
  • Hull City
  • Middlesbrough
  • Coventry City
  • Preston North End
  • Bristol City
  • Cardiff City
  • Swansea City
  • Watford
  • Sunderland
  • Millwall
  • Queens Park Rangers
  • Stoke City
  • Blackburn Rovers
  • Sheffield Wednesday
  • Plymouth Argyle
  • Birmingham City
  • Huddersfield Town
  • Rotherham United

Cruce de partidos Championship - Todos los partidos de la temporada

IdaVuelta
 Blackburn Rovers Leicester Sheffield Wednesday Sunderland West Bromwich Albion Birmingham City Leeds United Stoke City Preston North End Middlesbrough Southampton Huddersfield Town Coventry City Ipswich Town Cardiff City Norwich City Hull City Swansea City Bristol City Millwall Queens Park Rangers Plymouth Argyle Rotherham United Watford
Blackburn Rovers Blackburn Rovers
Leicester Leicester
Sheffield Wednesday Sheffield Wednesday
Sunderland Sunderland
West Bromwich Albion West Bromwich Albion
Birmingham City Birmingham City
Leeds United Leeds United
Stoke City Stoke City
Preston North End Preston North End
Middlesbrough Middlesbrough
Southampton Southampton
Huddersfield Town Huddersfield Town
Coventry City Coventry City
Ipswich Town Ipswich Town
Cardiff City Cardiff City
Norwich City Norwich City
Hull City Hull City
Swansea City Swansea City
Bristol City Bristol City
Millwall Millwall
Queens Park Rangers Queens Park Rangers
Plymouth Argyle Plymouth Argyle
Rotherham United Rotherham United
Watford Watford

  USO DE MEMORIA  
8,228,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3374
Total Execution Time  0.3393
  CADENA URL  
/championship2024/grupo1/cruces
  GET DATOS  
$_GET['/championship2024/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0262  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2024 AS c WHERE c.league_id='72033' ORDER BY c.id ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 11:31:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 11:31:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 11:31:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 11:31:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0358  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 = 72033 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72033 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.0435  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 = 72033 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72033 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0134  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 = 72033 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72033 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10