23 Feb 06	Finalizado	Monaco	1 - 1	Basel
15 Feb 06	Finalizado	Basel	1 - 0	Monaco
15 Dic 05	Finalizado	Monaco	2 - 1	CSKA Sofia
30 Nov 05	Finalizado	Slavia Praha	0 - 2	Monaco
24 Nov 05	Finalizado	Monaco	2 - 0	Hamburger SV
20 Oct 05	Finalizado	Viking Stavanger	1 - 0	Monaco
29 Sep 05	Finalizado	Willem II	1 - 3	Monaco
15 Sep 05	Finalizado	Monaco	2 - 0	Willem II

Ligue 1 »

13 May 06	Finalizado	Monaco	2 - 2	Nancy
06 May 06	Finalizado	Toulouse	3 - 3	Monaco
29 Abr 06	Finalizado	Monaco	1 - 1	Nantes
23 Abr 06	Finalizado	Monaco	2 - 1	Olympique Lyonnais
15 Abr 06	Finalizado	Le Mans	0 - 0	Monaco
08 Abr 06	Finalizado	Monaco	1 - 0	Olympique Marseille
01 Abr 06	Finalizado	Saint-Étienne	1 - 1	Monaco
25 Mar 06	Finalizado	Monaco	1 - 1	PSG
18 Mar 06	Finalizado	Ajaccio	1 - 0	Monaco
11 Mar 06	Finalizado	Monaco	4 - 1	Sochaux
04 Mar 06	Finalizado	Metz	2 - 1	Monaco
26 Feb 06	Finalizado	Monaco	0 - 1	Lille
18 Feb 06	Finalizado	Nice	2 - 0	Monaco
11 Feb 06	Finalizado	Monaco	1 - 1	Troyes
04 Feb 06	Finalizado	Stade Rennais	1 - 3	Monaco
22 Ene 06	Finalizado	Lens	1 - 1	Monaco
14 Ene 06	Finalizado	Monaco	0 - 1	Girondins Bordeaux
11 Ene 06	Finalizado	Monaco	1 - 1	Strasbourg
05 Ene 06	Finalizado	Auxerre	2 - 1	Monaco
18 Dic 05	Finalizado	Monaco	1 - 0	Toulouse
11 Dic 05	Finalizado	Nantes	0 - 0	Monaco
03 Dic 05	Finalizado	Monaco	2 - 0	Le Mans
27 Nov 05	Finalizado	Olympique Marseille	2 - 1	Monaco
19 Nov 05	Finalizado	Monaco	1 - 0	Saint-Étienne
06 Nov 05	Finalizado	PSG	0 - 0	Monaco
29 Oct 05	Finalizado	Monaco	3 - 0	Ajaccio
23 Oct 05	Finalizado	Sochaux	2 - 1	Monaco
15 Oct 05	Finalizado	Monaco	3 - 0	Metz
02 Oct 05	Finalizado	Lille	0 - 1	Monaco
24 Sep 05	Finalizado	Monaco	0 - 0	Nice
21 Sep 05	Finalizado	Troyes	1 - 2	Monaco
18 Sep 05	Finalizado	Monaco	0 - 2	Stade Rennais
10 Sep 05	Finalizado	Olympique Lyonnais	2 - 1	Monaco
28 Ago 05	Finalizado	Monaco	0 - 0	Lens
20 Ago 05	Finalizado	Girondins Bordeaux	1 - 0	Monaco
14 Ago 05	Finalizado	Strasbourg	1 - 2	Monaco
06 Ago 05	Finalizado	Monaco	0 - 2	Auxerre
30 Jul 05	Finalizado	Nancy	0 - 1	Monaco

Copa de Francia »

	01 Feb 06	Finalizado	Colmar	1 - 0	Monaco			0
	08 Ene 06	Finalizado	Rhone-Vallee	0 - 6	Monaco			0

Copa de la Liga »

07 Feb 06	Finalizado	Monaco	0 - 1	Nice
18 Ene 06	Finalizado	Toulouse	0 - 2	Monaco
21 Dic 05	Finalizado	Monaco	1 - 0	Lille
26 Oct 05	Finalizado	Monaco	1 - 0	Dijon FCO

Fase Previa Champions League »

	23 Ago 05	Finalizado	Monaco	2 - 2	Real Betis			0
	09 Ago 05	Finalizado	Real Betis	1 - 0	Monaco			1

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

P. Evra1

Gerard1

Kapo1

Plantilla del Monaco Temporada 2005/2006

		Edad	Altura	Peso
Portero
	André Biancarelli	54	177	-	-	-	-
	F. Roma	49	191	86	-	-	1
	G. Warmuz	53	185	83	-	-	1
Defensa
	A. Lescure	38	180	79	-	-	1
	Eric Cubilier	44	180	71	-	1	5
	F. Modesto	45	183	80	2	-	4
	G. Givet	42	181	75	2	-	5
	Julien Rodriguez	45	182	80	-	-	-
	Maicon	42	184	77	1	-	9
	Manuel Dos Santos	49	-	-	1	-	1
	O. Veigneau	38	174	69	1	-	1
	P. Evra	42	175	76	-	1	4
	S. Squillaci	43	184	76	1	1	1
