19 May 13	Finalizado	Wigan Athletic	2 - 2	Aston Villa	4
11 May 13	Finalizado	Aston Villa	1 - 2	Chelsea	20
04 May 13	Finalizado	Norwich City	1 - 2	Aston Villa	3
29 Abr 13	Finalizado	Aston Villa	6 - 1	Sunderland	24
22 Abr 13	Finalizado	Manchester United	3 - 0	Aston Villa	47
13 Abr 13	Finalizado	Aston Villa	1 - 1	Fulham	3
06 Abr 13	Finalizado	Stoke City	1 - 3	Aston Villa	20
31 Mar 13	Finalizado	Aston Villa	1 - 2	Liverpool	29
16 Mar 13	Finalizado	Aston Villa	3 - 2	Queens Park Rangers	14
09 Mar 13	Finalizado	Reading	1 - 2	Aston Villa	2
04 Mar 13	Finalizado	Aston Villa	0 - 1	Manchester City	12
23 Feb 13	Finalizado	Arsenal	2 - 1	Aston Villa	18
10 Feb 13	Finalizado	Aston Villa	2 - 1	West Ham	4
02 Feb 13	Finalizado	Everton	3 - 3	Aston Villa	6
29 Ene 13	Finalizado	Aston Villa	1 - 2	Newcastle	4
19 Ene 13	Finalizado	West Bromwich Albion	2 - 2	Aston Villa	10
12 Ene 13	Finalizado	Aston Villa	0 - 1	Southampton	8
01 Ene 13	Finalizado	Swansea City	2 - 2	Aston Villa	15
29 Dic 12	Finalizado	Aston Villa	0 - 3	Wigan Athletic	14
26 Dic 12	Finalizado	Aston Villa	0 - 4	Tottenham Hotspur	43
23 Dic 12	Finalizado	Chelsea	8 - 0	Aston Villa	69
15 Dic 12	Finalizado	Liverpool	1 - 3	Aston Villa	21
08 Dic 12	Finalizado	Aston Villa	0 - 0	Stoke City	1
01 Dic 12	Finalizado	Queens Park Rangers	1 - 1	Aston Villa	4
27 Nov 12	Finalizado	Aston Villa	1 - 0	Reading	0
24 Nov 12	Finalizado	Aston Villa	0 - 0	Arsenal	2
17 Nov 12	Finalizado	Manchester City	5 - 0	Aston Villa	7
10 Nov 12	Finalizado	Aston Villa	2 - 3	Manchester United	21
03 Nov 12	Finalizado	Sunderland	0 - 1	Aston Villa	0
27 Oct 12	Finalizado	Aston Villa	1 - 1	Norwich City	8
20 Oct 12	Finalizado	Fulham	1 - 0	Aston Villa	2
07 Oct 12	Finalizado	Tottenham Hotspur	2 - 0	Aston Villa	5
30 Sep 12	Finalizado	Aston Villa	1 - 1	West Bromwich Albion	5
22 Sep 12	Finalizado	Southampton	4 - 1	Aston Villa	4
15 Sep 12	Finalizado	Aston Villa	2 - 0	Swansea City	6
02 Sep 12	Finalizado	Newcastle	1 - 1	Aston Villa	13
25 Ago 12	Finalizado	Aston Villa	1 - 3	Everton	5
18 Ago 12	Finalizado	West Ham	1 - 0	Aston Villa	16

FA Cup »

	25 Ene 13	Finalizado	Millwall	2 - 1	Aston Villa			0
	05 Ene 13	Finalizado	Aston Villa	2 - 1	Ipswich Town			0

EFL Cup »

22 Ene 13	Finalizado	Aston Villa	2 - 1	Bradford City
08 Ene 13	Finalizado	Bradford City	3 - 1	Aston Villa
11 Dic 12	Finalizado	Norwich City	1 - 4	Aston Villa
30 Oct 12	Finalizado	Swindon Town	2 - 3	Aston Villa
25 Sep 12	Finalizado	Manchester City	2 - 4	Aston Villa
28 Ago 12	Finalizado	Aston Villa	3 - 0	Tranmere Rovers

