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,333,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.4190
Total Execution Time  0.4217
  CADENA URL  
/championship2024/grupo1/cruces
  GET DATOS  
$_GET['/championship2024/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0387  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.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 21:31:57' 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=2 AND last_update > '2024-04-27 21:31:57' 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=4 AND last_update > '2024-04-27 21:31:57' 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-27 21:31:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0487  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.0724  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.0145  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
0.0261  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 = 72033 AND t.round = 45 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC