07 Ago 20	Finalizado	Juventus	2 - 1	Olympique Lyonnais	374
26 Feb 20	Finalizado	Olympique Lyonnais	1 - 0	Juventus	444
11 Dic 19	Finalizado	B. Leverkusen	0 - 2	Juventus	351
26 Nov 19	Finalizado	Juventus	1 - 0	Atlético	450
06 Nov 19	Finalizado	Lokomotiv Moskva	1 - 2	Juventus	519
22 Oct 19	Finalizado	Juventus	2 - 1	Lokomotiv Moskva	317
01 Oct 19	Finalizado	Juventus	3 - 0	B. Leverkusen	114
18 Sep 19	Finalizado	Atlético	2 - 2	Juventus	835

Serie A »

01 Ago 20	Finalizado	Juventus	1 - 3	Roma	195
29 Jul 20	Finalizado	Cagliari	2 - 0	Juventus	321
26 Jul 20	Finalizado	Juventus	2 - 0	Sampdoria	242
23 Jul 20	Finalizado	Udinese	2 - 1	Juventus	388
20 Jul 20	Finalizado	Juventus	2 - 1	Lazio	300
15 Jul 20	Finalizado	Sassuolo	3 - 3	Juventus	221
11 Jul 20	Finalizado	Juventus	2 - 2	Atalanta	499
07 Jul 20	Finalizado	Milan	4 - 2	Juventus	434
04 Jul 20	Finalizado	Juventus	4 - 1	Torino	133
30 Jun 20	Finalizado	Genoa	1 - 3	Juventus	193
26 Jun 20	Finalizado	Juventus	4 - 0	Lecce	199
22 Jun 20	Finalizado	Bologna	0 - 2	Juventus	144
08 Mar 20	Finalizado	Juventus	2 - 0	Inter	207
22 Feb 20	Finalizado	SPAL	1 - 2	Juventus	167
16 Feb 20	Finalizado	Juventus	2 - 0	Brescia	84
08 Feb 20	Finalizado	Hellas Verona	2 - 1	Juventus	257
02 Feb 20	Finalizado	Juventus	3 - 0	Fiorentina	218
26 Ene 20	Finalizado	Napoli	2 - 1	Juventus	158
19 Ene 20	Finalizado	Juventus	2 - 1	Parma	121
12 Ene 20	Finalizado	Roma	1 - 2	Juventus	199
06 Ene 20	Finalizado	Juventus	4 - 0	Cagliari	181
18 Dic 19	Finalizado	Sampdoria	1 - 2	Juventus	66
15 Dic 19	Finalizado	Juventus	3 - 1	Udinese	62
07 Dic 19	Finalizado	Lazio	3 - 1	Juventus	352
01 Dic 19	Finalizado	Juventus	2 - 2	Sassuolo	240
23 Nov 19	Finalizado	Atalanta	1 - 3	Juventus	243
10 Nov 19	Finalizado	Juventus	1 - 0	Milan	259
02 Nov 19	Finalizado	Torino	0 - 1	Juventus	135
30 Oct 19	Finalizado	Juventus	2 - 1	Genoa	336
26 Oct 19	Finalizado	Lecce	1 - 1	Juventus	256
19 Oct 19	Finalizado	Juventus	2 - 1	Bologna	53
06 Oct 19	Finalizado	Inter	1 - 2	Juventus	229
28 Sep 19	Finalizado	Juventus	2 - 0	SPAL	121
24 Sep 19	Finalizado	Brescia	1 - 2	Juventus	180
21 Sep 19	Finalizado	Juventus	2 - 1	Hellas Verona	148
14 Sep 19	Finalizado	Fiorentina	0 - 0	Juventus	274
31 Ago 19	Finalizado	Juventus	4 - 3	Napoli	320
24 Ago 19	Finalizado	Parma	0 - 1	Juventus	192

Coppa Italia »

17 Jun 20	Finalizado	Napoli	0 - 0	Juventus	355
12 Jun 20	Finalizado	Juventus	0 - 0	Milan	317
13 Feb 20	Finalizado	Milan	1 - 1	Juventus	545
22 Ene 20	Finalizado	Juventus	3 - 1	Roma	122
15 Ene 20	Finalizado	Juventus	4 - 0	Udinese	61

Supercopa de Italia »

22 Dic 19

Finalizado

Juventus

1 - 3

Lazio

290

International Champions Cup »

