13 May 12	Finalizado	Everton	3 - 1	Newcastle	37
06 May 12	Finalizado	Newcastle	0 - 2	Manchester City	58
02 May 12	Finalizado	Chelsea	0 - 2	Newcastle	24
28 Abr 12	Finalizado	Wigan Athletic	4 - 0	Newcastle	18
21 Abr 12	Finalizado	Newcastle	3 - 0	Stoke City	16
09 Abr 12	Finalizado	Newcastle	2 - 0	Bolton Wanderers	2
06 Abr 12	Finalizado	Swansea City	0 - 2	Newcastle	19
01 Abr 12	Finalizado	Newcastle	2 - 0	Liverpool	20
25 Mar 12	Finalizado	West Bromwich Albion	1 - 3	Newcastle	0
18 Mar 12	Finalizado	Newcastle	1 - 0	Norwich City	7
12 Mar 12	Finalizado	Arsenal	2 - 1	Newcastle	93
04 Mar 12	Finalizado	Newcastle	1 - 1	Sunderland	6
25 Feb 12	Finalizado	Newcastle	2 - 2	Wolves	3
11 Feb 12	Finalizado	Tottenham Hotspur	5 - 0	Newcastle	33
05 Feb 12	Finalizado	Newcastle	2 - 1	Aston Villa	23
01 Feb 12	Finalizado	Blackburn Rovers	0 - 2	Newcastle	6
21 Ene 12	Finalizado	Fulham	5 - 2	Newcastle	14
15 Ene 12	Finalizado	Newcastle	1 - 0	Queens Park Rangers	0
04 Ene 12	Finalizado	Newcastle	3 - 0	Manchester United	120
30 Dic 11	Finalizado	Liverpool	3 - 1	Newcastle	76
26 Dic 11	Finalizado	Bolton Wanderers	0 - 2	Newcastle	9
21 Dic 11	Finalizado	Newcastle	2 - 3	West Bromwich Albion	0
17 Dic 11	Finalizado	Newcastle	0 - 0	Swansea City	4
10 Dic 11	Finalizado	Norwich City	4 - 2	Newcastle	17
03 Dic 11	Finalizado	Newcastle	0 - 3	Chelsea	26
26 Nov 11	Finalizado	Manchester United	1 - 1	Newcastle	62
19 Nov 11	Finalizado	Manchester City	3 - 1	Newcastle	43
05 Nov 11	Finalizado	Newcastle	2 - 1	Everton	26
31 Oct 11	Finalizado	Stoke City	1 - 3	Newcastle	7
22 Oct 11	Finalizado	Newcastle	1 - 0	Wigan Athletic	10
16 Oct 11	Finalizado	Newcastle	2 - 2	Tottenham Hotspur	23
01 Oct 11	Finalizado	Wolves	1 - 2	Newcastle	10
24 Sep 11	Finalizado	Newcastle	3 - 1	Blackburn Rovers	12
17 Sep 11	Finalizado	Aston Villa	1 - 1	Newcastle	20
12 Sep 11	Finalizado	Queens Park Rangers	0 - 0	Newcastle	0
28 Ago 11	Finalizado	Newcastle	2 - 1	Fulham	1
20 Ago 11	Finalizado	Sunderland	0 - 1	Newcastle	4
13 Ago 11	Finalizado	Newcastle	0 - 0	Arsenal	7

FA Cup »

	28 Ene 12	Finalizado	Brighton & Hove Albion	1 - 0	Newcastle			0
	07 Ene 12	Finalizado	Newcastle	2 - 1	Blackburn Rovers			0

EFL Cup »

26 Oct 11	Finalizado	Blackburn Rovers	4 - 3	Newcastle
20 Sep 11	Finalizado	Nottingham Forest	3 - 4	Newcastle
25 Ago 11	Finalizado	Scunthorpe United	1 - 2	Newcastle

Partidos Amistosos »

31 Jul 11

Finalizado

Leeds United

3 - 2

Newcastle

Estadísticas

GOLEADORES

D. Ba16

AMARILLAS

ROJAS

Plantilla del Newcastle Temporada 2011/2012

		Edad	Altura	Peso
