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

Poissy

Temporada 2022/2023

TEMPORADA 2022/2023

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rouen 1899	30	58	29	69
2	Chambly	30	52	25	57
3	Racing Paris	29	64	29	56
4	Voltigeurs	30	33	29	48
5	Saint-Malo	30	41	37	43
6	Poissy	29	43	37	41
7	Blois	30	46	42	39
8	Beauvais	30	41	37	39
9	Saint-Pryve	29	28	31	39
10	Granville	30	42	47	37
11	Guingamp II	29	34	47	34
12	Evreux 27	29	46	56	31
13	Stade	29	37	63	25
14	Vannes	30	47	58	24
15	Caen II	30	37	62	24
16	Chartres	30	33	53	23

TEMPORADA 2021/2022

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Versailles	30	47	16	64
2	Lorient II	30	49	22	56
3	Chartres	30	53	49	50
4	Rouen 1899	30	38	28	47
5	Blois	30	52	56	43
6	Saint-Pryve	30	37	38	42
7	Vannes	30	42	43	39
8	Voltigeurs	30	29	33	38
9	Granville	30	38	32	38
10	Guingamp II	30	41	48	38
11	Saint-Malo	30	33	38	36
12	Poissy	30	33	40	36
13	Romorantin	30	37	40	35
14	Caen II	30	29	41	35
15	Plabennec	30	29	45	27
16	Vitré	30	35	53	25

TEMPORADA 2020/2021

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Saint-Pryve	8	12	3	20
2	Voltigeurs	9	12	8	16
3	Geneviève	9	10	6	16
4	Caen II	9	10	7	15
5	Granville	9	8	6	15
6	Fleury-Merog	9	7	6	13
7	Chartres	9	13	11	12
8	Plabennec	9	11	13	12
9	Rouen 1899	8	4	4	10
10	Versailles	9	11	13	10
11	Guingamp II	9	7	9	9
12	Lorient II	9	5	8	9
13	Vannes	8	9	10	8
14	Saint-Malo	9	8	10	8
15	Blois	8	11	15	8
16	Poissy	9	6	15	2

TEMPORADA 2019/2020

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Stade	21	38	22	46
2	Chartres	21	42	19	44
3	Rouen 1899	20	23	15	39
4	Granville	21	22	21	38
5	Vannes	21	35	24	35
6	Paris	21	32	29	30
7	Lorient II	21	19	19	30
8	Fleury-Merog	21	24	23	29
9	Saint-Malo	20	23	22	28
10	Angers	21	21	19	27
11	Guingamp II	21	30	34	23
12	Sannois	21	20	24	23
13	Poissy	21	28	32	22
14	Vitré	21	19	26	18
15	Oissel	21	18	38	13
16	Mantes	21	7	34	6

TEMPORADA 2018/2019

NATIONAL 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Nantes II	30	45	24	55
2	Bastia-Borgo	30	57	35	54
3	Chartres	30	50	38	52
4	Stade	30	53	33	50
5	Lorient II	30	38	24	47
6	Oissel	30	39	37	41
7	Vannes	30	47	49	40
8	Poissy	30	35	36	39
9	Mantes	30	29	39	39
10	Granville	30	47	58	38
11	Saint-Malo	30	40	42	37
12	Vitré	30	34	45	36
13	PSG II	30	39	47	33
14	Furiani	30	31	43	33
15	Boulogne-Bil	30	36	51	29
16	Le Havre II	30	29	48	29

TEMPORADA 2017/2018

NATIONAL 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Drancy	30	41	17	59
2	CS Sedan	30	52	30	56
3	Geneviève	30	41	31	54
4	Fleury-Merog	30	45	34	51
5	Arras	30	46	37	48
6	Maur	30	37	33	46
7	Bastia-Borgo	30	33	24	44
8	Poissy	30	34	36	40
9	Iris Club C.	30	26	32	36
10	Lille II	30	39	48	34
11	Lens II	30	46	48	34
12	Stade Reims	30	41	43	32
13	Furiani	30	31	48	32
14	Amiens AC	30	18	28	30
15	V.Châtillon	30	28	50	29
16	Beauvais	30	31	50	24

TEMPORADA 2016/2017

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sannois	30	52	20	58
2	Fleury-Merog	30	36	22	57
3	Maur	30	36	20	54
4	Boulogne-Bil	30	48	42	49
5	Arras	30	47	34	46
6	Lens II	30	36	37	44
7	Drancy	30	28	22	39
8	Lille II	30	36	35	39
9	Iris Club C.	30	34	36	38
10	V.Châtillon	30	37	40	36
11	Le Havre II	30	36	43	36
12	Amiens AC	30	30	40	33
13	Poissy	30	37	44	32
14	Calais	30	38	57	31
15	Wasquehal	30	23	36	29
16	Dieppe	30	21	47	28

