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

Gerasdorf Stammersdorf

Temporada 2023/2024

TEMPORADA 2023/2024

CUARTA AUSTRIA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Sportunion	23	63	8	62
2	Dinamo	23	57	19	56
3	Slovan HAC	23	57	44	41
4	1980 Wien	23	47	31	40
5	Stadlau	24	36	29	39
6	Star Penzing	23	46	38	36
7	Donau	23	47	34	35
8	Mannswörth	24	30	42	34
9	Gerasdorf	24	30	36	31
10	Schwechat	24	37	47	29
11	Vorwärts	23	33	43	25
12	Wienerberg	23	30	40	25
13	Austria XIII	23	30	40	24
14	Simmeringer	24	26	47	20
15	Kagran	24	33	64	18
16	ASV 13	23	22	62	13

TEMPORADA 2022/2023

CUARTA AUSTRIA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Favoritner	30	82	46	69
2	Sportunion	30	81	28	68
3	Schwechat	30	64	33	58
4	Donau	29	54	31	51
5	Dinamo	30	58	43	50
6	Stadlau	30	54	41	45
7	Slovan HAC	30	64	50	44
8	Simmeringer	30	45	47	39
9	Austria XIII	30	54	65	39
10	1980 Wien	30	50	68	35
11	Wienerberg	30	51	61	32
12	Gerasdorf	30	47	55	31
13	ASV 13	30	45	75	31
14	Mannswörth	30	37	64	27
15	Vorwärts	30	40	76	27
16	Post	29	36	79	17

TEMPORADA 2021/2022

CUARTA AUSTRIA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Donaufeld	30	97	28	77
2	Donau	30	54	28	59
3	Sportunion	30	53	26	58
4	Schwechat	30	62	31	51
5	Dinamo	30	53	35	48
6	Austria XIII	30	53	50	46
7	Stadlau	30	43	37	44
8	Slovan HAC	30	71	70	43
9	Vorwärts	30	48	54	35
10	Post	30	48	56	34
11	Wienerberg	30	37	46	33
12	Gerasdorf	30	32	54	29
13	Favoritner	30	39	67	29
14	ASV 13	30	38	84	26
15	Ostbahn XI	30	40	68	25
16	Mannswörth	30	30	64	25

TEMPORADA 2020/2021

CUARTA AUSTRIA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	First Vienna	15	58	9	42
2	Wienerberg	15	35	14	34
3	Sportunion	15	32	16	31
4	Elektra	15	37	19	28
5	Donaufeld	15	30	18	28
6	Austria XIII	15	26	14	28
7	Stadlau	15	31	24	27
8	Schwechat	15	26	19	27
9	Favoritner	15	22	28	17
10	Vorwärts	15	27	36	14
11	Mannswörth	15	21	35	13
12	Donau	15	10	21	12
13	Slovan HAC	15	16	41	12
14	ASV 13	15	13	34	9
15	Gerasdorf	15	18	40	6
16	Post	15	5	39	5

TEMPORADA 2019/2020

CUARTA AUSTRIA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	First Vienna	17	47	11	43
2	Austria XIII	17	47	17	37
3	Elektra	17	38	16	32
4	Slovan HAC	17	23	18	27
5	Donau	17	25	25	26
6	Gerasdorf	17	29	31	25
7	Donaufeld	17	30	27	23
8	Schwechat	17	20	17	22
9	ASV 13	17	26	45	21
10	Mannswörth	17	27	31	20
11	Sportunion	17	22	31	18
12	Vorwärts	16	29	31	15
13	Favoritner	16	22	30	15
14	Stadlau	17	24	34	14
15	Wienerberg	17	25	46	14
16	Post	17	16	40	14

TEMPORADA 2018/2019

