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

PSG

Entrenador: Luis Enrique

Temporada 2018/2019

Información sobre PSG

Enviar Datos

Información

Nombre del equipo PSG
Nombre completo París Saint-Germain Football Club
Nombre corto PSG
País Francia
Ciudad Paris
Entrenador Luis Enrique
URL del equipo en RF //m.resultados-futbol.com/Paris-Saint-Germain-Fc

Otros Datos

Año de Fundación 1970
Patrocinador Accor Live Limitless
Marca de Ropa Nike, Air Jordan

Internet

Sitio Web www.psg.fr/
Correo electrónico psg@psg.tm.fr
Twitter principal @PSG_inside

Información sobre el estadio

Nombre del estadio Parc des Princes
Capacidad 49691
Dirección 24, rue du Commandant Guilbaud 75016 Paris
Teléfono +33 (1) 474 37171
Fax +33 (1) 423 05027
Año de construcción 1897
Tamaño 105 x 68 metros

Histórico de participación

Ligue 1

51 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1975, 1972)

Champions League Grupo 0

31 veces

(2024, 2024, 2023, 2023, 2022, 2022, 2021, 2021, 2020, 2020, 2019, 2019, 2018, 2018, 2017, 2017, 2016, 2016, 2015, 2015, 2014, 2014, 2013, 2013, 2005, 2001, 2001, 1998, 1995, 1995, 1987)

Copa de la Liga

25 veces

(2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996)

Supercopa Francia

19 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2011, 2007, 2005, 2004, 1999, 1998, 1996, 1986)

Partidos Amistosos

15 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 1981)

Europa League Grupo 6

12 veces

(2012, 2011, 2011, 2009, 2009, 2007, 2007, 2003, 2002, 1993, 1990, 1985)

Recopa de Europa

6 veces

(1999, 1997, 1996, 1994, 1984, 1983)

Fase Previa Europa League Grupo 4

2 veces

(2012, 2011)

Partidos del PSG

Ir al LIVESCORE

Champions League »

06 Mar 19	Finalizado	PSG	1 - 3	Manchester United	1376
12 Feb 19	Finalizado	Manchester United	0 - 2	PSG	1391
11 Dic 18	Finalizado	Crvena Zvezda	1 - 4	PSG	194
28 Nov 18	Finalizado	PSG	2 - 1	Liverpool	589
06 Nov 18	Finalizado	Napoli	1 - 1	PSG	385
24 Oct 18	Finalizado	PSG	2 - 2	Napoli	565
03 Oct 18	Finalizado	PSG	6 - 1	Crvena Zvezda	596
18 Sep 18	Finalizado	Liverpool	3 - 2	PSG	1392

Ligue 1 »