TEMPORADA 2015/2016

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	QRM	30	50	22	62
2	Iris Club C.	30	55	37	55
3	Poissy	30	55	42	52
4	Sannois	30	46	39	46
5	Wasquehal	30	44	41	46
6	Arras	30	43	43	41
7	Amiens AC	30	35	34	40
8	PSG II	30	35	40	40
9	Mantes	30	31	38	39
10	Boulogne-Bil	30	43	40	38
11	Calais	30	32	37	38
12	Dieppe	30	31	24	37
13	Troyes II	30	41	47	36
14	Lens II	30	37	45	36
15	Aubervillier	30	27	47	24
16	Roye-Noyon	30	38	67	22

TEMPORADA 2014/2015

NATIONAL 3 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Boulogne-Bil	26	51	39	47
2	Poissy	26	36	25	46
3	Chartres	26	36	20	45
4	Le Havre II	26	40	23	42
5	Gonfreville	26	33	28	41
6	Geneviève	26	26	27	37
7	Oissel	26	38	40	34
8	Bastia II	26	37	39	33
9	Caen II	26	37	35	32
10	Saint-Ouen-l	26	33	34	30
11	Amiens	26	32	37	30
12	QRM II	26	41	47	29
13	Furiani	26	25	44	22
14	Evry	26	26	53	17

TEMPORADA 2013/2014

NATIONAL 3 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Iris Club C.	28	63	13	69
2	CS Sedan	26	52	19	58
3	Poissy	28	37	27	45
4	Feignies	27	42	33	36
5	Wasquehal	27	36	37	35
6	Olympique	28	26	37	35
7	Sénart	28	36	41	33
8	Valenciennes	28	33	39	33
9	Evry	27	35	44	33
10	Paris II	27	41	44	32
11	Aulnoye	28	38	62	32
12	Épernay	27	18	32	29
13	Stade Reims	27	36	46	26
14	Compiègne	28	16	61	12

TEMPORADA 2012/2013

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dunkerque	34	47	22	69
2	Chambly	34	39	14	65
3	Beauvais	34	42	38	56
4	Roye-Noyon	34	39	35	50
5	Amnéville	34	50	42	47
6	Lille II	34	39	43	47
7	Aubervillier	34	35	44	47
8	FC Calvi	34	60	45	46
9	Ivry	34	33	31	46
10	Mantes	34	38	40	44
11	Villemomble	34	37	39	44
12	Amiens AC	34	38	44	44
13	Drancy	34	30	28	43
14	Lens II	34	42	46	43
15	Poissy	34	40	45	40
16	Compiègne	34	30	42	33
17	Metz II	34	33	47	32
18	Valenciennes	34	29	56	25

TEMPORADA 2011/2012

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CA Bastia	34	53	33	67
2	Aubervillier	34	53	34	64
3	Dunkerque	34	50	31	63
4	Auxerre II	34	60	36	62
5	Drancy	34	35	32	55
6	Lens II	34	48	39	50
7	FC Calvi	34	58	51	50
8	Amiens AC	34	41	40	50
9	Ivry	34	50	40	49
10	Lille II	34	44	42	48
11	Compiègne	34	44	52	43
12	Poissy	34	43	47	38
13	Valenciennes	34	44	52	38
14	PSG II	34	32	38	35
15	Alfortville	34	36	55	32
16	Sénart	34	22	45	31
17	Villemomble	34	24	47	30
18	Avion	34	34	57	25

TEMPORADA 2010/2011

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	QRM	32	58	33	63
2	CA Bastia	32	44	27	60
3	Red Star	32	37	21	60
4	Metz II	32	42	32	53
5	Poissy	32	45	46	45
6	Avion	32	40	43	41
7	Villemomble	32	30	34	41
8	Drancy	32	25	23	40
9	Compiègne	32	28	38	40
10	Le Havre II	32	38	35	39
11	Sénart	32	22	28	39
12	Lens II	32	41	44	38
13	Sannois	32	33	36	38
14	Aubervillier	32	40	45	38
15	Mantes	32	35	43	36
16	Lille II	32	37	45	32
17	Noisy-le-Sec	32	30	52	27

TEMPORADA 2009/2010

NATIONAL 3 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Calais	30	46	21	56
2	Oissel	30	41	35	52
3	Evreux 27	31	32	33	50
4	Poissy	30	48	35	49
5	Dieppe	30	43	36	44
6	Hazebrouck	31	41	36	44
7	Saint-Omer	30	35	34	44
8	Wasquehal	30	32	28	41
9	Bastia II	30	40	33	40
10	Gravelines	30	36	36	40
11	Amiens AC	30	39	38	39
12	Drouais	30	31	30	38
13	Pacy	29	30	32	38
14	Amiens	30	25	38	30
15	Gonfreville	30	25	49	29
16	Entente	29	25	55	19

TEMPORADA 2008/2009

NATIONAL 3 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Marck	32	45	26	59
2	Mantes	32	43	28	56
3	Hazebrouck	32	52	37	54
4	Poissy	32	40	30	51
5	Amiens AC	32	53	36	50
6	Oissel	32	40	35	50
7	Dieppe	32	45	42	47
8	Créteil II	32	46	43	46
9	Entente	32	29	25	44
10	Wasquehal	32	38	32	42
11	Gravelines	32	28	34	42
12	Amiens	32	44	38	41
13	Drouais	31	23	31	41
14	Pacy	32	38	47	39
15	Trouville	31	45	54	31
16	Armentières	32	23	38	30
17	AS Ifs	32	30	86	9

