26 May 04	Finalizado	Monaco	0 - 3	Porto	12
05 May 04	Finalizado	Chelsea	2 - 2	Monaco	0
20 Abr 04	Finalizado	Monaco	3 - 1	Chelsea	0
06 Abr 04	Finalizado	Monaco	3 - 1	Real Madrid	5
24 Mar 04	Finalizado	Real Madrid	4 - 2	Monaco	0
10 Mar 04	Finalizado	Monaco	1 - 0	Lokomotiv Moskva	0
24 Feb 04	Finalizado	Lokomotiv Moskva	2 - 1	Monaco	0
10 Dic 03	Finalizado	AEK Athens	0 - 0	Monaco	0
25 Nov 03	Finalizado	Monaco	1 - 1	PSV	0
05 Nov 03	Finalizado	Monaco	8 - 3	RC Deportivo	5
21 Oct 03	Finalizado	RC Deportivo	1 - 0	Monaco	0
30 Sep 03	Finalizado	Monaco	4 - 0	AEK Athens	0
17 Sep 03	Finalizado	PSV	1 - 2	Monaco	0

Ligue 1 »

21 May 04	Finalizado	Girondins Bordeaux	1 - 3	Monaco
15 May 04	Finalizado	Monaco	1 - 4	Stade Rennais
12 May 04	Finalizado	Strasbourg	0 - 0	Monaco
09 May 04	Finalizado	Monaco	1 - 0	Olympique Marseille
30 Abr 04	Finalizado	Nice	1 - 2	Monaco
24 Abr 04	Finalizado	Monaco	0 - 1	Nantes
10 Abr 04	Finalizado	Lens	0 - 0	Monaco
02 Abr 04	Finalizado	Monaco	3 - 3	Ajaccio
27 Mar 04	Finalizado	Le Mans	0 - 1	Monaco
20 Mar 04	Finalizado	Monaco	1 - 1	Sochaux
14 Mar 04	Finalizado	Auxerre	0 - 0	Monaco
05 Mar 04	Finalizado	Monaco	3 - 1	Guingamp
28 Feb 04	Finalizado	Toulouse	1 - 1	Monaco
20 Feb 04	Finalizado	Monaco	4 - 0	Montpellier
14 Feb 04	Finalizado	Monaco	0 - 1	Lille
07 Feb 04	Finalizado	Metz	0 - 2	Monaco
30 Ene 04	Finalizado	Monaco	1 - 1	PSG
21 Ene 04	Finalizado	Monaco	1 - 1	Nice
17 Ene 04	Finalizado	Bastia	0 - 0	Monaco
09 Ene 04	Finalizado	Monaco	3 - 0	Olympique Lyonnais
20 Dic 03	Finalizado	Stade Rennais	1 - 0	Monaco
14 Dic 03	Finalizado	Monaco	2 - 0	Strasbourg
05 Dic 03	Finalizado	Olympique Marseille	1 - 2	Monaco
29 Nov 03	Finalizado	Nantes	0 - 1	Monaco
22 Nov 03	Finalizado	Monaco	2 - 0	Lens
09 Nov 03	Finalizado	Ajaccio	0 - 1	Monaco
01 Nov 03	Finalizado	Monaco	4 - 2	Le Mans
26 Oct 03	Finalizado	Sochaux	1 - 1	Monaco
18 Oct 03	Finalizado	Monaco	1 - 1	Auxerre
04 Oct 03	Finalizado	Guingamp	1 - 2	Monaco
27 Sep 03	Finalizado	Monaco	3 - 0	Toulouse
21 Sep 03	Finalizado	Montpellier	1 - 2	Monaco
13 Sep 03	Finalizado	Lille	1 - 1	Monaco
31 Ago 03	Finalizado	Monaco	1 - 0	Metz
24 Ago 03	Finalizado	PSG	2 - 4	Monaco
16 Ago 03	Finalizado	Monaco	2 - 0	Bastia
10 Ago 03	Finalizado	Olympique Lyonnais	3 - 1	Monaco
02 Ago 03	Finalizado	Monaco	2 - 0	Girondins Bordeaux

Copa de Francia »

17 Mar 04	Finalizado	Monaco	0 - 1	Chateauroux
11 Feb 04	Finalizado	Monaco	4 - 1	Olympique Lyonnais
25 Ene 04	Finalizado	Valenciennes	0 - 0	Monaco
04 Ene 04	Finalizado	Metz	0 - 2	Monaco

