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

SV Innsbruck

Temporada 2022/2023

TEMPORADA 2022/2023

CUARTA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Völs	29	67	38	52
2	Innsbrucker	29	71	46	52
3	Volders	29	66	50	52
4	Ebbs	29	58	45	50
5	Johann	29	66	54	48
6	Kematen	29	56	46	48
7	Wacker	29	47	42	45
8	Mils	29	72	72	43
9	Sprutz	29	59	56	41
10	Oberperfuss	29	56	62	38
11	Mayrhofen	29	69	67	36
12	Union	29	59	82	34
13	Natters	29	50	61	32
14	SC Münster	29	39	61	30
15	Kirchbichl	29	47	64	27
16	Innsbruck	29	30	66	22

TEMPORADA 2021/2022

TERCERA AUSTRIA GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	SV Hall	8	21	13	30
2	Swarovski	8	22	15	26
3	Wacker	8	21	24	21
4	Fügen	8	20	18	20
5	Innsbruck	8	10	24	12

TEMPORADA 2020/2021

CUARTA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Fügen	15	43	21	34
2	Innsbruck	15	38	23	34
3	Mötz Silz	15	42	21	32
4	Kundl	15	29	17	28
5	Volders	15	34	27	26
6	Johann	15	30	27	23
7	Mils	15	41	36	21
8	Völs	15	26	25	21
9	Natters	14	32	28	20
10	Ebbs	14	27	20	19
11	Kematen	15	26	36	19
12	Kirchbichl	15	36	41	17
13	Zams	15	25	41	15
14	Zirl	15	14	21	13
15	Union	14	19	37	8
16	FC Söll	14	12	53	4

TEMPORADA 2019/2020

CUARTA AUSTRIA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Innsbruck	15	41	20	37
2	Fügen	15	37	24	30
3	Swarovski	15	41	18	29
4	Kirchbichl	15	36	23	29
5	Mötz Silz	15	35	22	26
6	Kematen	15	39	28	25
7	Kundl	15	38	26	23
8	Ebbs	15	31	21	23
9	Volders	15	24	30	19
10	Natters	15	27	29	18
11	Mils	15	28	36	18
12	Völs	15	22	32	16
13	Zams	15	21	41	15
14	Johann	15	22	29	14
15	FC Söll	15	12	40	7
16	Union	15	18	53	7

TEMPORADA 2018/2019

CUARTA AUSTRIA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	SV Hall	30	79	21	71
2	Telfs	30	75	42	61
3	Imst	30	92	44	58
4	Zirl	30	77	43	54
5	Swarovski	30	80	46	53
6	Kematen	30	59	40	52
7	Kirchbichl	30	57	50	43
8	Zams	30	58	67	43
9	Johann	30	43	58	42
10	Kundl	30	39	51	40
11	Innsbruck	30	61	57	38
12	Natters	30	56	80	36
13	Volders	30	36	54	28
14	FC Söll	30	44	85	26
15	Völs	30	29	84	18
16	Union	30	33	96	18

TEMPORADA 2017/2018

CUARTA AUSTRIA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Reichenau	30	106	21	75
2	Telfs	30	81	35	66
3	Zirl	30	75	47	53
4	SV Hall	30	61	43	53
5	Kirchbichl	30	62	58	51
6	Imst	30	68	48	48
7	Kematen	30	70	57	45
8	Innsbruck	30	54	61	37
9	Kundl	30	37	60	36
10	Völs	30	46	60	35
11	Union	30	47	65	34
12	Swarovski	30	42	54	31
13	Johann	30	50	76	31
14	Zams	30	50	88	31
15	Mötz Silz	30	59	86	27
16	Mayrhofen	30	38	87	17

TEMPORADA 2016/2017

CUARTA AUSTRIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Kitzbühel	30	78	28	67
2	Telfs	30	68	29	64
3	Reichenau	30	68	34	64
4	Imst	30	56	37	48
5	Swarovski	30	60	52	45
6	Zirl	30	51	51	45
7	Kirchbichl	30	56	64	45
8	Innsbruck	30	40	45	43
9	SV Hall	30	42	37	40
10	Kematen	30	52	56	37
11	Kundl	30	33	44	37
12	Mötz Silz	30	54	75	36
13	Union	30	54	58	34
14	Völs	30	45	71	33
15	Fügen	30	27	52	26
16	Ebbs	30	38	89	11

TEMPORADA 2015/2016

CUARTA AUSTRIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Wörgl	30	84	41	60
2	Kirchbichl	30	56	48	54
3	Swarovski	30	63	39	51
4	Union	30	51	42	50
5	Telfs	30	66	37	49
6	Kematen	30	58	49	49
7	SV Hall	30	60	40	48
8	Innsbruck	30	59	53	47
9	Imst	30	52	46	41
10	Fügen	30	55	57	39
11	Kundl	30	39	40	38
12	Völs	30	46	60	37
13	Mötz Silz	30	54	66	35
14	Schönwies	30	42	63	31
15	Matrei	30	33	64	24
16	Jenbach	30	27	100	15

TEMPORADA 2014/2015

CUARTA AUSTRIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Reichenau	30	75	32	62
2	Fügen	30	61	30	58
3	Innsbruck	30	71	37	55
4	Kematen	30	57	49	49
5	Union	30	60	44	47
6	Kirchbichl	30	59	51	46
7	Imst	30	44	48	44
8	Swarovski	30	54	52	43
9	Matrei	30	44	59	41
10	SV Hall	30	49	58	39
11	Mötz Silz	30	50	75	37
12	Völs	30	60	71	36
13	Jenbach	30	52	63	35
14	Kundl	30	44	60	35
15	Reutte	30	43	62	31
16	Zirl	30	40	72	21

TEMPORADA 2013/2014

CUARTA AUSTRIA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Kitzbühel	30	90	32	72
2	Reichenau	30	89	34	68
3	Matrei	30	76	53	54
4	Imst	30	60	44	51
5	Kirchbichl	30	67	51	49
6	Union	30	68	54	49
7	Reutte	30	52	46	45
8	SV Hall	30	37	40	42
9	Innsbruck	30	50	64	40
10	Fügen	30	52	47	39
11	Völs	30	57	65	38
12	Kundl	30	41	67	36
13	Mötz Silz	30	45	71	27
14	Zirl	30	35	67	26
15	Hippach	30	33	76	25
16	Neustift	30	35	76	17

TEMPORADA 2012/2013

CUARTA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Schwaz	30	81	38	67
2	Kitzbühel	30	69	41	58
3	Reichenau	30	52	36	56
4	SV Hall	30	53	37	55
5	Matrei	30	74	46	53
6	Imst	30	43	37	44
7	Union	30	51	48	44
8	Innsbruck	30	59	54	43
9	Kirchbichl	30	61	64	43
10	Reutte	30	42	50	40
11	Fügen	30	45	52	37
12	Kundl	30	54	61	34
13	Völs	30	43	62	27
14	Mötz Silz	30	26	54	26
15	Kematen	30	50	80	25
16	Kolsass Weer	30	44	87	20

TEMPORADA 2011/2012

CUARTA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Reichenau	30	79	29	64
2	Imst	30	58	29	57
3	Schwaz	30	66	42	53
4	Innsbruck	30	96	65	49
5	Völs	30	56	42	49
6	Matrei	30	83	59	48
7	Reutte	30	70	50	43
8	Kirchbichl	30	73	63	41
9	Kematen	30	70	59	40
10	Kundl	30	58	53	39
11	Kitzbühel	30	54	52	39
12	Kolsass Weer	30	63	71	39
13	SV Absam	30	55	56	37
14	Telfs	30	45	56	36
15	Johann	30	52	79	34
16	Axams	30	7	180	1

TEMPORADA 2010/2011

CUARTA AUSTRIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	SV Hall	30	93	23	77
2	Kundl	30	76	48	57
3	Matrei	30	81	60	56
4	Schwaz	30	64	38	55
5	Reutte	30	63	52	51
6	Axams	30	58	48	46
7	Kitzbühel	30	44	43	43
8	Imst	30	43	47	43
9	Innsbruck	30	78	60	41
10	Kirchbichl	30	63	54	40
11	Johann	30	49	78	33
12	Telfs	30	35	52	30
13	SV Absam	30	47	66	27
14	Innsbrucker	30	46	89	27
15	Jenbach	30	37	61	23
16	Hippach	30	32	90	22

TEMPORADA 2009/2010

CUARTA AUSTRIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Reichenau	30	75	35	67
2	Matrei	30	81	47	63
3	Imst	30	63	44	57
4	SV Hall	30	61	35	50
5	Jenbach	30	54	44	48
6	Kirchbichl	30	60	52	46
7	Innsbruck	30	46	46	45
8	Innsbrucker	30	50	39	43
9	Kitzbühel	30	54	52	42
10	SV Absam	30	51	49	40
11	Kundl	30	68	68	36
12	Telfs	30	48	60	35
13	Fügen	30	43	58	32
14	Längenfeld	30	33	62	23
15	FC Söll	30	36	90	21
16	Kirchberg	30	31	73	20

TEMPORADA 2008/2009

CUARTA AUSTRIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Wacker	30	95	19	79
2	Kundl	30	85	43	64
3	Fügen	30	61	54	47
4	Reichenau	30	45	41	47
5	Matrei	30	65	45	46
6	Längenfeld	30	46	48	42
7	Telfs	30	47	41	41
8	Innsbrucker	30	61	56	40
9	Kirchberg	30	63	66	40
10	Jenbach	30	50	54	38
11	Kirchbichl	30	51	60	38
12	Innsbruck	30	47	55	37
13	SV Absam	30	47	67	36
14	Oberperfuss	30	48	65	32
15	Kolsass Weer	30	49	85	32
16	Wörgl	30	21	82	15

Competiciones que juega

Cuarta Austria Grupo 3

Pos	Equipos		Pts
1		Völs	52
2		Innsbrucker AC	52
3		Volders	52
4		Ebbs	50
5		SK St. Johann	48
6		Kematen	48
7		Wacker Innsbruck	45
8		Mils	43
9		SPG Sprutz / Serfaus	41
10		Oberperfuss	38
11		Mayrhofen	36
12		Union Innsbruck	34
13		Natters	32
14		SC Münster	30
15		Kirchbichl	27
16		SV Innsbruck	22

	Ascenso : Völs
	Posible siguiente ronda : Union Innsbruck, Natters, SC Münster
	Descenso : Kirchbichl, SV Innsbruck

RIVALES EN Cuarta Austria

USO DE MEMORIA

6,562,568 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1651
Total Execution Time	0.1663

CADENA URL

/historico/Sv-Innsbruck

GET DATOS

$_GET['/historico/Sv-Innsbruck']

POST DATOS

No hay datos POST existentes

CONSULTAS (55)

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 = 'Sv-Innsbruck' 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.0060	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 = 'Sv-Innsbruck' 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=19381 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=19381 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=19381 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=19381 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=19381 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=19381 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=19381 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=19381 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=19381 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=19381 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=19381 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=19381 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=19381 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=19381 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=19381 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=19381 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=19381 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=19381 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=19381 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=19381 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=19381 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=19381 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=19381 AND type_rel = 2
0.0023	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 = '19381' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '19381' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '19381' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026	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=19381 AND l.year in (2022,2023,2024) 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 (68326,67294) 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 = 67294 AND teamId = 19381
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 68326 AND teamId = 19381
0.0020	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 = '19381' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19381' 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 = '19381' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032	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 events2023 e ON e.player_id = p.id AND e.league_id = 68326 WHERE rp.league_id = 68326 AND rp.teamId = 19381 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.0032	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 events2023 e ON e.player_id = p.id AND e.league_id = 68326 WHERE rp.league_id = 68326 AND rp.teamId = 19381 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 events2023 e ON e.player_id = p.id AND e.league_id = 68326 WHERE rp.league_id = 68326 AND rp.teamId = 19381 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 = 19381 AND l.year <= 2023 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 = 68326 AND t.round = 30 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* `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.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 = 67294 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 = 57778 AND t.round = 30 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* `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 = 50453 AND t.round = 15 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* `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 = 44311 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* `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 = 38914 AND t.round = 30 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* `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 = 33431 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* `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 = 15769 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* `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 = 3940 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* `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 = 27172 AND t.round = 30 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* `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 = 27167 AND t.round = 30 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* `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 = 27194 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* `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 = 27214 AND t.round = 30 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 = 27223 AND t.round = 30 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* `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 = 27257 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

SV Innsbruck

SV Innsbruck

Selecciona un equipo

Competiciones que juega

Cuarta Austria Grupo 3

RIVALES EN Cuarta Austria