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

Salzburg

Entrenador: Onur Cinel

Temporada 2023/2024

TEMPORADA 2023/2024

BUNDESLIGA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Salzburg	26	53	17	32
2	Sturm Graz	26	45	17	32
3	LASK	26	30	20	24
4	Rapid Wien	26	43	23	22
5	Austria	26	32	35	19
6	Hartberg	26	37	41	18

TEMPORADA 2022/2023

BUNDESLIGA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Salzburg	32	67	22	49
2	Sturm Graz	32	57	29	42
3	LASK	32	54	38	35
4	Rapid Wien	32	50	47	25
5	Austria Wien	32	55	52	24
6	Austria	32	45	63	23

TEMPORADA 2021/2022

BUNDESLIGA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Salzburg	10	27	6	52
2	Sturm Graz	10	16	14	37
3	Austria Wien	10	13	16	29
4	Wolfsberger	10	14	21	28
5	Rapid Wien	10	13	14	25
6	Austria	10	12	24	21

TEMPORADA 2020/2021

BUNDESLIGA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Salzburg	32	94	33	51
2	Rapid Wien	32	64	40	36
3	Sturm Graz	32	52	34	36
4	LASK	32	55	41	30
5	Wolfsberger	32	52	62	27
6	WSG Tirol	32	53	60	23

TEMPORADA 2019/2020

BUNDESLIGA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Salzburg	10	36	8	50
2	Rapid Wien	10	17	17	38
3	Wolfsberger	10	19	16	35
4	LASK	10	17	17	33
5	Hartberg	10	16	24	27
6	Sturm Graz	10	9	32	19

TEMPORADA 2018/2019

BUNDESLIGA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Salzburg	10	28	9	52
2	LASK	10	19	12	40
3	Wolfsberger	10	15	16	31
4	Austria Wien	10	16	20	27
5	Sturm Graz	10	11	17	24
6	Polten	10	6	21	21

TEMPORADA 2017/2018

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Salzburg	36	81	29	83
2	Sturm Graz	36	68	45	70
3	Rapid Wien	36	68	43	62
4	LASK	36	49	41	57
5	Admira	36	59	66	51
6	Mattersburg	36	50	56	46
7	Austria Wien	36	51	55	43
8	SCR Altach	36	35	51	38
9	Wolfsberger	36	31	57	33
10	Polten	36	28	77	20

TEMPORADA 2016/2017

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Salzburg	36	74	24	81
2	Austria Wien	36	72	50	63
3	Sturm Graz	36	55	39	60
4	SCR Altach	36	46	49	53
5	Rapid Wien	36	52	42	46
6	Admira	36	36	55	46
7	Mattersburg	36	39	54	43
8	Wolfsberger	36	40	59	42
9	Polten	36	41	60	37
10	SV Ried	36	33	56	35

TEMPORADA 2015/2016

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Salzburg	36	71	33	74
2	Rapid Wien	36	66	42	65
3	Austria Wien	36	65	48	59
4	Admira	36	45	51	50
5	Sturm Graz	36	40	40	48
6	Wolfsberger	36	33	36	43
7	SV Ried	36	36	52	42
8	SCR Altach	36	39	49	40
9	Mattersburg	36	40	70	39
10	Grödig	36	42	56	35

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

Competiciones que juega

Champions League Grupo 4

Pos	Equipos		Pts
1		Real Sociedad	12
2		Inter	12
3		Benfica	4
4		Salzburg	4

	Siguiente Ronda : Real Sociedad, Inter
	: Benfica
	Eliminado : Salzburg

RIVALES EN Bundesliga Austr.

RIVALES EN Champions League

RIVALES EN Copa de Austria

USO DE MEMORIA

6,195,280 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.7230
Total Execution Time	0.7250

CADENA URL

/historico/Salzburgo

GET DATOS

$_GET['/historico/Salzburgo']

POST DATOS

No hay datos POST existentes

CONSULTAS (50)

0.0195	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 = 'Salzburgo' 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.0109	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=3698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0109	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=3698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110	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=3698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111	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=3698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112	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=3698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112	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=3698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0134	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 = 72085
0.0110	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3698 AND type_rel = 2
0.0155	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3698 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0119	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 (1311412,2898,5070,9022,18982) ORDER BY n.cover_points DESC, update_date DESC
0.0174	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 = '3698' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0185	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 = '3698' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0106	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 = 75596 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0121	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=3698 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106	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 (75596,73860,72330,71432,70409) 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.0115	SELECT count(id) as num_players from rel_players WHERE league_id = 75596 AND teamId = 3698
0.0112	SELECT count(id) as num_players from rel_players WHERE league_id = 73860 AND teamId = 3698
0.0116	SELECT count(id) as num_players from rel_players WHERE league_id = 70409 AND teamId = 3698
0.0120	SELECT count(id) as num_players from rel_players WHERE league_id = 72330 AND teamId = 3698
0.0393	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 3698
0.0112	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 = 73860 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0110	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 = '3698' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3698' and rp.type = 4
0.0107	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 = '3698' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0120	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 = 73860 WHERE rp.league_id = 73860 AND rp.teamId = 3698 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.0119	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 = 73860 WHERE rp.league_id = 73860 AND rp.teamId = 3698 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0106	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 = 73860 WHERE rp.league_id = 73860 AND rp.teamId = 3698 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0120	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 = 3698 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0110	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* `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 = 72085 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.0107	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* `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 = 75596 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108	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 = 67768 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.0119	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 = 71332 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.0129	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 = 63138 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.0116	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 = 66905 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.0113	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 = 58504 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.0110	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 = 61918 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.0110	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 = 50148 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.0118	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 = 55611 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.0122	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 = 43673 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0119	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 = 49411 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123	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 = 38775 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123	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 = 29662 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124	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 = 15404 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124	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.0124	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.0120	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.0127	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.0125	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.0114	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 = 73860 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

Salzburg

Salzburg

Selecciona un equipo

Competiciones que juega

Champions League Grupo 4

RIVALES EN Bundesliga Austr.

RIVALES EN Champions League

RIVALES EN Copa de Austria