« Temporada Anterior
Temporada 2024
 
Publicidad 600x120.gif
Premier League
2023/2024

Premier League

  • Brighton & Hove Albion
  • Manchester City
  • Arsenal
  • Brentford
  • Liverpool
  • Tottenham Hotspur
  • West Ham
  • Newcastle
  • Aston Villa
  • Crystal Palace
  • Manchester United
  • Burnley
  • Fulham
  • AFC Bournemouth
  • Chelsea
  • Sheffield United
  • Luton Town
  • Wolves
  • Nottingham Forest
  • Everton
Resultados
« Jornada Anterior
Jornada 2
Jornada Siguiente »
18 Ago 23
20:45 Finalizado 		Nottingham Forest Nottingham Forest 2-1 Sheffield United Sheffield United más información Jugadas destacadas 205
3' T. Awoniyi 1-0
1-1 48' Gustavo Hamer
89' Chris Wood 2-1
19 Ago 23
16:00 Finalizado 		Fulham Fulham 0-3 Brentford Brentford más información Jugadas destacadas 528
0-1 44' Yoane Wissa
64' Tim Ream
0-2 66' Bryan Mbeumo
0-3 92' Bryan Mbeumo
19 Ago 23
16:00 Finalizado 		Liverpool Liverpool 3-1 AFC Bournemouth AFC Bournemouth más información Jugadas destacadas 330
0-1 3' A. Semenyo
28' Luis Díaz 1-1
36' M. Salah
36' M. Salah 2-1
58' A. Mac Allister
62' Diogo Jota 3-1
19 Ago 23
16:00 Finalizado 		Wolves Wolves 1-4 Brighton & Hove Albion Brighton & Hove Albion más información Jugadas destacadas 195
0-1 15' K. Mitoma
0-2 46' P. Estupiñán
0-3 51' Solly March
0-4 55' Solly March
61' Hee-Chan Hwang 1-4
95' Matheus Nunes
19 Ago 23
18:30 Finalizado 		Tottenham Hotspur Tottenham Hotspur 2-0 Manchester United Manchester United más información Jugadas destacadas 435
49' Pape Sarr 1-0
83' Lisandro Martínez
19 Ago 23
21:00 Finalizado 		Manchester City Manchester City 1-0 Newcastle Newcastle más información Jugadas destacadas 607
31' Julián Álvarez 1-0
20 Ago 23
15:00 Finalizado 		Aston Villa Aston Villa 4-0 Everton Everton más información Jugadas destacadas 168
18' J. Mcginn 1-0
24' Douglas Luiz 2-0
51' Leon Bailey 3-0
75' Jhon Durán 4-0
20 Ago 23
17:30 Finalizado 		West Ham West Ham 3-1 Chelsea Chelsea más información Jugadas destacadas 725
7' Nayef Aguerd 1-0
1-1 28' C. Chukwuemeka
43' E. Fernández
53' M. Antonio 2-1
67' Nayef Aguerd
95' L. Paquetá 3-1
21 Ago 23
21:00 Finalizado 		Crystal Palace Crystal Palace 0-1 Arsenal Arsenal más información Jugadas destacadas 467
0-1 54' M. Ødegaard
67' T. Tomiyasu
03 Oct 23
20:30 Finalizado 		Luton Town Luton Town 1-2 Burnley Burnley más información Jugadas destacadas 101
0-1 47' L. Foster
84' E. Adebayo 1-1
1-2 85' Bruun Larsen
Clasificación
« Jornada Anterior
Jornada 2
Jornada Siguiente »
Equipos Puntos J. G. E. P. F. C. Forma
1 Brighton & Hove Albion Brighton Hove A. 6 2 2 0 0 8 2
  • VICTORIA
  • Brighton & Hove Al. 4
  • Luton Town 1
  • VICTORIA
  • Wolves 1
  • Brighton & Hove Al. 4
2 Manchester City Manchester City 6 2 2 0 0 4 0
  • VICTORIA
  • Burnley 0
  • Manchester City 3
  • VICTORIA
  • Manchester City 1
  • Newcastle 0
3 Arsenal Arsenal 6 2 2 0 0 3 1
  • VICTORIA
  • Arsenal 2
  • Nottingham Forest 1
  • VICTORIA
  • Crystal Palace 0
  • Arsenal 1
4 Brentford Brentford 4 2 1 1 0 5 2
  • EMPATE
  • Brentford 2
  • Tottenham Hotspur 2
  • VICTORIA
  • Fulham 0
  • Brentford 3
5 Liverpool Liverpool 4 2 1 1 0 4 2
  • EMPATE
  • Chelsea 1
  • Liverpool 1
  • VICTORIA
  • Liverpool 3
  • AFC Bournemouth 1
6 Tottenham Hotspur Tottenham 4 2 1 1 0 4 2
  • EMPATE
  • Brentford 2
  • Tottenham Hotspur 2
  • VICTORIA
  • Tottenham Hotspur 2
  • Manchester United 0
7 West Ham West Ham 4 2 1 1 0 4 2
  • EMPATE
  • AFC Bournemouth 1
  • West Ham 1
  • VICTORIA
  • West Ham 3
  • Chelsea 1
8 Newcastle Newcastle 3 2 1 0 1 5 2
  • VICTORIA
  • Newcastle 5
  • Aston Villa 1
  • DERROTA
  • Manchester City 1
  • Newcastle 0
