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

Wiener Neustadt

Temporada 2019/2020

TEMPORADA 2019/2020

TERCERA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Marchfeld	18	34	15	42
2	Rapid Wien	18	32	13	37
3	Ebreichsdorf	18	28	11	34
4	Wiener SC	18	37	27	30
5	Stripfing	18	24	16	30
6	Team Wiener	18	23	20	27
7	Wiener	18	31	30	27
8	Mattersburg	18	30	25	25
9	Drassburg	18	25	30	25
10	Wiener	18	29	34	23
11	Neusiedl	18	25	35	23
12	Mauerwerk	18	25	32	20
13	Bruck/Leitha	18	24	35	19
14	Traiskirchen	18	25	34	16
15	Admira	18	20	28	14
16	Leobendorf	18	11	38	9

TEMPORADA 2018/2019

SEGUNDA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	WSG Tirol	30	59	26	65
2	SV Ried	30	61	21	63
3	Austria	30	55	34	50
4	Kapfenberger	30	44	40	46
5	Blau-Weiß	30	46	48	44
6	Wiener	30	39	41	44
7	Juniors	30	52	55	42
8	Austria	30	43	35	41
9	Wacker	30	40	44	41
10	FAC Wien	30	35	41	41
11	Amstetten	30	45	43	36
12	Liefering	30	50	54	35
13	Austria Wien	30	46	62	34
14	SV Lafnitz	30	36	42	33
15	Horn	30	33	62	25
16	Vorwarts	30	32	68	21

TEMPORADA 2017/2018

SEGUNDA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Wacker	36	60	31	71
2	Hartberg	36	63	34	68
3	Wiener	36	53	37	62
4	SV Ried	36	68	41	61
5	Liefering	36	58	44	55
6	Austria	36	48	52	45
7	WSG Tirol	36	45	56	40
8	Kapfenberger	36	40	68	35
9	FAC Wien	36	37	75	30
10	Blau-Weiß	36	35	69	26

TEMPORADA 2016/2017

SEGUNDA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	LASK	36	77	42	77
2	Liefering	36	58	49	60
3	Austria	36	58	49	57
4	Wacker	36	58	53	54
5	WSG Tirol	36	56	54	51
6	Kapfenberger	36	47	57	41
7	Blau-Weiß	36	41	45	39
8	Wiener	36	40	62	39
9	FAC Wien	36	39	48	38
10	Horn	36	42	57	33

TEMPORADA 2015/2016

SEGUNDA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Polten	36	68	34	80
2	LASK	36	65	35	72
3	Wacker	36	61	47	59
4	Liefering	36	65	49	57
5	Austria	36	56	40	57
6	Kapfenberger	36	63	62	50
7	Wiener	36	39	49	45
8	Austria	36	43	62	34
9	Austria	36	45	73	32
10	FAC Wien	36	23	77	17

TEMPORADA 2014/2015

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Salzburg	36	99	42	73
2	Rapid Wien	36	68	38	67
3	SCR Altach	36	50	49	59
4	Sturm Graz	36	57	41	58
5	Wolfsberger	36	44	50	52
6	SV Ried	36	49	51	44
7	Austria Wien	36	45	51	43
8	Grödig	36	46	65	37
9	Admira	36	32	61	34
10	Wiener	36	37	79	29

TEMPORADA 2013/2014

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Salzburg	36	110	35	80
2	Rapid Wien	36	63	40	62
3	Grödig	36	68	71	54
4	Austria Wien	36	58	44	53
5	Sturm Graz	36	55	55	48
6	SV Ried	36	55	66	43
7	Admira	36	51	67	42
8	Wolfsberger	36	50	63	41
9	Wiener	36	43	84	39
10	Wacker	36	42	70	29

TEMPORADA 2012/2013

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Austria Wien	36	84	31	82
2	Salzburg	36	91	39	77
3	Rapid Wien	36	57	39	57
4	Sturm Graz	36	47	56	48
5	Wolfsberger	36	53	56	47
6	SV Ried	36	60	59	46
7	Wiener	36	32	60	36
8	Wacker	36	41	73	36
9	Admira	36	47	68	35
10	Mattersburg	36	36	67	35

TEMPORADA 2011/2012

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Salzburg	36	60	30	68
2	Rapid Wien	36	52	30	62
3	Admira	36	59	52	55
4	Austria Wien	36	52	44	54
5	Sturm Graz	36	47	41	51
6	SV Ried	36	44	38	48
7	Wacker	36	36	45	45
8	Mattersburg	36	41	43	38
9	Wiener	36	26	51	33
10	Kapfenberger	36	21	64	23

