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 2023/2024

TEMPORADA 2023/2024

LIGA POLACA
Equipo		PJ	GF	GC	Puntos
1	Jagiellonia	29	66	39	55
2	Śląsk	29	38	26	51
3	Lech Poznań	29	43	34	51
4	Górnik	29	39	32	48
5	Legia	29	43	33	47
6	Pogon	29	54	34	47
7	Raków	29	50	32	46
8	Widzew	29	39	38	42
9	Stal Mielec	29	35	39	38
10	Piast	29	30	32	35
11	Zaglebie	29	31	43	35
12	Radomiak	29	34	47	35
13	Warta Poznan	29	31	35	34
14	Puszcza	29	35	46	32
15	KS Cracovia	29	38	40	32
16	Korona	29	34	38	30
17	LKS Lódz	29	28	61	21
18	Ruch	29	31	50	20

TEMPORADA 2022/2023

LIGA POLACA
Equipo		PJ	GF	GC	Puntos
1	Raków	34	63	24	75
2	Legia	34	57	37	66
3	Lech Poznań	34	51	29	61
4	Pogon	34	57	46	60
5	Piast	34	40	31	53
6	Górnik	34	45	43	48
7	KS Cracovia	34	41	35	46
8	Warta Poznan	34	37	35	45
9	Zaglebie	34	35	44	45
10	Radomiak	34	34	41	44
11	Stal Mielec	34	36	40	43
12	Widzew	34	38	47	41
13	Korona	34	39	48	41
14	Jagiellonia	34	48	49	41
15	Śląsk	34	35	48	38
16	Wisła	34	41	50	37
17	Lechia	34	28	56	30
18	Miedz	34	33	55	23

TEMPORADA 2021/2022

LIGA POLACA
Equipo		PJ	GF	GC	Puntos
1	Lech Poznań	34	67	24	74
2	Raków	34	60	30	69
3	Pogon	34	63	31	65
4	Lechia	34	52	39	57
5	Piast	34	45	37	54
6	Wisła	34	48	51	48
7	Radomiak	34	42	40	48
8	Górnik	34	55	55	47
9	KS Cracovia	34	40	42	46
10	Legia	34	46	48	43
11	Warta Poznan	34	35	38	42
12	Jagiellonia	34	39	50	40
13	Zaglebie	34	43	59	38
14	Stal Mielec	34	39	52	37
15	Śląsk	34	42	52	35
16	Termalica	34	36	56	32
17	Wisla	34	37	54	31
18	Górnik	34	29	60	28

TEMPORADA 2020/2021

LIGA POLACA
Equipo		PJ	GF	GC	Puntos
1	Legia	30	48	24	64
2	Raków	30	46	25	59
3	Pogon	30	36	23	52
4	Śląsk	30	36	32	43
5	Warta Poznan	30	33	32	43
6	Piast	30	39	32	42
7	Lechia	30	40	37	42
8	Zaglebie	30	38	40	41
9	Jagiellonia	30	39	48	37
10	Górnik	30	31	33	37
11	Lech Poznań	30	39	38	37
12	Wisła	30	37	44	33
13	Wisla	30	39	42	33
14	KS Cracovia	30	28	32	32
15	Stal Mielec	30	31	47	29
16	Podbeskidzie	30	29	60	25

TEMPORADA 2019/2020

LIGA POLACA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Legia	30	63	30	60
2	Piast	30	36	26	53
3	Śląsk	30	42	33	49
4	Lech Poznań	30	55	29	49
5	KS Cracovia	30	39	29	46
6	Pogon	30	29	31	45
7	Jagiellonia	30	41	39	44
8	Lechia	30	40	42	43
9	Górnik	30	39	38	41
10	Raków	30	38	43	41
11	Zaglebie	30	49	46	38
12	Wisła	30	37	50	38
13	Wisla	30	37	47	35
14	Korona	30	21	37	30
15	Arka Gdynia	30	28	47	29
16	LKS Lódz	30	26	53	21

TEMPORADA 2018/2019

