Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

« Temporada Anterior

Temporada Siguiente »

2016/2017

Championship 2017

Premier League

Championship 2017

La temporada finalizó el Domingo, 07 Mayo 2017.

	18 Oct 16 20:45 Finalizado	Barnsley	Barnsley - Newcastle 2016-10-18T20:45:00 Oakwell Stadium 0-2	Newcastle	más información Jugadas destacadas 24
			0-1	49' D. Gayle
			0-2	68' D. Gayle
	18 Oct 16 20:45 Finalizado	Birmingham City	Birmingham City - Rotherham United 2016-10-18T20:45:00 St. Andrew's Stadium 4-2	Rotherham United	más información Jugadas destacadas 8
		15' M. Morrison	1-0
			1-1	32' D. Ward
		35' L. Jutkiewicz	2-1
		43' J. Maghoma	3-1
			3-2	56' J. Taylor
		84' D. Cotterill	4-2
	18 Oct 16 20:45 Finalizado	Blackburn Rovers	Blackburn Rovers - Nottingham Forest 2016-10-18T20:45:00 Ewood Park 2-1	Nottingham Forest	más información Jugadas destacadas 14
		11' Sam Gallagher	1-0
		44' Sam Gallagher	2-0
			2-1	90' D. Perquis
				90' Hildeberto Pereira
	18 Oct 16 20:45 Finalizado	Brighton & Hove Albion	Brighton & Hove Albion - Wolves 2016-10-18T20:45:00 The American Express Community Stadium 1-0	Wolves	más información Jugadas destacadas 7
		14' S. Baldock	1-0
	18 Oct 16 20:45 Finalizado	Derby County	Derby County - Brentford 2016-10-18T20:45:00 iPro Stadium 0-0	Brentford	más información 17
	18 Oct 16 20:45 Finalizado	Fulham	Fulham - Norwich City 2016-10-18T20:45:00 Craven Cottage 2-2	Norwich City	más información Jugadas destacadas 31
			0-1	17' G. Dorrans
			0-2	41' G. Dorrans
		55' Stefan Johansen	1-2
		67' C. Martin	2-2
	18 Oct 16 20:45 Finalizado	Ipswich Town	Ipswich Town - Burton Albion 2016-10-18T20:45:00 Portman Road Stadium 2-0	Burton Albion	más información Jugadas destacadas 3
		15' L. Chambers	1-0
		88' Freddie Sears	2-0
	18 Oct 16 20:45 Finalizado	Leeds United	Leeds United - Wigan Athletic 2016-10-18T20:45:00 Elland Road 1-1	Wigan Athletic	más información Jugadas destacadas 12
		29' Chris Wood	1-0
			1-1	90' S. MacDonald
	18 Oct 16 20:45 Finalizado	Queens Park Rangers	Queens Park Rangers - Bristol City 2016-10-18T20:45:00 Loftus Road 1-0	Bristol City	más información Jugadas destacadas 4
		75' I. Sylla	1-0
	18 Oct 16 21:00 Finalizado	Reading	Reading - Aston Villa 2016-10-18T21:00:00 Madejski Stadium 1-2	Aston Villa	más información Jugadas destacadas 15
			0-1	38' J. Kodjia
		54' D. Williams
		54' Y. Kermorgant	1-1
			1-2	90' Jordan Ayew
	19 Oct 16 20:45 Finalizado	Cardiff City	Cardiff City - Sheffield Wednesday 2016-10-19T20:45:00 Cardiff City Stadium 1-1	Sheffield Wednesday	más información Jugadas destacadas 5
		9' Peter Whittingham	1-0
			1-1	55' D. Pudil
	19 Oct 16 20:45 Finalizado	Preston North End	Preston North End - Huddersfield Town 2016-10-19T20:45:00 Deepdale Stadium 3-1	Huddersfield Town	más información Jugadas destacadas 6
		6' T. Clarke	1-0
		42' A. Baptiste	2-0
		53' P. Gallagher	3-0
			3-1	81' N. Wells