24 May 19	Finalizado	Stade de Reims	3 - 1	PSG	228
18 May 19	Finalizado	PSG	4 - 0	Dijon FCO	60
11 May 19	Finalizado	Angers SCO	1 - 2	PSG	43
04 May 19	Finalizado	PSG	1 - 1	Nice	116
30 Abr 19	Finalizado	Montpellier	3 - 2	PSG	335
21 Abr 19	Finalizado	PSG	3 - 1	Monaco	206
17 Abr 19	Finalizado	Nantes	3 - 2	PSG	303
14 Abr 19	Finalizado	Lille	5 - 1	PSG	256
07 Abr 19	Finalizado	PSG	2 - 2	Strasbourg	136
31 Mar 19	Finalizado	Toulouse	0 - 1	PSG	116
17 Mar 19	Finalizado	PSG	3 - 1	Olympique Marseille	132
12 Mar 19	Finalizado	Dijon FCO	0 - 4	PSG	195
02 Mar 19	Finalizado	Caen	1 - 2	PSG	174
23 Feb 19	Finalizado	PSG	3 - 0	Nîmes	98
20 Feb 19	Finalizado	PSG	5 - 1	Montpellier	70
17 Feb 19	Finalizado	Saint-Étienne	0 - 1	PSG	166
09 Feb 19	Finalizado	PSG	1 - 0	Girondins Bordeaux	74
03 Feb 19	Finalizado	Olympique Lyonnais	2 - 1	PSG	194
27 Ene 19	Finalizado	PSG	4 - 1	Stade Rennais	151
19 Ene 19	Finalizado	PSG	9 - 0	Guingamp	226
12 Ene 19	Finalizado	Amiens SC	0 - 3	PSG	90
22 Dic 18	Finalizado	PSG	1 - 0	Nantes	63
05 Dic 18	Finalizado	Strasbourg	1 - 1	PSG	178
02 Dic 18	Finalizado	Girondins Bordeaux	2 - 2	PSG	127
24 Nov 18	Finalizado	PSG	1 - 0	Toulouse	59
11 Nov 18	Finalizado	Monaco	0 - 4	PSG	202
02 Nov 18	Finalizado	PSG	2 - 1	Lille	314
28 Oct 18	Finalizado	Olympique Marseille	0 - 2	PSG	330
20 Oct 18	Finalizado	PSG	5 - 0	Amiens SC	97
07 Oct 18	Finalizado	PSG	5 - 0	Olympique Lyonnais	261
29 Sep 18	Finalizado	Nice	0 - 3	PSG	188
26 Sep 18	Finalizado	PSG	4 - 1	Stade de Reims	88
23 Sep 18	Finalizado	Stade Rennais	1 - 3	PSG	253
14 Sep 18	Finalizado	PSG	4 - 0	Saint-Étienne	258
01 Sep 18	Finalizado	Nîmes	2 - 4	PSG	275
25 Ago 18	Finalizado	PSG	3 - 1	Angers SCO	208
18 Ago 18	Finalizado	Guingamp	1 - 3	PSG	746
12 Ago 18	Finalizado	PSG	3 - 0	Caen	159

Copa de Francia »

27 Abr 19	Finalizado	Stade Rennais	2 - 2	PSG	302
03 Abr 19	Finalizado	PSG	3 - 0	Nantes	54
26 Feb 19	Finalizado	PSG	3 - 0	Dijon FCO	114
06 Feb 19	Finalizado	Villefranche	0 - 3	PSG	377
23 Ene 19	Finalizado	PSG	2 - 0	Strasbourg	100
06 Ene 19	Finalizado	Pontivy	0 - 4	PSG	73

Copa de la Liga »

	09 Ene 19	Finalizado	PSG	1 - 2	Guingamp			395
	18 Dic 18	Finalizado	Orléans	1 - 2	PSG			54

International Champions Cup »

30 Jul 18	Finalizado	PSG	3 - 2	Atlético	601
28 Jul 18	Finalizado	Arsenal	5 - 1	PSG	295
21 Jul 18	Finalizado	Bayern München	3 - 1	PSG	420

Partidos Amistosos »

	15 Jul 18	Finalizado	PSG	2 - 4	Chambly			52
	11 Jul 18	Finalizado	PSG	1 - 0	St Geneviève			17

Supercopa Francia »

04 Ago 18

Finalizado

PSG

4 - 0

Monaco

375

Estadísticas

GOLEADORES

Neymar15

AMARILLAS

ROJAS

Plantilla del PSG Temporada 2018/2019

		Edad	Altura	Peso
Portero
16	A. Aréola	31	195	92	-	-	1
1	G. Buffon	46	192	83	-	-	-
50	S. Cibois	26	192	61	-	-	-
Defensa
	A. Georgen	25	172	69	-	-	-
