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

Monaco II

Temporada 2023/2024

TEMPORADA 2021/2022

NATIONAL 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Martigues	30	48	29	60
2	Grasse	30	41	29	54
3	GOAL FC	30	51	29	51
4	Fréjus	30	34	27	47
5	Jura Sud	30	46	42	45
6	Louhans	30	39	29	43
7	Aubagne	30	37	32	40
8	Hyères	30	34	34	39
9	Sporting	30	30	29	38
10	Olympique	30	31	43	38
11	Saint-Priest	30	37	38	37
12	Marignane	30	29	35	37
13	Lyon-Duchèr	30	36	43	33
14	Rumilly	30	27	39	32
15	Monaco II	30	34	48	32
16	Olympique	30	31	59	24

TEMPORADA 2020/2021

NATIONAL 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	GOAL FC	9	18	10	17
2	Aubagne	9	15	10	17
3	Sporting	9	15	8	16
4	Martigues	8	15	9	16
5	Fréjus	8	9	2	15
6	Andrézieux	9	15	11	14
7	Hyères	9	10	12	13
8	Grasse	8	10	6	12
9	Saint-Priest	9	14	14	12
10	Olympique	9	12	14	10
11	Rumilly	8	10	13	9
12	Louhans	8	11	12	8
13	Monaco II	9	9	18	8
14	Marignane	8	8	17	6
15	Olympique	9	6	17	6
16	Jura Sud	5	6	10	2

TEMPORADA 2019/2020

NATIONAL 2 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Annecy	21	30	16	42
2	Grasse	21	28	17	40
3	GOAL FC	21	32	19	39
4	Yzeure	21	30	21	39
5	Martigues	21	27	20	37
6	Louhans	21	40	26	33
7	Fréjus	21	21	22	27
8	Olympique	21	28	31	25
9	Hyères	21	13	21	25
10	Olympique	21	27	38	24
11	Jura Sud	21	24	37	23
12	Marignane	21	19	23	22
13	Monaco II	21	26	34	22
14	Saint-Priest	21	24	27	21
15	Marseille	21	23	33	19
16	Nîmes II	21	21	28	17

TEMPORADA 2018/2019

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sporting	30	43	25	59
2	Fréjus	30	51	38	57
3	Annecy	30	50	34	54
4	Jura Sud	30	43	30	50
5	Athlético	30	57	46	47
6	Marseille	30	42	34	44
7	Martigues	30	40	30	41
8	Hyères	30	29	33	41
9	Saint-Priest	30	39	42	40
10	Grasse	30	35	42	39
11	GOAL FC	30	32	39	39
12	Olympique	30	56	47	37
13	Olympique	30	50	57	35
14	Monaco II	30	44	52	33
15	Pontarlier	30	20	53	22
16	Nice II	30	41	70	20

TEMPORADA 2017/2018

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sporting	30	41	25	57
2	Marignane	30	39	25	57
3	Colomiers	30	43	27	51
4	Bergerac	30	43	28	49
5	Fréjus	30	41	32	49
6	Martigues	30	42	33	47
7	Sète	30	39	26	43
8	Monaco II	30	44	34	43
9	Grasse	30	32	31	39
10	Hyères	30	35	32	36
11	Stade	30	30	36	36
12	Nice II	30	31	48	35
13	Stade	30	32	46	32
14	Olympique	30	31	46	28
15	Tarbes	30	32	60	26
16	Paulhan/Péz	30	19	45	23

TEMPORADA 2016/2017

NATIONAL 2 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Rodez	30	43	27	61
2	Stade	30	46	28	51
3	Fréjus	30	46	31	51
4	Sporting	30	42	33	44
5	Hyères	30	32	22	43
6	Colomiers	30	35	37	43
7	Monaco II	30	54	48	42
8	Marignane	30	47	45	40
9	Tarbes	30	32	32	39
10	Olympique	30	30	32	38
11	Martigues	30	33	40	38
12	Sète	30	26	28	35
13	Nice II	30	37	50	35
14	Paulhan/Péz	30	34	45	33
15	Montpellier	30	26	45	31
16	Pontet	30	25	45	24

TEMPORADA 2015/2016

NATIONAL 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Pau FC	28	38	19	58
2	Monaco II	28	55	35	48
3	Colomiers	28	32	27	48
4	Nice II	28	42	36	45
5	Stade	28	33	30	43
6	Martigues	28	25	29	37
7	Marignane	28	32	39	37
8	Hyères	28	32	29	36
9	Olympique	28	33	33	34
10	Pontet	28	38	40	34
11	LAS Toulon	28	27	34	34
12	Tarbes	28	28	36	34
13	Rodez	28	25	27	31
14	Sète	28	23	29	30
15	Bayonne	28	23	43	20
16	Arles	0	0	0	0

