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

Resultados de Fútbol

Kufstein

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Austria	22	60	23	49
2	Hohenems	22	53	26	43
3	Pinzgau	22	40	21	43
4	Reichenau	23	44	24	40
5	Imst	23	48	41	39
6	Mötz Silz	22	60	44	37
7	Rheindorf	22	37	27	36
8	Wals-Grünau	23	36	36	36
9	Bischofshofe	23	47	38	33
10	Schwaz	22	31	31	27
11	Röthis	22	25	36	24
12	Kufstein	23	21	39	23
13	St. Johann	22	28	41	22
14	Wolfurt	23	28	59	18
15	Dornbirner	22	25	51	14
16	Rot-Weiß	22	22	68	13

TEMPORADA 2022/2023

TERCERA AUSTRIA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	SW Bregenz	10	16	7	21
2	Bischofshofe	10	22	15	17
3	Hohenems	10	21	19	17
4	Kufstein	10	22	22	12
5	Pinzgau	10	13	16	9
6	Reichenau	10	13	28	5

TEMPORADA 2021/2022

TERCERA AUSTRIA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Imst	8	32	9	36
2	Wörgl	8	16	15	33
3	Kitzbühel	8	12	15	29
4	Reichenau	8	10	20	27
5	Kufstein	8	12	23	22

TEMPORADA 2020/2021

TERCERA AUSTRIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Kitzbühel	16	34	13	33
2	Wörgl	15	36	27	31
3	Imst	14	34	20	26
4	Kufstein	15	30	19	26
5	Reichenau	15	25	17	24
6	Wacker	14	30	21	22
7	Schwaz	14	25	28	18
8	Swarovski	15	28	45	16
9	Telfs	17	27	35	15
10	SV Hall	15	12	56	0

TEMPORADA 2019/2020

TERCERA AUSTRIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Wörgl	18	45	16	36
2	Schwaz	18	43	34	33
3	Reichenau	18	46	32	29
4	SV Hall	18	35	26	28
5	Kitzbühel	18	36	25	27
6	Imst	18	32	34	27
7	Telfs	18	38	38	26
8	Kufstein	18	22	38	21
9	Zirl	18	30	53	12
10	Wacker	18	23	54	9

TEMPORADA 2018/2019

TERCERA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dornbirn	30	70	23	72
2	Kitzbühel	30	59	28	65
3	USK Anif	30	98	37	61
4	Kufstein	30	55	31	55
5	Seekirchen	30	57	45	51
6	St. Johann	30	66	43	50
7	Schwaz	30	47	42	47
8	Wörgl	30	60	59	43
9	Reichenau	30	50	45	42
10	Grödig	30	38	46	38
11	Hohenems	30	52	70	30
12	Wals-Grünau	30	34	55	30
13	Rheindorf	30	31	49	28
14	Pinzgau	30	38	73	25
15	Langenegg	30	35	89	22
16	Bischofshofe	30	31	86	19

TEMPORADA 2017/2018

TERCERA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	USK Anif	30	92	24	67
2	Grödig	30	73	27	61
3	Schwaz	30	49	33	53
4	Rheindorf	30	63	45	49
5	Kitzbühel	30	58	39	47
6	Dornbirn	30	40	42	43
7	Wals-Grünau	30	58	53	42
8	Wacker	30	48	50	41
9	Hohenems	30	51	61	41
10	Kufstein	30	56	53	38
11	St. Johann	30	48	55	36
12	Seekirchen	30	46	54	36
13	Wörgl	30	45	59	34
14	Hard	30	37	62	29
15	Pinzgau	30	35	74	24
16	Alberschwend	30	28	96	13

TEMPORADA 2016/2017

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	USK Anif	30	99	28	80
2	Grödig	30	70	20	70
3	Rheindorf	30	48	48	48
4	St. Johann	30	48	42	45
5	Schwaz	30	46	39	44
6	Wacker	30	48	46	43
7	Kufstein	30	53	51	41
8	Dornbirn	30	33	43	39
9	Hohenems	30	49	50	38
10	Seekirchen	30	51	57	38
11	Hard	30	46	54	37
12	Pinzgau	30	33	47	34
13	Wörgl	30	40	61	33
14	Eugendorf	30	40	66	30
15	Austria	30	43	62	23
16	Salzburger	30	34	67	22

TEMPORADA 2015/2016

TERCERA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	WSG Tirol	30	81	18	75
2	USK Anif	30	76	46	57
3	St. Johann	30	59	32	55
4	Dornbirn	30	58	39	50
5	Schwaz	30	44	40	46
6	Eugendorf	30	56	63	43
7	Wacker	30	54	45	42
8	Pinzgau	30	51	59	39
9	Seekirchen	30	50	58	39
10	Rheindorf	30	33	48	38
11	Kufstein	30	43	45	37
12	Hard	30	35	42	36
13	Neumarkt	30	43	61	36
14	SW Bregenz	30	42	63	33
15	Kitzbühel	30	53	59	32
16	Reichenau	30	28	88	13