Partidos Amistosos »

11 Ago 12	Finalizado	Werder Bremen	3 - 3	Aston Villa	0
04 Ago 12	Finalizado	Nottingham Forest	3 - 1	Aston Villa	0
01 Ago 12	Finalizado	Peterborough United	0 - 2	Aston Villa	0
25 Jul 12	Finalizado	Portland Timbers	2 - 2	Aston Villa	1

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Aston Villa Temporada 2012/2013

		Edad	Altura	Peso
Portero
33	A. Marshall	49	188	85	-	-	-
22	B. Guzan	39	193	94	-	-	2
1	Shay Given	48	185	84	-	-	-
Defensa
6	Ciaran Clark	34	185	76	1	1	6
37	D. Williams	31	180	75	-	-	-
30	E. Lichaj	35	180	79	-	-	6
29	E. Stevens	33	183	78	-	-	1
27	J. Bennett	34	178	74	-	1	4
12	M. Albrighton	34	175	67	-	-	-
34	M. Lowton	34	180	78	2	-	10
32	N. Baker	33	189	82	-	-	4
4	R. Vlaar	39	189	80	2	-	1
Centrocampista
26	A. Weimann	32	179	76	7	-	4
15	A. Westwood	34	174	80	-	-	2
25	B. Bannan	34	169	61	-	-	3
14	B. Holman	40	177	75	1	-	1
10	C. N'zogbia	37	171	70	2	-	1
31	Chris Herd	35	173	76	-	-	1
16	F. Delph	34	174	60	-	-	7
36	G. Burke	30	180	75	-	-	-
38	G. Gardner	31	186	82	-	-	-
8	K. El Ahmadi	39	179	78	1	-	5
40	S. Carruthers	31	173	66	-	-	-
7	S. Ireland	37	173	67	-	-	1
18	Y. Sylla	33	184	79	-	-	3
Delantero
20	C. Benteke	33	190	83	19	1	9
9	D. Bent	40	180	73	3	-	1
11	G. Agbonlahor	37	180	78	9	-	4
21	J. Bowery	32	185	76	-	-	-
23	N. Delfouneso	33	186	78	-	-	-
24	S. Dawkins	36	177	73	-	-	-

Noticias del Aston Villa

Ver últimas noticias

Walker, el titán de las 250 victorias en la Premier

BeSoccer Pro - Domingo, 28 Abril 2024

2 10.653

Kyle Walker cumplió una cifra redonda ante el Nottingham Forest. La biblia estadística de BeSoccer Pro constata que el defensa del Manchester City alcanzó sus 250 victorias en la Premier League. 102 de ellas con el Tottenham, club con que dio el salto a la élite. No obstante, registró 5 triunfos con la elástica del Aston Villa en 2011. El resto, defendiendo los colores de los 'sky blues', que continúan en la pelea por el título esta temporada.

Reacción de antaño

BeSoccer - Sábado, 27 Abril 2024

0 4.798

El Chelsea rascó un empate (2-2) de su visita al Aston Villa con motivo de la jornada 35 en la Premier League. Noni Madueke y Conor Gallagher frenaron la marcha del equipo de Unai Emery, que no depende de sí mismo para jugar la Champions League la próxima temporada. El VAR anuló el tanto de Nico Jackson en la primera mitad y el que pudo ser el 2-3 de los 'blues' en el añadido, obra frustrada de Axel Disasi.

Fabian Delph se queda en el Aston Villa

Isabel Ruiz - Sábado, 11 Julio 2015

0 554

El jugador ha confirmado en la web del club que no abandonará el equipo.

Luna regresa a España para reforzar al Eibar