Copa de la Liga »

29 Oct 03

Finalizado

Olympique Marseille

2 - 0

Monaco

Estadísticas

GOLEADORES

AMARILLAS

Joseph Dayo Oshadogan1

ROJAS

G. Givet1

P. Evra1

Plantilla del Monaco Temporada 2003/2004

		Edad	Altura	Peso
Portero
30	F. Roma	49	191	86	-	-	2
	T. Sylva	48	-	-	-	-	-
Defensa
32	G. Givet	42	181	75	2	1	3
	Hassan El-Fakiri	47	181	74	-	-	-
4	Hugo Ibarra	50	168	70	-	-	4
	Jim Ablancourt	40	-	-	-	-	-
	Joseph Dayo Oshadogan	47	182	78	-	-	1
27	Julien Rodriguez	45	182	80	-	-	5
	M. Ramos	40	177	69	-	-	-
13	P. Evra	42	175	76	-	1	7
19	S. Squillaci	43	184	76	5	-	2
Centrocampista
15	A. Zikos	49	-	-	1	-	6
	E. Cissé	46	186	76	1	-	6
6	J. Plašil	42	182	72	2	-	3
25	J. Rothen	46	177	70	-	-	2
	Jimmy Juan	40	189	83	-	-	-
7	L. Bernardi	46	172	69	2	-	13
8	L. Giuly	47	164	62	13	-	2
	Nicolas Hislen	41	-	-	-	-	-
Delantero
9	Dado Pršo	49	-	-	8	-	3
24	E. Adebayor	40	190	70	8	-	2
10	F. Morientes	48	186	78	10	-	2
	L. Lanteri	39	178	-	-	-	-
	N. Raynier	40	179	77	-	-	-
	S. Camara	41	173	74	2	-	2
	S. Nonda	47	180	76	5	-	-
	Sébastien Grax	39	178	74	-	-	-

Noticias del Monaco

Ver últimas noticias

El Mónaco le quita al Brest la 2ª plaza en su casa

BeSoccer - Domingo, 21 Abril 2024

0 3.136

El Mónaco ganó al Stade Brestois por 0-2 en la jornada 30 de la Ligue 1. Gracias a la cosecha de los 3 puntos, los del Principado se aúpan a la 2ª posición de la clasificación. Goles de Denis Zakaria y Takumi Minamino impulsaron la derrota de los anfitriones, que, para colmo, han disputado un compromiso más que sus verdugos a estas alturas de la temporada y, por tanto, podrían perder aún más fuelle por la plata francesa.

El Mónaco se frota las manos esperando el próximo gol de Martial

BeSoccer - Lunes, 13 Febrero 2017

0 5.266

El francés sigue acertado de cara a portería, este fin de semana ante el Watford, volvió a marcar gol y está a un tanto de llegar a los 25 tantos.

Guido Carrillo dice que 'el Mónaco es un equipo prestigioso y un grande de Francia'

BeSoccer - Martes, 30 Junio 2015

0 282

El delantero argentino Guido Carrillo, recientemente vendido al Mónaco, dijo hoy que su nuevo equipo es "prestigioso y un grande" de la liga francesa de fútbol.

El agente de Abdennour confirma el interés del Barça por él

BeSoccer - Domingo, 28 Junio 2015

0 231

También le quieren Milán, Inter, Juventus y Liverpool y el Manchester United se ha unido a la carrera por el central.

El exjugador Fernando Morientes, nuevo entrenador del Fuenlabrada de 2ªB

BeSoccer - Lunes, 22 Junio 2015

0 386

El exfutbolista internacional Fernando Morientes es el nuevo entrenador del Club de Fútbol Fuenlabrada de Segunda División 'B' para las próximas dos temporadas y será presentado el 29 de junio en el Estadio Fernando Torres de la ciudad madrileña, informó el Fuenlabrada.

Ver más noticias del equipo»

Competiciones que juega

Ligue 1

Pos	Equipos		Pts
1		Olympique Lyonnais	79
2		PSG	76
3		Monaco	75
4		Auxerre	65
5		Sochaux	63
6		Nantes	60
7		Olympique Marseille	57
8		Lens	53
9		Stade Rennais	52
10		Lille	51
11		Nice	50
12		Girondins Bordeaux	50
13		Strasbourg	43
14		Metz	42
15		Ajaccio	40
16		Toulouse	39
17		Bastia	39
18		Guingamp	38
19		Le Mans	38
20		Montpellier	31

