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

Lorient

Entrenador: Régis Le Bris

Temporada 2020/2021

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 2
Equipo		PJ	GF	GC	Puntos
1	Lorient	28	45	25	54
2	Lens	28	39	24	53
3	Ajaccio	28	38	22	52
4	Troyes	28	34	25	51
5	Clermont	28	35	25	50
6	Le Havre	28	38	25	44
7	Valenciennes	28	24	20	42
8	Guingamp	28	40	33	39
9	Grenoble	28	27	29	35
10	Chambly	28	26	32	35
11	Auxerre	28	31	30	34
12	Nancy	28	27	26	34
13	Caen	28	33	34	34
14	Sochaux	28	28	30	34
15	Chateauroux	28	22	38	34
16	Rodez	28	31	34	32
17	Paris FC	28	22	40	28
18	Niort	28	30	41	26
19	Le Mans	28	30	45	26
20	Orléans	28	21	43	19

TEMPORADA 2018/2019

LIGUE 2
Equipo		PJ	GF	GC	Puntos
1	Metz	38	60	23	81
2	Stade	38	64	35	74
3	Troyes	38	51	28	71
4	Paris FC	38	36	22	65
5	Lens	38	49	28	63
6	Lorient	38	51	41	63
7	Le Havre	38	45	40	54
8	Orléans	38	51	53	52
9	Grenoble	38	43	47	50
10	Clermont	38	44	37	48
11	Chateauroux	38	37	42	48
12	Niort	38	34	41	47
13	Valenciennes	38	52	61	43
14	Nancy	38	36	50	42
15	Auxerre	38	34	36	41
16	Sochaux	38	27	43	41
17	Ajaccio	38	29	45	40
18	Gazélec	38	30	54	39
19	Béziers	38	33	50	38
20	Red Star	38	28	58	30

TEMPORADA 2017/2018

LIGUE 2
Equipo		PJ	GF	GC	Puntos
1	Stade Reims	38	74	24	88
2	Nîmes	38	75	37	73
3	Ajaccio	38	62	43	68
4	Le Havre	38	53	34	66
5	Stade	38	58	43	65
6	Clermont	38	54	36	63
7	Lorient	38	61	46	62
8	Paris FC	38	46	36	61
9	Chateauroux	38	50	50	60
10	Sochaux	38	51	62	53
11	Auxerre	38	51	55	47
12	Orléans	38	52	61	46
13	Valenciennes	38	50	64	45
14	Lens	38	48	49	43
15	Niort	38	47	60	42
16	Gazélec	38	35	60	41
17	Nancy	38	39	54	38
18	Bourg-Péron	38	50	87	36
19	QRM	38	45	66	33
20	Tours	38	34	68	23

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 1
Equipo		PJ	GF	GC	Puntos
1	Girondins	38	64	34	80
2	Olympique	38	67	35	77
3	Olympique	38	52	29	71
4	Toulouse	38	45	27	64
5	Lille	38	51	39	64
6	PSG	38	49	38	64
7	Stade	38	42	34	61
8	Auxerre	38	35	35	55
9	Nice	38	40	41	50
10	Lorient	38	47	47	45
11	Monaco	38	41	45	45
12	Valenciennes	38	35	42	44
13	Grenoble	38	24	37	44
14	Sochaux	38	40	48	42
15	Nancy	38	38	47	42
16	Le Mans	38	43	54	40
17	Saint-Étien	38	40	56	40
18	Caen	38	42	49	37
19	Nantes	38	33	54	37
20	Le Havre	38	30	67	26

TEMPORADA 2007/2008

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Olympique	38	74	37	79
2	Girondins	38	65	38	75
3	Olympique	38	58	45	62
4	Nancy	38	44	30	60
5	Saint-Étien	38	47	34	58
6	Stade	38	47	44	58
7	Lille	38	45	32	57
8	Nice	38	35	30	55
9	Le Mans	38	46	49	53
10	Lorient	38	32	35	52
11	Caen	38	48	53	51
12	Monaco	38	40	48	47
13	Valenciennes	38	42	40	45
14	Sochaux	38	34	43	44
15	Auxerre	38	33	52	44
16	PSG	38	37	45	43
17	Toulouse	38	36	42	42
18	Lens	38	43	52	40
19	Strasbourg	38	34	55	35
20	Metz	38	28	64	24

TEMPORADA 2006/2007

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Olympique	38	64	27	81
2	Olympique	38	53	38	64
3	Stade	38	38	30	57
4	Lens	38	47	41	57
5	Girondins	38	39	35	57
6	Sochaux	38	46	48	57
7	Toulouse	38	44	43	56
8	Auxerre	38	41	41	54
9	Monaco	38	45	38	51
10	Lille	38	45	43	50
11	Saint-Étien	38	52	50	49
12	Le Mans	38	45	46	49
13	Nancy	38	37	44	49
14	Lorient	38	33	40	49
15	PSG	38	42	42	48
16	Nice	38	34	40	43
17	Valenciennes	38	36	48	43
18	Troyes	38	39	54	39
19	CS Sedan	38	46	58	35
20	Nantes	38	29	49	35

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

TEMPORADA 2003/2004