9 Aston Villa Aston Villa 3 2 1 0 1 5 5
  • DERROTA
  • Newcastle 5
  • Aston Villa 1
  • VICTORIA
  • Aston Villa 4
  • Everton 0
10 Crystal Palace Crystal Palace 3 2 1 0 1 1 1
  • VICTORIA
  • Sheffield United 0
  • Crystal Palace 1
  • DERROTA
  • Crystal Palace 0
  • Arsenal 1
11 Manchester United Manchester 3 2 1 0 1 1 2
  • VICTORIA
  • Manchester United 1
  • Wolves 0
  • DERROTA
  • Tottenham Hotspur 2
  • Manchester United 0
12 Burnley Burnley 3 2 1 0 1 2 4
  • DERROTA
  • Burnley 0
  • Manchester City 3
  • VICTORIA
  • Luton Town 1
  • Burnley 2
13 Fulham Fulham 3 2 1 0 1 1 3
  • VICTORIA
  • Everton 0
  • Fulham 1
  • DERROTA
  • Fulham 0
  • Brentford 3
14 AFC Bournemouth AFC Bournemouth 1 2 0 1 1 2 4
  • EMPATE
  • AFC Bournemouth 1
  • West Ham 1
  • DERROTA
  • Liverpool 3
  • AFC Bournemouth 1
15 Chelsea Chelsea 1 2 0 1 1 2 4
  • EMPATE
  • Chelsea 1
  • Liverpool 1
  • DERROTA
  • West Ham 3
  • Chelsea 1
16 Sheffield United Sheffield United 0 2 0 0 2 1 3
  • DERROTA
  • Sheffield United 0
  • Crystal Palace 1
  • DERROTA
  • Nottingham Forest 2
  • Sheffield United 1
17 Luton Town Luton Town 0 2 0 0 2 2 6
  • DERROTA
  • Brighton & Hove Al. 4
  • Luton Town 1
  • DERROTA
  • Luton Town 1
  • Burnley 2
18 Wolves Wolves 0 2 0 0 2 1 5
  • DERROTA
  • Manchester United 1
  • Wolves 0
  • DERROTA
  • Wolves 1
  • Brighton & Hove Al. 4
19 Nottingham Forest Nottingham * -1 2 1 0 1 3 3
  • DERROTA
  • Arsenal 2
  • Nottingham Forest 1
  • VICTORIA
  • Nottingham Forest 2
  • Sheffield United 1
20 Everton Everton * -8 2 0 0 2 0 5
  • DERROTA
  • Everton 0
  • Fulham 1
  • DERROTA
  • Aston Villa 4
  • Everton 0
Campeón : Brighton Hove A.
Champions League : Manchester City, Arsenal, Brentford
Europa League : Liverpool
Descenso : Wolves, Nottingham, Everton

Penalizaciones de la competición

-8 Puntos: Everton
-4 Puntos: Nottingham
JUGADORES DESTACADOS

INFORMACIÓN

La Premier League (por motivos de patrocinio Barclays Premier League), es la máxima categoría de la liga de clubes de fútbol de Inglaterra.

La Premier League fue fundada en 1992 por la Football League First Division (hasta entonces la máxima categoría de la liga inglesa) de separarse de la Football League para tomar ventaja de un lucrativo trato de derechos de televisión.

Reglas de la competición

  • Si dos o más equipos tienen los mismos puntos en la clasificación, se ordenarán según su gol average, en orden descendente.
  • Si dos o más equipos continuan en situación de empate (tanto en puntos como en Gol average) se ordenarán según los goles marcados, siendo el equipo con el mayor número de goles marcados el primero y el equipo con menor número el último.
  • Si dos o más equipos mantienen todavía una situación de empate (contando puntos, goal average y goles marcados) estarán compartiendo la misma posición en la tabla durante esa jornada.

Premier League

20 Abr 24 16:00
Kenilworth Road Stadium
20 Abr 24 16:00
Bramall Lane
20 Abr 24 20:30
Molineux Stadium
21 Abr 24 14:30
Goodison Park
21 Abr 24 16:00
Villa Park

  USO DE MEMORIA  
6,905,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.2722
Total Execution Time  0.2744
  CADENA URL  
/premier/grupo1/jornada2
  GET DATOS  
$_GET['/premier/grupo1/jornada2']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0127  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=10 ORDER BY l.group_code ASC
0.0114  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 19:47:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 19:47:19' 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-04-19 19:47:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 19:47:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0113  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=71849 AND rel.round=2
0.0109  SELECT c.isVideo, c.id,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,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name 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` = 71849 AND c.`round` = 2 ORDER BY shedule ASC LIMIT 200
0.0116  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2024 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2024 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 71849 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (12634,12630,12631,12637,12635,12633,12628,12636,12629,12632) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0130  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 = 2 AND e.real_date IS NOT NULL AND e.league_id = 71849 ORDER BY total DESC LIMIT 40
0.0108  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 71849 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0224  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 = 71849 AND t.round = 2 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 71849 AND shedule >= '2023/08/01' AND shedule < '2023/09/01' ORDER BY shedule ASC
0.0105  SELECT data1, data2 FROM services_tags WHERE categoryId=10
0.0107  SELECT group_code, extraName from `leagues` WHERE categoryId=10 AND year=2024