TEMPORADA 2007/2008

NATIONAL 2 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Girondins	34	56	28	63
2	Bayonne	34	47	30	58
3	Fontenay	34	40	33	54
4	Moulins	34	44	34	53
5	Orléans	34	44	35	50
6	Le Mans II	34	55	49	50
7	Anglet	34	42	37	48
8	PSG II	34	28	26	48
9	Geneviève	34	43	50	46
10	Chatelleraul	33	43	49	45
11	Montluçon	34	44	37	42
12	Stade	34	40	48	41
13	Yzeure	33	35	44	41
14	Sénart	34	43	54	38
15	Aurillac	34	34	46	35
16	Nantes II	34	27	41	35
17	Sables	34	29	45	34
18	Poissy	34	40	48	32

TEMPORADA 2006/2007

NATIONAL 2 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Villemomble	34	41	29	63
2	Stade	34	57	36	57
3	Auxerre II	34	48	37	54
4	Guingamp II	34	41	38	52
5	FUSC Bois G.	34	38	27	51
6	Poissy	34	47	43	50
7	Rouen 1899	34	32	29	50
8	Geneviève	34	48	38	49
9	Pacy	34	35	28	49
10	Red Star	34	39	33	47
11	Sénart	34	34	29	45
12	QRM	34	47	48	41
13	PSG II	33	40	42	41
14	Vitré	33	35	37	39
15	Plabennec	34	30	38	37
16	Pontivy	34	35	64	34
17	Dieppe	33	27	47	28
18	Concarneau	33	25	56	21

TEMPORADA 2005/2006

NATIONAL 2 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Paris FC	34	43	23	65
2	Stade	34	53	34	60
3	Guingamp II	34	46	30	54
4	Rouen 1899	33	44	33	52
5	Vitré	33	41	27	50
6	Villemomble	34	49	38	49
7	FUSC Bois G.	34	35	28	48
8	PSG II	33	46	43	48
9	Poissy	34	44	30	46
10	Sénart	34	36	36	43
11	Dieppe	33	28	38	41
12	Pontivy	34	39	51	41
13	Pacy	34	31	45	41
14	QRM	34	35	43	39
15	Geneviève	34	37	44	37
16	Noisy-le-Sec	34	22	29	34
17	Mantes	34	24	46	28
18	Mondeville	34	25	60	23

Competiciones que juega

National 2 Grupo 1

Pos	Equipos		Pts
1		FC Rouen 1899	69
2		Chambly	57
3		Racing Paris	56
4		Voltigeurs Châteaubriant	48
5		Saint-Malo	43
6		Poissy	41
7		Blois	39
8		Beauvais Oise	39
9		Saint-Pryve	39
10		Granville	37
11		Guingamp II	34
12		Evreux 27	31
13		Stade Rennais II	25
14		Vannes	24
15		Caen II	24
16		Chartres	23

	Ascenso : FC Rouen 1899
	: Chambly, Racing Paris, Voltigeurs Châteaubriant, Saint-Malo, Poissy, Blois, Beauvais Oise, Saint-Pryve, Granville, Guingamp II
	Descenso : Evreux 27, Stade Rennais II, Vannes, Caen II, Chartres

RIVALES EN Copa de Francia

RIVALES EN National 2

USO DE MEMORIA

7,471,400 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1001
Total Execution Time	0.1013

CADENA URL

/historico/Poissy

GET DATOS

$_GET['/historico/Poissy']

POST DATOS

No hay datos POST existentes

CONSULTAS (27)

0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6666 AND type_rel = 2
0.0024	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 = '6666' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023	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 = '6666' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 68291 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026	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=6666 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (70208,68291,67320) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 68291 AND teamId = 6666
0.0032	SELECT count(id) as num_players from rel_players WHERE league_id = 70208 AND teamId = 6666
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 6666
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 68291 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0032	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 events2023 e ON e.player_id = p.id AND e.league_id = 68291 WHERE rp.league_id = 68291 AND rp.teamId = 6666 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.0028	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 events2023 e ON e.player_id = p.id AND e.league_id = 68291 WHERE rp.league_id = 68291 AND rp.teamId = 6666 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	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 events2023 e ON e.player_id = p.id AND e.league_id = 68291 WHERE rp.league_id = 68291 AND rp.teamId = 6666 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 6666 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023	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 = 68291 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 63479 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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 = 57113 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 50568 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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 = 44574 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 39110 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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* `tables2017` 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 = 33906 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 15745 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 4307 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 2541 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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 = 1679 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 19923 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 20003 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Poissy

Poissy

Selecciona un equipo

Competiciones que juega

National 2 Grupo 1

RIVALES EN Copa de Francia

RIVALES EN National 2