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

Kalsdorf

Temporada 2023/2024

TEMPORADA 2023/2024

CUARTA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Tillmitsch	24	44	25	46
2	Hartberg II	24	60	48	41
3	Wildon	24	50	33	41
4	Kalsdorf	24	48	42	40
5	Lafnitz II	24	52	40	39
6	Fehring	24	35	31	37
7	Lebring	24	48	43	36
8	Köflach	24	38	24	35
9	Schladming	24	37	46	34
10	Fürstenfeld	24	38	35	34
11	Ilzer SV	24	35	37	34
12	Union	24	50	38	34
13	Heiligenkreu	24	47	52	33
14	SC Bruck	24	39	48	26
15	Union Gnas	24	26	62	18
16	Frauental	24	20	63	14

TEMPORADA 2022/2023

TERCERA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Leoben	30	76	22	72
2	Juniors	30	84	30	69
3	Hertha Wels	30	63	35	63
4	Gurten	30	44	29	55
5	Gleichenberg	30	65	56	49
6	Deutschlands	30	53	46	47
7	SV Ried II	30	47	47	47
8	Weindorf	30	48	53	39
9	Wolfsberger	30	49	48	36
10	Gleisdorf	30	49	50	36
11	Vöcklamarkt	30	29	44	33
12	Weiz	30	45	64	31
13	Allerheilige	30	35	56	28
14	Treibach	30	37	65	25
15	Kalsdorf	30	30	70	23
16	Klagenfurt	30	29	68	14

TEMPORADA 2021/2022

TERCERA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Sturm Graz	32	105	29	72
2	Deutschlands	32	62	26	63
3	Gurten	32	63	31	62
4	Hertha Wels	32	64	34	56
5	Sankt Andrä	32	71	50	56
6	Vöcklamarkt	32	46	41	52
7	Gleichenberg	32	56	47	51
8	Allerheilige	32	52	48	47
9	Weindorf	32	61	54	44
10	Gleisdorf	32	50	53	44
11	Weiz	32	47	56	43
12	SV Ried II	32	50	63	36
13	Kalsdorf	32	46	54	35
14	Treibach	32	56	73	35
15	Wels	32	47	71	33
16	Spittal	32	25	60	18
17	Stadl-Paura	32	18	129	6

TEMPORADA 2020/2021

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Gleisdorf	13	26	17	27
2	Weindorf	12	33	15	26
3	Gleichenberg	13	31	18	26
4	Gurten	13	22	13	26
5	Hertha Wels	14	34	23	25
6	Sturm Graz	13	23	17	23
7	Kalsdorf	13	20	19	22
8	Wolfsberger	13	21	18	18
9	Weiz	13	24	20	16
10	Deutschlands	13	29	27	16
11	Allerheilige	11	26	24	13
12	SV Ried II	12	20	28	12
13	Stadl-Paura	13	20	32	11
14	Spittal	12	10	25	9
15	Vöcklamarkt	13	11	28	8
16	Wels	13	14	40	7

TEMPORADA 2019/2020

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sturm Graz	17	39	20	34
2	Allerheilige	17	35	23	33
3	Hertha Wels	17	42	26	32
4	Gurten	17	35	19	31
5	Gleichenberg	17	44	33	29
6	Wolfsberger	17	39	30	29
7	Vöcklamarkt	17	41	34	29
8	Weindorf	17	29	20	28
9	Weiz	17	37	29	27
10	Gleisdorf	17	34	26	27
11	Deutschlands	17	31	24	22
12	Kalsdorf	17	18	28	20
13	SV Ried II	17	25	32	15
14	ATSV	17	26	36	14
15	Stadl-Paura	17	15	72	7
16	Wels	17	13	51	6

TEMPORADA 2018/2019

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Grazer AK	30	70	28	68
2	Gleisdorf	30	62	37	54
3	Gleichenberg	30	70	51	51
4	Vöcklamarkt	30	61	48	51
5	Stadl-Paura	30	56	51	51
6	Allerheilige	30	53	37	48
7	Sturm Graz	30	60	46	47
8	Wolfsberger	30	61	48	46
9	Weiz	30	65	54	45
10	Deutschlands	30	57	52	44
11	Gurten	30	41	41	39
12	Hertha Wels	30	56	64	38
13	Kalsdorf	30	43	56	35
14	Völkermarkt	30	31	73	20
15	Lendorf	30	32	77	20
16	Wels	30	30	85	16

TEMPORADA 2017/2018

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	SV Lafnitz	30	70	16	67
2	Gleisdorf	30	60	33	57
3	Vorwarts	30	70	38	55
4	Juniors	30	54	46	52
5	Austria	30	57	48	48
6	Allerheilige	30	59	41	47
7	Vöcklamarkt	30	52	43	47
8	Deutschlands	30	50	43	47
9	Sturm Graz	30	45	48	42
10	Gleichenberg	30	44	54	39
11	Gurten	30	45	46	37
12	Wolfsberger	30	41	63	33
13	Weiz	30	43	58	32
14	Kalsdorf	30	36	52	29
15	Stadl-Paura	30	32	67	27
16	Union	30	14	76	13

TEMPORADA 2016/2017

TERCERA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Hartberg	30	74	38	62
2	SV Lafnitz	30	54	27	60
3	Gleisdorf	30	53	35	59
4	Stadl-Paura	30	75	53	51
5	Deutschlands	30	65	45	46
6	Vorwarts	30	56	49	44
7	Kalsdorf	30	38	35	44
8	Gurten	30	39	43	42
9	Union	30	36	46	39
10	Sturm Graz	30	42	51	38
11	Weiz	30	40	52	38
12	Austria	30	43	61	35
13	Allerheilige	30	46	60	33
14	SV Pasching	30	43	49	31
15	Grieskirchen	30	44	64	23
16	ATSV	30	25	65	19

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

CUARTA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Kalsdorf	30	74	38	64
2	Weiz	30	67	36	55
3	Liezen	30	57	33	54
4	Gleisdorf	30	62	32	51
5	Voitsberg	30	57	42	46
6	Fürstenfeld	30	51	54	46
7	SV Lafnitz	30	64	59	44
8	Kindberg	30	50	47	43
9	Anger	30	60	56	42
10	Frohnleiten	30	41	44	39
11	SV Pachern	30	43	65	35
12	Wildon	30	56	62	34
13	Gratkorn II	30	42	73	33
14	Irdning	30	32	69	28
15	Grossklein	30	49	68	26
16	Mürzhofen/A	30	36	63	26

TEMPORADA 2010/2011

CUARTA AUSTRIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Kapfenberger	30	69	35	62
2	Frohnleiten	30	42	26	51
3	Gleisdorf	30	50	38	48
4	SV Pachern	30	48	45	47
5	Kindberg	30	47	45	47
6	Liezen	30	49	39	45
7	Wildon	30	54	48	45
8	Fürstenfeld	30	50	39	44
9	Anger	30	48	45	42
10	Gratkorn II	30	59	49	41
11	Kalsdorf	30	39	42	37
12	Irdning	30	39	47	35
13	TSV Pöllau	30	40	55	31
14	Fehring	30	39	56	29
15	Köflach	30	32	63	25
16	Flavia Solva	30	34	67	25

TEMPORADA 2009/2010

CUARTA AUSTRIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Gleinstätte	30	67	33	58
2	Kapfenberger	30	54	34	56
3	Irdning	30	51	37	50
4	Fürstenfeld	30	54	48	46
5	Kalsdorf	30	51	48	45
6	Anger	30	42	44	44
7	Gleisdorf	30	45	35	43
8	Gratkorn II	30	49	47	43
9	Köflach	30	44	48	41
10	Fehring	30	38	44	41
11	Wildon	30	58	54	40
12	SV Pachern	30	49	52	38
13	Liezen	30	43	48	36
14	Grossklein	30	32	44	36
15	SC Bruck	30	29	49	20
16	Grazer	30	29	70	16

TEMPORADA 2008/2009

CUARTA AUSTRIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Flavia Solva	30	54	34	52
2	Kalsdorf	29	56	38	52
3	Fürstenfeld	30	55	50	51
4	Gleisdorf	30	47	40	50
5	Fehring	30	57	47	47
6	Gleinstätte	30	64	48	46
7	SC Bruck	30	40	34	46
8	Köflach	30	52	49	41
9	Gratkorn II	30	55	50	40
10	Wildon	30	40	47	39
11	Grazer	30	53	46	37
12	Irdning	30	32	41	36
13	Kapfenberger	29	44	53	34
14	Grossklein	30	40	52	34
15	Deutschlands	30	40	64	32
16	Hartberg II	30	33	69	25

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

Competiciones que juega

Grupo 3

Cuarta Austria Grupo 3

Pos	Equipos		Pts
1		SV Tillmitsch	46
2		Hartberg II	41
3		Wildon	41
4		Kalsdorf	40
5		Lafnitz II	39
6		Fehring	37
7		Lebring	36
8		Köflach	35
9		FC Schladming	34
10		SC Fürstenfeld	34
11		Ilzer SV	34
12		Union Gamlitz	34
13		TUS Heiligenkreuz	33
14		SC Bruck	26
15		SV Union Gnas	18
16		Frauental	14

RIVALES EN Cuarta Austria

USO DE MEMORIA

7,034,720 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1405
Total Execution Time	0.1417

CADENA URL

/historico/Kalsdorf

GET DATOS

$_GET['/historico/Kalsdorf']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

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 = 'Kalsdorf' 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.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=12418 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=12418 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=12418 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043	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 = 73015
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12418 AND type_rel = 2
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 = '12418' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '12418' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 73015 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037	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=12418 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (73015,71432,68176) 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.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 68176 AND teamId = 12418
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 73015 AND teamId = 12418
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12418
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 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 = 73015 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022	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 = '12418' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12418' and rp.type = 4
0.0022	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 = '12418' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0059	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 = 73015 WHERE rp.league_id = 73015 AND rp.teamId = 12418 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.0037	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 = 73015 WHERE rp.league_id = 73015 AND rp.teamId = 12418 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 = 73015 WHERE rp.league_id = 73015 AND rp.teamId = 12418 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 = 12418 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73015 AND t.round = 25 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* `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 = 68176 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 = 63402 AND t.round = 34 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* `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 = 57019 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 = 50223 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.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* `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 = 44211 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* `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 = 38883 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 = 33372 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* `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.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 = 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.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* `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.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* `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.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 = 27202 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 = 27218 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* `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 = 27238 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* `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 = 27261 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* `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.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 = 73015 ORDER BY nameShow LIMIT 100

Kalsdorf

Kalsdorf

Selecciona un equipo

Competiciones que juega

Cuarta Austria Grupo 3

RIVALES EN Cuarta Austria