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

Stade Poitevin

Temporada 2023/2024

TEMPORADA 2023/2024

NATIONAL 3 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Montlouis	24	44	15	58
2	Stade	24	61	22	56
3	Tours	24	49	26	43
4	Tourangeau	24	43	33	43
5	Vierzon	24	40	35	34
6	Bourges	24	37	34	34
7	Panazol	24	40	41	33
8	Chatelleraul	24	35	39	33
9	Châteauroux	24	33	31	32
10	Chauvigny	24	29	44	27
11	Châteauneuf	24	34	36	26
12	Vineuil SF	24	25	40	23
13	Bourges Foot	24	29	56	18
14	Chambray FC	24	21	68	10

TEMPORADA 2022/2023

NATIONAL 3 GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	FC Libourne	26	52	15	57
2	Anglet	26	40	24	53
3	Chauvigny	26	47	32	50
4	Pau FC II	25	49	25	45
5	Chatelleraul	26	42	41	40
6	Niort II	26	49	39	39
7	Lège-Cap-Fe	26	33	39	38
8	Bayonne	26	39	32	37
9	Girondins	26	36	30	36
10	Stade	25	33	27	36
11	Portes Entre	26	28	43	29
12	CA Neuville	26	32	50	21
13	Guéret	26	22	61	14
14	Stade	26	19	63	7

TEMPORADA 2021/2022

NATIONAL 3 GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Stade	26	57	28	62
2	Bayonne	26	45	36	47
3	Anglet	26	37	27	45
4	Girondins	26	41	30	42
5	Stade	26	52	33	41
6	Chauvigny	26	36	31	38
7	FC Libourne	26	37	40	37
8	CA Neuville	26	44	40	35
9	Niort II	26	35	42	32
10	Lège-Cap-Fe	26	38	35	31
11	Chatelleraul	26	27	40	26
12	Bressuire	26	34	52	25
13	Cognac	26	33	63	23
14	Tartas	26	44	63	21

TEMPORADA 2020/2021

NATIONAL 3 GRUPO 10
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2019/2020

NATIONAL 3 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Stade	18	36	30	32
2	Bressuire	17	27	15	28
3	Lège-Cap-Fe	18	29	20	28
4	Chauvigny	17	31	23	28
5	Bayonne	17	23	15	28
6	Stade	18	29	21	25
7	Girondins	18	23	24	23
8	Cognac	17	20	27	22
9	Anglet	17	22	26	21
10	Chatelleraul	18	24	30	20
11	Niort II	17	21	24	19
12	Pau FC II	17	20	25	18
13	Mérignac-Ar	18	19	25	17
14	Bassin	17	20	39	11

TEMPORADA 2018/2019

NATIONAL 3 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Angouleme	26	56	24	61
2	Niort II	26	59	40	47
3	Lège-Cap-Fe	26	41	29	47
4	Bressuire	26	41	31	43
5	Anglet	26	32	28	40
6	Mérignac-Ar	26	34	24	38
7	Bayonne II	26	32	26	38
8	Limoges	26	23	25	38
9	Stade	26	28	31	33
10	Chauvigny	26	25	29	33
11	Pau FC II	26	43	43	31
12	SAG Cestas	26	23	51	20
13	Montmorillon	26	17	41	17
14	Chauray	26	15	47	15

TEMPORADA 2017/2018

NATIONAL 3 GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Girondins	26	41	20	55
2	Bayonne	26	48	19	54
3	Niort II	26	55	32	46
4	Anglet	26	41	30	44
5	Angouleme	26	49	32	42
6	Mérignac-Ar	26	36	29	36
7	Bressuire	26	34	38	36
8	Pau FC II	26	33	40	36
9	Stade	26	38	32	34
10	Chauray	26	24	31	32
11	Lège-Cap-Fe	26	29	29	30
12	FC Libourne	26	31	47	23
13	Cozes	26	23	58	21
14	Feytiat	26	18	63	13

TEMPORADA 2013/2014

NATIONAL 3 GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Fleury-Merog	26	40	27	44
2	Tours II	26	37	26	43
3	Saint-Pryve	26	43	29	42
4	Châteauroux	26	44	34	42
5	Poiré	26	33	27	40
6	Cholet	26	35	34	38
7	Chartres	26	42	37	36
8	Geneviève	26	27	27	36
9	La Roche VF	26	35	41	35
10	Chatelleraul	26	41	43	34
11	Thouars	26	27	43	31
12	Angers	26	38	39	30
13	Saumur	26	21	29	29
14	Stade	26	21	48	14

TEMPORADA 2012/2013

NATIONAL 3 GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Nantes II	26	53	20	55
2	Angers	26	49	29	51
3	Châteauroux	26	49	36	47
4	Sablé	26	44	35	39
5	Chauray	26	30	24	39
6	Cholet	26	41	27	37
7	Poiré	26	28	24	35
8	Limoges	26	31	42	33
9	Thouars	26	30	32	31
10	Stade	26	22	31	31
11	Chatelleraul	26	31	54	30
12	Avoine	26	30	43	25
13	La Suze	26	40	57	20
14	Flèche	26	23	47	17

TEMPORADA 2011/2012

NATIONAL 3 GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Chartres	9	23	7	23
2	Vertou	9	16	10	22
3	Cholet	9	18	7	20
4	Angers	9	19	10	18
5	Trelissac	9	12	8	17
6	Nantes II	9	12	8	14
7	Chatelleraul	9	15	12	13
8	Stade	9	16	17	13
9	Tours II	9	15	18	10
10	Saint-Pryve	9	13	16	10
11	Poiré	9	8	12	9
12	Herbiers	9	7	12	9
13	Saint-Jean-L	9	6	17	8
14	Limoges	9	13	18	7
15	Thouars	9	8	18	5
16	Cognac	9	10	21	5

TEMPORADA 2010/2011

NATIONAL 3 GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Saumur	28	55	20	60
2	Nantes II	28	50	28	54
3	Angers	28	51	30	54
4	Tours II	28	32	28	41
5	Stade	28	36	36	38
6	Cholet	28	38	40	37
7	Vierzon	28	34	55	36
8	Châteauroux	28	32	28	35
9	Cognac	28	37	41	35
10	Chatelleraul	28	40	50	35
11	Sablé	28	35	33	34
12	USSA Vertou	28	33	33	34
13	Bourges 18	28	33	33	33
14	Chataignerai	28	37	45	32
15	Bonchamp	28	23	66	10
16	Montluçon	0	0	0	0

TEMPORADA 2009/2010

NATIONAL 3 GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Poiré-sur-V	30	52	27	63
2	Saint-Pryve	30	54	34	61
3	Saumur	30	48	37	46
4	Angers	30	51	44	44
5	Châteauroux	30	40	34	43
6	Nantes II	30	40	35	43
7	Cholet	30	39	36	40
8	Stade	30	36	36	39
9	Tours II	30	46	41	38
10	Geneviève	30	32	36	38
11	Chatelleraul	30	38	47	37
12	Bourges 18	30	30	39	36
13	Niort II	30	34	38	35
14	Thouars	30	39	53	31
15	Blois	30	31	49	29
16	Ararat Issy	30	27	51	28

TEMPORADA 2005/2006

NATIONAL 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Yzeure	34	56	35	61
2	Rodez	34	58	46	59
3	Saint-Étien	34	54	36	57
4	Toulouse II	34	48	30	57
5	Le Mans II	34	54	41	55
6	Brive	34	40	30	47
7	Montluçon	34	37	43	47
8	Albi	34	49	41	45
9	Orléans	33	34	34	45
10	Aurillac	33	37	40	45
11	Nantes II	34	46	48	43
12	Luzenac	34	33	42	43
13	Girondins	34	31	40	40
14	Balma	34	34	64	40
15	Anglet	34	40	38	39
16	Andrézieux	34	30	35	39
17	Stade	34	29	45	35
18	Blois	34	38	60	28

TEMPORADA 1997/1998

