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.

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

Sturm Graz II

Entrenador: Jürgen Säumel

Temporada 2015/2016

TEMPORADA 2015/2016

TERCERA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Blau-Weiß	30	89	25	70
2	Hartberg	30	64	38	60
3	Union	30	53	35	52
4	Kalsdorf	30	56	43	51
5	SV Pasching	30	59	46	50
6	SV Lafnitz	30	62	52	49
7	Stadl-Paura	30	58	49	48
8	Allerheilige	30	50	43	48
9	Deutschlands	30	49	43	43
10	Gurten	30	51	44	40
11	Sturm Graz	30	48	48	38
12	Vorwarts	30	36	49	34
13	Weiz	30	33	66	26
14	Wolfsberger	30	34	64	23
15	SV Wallern	30	35	70	22
16	Annabichler	30	24	86	19

TEMPORADA 2014/2015

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Austria	29	66	24	64
2	Vorwarts	29	43	29	56
3	Weiz	29	55	39	53
4	SV Lafnitz	29	54	27	52
5	Blau-Weiß	29	49	34	51
6	Allerheilige	29	52	42	48
7	Sturm Graz	29	50	41	43
8	Kalsdorf	29	51	49	40
9	Wolfsberger	29	39	42	40
10	SV Pasching	29	45	49	40
11	Gurten	29	36	45	37
12	SV Wallern	29	35	46	34
13	Union	29	32	54	30
14	Klagenfurt	29	29	61	24
15	Vöcklamarkt	29	25	44	21
16	ATSV	29	21	56	16

TEMPORADA 2013/2014

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	LASK	30	80	19	76
2	SV Pasching	30	79	20	69
3	SV Lafnitz	30	68	55	55
4	SV Wallern	30	52	46	47
5	Austria	30	56	68	44
6	Blau-Weiß	30	40	52	42
7	Union	30	36	36	41
8	Sturm Graz	30	54	55	41
9	Kalsdorf	30	53	55	39
10	Allerheilige	30	49	46	37
11	Klagenfurt	30	57	65	37
12	Vorwarts	30	37	47	37
13	Vöcklamarkt	30	38	63	34
14	Wolfsberger	30	35	57	27
15	SV Villach	30	37	62	26
16	Kapfenberger	30	35	60	25

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

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	LASK Juniors	30	55	37	58
2	Blau-Weiß	30	55	27	57
3	Grazer AK	30	59	37	54
4	Allerheilige	30	45	29	52
5	Union	30	43	37	45
6	SV Pasching	30	38	33	45
7	Austria	30	42	37	43
8	Gleinstätte	30	49	49	41
9	Vöcklamarkt	30	45	45	38
10	Klagenfurt	30	38	40	38
11	Leoben	30	47	51	37
12	Sturm Graz	30	48	61	34
13	Wels	30	21	42	33
14	Feldkirchen	30	36	55	27
15	Weiz	30	34	53	26
16	Voitsberg	30	30	52	21

TEMPORADA 2009/2010

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	SV Pasching	30	77	24	63
2	Sankt Andrä	30	66	32	61
3	Blau-Weiß	30	49	31	55
4	St. Stefan	30	51	37	51
5	Grazer AK	30	57	40	50
6	Union	30	58	38	47
7	Allerheilige	30	57	49	46
8	Weiz	30	54	48	45
9	Voitsberg	30	48	44	45
10	Leoben	30	46	46	42
11	Klagenfurt	30	40	50	39
12	Wels	30	44	50	37
13	Sturm Graz	30	50	50	35
14	Flavia Solva	30	46	59	27
15	Veit Glan	30	36	76	25
16	Bad Aussee	30	14	119	5

TEMPORADA 2008/2009

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hartberg	30	63	25	64
2	Grazer AK	30	68	32	64
3	Sturm Graz	30	52	32	56
4	Voitsberg	30	65	37	54
5	Sankt Andrä	30	41	30	54
6	Wels	30	62	51	47
7	Blau-Weiß	30	50	35	43
8	Union	30	49	41	40
9	Klagenfurt	30	46	46	38
10	Allerheilige	30	38	38	38
11	Weiz	30	48	52	34
12	Veit Glan	30	43	62	30
13	Bad Aussee	30	29	66	28
14	Feldkirchen	30	39	66	27
15	FC Kärnten	30	22	70	23
16	Spittal	30	31	63	19

TEMPORADA 2007/2008

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Vöcklabruck	30	70	23	68
2	Feldkirchen	30	66	45	52
3	Grazer AK	30	57	37	52
4	Sankt Andrä	30	41	26	52
5	Sturm Graz	30	52	40	52
6	Allerheilige	30	40	35	52
7	Hartberg	30	45	38	44
8	Wels	30	57	46	43
9	Klagenfurt	30	44	43	41
10	Union	30	44	45	38
11	Austria	30	40	52	38
12	Weiz	30	45	47	35
13	Spittal	30	34	42	30
14	Gmunden	30	33	69	26
15	Grieskirchen	30	30	55	22
16	Bleiburg	30	19	74	10