Equipos		Puntos	J.	G.	E.	P.	F.	C.	Forma
1	Newcastle	28	13	9	1	3	27	11	EMPATE Aston Villa 1 Newcastle 1 VICTORIA Newcastle 4 Norwich City 3 VICTORIA Rotherham United 0 Newcastle 1 VICTORIA Newcastle 3 Brentford 1 VICTORIA Barnsley 0 Newcastle 2
2	Norwich City	27	13	8	3	2	26	18	VICTORIA Norwich City 3 Burton Albion 1 DERROTA Newcastle 4 Norwich City 3 VICTORIA Wolves 1 Norwich City 2 VICTORIA Norwich City 3 Rotherham United 1 EMPATE Fulham 2 Norwich City 2
3	Brighton Hove A.	25	13	7	4	2	17	9	VICTORIA Brighton & Hove Al. 2 Barnsley 0 EMPATE Ipswich Town 0 Brighton & Hove Al. 0 VICTORIA Sheffield Wednesda. 1 Brighton & Hove Al. 2 EMPATE Brighton & Hove Al. 2 Preston North End 2 VICTORIA Brighton & Hove Al. 1 Wolves 0
4	Huddersfield	25	13	8	1	4	15	12	DERROTA Reading 1 Huddersfield Town 0 VICTORIA Huddersfield Town 2 Rotherham United 1 VICTORIA Ipswich Town 0 Huddersfield Town 1 DERROTA Huddersfield Town 0 Sheffield Wednesda. 1 DERROTA Preston North End 3 Huddersfield Town 1
5	Birmingham City	23	13	6	5	2	19	14	EMPATE Queens Park Ranger. 1 Birmingham City 1 EMPATE Birmingham City 2 Preston North End 2 VICTORIA Birmingham City 1 Blackburn Rovers 0 DERROTA Nottingham Forest 3 Birmingham City 1 VICTORIA Birmingham City 4 Rotherham United 2
6	Sheffield	21	13	6	3	4	15	15	VICTORIA Sheffield Wednesda. 2 Nottingham Forest 1 VICTORIA Blackburn Rovers 0 Sheffield Wednesda. 1 DERROTA Sheffield Wednesda. 1 Brighton & Hove Al. 2 VICTORIA Huddersfield Town 0 Sheffield Wednesda. 1 EMPATE Cardiff City 1 Sheffield Wednesda. 1
7	Bristol City	20	13	6	2	5	20	15	VICTORIA Fulham 0 Bristol City 4 VICTORIA Bristol City 1 Leeds United 0 VICTORIA Bristol City 2 Nottingham Forest 1 DERROTA Cardiff City 2 Bristol City 1 DERROTA Queens Park Ranger. 1 Bristol City 0
8	Brentford	19	13	5	4	4	19	12	DERROTA Wolves 3 Brentford 1 VICTORIA Brentford 4 Reading 1 EMPATE Brentford 0 Wigan Athletic 0 DERROTA Newcastle 3 Brentford 1 EMPATE Derby County 0 Brentford 0
9	Queens Park Ran.	19	13	5	4	4	16	18	EMPATE Queens Park Ranger. 1 Birmingham City 1 EMPATE Burton Albion 1 Queens Park Ranger. 1 VICTORIA Fulham 1 Queens Park Ranger. 2 EMPATE Queens Park Ranger. 1 Reading 1 VICTORIA Queens Park Ranger. 1 Bristol City 0
10	Reading	19	13	5	4	4	14	18	VICTORIA Reading 1 Huddersfield Town 0 DERROTA Brentford 4 Reading 1 EMPATE Reading 1 Derby County 1 EMPATE Queens Park Ranger. 1 Reading 1 DERROTA Reading 1 Aston Villa 2
11	Fulham	18	13	4	6	3	16	17	DERROTA Fulham 0 Bristol City 4 EMPATE Nottingham Forest 1 Fulham 1 DERROTA Fulham 1 Queens Park Ranger. 2 VICTORIA Barnsley 2 Fulham 4 EMPATE Fulham 2 Norwich City 2
12	Ipswich Town	17	13	4	5	4	10	9	DERROTA Leeds United 1 Ipswich Town 0 EMPATE Ipswich Town 0 Brighton & Hove Al. 0 DERROTA Ipswich Town 0 Huddersfield Town 1 EMPATE Blackburn Rovers 0 Ipswich Town 0 VICTORIA Ipswich Town 2 Burton Albion 0
13	Preston North	17	13	5	2	6	17	17	VICTORIA Preston North End 1 Wigan Athletic 0 EMPATE Birmingham City 2 Preston North End 2 VICTORIA Preston North End 2 Aston Villa 0 EMPATE Brighton & Hove Al. 2 Preston North End 2 VICTORIA Preston North End 3 Huddersfield Town 1
14	Leeds United	17	13	5	2	6	13	15	VICTORIA Leeds United 1 Ipswich Town 0 DERROTA Bristol City 1 Leeds United 0 VICTORIA Leeds United 2 Barnsley 1 DERROTA Derby County 1 Leeds United 0 EMPATE Leeds United 1 Wigan Athletic 1
15	Barnsley	16	13	5	1	7	23	22	DERROTA Brighton & Hove Al. 2 Barnsley 0 EMPATE Barnsley 1 Aston Villa 1 DERROTA Leeds United 2 Barnsley 1 DERROTA Barnsley 2 Fulham 4 DERROTA Barnsley 0 Newcastle 2
16	Wolves	16	13	4	4	5	16	16	VICTORIA Wolves 3 Brentford 1 DERROTA Wigan Athletic 2 Wolves 1 DERROTA Wolves 1 Norwich City 2 EMPATE Aston Villa 1 Wolves 1 DERROTA Brighton & Hove Al. 1 Wolves 0
17	Nottingham	15	13	4	3	6	23	25	DERROTA Sheffield Wednesda. 2 Nottingham Forest 1 EMPATE Nottingham Forest 1 Fulham 1 DERROTA Bristol City 2 Nottingham Forest 1 VICTORIA Nottingham Forest 3 Birmingham City 1 DERROTA Blackburn Rovers 2 Nottingham Forest 1
18	Aston Villa	14	13	2	8	3	13	14	EMPATE Aston Villa 1 Newcastle 1 EMPATE Barnsley 1 Aston Villa 1 DERROTA Preston North End 2 Aston Villa 0 EMPATE Aston Villa 1 Wolves 1 VICTORIA Reading 1 Aston Villa 2
19	Burton Albion	14	13	3	5	5	16	18	DERROTA Norwich City 3 Burton Albion 1 EMPATE Burton Albion 1 Queens Park Ranger. 1 VICTORIA Burton Albion 2 Cardiff City 0 EMPATE Wigan Athletic 0 Burton Albion 0 DERROTA Ipswich Town 2 Burton Albion 0
20	Derby County	14	13	3	5	5	7	10	DERROTA Derby County 1 Blackburn Rovers 2 VICTORIA Cardiff City 0 Derby County 2 EMPATE Reading 1 Derby County 1 VICTORIA Derby County 1 Leeds United 0 EMPATE Derby County 0 Brentford 0
21	Blackburn Rovers	12	13	3	3	7	14	21	VICTORIA Derby County 1 Blackburn Rovers 2 DERROTA Blackburn Rovers 0 Sheffield Wednesda. 1 DERROTA Birmingham City 1 Blackburn Rovers 0 EMPATE Blackburn Rovers 0 Ipswich Town 0 VICTORIA Blackburn Rovers 2 Nottingham Forest 1
22	Cardiff City	12	13	3	3	7	11	21	VICTORIA Rotherham United 1 Cardiff City 2 DERROTA Cardiff City 0 Derby County 2 DERROTA Burton Albion 2 Cardiff City 0 VICTORIA Cardiff City 2 Bristol City 1 EMPATE Cardiff City 1 Sheffield Wednesda. 1
23	Wigan Athletic	11	13	2	5	6	13	15	DERROTA Preston North End 1 Wigan Athletic 0 VICTORIA Wigan Athletic 2 Wolves 1 EMPATE Brentford 0 Wigan Athletic 0 EMPATE Wigan Athletic 0 Burton Albion 0 EMPATE Leeds United 1 Wigan Athletic 1
24	Rotherham United	6	13	1	3	9	14	32	DERROTA Rotherham United 1 Cardiff City 2 DERROTA Huddersfield Town 2 Rotherham United 1 DERROTA Rotherham United 0 Newcastle 1 DERROTA Norwich City 3 Rotherham United 1 DERROTA Birmingham City 4 Rotherham United 2

	Ascenso : Newcastle, Norwich City
	Playoff Ascenso : Brighton Hove A., Huddersfield, Birmingham City, Sheffield
	Descenso : Cardiff City, Wigan Athletic, Rotherham United

