09 Dic 21	Finalizado	Real Sociedad	3 - 0	PSV	457
25 Nov 21	Finalizado	PSV	2 - 0	Sturm Graz	140
04 Nov 21	Finalizado	Monaco	0 - 0	PSV	325
21 Oct 21	Finalizado	PSV	1 - 2	Monaco	236
30 Sep 21	Finalizado	Sturm Graz	1 - 4	PSV	49
16 Sep 21	Finalizado	PSV	2 - 2	Real Sociedad	397

Conference League »

14 Abr 22	Finalizado	PSV	1 - 2	Leicester	550
07 Abr 22	Finalizado	Leicester	0 - 0	PSV	451
17 Mar 22	Finalizado	Kobenhavn	0 - 4	PSV	237
10 Mar 22	Finalizado	PSV	4 - 4	Kobenhavn	712
24 Feb 22	Finalizado	Maccabi Tel Aviv	1 - 1	PSV	265
17 Feb 22	Finalizado	PSV	1 - 0	Maccabi Tel Aviv	164

Eredivisie »

15 May 22	Finalizado	PEC Zwolle	1 - 2	PSV	97
11 May 22	Finalizado	PSV	3 - 2	NEC Nijmegen	74
08 May 22	Finalizado	Feyenoord	2 - 2	PSV	179
01 May 22	Finalizado	PSV	4 - 2	Willem II	54
23 Abr 22	Finalizado	Cambuur	1 - 2	PSV	93
10 Abr 22	Finalizado	PSV	2 - 0	RKC Waalwijk	82
02 Abr 22	Finalizado	Twente	3 - 3	PSV	150
20 Mar 22	Finalizado	PSV	5 - 0	Fortuna Sittard	17
13 Mar 22	Finalizado	Utrecht	0 - 1	PSV	29
06 Mar 22	Finalizado	PSV	3 - 1	Heracles	17
27 Feb 22	Finalizado	Sparta Rotterdam	1 - 2	PSV	80
20 Feb 22	Finalizado	PSV	3 - 1	Heerenveen	37
12 Feb 22	Finalizado	Vitesse	0 - 5	PSV	82
05 Feb 22	Finalizado	PSV	1 - 2	AZ Alkmaar	69
23 Ene 22	Finalizado	PSV	1 - 2	Ajax	119
16 Ene 22	Finalizado	Groningen	0 - 1	PSV	19
23 Dic 21	Finalizado	PSV	2 - 0	Go Ahead Eagles	336
19 Dic 21	Finalizado	RKC Waalwijk	1 - 4	PSV	66
12 Dic 21	Finalizado	NEC Nijmegen	1 - 2	PSV	242
04 Dic 21	Finalizado	PSV	4 - 1	Utrecht	24
28 Nov 21	Finalizado	Heerenveen	1 - 1	PSV	31
20 Nov 21	Finalizado	PSV	2 - 0	Vitesse	26
07 Nov 21	Finalizado	Fortuna Sittard	1 - 4	PSV	26
30 Oct 21	Finalizado	PSV	5 - 2	Twente	15
24 Oct 21	Finalizado	Ajax	5 - 0	PSV	140
16 Oct 21	Finalizado	PSV	3 - 1	PEC Zwolle	113
03 Oct 21	Finalizado	PSV	2 - 1	Sparta Rotterdam	45
25 Sep 21	Finalizado	Willem II	2 - 1	PSV	54
22 Sep 21	Finalizado	Go Ahead Eagles	1 - 2	PSV	223
19 Sep 21	Finalizado	PSV	0 - 4	Feyenoord	94
11 Sep 21	Finalizado	AZ Alkmaar	0 - 3	PSV	88
28 Ago 21	Finalizado	PSV	5 - 2	Groningen	47
21 Ago 21	Finalizado	PSV	4 - 1	Cambuur	77
14 Ago 21	Finalizado	Heracles	0 - 2	PSV	58

KNVB Beker »

17 Abr 22	Finalizado	PSV	2 - 1	Ajax	194
02 Mar 22	Finalizado	Go Ahead Eagles	1 - 2	PSV	101
08 Feb 22	Finalizado	PSV	4 - 0	NAC Breda	52
20 Ene 22	Finalizado	PSV	2 - 1	SC Telstar	130
15 Dic 21	Finalizado	PSV	2 - 0	Fortuna Sittard	29

Fase Previa Champions League »

24 Ago 21	Finalizado	PSV	0 - 0	Benfica	390
18 Ago 21	Finalizado	Benfica	2 - 1	PSV	289
10 Ago 21	Finalizado	Midtjylland	0 - 1	PSV	237
03 Ago 21	Finalizado	PSV	3 - 0	Midtjylland	59
28 Jul 21	Finalizado	Galatasaray SK	1 - 2	PSV	200
21 Jul 21	Finalizado	PSV	5 - 1	Galatasaray SK	93

Partidos Amistosos »

14 Jul 21	Finalizado	PSV	1 - 0	PAOK	20
10 Jul 21	Finalizado	VfL Osnabrück	0 - 0	PSV	4
07 Jul 21	Finalizado	Delbrücker SC	1 - 10	PSV	3
03 Jul 21	Finalizado	PSV	6 - 2	RWD Molenbeek	1

Supercopa Países Bajos »

07 Ago 21

Finalizado

Ajax

0 - 4

PSV

Estadísticas

GOLEADORES

AMARILLAS

Plantilla del PSV Temporada 2021/2022

		Edad	Altura	Peso
Portero
16	Joël Drommel	27	192	80	-	-	-
21	Maxime Delanghe	22	189	83	-	-	-
13	V. Müller	23	190	79	-	-	-
38	Yvon Mvogo	29	190	88	-	-	-
Defensa
4	A. Obispo	25	185	78	1	-	4
5	André Ramalho	32	182	81	3	-	4
3	Jordan Teze	24	183	68	1	-	4
17	Mauro Júnior	24	171	58	2	-	2
18	O. Boscagli	26	181	68	4	-	2
29	P. Mwene	30	170	68	3	-	-
31	Philipp Max	30	177	74	1	-	4
Centrocampista
15	E. Gutiérrez	28	181	70	1	-	3
6	I. Sangaré	26	191	77	3	-	4
23	J. Veerman	25	185	75	7	-	1
8	M. Van Ginkel	31	186	67	1	-	3
27	Mario Götze	31	176	64	4	-	4
37	R. Ledezma	23	174	64	1	-	-
30	Ryan Thomas	29	174	70	1	-	-
Delantero
19	Bruma	29	173	70	7	-	1
11	Cody Gakpo	24	193	76	12	-	1
7	E. Zahavi	36	180	80	11	-	-
20	Maxi Romero	25	180	76	-	-	-
10	Noni Madueke	22	182	70	3	-	-
25	Ritsu Doan	25	172	70	8	-	-
9	Vinícius	29	190	80	6	-	5
32	Y. Vertessen	23	176	69	6	-	-

Noticias del PSV

Ver últimas noticias

Pröpper, nuevo jugador del PSV

BeSoccer - Martes, 14 Julio 2015

0 457

El futbolista aterriza en Eindhoven días después de la marcha de un futbolista importante en el equipo.

El Valencia se enfrentará al PSV Eindhoven el 25 de julio

BeSoccer - Sábado, 11 Julio 2015

0 306

El Valencia disputará un partido amistoso ante el PSV Eindhoven el próximo sábado 25 de julio, en el estadio Luis Suñer Picó de Alzira, según ha informado este sábado el club valenciano.

Bakkali ya es del Valencia

BeSoccer - Lunes, 06 Julio 2015

3 3.688

El atacante belga despuntó en la Liga Holandesa y ahora tendrá un desafío mayor en la capital del Turia

El PSV va en serio a por Gastón Pereiro

BeSoccer - Viernes, 26 Junio 2015

0 399

El Nacional uruguayo recibió una oferta "importante" del PSV holandés por el 80 % del pase del centrocampista de 20 años Gastón Pereiro, confirmaron hoy a Efe fuentes oficiales del club.

El Manchester United cierra el fichaje de Memphis Depay

BeSoccer - Lunes, 22 Junio 2015

0 467

El Manchester United confirmó este lunes el fichaje del atacante internacional holandés Memphis Depay, procedente del PSV Eindhoven, hasta junio de 2019.

Ver más noticias del equipo»

Competiciones que juega

Eredivisie

Pos	Equipos		Pts
1		Ajax	83
2		PSV	81
3		Feyenoord	71
4		Twente	68
5		AZ Alkmaar	61
6		Vitesse	51
7		Utrecht	47
8		Heerenveen	41
9		Cambuur	39
10		RKC Waalwijk	38
11		NEC Nijmegen	38
12		Groningen	36
13		Go Ahead Eagles	36
14		Sparta Rotterdam	35
15		Fortuna Sittard	35
16		Heracles	34
17		Willem II	33
18		PEC Zwolle	27

	Champions League : Ajax
	Previa de Champions : PSV
	Europa League : Feyenoord
	Conference League : Twente, AZ Alkmaar
	Siguiente Ronda : Vitesse, Utrecht, Heerenveen
	Playoff Descenso : Heracles
	Descenso : Willem II, PEC Zwolle

RIVALES EN Fase Previa Cham.

RIVALES EN Conference Leagu.

RIVALES EN Europa League

RIVALES EN Eredivisie

RIVALES EN KNVB Beker

RIVALES EN Supercopa Países.

Ajax
PSV

USO DE MEMORIA

7,191,912 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.3223
Total Execution Time	0.3241

CADENA URL

/Psv/2022

GET DATOS

$_GET['/Psv/2022']

POST DATOS

No hay datos POST existentes

CONSULTAS (54)

0.0103	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 = 'Psv' 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=2023 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=2023 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=2023 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=2023 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=2023 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=2023 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=2023 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=2023 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=2023 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=2023 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 62749
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 = 64003
0.0029	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 = 66139
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 = 62628
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.0027	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 = 63412
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 = 67928
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2023 AND type_rel = 2
0.0060	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2023 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025	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 (285,681,1691,2277,2545) ORDER BY n.cover_points DESC, update_date DESC
0.0143	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 = '2023' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0089	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 = '2023' 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 = 62629 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	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 = 66139 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 = 64003 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	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 = 62749 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030	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 = 63412 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 = 67928 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033	(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 calendars2022 as c ON c.league_id = l.id WHERE (c.datateam1 = 2023 or c.datateam2 = 2023) AND l.year = 2022 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0083	(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 calendars2022 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 = 2023 or c.datateam2 = 2023) AND l.year = 2022 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0035	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2022 as c ON c.league_id = l.id INNER JOIN events2022 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 = 2023 or c.datateam2 = 2023) AND l.year = 2022)
0.0102	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=2023 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0024	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 (71895,70409,68342,67752,67723,67320,66139,58772) 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.0055	SELECT count(id) as num_players from rel_players WHERE league_id = 67723 AND teamId = 2023
0.0047	SELECT count(id) as num_players from rel_players WHERE league_id = 70409 AND teamId = 2023
0.0061	SELECT count(id) as num_players from rel_players WHERE league_id = 66139 AND teamId = 2023
0.0063	SELECT count(id) as num_players from rel_players WHERE league_id = 68342 AND teamId = 2023
0.0047	SELECT count(id) as num_players from rel_players WHERE league_id = 67752 AND teamId = 2023
0.0052	SELECT count(id) as num_players from rel_players WHERE league_id = 58772 AND teamId = 2023
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 71895 AND teamId = 2023
0.0322	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 2023
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 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 = 62749 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0077	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 = 62749 WHERE rp.league_id = 62749 AND rp.teamId = 2023 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.0062	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 = 62749 WHERE rp.league_id = 62749 AND rp.teamId = 2023 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0060	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 = 62749 WHERE rp.league_id = 62749 AND rp.teamId = 2023 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0047	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 = 2023 AND rp.league_id = 62749 AND l.year= 2022 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0031	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=6442643 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0021	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6442643
0.0046	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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6442643 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.0050	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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6442643 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0032	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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6442643 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0045	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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6442643 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0043	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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6442643 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

PSV

Información sobre PSV

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del PSV