LIGUE 2
Equipo		PJ	GF	GC	Puntos
1	Saint-Étien	38	44	29	73
2	Caen	38	56	31	71
3	Istres	38	44	26	66
4	Lorient	38	57	45	61
5	CS Sedan	38	42	31	60
6	Nancy	38	45	36	55
7	Le Havre	38	44	46	55
8	Niort	38	47	44	53
9	Amiens SC	38	43	45	53
10	Troyes	38	43	48	52
11	Chateauroux	38	44	49	49
12	Creteil	38	41	47	45
13	Angers SCO	38	36	43	45
14	Clermont	38	36	48	44
15	Grenoble	38	38	43	43
16	FC Gueugnon	38	40	43	42
17	Stade	38	51	55	42
18	Valence	38	45	56	40
19	Besancon RC	38	37	45	38
20	Rouen 1899	38	27	50	29

TEMPORADA 2002/2003

LIGUE 2
Equipo		PJ	GF	GC	Puntos
1	Toulouse	38	50	24	72
2	Le Mans	38	49	33	68
3	Metz	38	52	29	67
4	Lorient	38	43	29	65
5	Chateauroux	38	40	35	60
6	Niort	38	44	40	53
7	Caen	38	45	40	52
8	Stade	38	41	42	52
9	Saint-Étien	38	34	30	51
10	Amiens SC	38	30	33	49
11	FC Gueugnon	38	35	42	49
12	Grenoble	38	39	29	47
13	Valence	38	38	42	46
14	Clermont	38	39	51	46
15	Nancy	38	30	47	43
16	Istres	38	32	53	43
17	Creteil	38	39	42	42
18	Beauvais	38	20	32	37
19	Wasquehal	38	26	39	36
20	Stade Reims	38	31	45	35

TEMPORADA 2001/2002

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Olympique	34	62	32	66
2	Lens	34	55	30	64
3	Auxerre	34	48	38	59
4	PSG	34	43	24	58
5	Lille	34	39	32	56
6	Girondins	34	34	31	50
7	Troyes	34	40	35	47
8	Sochaux	34	41	40	46
9	Olympique	34	34	39	44
10	Nantes	34	35	41	43
11	Bastia	34	38	44	41
12	Stade	34	40	51	41
13	Montpellier	34	28	31	40
14	CS Sedan	34	35	39	39
15	Monaco	34	36	41	39
16	Guingamp	34	34	57	35
17	Metz	34	31	47	33
18	Lorient	34	43	64	31

Competiciones que juega

Ligue 1

Pos	Equipos		Pts
1		Lille	83
2		PSG	82
3		Monaco	78
4		Olympique Lyonnais	76
5		Olympique Marseille	60
6		Stade Rennais	58
7		Lens	57
8		Montpellier	54
9		Nice	52
10		Metz	47
11		Saint-Étienne	46
12		Girondins Bordeaux	45
13		Angers SCO	44
14		Stade de Reims	42
15		Strasbourg	42
16		Lorient	42
17		Stade Brestois	41
18		Nantes	40
19		Nîmes	35
20		Dijon FCO	21

	Champions League : Lille, PSG
	Previa de Champions : Monaco
	Europa League : Olympique Lyonnais, Olympique Marseille
	Conference League : Stade Rennais
	Playoff Descenso : Nantes
	Descenso : Nîmes, Dijon FCO

RIVALES EN Copa de Francia

RIVALES EN Ligue 1

USO DE MEMORIA

8,484,784 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6537
Total Execution Time	0.6549

CADENA URL

/historico/Lorient/2021

GET DATOS

$_GET['/historico/Lorient/2021']

POST DATOS

No hay datos POST existentes

CONSULTAS (37)

0.0167	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 = 'Lorient' AND l.year = 2021 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.0130	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=1586 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=1586 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=1586 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=1586 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0141	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 = 56825
0.0161	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 = '1586' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0167	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 = '1586' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0136	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 = 56825 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0180	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=1586 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0134	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 (65709,62807,62745,50213,49879) 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.0159	SELECT count(id) as num_players from rel_players WHERE league_id = 62745 AND teamId = 1586
0.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 49879 AND teamId = 1586
0.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 65709 AND teamId = 1586
0.0135	SELECT count(id) as num_players from rel_players WHERE league_id = 50213 AND teamId = 1586
0.0286	SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 1586
0.0133	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0155	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 events2021 e ON e.player_id = p.id AND e.league_id = 56825 WHERE rp.league_id = 56825 AND rp.teamId = 1586 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.0156	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 events2021 e ON e.player_id = p.id AND e.league_id = 56825 WHERE rp.league_id = 56825 AND rp.teamId = 1586 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151	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 events2021 e ON e.player_id = p.id AND e.league_id = 56825 WHERE rp.league_id = 56825 AND rp.teamId = 1586 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0145	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 = 1586 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0134	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.0134	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 = 49879 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.0136	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 = 38663 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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* `tables2016` 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 = 15065 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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.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* `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* `tables2013` 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 = 1910 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* `tables2010` 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 = 816 AND t.round = 38 ORDER BY team.conference 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* `tables2008` 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 = 26 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* `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 = 54 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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.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* `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
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* `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 = 521 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* `tables2003` 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 = 522 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* `tables2002` 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 = 49 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Lorient

Lorient

Selecciona un equipo

Competiciones que juega

Ligue 1

RIVALES EN Copa de Francia

RIVALES EN Ligue 1