CUARTA AUSTRIA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Wiener	30	78	33	72
2	Elektra	30	67	21	71
3	Wienerberg	30	58	44	52
4	Austria XIII	30	63	38	51
5	Mannswörth	30	60	44	47
6	Favoritner	30	45	45	46
7	Gerasdorf	30	54	42	41
8	Slovan HAC	30	53	52	41
9	Donaufeld	30	44	49	41
10	Vorwärts	30	53	57	39
11	Donau	30	46	56	33
12	Sportunion	30	46	59	31
13	Post	30	34	55	31
14	ASV 13	30	37	56	29
15	Ostbahn XI	30	34	60	23
16	Mauerwerk	30	28	89	21

TEMPORADA 2017/2018

CUARTA AUSTRIA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Team Wiener	30	89	38	62
2	Elektra	30	57	28	59
3	Favoritner	30	65	42	56
4	Donaufeld	30	70	42	54
5	Technopool	30	45	55	47
6	Wienerberg	30	67	54	46
7	Gerasdorf	30	59	56	44
8	Slovan HAC	30	50	48	44
9	Austria XIII	30	56	50	39
10	Wiener	30	66	61	39
11	Mannswörth	30	50	60	36
12	Post	30	41	59	32
13	Sportunion	30	46	70	28
14	Donau	30	36	63	27
15	Ostbahn XI	30	36	68	25
16	Gersthofer	30	42	81	21

TEMPORADA 2016/2017

CUARTA AUSTRIA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Karabakh	30	80	21	71
2	Elektra	30	59	38	56
3	Mannswörth	30	57	42	55
4	Team Wiener	30	60	49	50
5	Donaufeld	30	51	33	49
6	Austria XIII	30	50	47	46
7	Ostbahn XI	30	59	53	43
8	Wiener	30	55	77	41
9	Wienerberg	30	69	42	38
10	Post	30	46	53	38
11	Favoritner	30	53	51	37
12	Gerasdorf	30	41	44	37
13	Gersthofer	30	33	54	31
14	Admira	30	27	50	25
15	Sportunion	30	36	80	23
16	Simmeringer	30	33	75	21

TEMPORADA 2015/2016

CUARTA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Wienerberg	30	65	33	62
2	Team Wiener	30	65	44	55
3	Donaufeld	30	60	45	54
4	Elektra	30	69	42	50
5	Austria XIII	30	54	37	49
6	Gerasdorf	30	50	42	46
7	Wiener	30	51	50	42
8	Sportunion	30	48	49	42
9	Post	30	42	57	40
10	Gersthofer	30	44	53	39
11	Mannswörth	30	36	38	38
12	Admira	30	52	54	36
13	Favoritner	30	29	50	34
14	Simmeringer	30	40	55	27
15	Ostbahn XI	30	40	62	24
16	ASV 13	30	40	74	24

TEMPORADA 2014/2015

CUARTA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Stadlau	30	70	23	69
2	Admira	30	56	40	56
3	Mannswörth	30	48	31	49
4	Austria XIII	30	49	31	47
5	Wienerberg	30	46	45	47
6	Team Wiener	30	52	44	46
7	Elektra	30	49	46	46
8	Gerasdorf	30	46	40	44
9	Gersthofer	30	37	41	42
10	Ostbahn XI	30	44	44	40
11	Simmeringer	30	44	51	33
12	Wiener	30	27	44	32
13	Favoritner	30	35	49	31
14	ASV 13	30	34	56	29
15	Post	30	27	50	28
16	Donau	30	28	57	18

TEMPORADA 2013/2014

CUARTA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Donaufeld	29	74	30	69
2	Stadlau	29	58	18	57
3	Team Wiener	29	71	43	52
4	Admira	29	49	37	52
5	Ostbahn XI	29	62	38	51
6	Gerasdorf	29	49	34	48
7	Austria XIII	29	38	29	45
8	Favoritner	29	40	42	45
9	Post	29	59	53	44
10	Mannswörth	29	46	56	40
11	Donau	29	37	34	37
12	Wienerberg	29	40	40	37
13	First Vienna	29	45	58	29
14	Gersthofer	29	33	48	27
15	Simmeringer	29	21	81	10
16	NAC	29	15	96	7

TEMPORADA 2012/2013

