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

Clasificación

Equipo PJ GF GC Puntos
1 Leicester Leicester 44 86 39 94
2 Leeds United Leeds United 45 80 41 90
3 Ipswich Town Ipswich Town 44 88 56 90
4 Southampton Southampton 45 85 62 84
5 Norwich City Norwich City 45 79 63 73
6 West Bromwich Albion West 45 67 47 72
7 Hull City Hull City 45 68 59 70
8 Middlesbrough Middlesbroug 45 68 61 66
9 Coventry City Coventry 44 68 55 64
10 Preston North End Preston 44 56 61 63
11 Bristol City Bristol City 45 53 47 62
12 Cardiff City Cardiff City 45 51 65 62
13 Swansea City Swansea City 45 59 64 57
14 Watford Watford 45 60 58 56
15 Sunderland Sunderland 45 52 52 56
16 Millwall Millwall 45 44 55 56
17 Queens Park Rangers Queens Park 45 45 57 53
18 Stoke City Stoke City 45 45 60 53
19 Blackburn Rovers Blackburn 45 58 74 50
20 Sheffield Wednesday Sheffield 45 42 68 50
21 Plymouth Argyle Plymouth 45 58 70 48
22 Birmingham City Birmingham 45 49 65 47
23 Huddersfield Town Huddersfield 45 48 75 45
24 Rotherham United Rotherham 45 32 87 24

  USO DE MEMORIA  
5,658,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.3528
Total Execution Time  0.3555
  CADENA URL  
/championship2024/grupo1/resumen/3
  GET DATOS  
$_GET['/championship2024/grupo1/resumen/3']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0295  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'championship' 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.0158  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` = 72033 AND c.`round` = 3 ORDER BY shedule ASC LIMIT 200
0.0206  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 = 45 AND e.real_date IS NOT NULL AND e.league_id = 72033 ORDER BY total DESC LIMIT 100
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 23:04:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 23:04:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 23:04:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 23:04:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0367  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.0523  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.0164  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