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

Langenrohr

Temporada 2023/2024

TEMPORADA 2023/2024

CUARTA AUSTRIA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Gloggnitz	23	43	19	51
2	Marathon	23	46	20	50
3	Schrems	23	47	23	45
4	Wiener	23	34	33	37
5	Kilb	22	36	23	36
6	Zwettl	23	39	38	34
7	Pölten	23	36	39	32
8	SC Retz	23	29	22	32
9	Ortmann	23	39	34	32
10	St. Peter	23	38	31	30
11	Rohrbach	23	28	33	28
12	Scheiblingki	23	27	33	28
13	Langenrohr	23	32	47	26
14	Kottingbrunn	23	24	28	23
15	Haitzendorf	22	23	44	14
16	Waidhofen	23	16	70	10

TEMPORADA 2022/2023

CUARTA AUSTRIA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Ardagger	28	43	17	60
2	Kottingbrunn	27	40	21	54
3	Gloggnitz	27	55	33	51
4	Zwettl	27	36	21	49
5	Langenrohr	28	45	26	48
6	Schrems	28	44	38	40
7	Ortmann	28	30	30	40
8	SC Retz	27	33	33	36
9	Rohrbach	28	28	35	32
10	Haitzendorf	28	48	45	31
11	Pölten	27	34	36	31
12	Waidhofen	27	26	36	30
13	Kilb	27	28	39	30
14	Spratzern	28	24	47	25
15	Mannersdorf	27	9	66	19

TEMPORADA 2021/2022

CUARTA AUSTRIA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Scheiblingki	28	65	21	76
2	Kremser SC	28	75	30	65
3	SC Retz	28	47	31	50
4	Ardagger	28	39	17	49
5	Pölten	28	61	37	40
6	Kottingbrunn	28	35	29	37
7	Ortmann	28	36	36	37
8	Langenrohr	28	40	45	37
9	Waidhofen	28	23	37	34
10	Kilb	28	39	49	32
11	Rohrbach	28	31	51	29
12	Spratzern	28	36	56	27
13	Zwettl	28	30	54	27
14	Schrems	28	34	52	26
15	Mannersdorf	28	16	62	12

TEMPORADA 2020/2021

CUARTA AUSTRIA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Mannersdorf	0	0	0	0
2	Spratzern	0	0	0	0
3	Scheiblingki	0	0	0	0
4	Kilb	0	0	0	0
5	SC Retz	0	0	0	0
6	Zwettl	0	0	0	0
7	Ardagger	0	0	0	0
8	Waidhofen	0	0	0	0
9	Schrems	0	0	0	0
10	Langenrohr	0	0	0	0
11	Ortmann	0	0	0	0
12	Kottingbrunn	0	0	0	0
13	Kremser SC	0	0	0	0
14	Rohrbach	0	0	0	0
15	Pölten	0	0	0	0

TEMPORADA 2019/2020

CUARTA AUSTRIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	SC Retz	16	33	18	34
2	Kottingbrunn	15	30	8	33
3	Rohrbach	16	37	20	33
4	Scheiblingki	17	33	19	31
5	Pölten	16	33	20	31
6	Kremser SC	16	36	14	29
7	Ardagger	16	20	14	23
8	Gaflenz	15	26	29	21
9	Kilb	17	23	31	20
10	Schrems	16	23	29	19
11	Zwettl	16	22	28	15
12	Langenrohr	16	20	30	13
13	Mannersdorf	16	17	31	12
14	Waidhofen	16	17	37	12
15	Ortmann	16	24	44	11
16	Spratzern	16	18	40	9

TEMPORADA 2018/2019

CUARTA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Stripfing	30	68	21	72
2	Kremser SC	30	66	44	59
3	SC Retz	30	52	36	55
4	Kottingbrunn	30	47	33	52
5	Waidhofen	30	55	40	51
6	Scheiblingki	30	57	51	46
7	Gaflenz	30	44	48	44
8	Ardagger	30	36	32	40
9	Zwettl	30	41	58	39
10	Langenrohr	30	42	43	36
11	Rohrbach	30	37	45	36
12	Kilb	30	40	54	36
13	Ortmann	30	42	53	33
14	Spratzern	30	32	57	29
15	St. Peter	30	29	52	25
16	Rohrendorf	30	43	64	22

TEMPORADA 2017/2018

CUARTA AUSTRIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Leobendorf	30	57	13	65
2	Stripfing	30	60	22	65
3	SC Retz	30	54	29	62
4	Kremser SC	30	58	30	60
5	Scheiblingki	30	55	41	53
6	Kottingbrunn	30	46	27	52
7	Gaflenz	30	62	55	45
8	Langenrohr	30	44	48	36
9	Waidhofen	30	40	54	34
10	St. Peter	30	43	56	30
11	Ardagger	30	28	41	30
12	Zwettl	30	32	61	27
13	Rohrendorf	30	38	51	26
14	Spratzern	30	21	52	26
15	Rohrbach	30	30	53	25
16	Haitzendorf	30	23	58	23

TEMPORADA 2016/2017

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bruck/Leitha	30	78	34	65
2	Leobendorf	30	77	35	65
3	SC Retz	30	58	32	58
4	Kremser SC	30	61	30	57
5	Stripfing	30	60	49	45
6	Kottingbrunn	30	49	39	43
7	Ardagger	30	41	53	40
8	Haitzendorf	30	53	63	36
9	Spratzern	30	41	52	34
10	Rohrendorf	30	40	60	34
11	Zwettl	30	41	49	33
12	Langenrohr	30	39	52	33
13	Gaflenz	30	38	57	33
14	Waidhofen	30	47	72	33
15	St. Peter	30	37	59	31
16	Würmla	30	33	57	24

TEMPORADA 2015/2016

CUARTA AUSTRIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Marchfeld	30	73	30	68
2	Leobendorf	30	84	28	59
3	Kremser SC	30	61	42	56
4	Kottingbrunn	30	63	43	55
5	Spratzern	30	43	36	48
6	SC Retz	30	42	34	46
7	Zwettl	30	47	37	43
8	Traiskirchen	30	46	33	42
9	Langenrohr	30	53	47	33
10	Waidhofen	30	42	58	33
11	Ardagger	30	43	62	33
12	Würmla	30	46	60	32
13	St. Peter	30	42	68	31
14	Gaflenz	30	34	65	27
15	Haitzendorf	30	39	69	21
16	ATSV	30	7	53	20

TEMPORADA 2014/2015

CUARTA AUSTRIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Ebreichsdorf	30	82	32	69
2	Kremser SC	30	95	30	68
3	Kottingbrunn	30	71	35	59
4	Leobendorf	30	71	45	48
5	St. Peter	30	49	43	43
6	Langenrohr	30	45	57	43
7	Zwettl	30	47	41	42
8	Marchfeld	30	58	55	42
9	Gaflenz	30	48	49	42
10	SC Retz	30	50	52	42
11	Würmla	30	40	45	39
12	Ardagger	30	42	65	35
13	Spratzern	30	40	62	28
14	Waidhofen	30	42	74	27
15	Ober-Grafend	30	45	102	26
16	Bad Vöslau	30	33	71	21

TEMPORADA 2013/2014

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Pölten	29	79	23	65
2	Leobendorf	29	66	28	62
3	Gaflenz	29	72	39	61
4	Kottingbrunn	29	64	31	61
5	Würmla	29	67	41	57
6	Ardagger	29	58	36	50
7	Langenrohr	29	41	47	44
8	Marchfeld	29	53	52	39
9	Waidhofen	29	48	56	38
10	St. Peter	29	39	47	34
11	Zwettl	29	43	54	34
12	Bad Vöslau	29	41	55	33
13	Spratzern	29	40	61	28
14	Mistelbach	29	32	50	27
15	Schwadorf	29	19	65	13
16	Götzendorf	29	11	88	7

TEMPORADA 2012/2013

CUARTA AUSTRIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Ober-Grafend	30	66	36	65
2	Marchfeld	30	61	36	58
3	Bad Vöslau	30	46	27	58
4	Ardagger	30	51	49	44
5	Zwettl	30	50	52	44
6	St. Peter	30	47	43	43
7	Langenrohr	30	40	34	42
8	Würmla	30	53	50	42
9	Pölten	30	48	46	41
10	Kottingbrunn	30	33	27	40
11	Gaflenz	30	41	50	36
12	Waidhofen	30	48	55	34
13	Leobendorf	30	34	48	31
14	Götzendorf	30	30	51	30
15	Schwadorf	30	33	57	30
16	Stockerau	30	44	64	29

TEMPORADA 2011/2012

CUARTA AUSTRIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	SC Retz	30	72	39	61
2	Gaflenz	30	71	40	60
3	Bad Vöslau	30	64	38	55
4	Ardagger	30	54	40	53
5	Kottingbrunn	30	65	44	50
6	Pölten	30	54	43	47
7	Zwettl	30	59	54	45
8	Langenrohr	30	50	54	44
9	Leobendorf	30	65	58	42
10	Götzendorf	30	54	54	39
11	St. Peter	30	42	44	34
12	Würmla	30	54	67	34
13	Schwadorf	30	31	52	29
14	Waidhofen	30	39	67	26
15	Stockerau	30	28	66	25
16	Mistelbach	30	34	76	19

TEMPORADA 2010/2011

CUARTA AUSTRIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Amstetten	30	74	36	58
2	SC Retz	30	63	46	58
3	Götzendorf	30	47	34	52
4	Bad Vöslau	30	41	29	50
5	Mistelbach	30	56	47	47
6	Zwettl	30	52	46	47
7	Pölten	30	50	50	41
8	Schwadorf	30	48	49	40
9	Langenrohr	30	41	44	40
10	Gaflenz	30	54	60	39
11	Würmla	30	37	44	37
12	Kottingbrunn	30	35	37	35
13	Ardagger	30	41	34	34
14	Stockerau	30	46	60	32
15	St. Peter	30	52	58	31
16	Vösendorf	30	19	82	14

TEMPORADA 2009/2010

CUARTA AUSTRIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Sollenau	30	75	37	64
2	Amstetten	30	65	26	62
3	Mistelbach	30	58	30	53
4	SC Retz	30	54	37	52
5	Langenrohr	30	48	44	48
6	Pölten	30	53	47	45
7	Ardagger	30	35	38	36
8	Stockerau	30	40	51	36
9	Vösendorf	30	44	56	36
10	Bad Vöslau	30	36	45	35
11	Kottingbrunn	30	40	43	34
12	Götzendorf	30	37	51	34
13	Haitzendorf	30	31	48	34
14	Schrems	30	44	63	34
15	Leobendorf	30	35	51	28
16	Herzogenburg	30	45	73	25

TEMPORADA 2008/2009

CUARTA AUSTRIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Gaflenz	30	59	34	61
2	Sollenau	30	66	41	56
3	Kottingbrunn	30	63	43	56
4	Schrems	30	58	45	53
5	Leobendorf	30	43	30	52
6	Vösendorf	30	41	35	43
7	Langenrohr	30	52	50	43
8	Ardagger	30	40	41	43
9	Mistelbach	30	40	40	41
10	Götzendorf	30	42	46	41
11	SC Retz	30	41	45	39
12	Haitzendorf	30	36	42	32
13	Herzogenburg	30	40	61	29
14	Stockerau	30	33	47	28
15	Kremser SC	30	33	52	24
16	Ortmann	30	23	58	19

Competiciones que juega

Grupo 7

Cuarta Austria Grupo 7

Pos	Equipos		Pts
1		Gloggnitz	51
2		Marathon Korneuburg	50
3		Schrems	45
4		Wiener Neustadt	37
5		Kilb	36
6		Zwettl	34
7		St. Pölten II	32
8		SC Retz	32
9		Ortmann	32
10		St. Peter	30
11		Rohrbach	28
12		Scheiblingkirchen-Warth	28
13		Langenrohr	26
14		Kottingbrunn	23
15		SV Haitzendorf	14
16		Waidhofen / Thaya	10

RIVALES EN Cuarta Austria

USO DE MEMORIA

6,838,824 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.6121
Total Execution Time	0.6134

CADENA URL

/historico/Langenrohr

GET DATOS

$_GET['/historico/Langenrohr']

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0165	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 = 'Langenrohr' 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.0148	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=17509 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=17509 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=17509 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0301	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 = 73019
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17509 AND type_rel = 2
0.0149	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 = '17509' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0149	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 = '17509' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147	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 = 73019 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146	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 = '17509' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146	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 = '17509' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0154	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 = 73019 WHERE rp.league_id = 73019 AND rp.teamId = 17509 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.0152	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 = 73019 WHERE rp.league_id = 73019 AND rp.teamId = 17509 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154	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 = 73019 WHERE rp.league_id = 73019 AND rp.teamId = 17509 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149	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 = 17509 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150	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 = 73019 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 68332 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.0149	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 = 63697 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.0149	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 = 57783 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.0155	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 = 50450 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159	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 = 44307 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163	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 = 38912 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165	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 = 33426 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163	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 = 15768 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 3938 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 3583 AND t.round = 29 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163	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 = 27174 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163	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 = 27210 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163	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 = 27227 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	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 = 27243 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159	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 = 27260 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Langenrohr

Langenrohr

Selecciona un equipo

Competiciones que juega

Cuarta Austria Grupo 7

RIVALES EN Cuarta Austria