TEMPORADA 2006/2007

TERCERA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Bad Aussee	30	62	31	57
2	Wels	30	58	34	56
3	Feldkirchen	30	51	35	53
4	Sankt Andrä	30	43	30	51
5	Vöcklabruck	30	41	28	47
6	Spittal	30	37	43	45
7	Klagenfurt	30	45	46	44
8	Allerheilige	30	40	32	43
9	Sturm Graz	30	42	45	37
10	Union	30	35	50	35
11	Grieskirchen	30	33	38	34
12	Kärnten	30	35	46	34
13	Voitsberg	30	44	48	33
14	Blau-Weiß	30	33	38	33
15	Köflach	30	29	59	30
16	Union Perg	30	28	53	26

TEMPORADA 2005/2006

TERCERA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hartberg	30	54	28	63
2	Spittal	30	48	35	54
3	Feldkirchen	30	43	38	53
4	Voitsberg	30	44	38	48
5	Sankt Andrä	30	49	33	45
6	Union	30	45	33	44
7	Köflach	30	46	42	43
8	Wels	30	41	40	40
9	Klagenfurt	30	39	55	39
10	Bad Aussee	30	38	34	37
11	Sturm Graz	30	52	46	35
12	Blau-Weiß	30	32	42	34
13	Superfund	30	36	42	31
14	Vöcklabruck	30	37	49	31
15	Union Perg	30	27	43	31
16	Bleiburg	30	30	63	24

TEMPORADA 2004/2005

TERCERA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Schwanenstad	30	43	26	62
2	Hartberg	30	55	33	50
3	Spittal	30	56	43	48
4	Superfund	30	57	41	47
5	Köflach	30	42	32	47
6	Sturm Graz	30	49	46	44
7	Union	30	36	30	43
8	Bleiburg	30	37	52	40
9	Feldkirchen	30	46	55	38
10	Blau-Weiß	30	33	32	37
11	Sankt Andrä	30	36	41	37
12	Voitsberg	30	39	42	35
13	Wels	30	34	42	35
14	Union Perg	30	31	45	34
15	Kärnten	30	30	41	31
16	Kalsdorf	30	32	55	21

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

Competiciones que juega

Tercera Austria Grupo 1

Pos	Equipos		Pts
1		Blau-Weiß Linz	70
2		TSV Hartberg	60
3		Union St. Florian	52
4		Kalsdorf	51
5		SV Pasching	50
6		SV Lafnitz	49
7		Stadl-Paura	48
8		Allerheiligen	48
9		Deutschlandsberger	43
10		Gurten	40
11		Sturm Graz II	38
12		Vorwarts Steyr	34
13		Weiz	26
14		Wolfsberger AC II	23
15		SV Wallern	22
16		Annabichler Austria	19

RIVALES EN Tercera Austria

USO DE MEMORIA

6,565,672 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.5997
Total Execution Time	0.6012

CADENA URL

/historico/Sturm-Graz-A/2016

GET DATOS

$_GET['/historico/Sturm-Graz-A/2016']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0143	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 = 'Sturm-Graz-A' AND l.year = 2016 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.0128	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=12420 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=12420 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0267	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 15759
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12420 AND type_rel = 2
0.0141	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 = '12420' ORDER BY l.year DESC,cat.coefficient DESC
0.0129	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 = '12420' AND l.year = 2016 ORDER BY l.year DESC,cat.coefficient DESC
0.0128	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 = '12420' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 15759 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129	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=12420 AND l.year in (2015,2016,2017) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (33372,30386) 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.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 33372 AND teamId = 12420
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 30386 AND teamId = 12420
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 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 = 15759 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127	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 = '12420' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12420' and rp.type = 4
0.0127	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 = '12420' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0138	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 events2016 e ON e.player_id = p.id AND e.league_id = 15759 WHERE rp.league_id = 15759 AND rp.teamId = 12420 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 events2016 e ON e.player_id = p.id AND e.league_id = 15759 WHERE rp.league_id = 15759 AND rp.teamId = 12420 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132	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 events2016 e ON e.player_id = p.id AND e.league_id = 15759 WHERE rp.league_id = 15759 AND rp.teamId = 12420 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129	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 = 12420 AND l.year <= 2016 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 15759 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138	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 = 4155 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	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 = 2767 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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.0145	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.0138	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 = 24532 AND t.round = 30 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* `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 = 24535 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* `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 = 24538 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* `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 = 24541 AND t.round = 30 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* `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 = 27600 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138	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 = 27592 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* `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 = 27576 AND t.round = 30 ORDER BY team.conference 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* `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.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* `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.0126	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 = 15759 ORDER BY nameShow LIMIT 100

Sturm Graz II

Sturm Graz II

Selecciona un equipo

Competiciones que juega

Tercera Austria Grupo 1

RIVALES EN Tercera Austria