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

Spittal

Temporada 2023/2024

TEMPORADA 2023/2024

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Atus Velden	23	48	17	46
2	Treibach	23	49	27	44
3	Bleiburg	23	38	25	36
4	Ferlach	23	36	36	35
5	Köttmannsdo	23	28	37	34
6	ATSV	23	48	43	34
7	Spittal	22	46	36	34
8	Klagenfurt	23	41	37	32
9	Donau	23	35	39	30
10	KAC	23	33	36	30
11	Austria	23	24	29	29
12	Völkermarkt	23	35	44	27
13	Lendorf	23	31	38	27
14	Kraig	22	33	42	23
15	Landskron	23	27	47	22
16	St. Jakob	23	29	48	18

TEMPORADA 2022/2023

CUARTA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Klagenfu	32	74	36	65
2	Spittal	32	77	46	56
3	Austria	32	63	43	54
4	Ferlach	32	52	40	54
5	KAC	32	45	42	45
6	Lendorf	32	57	45	44
7	ATSV	32	69	64	44
8	St. Jakob	32	61	57	44
9	Kraig	32	39	64	43
10	Bleiburg	32	48	49	42
11	Köttmannsdo	32	56	58	42
12	Völkermarkt	32	49	58	42
13	Landskron	32	53	67	41
14	Feldkirchen	32	39	43	39
15	Maria Saal	32	58	77	38
16	Andra	32	50	73	30
17	ASKÖ Gmünd	32	26	54	29

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

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	ASKÖ Gmünd	16	30	14	33
2	St. Jakob	16	33	20	32
3	Treibach	16	33	23	30
4	Ferlach	16	25	19	27
5	Lendorf	16	29	21	25
6	Bleiburg	16	23	21	25
7	St. Michael	16	27	29	25
8	Maria Saal	16	31	24	22
9	Dellach	16	38	34	22
10	Spittal	16	28	28	21
11	Völkermarkt	16	21	23	21
12	Feldkirchen	16	24	32	18
13	KAC	16	18	27	17
14	Köttmannsdo	16	12	19	12
15	Kraig	16	16	37	11
16	Klagenfurt	16	17	34	10

TEMPORADA 2018/2019

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	ATSV	30	67	28	64
2	Treibach	30	96	41	63
3	Klagenfurt	30	46	41	53
4	Köttmannsdo	30	50	32	49
5	KAC	30	45	37	48
6	Maria Saal	30	65	50	47
7	Ferlach	30	57	49	47
8	ASKÖ Gmünd	30	42	49	47
9	Spittal	30	45	36	46
10	St. Jakob	30	45	61	37
11	Feldkirchen	30	40	44	34
12	Bleiburg	30	32	58	32
13	St. Michael	30	42	67	31
14	Matrei	30	47	63	27
15	ASKO	30	38	67	26
16	Lind	30	35	69	21

TEMPORADA 2017/2018

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Lendorf	30	60	30	59
2	Völkermarkt	30	61	35	58
3	Klagenfurt	30	56	30	52
4	Maria Saal	30	58	53	48
5	Feldkirchen	30	56	43	47
6	Treibach	30	55	39	43
7	ATSV	30	49	40	43
8	Bleiburg	30	37	48	42
9	Spittal	30	38	42	40
10	Ferlach	30	35	35	38
11	St. Jakob	30	42	43	38
12	Köttmannsdo	30	38	40	36
13	KAC	30	45	43	34
14	ASKÖ Gmünd	30	34	58	34
15	Kraig	30	32	67	30
16	Annabichler	30	27	77	21

TEMPORADA 2016/2017

CUARTA AUSTRIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Wolfsberger	30	89	27	71
2	Klagenfurt	30	63	33	61
3	Ferlach	30	77	45	59
4	Lendorf	30	62	47	55
5	Maria Saal	30	57	53	48
6	Treibach	30	54	53	44
7	Völkermarkt	30	44	47	44
8	Köttmannsdo	30	42	35	42
9	Feldkirchen	30	47	54	38
10	Spittal	30	55	55	37
11	Annabichler	30	41	53	36
12	Bleiburg	30	46	59	34
13	ASKÖ Gmünd	30	36	66	33
14	Lind	30	34	54	28
15	Dolomit	30	28	59	23
16	Rapid Lienz	30	25	60	20

TEMPORADA 2015/2016

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ferlach	30	81	41	68
2	ATSV	30	77	30	65
3	Klagenfurt	30	65	38	52
4	Treibach	30	53	46	46
5	Lendorf	30	50	54	45
6	ASKÖ Gmünd	30	46	44	44
7	Feldkirchen	30	49	55	44
8	Völkermarkt	30	40	38	43
9	Bleiburg	30	41	43	41
10	Köttmannsdo	30	36	36	40
11	Spittal	30	52	53	38
12	Rapid Lienz	30	36	48	35
13	Maria Saal	30	41	56	32
14	Kühnsdorf	30	30	47	29
15	Globasnitz	30	38	75	27
16	St. Michael	30	26	57	16

TEMPORADA 2014/2015

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Annabichler	30	77	34	69
2	Völkermarkt	30	61	28	65
3	Köttmannsdo	30	63	33	61
4	Ferlach	30	65	43	51
5	ASKÖ Gmünd	30	56	48	49
6	Treibach	30	58	53	44
7	Feldkirchen	30	60	43	41
8	Maria Saal	30	50	51	41
9	St. Michael	30	45	48	41
10	Lendorf	30	62	57	37
11	Bleiburg	30	40	50	36
12	Kühnsdorf	30	48	52	35
13	Spittal	30	46	62	31
14	Blau Weiss.	30	55	72	27
15	Veit Glan	30	45	71	26
16	SV Villach	30	28	114	14

TEMPORADA 2013/2014

CUARTA AUSTRIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	ATSV	30	58	20	65
2	Feldkirchen	30	66	32	58
3	Lendorf	30	58	39	56
4	Völkermarkt	30	50	31	53
5	Bleiburg	30	60	38	50
6	Treibach	30	51	40	48
7	Annabichler	30	54	48	46
8	Köttmannsdo	30	46	42	44
9	Maria Saal	30	57	57	42
10	ASKÖ Gmünd	30	43	48	41
11	Ferlach	30	48	47	40
12	Veit Glan	30	38	64	33
13	Spittal	30	61	72	31
14	Drautal	30	36	50	27
15	Steinfeld	30	44	91	19
16	Landskron	30	39	90	19

TEMPORADA 2012/2013

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Wolfsberger	30	88	28	69
2	ATSV	30	55	37	54
3	Veit Glan	30	63	41	53
4	Ferlach	30	60	51	50
5	Völkermarkt	30	46	35	47
6	Maria Saal	30	56	52	45
7	Lendorf	30	37	39	41
8	Spittal	30	49	53	41
9	Köttmannsdo	30	32	29	38
10	Treibach	30	47	54	36
11	Steinfeld	30	46	56	36
12	Bleiburg	30	47	46	35
13	Drautal	30	44	51	33
14	Rapid Lienz	30	24	46	27
15	Welzenegg	30	35	75	27
16	Raiba Ruden	30	27	63	13

TEMPORADA 2011/2012

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Feldkirchen	30	62	32	60
2	Veit Glan	30	57	35	59
3	Drautal	30	50	31	59
4	Lendorf	30	65	47	55
5	Spittal	30	61	36	50
6	ATSV	30	60	48	44
7	Treibach	30	57	54	43
8	Völkermarkt	30	43	36	41
9	Rapid Lienz	30	41	44	40
10	Sankt Andrä	30	39	43	37
11	Raiba Ruden	30	57	72	36
12	Maria Saal	30	42	58	36
13	Ferlach	30	47	60	33
14	Bleiburg	30	38	52	31
15	Hermagor	30	33	63	21
16	Eberndorfer	30	33	74	15

TEMPORADA 2010/2011

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	SV Villach	30	85	24	76
2	ATSV	30	56	34	53
3	Treibach	30	53	29	52
4	Bleiburg	30	51	40	50
5	Drautal	30	61	45	48
6	Lendorf	30	43	34	48
7	Maria Saal	30	58	61	46
8	Veit Glan	30	49	40	45
9	Spittal	30	44	38	43
10	Rapid Lienz	30	39	42	42
11	Eberndorfer	30	36	68	33
12	Sankt Andrä	30	38	54	32
13	Völkermarkt	30	38	56	32
14	Welzenegg	30	43	54	30
15	Landskron	30	36	61	20
16	Griffen	30	30	80	13

TEMPORADA 2009/2010

CUARTA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Feldkirchen	30	49	29	58
2	Lendorf	30	54	32	56
3	Treibach	30	53	27	55
4	Bleiburg	30	69	40	51
5	SV Villach	30	54	39	51
6	ATSV	30	43	48	49
7	Rapid Lienz	30	48	42	47
8	Austria	30	47	44	44
9	Völkermarkt	30	53	48	43
10	Sankt Andrä	30	53	49	43
11	Maria	30	29	26	40
12	Welzenegg	30	28	49	32
13	Spittal	30	52	64	30
14	St. Michael	30	33	57	29
15	Penk	30	33	56	25
16	Sittersdorf	30	39	87	17

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

Competiciones que juega

Grupo 1

Cuarta Austria Grupo 1

Pos	Equipos		Pts
1		Atus Velden	46
2		Treibach	44
3		Bleiburg	36
4		Ferlach	35
5		Köttmannsdorf	34
6		ATSV Wolfsberg	34
7		Spittal	34
8		SAK Klagenfurt	32
9		SV Donau Klagenfurt	30
10		KAC	30
11		Austria Klagenfurt II	29
12		Völkermarkt	27
13		Lendorf	27
14		Kraig	23
15		Landskron	22
16		St. Jakob	18

	Ascenso : Atus Velden
	Descenso : Kraig, Landskron, St. Jakob

RIVALES EN Copa de Austria

RIVALES EN Cuarta Austria

USO DE MEMORIA

7,702,288 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6742
Total Execution Time	0.6754

CADENA URL

/historico/Spittal

GET DATOS

$_GET['/historico/Spittal']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

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 = 'Spittal' 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.0126	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=18116 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=18116 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=18116 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=18116 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0256	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 = 73010
0.0126	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18116 AND type_rel = 2
0.0135	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 = '18116' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0134	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 = '18116' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129	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 = 73010 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0138	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=18116 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (73010,72330,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.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 73010 AND teamId = 18116
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 72330 AND teamId = 18116
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 18116
0.0128	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 = '18116' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18116' 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 = '18116' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0178	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 = 73010 WHERE rp.league_id = 73010 AND rp.teamId = 18116 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.0134	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 = 73010 WHERE rp.league_id = 73010 AND rp.teamId = 18116 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2024 e ON e.player_id = p.id AND e.league_id = 73010 WHERE rp.league_id = 73010 AND rp.teamId = 18116 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139	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 = 18116 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0140	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 = 73010 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.0141	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 = 68325 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.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* `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.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* `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.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* `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 = 50447 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.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* `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 = 44305 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* `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 = 38907 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* `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 = 38903 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* `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 = 15764 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* `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 = 3935 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* `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 = 27162 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* `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 = 27161 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* `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 = 27189 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* `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 = 27195 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* `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 = 27226 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.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* `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.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* `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.0133	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

Spittal

Spittal

Selecciona un equipo

Competiciones que juega

Cuarta Austria Grupo 1

RIVALES EN Copa de Austria

RIVALES EN Cuarta Austria