Centrocampista
	A. Zikos	49	-	-	1	1	11
	C. Meriem	44	174	70	3	-	1
	D. Pérez	43	177	81	-	-	7
	Gerard	45	180	70	-	1	3
	J. Plašil	42	182	72	1	-	3
	Kapo	43	190	80	5	1	4
	L. Bernardi	46	172	69	-	1	8
	M. Martin	35	178	75	-	-	-
	Muslin	38	185	77	-	-	-
	Olivier Sorlin	45	182	74	1	-	2
Delantero
	C. Vieri	50	-	-	3	-	1
	D. Gigliotti	38	176	74	2	-	4
	E. Adebayor	40	190	70	1	1	-
	E. Chevantón	43	178	76	10	-	3
	M. Di Vaio	47	179	78	5	-	3
	N. Maurice-Belay	39	182	80	-	-	-
	S. Camara	41	173	74	1	-	1
	S. Gakpé	36	177	79	2	-	1
	T. Maoulida	44	184	77	6	-	7

Noticias del Monaco

Ver últimas noticias

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.

En Colombia colocan a Falcao en el Chelsea

BeSoccer - Martes, 30 Junio 2015

0 189

El delantero del Mónaco Radamel Falcao García firmó el contrato para jugar la próxima temporada bajo la dirección del portugués Jose Mourinho en el Chelsea, aseguró hoy el programa deportivo colombiano Gol Caracol.

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	84
2		Girondins Bordeaux	69
3		Lille	62
4		Lens	60
5		Olympique Marseille	60
6		Auxerre	59
7		Stade Rennais	59
8		Nice	58
9		PSG	52
10		Monaco	52
11		Le Mans	52
12		Nancy	48
13		Saint-Étienne	47
14		Nantes	45
15		Sochaux	44
16		Toulouse	41
17		Troyes	39
18		Ajaccio	33
19		Strasbourg	29
20		Metz	29

RIVALES EN Fase Previa Cham.

RIVALES EN Copa de Francia

RIVALES EN Copa de la Liga

RIVALES EN Europa League

RIVALES EN Ligue 1

USO DE MEMORIA

6,815,208 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.9200
Total Execution Time	0.9219

CADENA URL

/Monaco/2006

GET DATOS

$_GET['/Monaco/2006']

POST DATOS

No hay datos POST existentes

CONSULTAS (48)

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 = 'Monaco' AND l.year = 2006 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.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=1713 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=1713 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=1713 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=1713 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=1713 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=1713 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147	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.0156	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 = 53
0.0163	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 = 10994
0.0151	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 = 10995
0.0151	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 = 20484
0.0150	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 = 20542
0.0153	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 = 40715
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1713 AND type_rel = 2
0.0198	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.0147	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 (177137,506,792,940,956) ORDER BY n.cover_points DESC, update_date DESC
0.0157	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 = 2006 ORDER BY l.year DESC,cat.coefficient DESC
0.0157	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.0147	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 = 40715 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149	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 = 20484 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149	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 = 20542 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148	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 = 10995 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 = 53 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0171	(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 calendars2006 as c ON c.league_id = l.id WHERE (c.datateam1 = 1713 or c.datateam2 = 1713) AND l.year = 2006 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0206	(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 calendars2006 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 = 2006 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0181	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2006 as c ON c.league_id = l.id INNER JOIN events2006 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 = 2006)
0.0186	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 (2005,2006,2007) ORDER BY l.id DESC, l.year DESC ;
0.0151	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,20543,20485,10995,9621,54) 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.0203	SELECT count(id) as num_players from rel_players WHERE league_id = 54 AND teamId = 1713
0.0159	SELECT count(id) as num_players from rel_players WHERE league_id = 9621 AND teamId = 1713
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 10995 AND teamId = 1713
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 20485 AND teamId = 1713
0.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 20543 AND teamId = 1713
0.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 40728 AND teamId = 1713
0.0153	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2006` 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 = 53 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 events2006 e ON e.player_id = p.id AND e.league_id = 53 WHERE rp.league_id = 53 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.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 events2006 e ON e.player_id = p.id AND e.league_id = 53 WHERE rp.league_id = 53 AND rp.teamId = 1713 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0163	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 events2006 e ON e.player_id = p.id AND e.league_id = 53 WHERE rp.league_id = 53 AND rp.teamId = 1713 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156	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 = 53 AND l.year= 2006 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=2609 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0154	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=2609
0.0154	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2609 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.0162	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2609 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0157	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2609 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0159	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2609 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0173	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2609 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0149	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 = 53 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

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

Partidos del Monaco

Estadísticas

Plantilla del Monaco Temporada 2005/2006

Noticias del Monaco

Monaco

Selecciona un equipo

Competiciones que juega

RIVALES EN Fase Previa Cham.

RIVALES EN Copa de Francia

RIVALES EN Copa de la Liga

RIVALES EN Europa League

RIVALES EN Ligue 1