JUGADORES DESTACADOS

RK		Nombre	Goles	Posición	Equipo
1		Chris Wood	27	DEL	Leeds United
2		Tammy Abraham	24	DEL	Bristol City
3		G. Murray	23	DEL	Brighton & Hove Albi.
4		D. Gayle	23	DEL	Newcastle
5		J. Kodjia	19	DEL	Aston Villa
6		Y. Kermorgant	18	DEL	Reading
7		C. Jerome	16	DEL	Norwich City
8		A. Knockaert	15	DEL	Brighton & Hove Albi.
9		Scott Hogan	15	DEL	Aston Villa
10		L. Vibe	15	DEL	Brentford
11		Tom Ince	14	DEL	Derby County
12		S. Winnall	14	DEL	Sheffield Wednesday
13		B. Assombalonga	14	DEL	Nottingham Forest
14		Danny Graham	12	DEL	Blackburn Rovers
15		F. Forestieri	12	DEL	Sheffield Wednesday
16		Tom Cairney	12	MED	Fulham
17		Kenneth Zohore	12	DEL	Cardiff City
18		Matt Ritchie	12	DEF	Newcastle
19		E. Kachunga	12	DEL	Huddersfield Town
20		Jota	12	DEL	Brentford

Busca la liga de tu equipo

