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

FC Mulhouse

Temporada 2023/2024

TEMPORADA 2021/2022

NATIONAL 3 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Colmar	26	49	20	59
2	Raon-l'Etape	26	47	27	48
3	Troyes II	26	54	36	48
4	Sarre-Union	26	47	33	42
5	Strasbourg	26	35	28	39
6	Biesheim	26	34	41	37
7	FC Mulhouse	26	45	38	35
8	Nancy II	26	47	36	35
9	Thaon	26	41	40	35
10	Prix lès Mé.	26	27	38	32
11	Épernay	26	31	39	31
12	Illkirch	26	34	48	24
13	Saint-Louis	26	30	47	22
14	Amnéville	26	18	68	7

TEMPORADA 2020/2021

NATIONAL 3 GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Biesheim	7	16	5	17
2	Thaon	7	14	6	16
3	Colmar	7	13	10	11
4	Sarre-Union	6	12	10	10
5	FC Mulhouse	6	9	8	10
6	Saint-Louis	7	12	12	9
7	Nancy II	7	9	15	9
8	Épernay	6	7	6	7
9	Prix lès Mé.	7	9	11	7
10	Illkirch	6	7	12	7
11	Raon-l'Etape	7	5	11	7
12	Strasbourg	6	9	10	6
13	Troyes II	6	5	6	6
14	Amnéville	7	6	11	5

TEMPORADA 2019/2020

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bastia	21	37	15	53
2	CS Sedan	21	27	4	48
3	Bobigny	21	35	12	45
4	Stade Reims	21	39	30	36
5	Geneviève	21	30	25	34
6	Épinal	21	22	15	30
7	Lens II	21	26	27	28
8	Maur	21	22	23	24
9	Olympique	21	23	27	23
10	FCSR	21	21	29	23
11	Schiltigheim	21	26	36	22
12	FC Mulhouse	21	17	27	20
13	Belfort	21	24	34	19
14	Lille II	21	12	21	18
15	Drancy	21	16	28	17
16	Iris Club C.	21	17	41	16

TEMPORADA 2018/2019

NATIONAL 3 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	FC Mulhouse	26	40	21	48
2	Strasbourg	26	48	32	47
3	Sarre-Union	26	37	28	43
4	Thaon	26	42	40	38
5	Troyes II	26	38	26	36
6	Saint-Louis	26	32	34	35
7	FCA Troyes	26	24	21	34
8	Vauban	26	34	41	33
9	Biesheim	26	32	38	33
10	Raon-l'Etape	26	38	44	33
11	Amnéville	26	36	41	32
12	Sarreguemine	26	44	48	31
13	Nancy II	26	31	43	29
14	Épernay	26	28	47	20

TEMPORADA 2017/2018

NATIONAL 3 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	FCSR	30	56	29	60
2	Troyes II	30	57	29	54
3	Strasbourg	30	48	33	52
4	Biesheim	30	46	35	51
5	FC Mulhouse	30	39	32	46
6	Amnéville	30	46	36	46
7	Sarre-Union	30	53	43	45
8	Sarreguemine	30	50	40	45
9	Épernay	30	42	36	45
10	Nancy II	30	51	48	44
11	Metz II	30	40	36	40
12	Lunéville	30	33	44	39
13	Prix lès Mé.	30	30	38	33
14	Trémery	30	39	67	28
15	Pagny	30	31	59	20
16	Erstein	30	23	79	17

TEMPORADA 2016/2017

NATIONAL 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Grenoble	28	47	15	66
2	Le Puy	28	40	15	57
3	Annecy	28	50	32	50
4	Olympique	28	54	44	46
5	Jura Sud	28	44	38	44
6	Villefranche	28	34	34	40
7	Stade Reims	28	43	41	36
8	Andrézieux	28	37	44	33
9	Raon-l'Etape	28	37	49	32
10	GOAL FC	28	29	37	31
11	Saint-Louis	28	30	44	31
12	Yzeure	28	28	38	29
13	Montceau	28	35	48	28
14	FC Mulhouse	28	30	43	26
15	Auxerre II	28	35	51	25
16	Evian Thonon	0	0	0	0