TEMPORADA 2014/2015

TERCERA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Austria	30	71	23	73
2	WSG Tirol	30	81	22	69
3	St. Johann	30	51	35	47
4	Eugendorf	30	53	48	47
5	Kitzbühel	30	46	40	43
6	Neumarkt	30	51	58	43
7	Dornbirn	30	46	43	41
8	Kufstein	30	56	59	41
9	Seekirchen	30	40	46	40
10	Schwaz	30	42	37	39
11	Wacker	30	58	61	38
12	Pinzgau	30	47	49	37
13	Hard	30	41	50	32
14	Rheindorf	30	33	70	31
15	Bizau	30	27	68	29
16	FC Höchst	30	20	54	19

TEMPORADA 2013/2014

TERCERA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Austria	30	96	15	79
2	WSG Tirol	30	88	36	70
3	Neumarkt	30	67	41	53
4	St. Johann	30	59	57	47
5	Rheindorf	30	51	51	46
6	Schwaz	30	45	42	45
7	Wacker	30	51	61	40
8	Kufstein	30	49	58	36
9	Dornbirn	30	50	51	34
10	Seekirchen	30	44	48	34
11	Hard	30	38	65	34
12	FC Höchst	30	35	51	33
13	Eugendorf	30	44	69	33
14	USK Anif	30	43	56	31
15	SW Bregenz	30	50	75	29
16	Wals-Grünau	30	36	70	27

TEMPORADA 2012/2013

TERCERA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Liefering	30	94	23	74
2	Austria	30	77	21	68
3	WSG Tirol	30	73	49	59
4	Kufstein	30	70	41	54
5	SW Bregenz	30	57	43	48
6	USK Anif	30	50	43	47
7	Seekirchen	30	43	44	43
8	Dornbirn	30	48	51	41
9	Wacker	30	60	60	40
10	St. Johann	30	39	44	37
11	Rheindorf	30	41	49	36
12	Neumarkt	30	47	69	34
13	Hard	30	36	64	32
14	Wals-Grünau	30	37	69	23
15	Andelsbuch	30	32	75	23
16	Pinzgau	30	27	86	13

TEMPORADA 2011/2012

TERCERA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	WSG Tirol	30	67	14	76
2	USK Anif	30	82	38	70
3	Dornbirn	30	72	30	64
4	Juniors	30	72	48	52
5	Kufstein	30	58	44	46
6	Wacker	30	58	53	45
7	Rheindorf	30	50	44	40
8	Austria	30	54	54	40
9	St. Johann	30	43	48	39
10	SW Bregenz	30	47	45	38
11	Pinzgau	30	50	55	38
12	Hard	30	39	66	32
13	Neumarkt	30	44	71	31
14	Union	30	35	87	24
15	Seekirchen	30	33	65	20
16	SV Hall	30	27	69	18

TEMPORADA 2010/2011

TERCERA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Juniors	30	78	23	68
2	WSG Tirol	30	64	40	59
3	USK Anif	30	66	37	55
4	Kufstein	30	67	45	55
5	Austria	30	61	37	54
6	Dornbirn	30	62	35	53
7	SW Bregenz	30	58	51	43
8	Wacker	30	56	60	40
9	St. Johann	30	39	41	39
10	Hard	30	49	57	38
11	Rheindorf	30	49	62	37
12	Neumarkt	30	34	61	33
13	Union	30	39	74	29
14	Seekirchen	30	48	75	28
15	Reichenau	30	52	82	23
16	FC Höchst	30	35	77	15

TEMPORADA 2009/2010

TERCERA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Grödig	30	100	23	76
2	WSG Tirol	30	78	39	61
3	USK Anif	30	82	47	59
4	Wacker	30	64	46	53
5	Kufstein	30	69	51	51
6	Seekirchen	30	70	54	51
7	SW Bregenz	30	76	44	50
8	Hard	30	82	53	49
9	St. Johann	30	66	64	42
10	Neumarkt	30	48	57	40
11	Reichenau	30	73	75	36
12	Rheindorf	30	43	62	36
13	Schwaz	30	37	64	33
14	Blau-Weiß	30	50	78	28
15	Axams	30	54	98	14
16	Hohenems	30	19	156	1

TEMPORADA 2008/2009

TERCERA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dornbirn	30	62	25	63
2	WSG Tirol	30	85	39	58
3	USK Anif	30	52	29	58
4	Hard	30	77	35	56
5	SW Bregenz	30	77	46	53
6	Kufstein	30	66	46	49
7	Reichenau	30	63	55	44
8	Axams	30	62	61	43
9	St. Johann	30	43	41	41
10	Hohenems	30	48	48	41
11	Seekirchen	30	49	53	37
12	Schwaz	30	42	50	37
13	Blau-Weiß	30	36	56	33
14	SV Hall	30	36	60	32
15	FC Höchst	30	34	59	31
16	Rot-Weiß	30	13	142	0

TEMPORADA 2007/2008

TERCERA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Grödig	30	72	25	68
2	Kufstein	30	73	49	54
3	Hard	30	53	38	54
4	SV Hall	30	47	41	49
5	WSG Tirol	30	54	42	47
6	Blau-Weiß	30	56	42	44
7	Seekirchen	30	51	43	43
8	Axams	30	54	47	42
9	USK Anif	30	45	45	40
10	Dornbirn	30	48	50	40
11	FC Höchst	30	54	52	39
12	SW Bregenz	30	61	66	37
13	Reichenau	30	49	62	37
14	Rot-Weiß	30	36	53	36
15	Kundl	30	45	64	28
16	Innsbrucker	30	39	118	8

TEMPORADA 2006/2007

TERCERA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Juniors	30	97	34	73
2	Hard	30	59	28	60
3	WSG Tirol	30	58	30	56
4	Kufstein	30	48	27	51
5	Blau-Weiß	30	74	47	49
6	Grödig	30	43	41	46
7	Dornbirn	30	43	45	42
8	SV Hall	30	54	48	40
9	Axams	30	48	46	37
10	FC Höchst	30	50	55	37
11	Reichenau	30	51	59	36
12	Seekirchen	30	42	68	32
13	Innsbrucker	30	57	88	32
14	Rot-Weiß	30	41	58	29
15	Hohenems	30	32	72	24
16	Austria	30	43	94	24

Competiciones que juega

Grupo 2

Tercera Austria Grupo 2

Pos	Equipos		Pts
1		Austria Salzburg	49
2		Hohenems	43
3		Pinzgau Saalfelden	43
4		Reichenau	40
5		Imst	39
6		Mötz / Silz	37
7		SC Rheindorf Altach II	36
8		Wals-Grünau	36
9		Bischofshofen	33
10		Schwaz	27
11		Röthis	24
12		Kufstein	23
13		St. Johann	22
14		Wolfurt	18
15		Dornbirner SV	14
16		Rot-Weiß Rankweil	13

	Ascenso : Austria Salzburg
	Descenso : Wolfurt, Dornbirner SV, Rot-Weiß Rankweil

RIVALES EN Copa de Austria

RIVALES EN Tercera Austria

USO DE MEMORIA

7,162,664 bytes

BENCHMARKS

Loading Time Base Classes	0.0016
Controller Execution Time ( Home / Category )	0.1661
Total Execution Time	0.1677

CADENA URL

/historico/Kufstein

GET DATOS

$_GET['/historico/Kufstein']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

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 = 'Kufstein' 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.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=12516 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=12516 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=12516 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=12516 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12516 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=338 AND type_rel = 3
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 338 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021	SELECT /53 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 (1268188,1267669,1162598,981042,744718) ORDER BY n.cover_points DESC, update_date DESC
0.0051	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 = '12516' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0037	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 = '12516' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023	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 = 72330 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020	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 = 72355 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0036	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=12516 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (72355,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.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 72355 AND teamId = 12516
0.0034	SELECT count(id) as num_players from rel_players WHERE league_id = 72330 AND teamId = 12516
0.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12516
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 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 = 72355 AND t.round = 23 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0049	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 = 72355 WHERE rp.league_id = 72355 AND rp.teamId = 12516 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.0043	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 = 72355 WHERE rp.league_id = 72355 AND rp.teamId = 12516 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	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 = 72355 WHERE rp.league_id = 72355 AND rp.teamId = 12516 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 = 12516 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 68178 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 71436 AND t.round = 10 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* `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 = 63400 AND t.round = 22 ORDER BY team.conference ASC,t.position 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* `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 = 67265 AND t.round = 10 ORDER BY team.conference ASC,t.position 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* `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 = 57021 AND t.round = 18 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* `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 = 50649 AND t.round = 18 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 = 44210 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 = 38884 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* `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 = 33373 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 = 15760 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 = 4156 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 = 2768 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 24528 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 24531 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* `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 = 24537 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* `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 = 24540 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* `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 = 27595 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

Kufstein

Kufstein

Selecciona un equipo

Competiciones que juega

Tercera Austria Grupo 2

RIVALES EN Copa de Austria

RIVALES EN Tercera Austria