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

Saint-Pryve

Temporada 2023/2024

TEMPORADA 2023/2024

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	La Roche VF	24	34	18	42
2	Paris	24	36	23	42
3	FC Libourne	24	40	28	39
4	Angouleme	24	31	27	37
5	Blois	24	37	30	37
6	Bergerac	24	33	28	36
7	Bourges Foot	24	29	37	34
8	Herbiers	24	31	26	33
9	Saint-Pryve	23	26	25	32
10	Saumur	24	30	33	28
11	Romorantin	24	28	37	27
12	Avoine OCC	23	22	31	25
13	Trelissac	24	24	35	21
14	Angers	24	17	40	13

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 3
Equipo		PJ	GF	GC	Puntos
1	Sète	21	33	15	49
2	Blois	20	24	20	38
3	Herbiers	20	29	19	35
4	Bergerac	20	21	15	33
5	Colomiers	20	28	19	31
6	Bourges Foot	21	25	21	31
7	Saint-Pryve	21	25	26	31
8	Angouleme	21	32	26	30
9	Nantes II	21	23	19	28
10	Romorantin	21	25	20	25
11	Andrézieux	21	26	25	23
12	Trelissac	21	18	22	22
13	Montpellier	21	25	38	22
14	Chamalières	19	18	25	21
15	Saint-Étien	21	19	32	18
16	Stade	21	18	47	9

TEMPORADA 2018/2019

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Le Puy	30	34	19	52
2	Herbiers	30	41	27	50
3	Andrézieux	30	39	33	48
4	Yzeure	30	32	29	47
5	Sète	30	37	28	46
6	Blois	30	43	39	45
7	Saint-Pryve	30	33	27	44
8	Bergerac	30	37	33	42
9	Saint-Étien	30	41	36	41
10	Colomiers	30	31	32	40
11	Stade	30	27	34	38
12	Romorantin	30	28	25	37
13	Trelissac	30	28	31	37
14	Nîmes II	30	26	41	33
15	Girondins	30	21	38	26
16	Stade	30	26	52	25

TEMPORADA 2017/2018

NATIONAL 2 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Le Mans	30	59	27	60
2	Stade	30	50	32	57
3	Saint-Malo	30	44	34	48
4	Lorient II	30	31	24	45
5	Romorantin	30	45	40	41
6	Saint-Pryve	30	29	31	41
7	Chartres	30	49	42	39
8	Boulogne-Bil	30	45	55	38
9	Le Havre II	30	43	55	38
10	Granville	30	38	36	37
11	Mantes	30	32	39	37
12	Limoges	30	31	38	37
13	Vitré	30	43	44	36
14	Trelissac	30	26	43	33
15	Stade	30	33	42	32
16	Fontenay	30	25	41	25

TEMPORADA 2016/2017

NATIONAL 3 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Saint-Pryve	26	54	24	55
2	Le Mans	26	47	23	51
3	Avoine OCC	26	33	25	46
4	Oissel	26	44	36	42
5	Tours II	26	49	42	40
6	Aubervillier	26	39	35	37
7	Caen II	26	40	46	36
8	Blois	26	38	35	35
9	Evreux 27	26	23	35	29
10	Drouais	26	28	42	29
11	Bourges 18	26	31	39	27
12	Avranches	26	36	49	25
13	QRM II	26	26	39	25
14	UJA Maccabi	26	26	44	24

TEMPORADA 2015/2016

NATIONAL 3 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Chartres	26	50	19	58
2	Avoine OCC	26	39	26	48
3	Le Mans	26	30	26	43
4	USSA Vertou	26	28	31	40
5	Angers	26	47	33	35
6	La Roche VF	26	33	44	34
7	Chatelleraul	26	34	34	33
8	Tours II	26	47	49	33
9	Bourges 18	26	28	30	33
10	Saint-Pryve	26	34	35	32
11	Bressuire	26	30	33	32
12	Poiré-sur-V	26	29	37	28
13	Châteauroux	26	32	50	27
14	Challans	26	21	35	21

TEMPORADA 2014/2015