TEMPORADA 2014/2015

NATIONAL 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Béziers	30	45	24	60
2	Grenoble	30	43	19	59
3	Olympique	30	44	28	52
4	Martigues	30	39	30	48
5	Marignane	30	35	25	45
6	Rodez	30	40	49	40
7	Villefranche	30	30	40	40
8	Sète	30	30	34	39
9	Nice II	30	39	46	37
10	Monaco II	30	41	35	36
11	GOAL FC	30	27	40	34
12	Lyon-Duchèr	30	35	35	33
13	Pontet	30	36	40	33
14	Hyères	30	26	33	32
15	Montpellier	30	31	47	27
16	Saint-Priest	30	25	41	26

TEMPORADA 2013/2014

NATIONAL 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Athlético	29	48	26	50
2	Rodez	28	38	27	50
3	Grenoble	28	41	26	46
4	Hyères	28	31	32	45
5	Pau FC	29	33	27	44
6	Cannes	29	34	30	40
7	Martigues	28	30	29	37
8	Monaco II	28	43	42	36
9	Béziers	28	35	32	35
10	Marignane	28	29	35	35
11	Nice II	29	34	41	34
12	Pontet	28	23	36	33
13	Tarbes	28	24	35	31
14	Valence	28	26	34	30
15	Stade	28	29	46	24

TEMPORADA 2012/2013

NATIONAL 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Colomiers	34	42	17	65
2	Cannes	34	50	24	59
3	Hyères	34	39	27	57
4	Martigues	34	46	31	55
5	Olympique	34	52	34	52
6	Marignane	34	40	34	49
7	Athlético	34	55	52	49
8	Rodez	34	38	50	48
9	Béziers	34	37	37	46
10	Monaco II	34	46	40	45
11	Pontet	34	46	47	44
12	Tarbes	34	38	53	44
13	Valence	34	35	44	42
14	Pau FC	34	41	45	41
15	Albi	34	41	57	35
16	Stade	34	42	61	35
17	Bayonne	34	21	36	33
18	Saint-Étien	34	24	44	25

TEMPORADA 2011/2012

NATIONAL 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Uzès Pont G.	34	55	29	70
2	Rodez	34	43	26	60
3	Monaco II	34	56	46	56
4	Cannes	33	53	36	54
5	Colomiers	34	45	30	53
6	Hyères	34	40	43	53
7	Saint-Étien	34	57	35	52
8	Girondins	34	34	32	49
9	Stade	34	39	35	46
10	Tarbes	34	44	41	46
11	Agde	34	38	35	44
12	Athlético	33	35	47	43
13	Pau FC	34	33	35	42
14	Marignane	34	40	53	41
15	Béziers	34	39	50	40
16	Pontet	34	45	57	36
17	Albi	34	34	51	31
18	Gap	34	22	71	10

TEMPORADA 2010/2011

NATIONAL 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Gazélec	34	51	32	68
2	Martigues	34	57	28	64
3	Pau FC	34	56	33	61
4	Olympique	34	53	41	53
5	Monaco II	34	49	41	50
6	Sporting	34	41	40	49
7	Colomiers	34	46	40	45
8	Saint-Étien	34	50	49	45
9	Albi	34	44	49	45
10	Hyères	34	47	47	44
11	Pontet	34	61	63	44
12	Uzès Pont G.	34	38	40	42
13	Agde	34	37	46	41
14	Marignane	34	28	36	40
15	Tarbes	34	38	42	39
16	Béziers	34	42	51	39
17	Aurillac	34	33	57	29
18	Anglet	34	32	68	27

TEMPORADA 2009/2010

NATIONAL 3 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Monaco II	30	56	26	60
2	Uzès Pont G.	30	57	24	58
3	Grasse	30	38	34	50
4	FC Calvi	30	44	34	48
5	Athlético	29	39	43	44
6	Valettoise	30	32	36	42
7	Sportive	30	43	40	41
8	Trinité	30	43	45	41
9	Cortenais	30	41	47	41
10	Nice II	30	39	30	40
11	Nîmes II	30	39	39	39
12	Gardanne	29	33	39	39
13	Furiani	30	33	47	39
14	Olympique	30	29	36	34
15	Ajaccio II	30	34	53	26
16	Menton	30	22	49	22

