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

Gratkorn

Temporada 2023/2024

TEMPORADA 2014/2015

CUARTA AUSTRIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Deutschlands	30	84	35	68
2	Heiligenkreu	30	71	38	66
3	Gleisdorf	30	60	46	48
4	Frohnleiten	30	48	48	47
5	Union Gnas	30	55	43	45
6	Zeltweg	30	61	50	44
7	Anger	30	50	44	44
8	Kapfenberger	30	52	48	44
9	Voitsberg	30	51	53	44
10	Weindorf	30	58	61	38
11	Liezen	30	37	49	37
12	Lebring	30	34	43	36
13	Leoben	30	45	55	34
14	Fürstenfeld	30	46	56	32
15	Gleinstätte	30	63	78	31
16	Gratkorn	30	27	95	9

TEMPORADA 2013/2014

CUARTA AUSTRIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Weiz	30	71	19	72
2	Gleisdorf	30	70	39	61
3	Deutschlands	30	72	42	59
4	Gleinstätte	30	56	43	53
5	Union Gnas	30	43	34	46
6	Heiligenkreu	30	65	59	45
7	Frohnleiten	30	53	49	42
8	Voitsberg	30	47	45	41
9	Leoben	30	40	44	39
10	Fürstenfeld	30	45	45	37
11	Gratkorn	30	41	55	32
12	Anger	30	35	47	31
13	Liezen	30	38	55	31
14	Wildon	30	38	59	30
15	Grossklein	30	27	65	20
16	Irdning	30	32	73	18

TEMPORADA 2012/2013

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	LASK	28	75	15	68
2	SV Pasching	28	64	19	66
3	Klagenfurt	28	54	48	47
4	Kalsdorf	28	62	48	43
5	SV Villach	28	46	40	43
6	Union	28	34	37	37
7	Allerheilige	28	46	52	36
8	Austria	28	40	48	35
9	Gratkorn	28	50	53	34
10	SV Wallern	28	24	31	34
11	Vöcklamarkt	28	38	46	33
12	Sturm Graz	28	36	47	32
13	Kapfenberger	28	27	50	27
14	Feldkirchen	28	36	69	23
15	Leoben	28	32	61	19
16	Grazer AK	0	0	0	0

TEMPORADA 2011/2012

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Grazer AK	30	80	29	70
2	SV Villach	30	45	30	53
3	Klagenfurt	30	44	41	48
4	Vöcklamarkt	30	44	42	48
5	Leoben	30	43	34	47
6	Austria	30	44	36	45
7	Gratkorn	30	50	49	44
8	Union	30	38	33	41
9	Sturm Graz	30	41	39	41
10	Allerheilige	30	38	35	40
11	Kapfenberger	30	47	46	40
12	SV Pasching	30	41	40	38
13	Wels	30	32	42	36
14	Vorwarts	30	36	58	27
15	Gleinstätte	30	32	54	25
16	LASK Juniors	30	28	75	20

TEMPORADA 2010/2011

SEGUNDA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Admira	36	85	45	75
2	SCR Altach	36	76	37	74
3	Austria	36	55	51	54
4	Sankt Andrä	36	56	50	52
5	Polten	36	55	55	51
6	Grödig	36	51	60	46
7	FC Lustenau	36	51	60	42
8	Hartberg	36	44	60	39
9	First Vienna	36	47	67	34
10	Gratkorn	36	47	82	33

TEMPORADA 2009/2010

SEGUNDA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Wacker	33	67	26	69
2	Admira	33	68	22	67
3	SCR Altach	33	60	27	66
4	Polten	33	44	42	51
5	Austria	33	43	46	50
6	Juniors	33	58	49	44
7	Gratkorn	33	57	51	43
8	FC Lustenau	33	42	52	41
9	Hartberg	33	36	68	38
10	Austria Wien	33	42	57	35
11	First Vienna	33	37	57	30
12	Dornbirn	33	24	81	22

TEMPORADA 2008/2009

SEGUNDA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Wiener	33	65	26	69
2	Wacker	33	65	44	62
3	Admira	33	55	36	60
4	Austria	33	52	47	48
5	Polten	33	51	46	47
6	Austria Wien	33	44	43	45
7	Juniors	33	41	56	43
8	Gratkorn	33	39	55	40
9	FC Lustenau	33	34	37	38
10	Grödig	33	37	52	35
11	Leoben	33	30	55	32
12	Vöcklabruck	33	40	56	30

TEMPORADA 2007/2008

SEGUNDA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Kapfenberger	33	79	45	66
2	Gratkorn	33	51	35	55
3	Austria	33	59	45	54
4	FC Lustenau	33	50	39	53
5	Austria Wien	33	45	44	50
6	Juniors	33	51	52	46
7	Schwanenstad	33	48	51	45
8	Leoben	33	44	46	41
9	Schwadorf	33	48	53	41
10	FC Kärnten	33	37	51	40
11	Parndorf	33	45	61	37
12	Bad Aussee	33	35	70	20

TEMPORADA 2006/2007

SEGUNDA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	LASK	33	74	34	76
2	Schwanenstad	33	59	41	63
3	Leoben	33	55	36	55
4	Austria	33	57	50	50
5	Gratkorn	33	45	41	47
6	FC Lustenau	33	54	51	47
7	FC Kärnten	33	41	41	42
8	Austria Wien	33	42	52	38
9	Parndorf	33	41	47	35
10	Admira	33	45	67	33
11	Kapfenberger	33	41	60	32
12	Hartberg	33	31	65	26

