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

Resultados de Fútbol

Legia Warszawa

Entrenador: Goncalo Feio

Temporada 2017/2018

TEMPORADA 2017/2018

LIGA POLACA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Legia	7	12	4	70
2	Jagiellonia	7	10	5	67
3	Górnik	7	12	8	60
4	Lech Poznań	7	4	11	60
5	Wisła	7	11	10	57
6	Wisla	7	10	6	55
7	Zaglebie	7	6	9	52
8	Korona	7	5	17	49

TEMPORADA 2016/2017

LIGA POLACA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Legia	7	12	1	44
2	Lechia	7	11	0	42
3	Lech Poznań	7	12	7	42
4	Jagiellonia	7	8	8	42
5	Korona	7	8	10	28
6	Wisla	7	9	11	26
7	Pogon	7	4	14	25
8	Termalica	7	4	17	25

TEMPORADA 2015/2016

LIGA POLACA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Legia	7	12	4	43
2	Piast	7	11	9	40
3	Zaglebie	7	14	5	38
4	KS Cracovia	7	9	8	36
5	Lechia	7	8	7	33
6	Pogon	7	7	13	30
7	Lech Poznań	7	5	9	27
8	Ruch	7	3	14	21

TEMPORADA 2014/2015

LIGA POLACA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lech Poznań	7	15	6	43
2	Legia	7	7	3	42
3	Jagiellonia	7	16	9	41
4	Śląsk	7	7	7	35
5	Lechia	7	9	10	29
6	Wisla	7	9	9	28
7	Górnik	7	7	17	26
8	Pogon	7	5	14	22

TEMPORADA 2013/2014

LIGA POLACA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Legia	7	15	4	50
2	Lech Poznań	7	12	6	40
3	Ruch	7	7	10	34
4	Lechia	7	8	4	32
5	Górnik	7	11	11	31
6	Wisla	7	13	16	31
7	Pogon	7	3	12	27
8	Zawisza	7	5	11	25

TEMPORADA 2012/2013

LIGA POLACA
Equipo		PJ	GF	GC	Puntos
1	Legia	30	59	22	67
2	Lech Poznań	30	46	22	61
3	Śląsk	30	44	42	47
4	Piast	30	41	41	46
5	Górnik	30	35	31	43
6	Polonia	30	45	34	42
7	Lechia	30	42	43	38
8	Wisla	30	28	35	38
9	Zaglebie	30	38	37	37
10	Jagiellonia	30	31	45	37
11	Korona	30	32	37	36
12	Pogon	30	29	39	35
13	Widzew	30	30	41	33
14	Podbeskidzie	30	39	43	32
15	Ruch	30	35	48	31
16	Bełchatów	30	24	38	31

TEMPORADA 2011/2012

LIGA POLACA
Equipo		PJ	GF	GC	Puntos
1	Śląsk	30	47	31	56
2	Ruch	30	44	28	55
3	Legia	30	42	17	53
4	Lech Poznań	30	42	22	52
5	Korona	30	34	29	48
6	Polonia W.	30	33	32	45
7	Wisla	30	29	26	43
8	Górnik	30	36	30	42
9	Zaglebie	30	36	42	40
10	Widzew	30	25	26	39
11	Jagiellonia	30	35	45	39
12	Podbeskidzie	30	26	39	35
13	Bełchatów	30	34	36	31
14	Lechia	30	21	30	31
15	LKS Lódz	30	23	53	24
16	KS Cracovia	30	20	41	22

TEMPORADA 2010/2011

LIGA POLACA
Equipo		PJ	GF	GC	Puntos
1	Wisla	30	44	29	56
2	Śląsk	30	46	34	49
3	Legia	30	45	38	49
4	Jagiellonia	30	38	32	48
5	Lech Poznań	30	37	23	45
6	Górnik	30	36	40	45
7	Polonia W.	30	41	26	44
8	Widzew	30	41	34	43
9	Lechia	30	37	36	43
10	Bełchatów	30	31	33	40
11	Zaglebie	30	31	38	39
12	Ruch	30	29	32	38
13	Korona	30	34	48	37
14	KS Cracovia	30	37	47	29
15	Arka Gdynia	30	22	43	28
16	Polonia	30	29	45	27

TEMPORADA 2009/2010