TEMPORADA 2008/2009

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hyères	34	37	24	66
2	Fréjus	34	50	29	58
3	Villefranche	34	59	44	56
4	Andrézieux	34	43	29	53
5	Martigues	34	51	39	53
6	Sporting	34	42	40	53
7	Olympique	34	52	36	52
8	Montpellier	34	64	46	49
9	Gazélec	34	40	41	46
10	CA Bastia	34	55	64	45
11	Agde	34	39	49	43
12	Jura Sud	34	36	47	42
13	Marignane	34	27	31	40
14	Lyon-Duchèr	34	36	50	40
15	Gap	34	42	54	38
16	Saint-Étien	34	40	45	35
17	Saint-Priest	34	36	58	30
18	Monaco II	34	34	57	30

TEMPORADA 2007/2008

NATIONAL 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Cassis-Carno	34	49	31	69
2	Gap	34	58	28	63
3	Gazélec	34	37	32	57
4	Monaco II	34	47	33	52
5	Marignane	34	41	32	51
6	Albi	34	45	32	50
7	Saint-Étien	34	33	35	47
8	Hyères	34	33	26	46
9	Sporting	34	36	36	46
10	Fréjus	34	41	43	46
11	CA Bastia	34	35	48	44
12	Luzenac	34	49	51	43
13	Andrézieux	34	31	33	41
14	Balma	34	34	44	39
15	Montpellier	34	33	43	39
16	Nice II	34	36	41	37
17	Toulouse II	34	31	49	29
18	Manosque	34	33	65	28

TEMPORADA 2006/2007

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Arles	34	53	35	62
2	Evian Thonon	34	43	29	58
3	Fréjus	34	54	43	55
4	Gap	34	48	37	55
5	Olympique	34	56	48	52
6	Jura Sud	34	47	39	51
7	Gazélec	34	50	44	51
8	Cassis-Carno	34	46	32	50
9	Monaco II	33	33	26	50
10	Montceau	34	40	38	49
11	Montpellier	34	50	43	48
12	Saint-Priest	34	39	43	48
13	CA Bastia	34	46	58	41
14	Nice II	34	38	40	39
15	Pontet	34	39	46	38
16	Saint-Étien	33	45	44	36
17	Agde	34	41	59	32
18	Marseille	34	27	91	11

TEMPORADA 2005/2006

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Martigues	34	41	19	67
2	Olympique	34	65	40	59
3	Pontet	34	30	23	58
4	Cassis-Carno	33	46	33	53
5	Nice II	34	48	45	53
6	Saint-Priest	34	45	42	50
7	Sochaux II	34	43	35	48
8	Jura Sud	34	35	38	48
9	Gap	34	40	38	46
10	Monaco II	34	49	44	45
11	Montpellier	34	45	42	45
12	Fréjus	33	39	36	44
13	Besancon RC	34	39	43	41
14	Agde	34	30	44	39
15	Marseille	34	43	63	37
16	Racing	34	45	51	34
17	Bourg-Péron	34	39	58	29
18	Lyon-Duchèr	34	21	49	26

Comparar equipos

Monaco II

Selecciona un equipo

Competiciones que juega

USO DE MEMORIA

6,978,872 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.1486
Total Execution Time	0.1498

CADENA URL

/historico/Monaco-Ii

GET DATOS

$_GET['/historico/Monaco-Ii']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0041	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 = 'Monaco-Ii' 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.0021	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=6696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=6696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6696 AND type_rel = 2
0.0033	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6696 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0032	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 (66107,480732,578602,634382,663233) ORDER BY n.cover_points DESC, update_date DESC
0.0041	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 = '6696' ORDER BY l.year DESC,cat.coefficient DESC
0.0038	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 = '6696' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0040	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 = '6696' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0039	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 = '6696' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0043	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=6696 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0024	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 (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.0036	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6696
0.0033	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 = '6696' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0031	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6696' and rp.type = 4
0.0030	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 = '6696' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0040	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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 6696 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.0029	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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 6696 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038	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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 6696 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	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 = 6696 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 63481 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.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* `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 = 57115 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.0027	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 = 50570 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.0029	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 = 44572 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 39108 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 33908 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 15747 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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 = 4379 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 2538 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 2099 AND t.round = 34 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* `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 = 1681 AND t.round = 34 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* `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 = 19925 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 = 20007 AND t.round = 30 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* `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 = 19932 AND t.round = 34 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* `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 = 19937 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 19940 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC