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

efl championship, english football league championship, campeonato de la liga de futbol ingles, campeonato sky bet, segunda division inglesa, segunda division de inglaterra

Championship 2007

  • Sunderland
  • Birmingham City
  • Derby County
  • West Bromwich Albion
  • Wolves
  • Southampton
  • Preston North End
  • Stoke City
  • Sheffield Wednesday
  • Colchester United
  • Plymouth Argyle
  • Crystal Palace
  • Cardiff City
  • Ipswich Town
  • Burnley
  • Norwich City
  • Coventry City
  • Queens Park Rangers
  • Leicester
  • Barnsley
  • Hull City
  • Leeds United
  • Southend United
  • Luton Town

Clasificación

Equipo PJ GF GC Puntos
1 Sunderland Sunderland 46 76 47 88
2 Birmingham City Birmingham 46 67 42 86
3 Derby County Derby County 46 62 46 84
4 West Bromwich Albion West 46 81 55 76
5 Wolves Wolves 46 59 56 76
6 Southampton Southampton 46 77 53 75
7 Preston North End Preston 46 64 53 74
8 Stoke City Stoke City 46 62 41 73
9 Sheffield Wednesday Sheffield 46 70 66 71
10 Colchester United Colchester 46 70 56 69
11 Plymouth Argyle Plymouth 46 63 62 67
12 Crystal Palace Crystal 46 59 51 65
13 Cardiff City Cardiff City 46 57 53 64
14 Ipswich Town Ipswich Town 46 64 59 62
15 Burnley Burnley 46 52 49 57
16 Norwich City Norwich City 46 56 71 57
17 Coventry City Coventry 46 47 62 56
18 Queens Park Rangers Queens Park 46 54 68 53
19 Leicester Leicester 46 49 64 53
20 Barnsley Barnsley 46 53 85 50
21 Hull City Hull City 46 51 67 49
22 Leeds United Leeds United 46 46 72 46
23 Southend United Southend 46 47 80 42
24 Luton Town Luton Town 46 53 81 40

  USO DE MEMORIA  
5,795,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1475
Total Execution Time  0.1494
  CADENA URL  
/championship2007/grupo1/resumen/46
  GET DATOS  
$_GET['/championship2007/grupo1/resumen/46']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0021  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 = 155 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 `calendars2007` 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` = 155 AND c.`round` = 46 ORDER BY shedule ASC LIMIT 200
0.0126  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 `events2007` e INNER JOIN calendars2007 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 = 46 AND e.real_date IS NOT NULL AND e.league_id = 155 ORDER BY total DESC LIMIT 100
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 04:40:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 04:40:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 04:40:43' 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-28 04:40:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0253  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 events2007 e ON e.player_id = p.id AND e.league_id = 155 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 155 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.0325  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 events2007 e ON e.player_id = p.id AND e.league_id = 155 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 155 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0187  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 events2007 e ON e.player_id = p.id AND e.league_id = 155 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 155 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0052  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` 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 = 155 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC