12 Dic 19	Finalizado	Eintracht Frankfurt	2 - 3	Vitória Guimarães	58
28 Nov 19	Finalizado	Vitória Guimarães	1 - 1	Standard de Liège	55
06 Nov 19	Finalizado	Vitória Guimarães	1 - 1	Arsenal	221
24 Oct 19	Finalizado	Arsenal	3 - 2	Vitória Guimarães	179
03 Oct 19	Finalizado	Vitória Guimarães	0 - 1	Eintracht Frankfurt	72
19 Sep 19	Finalizado	Standard de Liège	2 - 0	Vitória Guimarães	22

Liga Portuguesa »

24 Jul 20	Finalizado	CD Santa Clara	2 - 2	Vitória Guimarães	75
19 Jul 20	Finalizado	Vitória Guimarães	1 - 0	Marítimo	14
14 Jul 20	Finalizado	Benfica	2 - 0	Vitória Guimarães	98
10 Jul 20	Finalizado	Vitória Guimarães	1 - 2	Gil Vicente	167
04 Jul 20	Finalizado	Portimonense	0 - 1	Vitória Guimarães	22
30 Jun 20	Finalizado	Vitória Guimarães	2 - 0	Vitória Setúbal	29
25 Jun 20	Finalizado	Sporting Braga	3 - 2	Vitória Guimarães	29
19 Jun 20	Finalizado	Vitória Guimarães	1 - 1	Moreirense	48
11 Jun 20	Finalizado	Belenenses SAD	1 - 1	Vitória Guimarães	104
04 Jun 20	Finalizado	Vitória Guimarães	2 - 2	Sporting CP	116
08 Mar 20	Finalizado	Paços de Ferreira	1 - 2	Vitória Guimarães	12
01 Mar 20	Finalizado	Vitória Guimarães	2 - 0	Tondela	7
21 Feb 20	Finalizado	Desportivo Aves	0 - 2	Vitória Guimarães	11
16 Feb 20	Finalizado	Vitória Guimarães	1 - 2	Porto	34
08 Feb 20	Finalizado	Famalicão	0 - 7	Vitória Guimarães	20
02 Feb 20	Finalizado	Boavista	2 - 0	Vitória Guimarães	16
27 Ene 20	Finalizado	Vitória Guimarães	1 - 2	Rio Ave	6
18 Ene 20	Finalizado	Vitória Guimarães	1 - 0	CD Santa Clara	20
12 Ene 20	Finalizado	Marítimo	0 - 0	Vitória Guimarães	30
04 Ene 20	Finalizado	Vitória Guimarães	0 - 1	Benfica	76
15 Dic 19	Finalizado	Gil Vicente	2 - 2	Vitória Guimarães	17
08 Dic 19	Finalizado	Vitória Guimarães	2 - 0	Portimonense	4
01 Dic 19	Finalizado	Vitória Setúbal	1 - 1	Vitória Guimarães	6
10 Nov 19	Finalizado	Vitória Guimarães	0 - 2	Sporting Braga	6
02 Nov 19	Finalizado	Moreirense	1 - 1	Vitória Guimarães	10
30 Oct 19	Finalizado	Vitória Guimarães	5 - 0	Belenenses SAD	3
27 Oct 19	Finalizado	Sporting CP	3 - 1	Vitória Guimarães	31
29 Sep 19	Finalizado	Vitória Guimarães	1 - 0	Paços de Ferreira	61
22 Sep 19	Finalizado	Tondela	1 - 3	Vitória Guimarães	2
14 Sep 19	Finalizado	Vitória Guimarães	5 - 1	Desportivo Aves	7
08 Sep 19	Finalizado	Rio Ave	1 - 1	Vitória Guimarães	33
01 Sep 19	Finalizado	Porto	3 - 0	Vitória Guimarães	13
25 Ago 19	Finalizado	Vitória Guimarães	1 - 1	Famalicão	14
18 Ago 19	Finalizado	Vitória Guimarães	1 - 1	Boavista	12

Taça de Portugal »

19 Oct 19

Finalizado

Sintra

1 - 1

Vitória Guimarães

Partidos Amistosos »

17 Jul 19	Finalizado	Rio Ave	0 - 1	Vitória Guimarães	7
14 Jul 19	Finalizado	Vitória Guimarães	5 - 2	Famalicão	0
10 Jul 19	Finalizado	Vitória Guimarães	1 - 0	Desportivo Aves	4
06 Jul 19	Finalizado	Arouca	2 - 1	Vitória Guimarães	0

Fase Previa Europa League »

29 Ago 19	Finalizado	Vitória Guimarães	1 - 0	FCSB	77
22 Ago 19	Finalizado	FCSB	0 - 0	Vitória Guimarães	13
14 Ago 19	Finalizado	Vitória Guimarães	6 - 0	Ventspils	18
08 Ago 19	Finalizado	Ventspils	0 - 3	Vitória Guimarães	14
01 Ago 19	Finalizado	Vitória Guimarães	4 - 0	Jeunesse d'Esch	12
25 Jul 19	Finalizado	Jeunesse d'Esch	0 - 1	Vitória Guimarães	27

Fases Previas Copa de la Liga »

05 Ago 19

Finalizado

Feirense

0 - 1

Vitória Guimarães Tarjeta Roja

Copa de la Liga Portugal »

22 Ene 20	Finalizado	Vitória Guimarães	1 - 2	Porto	41
21 Dic 19	Finalizado	Vitória Guimarães	3 - 0	SC Covilha	8
04 Dic 19	Finalizado	Vitória Setúbal	0 - 2	Vitória Guimarães	10
25 Sep 19	Finalizado	Benfica	0 - 0	Vitória Guimarães	26

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Vitória Guimarães Temporada 2019/2020

		Edad	Altura	Peso
Portero
63	Celton Biai	23	188	82	-	-	-
1	Douglas Jesus	41	188	80	-	-	-
19	Jhonatan	32	190	82	-	-	-
56	M. Silva	29	189	78	-	-	-
56	Miguel Oliveira	29	196	88	-	-	-
Defensa
37	E. Suliman	26	188	82	-	-	1
29	F. Hanin	34	177	73	1	1	4
3	F. Venâncio	31	186	77	-	-	5
17	Falaye Sacko	28	180	64	-	-	6
79	J. Encada	26	188	70	-	-	-
77	João Correia	27	175	68	-	-	-
42	Lucas Soares	25	174	64	-	-	-
54	M. Mascarenhas	25	180	65	-	-	-
	Marcos Valente	30	196	74	-	-	-
2	Pedrão	31	190	87	-	-	4
4	V. Bondarenko	30	194	88	-	-	2
15	Víctor García	29	178	71	-	-	2
Centrocampista
25	A. Wakaso	32	180	80	-	-	-
70	André Almeida	23	176	62	1	-	1
11	André André	34	174	67	4	-	3
34	Didí	30	177	77	-	-	-
93	E. Abouchabaka	24	183	74	-	-	-
	G. Celis	30	178	74	-	-	-
22	I. Blati Touré	29	170	61	-	-	-
43	J. Amoah	29	177	71	-	1	2
10	J.c. Teixeira	31	177	76	8	-	4
24	M. Agu	30	184	77	1	-	5
18	M. Al Musrati	28	189	83	-	1	5
88	Pêpê	26	183	75	3	-	3
76	Tomás Händel	23	180	69	-	-	-
Delantero
27	Abou Ouattara	24	177	66	1	-	2
81	Aziz	25	187	83	-	-	-
96	Bruno Duarte	28	182	78	8	-	1
91	Davidson	33	177	70	5	1	2
	H. Medarious	26	172	70	-	-	-
45	João Pedro	27	185	78	2	-	-
23	Marcus Edwards	25	168	78	7	-	1
8	O. John	31	179	75	-	-	-
16	Rochinha	28	169	64	1	1	4
	S. Rincón	30	185	68	-	-	-

Noticias del Vitória Guimarães

Ver últimas noticias

Ricardo Valente da la victoria al Vitória Guimaraes en el último suspiro

BeSoccer - Martes, 03 Noviembre 2015

0 194

El Vitoria Guimaraes ganó este lunes a domicilio por 0-1 al Paços Ferreira en el último partido de la novena jornada de la Liga portuguesa de fútbol gracias a un gol de Ricardo Valente en minuto 90.

Sérgio Conceiçao llega al Vitória de Guimaraes como reemplazo de Evangelista

BeSoccer - Miércoles, 23 Septiembre 2015

0 115

El Vitória de Guimaraes presentó este miércoles al técnico portugués Sérgio Conceiçao como nuevo entrenador principal, apenas dos días después de la salida del anterior inquilino del banquillo, Armando Evangelista.

Los técnicos de Académica y Guimaraes dimiten tras la quinta jornada de Liga

BeSoccer - Lunes, 21 Septiembre 2015

0 165

El Académica de Coimbra y el Vitória de Guimaraes anunciaron hoy la salida de sus respectivos entrenadores cuando apenas se llevan cinco jornadas de Liga, en las que son las dos primeras dimisiones de la temporada en Portugal.

El União de Madeira se aupa a novena plaza tras empatar 0-0 con el Guimaraes

BeSoccer - Martes, 01 Septiembre 2015

0 96

El União de Madeira se aupó a la novena plaza de la Liga portuguesa, tras empatar este lunes 0-0 ante el Vitoria de Guimaraes, en una jornada en la que el Belenenses y el Marítimo de Funchal igualaron 1-1.

Casillas, cómodo debut en el Oporto con victoria y portería a 0

BeSoccer - Domingo, 16 Agosto 2015

0 859

El meta español Íker Casillas debutó en la Liga portuguesa con el número '12' de la zamarra del Oporto de forma plácida -tuvo que intervenir apenas en dos ocasiones- beneficiado de una cómoda victoria de su equipo, que derrotó al Guimaraes (3-0).

Ver más noticias del equipo»

Pos	Equipos	Pts
1		Porto	82
2		Benfica	77
3		Sporting Braga	60
4		Sporting CP	60
5		Rio Ave	55
6		Famalicão	54
7		Vitória Guimarães	50
8		Moreirense	43
9		CD Santa Clara	43
10		Gil Vicente	43
11		Marítimo	39
12		Boavista	39
13		Paços de Ferreira	39
14		Tondela	36
15		Belenenses SAD	35
16		Vitória Setúbal	34
17		Portimonense	33
18		Desportivo Aves	17

Pos

Equipos

Pts

	Champions League : Porto
	Previa de Champions : Benfica
	Europa League : Sporting Braga
	Previa de Europa League : Sporting CP, Rio Ave
	Descenso : Vitória Setúbal, Desportivo Aves

Champions League : Porto

Previa de Champions : Benfica

Europa League : Sporting Braga

Previa de Europa League : Sporting CP, Rio Ave

Descenso : Vitória Setúbal, Desportivo Aves

USO DE MEMORIA

7,285,832 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.2185
Total Execution Time	0.2204

CADENA URL

/Vitoria-Guimaraes/2020

GET DATOS

$_GET['/Vitoria-Guimaraes/2020']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0040	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 = 49945
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 = 51196
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 = 51072
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 = 50143
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 = 50420
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 = 51235
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 = 53562
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2730 AND type_rel = 2
0.0023	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2730 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 (6705,9575,13108,13514,20437) ORDER BY n.cover_points DESC, update_date DESC
0.0072	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 = '2730' ORDER BY l.year DESC,cat.coefficient DESC
0.0041	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 = '2730' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023	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 = 50143 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 = 51196 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 = 49945 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 = 51235 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 = 50420 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031	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 = 51072 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	(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 calendars2020 as c ON c.league_id = l.id WHERE (c.datateam1 = 2730 or c.datateam2 = 2730) AND l.year = 2020 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0033	(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 calendars2020 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 = 2730 or c.datateam2 = 2730) AND l.year = 2020 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0029	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2020 as c ON c.league_id = l.id INNER JOIN events2020 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 = 2730 or c.datateam2 = 2730) AND l.year = 2020)
0.0033	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=2730 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0021	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 (60297,58721,57339,56547,51196,51054,50420) 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.0029	SELECT count(id) as num_players from rel_players WHERE league_id = 57339 AND teamId = 2730
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 51196 AND teamId = 2730
0.0033	SELECT count(id) as num_players from rel_players WHERE league_id = 58721 AND teamId = 2730
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 51054 AND teamId = 2730
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 60297 AND teamId = 2730
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 50420 AND teamId = 2730
0.0106	SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 2730
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 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 = 49945 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0045	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 events2020 e ON e.player_id = p.id AND e.league_id = 49945 WHERE rp.league_id = 49945 AND rp.teamId = 2730 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.0042	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 events2020 e ON e.player_id = p.id AND e.league_id = 49945 WHERE rp.league_id = 49945 AND rp.teamId = 2730 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034	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 events2020 e ON e.player_id = p.id AND e.league_id = 49945 WHERE rp.league_id = 49945 AND rp.teamId = 2730 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 2730 AND rp.league_id = 49945 AND l.year= 2020 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0025	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=6281695 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0018	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6281695
0.0036	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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6281695 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.0040	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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6281695 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0026	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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6281695 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0027	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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6281695 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0034	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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6281695 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Vitória Guimarães

Información sobre Vitória Guimarães

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Vitória Guimarães

Estadísticas

Plantilla del Vitória Guimarães Temporada 2019/2020

Noticias del Vitória Guimarães

Vitória Guimarães

Selecciona un equipo

Competiciones que juega

RIVALES EN Fase Previa Euro.

RIVALES EN Europa League

RIVALES EN Liga Portuguesa

RIVALES EN Copa de la Liga.

RIVALES EN Fases Previas Co.

RIVALES EN Taça de Portugal