Introduce el nombre de tu equipo y busca rápidamente su competición

NOTICIAS RELACIONADAS

Ver más noticias de la competicion»

Equipos de esta competición

24

INFORMACIÓN

La Football League Championship, o The Championship (que por razones de patrocinio es llamada en el Reino Unido NPower Football
League Championship) es la máxima competición futbolística de la Football League, y la segunda de la Liga inglesa de fútbol (por debajo de la FA Premier League

USO DE MEMORIA

7,046,360 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.0899
Total Execution Time	0.0919

CADENA URL

/championship2017/grupo1/jornada13

GET DATOS

$_GET['/championship2017/grupo1/jornada13']

POST DATOS

No hay datos POST existentes

CONSULTAS (13)

0.0022	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.0019	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 12:59:48' 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-27 12:59:48' 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-27 12:59:48' 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=3 AND last_update > '2024-04-27 12:59:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020	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=30627 AND rel.round=13
0.0025	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 `calendars2017` 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` = 30627 AND c.`round` = 13 ORDER BY shedule ASC LIMIT 200
0.0038	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 events2017 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2017 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 30627 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 (49541,49542,49543,49544,49546,49547,49548,49549,49551,49552,49545,49550) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0057	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 `events2017` e INNER JOIN calendars2017 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 = 13 AND e.real_date IS NOT NULL AND e.league_id = 30627 ORDER BY total DESC LIMIT 40
0.0049	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2017` 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 = 30627 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT distinct(shedule), round FROM `calendars2017` as c WHERE c.`league_id` = 30627 AND shedule >= '2016/10/01' AND shedule < '2016/11/01' ORDER BY shedule ASC
0.0018	SELECT data1, data2 FROM services_tags WHERE categoryId=25
0.0047	SELECT group_code, extraName from `leagues` WHERE categoryId=25 AND year=2017