33	A. Zagré	22	168	55	-	-	-
31	Colin Dagba	25	170	62	-	-	2
35	I. Hemans Arday	27	175	70	-	-	-
14	Juan Bernat	31	170	67	1	1	6
20	L. Kurzawa	31	182	73	1	-	4
33	Loïc Mbe Soh	22	187	85	-	-	-
5	Marquinhos	29	183	79	3	1	2
3	P. Kimpembe	28	183	77	-	1	4
34	S. Nsoki	25	184	77	-	-	2
2	Thiago Silva	39	181	79	-	-	4
4	Thilo Kehrer	27	186	70	1	-	4
12	Thomas Meunier	32	191	90	3	-	2
Centrocampista
33	A. Toufiqui	25	175	69	-	-	-
25	Adrien Rabiot	29	188	71	2	-	3
24	C. Nkunku	26	177	68	3	-	-
36	Dina Ebimbe	23	184	72	-	-	-
8	L. Paredes	29	180	79	-	-	1
6	Marco Verratti	31	165	60	-	-	7
Delantero
11	Á. Di María	36	178	75	12	-	2
9	E. Cavani	37	184	71	18	-	1
23	J. Draxler	30	185	72	3	-	6
7	K. Mbappé	25	178	75	33	1	5
17	M. Choupo-Moting	35	191	84	3	-	-
27	M. Diaby	24	171	67	2	-	1
33	Metehan Guclu	25	182	70	1	-	-
10	Neymar	32	175	64	15	-	2

Noticias del PSG

Ver últimas noticias

"Mbappé es el que más habla en el vestuario"

BeSoccer - Martes, 30 Abril 2024

0 8.503

Gonçalo Ramos, jugador del PSG, compareció en rueda de prensa de cara a la ida de las semifinales de la Champions League en el Signal Iduna Park. El portugués ensalzó el liderazgo de Kylian Mbappé, de quien dijo que es quien más habla en el vestuario a la hora de motivar al resto. Otras voces referentes son las de Marquinhos o Danilo Pereira, al menos atendiendo al punto de vista del extremo.

"Si hay nivel, no me importa que los jugadores tengan 55 o 26 años"

BeSoccer - Martes, 30 Abril 2024

4 1.691

Luis Enrique, entrenador del Paris Saint-Germain, compareció en rueda de prensa de cara al partido de ida de semifinales de la Champions League contra el Borussia Dortmund en el Signal Iduna Park. A propósito de la juventud de su plantilla esta temporada en contraste con el vestuario que gestionó Christophe Galtier, subrayó lo poco que le importa la experiencia de un futbolista siempre y cuando su nivel sea el adecuado.

El PSG ya se plantea renovar a Luis Enrique

BeSoccer - Martes, 30 Abril 2024

1 1.572

Luis Enrique llegó el pasado verano al PSG y aún le queda un año más de contrato, pero en París están encantados con su labor al frente del equipo y ya se plantean su renovación, según apunta 'L'Équipe'. El conjunto parisino se encuentra a 4 partidos de lograr un triplete histórico en la temporada de estreno del español. Además, Al-Khelaïfi quiere hacer un proyecto a largo plazo, ya que no suelen durarle demasiado los entrenadores.

Anthony Taylor arbitrará el Borussia Dortmund-PSG

BeSoccer - Lunes, 29 Abril 2024

0 2.453

Anthony Taylor será el encargado de dirigir el encuentro entre el Borussia Dortmund y el PSG, partido de ida de las semifinales de la Champions League 2023-24.

Palmarés de la Ligue 1: el histórico de campeones de la Liga Francesa

BeSoccer Pro - Lunes, 29 Abril 2024

0 1.842

La Ligue 1 ha sido dominada durante la década anterior y lo que va de la actual por el Paris Saint-Germain, que esgrime unas finanzas que han sido valedoras de la presencia de algunos de los mayores ganadores del presente e incluso de la historia gala. Leo Messi, Kylian Mbappé... Son muchos los protagonistas que han sellado un gobierno impregnado en el palmarés de la categoría, donde tan solo el Saint-Étienne, a nivel histórico, discute a los del Parque de los Príncipes. BeSoccer Pro recoge a todos sus campeones.