NATIONAL
Equipo		PJ	GF	GC	Puntos
1	Ajaccio	34	64	22	77
2	CS Sedan	34	65	26	75
3	Creteil	34	46	21	72
4	Istres	34	61	43	58
5	Gazélec	34	52	33	57
6	Paris FC	34	46	33	53
7	Stade	34	43	48	45
8	Tours	34	39	39	43
9	Racing	34	33	38	43
10	Maur Lusi	34	33	39	43
11	Angouleme	34	35	43	39
12	Noisy-le-Sec	34	30	45	39
13	St-Denis	34	32	42	38
14	Thouars	34	37	42	35
15	Raon-l'Etape	34	27	42	32
16	Épinal	34	24	54	31
17	Angers SCO	34	25	51	26
18	Fréjus	34	35	66	25

TEMPORADA 1995/1996

LIGUE 2
Equipo		PJ	GF	GC	Puntos
1	Caen	42	59	34	81
2	Olympique	42	69	35	80
3	Nancy	42	56	23	76
4	Stade	42	52	47	69
5	Toulouse	42	40	34	63
6	Le Mans	42	37	36	62
7	Red Star	42	56	38	61
8	Perpignan	42	44	53	61
9	Chateauroux	42	40	35	60
10	Sochaux	42	49	40	59
11	Louhans	42	57	49	58
12	Lorient	42	44	46	58
13	Amiens SC	42	41	49	52
14	FC Mulhouse	42	44	45	51
15	Valence	42	34	42	51
16	Niort	42	48	50	50
17	Épinal	42	42	46	48
18	Charleville	42	34	54	48
19	Stade	42	36	48	46
20	Dunkerque	42	30	43	43
21	Angers SCO	42	31	53	37
22	Olympique	42	29	72	25

Competiciones que juega

Grupo 3

National 3 Grupo 3

Pos	Equipos		Pts
1		Montlouis	58
2		Stade Poitevin	56
3		Tours	43
4		FCO Tourangeau	43
5		Vierzon	34
6		ES Bourges Moulon	34
7		Panazol	33
8		Chatellerault	33
9		Châteauroux II	32
10		Chauvigny	27
11		Châteauneuf-sur-Loire	26
12		Vineuil SF	23
13		Bourges Foot 18 II	18
14		Chambray FC	10

	Ascenso : Montlouis
	Descenso : Vineuil SF, Bourges Foot 18 II, Chambray FC

RIVALES EN Copa de Francia

RIVALES EN National 3

USO DE MEMORIA

6,708,680 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.5422
Total Execution Time	0.5436

CADENA URL

/historico/Poitiers

GET DATOS

$_GET['/historico/Poitiers']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0114	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 = 'Poitiers' AND l.year = 2024 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.0105	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=6795 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6795 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=6795 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0213	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 = 73238
0.0111	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 = 74470
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6795 AND type_rel = 2
0.0110	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 = '6795' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0111	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 = '6795' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0115	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 = 74470 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106	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 = 73238 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110	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=6795 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106	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,73238) 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.0108	SELECT count(id) as num_players from rel_players WHERE league_id = 73238 AND teamId = 6795
0.0113	SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 6795
0.0123	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2024` 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 = 73238 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0115	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 = '6795' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0108	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6795' and rp.type = 4
0.0110	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 = '6795' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0129	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 = 73238 WHERE rp.league_id = 73238 AND rp.teamId = 6795 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.0121	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 = 73238 WHERE rp.league_id = 73238 AND rp.teamId = 6795 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0123	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 = 73238 WHERE rp.league_id = 73238 AND rp.teamId = 6795 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0116	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 = 6795 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0109	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* `tables2024` 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 = 73238 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 68302 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 63491 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107	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 = 57750 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 50954 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 44560 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 39136 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 2546 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 2107 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 1689 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 20001 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 20009 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 19945 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115	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* `tables1998` 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 = 16462 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123	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* `tables1996` 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 = 22398 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116	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 = 73238 ORDER BY nameShow LIMIT 100

Stade Poitevin

Stade Poitevin

Selecciona un equipo

Competiciones que juega

National 3 Grupo 3

RIVALES EN Copa de Francia

RIVALES EN National 3