4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Premier League 1897
  • Aston Villa
  • Sheffield United
  • Derby County
  • Preston North End
  • Liverpool
  • Sheffield Wednesday
  • Everton
  • Bolton Wanderers
  • Bury
  • Wolves
  • Nottingham Forest
  • West Bromwich Albion
  • Stoke City
  • Blackburn Rovers
  • Sunderland
  • Burnley

Premier League 1897

La temporada finalizó el Lunes, 26 Abril 1897.
 
10 Abr 97
Finalizado
Liverpool Liverpool 0-0 Preston North End Preston North End más información ...
 
16 Abr 97
Finalizado
Bury Bury 1-1 Sunderland Sunderland más información ...
 
16 Abr 97
Finalizado
Bolton Wanderers Bolton Wanderers 0-2 Sheffield United Sheffield United más información ...
 
17 Abr 97
Finalizado
Sheffield Wednesday Sheffield Wednesday 2-0 Bury Bury más información ...
 
17 Abr 97
Finalizado
Aston Villa Aston Villa 3-0 Blackburn Rovers Blackburn Rovers más información ...
 
20 Abr 97
Finalizado
Wolves Wolves 4-0 Bolton Wanderers Bolton Wanderers más información ...
 
20 Abr 97
Finalizado
Derby County Derby County 0-1 Everton Everton más información ...
 
24 Abr 97
Finalizado
Everton Everton 1-2 Bury Bury más información ...
 
26 Abr 97
Finalizado
Preston North End Preston North End 0-1 Aston Villa Aston Villa más información ...
Equipos Puntos J. G. E. P. F. C. Forma
1 Aston Villa Aston Villa 47 30 21 5 4 73 38
  • VICTORIA
  • Aston Villa 6
  • Bolton Wanderers 2
  • VICTORIA
  • Bolton Wanderers 1
  • Aston Villa 2
  • VICTORIA
  • Aston Villa 5
  • Wolves 0
  • VICTORIA
  • Aston Villa 3
  • Blackburn Rovers 0
  • VICTORIA
  • Preston North End 0
  • Aston Villa 1
2 Sheffield United Sheffield United 36 30 13 10 7 42 29
  • VICTORIA
  • Sunderland 0
  • Sheffield United 1
  • DERROTA
  • Sheffield United 0
  • Preston North End 2
  • VICTORIA
  • Sheffield United 1
  • Stoke City 0
  • DERROTA
  • Stoke City 2
  • Sheffield United 0
  • VICTORIA
  • Bolton Wanderers 0
  • Sheffield United 2
3 Derby County Derby County 36 30 16 4 10 70 50
  • VICTORIA
  • Burnley 2
  • Derby County 3
  • DERROTA
  • Bury 1
  • Derby County 0
  • DERROTA
  • Everton 5
  • Derby County 2
  • VICTORIA
  • Preston North End 0
  • Derby County 2
  • DERROTA
  • Derby County 0
  • Everton 1
4 Preston North End Preston North 34 30 11 12 7 55 40
  • EMPATE
  • Nottingham Forest 0
  • Preston North End 0
  • EMPATE
  • Preston North End 0
  • West Bromwich Albi. 0
  • DERROTA
  • Preston North End 0
  • Derby County 2
  • EMPATE
  • Liverpool 0
  • Preston North End 0
  • DERROTA
  • Preston North End 0
  • Aston Villa 1
5 Liverpool Liverpool 33 30 12 9 9 46 38
  • VICTORIA
  • Liverpool 3
  • Wolves 0
  • EMPATE
  • Aston Villa 0
  • Liverpool 0
  • DERROTA
  • Liverpool 1
  • Burnley 2
  • EMPATE
  • Liverpool 2
  • Sheffield Wednesda. 2
  • EMPATE
  • Liverpool 0
  • Preston North End 0
6 Sheffield Wednesday Sheffield 31 30 10 11 9 42 37
  • DERROTA
  • Wolves 2
  • Sheffield Wednesda. 0
  • EMPATE
  • Liverpool 2
  • Sheffield Wednesda. 2
  • VICTORIA
  • Sheffield Wednesda. 3
  • Nottingham Forest 0
  • DERROTA
  • Bolton Wanderers 2
  • Sheffield Wednesda. 1
  • VICTORIA
  • Sheffield Wednesda. 2
  • Bury 0
7 Everton Everton 31 30 14 3 13 62 57
  • DERROTA
  • Preston North End 4
  • Everton 1
  • VICTORIA
  • Everton 5
  • Derby County 2
  • VICTORIA
  • Everton 6
  • West Bromwich Albi. 3
  • VICTORIA
  • Derby County 0
  • Everton 1
  • DERROTA
  • Everton 1
  • Bury 2
