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

Widzew Łódź

Entrenador: Daniel Mysliwiec

Temporada 2023/2024

TEMPORADA 2023/2024

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

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

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Miedz	34	56	22	77
2	Widzew	34	53	38	62
3	Arka Gdynia	34	62	39	61
4	Korona	34	46	37	56
5	Odra Opole	34	51	46	51
6	Chrobry	34	43	34	50
7	Sandecja	34	39	36	47
8	Katowice	34	44	47	46
9	Podbeskidzie	34	48	41	45
10	LKS Lódz	34	33	37	45
11	Resovia	34	42	39	44
12	GKS Tychy	34	37	41	44
13	SKRA	34	28	41	38
14	Puszcza	34	41	50	37
15	Zagłębie	34	41	48	36
16	Stomil	34	32	52	35
17	Gornik	34	32	54	29
18	Jastrzębie	34	32	58	25

TEMPORADA 2020/2021

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Radomiak	34	49	20	68
2	Termalica	34	56	28	65
3	GKS Tychy	34	49	27	63
4	Arka Gdynia	34	51	32	60
5	LKS Lódz	34	59	41	58
6	Górnik	34	47	30	56
7	Miedz	34	49	36	51
8	Odra Opole	34	35	41	49
9	Widzew	34	30	36	46
10	Sandecja	34	42	50	45
11	Chrobry	34	34	45	44
12	Korona	34	31	46	41
13	Puszcza	34	32	46	37
14	Jastrzębie	34	32	48	35
15	Stomil	34	31	48	35
16	Resovia	34	27	45	32
17	Zagłębie	34	35	43	30
18	Bełchatów	34	24	51	23

TEMPORADA 2019/2020

TERCERA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Górnik	34	47	37	63
2	Katowice	34	57	40	59
3	Widzew	34	65	37	59
4	Resovia	34	50	32	52
5	Bytovia	34	50	48	52
6	Stal Rzeszow	34	55	44	51
7	Olimpia	34	46	38	50
8	Garbarnia	34	46	40	50
9	Znicz	34	49	52	49
10	Pogon	34	54	53	49
11	Gornik	34	60	47	48
12	Lech Poznań	34	49	47	47
13	Stargard	34	54	53	47
14	SKRA	34	37	44	47
15	Stal Stalowa	34	45	49	46
16	Elana Torun	34	50	54	41
17	Legionovia	34	33	64	24
18	Gryf	34	23	91	14

TEMPORADA 2018/2019

TERCERA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Radomiak	34	67	28	59
2	Olimpia	34	65	44	59
3	Bełchatów	34	41	22	58
4	Elana Torun	34	51	37	56
5	Widzew	34	48	29	55
6	Pogon	34	54	42	51
7	Stal Stalowa	34	47	45	51
8	Górnik	34	49	55	46
9	Resovia	34	39	45	46
10	Znicz	34	47	60	46
11	SKRA	34	32	48	43
12	Stargard	34	41	51	41
13	Olimpia	34	28	38	40
14	Gryf	34	49	61	40
15	Siarka	34	33	57	39
16	Energetyk	34	33	41	38
17	Rozwoj	34	38	52	34
18	Ruch	34	37	44	32

TEMPORADA 2017/2018

CUARTA POLONIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Lechia	34	74	33	74
2	Widzew	34	63	25	74
3	Sokół	34	64	37	66
4	Polonia	34	63	37	62
5	Olimpia	34	60	54	56
6	Huragan	34	50	38	54
7	Ursus	34	51	46	53
8	Swit Nowy D.	34	58	52	49
9	Victoria	34	53	59	48
10	LKS Łomża	34	41	46	45
11	Pelikan	34	63	63	43
12	Drwęca Nowe	34	40	54	42
13	MKS Ełk	34	35	42	39
14	Sokół	34	40	48	39
15	Legia	34	52	52	38
16	Warta	34	35	59	27
17	Bielsk	34	33	79	25
18	Wikielec	34	31	82	18

TEMPORADA 2016/2017

CUARTA POLONIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Drwęca Nowe	34	80	33	75
2	LKS Lódz	34	60	18	73
3	Widzew	34	57	34	66
4	Swit Nowy D.	34	61	32	62
5	Lechia	34	59	37	55
6	Sokół	34	53	39	54
7	Pelikan	34	50	39	53
8	Legia	34	58	51	53
9	Sokół	34	46	34	49
10	LKS Łomża	34	37	34	46
11	MKS Ełk	34	45	51	44
12	Huragan	34	43	39	43
13	Ursus	34	43	44	42
14	Jagiellonia	34	34	50	40
15	Concordia	34	59	57	39
16	Huragan	34	27	84	25
17	Ruch Wysokie	34	26	69	21
18	Motor Lubawa	34	15	108	5

TEMPORADA 2014/2015

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Zaglebie	34	57	20	77
2	Termalica	34	60	26	73
3	Wisła	34	50	25	69
4	Olimpia	34	46	37	53
5	Chojniczanka	34	50	37	50
6	Dolcan Zabki	34	43	39	50
7	Stomil	34	47	47	49
8	Katowice	34	44	41	48
9	Wigry	34	36	37	47
10	Arka Gdynia	34	38	39	43
11	Chrobry	34	41	45	41
12	Miedz	34	44	45	40
13	Bytovia	34	39	45	40
14	Swinoujscie	34	26	46	36
15	Sandecja	34	40	55	35
16	Pogon	34	34	53	30
17	GKS Tychy	34	31	56	28
18	Widzew	34	25	58	22

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

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

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Widzew	34	62	17	77
2	Górnik	34	47	30	61
3	Sandecja	34	55	42	59
4	LKS Lódz	34	51	45	55
5	Pogon	34	46	35	51
6	Kluczbork	34	43	37	46
7	Swinoujscie	34	33	36	46
8	KSZO	34	37	46	46
9	Warta	34	34	33	45
10	Podbeskidzie	34	45	38	44
11	Warta Poznan	34	49	45	44
12	Górnik	34	38	45	44
13	Katowice	34	41	41	43
14	Dolcan Zabki	34	37	43	42
15	Wisła	34	43	51	40
16	Znicz	34	32	48	39
17	Stal Stalowa	34	32	58	25
18	Motor Lublin	34	27	62	23

