20 May 22	Finalizado	Torino	0 - 3	Roma	412
14 May 22	Finalizado	Roma	1 - 1	Venezia	716
09 May 22	Finalizado	Fiorentina	2 - 0	Roma	982
01 May 22	Finalizado	Roma	0 - 0	Bologna	661
23 Abr 22	Finalizado	Inter	3 - 1	Roma	312
18 Abr 22	Finalizado	Napoli	1 - 1	Roma	603
10 Abr 22	Finalizado	Roma	2 - 1	Salernitana	539
03 Abr 22	Finalizado	Sampdoria	0 - 1	Roma	222
20 Mar 22	Finalizado	Roma	3 - 0	Lazio	159
13 Mar 22	Finalizado	Udinese	1 - 1	Roma	175
05 Mar 22	Finalizado	Roma	1 - 0	Atalanta	347
27 Feb 22	Finalizado	Spezia	0 - 1	Roma	242
19 Feb 22	Finalizado	Roma	2 - 2	Hellas Verona	330
13 Feb 22	Finalizado	Sassuolo	2 - 2	Roma	319
05 Feb 22	Finalizado	Roma	0 - 0	Genoa	463
23 Ene 22	Finalizado	Empoli	2 - 4	Roma	187
16 Ene 22	Finalizado	Roma	1 - 0	Cagliari	330
09 Ene 22	Finalizado	Roma	3 - 4	Juventus	385
06 Ene 22	Finalizado	Milan	3 - 1	Roma	286
22 Dic 21	Finalizado	Roma	1 - 1	Sampdoria	552
18 Dic 21	Finalizado	Atalanta	1 - 4	Roma	588
13 Dic 21	Finalizado	Roma	2 - 0	Spezia	414
04 Dic 21	Finalizado	Roma	0 - 3	Inter	268
01 Dic 21	Finalizado	Bologna	1 - 0	Roma	707
28 Nov 21	Finalizado	Roma	1 - 0	Torino	121
21 Nov 21	Finalizado	Genoa	0 - 2	Roma	368
07 Nov 21	Finalizado	Venezia	3 - 2	Roma	234
31 Oct 21	Finalizado	Roma	1 - 2	Milan	577
27 Oct 21	Finalizado	Cagliari	1 - 2	Roma	156
24 Oct 21	Finalizado	Roma	0 - 0	Napoli	534
17 Oct 21	Finalizado	Juventus	1 - 0	Roma	375
03 Oct 21	Finalizado	Roma	2 - 0	Empoli	46
26 Sep 21	Finalizado	Lazio	3 - 2	Roma	200
23 Sep 21	Finalizado	Roma	1 - 0	Udinese	482
19 Sep 21	Finalizado	Hellas Verona	3 - 2	Roma	387
12 Sep 21	Finalizado	Roma	2 - 1	Sassuolo	489
29 Ago 21	Finalizado	Salernitana	0 - 4	Roma	220
22 Ago 21	Finalizado	Roma	3 - 1	Fiorentina	109

Conference League »

25 May 22	Finalizado	Roma	1 - 0	Feyenoord	839
05 May 22	Finalizado	Roma	1 - 0	Leicester	275
28 Abr 22	Finalizado	Leicester	1 - 1	Roma	465
14 Abr 22	Finalizado	Roma	4 - 0	FK Bodo Glimt	311
07 Abr 22	Finalizado	FK Bodo Glimt	2 - 1	Roma	401
17 Mar 22	Finalizado	Roma	1 - 1	Vitesse	338
10 Mar 22	Finalizado	Vitesse	0 - 1	Roma	366
09 Dic 21	Finalizado	CSKA Sofia	2 - 3	Roma	55
25 Nov 21	Finalizado	Roma	4 - 0	Zorya Luhansk	42
04 Nov 21	Finalizado	Roma	2 - 2	FK Bodo Glimt	289
21 Oct 21	Finalizado	FK Bodo Glimt	6 - 1	Roma	487
30 Sep 21	Finalizado	Zorya Luhansk	0 - 3	Roma	46
16 Sep 21	Finalizado	Roma	5 - 1	CSKA Sofia	91

Coppa Italia »

	08 Feb 22	Finalizado	Inter	2 - 0	Roma			271
	20 Ene 22	Finalizado	Roma	3 - 1	Lecce			181

Partidos Amistosos »

14 Ago 21	Finalizado	Roma	5 - 0	Raja Casablanca	12
07 Ago 21	Finalizado	Real Betis	5 - 2	Roma	132
04 Ago 21	Finalizado	Belenenses SAD	1 - 3	Roma	17
31 Jul 21	Finalizado	Roma	0 - 0	Sevilla	69
28 Jul 21	Finalizado	Porto	1 - 1	Roma	38
25 Jul 21	Finalizado	Roma	5 - 2	Debreceni VSC	31
21 Jul 21	Finalizado	Triestina	0 - 1	Roma	18
18 Jul 21	Finalizado	Roma	2 - 0	Ternana Calcio	0
15 Jul 21	Finalizado	Roma	10 - 0	Valdinievole Montecatini	7

Fase Previa Conference League »

	26 Ago 21	Finalizado	Roma	3 - 0	Trabzonspor			61
	19 Ago 21	Finalizado	Trabzonspor	1 - 2	Roma			145

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Roma Temporada 2021/2022

		Edad	Altura	Peso
