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

Cholet

Entrenador: David Augereau

Temporada 2023/2024

TEMPORADA 2023/2024

NATIONAL
Equipo		PJ	GF	GC	Puntos
1	Red Star	30	49	27	62
2	Martigues	31	39	25	53
3	Niort	31	51	37	52
4	Le Mans	31	44	38	48
5	Nancy	31	46	41	47
6	Dijon FCO	31	42	39	47
7	Rouen 1899	31	37	28	46
8	Sochaux	31	48	39	46
9	Versailles	31	38	30	43
10	Orléans	31	33	35	39
11	Chateauroux	31	36	41	36
12	Avranches	31	34	53	35
13	Villefranche	31	32	40	35
14	Nîmes	30	29	39	35
15	GOAL FC	31	40	44	34
16	Marignane	31	33	46	34
17	Épinal	31	36	45	32
18	Cholet	31	29	49	28

TEMPORADA 2022/2023

NATIONAL
Equipo		PJ	GF	GC	Puntos
1	Concarneau	34	60	37	62
2	Dunkerque	34	50	32	62
3	Red Star	34	51	30	60
4	Martigues	34	54	40	60
5	Versailles	34	41	41	51
6	Villefranche	34	49	40	46
7	CS Sedan	34	41	47	46
8	Cholet	34	38	41	45
9	Avranches	34	44	46	45
10	Orléans	34	38	37	44
11	Chateauroux	34	41	46	44
12	Le Mans	34	50	42	43
13	Nancy	34	37	42	41
14	Bourg-Péron	34	42	46	40
15	Stade	34	36	46	38
16	Le Puy	34	34	50	35
17	Paris	34	28	42	31
18	Bastia-Borgo	34	32	61	26

TEMPORADA 2021/2022

NATIONAL
Equipo		PJ	GF	GC	Puntos
1	Stade	34	50	31	67
2	Annecy	34	55	30	66
3	Villefranche	34	47	29	65
4	Concarneau	34	48	31	58
5	Chateauroux	34	41	28	55
6	Bourg-Péron	34	55	37	54
7	Stade	34	47	35	52
8	CS Sedan	34	37	37	50
9	Orléans	34	37	35	47
10	Le Mans	34	35	35	46
11	Red Star	34	55	50	44
12	Avranches	34	37	58	42
13	Cholet	34	49	62	41
14	Sète	34	35	42	37
15	Bastia-Borgo	34	40	58	31
16	Chambly	34	35	62	29
17	US Boulogne	34	28	48	26
18	Creteil	34	35	58	26

TEMPORADA 2020/2021

NATIONAL
Equipo		PJ	GF	GC	Puntos
1	Bastia	34	57	28	66
2	QRM	34	48	31	58
3	Villefranche	34	40	29	55
4	Le Mans	34	46	36	52
5	Concarneau	34	38	32	48
6	Red Star	34	39	33	47
7	Orléans	34	49	41	47
8	Sète	34	31	32	43
9	Cholet	34	36	48	43
10	Stade	34	32	33	43
11	Bourg-Péron	34	29	33	43
12	Stade	34	33	32	42
13	Avranches	34	36	42	41
14	Annecy	34	42	47	40
15	US Boulogne	34	29	38	38
16	Bastia-Borgo	34	37	49	35
17	Creteil	34	29	48	35
18	Lyon-Duchèr	34	33	52	31

TEMPORADA 2019/2020

NATIONAL
Equipo		PJ	GF	GC	Puntos
1	Pau FC	25	43	20	48
2	Dunkerque	25	42	26	47
3	US Boulogne	25	32	17	46
4	Red Star	25	30	22	42
5	Bourg-Péron	25	38	30	42
6	Avranches	24	30	26	42
7	Villefranche	25	34	24	41
8	Lyon-Duchèr	25	37	32	40
9	Creteil	25	33	27	35
10	Stade	25	26	24	35
11	Concarneau	25	21	25	31
12	Cholet	25	32	40	28
13	Bastia-Borgo	23	22	32	24
14	QRM	24	26	34	24
15	Le Puy	25	27	40	23
16	Béziers	25	26	43	23
17	Gazélec	25	15	35	19
18	Sporting	25	17	34	13

TEMPORADA 2018/2019

NATIONAL
Equipo		PJ	GF	GC	Puntos
1	Rodez	34	54	21	76
2	Chambly	34	48	31	62
3	Le Mans	34	38	29	59
4	Stade	34	51	43	54
5	Lyon-Duchèr	34	43	42	50
6	US Boulogne	34	38	33	49
7	Pau FC	34	45	35	48
8	Cholet	34	41	38	46
9	Avranches	34	37	40	45
10	QRM	34	37	37	45
11	Dunkerque	34	37	39	43
12	Villefranche	34	34	34	42
13	Concarneau	34	30	43	40
14	Tours	34	21	29	37
15	Bourg-Péron	34	32	42	36
16	Marignane	34	31	43	34
17	Sannois	34	27	46	29
18	Drancy	34	21	40	26