Portero
21	F. Forster	36	201	93	-	-	-
33	O. Søderberg	33	193	85	-	-	-
35	R. Elliot	37	190	85	-	-	-
1	Steve Harper	49	188	82	-	-	-
26	Tim Krul	36	193	83	-	-	4
Defensa
3	D. Santon	33	187	77	-	-	1
5	D. Simpson	37	177	77	-	-	7
2	F. Coloccini	42	183	76	-	-	2
14	J. Perch	38	180	72	-	-	3
34	J. Tavernier	32	182	76	-	-	-
6	M. Williamson	40	194	91	-	-	4
16	R. Taylor	39	173	65	2	-	5
31	Shane Ferguson	32	175	67	-	-	1
27	Steven Taylor	38	188	81	-	-	1
Centrocampista
17	A. Smith	43	180	69	-	-	1
24	C. Tioté	37	180	76	-	-	11
15	D. Gosling	34	178	71	1	1	2
8	D. Guthrie	36	170	72	1	-	3
10	H. Ben Arfa	37	178	65	5	-	2
29	H. Vučkič	31	186	79	-	-	-
7	J. Barton	41	180	70	3	2	10
18	J. Gutiérrez	40	183	78	2	1	6
13	M. Abeid	31	178	77	-	-	-
32	R. Donaldson	32	178	73	-	-	-
22	S. Marveaux	38	172	66	-	-	-
4	Y. Cabaye	38	175	72	4	-	6
Delantero
19	D. Ba	38	189	84	16	-	1
25	G. Obertan	35	186	79	1	-	-
20	L. Best	37	185	76	4	-	2
9	P. Cissé	38	183	73	13	-	1
11	P. Løvenkrands	44	181	68	-	-	-
28	S. Ameobi	31	190	66	-	-	1
23	Sh. Ameobi	42	191	84	2	-	2

Noticias del Newcastle

Ver últimas noticias

El Newcastle confirma el descenso del Sheffield

BeSoccer - Sábado, 27 Abril 2024

0 462

El Newcastle goleó al Sheffield United por 5-1 en la jornada 35 de la Premier League. Matemáticamente, los 'blades' ya son de Championship al quedarse a 10 puntos de la permanencia con 9 por disputar.

El Newcastle ficha al defensa congolés Chancel Mbemba

BeSoccer - Lunes, 27 Julio 2015

2 2.618

El Newcastle ha anunciado hoy mediante un comunicado en su página web que ha acordado con el Anderlecht el fichaje del joven defensa internacional congolés Chancel Mbemba.

Aleksandar Mitrovic, nuevo refuerzo del Newcastle

BeSoccer - Martes, 21 Julio 2015

0 519

El delantero Aleksandar Mitrovic cambia el Anderlecht y la Liga belga por el Newcastle y la Premier.

Cissé y Sergio Araujo podrían ser los sutitutos de Bacca

BeSoccer - Lunes, 29 Junio 2015

0 479

El delantero senegalés anotó 11 goles en 22 partidos con el Newcastle en la Premier League y el argentino se ha destapado como uno de los mejores atacantes de la Segunda División.

Asprilla: 'Neymar es un niño. Necesita alguien mayor que le corrija'

BeSoccer - Lunes, 22 Junio 2015

0 641

El exjugador colombiano Faustino Asprilla considera que el brasileño Neymar "es un niño y necesita alguien mayor que le corrija" y le parece "un jugador mentiroso".

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,516,680 bytes

BENCHMARKS

Loading Time Base Classes	0.0075
Controller Execution Time ( Home / Category )	0.8151
Total Execution Time	0.8227

CADENA URL

/newcastle-united-fc/2012

GET DATOS

$_GET['/newcastle-united-fc/2012']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0297	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 = 'newcastle-united-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.0148	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=1796 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148	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=1796 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148	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=1796 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=1796 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=1796 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1796 AND type_rel = 2
0.0182	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1796 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0151	SELECT /35 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1312828,484,837,3232,3781) ORDER BY n.cover_points DESC, update_date DESC
0.0170	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '1796' AND l.year = 2012 ORDER BY l.year DESC,cat.coefficient DESC
0.0195	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 = '1796' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0167	(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 = 1796 or c.datateam2 = 1796) AND l.year = 2012 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0247	(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 = 1796 or c.datateam2 = 1796) AND l.year = 2012 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0302	(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 = 1796 or c.datateam2 = 1796) AND l.year = 2012)
0.0186	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=1796 AND l.year in (2011,2012,2013) ORDER BY l.id DESC, l.year DESC ;
0.0158	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 (72607,41754,20550,14433,2257,1906,1900) 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.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 1900 AND teamId = 1796
0.0155	SELECT count(id) as num_players from rel_players WHERE league_id = 2257 AND teamId = 1796
0.0163	SELECT count(id) as num_players from rel_players WHERE league_id = 14433 AND teamId = 1796
0.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 20550 AND teamId = 1796
0.0159	SELECT count(id) as num_players from rel_players WHERE league_id = 41754 AND teamId = 1796
0.0164	SELECT count(id) as num_players from rel_players WHERE league_id = 1906 AND teamId = 1796
0.0159	SELECT count(id) as num_players from rel_players WHERE league_id = 72607 AND teamId = 1796
0.0161	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 = 1796 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.0164	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 = 1796 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0177	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 = 1796 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0173	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 = 1796 AND rp.league_id = 1315 AND l.year= 2012 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0173	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=28825 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0151	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=28825
0.0217	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=28825 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.0200	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=28825 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0188	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=28825 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0167	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=28825 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0177	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=28825 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Newcastle

Información sobre Newcastle

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Newcastle

Estadísticas

Plantilla del Newcastle Temporada 2011/2012

Noticias del Newcastle

Newcastle

Selecciona un equipo

Competiciones que juega

RIVALES EN EFL Cup

RIVALES EN FA Cup

RIVALES EN Premier League