Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Montpellier

Entrenador: Michel Der Zakarian

Temporada 2023/2024

TEMPORADA 2023/2024

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	PSG	30	73	26	69
2	Monaco	30	56	38	58
3	Stade	30	44	29	53
4	Lille	30	43	26	52
5	Nice	30	33	24	48
6	Lens	30	39	32	46
7	Stade	30	44	36	42
8	Olympique	30	45	37	41
9	Olympique	30	39	49	41
10	Stade Reims	30	37	41	40
11	Toulouse	30	36	39	37
12	Montpellier	31	39	43	37
13	Strasbourg	30	33	41	36
14	Nantes	31	29	49	32
15	Metz	30	31	49	29
16	Le Havre	30	27	38	28
17	Lorient	30	36	59	26
18	Clermont	30	21	49	22

TEMPORADA 2022/2023

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	PSG	38	89	40	85
2	Lens	38	68	29	84
3	Olympique	38	67	40	73
4	Stade	38	69	39	68
5	Lille	38	65	44	67
6	Monaco	38	70	58	65
7	Olympique	38	65	47	62
8	Clermont	38	45	49	59
9	Nice	38	48	37	58
10	Lorient	38	52	53	55
11	Stade Reims	38	45	45	51
12	Montpellier	38	65	62	50
13	Toulouse	38	51	57	48
14	Stade	38	44	54	44
15	Strasbourg	38	51	59	40
16	Nantes	38	37	55	36
17	Auxerre	38	35	63	35
18	Ajaccio	38	23	74	26
19	Troyes	38	45	81	24
20	Angers SCO	38	33	81	18

TEMPORADA 2021/2022

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	PSG	38	90	36	86
2	Olympique	38	63	38	71
3	Monaco	38	65	40	69
4	Stade	38	82	40	66
5	Nice	38	52	36	66
6	Strasbourg	38	60	43	63
7	Lens	38	62	48	62
8	Olympique	38	66	51	61
9	Nantes	38	55	48	55
10	Lille	38	48	48	55
11	Stade	38	49	57	48
12	Stade Reims	38	43	44	46
13	Montpellier	38	49	61	43
14	Angers SCO	38	44	55	41
15	Troyes	38	37	53	38
16	Lorient	38	35	63	36
17	Clermont	38	38	69	36
18	Saint-Étien	38	42	77	32
19	Metz	38	35	69	31
20	Girondins	38	52	91	31

TEMPORADA 2020/2021

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Lille	38	64	23	83
2	PSG	38	86	28	82
3	Monaco	38	76	42	78
4	Olympique	38	81	43	76
5	Olympique	38	54	47	60
6	Stade	38	52	40	58
7	Lens	38	55	54	57
8	Montpellier	38	60	62	54
9	Nice	38	50	53	52
10	Metz	38	44	48	47
11	Saint-Étien	38	42	54	46
12	Girondins	38	42	56	45
13	Angers SCO	38	40	58	44
14	Stade Reims	38	42	50	42
15	Strasbourg	38	49	58	42
16	Lorient	38	50	68	42
17	Stade	38	50	66	41
18	Nantes	38	47	55	40
19	Nîmes	38	40	71	35
20	Dijon FCO	38	25	73	21

TEMPORADA 2019/2020

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	PSG	27	75	24	68
2	Olympique	28	41	29	56
3	Stade	28	38	24	50
4	Lille	28	35	27	49
5	Stade Reims	28	26	21	41
6	Nice	28	41	38	41
7	Olympique	28	42	27	40
8	Montpellier	28	35	34	40
9	Monaco	28	44	44	40
10	Angers SCO	28	28	33	39
11	Strasbourg	27	32	32	38
12	Girondins	28	40	34	37
13	Nantes	28	28	31	37
14	Stade	28	34	37	34
15	Metz	28	27	35	34
16	Dijon FCO	28	27	37	30
17	Saint-Étien	28	29	45	30
18	Nîmes	28	29	44	27
19	Amiens SC	28	31	50	23
20	Toulouse	28	22	58	13

TEMPORADA 2018/2019

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	PSG	38	105	35	91
2	Lille	38	68	33	75
3	Olympique	38	70	47	72
4	Saint-Étien	38	59	41	66
5	Olympique	38	60	52	61
6	Montpellier	38	53	42	59
7	Nice	38	30	35	56
8	Stade Reims	38	39	42	55
9	Nîmes	38	57	58	53
10	Stade	38	55	52	52
11	Strasbourg	38	58	48	49
12	Nantes	38	48	48	48
13	Angers SCO	38	44	49	46
14	Girondins	38	34	42	41
15	Amiens SC	38	31	52	38
16	Toulouse	38	35	57	38
17	Monaco	38	38	57	36
18	Dijon FCO	38	31	60	34
19	Caen	38	29	54	33
20	Guingamp	38	28	68	27

TEMPORADA 2017/2018

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	PSG	38	108	29	93
2	Monaco	38	85	45	80
3	Olympique	38	87	43	78
4	Olympique	38	80	47	77
5	Stade	38	50	44	58
6	Girondins	38	53	48	55
7	Saint-Étien	38	47	50	55
8	Nice	38	53	52	54
9	Nantes	38	36	41	52
10	Montpellier	38	36	33	51
11	Dijon FCO	38	55	73	48
12	Guingamp	38	48	59	47
13	Amiens SC	38	37	42	45
14	Angers SCO	38	42	52	41
15	Strasbourg	38	44	67	38
16	Caen	38	27	52	38
17	Lille	38	41	67	38
18	Toulouse	38	38	54	37
19	Troyes	38	32	59	33
20	Metz	38	34	76	26

TEMPORADA 2016/2017

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Monaco	38	107	31	95
2	PSG	38	83	27	87
3	Nice	38	63	36	78
4	Olympique	38	77	48	67
5	Olympique	38	57	41	62
6	Girondins	38	53	43	59
7	Nantes	38	40	54	51
8	Saint-Étien	38	41	42	50
9	Stade	38	36	42	50
10	Guingamp	38	46	53	50
11	Lille	38	40	47	46
12	Angers SCO	38	40	49	46
13	Toulouse	38	37	41	44
14	Metz	38	39	72	43
15	Montpellier	38	48	66	39
16	Dijon FCO	38	46	58	37
17	Caen	38	36	65	37
18	Lorient	38	44	70	36
19	Nancy	38	29	52	35
20	Bastia	38	29	54	34

TEMPORADA 2015/2016

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	PSG	38	102	19	96
2	Olympique	38	67	43	65
3	Monaco	38	57	50	65
4	Nice	38	58	41	63
5	Lille	38	39	27	60
6	Saint-Étien	38	42	37	58
7	Caen	38	39	52	54
8	Stade	38	52	54	52
9	Angers SCO	38	40	38	50
10	Bastia	38	36	42	50
11	Girondins	38	50	57	50
12	Montpellier	38	49	47	49
13	Olympique	38	48	42	48
14	Nantes	38	33	44	48
15	Lorient	38	47	58	46
16	Guingamp	38	47	56	44
17	Toulouse	38	45	55	40
18	Stade Reims	38	44	57	39
19	Gazélec	38	37	58	37
20	Troyes	38	28	83	18

TEMPORADA 2014/2015

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	PSG	38	83	36	83
2	Olympique	38	72	33	75
3	Monaco	38	51	26	71
4	Olympique	38	76	42	69
5	Saint-Étien	38	51	30	69
6	Girondins	38	47	44	63
7	Montpellier	38	46	39	56
8	Lille	38	43	42	56
9	Stade	38	35	42	50
10	Guingamp	38	41	55	49
11	Nice	38	44	53	48
12	Bastia	38	37	46	47
13	Caen	38	54	55	46
14	Nantes	38	29	40	45
15	Stade Reims	38	47	66	44
16	Lorient	38	44	50	43
17	Toulouse	38	43	64	42
18	Evian Thonon	38	41	62	37
19	Metz	38	31	61	30
20	Lens	38	32	61	29

TEMPORADA 2013/2014

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	PSG	38	84	23	89
2	Monaco	38	63	31	80
3	Lille	38	46	26	71
4	Saint-Étien	38	56	34	69
5	Olympique	38	56	44	61
6	Olympique	38	53	40	60
7	Girondins	38	49	43	53
8	Lorient	38	48	53	49
9	Toulouse	38	46	53	49
10	Stade Reims	38	44	52	48
11	Nantes	38	38	43	47
12	Bastia	38	42	56	47
13	Stade	38	47	45	46
14	Evian Thonon	38	39	51	44
15	Montpellier	38	45	53	42
16	Guingamp	38	34	42	42
17	Nice	38	30	44	42
18	Sochaux	38	37	61	40
19	Valenciennes	38	37	65	29
20	Ajaccio	38	37	72	23

TEMPORADA 2012/2013

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	PSG	38	69	23	83
2	Olympique	38	42	36	71
3	Olympique	38	61	38	67
4	Nice	38	57	46	64
5	Saint-Étien	38	60	32	63
6	Lille	38	59	40	62
7	Girondins	38	40	34	55
8	Lorient	38	57	58	53
9	Montpellier	38	54	51	52
10	Toulouse	38	49	47	51
11	Valenciennes	38	49	53	48
12	Bastia	38	50	66	47
13	Stade	38	48	59	46
14	Stade Reims	38	33	42	43
15	Ajaccio	38	39	51	42
16	Sochaux	38	41	57	41
17	Evian Thonon	38	46	53	40
18	Nancy	38	38	58	38
19	Troyes	38	43	61	37
20	Stade	38	32	62	29

TEMPORADA 2011/2012

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Montpellier	38	68	34	82
2	PSG	38	75	41	79
3	Lille	38	72	39	74
4	Olympique	38	64	51	64
5	Girondins	38	53	41	61
6	Stade	38	53	44	60
7	Saint-Étien	38	49	45	57
8	Toulouse	38	37	34	56
9	Evian Thonon	38	54	55	50
10	Olympique	38	45	41	48
11	Nancy	38	38	48	45
12	Valenciennes	38	40	50	43
13	Nice	38	39	46	42
14	Sochaux	38	40	60	42
15	Stade	38	31	38	41
16	Ajaccio	38	40	61	41
17	Lorient	38	35	49	39
18	Caen	38	39	59	38
19	Dijon FCO	38	38	63	36
20	Auxerre	38	46	57	34

TEMPORADA 2010/2011

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Lille	38	68	36	76
2	Olympique	38	62	39	68
3	Olympique	38	61	40	64
4	PSG	38	56	41	60
5	Sochaux	38	60	43	58
6	Stade	38	38	35	56
7	Girondins	38	43	42	51
8	Toulouse	38	38	36	50
9	Auxerre	38	45	41	49
10	Saint-Étien	38	46	47	49
11	Lorient	38	46	48	49
12	Valenciennes	38	45	41	48
13	Nancy	38	43	48	48
14	Montpellier	38	32	43	47
15	Caen	38	46	51	46
16	Stade	38	36	43	46
17	Nice	38	33	48	46
18	Monaco	38	36	40	44
19	Lens	38	35	58	35
20	Arles	38	21	70	20

TEMPORADA 2009/2010

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Olympique	38	69	36	78
2	Olympique	38	64	38	72
3	Auxerre	38	42	29	71
4	Lille	38	72	40	70
5	Montpellier	38	50	40	69
6	Girondins	38	58	40	64
7	Lorient	38	54	42	58
8	Monaco	38	39	45	55
9	Stade	38	52	41	53
10	Valenciennes	38	50	50	52
11	Lens	38	40	44	48
12	Nancy	38	46	53	48
13	PSG	38	50	46	47
14	Toulouse	38	36	36	47
15	Nice	38	41	57	44
16	Sochaux	38	28	52	41
17	Saint-Étien	38	27	45	40
18	Le Mans	38	36	59	32
19	US Boulogne	38	31	62	31
20	Grenoble	38	31	61	23

TEMPORADA 2008/2009

LIGUE 2
Equipo		PJ	GF	GC	Puntos
1	Lens	38	47	35	68
2	Montpellier	38	61	36	66
3	US Boulogne	38	51	36	66
4	Strasbourg	38	57	45	65
5	Metz	38	48	35	63
6	Tours	38	50	41	61
7	Angers SCO	38	46	42	53
8	Dijon FCO	38	43	46	52
9	CS Sedan	38	46	49	51
10	Vannes	38	34	45	51
11	Bastia	38	38	47	48
12	Clermont	38	46	50	47
13	Guingamp	38	37	35	46
14	Stade	38	45	50	45
15	Chateauroux	38	40	46	44
16	Ajaccio	38	44	56	44
17	Nîmes	38	32	46	44
18	Amiens SC	38	35	40	43
19	Troyes	38	39	48	38
20	Stade Reims	38	40	51	36

TEMPORADA 2007/2008

LIGUE 2
Equipo		PJ	GF	GC	Puntos
1	Le Havre	38	66	30	78
2	Nantes	38	58	34	70
3	Grenoble	38	44	30	63
4	CS Sedan	38	46	40	58
5	Clermont	38	50	41	57
6	Troyes	38	46	44	57
7	Stade	38	38	38	57
8	Montpellier	38	43	32	54
9	Ajaccio	38	37	41	54
10	Angers SCO	38	39	35	53
11	Bastia	38	45	46	51
12	Guingamp	38	41	37	48
13	Stade Reims	38	44	52	46
14	Amiens SC	38	49	51	45
15	Chateauroux	38	34	42	45
16	US Boulogne	38	37	54	43
17	Dijon FCO	38	32	51	42
18	Niort	38	38	48	41
19	FC Libourne	38	41	62	32
20	FC Gueugnon	38	39	59	27

TEMPORADA 2006/2007

LIGUE 2
Equipo		PJ	GF	GC	Puntos
1	Metz	38	54	22	76
2	Caen	38	65	40	71
3	Strasbourg	38	47	33	70
4	Amiens SC	38	57	42	69
5	Grenoble	38	51	39	59
6	Le Havre	38	52	38	56
7	Chateauroux	38	42	43	54
8	Dijon FCO	38	44	47	54
9	Bastia	38	52	49	53
10	FC Gueugnon	38	47	52	48
11	Stade Reims	38	43	46	47
12	Ajaccio	38	44	50	47
13	Guingamp	38	45	44	46
14	Stade	38	40	40	45
15	Montpellier	38	41	48	44
16	Niort	38	36	44	44
17	FC Libourne	38	43	52	44
18	Creteil	38	33	50	40
19	Istres	38	35	63	35
20	Tours	38	29	58	26

TEMPORADA 2005/2006

LIGUE 2
Equipo		PJ	GF	GC	Puntos
1	Valenciennes	38	51	28	74
2	CS Sedan	38	50	32	71
3	Lorient	38	49	26	66
4	Caen	38	56	35	66
5	Dijon FCO	38	47	32	60
6	Bastia	38	47	40	58
7	Le Havre	38	48	41	55
8	Creteil	38	46	33	54
9	Guingamp	38	36	32	50
10	Grenoble	38	42	45	48
11	FC Gueugnon	38	29	37	48
12	Montpellier	38	34	43	47
13	Istres	38	33	45	47
14	Stade Reims	38	32	31	45
15	Chateauroux	38	48	48	44
16	Amiens SC	38	32	44	43
17	Stade	38	34	48	42
18	Clermont	38	35	59	38
19	Stade	38	38	59	35
20	Sète	38	31	60	23

TEMPORADA 2004/2005

LIGUE 2
Equipo		PJ	GF	GC	Puntos
1	Nancy	38	54	33	71
2	Le Mans	38	51	30	68
3	Troyes	38	61	48	68
4	Dijon FCO	38	44	34	57
5	Chateauroux	38	51	43	57
6	CS Sedan	38	38	38	57
7	Guingamp	38	53	43	56
8	Montpellier	38	44	39	55
9	Stade	38	38	34	55
10	Grenoble	38	45	50	48
11	FC Gueugnon	38	30	40	48
12	Amiens SC	38	41	41	47
13	Stade	38	43	51	47
14	Lorient	38	44	53	47
15	Creteil	38	42	38	46
16	Stade Reims	38	34	55	43
17	Le Havre	38	28	42	42
18	Clermont	38	34	39	39
19	Niort	38	40	52	38
20	Angers SCO	38	32	44	38

Competiciones que juega

Ligue 1

Pos	Equipos		Pts
1		PSG	69
2		Monaco	58
3		Stade Brestois	53
4		Lille	52
5		Nice	48
6		Lens	46
7		Stade Rennais	42
8		Olympique Marseille	41
9		Olympique Lyonnais	41
10		Stade de Reims	40
11		Toulouse	37
12		Montpellier	37
13		Strasbourg	36
14		Nantes	32
15		Metz	29
16		Le Havre	28
17		Lorient	26
18		Clermont	22

	Campeón : PSG
	Champions League : Monaco, Stade Brestois
	Previa de Champions : Lille
	Europa League : Nice
	: Lens
	Playoff Descenso : Le Havre
	Descenso : Lorient, Clermont

RIVALES EN Copa de Francia

RIVALES EN Ligue 1

USO DE MEMORIA

8,619,720 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.4958
Total Execution Time	0.4970

CADENA URL

/historico/Montpellier-Hsc

GET DATOS

$_GET['/historico/Montpellier-Hsc']

POST DATOS

No hay datos POST existentes

CONSULTAS (27)

0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1728 AND type_rel = 2
0.0131	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1728 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 (1312768,41287,218,1087,1647) ORDER BY n.cover_points DESC, update_date DESC
0.0136	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 = '1728' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135	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=1728 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125	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 (74470,72046,71432) 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.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 72046 AND teamId = 1728
0.0137	SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 1728
0.0207	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1728
0.0144	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 events2024 e ON e.player_id = p.id AND e.league_id = 72046 WHERE rp.league_id = 72046 AND rp.teamId = 1728 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 events2024 e ON e.player_id = p.id AND e.league_id = 72046 WHERE rp.league_id = 72046 AND rp.teamId = 1728 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 events2024 e ON e.player_id = p.id AND e.league_id = 72046 WHERE rp.league_id = 72046 AND rp.teamId = 1728 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 1728 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0255	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2023` 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 = 67675 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2022` 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 = 62745 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2021` 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 = 56825 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2020` 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 = 49849 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2019` 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 = 43549 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 38644 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2015` 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 = 3771 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM* `tables2014` 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 = 2432 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2012` 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 = 1327 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2011` 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 = 1072 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2009` 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 = 450 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2007` 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 = 518 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId 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 = 519 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2005` 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 = 520 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Montpellier

Montpellier

Selecciona un equipo

Competiciones que juega

Ligue 1

RIVALES EN Copa de Francia

RIVALES EN Ligue 1