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

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

Championship 2015

  • AFC Bournemouth
  • Watford
  • Norwich City
  • Middlesbrough
  • Brentford
  • Ipswich Town
  • Wolves
  • Derby County
  • Blackburn Rovers
  • Birmingham City
  • Cardiff City
  • Charlton Athletic
  • Sheffield Wednesday
  • Nottingham Forest
  • Leeds United
  • Huddersfield Town
  • Fulham
  • Bolton Wanderers
  • Reading
  • Brighton & Hove Albion
  • Rotherham United
  • Millwall
  • Wigan Athletic
  • Blackpool

Clasificación

Equipo PJ GF GC Puntos
1 AFC Bournemouth Bournemouth 46 98 45 90
2 Watford Watford 46 91 50 89
3 Norwich City Norwich City 46 88 48 86
4 Middlesbrough Middlesbroug 46 68 37 85
5 Brentford Brentford 46 78 59 78
6 Ipswich Town Ipswich Town 46 72 54 78
7 Wolves Wolves 46 70 56 78
8 Derby County Derby County 46 85 56 77
9 Blackburn Rovers Blackburn 46 66 59 67
10 Birmingham City Birmingham 46 54 64 63
11 Cardiff City Cardiff City 46 57 61 62
12 Charlton Athletic Charlton 46 54 60 60
13 Sheffield Wednesday Sheffield 46 43 49 60
14 Nottingham Forest Nottingham 46 71 69 59
15 Leeds United Leeds United 46 50 61 56
16 Huddersfield Town Huddersfield 46 58 75 55
17 Fulham Fulham 46 62 83 52
18 Bolton Wanderers Bolton 46 54 67 51
19 Reading Reading 46 48 69 50
20 Brighton & Hove Albion Brighton 46 44 54 47
21 Rotherham United Rotherham 46 46 67 46
22 Millwall Millwall 46 42 76 41
23 Wigan Athletic Wigan 46 39 64 39
24 Blackpool Blackpool 46 36 91 26

  USO DE MEMORIA  
5,699,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.3918
Total Execution Time  0.3940
  CADENA URL  
/championship2015/grupo1/resumen/46
  GET DATOS  
$_GET['/championship2015/grupo1/resumen/46']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0144  SELECT type FROM routes WHERE alias = 'championship2015'
0.0292  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 = 2015 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0153  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 `calendars2015` 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` = 3812 AND c.`round` = 46 ORDER BY shedule ASC LIMIT 200
0.0253  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 `events2015` e INNER JOIN calendars2015 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 = 3812 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-05-01 16:13:59' 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-05-01 16:13:59' 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-05-01 16:13:59' 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=3 AND last_update > '2024-05-01 16:13:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  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 = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2015 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0339  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 events2015 e ON e.player_id = p.id AND e.league_id = 3812 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 3812 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.0392  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 events2015 e ON e.player_id = p.id AND e.league_id = 3812 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 3812 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0161  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 events2015 e ON e.player_id = p.id AND e.league_id = 3812 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 3812 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0303  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 3812 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC