23 Feb 20	Finalizado	Legia Warszawa	1 - 1	SKRA Częstochowa	0
26 Ene 20	Finalizado	Legia Warszawa	2 - 0	Kairat Almaty	0
22 Ene 20	Finalizado	Legia Warszawa	1 - 0	FK Vozdovac	1
22 Ene 20	Finalizado	Legia Warszawa	3 - 1	Nyíregyháza Spartacus	0
16 Ene 20	Finalizado	Botosani	1 - 2	Legia Warszawa	5
14 Jul 19	Finalizado	Radomiak Radom	0 - 5	Legia Warszawa	11
02 Jul 19	Finalizado	Universitatea Craiova	3 - 3	Legia Warszawa	18

Fase Previa Europa League »

29 Ago 19	Finalizado	Rangers FC	1 - 0	Legia Warszawa	127
22 Ago 19	Finalizado	Legia Warszawa	0 - 0	Rangers FC	56
14 Ago 19	Finalizado	Atromitos	0 - 2	Legia Warszawa	75
08 Ago 19	Finalizado	Legia Warszawa	0 - 0	Atromitos	44
01 Ago 19	Finalizado	KuPS Kuopio	0 - 0	Legia Warszawa	33
25 Jul 19	Finalizado	Legia Warszawa	1 - 0	KuPS Kuopio	6
18 Jul 19	Finalizado	Legia Warszawa	3 - 0	Europa FC	13
11 Jul 19	Finalizado	Europa FC	0 - 0	Legia Warszawa	30

Liga Polaca »

19 Jul 20	Finalizado	Legia Warszawa	1 - 2	Pogon Szczecin	18
15 Jul 20	Finalizado	Lechia Gdansk	0 - 0	Legia Warszawa	1
11 Jul 20	Finalizado	Legia Warszawa	2 - 0	KS Cracovia	11
04 Jul 20	Finalizado	Lech Poznań	2 - 1	Legia Warszawa	0
27 Jun 20	Finalizado	Legia Warszawa	1 - 1	Piast Gliwice	6
24 Jun 20	Finalizado	Jagiellonia Bialystok	0 - 0	Legia Warszawa	2
21 Jun 20	Finalizado	Legia Warszawa	2 - 0	Śląsk Wrocław	0
14 Jun 20	Finalizado	Górnik Zabrze	2 - 0	Legia Warszawa	5
10 Jun 20	Finalizado	Legia Warszawa	5 - 1	Arka Gdynia	15
07 Jun 20	Finalizado	Wisla Kraków	1 - 3	Legia Warszawa	10
30 May 20	Finalizado	Lech Poznań	0 - 1	Legia Warszawa	15
08 Mar 20	Finalizado	Legia Warszawa	1 - 2	Piast Gliwice	4
04 Mar 20	Finalizado	Lechia Gdansk	0 - 2	Legia Warszawa	5
29 Feb 20	Finalizado	Legia Warszawa	2 - 1	KS Cracovia	0
22 Feb 20	Finalizado	Legia Warszawa	4 - 0	Jagiellonia Bialystok	0
15 Feb 20	Finalizado	Raków Częstochowa	2 - 2	Legia Warszawa	0
09 Feb 20	Finalizado	Legia Warszawa	3 - 1	LKS Lódz	2
20 Dic 19	Finalizado	Zaglebie Lubin	2 - 1	Legia Warszawa	13
14 Dic 19	Finalizado	Legia Warszawa	3 - 1	Wisła Płock	0
08 Dic 19	Finalizado	Śląsk Wrocław	0 - 3	Legia Warszawa	1
30 Nov 19	Finalizado	Legia Warszawa	4 - 0	Korona Kielce	1
23 Nov 19	Finalizado	Pogon Szczecin	3 - 1	Legia Warszawa	1
09 Nov 19	Finalizado	Legia Warszawa	5 - 1	Górnik Zabrze	0
03 Nov 19	Finalizado	Arka Gdynia	0 - 1	Legia Warszawa	4
27 Oct 19	Finalizado	Legia Warszawa	7 - 0	Wisla Kraków	1
19 Oct 19	Finalizado	Legia Warszawa	2 - 1	Lech Poznań	3
06 Oct 19	Finalizado	Piast Gliwice	2 - 0	Legia Warszawa	0
28 Sep 19	Finalizado	Legia Warszawa	1 - 2	Lechia Gdansk	0
22 Sep 19	Finalizado	KS Cracovia	1 - 2	Legia Warszawa	0
18 Sep 19	Finalizado	Wisła Płock	1 - 0	Legia Warszawa	6
13 Sep 19	Finalizado	Jagiellonia Bialystok	0 - 0	Legia Warszawa	3
01 Sep 19	Finalizado	Legia Warszawa	3 - 1	Raków Częstochowa	1
25 Ago 19	Finalizado	LKS Lódz	2 - 3	Legia Warszawa	0
18 Ago 19	Finalizado	Legia Warszawa	1 - 0	Zaglebie Lubin	3
04 Ago 19	Finalizado	Legia Warszawa	0 - 0	Śląsk Wrocław	3
28 Jul 19	Finalizado	Korona Kielce	1 - 2	Legia Warszawa	0
21 Jul 19	Finalizado	Legia Warszawa	1 - 2	Pogon Szczecin	12