Portero
87	D. Fuzato	26	190	88	-	1	-
63	Pietro Boer	21	193	80	-	-	-
1	Rui Patrício	36	190	84	-	-	2
Defensa
6	C. Smalling	34	194	90	3	-	-
18	D. Santon	33	187	77	-	-	-
23	G. Mancini	28	190	77	-	1	15
37	L. Spinazzola	31	186	75	-	-	1
24	M. Kumbulla	24	191	78	-	-	6
5	Matías Viña	26	175	70	-	-	2
59	N. Zalewski	22	175	70	-	-	1
2	R. Karsdorp	29	184	80	-	1	9
3	Roger Ibáñez	25	185	73	3	-	9
Centrocampista
42	A. Diawara	26	183	75	-	-	-
15	A. Maitland-Niles	26	180	71	-	-	-
4	B. Cristante	29	186	82	2	-	9
55	E. Darboe	22	179	70	-	-	-
52	Edoardo Bove	21	181	61	1	-	-
65	F. Tripi	22	185	65	-	-	-
77	H. Mkhitaryan	35	177	72	5	1	4
17	J. Veretout	31	177	66	4	-	6
7	L. Pellegrini	27	186	77	9	1	7
22	N. Zaniolo	24	190	79	2	2	11
27	Sérgio Oliveira	31	181	72	2	-	5
Delantero
11	Carles Pérez	26	173	75	1	-	2
14	E. Shomurodov	28	190	76	3	-	2
64	F. Afena-Gyan	21	175	75	2	1	5
92	S. El Shaarawy	31	178	72	3	-	1
9	Tammy Abraham	26	194	78	17	-	9

Noticias del Roma

Ver últimas noticias

El Udinese y la Roma jugaron los 20 minutos que les quedaron pendientes de disputar del partido de la jornada 32 después de que N'Dicka se fuera al suelo con las manos en el pecho. Aquel día, el duelo iba 1-1 y este jueves Cristante ha querido dedicarle un gol y el triunfo a su compañero, ya recuperado tras el susto.

Ene(a)migos íntimos

Javi Cubero - Miércoles, 24 Abril 2024

0 16.973

Udinese y Roma finalizarán el partido de la jornada 32 de la Serie A este mismo jueves tras el accidente que sufrió N'Dicka hace unas semanas. Un duelo que dejará su particular batalla en los banquillos, con Daniele de Rossi y Fabio Cannavaro como directores de ambas escuadras, dos viejos conocidos en su etapa como futbolistas tanto como rivales como compañeros y leyendas de la Selección Italiana.

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		Milan	86
2		Inter	84
3		Napoli	79
4		Juventus	70
5		Lazio	64
6		Roma	63
7		Fiorentina	62
8		Atalanta	59
9		Hellas Verona	53
10		Torino	50
11		Sassuolo	50
12		Udinese	47
13		Bologna	46
14		Empoli	41
15		Sampdoria	36
16		Spezia	36
17		Salernitana	31
18		Cagliari	30
19		Genoa	28
20		Venezia	27

	Champions League : Milan, Inter, Napoli, Juventus
	Europa League : Lazio, Roma
	Conference League : Fiorentina
	Descenso : Cagliari, Genoa, Venezia

RIVALES EN Conference Leagu.

RIVALES EN Fase Previa Conf.

RIVALES EN Coppa Italia

RIVALES EN Serie A

USO DE MEMORIA

7,088,760 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.9544
Total Execution Time	0.9564

CADENA URL

/Roma/2022

GET DATOS

$_GET['/Roma/2022']

POST DATOS

No hay datos POST existentes

CONSULTAS (48)

0.0144	SELECT type FROM routes WHERE alias = 'roma'
0.0180	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 = 2022 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.0145	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.0145	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.0145	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.0145	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.0157	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 = 64012
0.0162	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 = 66139
0.0152	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 = 63341
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2176 AND type_rel = 2
0.0221	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.0149	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 (1312609,1312438,537,649,702) ORDER BY n.cover_points DESC, update_date DESC
0.0177	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 = 2022 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 = '2176' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0157	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 = 66139 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0161	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 = 62617 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0164	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 = 63341 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0156	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 = 62734 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0169	(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 calendars2022 as c ON c.league_id = l.id WHERE (c.datateam1 = 2176 or c.datateam2 = 2176) AND l.year = 2022 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0216	(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 calendars2022 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 = 2022 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0194	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2022 as c ON c.league_id = l.id INNER JOIN events2022 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 = 2022)
0.0262	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 (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0150	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 (70409,68214,67673,67320,66139,62617) 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.0165	SELECT count(id) as num_players from rel_players WHERE league_id = 67673 AND teamId = 2176
0.0161	SELECT count(id) as num_players from rel_players WHERE league_id = 70409 AND teamId = 2176
0.0155	SELECT count(id) as num_players from rel_players WHERE league_id = 66139 AND teamId = 2176
0.0157	SELECT count(id) as num_players from rel_players WHERE league_id = 68214 AND teamId = 2176
0.0156	SELECT count(id) as num_players from rel_players WHERE league_id = 62617 AND teamId = 2176
0.0268	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 2176
0.0151	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2022` 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 = 62734 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0150	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 = '2176' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2176' and rp.type = 4
0.0152	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 = '2176' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0145	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '2176' and rp.type = 4
0.0171	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 events2022 e ON e.player_id = p.id AND e.league_id = 62734 WHERE rp.league_id = 62734 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.0168	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 events2022 e ON e.player_id = p.id AND e.league_id = 62734 WHERE rp.league_id = 62734 AND rp.teamId = 2176 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0165	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 events2022 e ON e.player_id = p.id AND e.league_id = 62734 WHERE rp.league_id = 62734 AND rp.teamId = 2176 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156	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 = 62734 AND l.year= 2022 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0152	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=6442322 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=6442322
0.0157	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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6442322 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.0157	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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6442322 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0154	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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6442322 and (e.action = 3 or e.action = 4) 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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6442322 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0156	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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6442322 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