LIGA POLACA
Equipo		PJ	GF	GC	Puntos
1	Lech Poznań	30	51	20	65
2	Wisla	30	48	20	62
3	Ruch	30	40	30	53
4	Legia	30	36	22	52
5	Bełchatów	30	37	27	48
6	Lechia	30	30	32	37
7	Polonia	30	29	31	37
8	Korona	30	35	41	37
9	Śląsk	30	32	33	36
10	Zaglebie	30	30	38	35
11	Jagiellonia	30	29	27	34
12	KS Cracovia	30	25	39	34
13	Polonia W.	30	25	38	33
14	Arka Gdynia	30	28	39	28
15	Odra	30	27	45	27
16	Piast	30	30	50	27

TEMPORADA 2008/2009

LIGA POLACA
Equipo		PJ	GF	GC	Puntos
1	Wisla	30	53	21	64
2	Legia	30	52	17	61
3	Lech Poznań	30	51	24	59
4	Polonia	30	40	23	54
5	Bełchatów	30	40	28	54
6	Śląsk	30	40	34	45
7	Polonia	30	30	46	35
8	LKS Lódz	30	27	43	35
9	Jagiellonia	30	28	34	34
10	Ruch	30	22	32	34
11	Piast	30	17	26	33
12	Lechia	30	30	44	32
13	Odra	30	23	40	32
14	Arka Gdynia	30	27	39	30
15	KS Cracovia	30	24	40	30
16	Górnik	30	20	33	29

TEMPORADA 2007/2008

LIGA POLACA
Equipo		PJ	GF	GC	Puntos
1	Wisla	30	68	18	77
2	Legia	30	48	17	63
3	Dyskobolia	30	52	24	60
4	Lech Poznań	30	55	32	57
5	Zaglebie	30	43	30	52
6	Korona	30	38	32	51
7	KS Cracovia	30	30	32	39
8	Górnik	30	34	39	39
9	Bełchatów	30	26	32	38
10	Ruch	30	35	41	34
11	LKS Lódz	30	25	31	30
12	Odra	30	28	47	29
13	Polonia	30	22	45	28
14	Jagiellonia	30	27	57	27
15	Widzew	30	27	42	26
16	Zagłębie	30	19	58	16

TEMPORADA 2006/2007

LIGA POLACA
Equipo		PJ	GF	GC	Puntos
1	Zaglebie	30	57	29	62
2	Bełchatów	30	63	32	61
3	Legia	30	53	33	52
4	KS Cracovia	30	48	41	49
5	Dyskobolia	30	40	26	48
6	Lech Poznań	30	53	36	47
7	Korona	30	41	34	47
8	Wisla	30	41	25	46
9	LKS Lódz	30	31	30	41
10	Arka Gdynia	30	43	39	40
11	Odra	30	29	36	40
12	Widzew	30	27	48	28
13	Górnik	30	24	64	26
14	Górnik	30	30	51	25
15	Wisła	30	20	47	23
16	Pogon	30	24	53	16

TEMPORADA 2005/2006

LIGA POLACA
Equipo		PJ	GF	GC	Puntos
1	Legia	30	47	17	66
2	Wisla	30	50	20	64
3	Amica Wronki	30	50	28	49
4	Zaglebie	30	45	32	49
5	Korona	30	46	33	47
6	Lech Poznań	30	45	45	42
7	Odra	30	23	27	40
8	Bełchatów	30	30	32	37
9	Pogon	30	29	34	37
10	Dyskobolia	30	37	45	37
11	KS Cracovia	30	32	44	37
12	Wisła	30	30	45	34
13	Górnik	30	23	31	33
14	Górnik	30	29	46	29
15	Arka Gdynia	30	21	33	27
16	Polonia	30	20	45	25

TEMPORADA 2004/2005

LIGA POLACA
Equipo		PJ	GF	GC	Puntos
1	Wisla	26	70	23	62
2	Dyskobolia	26	46	28	51
3	Legia	26	42	19	47
4	Wisła	26	35	30	41
5	KS Cracovia	26	37	29	40
6	Amica Wronki	26	29	28	38
7	Górnik	26	36	36	36
8	Lech Poznań	26	34	40	34
9	Pogon	26	34	43	31
10	Polonia	26	27	52	29
11	Górnik	26	27	30	28
12	Zaglebie	26	31	41	28
13	Odra	26	27	41	24
14	Katowice	26	23	58	16

TEMPORADA 2003/2004