TEMPORADA 2015/2016

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lyon-Duchèr	30	44	19	62
2	Grenoble	30	40	19	59
3	Auxerre II	30	39	27	49
4	Olympique	30	39	41	47
5	Jura Sud	30	41	34	44
6	Villefranche	30	37	30	43
7	Drancy	30	33	29	41
8	Saint-Louis	30	30	30	40
9	GOAL FC	30	26	32	38
10	FC Mulhouse	30	33	36	37
11	Yzeure	30	27	29	36
12	Moulins	30	34	41	36
13	Le Puy	30	27	35	32
14	Montceau	30	28	50	32
15	Sarre-Union	30	34	41	28
16	Sochaux II	30	23	42	24

TEMPORADA 2014/2015

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Belfort	30	51	30	61
2	Fleury-Merog	30	38	25	51
3	FC Mulhouse	30	45	32	48
4	Montceau	30	41	38	45
5	Sarre-Union	30	47	42	44
6	Moulins	30	35	30	44
7	Aubervillier	30	29	35	43
8	Jura Sud	30	40	42	40
9	Drancy	30	40	43	36
10	Troyes II	30	34	43	35
11	Yzeure	30	24	29	34
12	V.Châtillon	30	24	32	34
13	Sochaux II	30	38	43	33
14	Metz II	30	29	35	33
15	Raon-l'Etape	30	37	44	32
16	Saint-Étien	30	33	42	31

TEMPORADA 2013/2014

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Épinal	30	56	37	55
2	Moulins	30	51	35	52
3	Yzeure	30	43	31	48
4	Olympique	30	53	45	47
5	FC Mulhouse	30	36	38	45
6	Lyon-Duchèr	30	40	37	43
7	Belfort	30	32	32	42
8	Raon-l'Etape	30	45	49	42
9	Sarre-Union	30	48	48	40
10	Sochaux II	30	37	40	40
11	Villefranche	30	34	32	38
12	GOAL FC	30	33	39	38
13	Saint-Priest	30	28	45	38
14	Montceau	30	37	48	36
15	Jura Sud	30	45	44	35
16	Vesoul	30	26	44	25

TEMPORADA 2012/2013

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Grenoble	34	63	30	62
2	Raon-l'Etape	34	53	31	62
3	Strasbourg	34	47	29	62
4	Lyon-Duchèr	34	49	39	55
5	Moulins	34	51	36	54
6	FC Mulhouse	34	46	39	53
7	Villefranche	34	44	42	47
8	PSG II	34	44	49	44
9	Yzeure	34	37	35	43
10	Jura Sud	34	31	38	43
11	Sochaux II	34	30	34	40
12	Sarre-Union	34	28	52	40
13	Belfort	34	31	37	38
14	Montceau	34	30	43	38
15	GOAL FC	34	37	47	37
16	Auxerre II	34	29	52	37
17	UJA Maccabi	34	25	33	35
18	Nancy II	34	42	51	33

TEMPORADA 2011/2012

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Olympique	32	71	34	66
2	Bourg-Péron	32	56	26	62
3	Lyon-Duchèr	32	57	33	61
4	Raon-l'Etape	32	50	30	53
5	Metz II	32	58	40	47
6	Valence	32	40	31	47
7	Yzeure	32	42	36	45
8	FC Mulhouse	32	44	40	43
9	Moulins	32	31	30	43
10	Nancy II	32	34	42	42
11	Belfort	32	38	42	39
12	Villefranche	32	28	51	37
13	Sochaux II	32	40	44	35
14	GOAL FC	32	28	49	34
15	Amnéville	32	50	61	33
16	Sarre-Union	32	33	69	27
17	Jura Sud	32	31	73	19

TEMPORADA 2010/2011

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Besancon RC	32	41	22	64
2	Épinal	32	51	22	61
3	Ivry	32	53	31	56
4	Sochaux II	32	49	36	53
5	Villefranche	32	45	34	50
6	Amnéville	32	50	45	49
7	Bourg-Péron	32	50	48	47
8	PSG II	32	55	41	46
9	Auxerre II	32	41	32	44
10	Jura Sud	32	35	42	44
11	Nancy II	32	48	40	43
12	FC Mulhouse	32	45	44	41
13	Belfort	32	35	35	38
14	Raon-l'Etape	32	39	49	37
15	Lyon-Duchèr	32	40	51	35
16	GOAL FC	32	34	68	22
17	Louhans	32	13	84	7

