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	36	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	25	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

Estas son las semifinales de la Europa League 23-24

Javi Cubero - Viernes, 19 Abril 2024

2 46.503

Los cuartos de final llegaron a su fin tras unos apasionantes partidos y ya se conocen a los cuatro clasificados para las semifinales. El Olympique de Marsella se medirá al Atalanta, mientras que la Roma lo hará ante el Bayer Leverkusen. La ida será el 2 de mayo y la vuelta, el 9.

El imparable 'efecto De Rossi'

BeSoccer - Viernes, 19 Abril 2024

0 268

La Roma certificó su pase a las semifinales de la Europa League tras volver a vencer al Milan (2-1). El conjunto dirigido por Daniele de Rossi fue el protagonista del choque de principio a fin, mientras que los 'rossoneri' no dieron síntoma alguno de darle la vuelta a la eliminatoria.

El Milan se juega la temporada en 5 días

BeSoccer - Miércoles, 17 Abril 2024

1 7.760

El Milan tiene por delante una semana clave. Este jueves se enfrentará a la Roma y debe remontar a los 'giallorossi' si quiere pasar de ronda en la Europa League. Unos días después, el lunes, se mide al Inter en un derbi que podría terminar con el 'Scudetto' en manos del vecino y eterno rival. Los 'rossoneri' se juegan el curso en apenas 5 días.

Horarios y partidos de la jornada 33 de Serie A 2023-24

BeSoccer - Martes, 16 Abril 2024

1 22.529

El 'Calcio' continúa su travesía por esta campaña 2023-24 con un conjunto de encuentros pertenecientes a la trigésimo tercera jornada que prometen una gran emoción para los aficionados de la liga de oro italiana.

El Milan hace posible el sueño más húmedo del Inter

BeSoccer - Domingo, 14 Abril 2024

0 5.820

El Milan volvió a pinchar en la Serie A, con la mente puesta en la Europa League, empató contra el Sassuolo y deja una opción para que el Inter pueda ser campeón en el 'Derby della Madonnina'.

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 Europa League

RIVALES EN Fase Previa Euro.

RIVALES EN Serie A

USO DE MEMORIA

7,336,136 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.8676
Total Execution Time	0.8696

CADENA URL

/Milan/2018

GET DATOS

$_GET['/Milan/2018']

POST DATOS

No hay datos POST existentes

CONSULTAS (55)

0.0108	SELECT type FROM routes WHERE alias = 'milan'
0.0352	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.0115	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.0114	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.0116	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.0112	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.0112	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.0112	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.0111	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.0106	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.0106	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.0111	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.0112	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.0111	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.0112	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.0115	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.0106	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1692 AND type_rel = 2
0.0239	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.0124	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 (1311517,1311556,1311300,1257629,1310902) ORDER BY n.cover_points DESC, update_date DESC
0.0210	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.0219	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.0125	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.0120	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 = 41795 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0120	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.0119	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.0123	(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.0118	(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.0113	(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.0123	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.0106	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.0117	SELECT count(id) as num_players from rel_players WHERE league_id = 43550 AND teamId = 1692
0.0106	SELECT count(id) as num_players from rel_players WHERE league_id = 44995 AND teamId = 1692
0.0117	SELECT count(id) as num_players from rel_players WHERE league_id = 44541 AND teamId = 1692
0.0106	SELECT count(id) as num_players from rel_players WHERE league_id = 43533 AND teamId = 1692
0.0116	SELECT count(id) as num_players from rel_players WHERE league_id = 38745 AND teamId = 1692
0.0124	SELECT count(id) as num_players from rel_players WHERE league_id = 43268 AND teamId = 1692
0.0521	SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 1692
0.0107	SELECT count(id) as num_players from rel_players WHERE league_id = 72479 AND teamId = 1692
0.0114	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.0116	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 = '1692' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1692' and rp.type = 4
0.0135	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 = '1692' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0106	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1692' and rp.type = 4
0.0142	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.0128	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.0123	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.0118	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.0110	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.0105	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=783078
0.0114	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.0114	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.0111	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.0111	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.0113	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.0106	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


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

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