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

Altenmarkt

Temporada 2022/2023

TEMPORADA 2022/2023

CUARTA AUSTRIA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Thalgau	26	60	30	58
2	Bürmoos	26	55	24	55
3	Straßwalche	26	49	37	48
4	Eugendorf	26	55	32	42
5	Bramberg	26	57	36	42
6	Adnet	26	41	30	39
7	Siezenheim	26	43	36	39
8	Puch	26	42	41	38
9	Neumarkt	26	47	56	35
10	Hallwang	26	43	52	30
11	Schwarzach	26	31	46	30
12	Altenmarkt	26	36	66	20
13	Salzburg	26	30	61	17
14	Bergheim	26	35	77	17

TEMPORADA 2021/2022

CUARTA AUSTRIA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Golling	26	75	37	54
2	UFC Hallein	26	70	32	51
3	Eugendorf	26	61	25	50
4	Thalgau	26	58	49	46
5	Bürmoos	26	59	45	44
6	Adnet	26	40	28	44
7	Siezenheim	26	49	50	40
8	Hallwang	26	48	42	38
9	Neumarkt	26	48	47	38
10	Bramberg	26	39	49	34
11	Straßwalche	26	55	52	31
12	Bergheim	26	46	80	23
13	Altenmarkt	26	36	68	20
14	Puch	26	20	100	2

TEMPORADA 2020/2021

CUARTA AUSTRIA GRUPO 5
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2019/2020

CUARTA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Eugendorf	15	40	15	35
2	Adnet	15	38	18	33
3	Zell am See	15	32	14	30
4	Neumarkt	15	34	15	28
5	Golling	15	41	35	26
6	Straßwalche	15	32	43	25
7	Bergheim	15	28	22	22
8	Bramberg	15	27	24	20
9	Bürmoos	15	32	22	19
10	Altenmarkt	15	28	32	17
11	UFC Hallein	15	20	27	15
12	Thalgau	15	23	46	11
13	Hallwang	15	15	40	9
14	Puch	15	12	49	5

TEMPORADA 2018/2019

CUARTA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Salzburger	30	93	25	75
2	Austria	30	92	31	70
3	Kuchl	30	66	37	61
4	Neumarkt	30	77	48	57
5	Bürmoos	30	55	45	47
6	Eugendorf	30	61	47	46
7	Zell am See	30	63	53	43
8	Golling	30	59	69	38
9	Straßwalche	30	48	46	37
10	Altenmarkt	30	52	61	37
11	Thalgau	30	64	75	34
12	Puch	30	54	89	30
13	Bramberg	30	59	82	29
14	Adnet	30	32	82	26
15	UFC Hallein	30	41	85	25
16	SK Strobl	30	38	79	18

TEMPORADA 2017/2018

CUARTA AUSTRIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Bischofshofe	30	63	28	69
2	Neumarkt	30	64	34	61
3	Eugendorf	30	69	50	55
4	Bürmoos	30	46	36	49
5	Zell am See	30	63	46	47
6	Salzburger	30	59	48	45
7	Austria	30	57	50	41
8	Bramberg	30	39	44	41
9	Straßwalche	30	58	55	39
10	SK Strobl	30	56	57	37
11	Kuchl	30	49	57	36
12	Golling	30	53	64	32
13	UFC Hallein	30	37	60	30
14	Altenmarkt	30	40	64	30
15	Hallwang	30	39	68	30
16	Bergheim	30	39	70	27

TEMPORADA 2016/2017

CUARTA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Wals-Grünau	30	105	20	78
2	Neumarkt	30	74	23	70
3	Kuchl	30	66	37	54
4	Straßwalche	30	55	50	44
5	Bischofshofe	30	46	60	44
6	Bürmoos	30	41	44	43
7	Hallwang	30	35	47	42
8	Zell am See	30	45	39	41
9	Bergheim	30	40	41	40
10	Bramberg	30	39	46	40
11	Golling	30	53	63	38
12	Altenmarkt	30	37	51	37
13	UFC Hallein	30	47	56	36
14	Berndorf	30	44	54	33
15	Puch	30	40	60	29
16	Hallein	30	21	97	3

TEMPORADA 2015/2016

CUARTA AUSTRIA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Bergheim	30	66	37	61
2	Salzburger	30	51	22	58
3	Grödig II	30	69	40	53
4	Wals-Grünau	30	70	34	52
5	Kuchl	30	65	45	49
6	Bramberg	30	56	38	49
7	Straßwalche	30	59	48	49
8	Altenmarkt	30	52	41	49
9	Puch	30	54	30	46
10	Zell am See	30	49	44	42
11	Golling	30	53	58	39
12	UFC Hallein	30	42	56	39
13	Bischofshofe	30	30	63	28
14	Hallwang	30	34	61	24
15	Hallein	30	29	96	12
16	Maria	30	19	85	7

TEMPORADA 2014/2015

CUARTA AUSTRIA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	USK Anif	30	95	29	78
2	Grödig II	30	86	48	55
3	Kuchl	30	71	53	49
4	Altenmarkt	30	66	63	49
5	Wals-Grünau	30	68	53	48
6	Straßwalche	30	67	52	46
7	UFC Hallein	30	57	45	46
8	Bergheim	30	40	46	41
9	Puch	30	48	57	41
10	Hallein	30	49	65	39
11	Bramberg	30	40	50	35
12	Salzburger	30	45	66	35
13	Zell am See	30	57	75	34
14	Hallwang	30	36	55	31
15	Berndorf	30	27	55	24
16	Union	30	30	70	13

TEMPORADA 2013/2014

CUARTA AUSTRIA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Pinzgau	30	72	26	69
2	Grödig II	30	86	40	66
3	Kuchl	30	58	39	52
4	Straßwalche	30	68	48	51
5	Salzburger	30	52	46	48
6	Bergheim	30	64	59	46
7	Altenmarkt	30	52	47	46
8	Union	30	43	55	39
9	Zell am See	30	55	70	37
10	Puch	30	48	53	35
11	Bramberg	30	45	59	34
12	Hallwang	30	51	69	33
13	Hallein	30	39	64	32
14	Berndorf	30	47	69	30
15	Schwarzach	30	35	52	29
16	Anthering	30	43	62	28

TEMPORADA 2012/2013

CUARTA AUSTRIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Eugendorf	30	82	31	68
2	Hallein	30	57	34	61
3	Salzburger	30	56	37	54
4	Altenmarkt	30	54	35	51
5	Puch	30	56	47	48
6	Straßwalche	30	66	50	47
7	Bramberg	30	54	63	42
8	Grödig II	30	56	50	39
9	Kuchl	30	54	51	39
10	Zell am See	30	59	61	38
11	Hallwang	30	34	39	37
12	Union	30	43	60	35
13	Berndorf	30	42	59	33
14	Schwarzach	30	38	62	29
15	SC Leogang	30	41	78	26
16	Golling	30	31	66	25

TEMPORADA 2011/2012

CUARTA AUSTRIA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Wals-Grünau	30	67	25	64
2	Salzburger	30	59	25	62
3	Hallwang	30	66	36	62
4	Grödig II	30	69	35	60
5	Eugendorf	30	68	41	59
6	Kuchl	30	55	49	44
7	Hallein	30	59	53	42
8	Straßwalche	30	54	56	38
9	Puch	30	54	56	37
10	Union	30	54	61	33
11	SC Leogang	30	52	77	31
12	Altenmarkt	30	40	65	31
13	Zell am See	30	45	76	31
14	Golling	30	53	72	29
15	Anthering	30	31	62	27
16	Salzburg	30	38	75	24

Competiciones que juega

Cuarta Austria Grupo 7

Pos	Equipos		Pts
1		Thalgau	58
2		Bürmoos	55
3		Straßwalchen	48
4		USC Eugendorf	42
5		Bramberg	42
6		Adnet	39
7		Siezenheim	39
8		Puch	38
9		TSV Neumarkt	35
10		Hallwang	30
11		SV Schwarzach	30
12		Altenmarkt	20
13		ASV Salzburg	17
14		Bergheim	17

	Ascenso : Thalgau
	Posible siguiente ronda : SV Schwarzach, Altenmarkt, ASV Salzburg
	Descenso : Bergheim

RIVALES EN Cuarta Austria

USO DE MEMORIA

6,108,128 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1415
Total Execution Time	0.1427

CADENA URL

/historico/Altenmarkt

GET DATOS

$_GET['/historico/Altenmarkt']

POST DATOS

No hay datos POST existentes

CONSULTAS (49)

0.0032	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 = 'Altenmarkt' 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.0034	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 = 'Altenmarkt' 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=19406 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=19406 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=19406 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=19406 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=19406 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=19406 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=19406 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=19406 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=19406 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=19406 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=19406 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=19406 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=19406 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=19406 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=19406 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=19406 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=19406 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024	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 = 68330
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19406 AND type_rel = 2
0.0023	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 = '19406' ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '19406' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0020	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 = '19406' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = '19406' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019	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 = 68330 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	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=19406 AND l.year in (2022,2023,2024) 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 (68330,67320) 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 = 68330 AND teamId = 19406
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 19406
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 = '19406' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0026	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19406' and rp.type = 4
0.0020	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 = '19406' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0027	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 = 68330 WHERE rp.league_id = 68330 AND rp.teamId = 19406 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.0024	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 = 68330 WHERE rp.league_id = 68330 AND rp.teamId = 19406 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 events2023 e ON e.player_id = p.id AND e.league_id = 68330 WHERE rp.league_id = 68330 AND rp.teamId = 19406 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 19406 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 = 68330 AND t.round = 26 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* `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 = 63696 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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 = 57781 AND t.round = 26 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 = 50449 AND t.round = 15 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 = 44306 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 = 38911 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* `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 = 33428 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* `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 = 15771 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* `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 = 3942 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* `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 = 27181 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* `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 = 27175 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* `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 = 27212 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Altenmarkt

Altenmarkt

Selecciona un equipo

Competiciones que juega

Cuarta Austria Grupo 7

RIVALES EN Cuarta Austria