RIVALES EN Champions League

RIVALES EN Copa de Francia

RIVALES EN Copa de la Liga

RIVALES EN Ligue 1

USO DE MEMORIA

6,501,208 bytes

BENCHMARKS

Loading Time Base Classes	0.0026
Controller Execution Time ( Home / Category )	0.7550
Total Execution Time	0.7577

CADENA URL

/Monaco/2004

GET DATOS

$_GET['/Monaco/2004']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0146	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 = 'Monaco' AND l.year = 2004 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=1713 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=1713 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=1713 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=1713 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=1713 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=1713 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 = 51
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 = 9627
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 = 9630
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 = 22400
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 = 22410
0.0124	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1713 AND type_rel = 2
0.0182	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1713 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 (1311964,177137,506,792,940) ORDER BY n.cover_points DESC, update_date DESC
0.0145	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 = '1713' AND l.year = 2004 ORDER BY l.year DESC,cat.coefficient DESC
0.0143	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 = '1713' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 9630 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129	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 = 22400 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 = 22410 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 = 51 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130	(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 calendars2004 as c ON c.league_id = l.id WHERE (c.datateam1 = 1713 or c.datateam2 = 1713) AND l.year = 2004 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0135	(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 calendars2004 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 = 1713 or c.datateam2 = 1713) AND l.year = 2004 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0134	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2004 as c ON c.league_id = l.id INNER JOIN events2004 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 = 1713 or c.datateam2 = 1713) AND l.year = 2004)
0.0142	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=1713 AND l.year in (2003,2004,2005) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (40728,22411,22401,9630,52) 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.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 52 AND teamId = 1713
0.0177	SELECT count(id) as num_players from rel_players WHERE league_id = 9630 AND teamId = 1713
0.0180	SELECT count(id) as num_players from rel_players WHERE league_id = 22401 AND teamId = 1713
0.0167	SELECT count(id) as num_players from rel_players WHERE league_id = 22411 AND teamId = 1713
0.0167	SELECT count(id) as num_players from rel_players WHERE league_id = 40728 AND teamId = 1713
0.0146	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2004` 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 = 51 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0202	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 events2004 e ON e.player_id = p.id AND e.league_id = 51 WHERE rp.league_id = 51 AND rp.teamId = 1713 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.0141	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 events2004 e ON e.player_id = p.id AND e.league_id = 51 WHERE rp.league_id = 51 AND rp.teamId = 1713 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137	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 events2004 e ON e.player_id = p.id AND e.league_id = 51 WHERE rp.league_id = 51 AND rp.teamId = 1713 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132	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 = 1713 AND rp.league_id = 51 AND l.year= 2004 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0130	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=2462 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0125	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=2462
0.0136	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 events2004 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2462 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.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 events2004 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2462 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 events2004 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2462 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0130	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 events2004 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2462 AND (e.action = 22) 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 events2004 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2462 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0127	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 = 51 ORDER BY nameShow LIMIT 100

Resultados de Fútbol

Monaco

Información sobre Monaco

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Ligue 1

Copa de Francia

Copa de la Liga

Champions League Grupo 1

Europa League Grupo 8

Partidos Amistosos

Fase Previa Champions League Grupo 4

Supercopa Francia

Recopa de Europa

Copa Emirates

Ligue 2

Trofeo Costa del Sol

Trofeo Teresa Herrera

Partidos del Monaco

Estadísticas

Plantilla del Monaco Temporada 2003/2004

Noticias del Monaco

El Mónaco le quita al Brest la 2ª plaza en su casa

El Mónaco se frota las manos esperando el próximo gol de Martial

Guido Carrillo dice que 'el Mónaco es un equipo prestigioso y un grande de Francia'

El agente de Abdennour confirma el interés del Barça por él

El exjugador Fernando Morientes, nuevo entrenador del Fuenlabrada de 2ªB

Monaco

Selecciona un equipo

Competiciones que juega

Ligue 1

RIVALES EN Champions League

RIVALES EN Copa de Francia

RIVALES EN Copa de la Liga

RIVALES EN Ligue 1


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