TEMPORADA 2009/2010

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Colmar	36	55	33	69
2	UJA Maccabi	36	56	37	67
3	Villemomble	36	45	33	61
4	Besancon RC	36	59	48	56
5	Amnéville	36	58	55	53
6	Drancy	36	49	51	52
7	Noisy-le-Sec	36	52	46	50
8	Nancy II	36	47	46	50
9	Épinal	36	45	46	50
10	Lille II	36	55	47	49
11	Compiègne	36	42	40	48
12	Raon-l'Etape	36	47	48	45
13	Sannois	36	47	50	45
14	FC Mulhouse	36	41	48	45
15	Lens II	36	40	42	44
16	Vesoul	36	29	45	38
17	Dunkerque	36	45	53	37
18	Marck	36	43	57	37
19	Strasbourg	36	28	58	24

TEMPORADA 2008/2009

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Besancon RC	34	67	34	72
2	Compiègne	34	52	30	64
3	FC Mulhouse	34	46	32	62
4	Montceau	34	46	33	58
5	Colmar	34	33	29	54
6	Sochaux II	34	45	36	53
7	Dunkerque	34	43	39	49
8	Auxerre II	34	39	37	47
9	Lens II	34	45	40	45
10	Strasbourg	34	34	35	44
11	Lille II	34	40	48	43
12	Raon-l'Etape	34	39	49	41
13	Sénart	34	24	32	37
14	Nancy II	34	32	41	36
15	Noisy-le-Sec	34	31	43	36
16	Vesoul	34	39	49	35
17	Metz II	34	30	47	35
18	Geneviève	34	28	59	22

TEMPORADA 2007/2008

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Evian Thonon	34	52	17	74
2	Besancon RC	34	61	20	68
3	Vesoul	34	61	42	61
4	Sochaux II	34	65	45	60
5	Saint-Priest	34	50	38	53
6	Olympique	34	45	32	49
7	Montceau	34	36	33	48
8	Auxerre II	34	52	48	45
9	Strasbourg	34	42	43	45
10	Red Star	34	38	40	40
11	Jura Sud	34	31	37	38
12	FC Mulhouse	34	31	55	38
13	Raon-l'Etape	33	36	57	37
14	Metz II	33	35	45	36
15	Nancy II	34	28	36	34
16	Épinal	34	33	49	34
17	Belfort	34	30	50	32
18	Épernay	34	25	64	26

TEMPORADA 2006/2007

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Calais	34	55	24	66
2	Besancon RC	34	55	31	62
3	Lille II	34	46	34	56
4	Dunkerque	34	50	42	50
5	Metz II	34	44	37	50
6	Sochaux II	34	56	43	48
7	Compiègne	34	42	39	48
8	Épinal	34	42	42	46
9	Lens II	34	42	49	46
10	FC Mulhouse	34	38	45	46
11	Nancy II	34	38	39	44
12	Vesoul	34	33	39	44
13	Lesquin	34	36	47	43
14	Olympique	34	37	39	38
15	Strasbourg	34	41	44	36
16	Épernay	34	35	55	35
17	Leval	34	37	61	32
18	Schiltigheim	34	44	61	31

TEMPORADA 2005/2006

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Beauvais	34	67	33	68
2	Dunkerque	34	55	37	63
3	Auxerre II	34	51	32	58
4	Roye-Noyon	34	47	37	51
5	Calais	34	41	30	50
6	Compiègne	34	43	34	50
7	Lens II	34	50	44	49
8	Lesquin	34	35	41	46
9	Lille II	34	45	39	45
10	FC Mulhouse	34	40	48	43
11	Metz II	33	36	33	42
12	Strasbourg	34	35	43	42
13	Nancy II	34	38	40	39
14	Vauban	34	47	59	37
15	Schiltigheim	34	35	48	37
16	Épinal	34	32	54	37
17	Feignies	33	36	47	36
18	Wasquehal	34	32	66	21

TEMPORADA 1998/1999

