15 Mar 18	Finalizado	Arsenal	3 - 1	Milan	654
08 Mar 18	Finalizado	Milan	0 - 2	Arsenal	627
22 Feb 18	Finalizado	Milan	1 - 0	Ludogorets	154
15 Feb 18	Finalizado	Ludogorets	0 - 3	Milan	281
07 Dic 17	Finalizado	HNK Rijeka	2 - 0	Milan	249
23 Nov 17	Finalizado	Milan	5 - 1	Austria Wien	158
02 Nov 17	Finalizado	AEK Athens	0 - 0	Milan	310
19 Oct 17	Finalizado	Milan	0 - 0	AEK Athens	400
28 Sep 17	Finalizado	Milan	3 - 2	HNK Rijeka	250
14 Sep 17	Finalizado	Austria Wien	1 - 5	Milan	413

Serie A »

20 May 18	Finalizado	Milan	5 - 1	Fiorentina	223
13 May 18	Finalizado	Atalanta	1 - 1	Milan	191
05 May 18	Finalizado	Milan	4 - 1	Hellas Verona	124
29 Abr 18	Finalizado	Bologna	1 - 2	Milan	164
21 Abr 18	Finalizado	Milan	0 - 1	Benevento	395
18 Abr 18	Finalizado	Torino	1 - 1	Milan	144
15 Abr 18	Finalizado	Milan	0 - 0	Napoli	195
08 Abr 18	Finalizado	Milan	1 - 1	Sassuolo	300
04 Abr 18	Finalizado	Milan	0 - 0	Inter	591
31 Mar 18	Finalizado	Juventus	3 - 1	Milan	326
18 Mar 18	Finalizado	Milan	3 - 2	Chievo	440
11 Mar 18	Finalizado	Genoa	0 - 1	Milan	267
25 Feb 18	Finalizado	Roma	0 - 2	Milan	392
18 Feb 18	Finalizado	Milan	1 - 0	Sampdoria	253
10 Feb 18	Finalizado	SPAL	0 - 4	Milan	159
04 Feb 18	Finalizado	Udinese	1 - 1	Milan	126
28 Ene 18	Finalizado	Milan	2 - 1	Lazio	260
21 Ene 18	Finalizado	Cagliari	1 - 2	Milan	142
06 Ene 18	Finalizado	Milan	1 - 0	Crotone	148
30 Dic 17	Finalizado	Fiorentina	1 - 1	Milan	279
23 Dic 17	Finalizado	Milan	0 - 2	Atalanta	204
17 Dic 17	Finalizado	Hellas Verona	3 - 0	Milan	317
10 Dic 17	Finalizado	Milan	2 - 1	Bologna	276
03 Dic 17	Finalizado	Benevento	2 - 2	Milan	450
26 Nov 17	Finalizado	Milan	0 - 0	Torino	133
18 Nov 17	Finalizado	Napoli	2 - 1	Milan	217
05 Nov 17	Finalizado	Sassuolo	0 - 2	Milan	139
28 Oct 17	Finalizado	Milan	0 - 2	Juventus	295
25 Oct 17	Finalizado	Chievo	1 - 4	Milan	195
22 Oct 17	Finalizado	Milan	0 - 0	Genoa	184
15 Oct 17	Finalizado	Inter	3 - 2	Milan	402
01 Oct 17	Finalizado	Milan	0 - 2	Roma	275
24 Sep 17	Finalizado	Sampdoria	2 - 0	Milan	410
20 Sep 17	Finalizado	Milan	2 - 0	SPAL	156
17 Sep 17	Finalizado	Milan	2 - 1	Udinese	247
10 Sep 17	Finalizado	Lazio	4 - 1	Milan	418
27 Ago 17	Finalizado	Milan	2 - 1	Cagliari	267
20 Ago 17	Finalizado	Crotone	0 - 3	Milan	259

Coppa Italia »

09 May 18	Finalizado	Juventus	4 - 0	Milan	520
28 Feb 18	Finalizado	Lazio	0 - 0	Milan	667
31 Ene 18	Finalizado	Milan	0 - 0	Lazio	237
27 Dic 17	Finalizado	Milan	1 - 0	Inter	787
13 Dic 17	Finalizado	Milan	3 - 0	Hellas Verona	80