10 Ago 19	Finalizado	Atlético	2 - 1	Juventus	729
24 Jul 19	Finalizado	Juventus	1 - 1	Inter	192
21 Jul 19	Finalizado	Juventus	2 - 3	Tottenham Hotspur	264

Partidos Amistosos »

17 Ago 19	Finalizado	Triestina	0 - 1	Juventus	13
14 Ago 19	Finalizado	Juventus	3 - 1	Juventus Sub 19	0
07 Ago 19	Finalizado	Juventus	4 - 0	Novara	1
26 Jul 19	Finalizado	K League All-Star	3 - 3	Juventus	70

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Danilo1

Plantilla del Juventus Temporada 2019/2020

		Edad	Altura	Peso
Portero
31	C. Pinsoglio	34	194	77	-	-	-
77	G. Buffon	46	192	83	-	-	-
1	W. Szczęsny	34	196	84	-	-	1
Defensa
12	Alex Sandro	33	181	80	1	-	4
24	D. Rugani	29	190	78	-	-	2
13	Danilo	32	184	73	2	1	4
47	G. Frabotta	24	187	70	-	-	-
3	Giorgio Chiellini	39	187	86	1	-	-
16	Juan Cuadrado	35	176	72	2	1	7
19	L. Bonucci	36	189	86	3	-	9
41	L. Coccolo	26	187	78	-	-	-
2	M. De Sciglio	31	183	68	-	-	1
28	M. Demiral	26	190	86	1	-	1
4	Matthijs De Ligt	24	189	86	4	-	5
34	P. Beruatto	25	185	78	-	-	-
42	Wesley	24	170	66	-	-	-
Centrocampista
8	Aaron Ramsey	33	178	76	3	-	2
25	Adrien Rabiot	29	188	71	1	1	7
43	Daouda Peeters	25	185	74	-	-	-
5	M. Pjanić	34	178	68	3	-	10
39	M. Portanova	23	183	72	-	-	-
10	Paulo Dybala	30	177	69	11	-	5
30	R. Bentancur	26	187	73	-	-	9
6	S. Khedira	37	189	83	-	-	3
38	S. Muratore	25	186	74	-	-	-
Delantero
7	C. Ronaldo	39	188	80	31	-	3
11	D. Costa	33	172	65	1	-	1
33	F. Bernardeschi	30	183	75	1	-	6
44	G. Vrioni	25	188	70	-	-	-
46	L. Zanimacchia	25	178	70	-	-	-
35	Marco Olivieri	24	177	80	-	-	-

Noticias del Juventus

Ver últimas noticias

"Me tomaron por loco cuando dije que el Inter era superior a los demás"

BeSoccer - Viernes, 26 Abril 2024

3 7.837

A Massimiliano Allegri no le ha extrañado nada que el Inter se haya proclamado campeón de la Serie A. Antes del Juventus-Milan valoró muy positivamente el esfuerzo de los 'nerazzurri', a los que consideró "claramente más fuertes que los demás".

"Siempre soñé con jugar en el Madrid y ganar la Champions"

BeSoccer - Jueves, 25 Abril 2024

4 21.006

El jugador Matías Soulé, cedido en el Frosinone por la Juventus de Turín, charló hace un par de semanas con 'ESPN' y habló sobre sus deseos como jugador. Aseguró que, de niño, siempre quiso jugar en el Real Madrid y aspira a conquistar la Champions League algún día.

Esto es la Juve

Juanma Velasco - Martes, 23 Abril 2024

0 9.214

La Juventus metió la cabeza en la gran final de la Coppa Italia pese a caer por 2-1 en el Olímpico de Roma ante la Lazio. Un gol de Milik en el 83' fue suficiente para una 'Vecchia Signora' que, pese a estar desaparecida en la Ciudad Eterna, aprovechó la mejor ocasión que tuvo para colarse en la batalla por el título.

"Sueño con ganar el Balón de Oro"

BeSoccer - Martes, 23 Abril 2024

4 3.418

El jugador de la Juventus Dusan Vlahovic concedió una entrevista al diario francés 'L'Équipe' en la que afirmó: "Obviamente, sueño con ganar el Balón de Oro". Además, el serbio habló sobre su técnico, Massimiliano Allegri, su club, su futuro y su rendimiento en la presente temporada. Por último, esbozó una lista de delanteros a los que considera como sus modelos de referencia.

El Inter se acuerda de la Juve: "A diferencia de otros, nunca nos hemos escondido"

