07 Dic 17	Finalizado	Austria Wien	0 - 0	AEK Athens	25
23 Nov 17	Finalizado	Milan	5 - 1	Austria Wien	158
02 Nov 17	Finalizado	HNK Rijeka	1 - 4	Austria Wien	42
19 Oct 17	Finalizado	Austria Wien	1 - 3	HNK Rijeka	41
28 Sep 17	Finalizado	AEK Athens	2 - 2	Austria Wien	50
14 Sep 17	Finalizado	Austria Wien	1 - 5	Milan	413

Partidos Amistosos »

27 Jun 18	Finalizado	SC Oberpullendorf	0 - 12	Austria Wien	4
24 Jun 18	Finalizado	SC Bisamberg	0 - 2	Austria Wien	1
23 Jun 18	Finalizado	Sportunion Mauer	0 - 2	Austria Wien	1
30 Ene 18	Finalizado	Austria Wien	0 - 2	Zbrojovka Brno	0
26 Ene 18	Finalizado	Slovan Liberec	1 - 1	Austria Wien	4
~~24 Ene 18~~	Aplazado	Anorthosis	-	Austria Wien	1
22 Ene 18	Finalizado	Dinamo Bucureşti	3 - 2	Austria Wien	6
20 Ene 18	Finalizado	Austria Wien	1 - 1	Górnik Zabrze	1
16 Ene 18	Finalizado	FAC Wien	1 - 1	Austria Wien	20
13 Ene 18	Finalizado	Wiener Neustadt	2 - 6	Austria Wien	0
10 Nov 17	Finalizado	Austria Wien	3 - 2	Stade Brestois	3
05 Oct 17	Finalizado	Austria Wien	0 - 3	TSV Hartberg	0
02 Sep 17	Finalizado	Austria Wien	4 - 1	Weinviertel	1
01 Sep 17	Finalizado	Ankerbrot	0 - 16	Austria Wien	12
08 Ago 17	Finalizado	St. Georgen	1 - 12	Austria Wien	17
11 Jul 17	Finalizado	Kapfenberger SV	1 - 3	Austria Wien	8
08 Jul 17	Finalizado	Parndorf	0 - 6	Austria Wien	0
05 Jul 17	Finalizado	Austria Wien	4 - 0	DAC	1
04 Jul 17	Finalizado	Austria Wien	1 - 2	Zenit	10

Fase Previa Europa League »

24 Ago 17	Finalizado	Austria Wien	0 - 1	NK Osijek	46
17 Ago 17	Finalizado	NK Osijek	1 - 2	Austria Wien	13
02 Ago 17	Finalizado	AEL Limassol	1 - 2	Austria Wien	42
27 Jul 17	Finalizado	Austria Wien	0 - 0	AEL Limassol	24

Bundesliga Austria »

27 May 18	Finalizado	Austria Wien	4 - 0	Salzburg	19
20 May 18	Finalizado	SKN St. Polten	2 - 0	Austria Wien	9
15 May 18	Finalizado	Wolfsberger AC	2 - 1	Austria Wien	25
05 May 18	Finalizado	Austria Wien	0 - 0	Admira	1
28 Abr 18	Finalizado	Austria Wien	2 - 3	Mattersburg	0
21 Abr 18	Finalizado	LASK	1 - 0	Austria Wien	16
15 Abr 18	Finalizado	Austria Wien	0 - 4	Rapid Wien	2
07 Abr 18	Finalizado	Sturm Graz	0 - 2	Austria Wien	8
31 Mar 18	Finalizado	Austria Wien	2 - 1	SCR Altach	4
18 Mar 18	Finalizado	Salzburg	5 - 0	Austria Wien	5
10 Mar 18	Finalizado	Austria Wien	4 - 0	SKN St. Polten	3
03 Mar 18	Finalizado	Austria Wien	2 - 0	Wolfsberger AC	0
24 Feb 18	Finalizado	Admira	2 - 1	Austria Wien	0
17 Feb 18	Finalizado	Mattersburg	2 - 1	Austria Wien	4
10 Feb 18	Finalizado	Austria Wien	1 - 3	LASK	1
04 Feb 18	Finalizado	Rapid Wien	1 - 1	Austria Wien	7
17 Dic 17	Finalizado	Austria Wien	1 - 0	Sturm Graz	5
10 Dic 17	Finalizado	SCR Altach	1 - 0	Austria Wien	3
03 Dic 17	Finalizado	Austria Wien	1 - 1	Salzburg	2
29 Nov 17	Finalizado	SKN St. Polten	1 - 0	Austria Wien	11
26 Nov 17	Finalizado	Wolfsberger AC	1 - 2	Austria Wien	0
18 Nov 17	Finalizado	Austria Wien	2 - 3	Admira	6
05 Nov 17	Finalizado	Austria Wien	1 - 3	Mattersburg	5
28 Oct 17	Finalizado	LASK	2 - 2	Austria Wien	2
22 Oct 17	Finalizado	Austria Wien	0 - 1	Rapid Wien	0
15 Oct 17	Finalizado	Sturm Graz	3 - 0	Austria Wien	18
01 Oct 17	Finalizado	Austria Wien	2 - 0	SCR Altach	0
24 Sep 17	Finalizado	Salzburg	0 - 0	Austria Wien	12
17 Sep 17	Finalizado	Austria Wien	5 - 1	SKN St. Polten	2
09 Sep 17	Finalizado	Austria Wien	2 - 2	Wolfsberger AC	5
27 Ago 17	Finalizado	Admira	1 - 3	Austria Wien	6
20 Ago 17	Finalizado	Mattersburg	1 - 3	Austria Wien	2
12 Ago 17	Finalizado	Austria Wien	2 - 0	LASK	3
06 Ago 17	Finalizado	Rapid Wien	2 - 2	Austria Wien	1
30 Jul 17	Finalizado	Austria Wien	2 - 3	Sturm Graz	6
23 Jul 17	Finalizado	SCR Altach	3 - 0	Austria Wien	1

Copa de Austria »

25 Oct 17	Finalizado	Austria Wien	1 - 2	Rapid Wien	0
20 Sep 17	Finalizado	Vöcklamarkt	0 - 3	Austria Wien	1
14 Jul 17	Finalizado	Ebreichsdorf	0 - 0	Austria Wien	27

Estadísticas

GOLEADORES

Kevin Friesenbichler1

AMARILLAS

Kevin Friesenbichler1

A. Kadiri1

Felipe Pires1

Plantilla del Austria Wien Temporada 2017/2018

		Edad	Altura	Peso
Portero
99	M. Kos	27	183	80	-	-	-
31	O. Hadžikić	28	186	80	-	-	-
32	Patrick Pentz	27	183	81	-	-	-
	Robert Almer	40	193	87	-	-	-
Defensa
24	A. Borkovic	24	184	74	1	-	-
28	Christoph Martschinko	30	175	78	-	-	-
16	D. Prokop	26	172	68	2	-	-
23	David De Paula	39	176	69	-	-	-
17	F. Klein	37	180	68	-	-	1
18	H. Westermann	40	190	87	-	-	-
19	M. Blauensteiner	29	182	78	-	-	-
2	Petar Gluhakovic	28	170	73	-	-	-
	S. Jonovic	28	185	-	-	-	-
25	T. Salamon	35	175	74	-	-	2
15	T. Serbest	29	184	79	1	-	-
Centrocampista
	A. Grünwald	34	188	79	-	-	-
6	A. Kadiri	28	186	88	-	-	1
	D. Cancola	27	184	73	-	-	-
8	I. Alhassan	27	192	76	-	-	2
21	Jin-Hyun Lee	26	173	65	-	-	-
26	R. Holzhauser	31	193	88	-	-	1
4	Ruan	-	-	-	-	-	-
	V. Demaku	24	180	68	-	-	-
Delantero
14	C. Monschein	31	178	74	3	-	2
95	Felipe Pires	29	178	68	-	-	1
7	Ismael Tajouri	30	168	64	1	-	-
9	Kevin Friesenbichler	29	185	75	1	-	1
39	M. Sarkaria	27	180	70	-	-	-
11	Venuto	29	164	60	-	-	-

Noticias del Austria Wien

Ver últimas noticias

El Norwich va a por Gorgon

Jaime González Pons - Viernes, 05 Agosto 2016

0 171

El futbolista, que ha jugado toda su carrera en el Austria de Viena, está libre desde el 30 de junio, cuando se concluyó su contrato con el club austriaco.

El Benfica se desprende de Friesenbichler

BeSoccer - Sábado, 23 Julio 2016

0 369

El cuerpo técnico de la entidad portuguesa no cuenta con las cualidades del delantero Kevin Friesenbichler, motivo más que suficiente para abandonar el club en busca de minutos.

El Austria de Viena golea 9-0 al Mattersburg y repite su récord goleador

BeSoccer - Domingo, 24 Abril 2016

0 816

El Austria de Viena ha logrado hoy repetir hoy la mayor goleada de su historia, lograda en 2004, al endosarle al Mattersburg nueve goles a cero en un partido de la Bundesliga austríaca.

El Rapid gana el derbi de Viena y alcanza al Salzburgo

BeSoccer - Domingo, 14 Febrero 2016

0 197

El Rapid Viena ganó el derbi al Austria Viena (0-3) y, beneficiado por el tropiezo del Salzburgo ante el Ried (1-0) el sábado, se situó a la altura del liderato de la Liga de Austria, que completó la vigésima segunda jornada.

El Rapid se pone a un punto del Austria Viena, líder provisional

BeSoccer - Domingo, 07 Febrero 2016

0 131

El Rapid Viena, rival del Valencia en la Europa League, ganó al Wolfsberger (3-0) en el retorno de la Liga de Austria tras el parón invernal, y se situó a un punto del Austria Viena, que venció a domicilio al Groedig (0-1) y se instaló como líder provisional a expensas del Salzburgo.

Ver más noticias del equipo»

Competiciones que juega

Europa League Grupo 4

Pos	Equipos		Pts
1		Milan	11
2		AEK Athens	8
3		HNK Rijeka	7
4		Austria Wien	5

	Siguiente Ronda : Milan, AEK Athens

RIVALES EN Bundesliga Austr.

RIVALES EN Copa de Austria

RIVALES EN Europa League

RIVALES EN Fase Previa Euro.

USO DE MEMORIA

6,568,176 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.7416
Total Execution Time	0.7436

CADENA URL

/Austria-Wien/2018

GET DATOS

$_GET['/Austria-Wien/2018']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0198	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 = 'Austria-Wien' AND l.year = 2018 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.0126	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=397 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=397 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=397 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=397 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=397 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=397 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=397 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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 = 39627
0.0135	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 = 38775
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=397 AND type_rel = 2
0.0129	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 397 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0131	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 (40425,42471,63496,93173,97489) ORDER BY n.cover_points DESC, update_date DESC
0.0148	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 = '397' AND l.year = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0156	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 = '397' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129	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 = 38775 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126	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 = 39627 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130	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 = 38744 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133	(SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2018 as c ON c.league_id = l.id WHERE (c.datateam1 = 397 or c.datateam2 = 397) AND l.year = 2018 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0149	(SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2018 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 397 or c.datateam2 = 397) AND l.year = 2018 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0167	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2018 as c ON c.league_id = l.id INNER JOIN events2018 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 397 or c.datateam2 = 397) AND l.year = 2018)
0.0143	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=397 AND l.year in (2017,2018,2019) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (49411,44346,43475,39627,38745) 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.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 49411 AND teamId = 397
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 39627 AND teamId = 397
0.0136	SELECT count(id) as num_players from rel_players WHERE league_id = 38745 AND teamId = 397
0.0167	SELECT count(id) as num_players from rel_players WHERE league_id = 44346 AND teamId = 397
0.0493	SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 397
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 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 = 39627 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0134	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 events2018 e ON e.player_id = p.id AND e.league_id = 39627 WHERE rp.league_id = 39627 AND rp.teamId = 397 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.0132	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 events2018 e ON e.player_id = p.id AND e.league_id = 39627 WHERE rp.league_id = 39627 AND rp.teamId = 397 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127	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 events2018 e ON e.player_id = p.id AND e.league_id = 39627 WHERE rp.league_id = 39627 AND rp.teamId = 397 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129	SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 397 AND rp.league_id = 39627 AND l.year= 2018 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0133	SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=817591 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0125	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=817591
0.0131	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=817591 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0129	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=817591 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0127	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=817591 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0128	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=817591 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0129	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=817591 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0127	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 = 39627 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

Austria Wien

Información sobre Austria Wien

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Austria Wien