CUARTA AUSTRIA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Wiener	30	84	28	68
2	Post	30	59	33	60
3	Stadlau	30	60	27	59
4	Donaufeld	30	65	40	54
5	Team Wiener	30	57	35	51
6	Favoritner	30	57	50	50
7	Donau	30	47	41	49
8	NAC	30	68	49	47
9	Admira	30	51	44	43
10	Austria XIII	30	52	51	39
11	Gersthofer	30	32	48	32
12	Gerasdorf	30	43	63	31
13	First Vienna	30	37	61	30
14	Fortuna 05	30	35	72	25
15	Slovan-Hütt	30	37	78	20
16	Columbia	30	25	89	11

TEMPORADA 2011/2012

CUARTA AUSTRIA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Ostbahn XI	30	71	38	63
2	NAC	30	68	33	59
3	Stadlau	30	48	22	54
4	Team Wiener	30	41	31	52
5	Post	30	54	38	51
6	Austria XIII	30	56	45	49
7	Donaufeld	30	54	44	47
8	Gerasdorf	30	54	48	42
9	Donau	30	31	37	41
10	Gersthofer	30	31	35	40
11	Admira	30	46	40	37
12	Fortuna 05	30	50	55	37
13	Favoritner	30	40	50	37
14	Slovan HAC	30	31	68	25
15	Wienerberg	30	30	61	18
16	LAC-IC	30	24	84	14

TEMPORADA 2010/2011

CUARTA AUSTRIA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Simmeringer	30	81	20	75
2	Admira	30	65	41	54
3	Post	30	49	28	54
4	Team Wiener	30	57	34	52
5	LAC-IC	30	56	50	49
6	Stadlau	30	65	39	46
7	Favoritner	30	64	56	45
8	Gersthofer	30	49	45	45
9	Donaufeld	30	42	51	43
10	Süssenbrunn	30	47	49	42
11	Wienerberg	30	48	58	39
12	Gerasdorf	30	41	61	33
13	Fortuna 05	30	35	58	29
14	Slovan-Hütt	30	30	52	24
15	Mannswörth	30	32	65	22
16	Rennweger	30	21	75	21

TEMPORADA 2009/2010

CUARTA AUSTRIA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Columbia	30	66	32	65
2	Post	30	60	25	59
3	Simmeringer	30	59	32	58
4	Stadlau	30	66	29	52
5	Admira	30	75	46	52
6	Favoritner	30	65	45	51
7	Favoriten	30	64	52	49
8	Slovan HAC	30	47	43	46
9	Rennweger	30	70	59	43
10	Fortuna 05	30	55	76	41
11	Mannswörth	30	48	56	39
12	Gersthofer	30	35	53	34
13	Donaufeld	30	43	55	29
14	Gerasdorf	30	40	68	29
15	Ankerbrot	30	34	71	25
16	Aspern	30	24	109	4

TEMPORADA 2008/2009

CUARTA AUSTRIA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Schwechat	30	72	13	72
2	Stadlau	30	73	28	62
3	Post	30	59	27	54
4	Favoriten	30	63	45	54
5	Admira	30	57	41	50
6	Fortuna 05	30	59	50	47
7	Columbia	30	39	30	46
8	Donaufeld	30	48	32	45
9	Rennweger	29	62	52	45
10	Gersthofer	30	44	48	41
11	Mannswörth	29	48	49	38
12	Ankerbrot	30	37	56	33
13	Favoritner	30	27	53	26
14	Gerasdorf	30	37	69	24
15	Slovan HAC	30	33	82	19
16	Donau	30	34	117	10

TEMPORADA 1997/1998

SEGUNDA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Vorwarts	28	59	30	54
2	Spittal	28	52	30	50
3	First Vienna	28	44	26	46
4	Braunau	28	42	27	46
5	SW Bregenz	28	44	31	45
6	Leoben	28	40	43	41
7	Stockerau	28	44	45	40
8	Gerasdorf	28	49	47	39
9	Polten	28	32	40	39
10	SCR Altach	28	30	31	38
11	Hartberg	28	35	39	35
12	WSG Tirol	28	32	36	34
13	Kufstein	28	22	37	28
14	Kottingbrunn	28	28	60	19
15	Eintracht	28	24	55	18

