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

El Lopetegui más cotizado: Milan, United, West Ham...

BeSoccer - Sábado, 27 Abril 2024

0 225

Julen Lopetegui es uno de los nombres más repetidos en las quinielas de los banquillos para la próxima temporada. 'Relevo' insiste en que mantiene conversaciones muy activas por el Milan, pero no es el único club de élite con el que se le ha relacionado en las últimas semanas.

Giroud va camino a la MLS: jugará en Los Angeles FC con su compatriota Lloris

BeSoccer - Martes, 23 Abril 2024

0 1.189

Olivier Giroud, que acaba contrato al término de la presente temporada, pondrá el punto y final a su etapa en el Milan para sumarse a las filas de Los Angeles FC. El delantero francés, que firmará por 18 meses y que tendrá 1 año opcional, compartirá equipo con su compatriota Lloris y no irá a los Juegos Olímpicos.

Todos miran a Pioli

BeSoccer - Martes, 23 Abril 2024

0 941

Stefano Pioli ha quedado señalado después de su peor semana como entrenador del Milan. Cayó eliminado de la Europa League, vio cómo el Inter celebraba el 'Scudetto' en su casa y tiene muchas papeletas para no continuar la próxima temporada.

Final caliente en el Milan-Inter con agresiones y 3 rojas en 4'

BeSoccer - Martes, 23 Abril 2024

0 2.580

El final del partido entre el Milan y el Inter de Milán se vio empañado por una serie de acciones que acabaron en tanganas y donde el colegiado tuvo que echar mano a las expulsiones. Primero, Theo Hernández se enzarzó con Dumfries y, más tarde, Calabria golpeó en la cara a un defensor y también vio la roja.

"Ti ricordi il derby del 2024?"

Carlos Torregrosa - Lunes, 22 Abril 2024

1 5.134

El Inter vivió el 'Derby della Madonnina' soñado. Con su victoria ante el Milan por 1-2, los de Simone Inzaghi se proclamaron campeones de la Serie A con 5 jornadas aún por delante. Cualquier aficionado 'neroazzurri' habría deseado levantar un 'Scudetto' ante el eterno rival. Y ese día llegó en un derbi que nunca se olvidará en la capital lombarda.

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,340,512 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.7506
Total Execution Time	0.7526

CADENA URL

/Milan/2018

GET DATOS

$_GET['/Milan/2018']

POST DATOS

No hay datos POST existentes

CONSULTAS (48)

0.0318	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.0118	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.0117	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.0110	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.0107	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.0107	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.0114	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.0121	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.0121	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.0107	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1692 AND type_rel = 2
0.0195	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.0112	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 (1312783,1312272,1312221,1312167,1312158) ORDER BY n.cover_points DESC, update_date DESC
0.0140	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.0152	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.0108	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.0107	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.0109	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.0106	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.0110	(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.0150	(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.0134	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.0107	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.0122	SELECT count(id) as num_players from rel_players WHERE league_id = 44541 AND teamId = 1692
0.0105	SELECT count(id) as num_players from rel_players WHERE league_id = 43533 AND teamId = 1692
0.0111	SELECT count(id) as num_players from rel_players WHERE league_id = 38745 AND teamId = 1692
0.0114	SELECT count(id) as num_players from rel_players WHERE league_id = 43268 AND teamId = 1692
0.0222	SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 1692
0.0106	SELECT count(id) as num_players from rel_players WHERE league_id = 72479 AND teamId = 1692
0.0111	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.0140	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.0150	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.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 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.0167	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.0125	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.0110	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=783078
0.0129	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.0115	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.0112	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.0112	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

Estadísticas

Plantilla del Milan Temporada 2017/2018

Noticias del Milan

Milan

Selecciona un equipo

Competiciones que juega

RIVALES EN Coppa Italia

RIVALES EN Europa League

RIVALES EN Fase Previa Euro.

RIVALES EN Serie A