TEMPORADA 2005/2006

SEGUNDA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	SCR Altach	36	61	35	68
2	LASK	36	51	30	66
3	Austria	36	54	32	62
4	Austria Wien	36	58	40	58
5	Gratkorn	36	47	40	54
6	Leoben	36	59	49	51
7	FC Kärnten	36	57	50	51
8	Kapfenberger	36	51	69	39
9	Schwanenstad	36	33	57	33
10	Kufstein	36	23	92	16

TEMPORADA 2004/2005

SEGUNDA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	SV Ried	36	79	38	77
2	Kapfenberger	36	64	37	71
3	FC Kärnten	36	68	41	58
4	Austria	36	55	43	56
5	Leoben	36	43	49	47
6	SCR Altach	36	37	45	41
7	LASK	36	38	64	39
8	Untersiebenb	36	45	66	34
9	Gratkorn	36	43	58	32
10	Wörgl	36	32	63	32

TEMPORADA 2003/2004

TERCERA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Gratkorn	30	67	28	63
2	Hartberg	30	62	30	60
3	Arnfels	30	50	39	49
4	Köflach	30	53	49	48
5	Blau-Weiß	30	40	33	47
6	Schwanenstad	30	41	35	44
7	Bleiburg	30	33	32	42
8	Sturm Graz	30	33	35	41
9	Sankt Andrä	30	44	47	40
10	Kärnten	30	31	28	39
11	Voitsberg	30	45	49	39
12	Union	30	35	41	38
13	Union Perg	30	35	58	35
14	Spittal	30	27	38	34
15	Wels	30	25	48	26
16	LASK Linz	30	23	54	19

TEMPORADA 2002/2003

TERCERA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Blau-Weiß	30	72	22	72
2	Hartberg	30	58	37	59
3	Schwanenstad	30	58	38	52
4	Voitsberg	30	54	29	51
5	Gratkorn	30	42	24	51
6	Köflach	30	49	41	50
7	Spittal	30	41	34	42
8	Kärnten	30	38	41	42
9	Bleiburg	30	32	43	41
10	Sturm Graz	30	58	53	39
11	Union Perg	30	42	47	36
12	Eintracht	30	35	55	33
13	Union	30	33	56	31
14	Klagenfurt	30	32	52	28
15	Veit Glan	30	26	70	24
16	Zeltweg	30	28	56	23

TEMPORADA 2001/2002

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kapfenberger	30	79	29	66
2	Blau-Weiß	30	62	34	61
3	Hartberg	30	54	26	59
4	Gratkorn	30	48	27	55
5	Spittal	30	49	30	53
6	Schwanenstad	30	47	35	49
7	Zeltweg	30	44	47	48
8	Voitsberg	30	42	41	41
9	Köflach	30	33	41	39
10	Eintracht	30	31	36	38
11	Union	30	53	58	37
12	Kärnten	30	40	45	35
13	Bleiburg	30	26	34	33
14	Sankt Veit	30	28	57	18
15	ATSV	30	23	57	18
16	Donau Linz	30	27	89	8

TEMPORADA 2000/2001

TERCERA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	SV Pasching	30	61	27	56
2	Kapfenberger	30	50	34	51
3	Hartberg	30	47	30	48
4	BSV Juniors	30	52	39	48
5	Gratkorn	30	44	35	45
6	Donau Linz	30	33	30	45
7	Blau-Weiß	30	48	41	42
8	Alpe Adria	30	38	44	41
9	Zeltweg	30	42	39	40
10	Spittal	30	47	51	39
11	Wels	30	40	51	38
12	Voitsberg	30	40	48	37
13	Wolfsberger	30	37	49	34
14	Union	30	34	56	32
15	Lendorf	30	24	45	31
16	Klagenfurt	30	29	47	26

Comparar equipos

Gratkorn

Selecciona un equipo

Competiciones que juega

USO DE MEMORIA

6,345,328 bytes

BENCHMARKS

Loading Time Base Classes	0.0015
Controller Execution Time ( Home / Category )	0.1405
Total Execution Time	0.1419

CADENA URL

/historico/Gratkorn

GET DATOS

$_GET['/historico/Gratkorn']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0031	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 = 'Gratkorn' 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=18097 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=18097 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18097 AND type_rel = 2
0.0032	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=153 AND type_rel = 3
0.0091	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 153 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022	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 (1312034,1307741,1307681,1307639,1307019) ORDER BY n.cover_points DESC, update_date DESC
0.0026	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 = '18097' ORDER BY l.year DESC,cat.coefficient DESC
0.0028	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 = '18097' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020	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 = '18097' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	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 = '18097' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=18097 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 18097
0.0019	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 = '18097' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18097' and rp.type = 4
0.0020	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 = '18097' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 18097 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.0022	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 = 18097 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 18097 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 18097 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* `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 = 3939 AND t.round = 30 ORDER BY team.conference 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* `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 = 27166 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 = 24526 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* `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 = 24529 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* `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 = 8926 AND t.round = 36 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 = 8925 AND t.round = 33 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* `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 = 8924 AND t.round = 33 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* `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 = 8921 AND t.round = 33 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* `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 = 8919 AND t.round = 33 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* `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 = 8916 AND t.round = 36 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* `tables2005` 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 = 8914 AND t.round = 36 ORDER BY team.conference 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* `tables2004` 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 = 27570 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* `tables2003` 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 = 44521 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* `tables2002` 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 = 27565 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC