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

Stadl-Paura

Temporada 2022/2023

TEMPORADA 2022/2023

CUARTA AUSTRIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Oedt	28	80	27	65
2	SV Wallern	28	78	37	58
3	Union	28	68	41	50
4	Wohnbau	28	76	50	49
5	Martin	28	70	43	46
6	Valentin	28	47	33	42
7	Union	28	53	40	42
8	Union	28	48	54	38
9	Zebau Ischl	29	52	70	36
10	Grün-Weiß	28	65	40	35
11	Friedburg	28	48	56	35
12	Union Perg	28	41	49	33
13	Kornspitz	28	44	53	33
14	Ostermiethin	28	49	58	28
15	Wels	28	33	99	16
16	Stadl-Paura	15	0	102	0

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

CUARTA AUSTRIA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Stadl-Paura	30	63	24	68
2	Grieskirchen	30	74	40	56
3	Marchtrenk	30	50	34	52
4	Gmunden	30	49	40	51
5	Bad Ischl	30	47	39	49
6	Union	30	50	46	47
7	Union	30	49	40	46
8	Wels	30	44	43	46
9	Donau Linz	30	58	57	41
10	Sierning	30	47	48	38
11	SV Ried II	30	36	43	37
12	Grün-Weiß	30	36	45	37
13	Schallerbach	30	42	55	37
14	Martin	30	47	61	33
15	Eferding	30	33	54	26
16	Bad Goisern	30	21	77	10

Competiciones que juega

Cuarta Austria Grupo 6

Pos	Equipos		Pts
1		Oedt	65
2		SV Wallern	58
3		Union Edelweiß	50
4		Wohnbau Dietach	49
5		St. Martin im Muhlreis	46
6		St. Valentin	42
7		Union Weißkirchen	42
8		Union Mondsee	38
9		Zebau Bad Ischl	36
10		Grün-Weiß Micheldorf	35
11		Friedburg / Pöndorf	35
12		Union Perg	33
13		Kornspitz Pregarten	33
14		Ostermiething	28
15		Wels	16
16		Stadl-Paura	0

	Ascenso : Oedt
	Posible siguiente ronda : Union Perg, Kornspitz Pregarten, Ostermiething, Wels
	Descenso : Stadl-Paura

RIVALES EN Cuarta Austria

USO DE MEMORIA

5,797,968 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.1769
Total Execution Time	0.1783

CADENA URL

/historico/Stadl-Paura

GET DATOS

$_GET['/historico/Stadl-Paura']

POST DATOS

No hay datos POST existentes

CONSULTAS (55)

0.0028	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 = 'Stadl-Paura' 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.0057	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 = 'Stadl-Paura' 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.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=19402 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=19402 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=19402 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=19402 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=19402 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=19402 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=19402 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=19402 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=19402 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=19402 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=19402 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=19402 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=19402 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=19402 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=19402 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=19402 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=19402 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=19402 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=19402 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=19402 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=19402 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=19402 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=19402 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=19402 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19402 AND type_rel = 2
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 19402 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020	SELECT /35 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (355844) ORDER BY n.cover_points DESC, update_date DESC
0.0030	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 = '19402' ORDER BY l.year DESC,cat.coefficient DESC
0.0033	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 = '19402' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '19402' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0031	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 = '19402' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0048	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=19402 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0023	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 (68329,63402,63190,62807) 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.0034	SELECT count(id) as num_players from rel_players WHERE league_id = 63402 AND teamId = 19402
0.0043	SELECT count(id) as num_players from rel_players WHERE league_id = 68329 AND teamId = 19402
0.0050	SELECT count(id) as num_players from rel_players WHERE league_id = 63190 AND teamId = 19402
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 19402
0.0021	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 = '19402' 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 = '19402' and rp.type = 4
0.0021	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 = '19402' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0038	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 events2023 e ON e.player_id = p.id AND e.league_id = 68329 WHERE rp.league_id = 68329 AND rp.teamId = 19402 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.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 events2023 e ON e.player_id = p.id AND e.league_id = 68329 WHERE rp.league_id = 68329 AND rp.teamId = 19402 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2023 e ON e.player_id = p.id AND e.league_id = 68329 WHERE rp.league_id = 68329 AND rp.teamId = 19402 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 19402 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 68329 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.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* `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.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* `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.0028	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.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* `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 = 3941 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Stadl-Paura

Stadl-Paura

Selecciona un equipo

Competiciones que juega

Cuarta Austria Grupo 6

RIVALES EN Cuarta Austria