13 May 12	Finalizado	Chelsea	2 - 1	Blackburn Rovers	13
07 May 12	Finalizado	Blackburn Rovers	0 - 1	Wigan Athletic	15
29 Abr 12	Finalizado	Tottenham Hotspur	2 - 0	Blackburn Rovers	14
21 Abr 12	Finalizado	Blackburn Rovers	2 - 0	Norwich City	1
14 Abr 12	Finalizado	Swansea City	3 - 0	Blackburn Rovers	1
10 Abr 12	Finalizado	Blackburn Rovers	2 - 3	Liverpool	8
07 Abr 12	Finalizado	West Bromwich Albion	3 - 0	Blackburn Rovers	0
02 Abr 12	Finalizado	Blackburn Rovers	0 - 2	Manchester United	64
24 Mar 12	Finalizado	Bolton Wanderers	2 - 1	Blackburn Rovers	4
20 Mar 12	Finalizado	Blackburn Rovers	2 - 0	Sunderland	8
10 Mar 12	Finalizado	Wolves	0 - 2	Blackburn Rovers	6
03 Mar 12	Finalizado	Blackburn Rovers	1 - 1	Aston Villa	8
25 Feb 12	Finalizado	Manchester City	3 - 0	Blackburn Rovers	17
11 Feb 12	Finalizado	Blackburn Rovers	3 - 2	Queens Park Rangers	0
04 Feb 12	Finalizado	Arsenal	7 - 1	Blackburn Rovers	104
01 Feb 12	Finalizado	Blackburn Rovers	0 - 2	Newcastle	6
21 Ene 12	Finalizado	Everton	1 - 1	Blackburn Rovers	3
14 Ene 12	Finalizado	Blackburn Rovers	3 - 1	Fulham	14
02 Ene 12	Finalizado	Blackburn Rovers	1 - 2	Stoke City	10
31 Dic 11	Finalizado	Manchester United	2 - 3	Blackburn Rovers	67
26 Dic 11	Finalizado	Liverpool	1 - 1	Blackburn Rovers	20
20 Dic 11	Finalizado	Blackburn Rovers	1 - 2	Bolton Wanderers	15
17 Dic 11	Finalizado	Blackburn Rovers	1 - 2	West Bromwich Albion	0
11 Dic 11	Finalizado	Sunderland	2 - 1	Blackburn Rovers	6
03 Dic 11	Finalizado	Blackburn Rovers	4 - 2	Swansea City	8
26 Nov 11	Finalizado	Stoke City	3 - 1	Blackburn Rovers	11
19 Nov 11	Finalizado	Wigan Athletic	3 - 3	Blackburn Rovers	8
05 Nov 11	Finalizado	Blackburn Rovers	0 - 1	Chelsea	30
29 Oct 11	Finalizado	Norwich City	3 - 3	Blackburn Rovers	7
23 Oct 11	Finalizado	Blackburn Rovers	1 - 2	Tottenham Hotspur	11
15 Oct 11	Finalizado	Queens Park Rangers	1 - 1	Blackburn Rovers	0
01 Oct 11	Finalizado	Blackburn Rovers	0 - 4	Manchester City	52
24 Sep 11	Finalizado	Newcastle	3 - 1	Blackburn Rovers	12
17 Sep 11	Finalizado	Blackburn Rovers	4 - 3	Arsenal	123
11 Sep 11	Finalizado	Fulham	1 - 1	Blackburn Rovers	7
27 Ago 11	Finalizado	Blackburn Rovers	0 - 1	Everton	2
20 Ago 11	Finalizado	Aston Villa	3 - 1	Blackburn Rovers	10
13 Ago 11	Finalizado	Blackburn Rovers	1 - 2	Wolves	2

FA Cup »

07 Ene 12

Finalizado

Newcastle

2 - 1

Blackburn Rovers

EFL Cup »

29 Nov 11	Finalizado	Cardiff City	2 - 0	Blackburn Rovers
26 Oct 11	Finalizado	Blackburn Rovers	4 - 3	Newcastle
20 Sep 11	Finalizado	Blackburn Rovers	3 - 2	Leyton Orient
24 Ago 11	Finalizado	Blackburn Rovers	3 - 1	Sheffield Wednesday