TEMPORADA 2010/2011

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Sturm Graz	36	66	33	66
2	Salzburg	36	53	31	63
3	Austria Wien	36	64	37	61
4	SV Ried	36	51	38	58
5	Rapid Wien	36	52	41	53
6	Wacker	36	43	42	50
7	Wiener	36	44	52	50
8	Kapfenberger	36	42	61	38
9	Mattersburg	36	29	56	31
10	LASK	36	22	75	19

TEMPORADA 2009/2010

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Salzburg	36	68	27	76
2	Austria Wien	36	60	34	75
3	Rapid Wien	36	80	38	73
4	Sturm Graz	36	50	36	58
5	Wiener	36	54	58	47
6	Mattersburg	36	45	71	41
7	LASK	36	59	70	40
8	SV Ried	36	39	47	38
9	Kapfenberger	36	44	67	33
10	Austria	36	29	80	15

TEMPORADA 2008/2009

SEGUNDA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Wiener	33	65	26	69
2	Wacker	33	65	44	62
3	Admira	33	55	36	60
4	Austria	33	52	47	48
5	Polten	33	51	46	47
6	Austria Wien	33	44	43	45
7	Juniors	33	41	56	43
8	Gratkorn	33	39	55	40
9	FC Lustenau	33	34	37	38
10	Grödig	33	37	52	35
11	Leoben	33	30	55	32
12	Vöcklabruck	33	40	56	30

TEMPORADA 1966/1967

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Rapid Wien	26	72	29	61
2	Wacker	26	58	24	59
3	Austria Wien	26	43	23	49
4	LASK	26	39	25	43
5	Wiener SC	26	60	36	42
6	SW Bregenz	27	26	37	39
7	First Vienna	26	42	49	37
8	Admira	26	36	25	36
9	Grazer AK	26	27	44	31
10	Austria	26	21	33	30
11	Sturm Graz	26	32	47	25
12	Wacker Wien	26	28	50	25
13	Wiener	26	21	44	21
14	Kapfenberger	27	20	59	16

TEMPORADA 1965/1966

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Admira	26	51	17	43
2	Rapid Wien	26	64	22	40
3	Austria Wien	26	58	28	35
4	Wiener SC	26	57	32	30
5	First Vienna	26	52	43	30
6	Austria	26	39	33	29
7	LASK	26	46	37	27
8	Wacker	26	32	31	25
9	Schwechat	26	40	42	23
10	Grazer AK	26	35	46	23
11	Kapfenberger	26	26	51	20
12	Wiener	26	24	59	18
13	Salzburg	26	25	66	12
14	Simmeringer	26	26	68	9

TEMPORADA 1964/1965

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	LASK	26	49	29	50
2	Admira	26	52	28	49
3	Rapid Wien	26	42	21	49
4	Wiener SC	26	54	36	48
5	First Vienna	26	51	36	42
6	Schwechat	26	27	28	39
7	Austria Wien	26	29	28	37
8	Wacker	26	29	23	34
9	Wiener	26	31	32	31
10	Sturm Graz	26	29	40	26
11	Grazer AK	26	28	48	26
12	Kapfenberger	26	25	45	25
13	Wiener AC	26	31	54	20
14	Wacker Wien	26	27	56	19

TEMPORADA 1963/1964

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Rapid Wien	26	69	27	62
2	Austria Wien	26	61	36	54
3	LASK	26	46	36	48
4	Schwechat	26	51	41	44
5	Wiener SC	26	48	53	44
6	Grazer AK	26	49	42	38
7	Admira	26	52	49	38
8	First Vienna	26	38	33	32
9	Wiener AC	26	33	38	31
10	Wiener	26	33	47	30
11	Kapfenberger	26	38	56	26
12	Simmeringer	26	46	64	25
13	Stickstoff	26	42	56	22
14	Dornbirn	26	31	59	17

TEMPORADA 1961/1962

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Austria Wien	26	65	23	61
2	LASK	26	69	40	54
3	Admira	26	56	34	52
4	Wiener SC	26	58	39	44
5	Rapid Wien	26	58	32	43
6	Wiener AC	26	47	37	38
7	Grazer AK	26	43	42	37
8	Stickstoff	26	47	50	36
9	Schwechat	26	50	68	32
10	Simmeringer	26	37	62	31
11	First Vienna	26	44	44	29
12	Kapfenberger	26	29	53	21
13	Wiener	26	30	57	17
14	Salzburger	26	27	79	9

TEMPORADA 1960/1961

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Austria Wien	26	68	31	56
2	First Vienna	26	63	41	45
3	Wiener SC	26	71	52	45
4	Wiener AC	26	60	41	45
5	Rapid Wien	26	49	42	43
6	LASK	27	57	50	42
7	Grazer AK	26	53	37	41
8	Wiener	26	58	67	35
9	Stickstoff	26	53	58	33
10	Schwechat	26	37	49	29
11	Salzburg	26	45	54	28
12	Simmeringer	27	42	53	28
13	Admira	26	39	56	26
14	Dornbirn	26	37	101	13

TEMPORADA 1959/1960

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Rapid Wien	26	87	32	60
2	Wiener SC	26	71	35	55
3	First Vienna	26	81	50	55
4	Wiener AC	26	74	43	55
5	Austria Wien	26	67	49	42
6	Simmeringer	26	51	49	39
7	LASK	26	54	57	35
8	Wacker Wien	26	47	57	27
9	Grazer AK	26	45	55	26
10	Wiener	26	49	79	26
11	Kremser SC	26	44	65	24
12	Salzburg	26	42	67	24
13	Leoben	26	39	73	24
14	Admira	26	31	71	14

TEMPORADA 1950/1951

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Rapid Wien	24	133	40	63
2	Wacker Wien	24	100	38	56
3	Austria Wien	24	89	49	46
4	Wiener SC	24	73	52	38
5	First Vienna	24	56	58	36
6	FC Wien	24	45	50	35
7	Sturm Graz	24	48	74	31
8	Admira	24	66	50	29
9	FAC Wien	25	55	74	28
10	LASK	24	25	62	26
11	Vorwarts	24	34	64	23
12	Wiener	24	45	74	21
13	Elektra	25	33	117	11

Competiciones que juega

Grupo 7

Tercera Austria Grupo 1

Pos	Equipos		Pts
1		Marchfeld	42
2		Rapid Wien II	37
3		Ebreichsdorf	34
4		Wiener SC	30
5		Stripfing	30
6		Team Wiener Linien	27
7		SC Wiener Viktoria	27
8		Mattersburg II	25
9		Drassburg	25
10		Wiener Neustadt	23
11		Neusiedl	23
12		Mauerwerk	20
13		Bruck/Leitha	19
14		FCM Traiskirchen	16
15		Admira Wacker II	14
16		Leobendorf	9

	Ascenso : Marchfeld
	Playoff Descenso : Mauerwerk, Bruck/Leitha, FCM Traiskirchen
	Descenso : Admira Wacker II, Leobendorf

RIVALES EN Tercera Austria

USO DE MEMORIA

6,937,480 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.2715
Total Execution Time	0.2736

CADENA URL

/historico/Wiener-Neustadt/2020

GET DATOS

$_GET['/historico/Wiener-Neustadt/2020']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0035	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 = 'Wiener-Neustadt' AND l.year = 2020 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.0030	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=3971 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0055	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=3971 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=3971 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0057	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 = 50222
0.0026	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3971 AND type_rel = 2
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 = '3971' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0030	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 = '3971' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	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 = 50222 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	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=3971 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0034	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 (57797,57018,56547,44020) 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 = 44020 AND teamId = 3971
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 57018 AND teamId = 3971
0.0033	SELECT count(id) as num_players from rel_players WHERE league_id = 57797 AND teamId = 3971
0.0158	SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 3971
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* `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 = 50222 AND t.round = 18 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0062	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 events2020 e ON e.player_id = p.id AND e.league_id = 50222 WHERE rp.league_id = 50222 AND rp.teamId = 3971 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.0041	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 events2020 e ON e.player_id = p.id AND e.league_id = 50222 WHERE rp.league_id = 50222 AND rp.teamId = 3971 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2020 e ON e.player_id = p.id AND e.league_id = 50222 WHERE rp.league_id = 50222 AND rp.teamId = 3971 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0114	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 = 3971 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 50222 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.0034	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 = 44020 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* `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 = 38776 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042	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 = 33336 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046	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 = 15704 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 3813 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 2482 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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 = 2014 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036	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 = 1364 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039	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 = 1093 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0058	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 = 870 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040	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 = 8924 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0047	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* `tables1967` 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 = 26094 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038	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* `tables1966` 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 = 26097 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038	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* `tables1965` 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 = 26100 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0050	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* `tables1964` 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 = 26102 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0053	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* `tables1962` 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 = 26112 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044	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* `tables1961` 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 = 26114 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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* `tables1960` 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 = 26117 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036	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* `tables1951` 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 = 26170 AND t.round = 26 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

Wiener Neustadt

Wiener Neustadt

Selecciona un equipo

Competiciones que juega

Tercera Austria Grupo 1

RIVALES EN Tercera Austria