LIGA POLACA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Piast	7	10	2	72
2	Legia	7	7	7	68
3	Lechia	7	9	13	67
4	Jagiellonia	7	10	11	57
5	KS Cracovia	7	6	9	57
6	Zaglebie	7	9	10	53
7	Pogon	7	13	12	52
8	Lech Poznań	7	8	8	52

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 1
Equipo		PJ	GF	GC	Puntos
1	Legia	30	57	30	56
2	Lech Poznań	30	53	27	56
3	Jagiellonia	30	43	35	49
4	Śląsk	30	44	36	48
5	Górnik	30	43	43	43
6	Wisla	30	47	40	42
7	Pogon	30	40	38	41
8	Lechia	30	36	37	41
9	Piast	30	38	43	39
10	Korona	30	34	42	39
11	Podbeskidzie	30	40	49	38
12	KS Cracovia	30	35	41	37
13	Górnik	30	31	37	34
14	Ruch	30	33	38	33
15	Bełchatów	30	24	42	31
16	Zawisza	30	32	52	29

TEMPORADA 2013/2014

LIGA POLACA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Legia	30	60	30	63
2	Lech Poznań	30	56	34	53
3	Ruch	30	40	38	50
4	Pogon	30	47	38	47
5	Wisla	30	38	30	45
6	Zawisza	30	43	37	42
7	Górnik	30	42	46	42
8	Lechia	30	38	37	40
9	Jagiellonia	30	46	43	39
10	KS Cracovia	30	37	43	39
11	Korona	30	36	41	37
12	Śląsk	30	38	40	34
13	Piast	30	29	47	34
14	Podbeskidzie	30	27	39	31
15	Zaglebie	30	31	40	29
16	Widzew	30	26	51	22

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

Competiciones que juega

RIVALES EN Fase Previa Conf.

RIVALES EN Conference Leagu.

RIVALES EN Copa Polonia

RIVALES EN Liga Polaca

RIVALES EN Supercopa Poloni.

USO DE MEMORIA

7,183,144 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	1.0515
Total Execution Time	1.0526

CADENA URL

/historico/Kp-Legia-Warszawa

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (57)

0.0175	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 = 2024 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.0146	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.0146	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.0146	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.0146	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.0147	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.0147	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.0150	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.0149	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.0155	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.0153	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.0173	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 = 73884
0.0154	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 = 72168
0.0154	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 = 71687
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1465 AND type_rel = 2
0.0153	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.0150	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.0223	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.0154	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 = 73884 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0156	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 = 72168 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145	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 = 71687 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0157	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 (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145	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 (74792,72171,72168,72103,71687,71432) 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.0154	SELECT count(id) as num_players from rel_players WHERE league_id = 72168 AND teamId = 1465
0.0158	SELECT count(id) as num_players from rel_players WHERE league_id = 74792 AND teamId = 1465
0.0166	SELECT count(id) as num_players from rel_players WHERE league_id = 72103 AND teamId = 1465
0.0203	SELECT count(id) as num_players from rel_players WHERE league_id = 72171 AND teamId = 1465
0.0186	SELECT count(id) as num_players from rel_players WHERE league_id = 71687 AND teamId = 1465
0.0530	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1465
0.0148	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.0146	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1465' and rp.type = 4
0.0147	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.0145	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1465' and rp.type = 4
0.0164	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 events2024 e ON e.player_id = p.id AND e.league_id = 74792 WHERE rp.league_id = 74792 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.0173	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 events2024 e ON e.player_id = p.id AND e.league_id = 74792 WHERE rp.league_id = 74792 AND rp.teamId = 1465 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149	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 events2024 e ON e.player_id = p.id AND e.league_id = 74792 WHERE rp.league_id = 74792 AND rp.teamId = 1465 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0167	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 <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0154	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* `tables2024` 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 = 72168 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	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* `tables2023` 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 = 67771 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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* `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 = 63126 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163	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* `tables2021` 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 = 57378 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160	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* `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 = 56791 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164	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* `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 team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164	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* `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 = 43817 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164	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* `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 = 49562 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164	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 = 38694 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	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.0154	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.0148	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.0152	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.0148	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.0151	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.0150	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.0152	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.0151	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.0150	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.0150	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


	¿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

RIVALES EN Fase Previa Conf.

RIVALES EN Conference Leagu.

RIVALES EN Copa Polonia

RIVALES EN Liga Polaca

RIVALES EN Supercopa Poloni.