TEMPORADA 2017/2018

NATIONAL
Equipo		PJ	GF	GC	Puntos
1	Red Star	32	41	25	56
2	Béziers	32	41	29	52
3	Grenoble	32	33	23	51
4	Rodez	32	33	33	45
5	Avranches	32	39	42	43
6	Lyon-Duchèr	32	30	33	42
7	US Boulogne	32	36	34	42
8	Stade	32	37	36	42
9	Dunkerque	32	39	39	41
10	Concarneau	32	38	38	40
11	Chambly	32	36	32	40
12	Sannois	32	41	46	40
13	Pau FC	32	43	37	40
14	Cholet	32	49	53	39
15	Herbiers	32	37	45	39
16	Athlético	32	37	46	37
17	Creteil	32	29	48	26

TEMPORADA 2016/2017

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Stade	30	44	34	56
2	Cholet	30	46	32	52
3	Bergerac	30	35	34	49
4	Granville	30	40	41	47
5	Trelissac	30	44	31	46
6	Vitré	30	36	34	45
7	Romorantin	30	35	31	44
8	PSG II	30	44	36	42
9	Saint-Malo	30	32	32	42
10	Fontenay	30	47	49	42
11	Lorient II	30	41	35	39
12	Chartres	30	33	41	33
13	Plabennec	30	30	37	29
14	Mantes	30	23	41	29
15	Nantes II	30	40	40	28
16	Voltigeurs	30	26	48	26

TEMPORADA 2015/2016

NATIONAL 2 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Concarneau	30	41	24	56
2	Saint-Malo	30	57	32	55
3	Romorantin	30	54	44	54
4	Bergerac	30	36	33	52
5	Lorient II	30	40	31	44
6	Cholet	30	36	28	44
7	Voltigeurs	30	46	41	43
8	Fleury-Merog	30	32	35	41
9	Trelissac	30	38	32	39
10	Nantes II	30	37	38	35
11	Fontenay	30	40	45	35
12	Plabennec	30	34	49	34
13	V.Châtillon	30	26	34	31
14	Vitré	30	33	46	30
15	Stade	30	22	37	25
16	Girondins	30	23	46	22

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 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

Competiciones que juega

National

Pos	Equipos		Pts
1		Red Star	62
2		FC Martigues	53
3		Niort	52
4		Le Mans	48
5		Nancy	47
6		Dijon FCO	47
7		FC Rouen 1899	46
8		Sochaux	46
9		Versailles	43
10		Orléans	39
11		Chateauroux	36
12		Avranches	35
13		Villefranche	35
14		Nîmes	35
15		GOAL FC	34
16		Marignane Gignac	34
17		Épinal	32
18		Cholet	28

	Ascenso : Red Star, FC Martigues
	Descenso : Villefranche, Nîmes, GOAL FC, Marignane Gignac, Épinal, Cholet

RIVALES EN Copa de Francia

RIVALES EN National

USO DE MEMORIA

7,072,032 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5500
Total Execution Time	0.5512

CADENA URL

/historico/Cholet

GET DATOS

$_GET['/historico/Cholet']

POST DATOS

No hay datos POST existentes

CONSULTAS (26)

0.0154	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 = '6794' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148	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 = 72083 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0156	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=6794 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0154	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,72083,71432) 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.0173	SELECT count(id) as num_players from rel_players WHERE league_id = 72083 AND teamId = 6794
0.0198	SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 6794
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6794
0.0297	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 = 72083 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0199	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 = 72083 WHERE rp.league_id = 72083 AND rp.teamId = 6794 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 = 72083 WHERE rp.league_id = 72083 AND rp.teamId = 6794 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0185	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 = 72083 WHERE rp.league_id = 72083 AND rp.teamId = 6794 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0167	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 = 6794 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0170	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 = 68050 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 63266 AND t.round = 34 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 = 57035 AND t.round = 34 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* `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 = 50111 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 44443 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* `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 = 38779 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 33905 AND t.round = 30 ORDER BY team.conference 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* `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 = 15748 AND t.round = 30 ORDER BY team.conference 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* `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.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* `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.0150	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.0153	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.0165	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.0166	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

Cholet

Cholet

Selecciona un equipo

Competiciones que juega

National

RIVALES EN Copa de Francia

RIVALES EN National