International Champions Cup »

	22 Jul 17	Finalizado	Bayern München	0 - 4	Milan			408
	18 Jul 17	Finalizado	Milan	1 - 3	B. Dortmund			486

Partidos Amistosos »

	09 Ago 17	Finalizado	Milan	1 - 2	Real Betis			694
	11 Jul 17	Finalizado	FC Lugano	0 - 4	Milan			102

Fase Previa Europa League »

24 Ago 17	Finalizado	KF Shkëndija	0 - 1	Milan	142
17 Ago 17	Finalizado	Milan	6 - 0	KF Shkëndija	331
03 Ago 17	Finalizado	Milan	2 - 0	Universitatea Craiova	124
27 Jul 17	Finalizado	Universitatea Craiova	0 - 1	Milan	186

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Suso1

Plantilla del Milan Temporada 2017/2018

		Edad	Altura	Peso
Portero
90	A. Donnarumma	33	192	96	-	-	-
75	A. Guarnone	25	189	75	-	-	-
99	G. Donnarumma	25	196	90	-	-	2
30	M. Storari	47	187	76	-	-	-
Defensa
13	A. Romagnoli	29	185	75	2	1	9
12	Andrea Conti	30	184	76	-	-	-
17	C. Zapata	37	187	70	-	-	2
2	D. Calabria	27	176	70	1	1	2
15	G. Gómez	30	185	85	-	-	-
20	I. Abate	37	180	73	1	-	3
31	L. Antonelli	37	184	79	-	-	1
19	L. Bonucci	37	189	86	2	1	5
22	M. Musacchio	33	180	73	-	-	2
46	Matteo Gabbia	24	185	73	-	-	-
47	R. Bellanova	23	188	72	-	-	-
68	Ricardo Rodríguez	31	182	77	1	1	5
76	Tiago Dias	26	175	65	-	-	-
Centrocampista
57	Emanuel Torrasi	25	180	70	-	-	-
79	Franck Kessié	27	183	76	5	-	9
5	G. Bonaventura	34	180	69	8	-	3
10	H. Çalhanoğlu	30	178	76	6	1	7
4	J. Mauri	27	169	78	-	-	-
21	L. Biglia	38	178	74	1	-	5
73	M. Locatelli	26	185	75	-	-	4
18	R. Montolivo	39	182	79	1	1	3
Delantero
9	André Silva	28	185	78	2	-	-
11	F. Borini	33	180	73	2	-	5
74	F. Tsadjout	24	190	88	-	-	-
7	N. Kalinić	36	187	80	6	-	3
63	Patrick Cutrone	26	183	75	10	-	3
8	Suso	30	177	72	6	1	2

Noticias del Milan

Ver últimas noticias

El Milan continúa de capa caída después de empatar ante el Genoa con un autogol en el minuto 87. El cuadro 'rossonero', que solo ha ganado un partido de los últimos 5 que ha disputado, no termina de cerrar la segunda plaza y la Juve puede aprovecharse para meterle presión.

Lopetegui, decepcionado con el Milan, se acerca más al West Ham

BeSoccer - Viernes, 03 Mayo 2024

2 1.528

El diario 'AS' informa de que Julen Lopetegui está decepcionado por el trato del Milan, que se ha dejado llevar por la furiosa respuesta de sus 'tifosi' a su potencial contratación como nuevo entrenador. El periódico sostiene que el estratega llevaba trabajando seis meses en la confección del proyecto de San Siro y que, ahora, se siente faltado al respecto. En paralelo, Fabrizio Romano indica que el West Ham United está en conversaciones directas con él.

Deschamps confirmó la marcha de Giroud a la MLS

BeSoccer - Miércoles, 01 Mayo 2024

1 683

Didier Deschamps, seleccionador de Francia, avaló en 'AFP' la salida de Olivier Giroud este verano rumbo a la MLS. El galo aseguró que el futbolista quiere seguir con su carrera, "pero a un nivel un poco más bajo que en Europa".

La mofa de Dumfries que escocerá al Milan: ¡sacó a pasear a Theo Hernández!

BeSoccer - Domingo, 28 Abril 2024

12 21.395

La fiesta de celebración del 'Scudetto' por parte del Inter de Milán dio mucho de sí. En plena rúa, a Denzel Dumfries los hinchas le entregaron una pancarta en la que aparecía él... paseando a Theo Hernández. Una imagen que no dudó en mostrar bien alto para dejar claro quién manda en la ciudad.