Ver más noticias del equipo»

Competiciones que juega

Grupo 6

Ligue 1

Pos	Equipos		Pts
1		PSG	91
2		Lille	75
3		Olympique Lyonnais	72
4		Saint-Étienne	66
5		Olympique Marseille	61
6		Montpellier	59
7		Nice	56
8		Stade de Reims	55
9		Nîmes	53
10		Stade Rennais	52
11		Strasbourg	49
12		Nantes	48
13		Angers SCO	46
14		Girondins Bordeaux	41
15		Amiens SC	38
16		Toulouse	38
17		Monaco	36
18		Dijon FCO	34
19		Caen	33
20		Guingamp	27

	Champions League : PSG, Lille, Olympique Lyonnais
	Europa League : Saint-Étienne
	Playoff Descenso : Dijon FCO
	Descenso : Caen, Guingamp

RIVALES EN Champions League

RIVALES EN Copa de Francia

RIVALES EN Copa de la Liga

RIVALES EN Ligue 1

RIVALES EN Supercopa Franci.

PSG
Monaco

USO DE MEMORIA

7,036,424 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.1951
Total Execution Time	0.1970

CADENA URL

/Paris-Saint-Germain-Fc/2019

GET DATOS

$_GET['/Paris-Saint-Germain-Fc/2019']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0018	SELECT type FROM routes WHERE alias = 'paris-saint-germain-fc'
0.0042	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 = 44984
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 = 48457
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 = 44442
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 = 43532
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 = 43268
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1924 AND type_rel = 2
0.0037	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1924 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 (1313323,1313318,1313256,1313118,1263611) ORDER BY n.cover_points DESC, update_date DESC
0.0039	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 = '1924' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 48457 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	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 = 47499 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 = 44442 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 = 43549 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 = 43532 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	(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 calendars2019 as c ON c.league_id = l.id WHERE (c.datateam1 = 1924 or c.datateam2 = 1924) AND l.year = 2019 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0039	(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 calendars2019 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 = 1924 or c.datateam2 = 1924) AND l.year = 2019 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0027	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2019 as c ON c.league_id = l.id INNER JOIN events2019 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 = 1924 or c.datateam2 = 1924) AND l.year = 2019)
0.0056	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=1924 AND l.year in (2018,2019,2020) 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 (53485,51675,50213,49849,49779,49506,43268) 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.0030	SELECT count(id) as num_players from rel_players WHERE league_id = 49849 AND teamId = 1924
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 53485 AND teamId = 1924
0.0035	SELECT count(id) as num_players from rel_players WHERE league_id = 51675 AND teamId = 1924
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 50213 AND teamId = 1924
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 49779 AND teamId = 1924
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 43268 AND teamId = 1924
0.0098	SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 1924
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* `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 = 43549 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0039	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 events2019 e ON e.player_id = p.id AND e.league_id = 43549 WHERE rp.league_id = 43549 AND rp.teamId = 1924 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.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 events2019 e ON e.player_id = p.id AND e.league_id = 43549 WHERE rp.league_id = 43549 AND rp.teamId = 1924 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	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 events2019 e ON e.player_id = p.id AND e.league_id = 43549 WHERE rp.league_id = 43549 AND rp.teamId = 1924 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 1924 AND rp.league_id = 43549 AND l.year= 2019 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0023	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=6185450 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=6185450
0.0029	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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185450 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.0028	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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185450 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0023	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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185450 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0024	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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185450 AND (e.action = 22) 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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185450 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

PSG

Información sobre PSG

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del PSG

Estadísticas

Plantilla del PSG Temporada 2018/2019

Noticias del PSG

PSG

Selecciona un equipo

Competiciones que juega

RIVALES EN Champions League

RIVALES EN Copa de Francia

RIVALES EN Copa de la Liga

RIVALES EN Ligue 1

RIVALES EN Supercopa Franci.