BeSoccer - Viernes, 10 Julio 2015

0 1.024

El defensa lateral izquierdo Antonio Manuel Luna Rodríguez, más conocido como Luna, se ha convertido hoy jueves en el segundo fichaje del Eibar, y se ha comprometido por dos temporadas (2015-2016 y 2016-2017) con el club guipuzcoano.

Ver más noticias del equipo»

Pos	Equipos	Pts
1		Manchester United	89
2		Manchester City	78
3		Chelsea	75
4		Arsenal	73
5		Tottenham Hotspur	72
6		Everton	63
7		Liverpool	61
8		West Bromwich Albion	49
9		Swansea City	46
10		West Ham	46
11		Norwich City	44
12		Fulham	43
13		Stoke City	42
14		Southampton	41
15		Aston Villa	41
16		Newcastle	41
17		Sunderland	39
18		Wigan Athletic	36
19		Reading	28
20		Queens Park Rangers	25

Pos

Equipos

Pts

	Champions League : Manchester United, Manchester City, Chelsea
	Previa de Champions : Arsenal
	Europa League : Tottenham Hotspur, Swansea City
	Descenso : Wigan Athletic, Reading, Queens Park Rangers

Champions League : Manchester United, Manchester City, Chelsea

Previa de Champions : Arsenal

Europa League : Tottenham Hotspur, Swansea City

Descenso : Wigan Athletic, Reading, Queens Park Rangers

USO DE MEMORIA

6,506,048 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.5973
Total Execution Time	0.5991

CADENA URL

/aston-villa-fc/2013

GET DATOS

$_GET['/aston-villa-fc/2013']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0159	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 = 'aston-villa-fc' AND l.year = 2013 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.0126	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=297 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=297 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=297 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=297 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=297 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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 = 2013
0.0130	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 = 20550
0.0141	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 = '297' AND l.year = 2013 ORDER BY l.year DESC,cat.coefficient DESC
0.0144	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 = '297' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 20550 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 2013 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 1900 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129	(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 calendars2013 as c ON c.league_id = l.id WHERE (c.datateam1 = 297 or c.datateam2 = 297) AND l.year = 2013 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0137	(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 calendars2013 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 = 297 or c.datateam2 = 297) AND l.year = 2013 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0139	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2013 as c ON c.league_id = l.id INNER JOIN events2013 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 = 297 or c.datateam2 = 297) AND l.year = 2013)
0.0141	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=297 AND l.year in (2012,2013,2014) ORDER BY l.id DESC, l.year DESC ;
0.0126	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,13879,2435,2399) 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.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 2435 AND teamId = 297
0.0139	SELECT count(id) as num_players from rel_players WHERE league_id = 13879 AND teamId = 297
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 20550 AND teamId = 297
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 2399 AND teamId = 297
0.0130	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2013` 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 = 1900 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0138	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 events2013 e ON e.player_id = p.id AND e.league_id = 1900 WHERE rp.league_id = 1900 AND rp.teamId = 297 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.0137	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 events2013 e ON e.player_id = p.id AND e.league_id = 1900 WHERE rp.league_id = 1900 AND rp.teamId = 297 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134	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 events2013 e ON e.player_id = p.id AND e.league_id = 1900 WHERE rp.league_id = 1900 AND rp.teamId = 297 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129	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 = 297 AND rp.league_id = 1900 AND l.year= 2013 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0129	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=38976 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0125	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=38976
0.0133	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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=38976 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.0133	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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=38976 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0131	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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=38976 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0132	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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=38976 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0133	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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=38976 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Aston Villa

Información sobre Aston Villa

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Aston Villa

Estadísticas

Plantilla del Aston Villa Temporada 2012/2013

Noticias del Aston Villa

Aston Villa

Selecciona un equipo

Competiciones que juega

RIVALES EN EFL Cup

RIVALES EN FA Cup

RIVALES EN Premier League