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

Resultados de Fútbol

Nantes

Entrenador: Antoine Kombouaré

Temporada 1974/1975

TEMPORADA 1974/1975

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Saint-Étien	38	70	39	52
2	Olympique	38	65	45	45
3	Olympique	38	64	53	43
4	Nantes	38	50	42	43
5	Nîmes	38	56	49	43
6	Bastia	38	54	47	41
7	Lens	38	59	59	40
8	Metz	38	54	56	40
9	Monaco	38	64	68	40
10	Strasbourg	38	49	56	40
11	Stade Reims	38	57	57	38
12	Girondins	38	48	49	37
13	Nice	38	59	63	36
14	PSG	38	57	65	36
15	Lille	38	53	56	35
16	Troyes	38	46	55	34
17	Sochaux	38	41	49	32
18	Stade	38	38	52	31
19	Angers SCO	38	48	60	28
20	Red Star	38	43	55	26

TEMPORADA 1973/1974

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Saint-Étien	38	74	40	55
2	Nantes	38	63	41	47
3	Olympique	38	64	51	47
4	Angers SCO	38	77	57	43
5	Nice	38	71	55	42
6	Sochaux	38	59	46	42
7	Nîmes	38	41	37	41
8	Stade	38	42	47	40
9	Stade Reims	38	67	62	39
10	Strasbourg	38	62	67	37
11	Bastia	38	44	49	36
12	Lens	38	58	65	36
13	Metz	38	53	53	35
14	Olympique	38	58	62	35
15	Girondins	38	55	57	34
16	Monaco	38	64	73	33
17	Troyes	38	52	63	33
18	Nancy	38	51	67	33
19	Paris FC	38	54	79	27
20	CS Sedan	38	42	80	25

TEMPORADA 1972/1973

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Nantes	38	67	31	55
2	Nice	38	70	44	50
3	Olympique	38	64	37	48
4	Saint-Étien	38	64	47	46
5	Angers SCO	38	52	47	43
6	Nancy	38	59	47	42
7	Nîmes	38	48	39	42
8	Stade Reims	38	50	47	41
9	Bastia	38	59	41	38
10	Stade	38	46	53	38
11	Sochaux	38	56	54	37
12	Paris FC	38	54	58	36
13	Olympique	38	62	67	35
14	Girondins	38	49	55	35
15	Metz	38	44	52	35
16	Strasbourg	38	42	62	30
17	CS Sedan	38	49	71	30
18	Valenciennes	38	37	51	28
19	Red Star	38	38	58	28
20	Ajaccio	38	40	89	23

TEMPORADA 1971/1972

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Olympique	38	78	37	56
2	Nîmes	38	76	37	51
3	Sochaux	38	57	42	47
4	Angers SCO	38	56	40	45
5	Olympique	38	58	45	45
6	Saint-Étien	38	81	59	44
7	Nantes	38	70	48	43
8	Nice	38	58	44	42
9	Bastia	38	58	57	42
10	Nancy	38	56	49	40
11	Stade	38	53	54	38
12	Girondins	38	39	52	35
13	Ajaccio	38	49	53	33
14	Metz	38	44	49	33
15	Stade Reims	38	46	69	31
16	PSG	38	51	67	30
17	Red Star	38	34	64	30
18	Lille	38	43	68	26
19	Monaco	38	41	68	26
20	Angouleme	38	39	85	23

TEMPORADA 1970/1971

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Olympique	38	94	48	55
2	Saint-Étien	38	83	45	51
3	Nantes	38	61	41	46
4	Nîmes	38	68	54	45
5	Girondins	38	58	51	40
6	Ajaccio	38	54	52	40
7	Olympique	38	51	51	40
8	Metz	38	46	56	40
9	Stade Reims	38	54	44	39
10	Sochaux	38	58	55	38
11	Stade	38	56	53	37
12	Angers SCO	38	61	66	35
13	Nancy	38	45	56	35
14	Nice	38	48	55	34
15	Red Star	38	46	65	33
16	Angouleme	38	30	47	32
17	Bastia	38	52	83	32
18	Strasbourg	38	54	63	31
19	Valenciennes	38	47	59	29
20	CS Sedan	38	42	64	28

TEMPORADA 1969/1970

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Saint-Étien	34	88	30	56
2	Olympique	34	75	41	45
3	CS Sedan	34	54	42	42
4	Angouleme	34	53	43	38
5	Strasbourg	34	65	55	36
6	Girondins	34	54	48	36
7	Angers SCO	34	53	53	35
8	Metz	34	50	44	34
9	Sochaux	34	48	55	34
10	Nantes	34	62	56	33
11	Nîmes	34	60	55	32
12	Rouen 1899	34	41	45	32
13	Red Star	34	45	67	30
14	Stade	34	52	73	29
15	Olympique	34	57	78	28
16	Ajaccio	34	34	51	26
17	Bastia	34	50	74	24
18	Valenciennes	34	32	63	22

TEMPORADA 1968/1969

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Saint-Étien	34	70	26	53
2	Girondins	34	77	34	51
3	Metz	34	41	27	42
4	Rouen 1899	34	44	43	40
5	CS Sedan	34	49	35	39
6	Bastia	34	50	66	34
7	Olympique	34	51	48	33
8	Valenciennes	34	38	37	33
9	Olympique	34	53	51	32
10	Nantes	34	44	45	32
11	Stade	34	50	57	31
12	Sochaux	34	49	55	29
13	Strasbourg	34	34	41	29
14	Nîmes	34	32	39	29
15	Red Star	34	35	48	29
16	Ajaccio	34	36	53	28
17	Monaco	34	33	50	27
18	Nice	34	30	61	21

TEMPORADA 1967/1968

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Saint-Étien	38	78	30	57
2	Nice	38	49	41	46
3	Sochaux	38	48	39	43
4	Olympique	38	49	46	43
5	Valenciennes	38	42	34	42
6	Metz	38	49	44	42
7	Nantes	38	55	50	41
8	Girondins	38	57	44	40
9	Ajaccio	38	59	59	39
10	CS Sedan	38	56	47	38
11	Monaco	38	45	48	37
12	Olympique	38	53	51	36
13	Red Star	38	44	43	36
14	Stade	38	49	57	36
15	Rouen 1899	38	48	51	35
16	Strasbourg	38	34	40	34
17	Lens	38	48	61	34
18	Angers SCO	38	56	70	34
19	Lille	38	35	52	27
20	AS Aix	38	48	95	20

TEMPORADA 1966/1967

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Saint-Étien	38	82	37	54
2	Nantes	38	81	51	50
3	Angers SCO	38	66	46	44
4	Girondins	38	53	43	43
5	CS Sedan	38	58	50	42
6	Nice	38	53	55	41
7	Valenciennes	38	42	37	40
8	Lens	38	58	55	40
9	Olympique	38	44	45	39
10	Lille	38	48	50	38
11	Stade	38	59	56	37
12	Strasbourg	38	54	52	36
13	Sochaux	38	43	53	35
14	Monaco	38	44	44	34
15	Olympique	38	40	56	34
16	Rouen 1899	38	37	44	33
17	Toulouse	38	40	52	32
18	Nîmes	38	43	64	32
19	Stade Reims	38	40	66	30
20	Stade	38	18	47	26

TEMPORADA 1965/1966

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Nantes	38	84	36	60
2	Girondins	38	84	36	53
3	Valenciennes	38	58	44	52
4	Toulouse	38	61	46	46
5	Saint-Étien	38	85	62	45
6	Stade	38	80	70	42
7	Sochaux	38	61	56	39
8	Strasbourg	38	59	47	38
9	CS Sedan	38	68	58	38
10	Nice	38	66	59	36
11	Angers SCO	38	68	66	36
12	Lens	38	55	57	36
13	Monaco	38	48	54	35
14	Rouen 1899	38	41	62	34
15	Stade	38	45	57	33
16	Olympique	38	43	56	33
17	Nîmes	38	52	67	33
18	Lille	38	51	71	30
19	Cannes	38	37	86	21
20	Red Star	38	44	100	20

TEMPORADA 1964/1965

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Nantes	34	66	45	43
2	Girondins	34	43	32	41
3	Valenciennes	34	52	30	40
4	Stade	34	67	48	38
5	Strasbourg	34	56	46	38
6	Olympique	34	46	50	36
7	Saint-Étien	34	48	43	35
8	Lens	34	55	61	35
9	Lille	34	57	48	34
10	Sochaux	34	49	45	34
11	Toulouse	34	50	52	33
12	Monaco	34	41	45	33
13	Angers SCO	34	44	51	31
14	CS Sedan	34	51	58	30
15	Stade	34	40	52	30
16	Rouen 1899	34	31	48	30
17	Nîmes	34	42	58	29
18	Sporting	34	31	57	22