NATIONAL
Equipo		PJ	GF	GC	Puntos
1	Louhans	36	51	26	68
2	Creteil	36	52	25	66
3	Gazélec	36	50	34	65
4	Racing	36	43	28	63
5	Valenciennes	36	54	27	62
6	Noisy-le-Sec	36	35	26	58
7	Pau FC	36	41	37	50
8	Raon-l'Etape	36	42	40	49
9	Paris FC	36	46	51	49
10	Fréjus	36	36	41	44
11	Martigues	36	34	37	42
12	Istres	36	39	43	42
13	Angers SCO	36	45	55	42
14	Thouars	36	39	43	40
15	FC Mulhouse	36	40	56	40
16	Maur Lusi	36	40	45	39
17	Pacy	36	32	51	39
18	Angouleme	36	34	52	34
19	Saint-Priest	36	29	65	30

TEMPORADA 1997/1998

LIGUE 2
Equipo		PJ	GF	GC	Puntos
1	Nancy	42	64	37	76
2	Lorient	42	68	38	75
3	Sochaux	42	56	37	66
4	Lille	42	62	44	65
5	Troyes	42	48	38	63
6	Le Mans	42	54	46	62
7	Valence	42	51	45	58
8	Red Star	42	51	61	57
9	Caen	42	61	55	56
10	Niort	42	42	38	55
11	FC Gueugnon	42	47	54	55
12	Amiens SC	42	40	49	55
13	Stade	42	50	48	54
14	Nice	42	40	40	52
15	Nîmes	42	41	51	52
16	Beauvais	42	40	47	51
17	Saint-Étien	42	47	60	51
18	Wasquehal	42	49	63	51
19	Louhans	42	41	51	49
20	Sporting	42	43	62	46
21	Martigues	42	37	63	45
22	FC Mulhouse	42	51	56	41

TEMPORADA 1996/1997

LIGUE 2
Equipo		PJ	GF	GC	Puntos
1	Chateauroux	42	54	27	76
2	Toulouse	42	61	32	75
3	Martigues	42	54	33	67
4	FC Gueugnon	42	54	47	67
5	Niort	42	44	36	65
6	Le Mans	42	49	41	62
7	Beauvais	42	43	43	61
8	Stade	42	48	39	58
9	Lorient	42	50	50	58
10	Valence	42	48	53	58
11	Sochaux	42	54	47	57
12	FC Mulhouse	42	51	49	54
13	Red Star	42	50	48	54
14	Sporting	42	50	57	54
15	Amiens SC	42	44	47	52
16	Perpignan	42	38	42	51
17	Saint-Étien	42	48	56	51
18	Louhans	42	39	52	51
19	Charleville	42	37	48	49
20	Troyes	42	36	42	48
21	Stade	42	32	46	38
22	Épinal	42	26	75	26

Comparar equipos

FC Mulhouse

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa de Francia

USO DE MEMORIA

7,709,456 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.5437
Total Execution Time	0.5451

CADENA URL

/historico/Mulhouse

GET DATOS

$_GET['/historico/Mulhouse']

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2831 AND type_rel = 2
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=325 AND type_rel = 3
0.0138	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 325 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129	SELECT /53 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 (1055306,1309247,1309074,1308938,1309013) ORDER BY n.cover_points DESC, update_date DESC
0.0131	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 = '2831' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131	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=2831 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128	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) 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.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 2831
0.0126	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 = 74470 AND t.round = 8 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0136	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 = 74470 WHERE rp.league_id = 74470 AND rp.teamId = 2831 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.0135	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 = 74470 WHERE rp.league_id = 74470 AND rp.teamId = 2831 AND (e.action = 4 or e.action = 5) 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 events2024 e ON e.player_id = p.id AND e.league_id = 74470 WHERE rp.league_id = 74470 AND rp.teamId = 2831 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131	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 = 2831 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129	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 = 63488 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.0128	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 = 57539 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.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* `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 = 50567 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.0128	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 = 44565 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 39133 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 33907 AND t.round = 30 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* `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 = 15746 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 4378 AND t.round = 30 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* `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 = 2537 AND t.round = 30 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* `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 = 2098 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 1680 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 19924 AND t.round = 34 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* `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 = 19931 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 19936 AND t.round = 34 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* `tables2007` 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 = 19939 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 19943 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM* `tables1999` 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 = 16461 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* `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 = 527 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM* `tables1997` 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 = 528 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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 = 74470 ORDER BY nameShow LIMIT 100