4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2008
Temporada Siguiente »
Premier League 2008
2007/2008

liga inglesa,the premiership,liga premier,football league first division,primera division inglesa,premier,premier league,primera division de inglaterra

Premier League 2008

  • Manchester United
  • Chelsea
  • Arsenal
  • Liverpool
  • Everton
  • Aston Villa
  • Blackburn Rovers
  • Portsmouth
  • Manchester City
  • West Ham
  • Tottenham Hotspur
  • Newcastle
  • Middlesbrough
  • Wigan Athletic
  • Sunderland
  • Bolton Wanderers
  • Fulham
  • Reading
  • Birmingham City
  • Derby County

Clasificación

Equipo PJ GF GC Puntos
1 Manchester United Manchester 38 80 22 87
2 Chelsea Chelsea 38 65 26 85
3 Arsenal Arsenal 38 74 31 83
4 Liverpool Liverpool 38 67 28 76
5 Everton Everton 38 55 33 65
6 Aston Villa Aston Villa 38 71 51 60
7 Blackburn Rovers Blackburn 38 50 48 58
8 Portsmouth Portsmouth 38 48 40 57
9 Manchester City Manchester 38 45 53 55
10 West Ham West Ham 38 42 50 49
11 Tottenham Hotspur Tottenham 38 66 61 46
12 Newcastle Newcastle 38 45 65 43
13 Middlesbrough Middlesbroug 38 43 53 42
14 Wigan Athletic Wigan 38 34 51 40
15 Sunderland Sunderland 38 36 59 39
16 Bolton Wanderers Bolton 38 36 54 37
17 Fulham Fulham 38 38 60 36
18 Reading Reading 38 41 66 36
19 Birmingham City Birmingham 38 46 62 35
20 Derby County Derby County 38 20 89 11

  USO DE MEMORIA  
5,506,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3766
Total Execution Time  0.3785
  CADENA URL  
/premier2008/grupo1/resumen/38
  GET DATOS  
$_GET['/premier2008/grupo1/resumen/38']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0129  SELECT type FROM routes WHERE alias = 'premier2008'
0.0254  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0127  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 29 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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 `calendars2008` 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` = 29 AND c.`round` = 38 ORDER BY shedule ASC LIMIT 200
0.0246  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 `events2008` e INNER JOIN calendars2008 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 = 38 AND e.real_date IS NOT NULL AND e.league_id = 29 ORDER BY total DESC LIMIT 100
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 06:10:01' 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-05-09 06:10:01' 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-05-09 06:10:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 06:10:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0135  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0586  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 events2008 e ON e.player_id = p.id AND e.league_id = 29 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 29 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.0307  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 events2008 e ON e.player_id = p.id AND e.league_id = 29 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 29 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0212  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 events2008 e ON e.player_id = p.id AND e.league_id = 29 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 29 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2008` 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 = 29 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC