18 May 14	Finalizado	Genoa	1 - 0	Roma	39
11 May 14	Finalizado	Roma	0 - 1	Juventus	94
04 May 14	Finalizado	Catania	4 - 1	Roma	66
25 Abr 14	Finalizado	Roma	2 - 0	Milan	250
19 Abr 14	Finalizado	Fiorentina	0 - 1	Roma	150
12 Abr 14	Finalizado	Roma	3 - 1	Atalanta	27
06 Abr 14	Finalizado	Cagliari	1 - 3	Roma	30
02 Abr 14	Finalizado	Roma	4 - 2	Parma	97
30 Mar 14	Finalizado	Sassuolo	0 - 2	Roma	54
25 Mar 14	Finalizado	Roma	2 - 1	Torino	116
22 Mar 14	Finalizado	Chievo	0 - 2	Roma	26
17 Mar 14	Finalizado	Roma	3 - 2	Udinese	73
09 Mar 14	Finalizado	Napoli	1 - 0	Roma	41
01 Mar 14	Finalizado	Roma	0 - 0	Inter	52
22 Feb 14	Finalizado	Bologna	0 - 1	Roma	22
16 Feb 14	Finalizado	Roma	3 - 0	Sampdoria	52
09 Feb 14	Finalizado	Lazio	0 - 0	Roma	53
26 Ene 14	Finalizado	Hellas Verona	1 - 3	Roma	44
18 Ene 14	Finalizado	Roma	3 - 0	Livorno	30
12 Ene 14	Finalizado	Roma	4 - 0	Genoa	27
05 Ene 14	Finalizado	Juventus	3 - 0	Roma	99
22 Dic 13	Finalizado	Roma	4 - 0	Catania	20
16 Dic 13	Finalizado	Milan	2 - 2	Roma	308
08 Dic 13	Finalizado	Roma	2 - 1	Fiorentina	21
01 Dic 13	Finalizado	Atalanta	1 - 1	Roma	16
25 Nov 13	Finalizado	Roma	0 - 0	Cagliari	34
10 Nov 13	Finalizado	Roma	1 - 1	Sassuolo	14
03 Nov 13	Finalizado	Torino	1 - 1	Roma	33
31 Oct 13	Finalizado	Roma	1 - 0	Chievo	24
27 Oct 13	Finalizado	Udinese	0 - 1	Roma	11
18 Oct 13	Finalizado	Roma	2 - 0	Napoli	46
05 Oct 13	Finalizado	Inter	0 - 3	Roma	26
29 Sep 13	Finalizado	Roma	5 - 0	Bologna	8
25 Sep 13	Finalizado	Sampdoria	0 - 2	Roma	9
22 Sep 13	Finalizado	Roma	2 - 0	Lazio	11
16 Sep 13	Finalizado	Parma	1 - 3	Roma	10
01 Sep 13	Finalizado	Roma	3 - 0	Hellas Verona	8
25 Ago 13	Finalizado	Livorno	0 - 2	Roma	7

Coppa Italia »

12 Feb 14	Finalizado	Napoli	3 - 0	Roma
05 Feb 14	Finalizado	Roma	3 - 2	Napoli
21 Ene 14	Finalizado	Roma	1 - 0	Juventus
09 Ene 14	Finalizado	Roma	1 - 0	Sampdoria

Partidos Amistosos »

24 May 14	Finalizado	Orlando City	0 - 1	Roma	0
11 Ago 13	Finalizado	Chelsea	2 - 1	Roma	1
21 Jul 13	Finalizado	Roma	1 - 1	Bursaspor	4

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Maicon1

Plantilla del Roma Temporada 2013/2014

		Edad	Altura	Peso
Portero
1	B. Lobont	46	185	78	-	-	-
51	Francesco Proietti Gaffi	29	187	82	-	-	-
26	M. De Sanctis	47	190	82	-	-	2
Defensa
24	A. Florenzi	33	173	67	6	-	4
46	A. Romagnoli	29	185	75	-	-	4
91	D. Boldor	29	189	79	-	-	-
3	Dodô	32	177	69	-	-	2
42	F. Balzaretti	42	180	74	1	1	3
5	L. Castán	37	184	80	-	1	7
27	M. Bălașa	29	186	69	-	-	-
17	M. Benatia	37	189	88	5	-	8
13	Maicon	42	184	77	2	1	6
20	Michel Bastos	40	178	74	1	-	1
2	Rafael Tolói	33	185	75	-	-	1
33	Tin Jedvaj	28	185	81	-	-	1
98	V. Marin	28	180	72	-	-	-
35	V. Torosidis	38	185	80	1	-	1
Centrocampista
8	Adem Ljajic	32	182	72	6	-	5
16	D. De Rossi	40	184	79	1	1	4
6	K. Strootman	34	186	77	5	-	6
95	L. Mazzitelli	28	184	76	-	-	-
93	L. Pellegrini	27	186	77	-	-	-
50	M. Adamo	27	175	-	-	-	-
15	M. Pjanić	34	178	68	6	1	9
44	R. Nainggolan	35	176	65	4	-	11
97	Simone Battaglia	29	170	60	-	-	-
Delantero
8	Erik Lamela	32	184	74	-	-	-
96	F. Di Mariano	28	177	70	-	-	-
94	F. Ricci	29	175	68	-	-	-
10	F. Totti	47	180	82	8	-	3
20	J. Tallo	31	185	80	-	-	-
22	Mattia Destro	33	182	73	13	-	5
11	R. Taddei	44	177	70	2	-	3
99	Valmir Berisha	27	184	78	-	-	-
27	Y. Gervinho	36	179	68	9	-	2

Noticias del Roma

Ver últimas noticias

Palmarés de la Serie A: ¿quién ha ganado más títulos?

BeSoccer Pro - Lunes, 29 Abril 2024

4 2.685

Desgranamos la lista de equipos del palmarés entre todos los campeones de la Serie A, además de añadir cuántas veces lo han logrado y en qué años. El Nápoles consiguió su tercer título liguero después de encadenar 33 años sin poder disfrutar de ello.

Simulacro aprobado

BeSoccer - Domingo, 28 Abril 2024

0 247

La Roma rascó el empate (2-2) ante el Nápoles en la jornada 34 de la Serie A. Tammy Abraham marcó el tanto definitivo por el que el cuadro 'giallorosso' ultimó los detalles para medirse al Bayer Leverkusen en las semifinales de la Europa League.

Carew debuta en las grandes pantallas como mafioso

BeSoccer - Viernes, 26 Junio 2015

1 126

El ex jugador del Valencia se ha pasado al cine y en su debut, en una película noruega, ejercerá de mafioso.

La Roma ata a Nainggolan

BeSoccer - Jueves, 25 Junio 2015

0 276

El equipo italiano no quiere ni oír hablar de una posible venta al Real Madrid, por lo que ha decidido comprar el cien por cien de los derechos del jugador para evitar su salida.

Falqué completa el reconocimiento médico antes de fichar por el Roma

BeSoccer - Lunes, 22 Junio 2015

0 210

El delantero español Iago Falqué completó hoy el reconocimiento médico al que se sometió en los últimos días en Roma, antes de fichar previsiblemente por el club y dejar el Génova, acuerdo que podría oficializarse en las próximas horas.

Ver más noticias del equipo»

Competiciones que juega

Grupo 7

Serie A

Pos	Equipos		Pts
1		Juventus	102
2		Roma	85
3		Napoli	78
4		Fiorentina	65
5		Inter	60
6		Parma	58
7		Torino	57
8		Milan	57
9		Lazio	56
10		Hellas Verona	54
11		Atalanta	50
12		Sampdoria	45
13		Udinese	44
14		Genoa	44
15		Cagliari	39
16		Chievo	36
17		Sassuolo	34
18		Catania	32
19		Bologna	29
20		Livorno	25

	Champions League : Juventus, Roma
	Previa de Champions : Napoli
	Europa League : Fiorentina, Inter, Torino
	Descenso : Catania, Bologna, Livorno

RIVALES EN Coppa Italia

RIVALES EN Serie A

USO DE MEMORIA

6,514,264 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.7392
Total Execution Time	0.7410

CADENA URL

/Roma/2014

GET DATOS

$_GET['/Roma/2014']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0170	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 = 'Roma' AND l.year = 2014 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.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=2176 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=2176 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=2176 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=2176 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0292	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 = 2489
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2176 AND type_rel = 2
0.0202	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2176 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147	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 (1250956,1313021,537,649,702) ORDER BY n.cover_points DESC, update_date DESC
0.0163	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 = '2176' AND l.year = 2014 ORDER BY l.year DESC,cat.coefficient DESC
0.0163	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 = '2176' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148	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 = 3322 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146	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 = 2489 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0157	(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 calendars2014 as c ON c.league_id = l.id WHERE (c.datateam1 = 2176 or c.datateam2 = 2176) AND l.year = 2014 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0161	(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 calendars2014 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 = 2176 or c.datateam2 = 2176) AND l.year = 2014 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0151	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2014 as c ON c.league_id = l.id INNER JOIN events2014 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 = 2176 or c.datateam2 = 2176) AND l.year = 2014)
0.0161	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=2176 AND l.year in (2013,2014,2015) ORDER BY l.id DESC, l.year DESC ;
0.0146	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 (71977,4249,4234,3981,3808,3804,3774) 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.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 3774 AND teamId = 2176
0.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 4234 AND teamId = 2176
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 4249 AND teamId = 2176
0.0158	SELECT count(id) as num_players from rel_players WHERE league_id = 3981 AND teamId = 2176
0.0153	SELECT count(id) as num_players from rel_players WHERE league_id = 3808 AND teamId = 2176
0.0181	SELECT count(id) as num_players from rel_players WHERE league_id = 3804 AND teamId = 2176
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 71977 AND teamId = 2176
0.0162	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 events2014 e ON e.player_id = p.id AND e.league_id = 2489 WHERE rp.league_id = 2489 AND rp.teamId = 2176 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 events2014 e ON e.player_id = p.id AND e.league_id = 2489 WHERE rp.league_id = 2489 AND rp.teamId = 2176 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0169	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 events2014 e ON e.player_id = p.id AND e.league_id = 2489 WHERE rp.league_id = 2489 AND rp.teamId = 2176 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152	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 = 2176 AND rp.league_id = 2489 AND l.year= 2014 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0151	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=53452 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0145	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=53452
0.0153	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=53452 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.0153	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=53452 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0151	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=53452 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0151	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=53452 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0153	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=53452 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Roma

Información sobre Roma

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Roma