Partidos Amistosos »

	30 Jul 11	Finalizado	Kitchee FC	0 - 3	Blackburn Rovers			6
	27 Jul 11	Finalizado	Aston Villa	1 - 0	Blackburn Rovers			0

Estadísticas

GOLEADORES

AMARILLAS

J. Lowe10

ROJAS

D. Dunn1

Plantilla del Blackburn Rovers Temporada 2011/2012

		Edad	Altura	Peso
Portero
34	J. Kean	33	193	76	-	-	-
13	M. Bunn	39	183	77	-	-	-
1	P. Robinson	44	190	73	-	-	-
42	S. Usai	34	190	84	-	-	-
Defensa
39	A. Henley	29	178	77	-	-	-
18	B. Orr	41	183	75	-	-	2
4	C. Samba	40	193	91	2	-	2
5	G. Givet	42	181	75	-	1	2
31	Grant Hanley	32	188	76	1	-	6
38	M. Anderson	34	190	85	-	-	-
21	Marcus Olsson	35	180	72	-	-	-
3	Martin Olsson	35	178	81	-	1	5
2	Míchel Salgado	48	-	-	-	-	4
6	R. Nelsen	46	185	90	-	-	-
16	S. Dann	37	188	76	1	-	2
Centrocampista
	A. Linganzi	34	186	81	-	-	-
7	B. Emerton	45	185	85	-	-	1
32	Bruno Ribeiro	41	171	67	-	-	-
8	D. Dunn	44	175	78	2	1	5
35	J. Lowe	32	183	80	-	-	10
33	J. Morris	32	180	70	-	-	-
10	M. Formica	36	178	67	4	-	3
12	M. Pedersen	42	183	74	3	-	6
14	R. Petrović	35	193	89	-	-	4
20	Ruben Rochina	33	179	74	2	-	2
15	S. N'zonzi	35	196	75	2	-	7
11	Vince Grella	44	183	79	-	-	-
Delantero
9	A. Modeste	36	188	83	-	1	1
25	D. Goodwillie	35	175	71	2	-	-
23	J. Hoilett	33	174	71	7	-	5
30	J. Roberts	46	185	79	-	-	2
19	J. Slew	31	178	81	-	-	-
22	N. Blackman	34	188	74	-	-	-
29	S. Vukcevic	38	179	77	1	-	-
24	Yakubu Ayegbeni	41	183	83	17	1	1

Noticias del Blackburn Rovers

Ver últimas noticias

El Swansea pregunta por Rhodes

BeSoccer - Viernes, 22 Enero 2016

0 235

El internacional escocés está cuajando una notable campaña en el Blackburn Rovers, histórico club inglés que deambula desde hace un par de años en la Championship.

El Sunderland cede a Graham al Blackburn Rovers

Isabel Ruiz - Miércoles, 20 Enero 2016

0 157

Danny Graham deja temporalmente el Sunderland para incorporarse al Blackburn Rovers.

Un Blackburn Rovers en inferioridad elimina al Newport de la FA Cup

BeSoccer - Lunes, 18 Enero 2016

0 218

El Blackburn Rovers, que milita en la segunda división (Championship), alcanzó este lunes la cuarta ronda de la Copa inglesa tras derrotar por 1-2 al Newport County, de la cuarta categoría (League 1) y ante el que jugó en inferioridad desde el minuto 10.

Varney retorna al Ipswich Town

BeSoccer - Viernes, 18 Diciembre 2015

1 482

El atacante ya jugó la pasada temporada allí, cedido por el Blackburn Rovers. Tras recuperarse de una lesión en el talón de aquiles, volverá hasta final de temporada.

Lambert es el nuevo técnico del Blackburn Rovers

BeSoccer - Domingo, 15 Noviembre 2015

0 237

El Blackburn Rovers, conjunto de la Championship, segunda categoría del fútbol inglés, anunció este domingo la contratación del escocés Paul Lambert como nuevo técnico.

Ver más noticias del equipo»