Copa Polonia »

07 Jul 20	Finalizado	KS Cracovia	3 - 0	Legia Warszawa	11
26 May 20	Finalizado	Miedz Legnica	1 - 2	Legia Warszawa	4
03 Dic 19	Finalizado	Górnik Łęczna	0 - 2	Legia Warszawa	1
30 Oct 19	Finalizado	Widzew Łódź	2 - 3	Legia Warszawa	1
25 Sep 19	Finalizado	Puszcza Niepolomice	0 - 2	Legia Warszawa	0

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Legia Warszawa Temporada 2019/2020

		Edad	Altura	Peso
Portero
33	R. Cierzniak	40	187	81	-	-	-
1	R. Majecki	24	193	78	-	-	1
19	W. Muzyk	25	191	83	-	-	-
Defensa
55	A. Jędrzejczyk	36	189	86	-	-	11
34	I. Astiz	40	185	74	-	-	1
5	I. Lewczuk	38	187	83	-	-	5
37	I. Obradović	35	181	74	-	-	-
16	Luís Rocha	30	177	71	-	1	4
29	M. Vesovic	32	180	70	2	-	2
4	M. Wieteska	27	187	82	1	-	2
14	Michal Karbownik	23	175	71	-	-	3
41	P. Stolarski	28	181	72	-	-	-
22	P. Wszołek	31	186	77	6	-	4
44	W. Rémy	33	184	78	-	-	-
Centrocampista
24	A. Martins	34	166	62	-	-	4
99	B. Slisz	25	179	76	2	-	-
7	D. Antolić	33	180	71	3	-	1
82	Luquinhas	27	169	63	5	-	2
77	M. Praszelik	23	184	74	-	-	-
31	P. Pyrdol	24	178	72	1	-	1
8	V. Gvilia	29	180	69	5	-	2
Delantero
18	A. Novikovas	33	176	75	4	-	-
20	José Kanté	33	184	76	10	1	6
17	M. Cholewiak	34	184	78	4	-	1
39	Maciej Rosolek	22	183	77	2	-	-
9	T. Pekhart	34	194	89	4	-	1
27	V. Sanogo	29	186	85	1	-	-

Noticias del Legia Warszawa

Ver últimas noticias

El infierno está inspirado en el estadio del Legia

BeSoccer - Miércoles, 28 Octubre 2015

1 795

La afición del Legia hizo que el partido entre el equipo local y el Lech Poznan fuera un auténtico infierno. Los hinchas del Legia sacaron sus bengalas para lograr este ambiente tan... diabólico.

La cara más insolidaria del fútbol: pancartas y cánticos contra los refugiados

BeSoccer - Domingo, 13 Septiembre 2015

9 4.369

No todo el mundo se ha mostrado tan solidario con la catástrofe humanitaria que ha llegado a las puertas de Europa. Una parte de los hinchas de dos equipos en concreto se han mostrado bastante disconformes con la llegada de los refugiados sirios.

Así queda el grupo D de Europa League

Cristina Serrano de la Cruz - Viernes, 28 Agosto 2015

0 624

En el Grupo C se enfrentarán por la Europa League los siguientes equipos: Nápoles, Club Brugge, Legia y Midtjylland.

La UEFA sanciona al Kukësi por la batalla ante el Legia

BeSoccer - Martes, 04 Agosto 2015

1 696

La UEFA ha sancionado hoy al FC Kukesi albanés con la pérdida por 0-3 del partido de ida de la tercera ronda de clasificación de la Liga Europa a causa de los incidentes que se produjeron durante el encuentro y que obligaron a su suspensión en el minuto 52.

Suspendido el Kukesi-Legia por lanzamiento de piedras desde la grada

BeSoccer - Jueves, 30 Julio 2015

2 532