TEMPORADA 1963/1964

LIGUE 1
Equipo		PJ	GF	GC	Puntos
1	Saint-Étien	34	71	48	44
2	Monaco	34	62	45	41
3	Lens	34	71	46	40
4	Olympique	34	58	53	39
5	Toulouse	34	56	54	37
6	Valenciennes	34	49	39	35
7	Girondins	34	55	58	34
8	Nantes	34	51	59	34
9	Strasbourg	34	43	41	33
10	Angers SCO	34	54	62	33
11	Stade	34	54	65	33
12	CS Sedan	34	62	52	32
13	Nîmes	34	45	45	32
14	Rouen 1899	34	50	51	32
15	Stade	34	48	53	32
16	Racing Paris	34	66	76	31
17	Stade Reims	34	37	56	27
18	Nice	34	45	74	23

Competiciones que juega

Ligue 1

Pos	Equipos		Pts
1		Saint-Étienne	52
2		Olympique Marseille	45
3		Olympique Lyonnais	43
4		Nantes	43
5		Nîmes	43
6		Bastia	41
7		Lens	40
8		Metz	40
9		Monaco	40
10		Strasbourg	40
11		Stade de Reims	38
12		Girondins Bordeaux	37
13		Nice	36
14		PSG	36
15		Lille	35
16		Troyes	34
17		Sochaux	32
18		Stade Rennais	31
19		Angers SCO	28
20		Red Star	26

RIVALES EN Europa League

RIVALES EN Ligue 1

USO DE MEMORIA

7,056,264 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6715
Total Execution Time	0.6727

CADENA URL

/historico/Nantes/1975

GET DATOS

$_GET['/historico/Nantes/1975']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0143	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 = 'Nantes' AND l.year = 1975 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=1776 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=1776 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=1776 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255	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 = 9776
0.0144	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 = 10941
0.0128	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1776 AND type_rel = 2
0.0151	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1776 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0140	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 (1257869,3223,4729,9648,1263611) ORDER BY n.cover_points DESC, update_date DESC
0.0188	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 = '1776' ORDER BY l.year DESC,cat.coefficient DESC
0.0142	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 = '1776' AND l.year = 1975 ORDER BY l.year DESC,cat.coefficient DESC
0.0147	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 = '1776' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0134	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 = 10941 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 = 9776 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0139	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=1776 AND l.year in (1974,1975,1976) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (10941,10924,9777) 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.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 9777 AND teamId = 1776
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 10924 AND teamId = 1776
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 10941 AND teamId = 1776
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 FROM* `tables1975` 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 = 9776 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1776' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1776' and rp.type = 4
0.0130	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1776' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0138	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 events1975 e ON e.player_id = p.id AND e.league_id = 9776 WHERE rp.league_id = 9776 AND rp.teamId = 1776 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.0134	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 events1975 e ON e.player_id = p.id AND e.league_id = 9776 WHERE rp.league_id = 9776 AND rp.teamId = 1776 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138	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 events1975 e ON e.player_id = p.id AND e.league_id = 9776 WHERE rp.league_id = 9776 AND rp.teamId = 1776 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149	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 = 1776 AND l.year <= 1975 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0142	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* `tables1975` 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 = 9776 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144	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* `tables1974` 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 = 9777 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137	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* `tables1973` 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 = 9778 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139	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* `tables1972` 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 = 9779 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* `tables1971` 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 = 9780 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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* `tables1970` 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 = 9781 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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* `tables1969` 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 = 9782 AND t.round = 34 ORDER BY team.conference 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* `tables1968` 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 = 9783 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* `tables1967` 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 = 9784 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* `tables1966` 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 = 9785 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* `tables1965` 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 = 9786 AND t.round = 34 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* `tables1964` 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 = 9787 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 = 9776 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

Resultados de Fútbol

Nantes

Nantes

Selecciona un equipo

Competiciones que juega

Ligue 1

RIVALES EN Europa League

RIVALES EN Ligue 1