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

Sturm Graz

Entrenador: Christian Ilzer

Temporada 2000/2001

TEMPORADA 2000/2001

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Tirol	36	63	31	68
2	Rapid Wien	36	62	36	60
3	Grazer AK	36	49	40	57
4	Sturm Graz	36	58	44	55
5	Austria Wien	36	47	43	50
6	Salzburg	36	49	45	49
7	SV Ried	36	51	52	48
8	SW Bregenz	36	40	67	38
9	Admira	36	29	63	36
10	LASK	36	43	70	33

TEMPORADA 1999/2000

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Tirol	36	54	30	77
2	Sturm Graz	36	77	32	74
3	Rapid Wien	36	59	29	66
4	Austria Wien	36	49	44	54
5	SV Ried	36	56	39	53
6	Salzburg	36	39	45	46
7	Grazer AK	36	41	62	42
8	LASK	36	41	49	39
9	SW Bregenz	36	39	73	35
10	Austria	36	22	74	19

TEMPORADA 1998/1999

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Sturm Graz	36	72	32	73
2	Rapid Wien	36	50	25	70
3	Grazer AK	36	46	29	65
4	Salzburg	36	55	40	57
5	LASK	36	53	44	57
6	Tirol	36	49	41	55
7	Austria Wien	36	41	44	50
8	SV Ried	36	25	47	32
9	Austria	36	24	61	23
10	Vorwarts	36	29	81	15

TEMPORADA 1997/1998

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Sturm Graz	36	80	28	81
2	Rapid Wien	36	42	36	62
3	Grazer AK	36	53	33	61
4	Salzburg	36	48	33	56
5	LASK	36	67	58	55
6	Tirol	36	49	51	48
7	Austria Wien	36	39	54	40
8	SV Ried	36	42	55	39
9	Austria	36	38	59	32
10	Admira	36	34	85	22

TEMPORADA 1996/1997

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Salzburg	36	54	25	69
2	Rapid Wien	36	69	36	66
3	Sturm Graz	36	50	31	55
4	Tirol	36	49	40	55
5	Grazer AK	36	39	42	47
6	Austria Wien	36	41	51	46
7	LASK	36	38	47	44
8	SV Ried	36	44	59	42
9	FC Linz	36	28	47	31
10	Admira	36	35	69	28

TEMPORADA 1995/1996

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Rapid Wien	36	68	38	73
2	Sturm Graz	36	61	35	67
3	Tirol	36	66	39	63
4	Grazer AK	36	46	36	57
5	Austria Wien	36	42	35	51
6	LASK	36	36	35	48
7	SV Ried	36	46	55	45
8	Salzburg	36	53	52	44
9	Admira	36	35	61	34
10	Vorwarts	36	25	92	6

TEMPORADA 1994/1995

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Salzburg	36	48	24	47
2	Sturm Graz	36	58	41	47
3	Rapid Wien	36	63	50	46
4	Austria Wien	36	58	38	43
5	Tirol	36	61	44	40
6	LASK	36	51	44	39
7	Admira	36	48	55	33
8	Vorwarts	36	40	49	29
9	FC Linz	36	33	81	20
10	Modling	36	28	62	16

TEMPORADA 1993/1994

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Salzburg	36	56	18	51
2	Austria Wien	36	63	39	49
3	Admira	36	51	35	44
4	Tirol	36	48	33	39
5	Rapid Wien	36	38	42	35
6	Modling	36	32	49	35
7	Sturm Graz	36	37	42	33
8	Vorwarts	36	43	54	26
9	Polten	36	37	57	26
10	Wiener SC	36	21	57	22

TEMPORADA 1992/1993

BUNDESLIGA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Salzburg	22	45	27	29
2	Tirol	22	45	22	28
3	Austria Wien	22	47	25	28
4	Wiener SC	22	31	33	27
5	Rapid Wien	22	34	26	26
6	Admira	22	47	33	25
7	Polten	22	34	37	22
8	Vorwarts	22	30	34	22
9	Modling	22	39	41	19
10	LASK	22	21	46	14
11	FC Linz	22	20	43	12
12	Sturm Graz	22	23	49	12

TEMPORADA 1991/1992

BUNDESLIGA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Salzburg	22	43	18	34
2	Austria Wien	22	51	21	33
3	Swarovski	22	48	34	29
4	FC Linz	22	36	24	28
5	Rapid Wien	22	37	24	27
6	Admira	22	33	22	27
7	Polten	22	25	34	18
8	Vorwarts	22	28	29	17
9	Sturm Graz	22	21	36	15
10	Kremser SC	22	23	43	14
11	First Vienna	22	20	43	14
12	Leoben	22	11	48	8

TEMPORADA 1990/1991

BUNDESLIGA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Austria Wien	14	24	12	36
2	Swarovski	14	29	17	35
3	Sturm Graz	14	18	12	32
4	Rapid Wien	14	20	20	27
5	Salzburg	14	20	20	24
6	Admira	14	14	19	23
7	Vorwarts	14	14	24	21
8	Leoben	14	13	28	19

TEMPORADA 1989/1990

BUNDESLIGA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Swarovski	22	41	22	32
2	Austria Wien	22	50	25	31
3	Admira	22	58	38	29
4	Rapid Wien	22	44	30	28
5	Sturm Graz	22	23	17	23
6	First Vienna	22	38	40	21
7	Salzburg	22	29	31	21
8	Polten	22	25	31	21
9	Kremser SC	22	32	33	20
10	Vorwarts	22	22	40	14
11	Wiener SC	22	20	43	13
12	Grazer AK	22	16	48	11