TEMPORADA 1996/1997

SEGUNDA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Austria	30	60	18	65
2	Vorwarts	30	65	26	60
3	First Vienna	30	67	31	58
4	Gerasdorf	30	54	38	51
5	Spittal	30	43	26	50
6	Polten	30	54	49	48
7	SW Bregenz	30	39	38	43
8	Stockerau	30	39	36	42
9	Braunau	30	36	35	41
10	Kufstein	30	29	42	41
11	WSG Tirol	30	41	45	38
12	Leoben	30	35	37	35
13	Modling	30	35	55	34
14	Hartberg	30	34	48	30
15	Flavia Solva	30	19	69	15
16	Favoritner	30	16	73	12

TEMPORADA 1995/1996

SEGUNDA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	FC Linz	30	62	27	68
2	Gerasdorf	30	54	25	56
3	First Vienna	30	48	39	48
4	Modling	30	45	33	46
5	Leoben	30	41	33	44
6	Favoritner	30	38	31	44
7	Austria	30	34	24	40
8	Braunau	30	39	40	38
9	WSG Tirol	30	34	34	36
10	Flavia Solva	30	21	37	36
11	Spittal	30	35	42	35
12	Kufstein	30	33	42	35
13	Polten	30	36	51	34
14	Klagenfurt	30	30	50	32
15	Oberwart	30	33	49	30
16	Klingenbach	30	28	54	20

Competiciones que juega

Grupo 9

Cuarta Austria Grupo 9

Pos	Equipos		Pts
1		Sportunion Mauer	62
2		Dinamo Helfort 15	56
3		Slovan HAC	41
4		1980 Wien	40
5		Stadlau	39
6		Red Star Penzing	36
7		Donau	35
8		Mannswörth	34
9		Gerasdorf Stammersdorf	31
10		Schwechat	29
11		Vorwärts Brigittenau	25
12		Wienerberg	25
13		Austria XIII	24
14		Simmeringer SC	20
15		Kagran	18
16		ASV 13	13

RIVALES EN Cuarta Austria

USO DE MEMORIA

7,303,944 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1276
Total Execution Time	0.1288

CADENA URL

/historico/Gerasdorf-Stammersdorf

GET DATOS

$_GET['/historico/Gerasdorf-Stammersdorf']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0036	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 = 'Gerasdorf-Stammersdorf' 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.0018	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=17542 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=17542 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=17542 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039	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 = 73021
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17542 AND type_rel = 2
0.0025	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 = '17542' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '17542' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 73021 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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=17542 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 (73021,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.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 73021 AND teamId = 17542
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17542
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 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 = 73021 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = 73021 WHERE rp.league_id = 73021 AND rp.teamId = 17542 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.0026	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 = 73021 WHERE rp.league_id = 73021 AND rp.teamId = 17542 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	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 = 73021 WHERE rp.league_id = 73021 AND rp.teamId = 17542 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 17542 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73021 AND t.round = 24 ORDER BY team.conference ASC,t.position 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* `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 = 68331 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.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* `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 = 63698 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.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* `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 = 57784 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.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* `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 = 50455 AND t.round = 17 ORDER BY team.conference ASC,t.position 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* `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 = 44312 AND t.round = 30 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* `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 = 38915 AND t.round = 30 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* `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 = 38906 AND t.round = 30 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* `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 = 15765 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* `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 = 3937 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 3585 AND t.round = 29 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* `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 = 27184 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* `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 = 27219 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* `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 = 27236 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* `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 = 27253 AND t.round = 30 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* `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 = 27271 AND t.round = 30 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* `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 = 10041 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* `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 = 10042 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* `tables1996` 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 = 10043 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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 = 73021 ORDER BY nameShow LIMIT 100

Gerasdorf Stammersdorf

Gerasdorf Stammersdorf

Selecciona un equipo

Competiciones que juega

Cuarta Austria Grupo 9

RIVALES EN Cuarta Austria