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 2021/2022

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 1
Equipo		PJ	GF	GC	Puntos
1	Salzburg	22	74	26	48
2	LASK	22	50	20	42
3	Rapid Wien	22	47	26	40
4	Wolfsberger	22	50	27	38
5	Sturm Graz	22	37	28	32
6	Hartberg	22	36	50	29
7	Austria Wien	22	33	36	25
8	SCR Altach	22	34	44	24
9	Admira	22	22	43	19
10	WSG Tirol	22	26	50	19
11	Mattersburg	22	26	52	18
12	Polten	22	21	54	17

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

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

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Salzburg	36	86	50	74
2	Rapid Wien	36	89	43	70
3	Austria Wien	36	59	46	62
4	Sturm Graz	36	68	45	60
5	SV Ried	36	58	38	60
6	Austria	36	47	57	41
7	LASK	36	35	67	37
8	Kapfenberger	36	48	81	36
9	Mattersburg	36	42	71	33
10	SCR Altach	36	56	90	30

TEMPORADA 2007/2008

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Rapid Wien	36	69	36	69
2	Salzburg	36	63	42	63
3	Austria Wien	36	46	33	58
4	Sturm Graz	36	60	41	56
5	Mattersburg	36	55	43	53
6	LASK	36	54	47	53
7	SV Ried	36	38	53	38
8	SCR Altach	36	37	64	36
9	Austria	36	26	58	33
10	Wacker	36	32	63	29

TEMPORADA 2006/2007

BUNDESLIGA AUSTRIA
Equipo		PJ	GF	GC	Puntos
1	Salzburg	36	72	25	75
2	SV Ried	36	47	42	56
3	Mattersburg	36	61	58	55
4	Rapid Wien	36	55	49	52
5	SV Pasching	36	47	41	52
6	Austria Wien	36	43	43	45
7	Sturm Graz	36	40	40	41
8	SCR Altach	36	45	64	38
9	Wacker	36	40	64	34
10	Grazer AK	36	43	67	6

Competiciones que juega

Champions League Grupo 7

Pos	Equipos		Pts
1		Lille	11
2		Salzburg	10
3		Sevilla	6
4		Wolfsburg	5

	Siguiente Ronda : Lille, Salzburg
	: Sevilla
	Eliminado : Wolfsburg

RIVALES EN Bundesliga Austr.

RIVALES EN Fase Previa Cham.

RIVALES EN Champions League

RIVALES EN Copa de Austria

USO DE MEMORIA

6,680,560 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.2036
Total Execution Time	0.2048

CADENA URL

/historico/Salzburgo/2022

GET DATOS

$_GET['/historico/Salzburgo/2022']

POST DATOS

No hay datos POST existentes

CONSULTAS (58)

0.0049	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 = 2022 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.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=3698 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=3698 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=3698 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=3698 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=3698 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=3698 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=3698 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=3698 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 = 63998
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 = 66133
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 = 63138
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 = 66905
0.0028	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 = 62629
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 = 63190
0.0017	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3698 AND type_rel = 2
0.0029	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.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 (2898,5070,9022,18982,19087) ORDER BY n.cover_points DESC, update_date DESC
0.0048	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 = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0051	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.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 = 66905 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 = 62629 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 = 63998 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 63190 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0039	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 (2021,2022,2023) 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 (71332,70409,68816,68059,67320,62629) 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.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 71332 AND teamId = 3698
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 68816 AND teamId = 3698
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 70409 AND teamId = 3698
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 62629 AND teamId = 3698
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 68059 AND teamId = 3698
0.0156	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 3698
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 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 = 63998 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0035	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 events2022 e ON e.player_id = p.id AND e.league_id = 63998 WHERE rp.league_id = 63998 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.0033	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 events2022 e ON e.player_id = p.id AND e.league_id = 63998 WHERE rp.league_id = 63998 AND rp.teamId = 3698 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021	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 events2022 e ON e.player_id = p.id AND e.league_id = 63998 WHERE rp.league_id = 63998 AND rp.teamId = 3698 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0053	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 <= 2022 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* `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.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* `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.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* `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.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* `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.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* `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.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 = 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.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* `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.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* `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.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* `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.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 = 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.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* `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.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 = 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.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 = 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.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* `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.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* `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.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* `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.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* `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.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* `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 = 321 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* `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 = 67 AND t.round = 36 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* `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 = 341 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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 = 63998 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 7

RIVALES EN Bundesliga Austr.

RIVALES EN Fase Previa Cham.

RIVALES EN Champions League

RIVALES EN Copa de Austria