La afición 'rossonera' rechaza la posible llegada de Lopetegui al Milan

BeSoccer - Domingo, 28 Abril 2024

6 7.230

En los últimos días se ha relacionado a Julen Lopetegui, actualmente sin equipo, con varios clubes de cierta entidad en Europa. Uno de ellos es el AC Milan, pero este rumor no ha sentado bien en la afición 'rossonera'. De hecho, los hinchas milanistas están recogiendo firmas para impedir la llegada del español a San Siro bajo el lema de "NOPEtegui".

Ver más noticias del equipo»

Competiciones que juega

Serie A

Pos	Equipos		Pts
1		Juventus	95
2		Napoli	91
3		Roma	77
4		Inter	72
5		Lazio	72
6		Milan	64
7		Atalanta	60
8		Fiorentina	57
9		Torino	54
10		Sampdoria	54
11		Sassuolo	43
12		Genoa	41
13		Chievo	40
14		Udinese	40
15		Bologna	39
16		Cagliari	39
17		SPAL	38
18		Crotone	35
19		Hellas Verona	25
20		Benevento	21

	Champions League : Juventus, Napoli, Roma, Inter
	Europa League : Lazio, Milan, Atalanta
	Descenso : Crotone, Hellas Verona, Benevento

RIVALES EN Coppa Italia

RIVALES EN Fase Previa Euro.

RIVALES EN Europa League

RIVALES EN Serie A

USO DE MEMORIA

7,232,920 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.8806
Total Execution Time	0.8825

CADENA URL

/Milan/2018

GET DATOS

$_GET['/Milan/2018']

POST DATOS

No hay datos POST existentes

CONSULTAS (52)

0.0311	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 = 'Milan' AND l.year = 2018 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=1692 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=1692 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=1692 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=1692 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=1692 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=1692 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=1692 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=1692 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=1692 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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 = 38646
0.0133	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 = 39627
0.0133	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 = 41795
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 = 39142
0.0134	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 = 38744
0.0135	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 = 38745
0.0135	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 = 38071
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1692 AND type_rel = 2
0.0172	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1692 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128	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 (1314068,1313787,1313493,1313016,1312942) ORDER BY n.cover_points DESC, update_date DESC
0.0144	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 = '1692' AND l.year = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0146	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 = '1692' 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 = 39142 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128	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 = 38745 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 = 39627 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127	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 = 38646 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131	(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 calendars2018 as c ON c.league_id = l.id WHERE (c.datateam1 = 1692 or c.datateam2 = 1692) AND l.year = 2018 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 calendars2018 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 = 1692 or c.datateam2 = 1692) AND l.year = 2018 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0133	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2018 as c ON c.league_id = l.id INNER JOIN events2018 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 = 1692 or c.datateam2 = 1692) AND l.year = 2018)
0.0144	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=1692 AND l.year in (2017,2018,2019) 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 (72479,44995,44541,43550,43533,43475,43268,38745) 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.0137	SELECT count(id) as num_players from rel_players WHERE league_id = 43550 AND teamId = 1692
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 44995 AND teamId = 1692
0.0137	SELECT count(id) as num_players from rel_players WHERE league_id = 44541 AND teamId = 1692
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 43533 AND teamId = 1692
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 38745 AND teamId = 1692
0.0135	SELECT count(id) as num_players from rel_players WHERE league_id = 43268 AND teamId = 1692
0.0267	SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 1692
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 72479 AND teamId = 1692
0.0132	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2018` 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 = 38646 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 events2018 e ON e.player_id = p.id AND e.league_id = 38646 WHERE rp.league_id = 38646 AND rp.teamId = 1692 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.0166	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 events2018 e ON e.player_id = p.id AND e.league_id = 38646 WHERE rp.league_id = 38646 AND rp.teamId = 1692 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151	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 events2018 e ON e.player_id = p.id AND e.league_id = 38646 WHERE rp.league_id = 38646 AND rp.teamId = 1692 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138	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 = 1692 AND rp.league_id = 38646 AND l.year= 2018 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0131	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=783078 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0127	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=783078
0.0135	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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=783078 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.0140	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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=783078 and (e.action = 4 or e.action = 5) 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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=783078 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0134	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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=783078 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0138	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 events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=783078 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0126	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 38646 ORDER BY nameShow LIMIT 100

Milan

Información sobre Milan

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Milan