NATIONAL 3 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Cholet	26	34	21	45
2	Saint-Pryve	26	40	25	41
3	La Roche VF	26	38	31	39
4	Le Mans	26	34	28	39
5	Angers	26	34	34	38
6	Bressuire	26	28	29	38
7	Tours II	26	38	32	36
8	Avoine OCC	26	26	31	36
9	Châteauroux	26	42	35	35
10	Poiré	26	31	26	34
11	USSA Vertou	26	25	35	34
12	Chatelleraul	26	34	46	31
13	Chauray	26	30	44	30
14	Thouars	26	27	44	23

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 3
Equipo		PJ	GF	GC	Puntos
1	Saint-Pryve	26	43	29	48
2	Vesoul	26	37	25	48
3	Dijon II	26	54	36	46
4	Saint-Louis	26	37	29	41
5	Colmar II	26	46	37	39
6	Illzach	26	38	46	39
7	Troyes II	26	50	40	38
8	Schiltigheim	26	41	43	36
9	Thaon	26	34	38	36
10	Belfort Sud	26	47	53	34
11	Épernay	26	43	41	30
12	Lunéville	26	32	42	29
13	Jarville	26	39	47	24
14	Forbach	26	20	55	15

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 2 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Poiré-sur-V	32	47	24	59
2	Cherbourg	32	42	37	49
3	Vitréenne	32	39	26	48
4	Herbiers	32	48	36	46
5	Carquefou	32	42	36	46
6	Yzeure	32	30	26	44
7	Moulins	32	42	43	44
8	Le Mans II	32	44	38	42
9	Avranches	32	32	31	42
10	V.Châtillon	32	36	39	42
11	Romorantin	32	43	44	41
12	Luçon	32	36	43	40
13	Lorient II	32	39	42	39
14	Fontenay	32	34	43	39
15	Caen II	32	40	55	38
16	Saint-Pryve	32	40	53	36
17	Stade	32	27	45	29

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 2008/2009

NATIONAL 3 GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Tours II	32	79	34	66
2	Herbiers	32	43	27	57
3	Niort II	32	56	41	54
4	Saumur	32	48	35	52
5	Cognac	31	45	41	51
6	Alençon	32	49	39	50
7	Poiré-sur-V	32	36	28	50
8	Saint-Pryve	32	57	45	45
9	Châteauroux	32	47	37	45
10	Blois	32	34	35	44
11	Arménienne	32	37	36	43
12	Auxerre III	31	40	44	38
13	Thouars	32	32	39	38
14	Choisy	32	39	64	32
15	Malesherbes	32	43	60	30
16	Buxerolles	32	43	76	30
17	Chartres	32	31	78	20

TEMPORADA 2007/2008

NATIONAL 3 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Luçon	30	46	16	65
2	Saint-Pryve	30	50	31	53
3	Saumur	30	52	36	51
4	Angers	30	38	32	48
5	Arménienne	30	45	33	47
6	Auxerre III	30	40	34	47
7	Châteauroux	30	38	25	46
8	Herbiers	30	43	28	45
9	Thouars	30	31	26	42
10	Malesherbes	30	34	41	38
11	Blois	30	33	31	36
12	Nivernais	30	29	39	35
13	Flèche	30	26	30	32
14	Créteil II	30	32	41	29
15	Chatelleraul	30	26	60	22
16	Écommoy FC	30	17	77	14

Competiciones que juega

Grupo 2

National 2 Grupo 2

Pos	Equipos		Pts
1		La Roche VF	42
2		Paris 13 Atletico	42
3		FC Libourne	39
4		Angouleme	37
5		Blois	37
6		Bergerac	36
7		Bourges Foot 18	34
8		Les Herbiers	33
9		Saint-Pryve	32
10		Saumur	28
11		Romorantin	27
12		Avoine OCC	25
13		Trelissac	21
14		Angers SCO II	13

	Ascenso : La Roche VF
	Descenso : Saumur, Romorantin, Avoine OCC, Trelissac, Angers SCO II

RIVALES EN National 2

USO DE MEMORIA

6,919,816 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7260
Total Execution Time	0.7272

CADENA URL

/historico/St-Pryve-St-Hi

GET DATOS

$_GET['/historico/St-Pryve-St-Hi']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0155	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 = 'St-Pryve-St-Hi' 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.0145	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=6803 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=6803 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=6803 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6803 AND type_rel = 2
0.0149	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6803 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148	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 (770851,779765,779360) ORDER BY n.cover_points DESC, update_date DESC
0.0156	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 = '6803' ORDER BY l.year DESC,cat.coefficient DESC
0.0157	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 = '6803' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0173	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 = '6803' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0176	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=6803 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146	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 (72963,71432,70208) 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.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 72963 AND teamId = 6803
0.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 70208 AND teamId = 6803
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6803
0.0146	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 = '6803' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6803' and rp.type = 4
0.0149	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 = '6803' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0177	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 = 72963 WHERE rp.league_id = 72963 AND rp.teamId = 6803 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.0206	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 = 72963 WHERE rp.league_id = 72963 AND rp.teamId = 6803 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0167	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 = 72963 WHERE rp.league_id = 72963 AND rp.teamId = 6803 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155	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 = 6803 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0163	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 = 72963 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.0148	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.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* `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.0151	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.0155	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 = 50569 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.0156	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 = 44573 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 39111 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160	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 = 34008 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160	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 = 15897 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158	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 = 4306 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161	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.0161	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 = 2103 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158	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.0160	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 = 19926 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161	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.0158	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 = 20018 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157	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 = 20025 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Saint-Pryve

Saint-Pryve

Selecciona un equipo

Competiciones que juega

National 2 Grupo 2

RIVALES EN National 2