TEMPORADA 1988/1989

BUNDESLIGA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Swarovski	22	50	25	33
2	Admira	22	45	27	31
3	Austria Wien	22	54	26	30
4	Polten	22	34	34	25
5	Rapid Wien	22	35	26	24
6	First Vienna	22	31	34	22
7	Grazer AK	22	27	37	22
8	Wiener SC	22	39	43	20
9	Vorwarts	22	21	31	18
10	Austria	22	29	47	16
11	Sturm Graz	22	21	35	12
12	LASK	22	21	42	11

TEMPORADA 1987/1988

BUNDESLIGA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Rapid Wien	14	29	18	36
2	Austria Wien	14	36	20	32
3	Sturm Graz	14	22	16	30
4	First Vienna	14	23	25	28
5	Admira	14	21	20	26
6	Swarovski	14	13	19	25
7	Grazer AK	14	18	37	22
8	Wiener SC	14	24	31	20

TEMPORADA 1986/1987

BUNDESLIGA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Austria Wien	0	0	0	17
2	Rapid Wien	0	0	0	15
3	Swarovski	0	0	0	15
4	Admira	0	0	0	11
5	FC Linz	0	0	0	11
6	LASK	0	0	0	11
7	Sturm Graz	0	0	0	11
8	Wiener SC	0	0	0	11

Competiciones que juega

Champions League Grupo 4

Pos	Equipos		Pts
1		Sturm Graz	10
2		Galatasaray SK	8
3		Rangers FC	8
4		Monaco	7

	Siguiente Ronda : Sturm Graz, Galatasaray SK
	: Rangers FC
	Eliminado : Monaco

RIVALES EN Bundesliga Austr.

RIVALES EN Champions League

RIVALES EN Fase Previa Cham.

RIVALES EN Copa de Austria

USO DE MEMORIA

6,560,040 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1859
Total Execution Time	0.1871

CADENA URL

/historico/Sturm-Graz/2001

GET DATOS

$_GET['/historico/Sturm-Graz/2001']

POST DATOS

No hay datos POST existentes

CONSULTAS (61)

0.0039	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 = 'Sturm-Graz' AND l.year = 2001 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=2432 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=2432 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=2432 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=2432 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=2432 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=2432 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=2432 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026	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 = 9671
0.0025	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 = 9675
0.0023	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 = 347
0.0025	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 = 40764
0.0025	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 = 40766
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 = 23363
0.0020	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2432 AND type_rel = 2
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2432 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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 (1220,44393,52034,167797,365416) ORDER BY n.cover_points DESC, update_date DESC
0.0035	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 = '2432' AND l.year = 2001 ORDER BY l.year DESC,cat.coefficient DESC
0.0035	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 = '2432' 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 = 347 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 9675 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 = 40764 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 = 23363 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0035	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=2432 AND l.year in (2000,2001,2002) 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 (56355,42335,23363,11995,10974,9684,348) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 348 AND teamId = 2432
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 9684 AND teamId = 2432
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 10974 AND teamId = 2432
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 42335 AND teamId = 2432
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 23363 AND teamId = 2432
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 56355 AND teamId = 2432
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 11995 AND teamId = 2432
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 FROM* `tables2001` 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 = 9671 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022	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 = '2432' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2432' 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 = '2432' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0039	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 events2001 e ON e.player_id = p.id AND e.league_id = 9671 WHERE rp.league_id = 9671 AND rp.teamId = 2432 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.0030	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 events2001 e ON e.player_id = p.id AND e.league_id = 9671 WHERE rp.league_id = 9671 AND rp.teamId = 2432 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 events2001 e ON e.player_id = p.id AND e.league_id = 9671 WHERE rp.league_id = 9671 AND rp.teamId = 2432 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0044	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 = 2432 AND l.year <= 2001 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `tables2001` 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 = 347 AND t.round = 36 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* `tables2000` 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 = 348 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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* `tables1999` 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 = 349 AND t.round = 36 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* `tables1998` 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 = 350 AND t.round = 36 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* `tables1997` 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 = 351 AND t.round = 36 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* `tables1996` 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 = 352 AND t.round = 36 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* `tables1995` 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 = 353 AND t.round = 36 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* `tables1994` 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 = 354 AND t.round = 36 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* `tables1993` 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 = 10030 AND t.round = 22 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* `tables1992` 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 = 10029 AND t.round = 22 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* `tables1991` 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 = 10028 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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* `tables1991` 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 = 10036 AND t.round = 36 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* `tables1990` 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 = 10035 AND t.round = 36 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* `tables1990` 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 = 10027 AND t.round = 22 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* `tables1989` 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 = 10062 AND t.round = 14 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* `tables1989` 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 = 10026 AND t.round = 22 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* `tables1988` 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 = 10025 AND t.round = 22 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* `tables1988` 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 = 10033 AND t.round = 36 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* `tables1987` 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 = 10024 AND t.round = 22 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* `tables1987` 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 = 10032 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 9671 ORDER BY nameShow LIMIT 100


	¿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

Sturm Graz

Sturm Graz

Selecciona un equipo

Competiciones que juega

Champions League Grupo 4

RIVALES EN Bundesliga Austr.

RIVALES EN Champions League

RIVALES EN Fase Previa Cham.

RIVALES EN Copa de Austria