8 Bolton Wanderers Bolton Wanderers 30 30 12 6 12 40 43
  • DERROTA
  • Bolton Wanderers 1
  • Aston Villa 2
  • DERROTA
  • Bolton Wanderers 1
  • Wolves 2
  • VICTORIA
  • Bolton Wanderers 2
  • Sheffield Wednesda. 1
  • DERROTA
  • Bolton Wanderers 0
  • Sheffield United 2
  • DERROTA
  • Wolves 4
  • Bolton Wanderers 0
9 Bury Bury 30 30 10 10 10 39 44
  • DERROTA
  • Stoke City 3
  • Bury 0
  • VICTORIA
  • Bury 3
  • Blackburn Rovers 0
  • EMPATE
  • Bury 1
  • Sunderland 1
  • DERROTA
  • Sheffield Wednesda. 2
  • Bury 0
  • VICTORIA
  • Everton 1
  • Bury 2
10 Wolves Wolves 28 30 11 6 13 45 41
  • VICTORIA
  • Burnley 0
  • Wolves 3
  • VICTORIA
  • Bolton Wanderers 1
  • Wolves 2
  • VICTORIA
  • Nottingham Forest 1
  • Wolves 2
  • DERROTA
  • Aston Villa 5
  • Wolves 0
  • VICTORIA
  • Wolves 4
  • Bolton Wanderers 0
11 Nottingham Forest Nottingham 26 30 9 8 13 44 49
  • EMPATE
  • Bolton Wanderers 0
  • Nottingham Forest 0
  • EMPATE
  • Sunderland 2
  • Nottingham Forest 2
  • DERROTA
  • Sheffield Wednesda. 3
  • Nottingham Forest 0
  • DERROTA
  • Nottingham Forest 1
  • Wolves 2
  • EMPATE
  • Nottingham Forest 0
  • Preston North End 0
12 West Bromwich Albion West Bromwich A. 26 30 10 6 14 33 56
  • DERROTA
  • Sunderland 2
  • West Bromwich Albi. 1
  • VICTORIA
  • West Bromwich Albi. 3
  • Burnley 0
  • DERROTA
  • Burnley 5
  • West Bromwich Albi. 0
  • DERROTA
  • Everton 6
  • West Bromwich Albi. 3
  • EMPATE
  • Preston North End 0
  • West Bromwich Albi. 0
13 Stoke City Stoke City 25 30 11 3 16 48 59
  • VICTORIA
  • Stoke City 3
  • Bury 0
  • DERROTA
  • Sheffield United 1
  • Stoke City 0
  • DERROTA
  • Stoke City 0
  • Sunderland 1
  • VICTORIA
  • Stoke City 1
  • Blackburn Rovers 0
  • VICTORIA
  • Stoke City 2
  • Sheffield United 0
14 Blackburn Rovers Blackburn Rovers 25 30 11 3 16 35 62
  • VICTORIA
  • Everton 0
  • Blackburn Rovers 3
  • VICTORIA
  • Blackburn Rovers 2
  • Stoke City 1
  • DERROTA
  • Bury 3
  • Blackburn Rovers 0
  • DERROTA
  • Stoke City 1
  • Blackburn Rovers 0
  • DERROTA
  • Aston Villa 3
  • Blackburn Rovers 0
15 Sunderland Sunderland 23 30 7 9 14 34 47
  • EMPATE
  • Sunderland 1
  • Burnley 1
  • VICTORIA
  • Sunderland 2
  • West Bromwich Albi. 1
  • EMPATE
  • Sunderland 2
  • Nottingham Forest 2
  • VICTORIA
  • Stoke City 0
  • Sunderland 1
  • EMPATE
  • Bury 1
  • Sunderland 1
16 Burnley Burnley 19 30 6 7 17 43 61
  • DERROTA
  • Burnley 0
  • Wolves 3
  • DERROTA
  • Burnley 2
  • Derby County 3
  • VICTORIA
  • Liverpool 1
  • Burnley 2
  • DERROTA
  • West Bromwich Albi. 3
  • Burnley 0
  • VICTORIA
  • Burnley 5
  • West Bromwich Albi. 0
Descenso : Burnley

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.

  USO DE MEMORIA  
5,281,760 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0756
Total Execution Time  0.0775
  CADENA URL  
/premier1897
  GET DATOS  
$_GET['/premier1897']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0029  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.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 08:43:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 08:43:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 08:43:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 08:43:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0176  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 `calendars1897` 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` = 5607 AND c.`round` = 30 ORDER BY shedule ASC LIMIT 200
0.0021  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 events1897 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1897 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 5607 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 (232,233,234,235,236,237,238,239,240) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0024  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 `tables1897` 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 = 5607 AND t.round = 29 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0055  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1897` 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 = 5607 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT data1, data2 FROM services_tags WHERE categoryId=10
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=10 AND year=1897