LIGA POLACA
Equipo		PJ	GF	GC	Puntos
1	Wisla	26	73	30	65
2	Legia	26	56	19	60
3	Amica Wronki	26	47	25	48
4	Dyskobolia	26	59	31	46
5	Wisła	26	41	39	38
6	Lech Poznań	26	43	34	37
7	Górnik	26	26	33	33
8	Górnik	26	22	38	33
9	Odra	26	27	40	28
10	Katowice	26	20	42	26
11	Polonia	26	25	40	25
12	Gornik	26	17	37	23
13	Swit Nowy D.	26	21	42	22
14	Widzew	26	25	52	19

Competiciones que juega

Liga Polaca Grupo 1

Pos	Equipos		Pts
1		Lech Poznań	55
2		Legia Warszawa	54
3		Jagiellonia Bialystok	54
4		Wisła Płock	49
5		Górnik Zabrze	47
6		Korona Kielce	45
7		Wisla Kraków	44
8		Zaglebie Lubin	43
9		Arka Gdynia	40
10		KS Cracovia	39
11		Śląsk Wrocław	31
12		Pogon Szczecin	31
13		Piast Gliwice	30
14		Lechia Gdansk	30
15		Termalica Nieciecza	29
16		Sandecja Nowy Sacz	25

	Playoff Título : Lech Poznań, Legia Warszawa, Jagiellonia Bialystok, Wisła Płock, Górnik Zabrze, Korona Kielce, Wisla Kraków, Zaglebie Lubin
	Playoff Descenso : Arka Gdynia, KS Cracovia, Śląsk Wrocław, Pogon Szczecin, Piast Gliwice, Lechia Gdansk, Termalica Nieciecza, Sandecja Nowy Sacz

RIVALES EN Fase Previa Cham.

RIVALES EN Copa Polonia

RIVALES EN Fase Previa Euro.

RIVALES EN Liga Polaca

RIVALES EN Supercopa Poloni.

USO DE MEMORIA

7,536,024 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.2550
Total Execution Time	0.2569

CADENA URL

/historico/Kp-Legia-Warszawa/2018

GET DATOS

$_GET['/historico/Kp-Legia-Warszawa/2018']

POST DATOS

No hay datos POST existentes

CONSULTAS (61)

0.0069	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 = 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.0024	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.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=1465 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=1465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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.0038	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.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=1465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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.0069	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.0066	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.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 = 43271
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 = 38740
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 = 38745
0.0050	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 = 38703
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1465 AND type_rel = 2
0.0023	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.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 (4368,4799,8908,11589,19665) ORDER BY n.cover_points DESC, update_date DESC
0.0043	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 = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0038	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.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 = 38739 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	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 = 38745 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037	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 = 38694 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 = 38703 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0050	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 (2017,2018,2019) 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 (49562,44546,43952,43940,43567,43475,37544,34713) 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.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 49562 AND teamId = 1465
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 34713 AND teamId = 1465
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 37544 AND teamId = 1465
0.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 43952 AND teamId = 1465
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 44546 AND teamId = 1465
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 43940 AND teamId = 1465
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 43567 AND teamId = 1465
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 1465
0.0056	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 = 38694 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1465' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1465' and rp.type = 4
0.0022	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1465' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1465' and rp.type = 4
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 events2018 e ON e.player_id = p.id AND e.league_id = 38694 WHERE rp.league_id = 38694 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.0037	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 = 38694 WHERE rp.league_id = 38694 AND rp.teamId = 1465 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 = 38694 WHERE rp.league_id = 38694 AND rp.teamId = 1465 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0052	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 1465 AND l.year <= 2018 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 43271 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2017` 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 = 31530 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2017` 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 = 38339 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2016` 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 = 15467 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2016` 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 = 23684 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2015` 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 = 3818 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2015` 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 = 13703 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2014` 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 = 2422 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2014` 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 = 10839 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2013` 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 = 2038 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM* `tables2012` 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 = 1363 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2011` 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 = 1076 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2010` 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 = 871 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2009` 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 = 803 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM* `tables2008` 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 = 8782 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2007` 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 = 8785 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2006` 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 = 8787 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2005` 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 = 8790 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2004` 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 = 8793 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


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

Resultados de Fútbol

Legia Warszawa

Legia Warszawa

Selecciona un equipo

Competiciones que juega

Liga Polaca Grupo 1

RIVALES EN Fase Previa Cham.

RIVALES EN Copa Polonia

RIVALES EN Fase Previa Euro.

RIVALES EN Liga Polaca

RIVALES EN Supercopa Poloni.