Pos	Equipos	Pts
1		Manchester City	89
2		Manchester United	89
3		Arsenal	70
4		Tottenham Hotspur	69
5		Newcastle	65
6		Chelsea	64
7		Everton	56
8		Liverpool	52
9		Fulham	52
10		West Bromwich Albion	47
11		Swansea City	47
12		Norwich City	47
13		Sunderland	45
14		Stoke City	45
15		Wigan Athletic	43
16		Aston Villa	38
17		Queens Park Rangers	37
18		Bolton Wanderers	36
19		Blackburn Rovers	31
20		Wolves	25

Pos

Equipos

Pts

	Champions League : Manchester City, Manchester United, Arsenal, Chelsea
	Europa League : Tottenham Hotspur, Newcastle, Liverpool
	Descenso : Bolton Wanderers, Blackburn Rovers, Wolves

Champions League : Manchester City, Manchester United, Arsenal, Chelsea

Europa League : Tottenham Hotspur, Newcastle, Liverpool

Descenso : Bolton Wanderers, Blackburn Rovers, Wolves

USO DE MEMORIA

6,371,896 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1839
Total Execution Time	0.1858

CADENA URL

/Blackburn-Rovers-Fc/2012

GET DATOS

$_GET['/Blackburn-Rovers-Fc/2012']

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

0.0018	SELECT type FROM routes WHERE alias = 'blackburn-rovers-fc'
0.0065	SELECT dt.,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM* `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Blackburn-Rovers-Fc' AND l.year = 2012 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=507 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=507 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=507 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=507 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=507 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 1323
0.0045	SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '507' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023	(SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2012 as c ON c.league_id = l.id WHERE (c.datateam1 = 507 or c.datateam2 = 507) AND l.year = 2012 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0027	(SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2012 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 507 or c.datateam2 = 507) AND l.year = 2012 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0036	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2012 as c ON c.league_id = l.id INNER JOIN events2012 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 507 or c.datateam2 = 507) AND l.year = 2012)
0.0045	SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=507 AND l.year in (2011,2012,2013) ORDER BY l.id DESC, l.year DESC ;
0.0042	SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (20550,14433,1919,1906,1315) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 1315 AND teamId = 507
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 1919 AND teamId = 507
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 14433 AND teamId = 507
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 20550 AND teamId = 507
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 1906 AND teamId = 507
0.0021	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '507' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '507' and rp.type = 4
0.0021	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '507' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0033	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2012 e ON e.player_id = p.id AND e.league_id = 1315 WHERE rp.league_id = 1315 AND rp.teamId = 507 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0040	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2012 e ON e.player_id = p.id AND e.league_id = 1315 WHERE rp.league_id = 1315 AND rp.teamId = 507 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2012 e ON e.player_id = p.id AND e.league_id = 1315 WHERE rp.league_id = 1315 AND rp.teamId = 507 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 507 AND rp.league_id = 1315 AND l.year= 2012 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0034	SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=28817 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0019	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=28817
0.0026	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2012 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=28817 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0025	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2012 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=28817 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0026	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2012 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=28817 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0024	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2012 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=28817 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0034	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2012 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=28817 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Blackburn Rovers

Información sobre Blackburn Rovers

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

FA Cup

Premier League

Championship

EFL Cup

Partidos Amistosos

Europa League Grupo 0

Community Shield

Champions League Grupo 2

Championship - Play Offs Ascenso

League One

EFL Trophy

Fase Previa Europa League

Copa Intertoto

Partidos del Blackburn Rovers

Estadísticas

Plantilla del Blackburn Rovers Temporada 2011/2012

Noticias del Blackburn Rovers

El Swansea pregunta por Rhodes

El Sunderland cede a Graham al Blackburn Rovers

Un Blackburn Rovers en inferioridad elimina al Newport de la FA Cup

Varney retorna al Ipswich Town

Lambert es el nuevo técnico del Blackburn Rovers

Blackburn Rovers

Selecciona un equipo

Competiciones que juega

Premier League

RIVALES EN EFL Cup

RIVALES EN FA Cup

RIVALES EN Premier League