TEMPORADA 2008/2009

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Widzew	34	55	23	72
2	Zaglebie	34	68	33	69
3	Korona	34	51	37	61
4	Podbeskidzie	34	58	29	59
5	Górnik	34	49	36	57
6	Znicz	34	42	29	55
7	Swinoujscie	34	43	37	53
8	Dolcan Zabki	34	35	31	49
9	Wisła	34	45	41	47
10	Warta Poznan	34	44	45	46
11	Katowice	34	37	42	44
12	Stal Stalowa	34	33	34	43
13	Jastrzębie	34	37	48	41
14	Warta	34	39	54	36
15	Motor Lublin	34	21	36	32
16	Tur Turek	34	29	56	30
17	Odra Opole	34	22	51	25
18	Kmita	34	11	57	21

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

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Widzew	34	53	28	62
2	LKS Lódz	34	42	21	58
3	Jagiellonia	34	48	30	56
4	Śląsk	34	38	35	56
5	Zagłębie	34	48	34	54
6	Zawisza	34	38	26	53
7	Ruch	34	50	36	51
8	Piast	34	44	33	48
9	KSZO	34	37	41	46
10	Gornik	34	36	37	45
11	Lechia	34	33	39	45
12	Heko	34	40	42	43
13	Podbeskidzie	34	37	38	41
14	Radomiak	34	39	46	35
15	Polonia	34	32	51	35
16	Swit Nowy D.	34	27	54	30
17	Szczakowiank	34	28	63	29
18	Drwęca Nowe	34	31	47	26

TEMPORADA 2004/2005

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Korona	34	51	33	67
2	Bełchatów	34	58	35	66
3	Arka Gdynia	34	44	23	64
4	Widzew	34	44	26	58
5	Podbeskidzie	34	39	33	58
6	Jagiellonia	34	45	29	54
7	Kujawiak	34	48	36	54
8	Zagłębie	34	48	44	54
9	LKS Lódz	34	48	42	51
10	KSZO	34	43	41	50
11	Swit Nowy D.	34	34	30	49
12	Gornik	34	29	42	41
13	Piast	34	29	37	36
14	Ruch	34	36	50	35
15	Szczakowiank	34	37	38	33
16	Radomiak	34	34	48	31
17	Mlawa	34	25	47	28
18	Radomsko	34	28	86	11

Competiciones que juega

Liga Polaca

Pos	Equipos		Pts
1		Jagiellonia Bialystok	56
2		Lech Poznań	52
3		Górnik Zabrze	51
4		Śląsk Wrocław	51
5		Legia Warszawa	50
6		Raków Częstochowa	49
7		Pogon Szczecin	48
8		Widzew Łódź	42
9		Piast Gliwice	38
10		Stal Mielec	38
11		Zaglebie Lubin	38
12		Radomiak Radom	35
13		Warta Poznan	34
14		Puszcza Niepolomice	33
15		KS Cracovia	33
16		Korona Kielce	31
17		Ruch Chorzów	23
18		LKS Lódz	21

	Campeón : Jagiellonia Bialystok
	: Lech Poznań, Górnik Zabrze
	Descenso : Korona Kielce, Ruch Chorzów, LKS Lódz

RIVALES EN Copa Polonia

RIVALES EN Liga Polaca

USO DE MEMORIA

7,933,944 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1592
Total Execution Time	0.1605

CADENA URL

/historico/Widzew-Od

GET DATOS

$_GET['/historico/Widzew-Od']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0034	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 = 'Widzew-Od' 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.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=5811 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=5811 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=5811 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=5811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5811 AND type_rel = 2
0.0025	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5811 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 (133540,237314,1132350,1168891) ORDER BY n.cover_points DESC, update_date DESC
0.0038	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 = '5811' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0037	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 = '5811' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0031	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=5811 AND l.year in (2023,2024,2025) 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 (72171,72168,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.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 72168 AND teamId = 5811
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 72171 AND teamId = 5811
0.0032	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 5811
0.0021	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 = '5811' 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 = '5811' and rp.type = 4
0.0021	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 = '5811' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2024 e ON e.player_id = p.id AND e.league_id = 72168 WHERE rp.league_id = 72168 AND rp.teamId = 5811 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.0044	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 = 72168 WHERE rp.league_id = 72168 AND rp.teamId = 5811 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030	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 = 72168 WHERE rp.league_id = 72168 AND rp.teamId = 5811 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0040	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 = 5811 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0039	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.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* `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 = 63249 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.0034	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 = 58338 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.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* `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 = 50151 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.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* `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 = 44128 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 38925 AND t.round = 34 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 = 33762 AND t.round = 34 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* `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 = 3876 AND t.round = 34 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 = 10840 AND t.round = 7 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* `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.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* `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.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* `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.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* `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 = 8842 AND t.round = 34 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 = 8840 AND t.round = 34 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* `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.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* `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.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* `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 = 8833 AND t.round = 34 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* `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 = 8832 AND t.round = 34 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

Widzew Łódź

Widzew Łódź

Selecciona un equipo

Competiciones que juega

Liga Polaca

RIVALES EN Copa Polonia

RIVALES EN Liga Polaca