BeSoccer - Martes, 23 Abril 2024

5 3.842

El Inter de Milán se proclamó campeón de la Serie A 2023-24 tras vencer al Milan en el 'Derby della Madoninna'. Tras este logro, su director deportivo, Piero Ausilio, compareció ante los micrófonos de 'Sky Sport' y dejó un recado al que parecía que iba a ser su principal rival por el título, la Juventus: "A diferencia de otros, nunca nos hemos escondido". Además, explicó en qué punto se encuentran las renovaciones de Lautaro Martínez y Nicolò Barella.

Ver más noticias del equipo»

Competiciones que juega

Serie A

Pos	Equipos		Pts
1		Juventus	83
2		Inter	82
3		Atalanta	78
4		Lazio	78
5		Roma	70
6		Milan	66
7		Napoli	62
8		Sassuolo	51
9		Hellas Verona	49
10		Fiorentina	49
11		Parma	49
12		Bologna	47
13		Udinese	45
14		Cagliari	45
15		Sampdoria	42
16		Torino	40
17		Genoa	39
18		Lecce	35
19		Brescia	25
20		SPAL	20

	Champions League : Juventus, Inter, Atalanta, Lazio
	Europa League : Roma, Milan
	Previa de Europa League : Napoli
	Descenso : Lecce, Brescia, SPAL

RIVALES EN Champions League

RIVALES EN Coppa Italia

RIVALES EN Serie A

RIVALES EN Supercopa de Ita.

USO DE MEMORIA

7,063,624 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.8979
Total Execution Time	0.8998

CADENA URL

/juventus-fc/2020

GET DATOS

$_GET['/juventus-fc/2020']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0145	SELECT type FROM routes WHERE alias = 'juventus-fc'
0.0172	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 = 'juventus-fc' AND l.year = 2020 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=1430 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=1430 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=1430 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=1430 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=1430 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149	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=1430 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=1430 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=1430 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0158	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 = 49851
0.0165	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 = 51186
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 = 50675
0.0158	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 = 51682
0.0191	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 = '1430' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150	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 = 53485 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0166	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 = 50675 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155	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 = 49851 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155	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 = 51682 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0158	(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 calendars2020 as c ON c.league_id = l.id WHERE (c.datateam1 = 1430 or c.datateam2 = 1430) AND l.year = 2020 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0168	(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 calendars2020 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 = 1430 or c.datateam2 = 1430) AND l.year = 2020 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0152	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2020 as c ON c.league_id = l.id INNER JOIN events2020 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 = 1430 or c.datateam2 = 1430) AND l.year = 2020)
0.0163	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=1430 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0147	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 (60337,60149,58676,57792,56547,49360) 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.0156	SELECT count(id) as num_players from rel_players WHERE league_id = 57792 AND teamId = 1430
0.0157	SELECT count(id) as num_players from rel_players WHERE league_id = 60337 AND teamId = 1430
0.0168	SELECT count(id) as num_players from rel_players WHERE league_id = 58676 AND teamId = 1430
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 60149 AND teamId = 1430
0.0162	SELECT count(id) as num_players from rel_players WHERE league_id = 49360 AND teamId = 1430
0.0264	SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 1430
0.0152	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2020` 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 = 49851 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0158	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 = '1430' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1430' and rp.type = 4
0.0155	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 = '1430' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1430' and rp.type = 4
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 events2020 e ON e.player_id = p.id AND e.league_id = 49851 WHERE rp.league_id = 49851 AND rp.teamId = 1430 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 events2020 e ON e.player_id = p.id AND e.league_id = 49851 WHERE rp.league_id = 49851 AND rp.teamId = 1430 AND (e.action = 4 or e.action = 5) 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 events2020 e ON e.player_id = p.id AND e.league_id = 49851 WHERE rp.league_id = 49851 AND rp.teamId = 1430 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0163	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 = 1430 AND rp.league_id = 49851 AND l.year= 2020 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0153	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=6280092 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=6280092
0.0160	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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280092 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.0158	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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280092 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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280092 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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280092 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0160	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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280092 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Juventus

Información sobre Juventus

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Juventus

Estadísticas

Plantilla del Juventus Temporada 2019/2020

Noticias del Juventus

Juventus

Selecciona un equipo

Competiciones que juega

RIVALES EN Champions League

RIVALES EN Coppa Italia

RIVALES EN Serie A

RIVALES EN Supercopa de Ita.