El partido de tercera ronda de la Europa League que enfrentaba al Kukesi albano y al Legia de Varsovia polaco, ha sido suspendido en el minuto 51 por el lanzamiento de varias piedras desde la grada de los ultras del equipo local, que han impactado en los jugadores visitantes.

Ver más noticias del equipo»

Competiciones que juega

Liga Polaca Grupo 1

Pos	Equipos		Pts
1		Legia Warszawa	60
2		Piast Gliwice	53
3		Śląsk Wrocław	49
4		Lech Poznań	49
5		KS Cracovia	46
6		Pogon Szczecin	45
7		Jagiellonia Bialystok	44
8		Lechia Gdansk	43
9		Górnik Zabrze	41
10		Raków Częstochowa	41
11		Zaglebie Lubin	38
12		Wisła Płock	38
13		Wisla Kraków	35
14		Korona Kielce	30
15		Arka Gdynia	29
16		LKS Lódz	21

	Playoff Título : Legia Warszawa, Piast Gliwice, Śląsk Wrocław, Lech Poznań, KS Cracovia, Pogon Szczecin, Jagiellonia Bialystok, Lechia Gdansk
	Playoff Descenso : Górnik Zabrze, Raków Częstochowa, Zaglebie Lubin, Wisła Płock, Wisla Kraków, Korona Kielce, Arka Gdynia, LKS Lódz

RIVALES EN Copa Polonia

RIVALES EN Fase Previa Euro.

RIVALES EN Liga Polaca

USO DE MEMORIA

6,734,288 bytes

BENCHMARKS

Loading Time Base Classes	0.0033
Controller Execution Time ( Home / Category )	0.7652
Total Execution Time	0.7685

CADENA URL

/Kp-Legia-Warszawa/2020

GET DATOS

$_GET['/Kp-Legia-Warszawa/2020']

POST DATOS

No hay datos POST existentes

CONSULTAS (48)

0.0133	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 = 'Kp-Legia-Warszawa' AND l.year = 2020 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.0109	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=1465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107	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=1465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=1465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107	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=1465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107	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=1465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0108	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=1465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112	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=1465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0113	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=1465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0113	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=1465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133	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 = 49920
0.0134	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 = 56791
0.0134	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 = 50131
0.0133	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.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 = 50670
0.0134	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 = 51054
0.0132	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 = 49506
0.0109	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1465 AND type_rel = 2
0.0130	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1465 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0122	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 (4368,4799,8908,11589,19665) ORDER BY n.cover_points DESC, update_date DESC
0.0147	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 = '1465' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0123	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 = '1465' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0112	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 = 50131 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111	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 = 49920 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0114	(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 = 1465 or c.datateam2 = 1465) AND l.year = 2020 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0133	(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 = 1465 or c.datateam2 = 1465) AND l.year = 2020 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0150	(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 = 1465 or c.datateam2 = 1465) AND l.year = 2020)
0.0186	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=1465 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0116	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 (58772,58148,57380,57378,57103,56547) 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.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 57378 AND teamId = 1465
0.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 58148 AND teamId = 1465
0.0172	SELECT count(id) as num_players from rel_players WHERE league_id = 58772 AND teamId = 1465
0.0164	SELECT count(id) as num_players from rel_players WHERE league_id = 57380 AND teamId = 1465
0.0114	SELECT count(id) as num_players from rel_players WHERE league_id = 57103 AND teamId = 1465
0.0393	SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 1465
0.0110	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 = 49920 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0124	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 = 49920 WHERE rp.league_id = 49920 AND rp.teamId = 1465 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.0121	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 = 49920 WHERE rp.league_id = 49920 AND rp.teamId = 1465 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0117	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 = 49920 WHERE rp.league_id = 49920 AND rp.teamId = 1465 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0114	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 = 1465 AND rp.league_id = 49920 AND l.year= 2020 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0111	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=6281255 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0106	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6281255
0.0114	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=6281255 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.0117	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=6281255 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0115	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=6281255 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0116	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=6281255 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0119	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=6281255 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0109	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 = 49920 ORDER BY nameShow LIMIT 100

Resultados de Fútbol

Legia Warszawa

Información sobre Legia Warszawa

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Liga Polaca

Fase Previa Europa League Grupo 2

Fase Previa Champions League Grupo 3

Copa Polonia

Europa League Grupo 3

Supercopa Polonia

Partidos Amistosos

Recopa de Europa

Champions League Grupo 6

Fase Previa Conference League Grupo 2

Conference League Grupo 0

Trofeo Ciutat de Palma

Copa de Ferias

Copa Intertoto

Partidos del Legia Warszawa