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

Zaglebie Lubin

Entrenador: Waldemar Fornalik

Temporada 2019/2020

TEMPORADA 2019/2020

LIGA POLACA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Górnik	37	51	47	53
2	Raków	37	51	56	53
3	Zaglebie	37	61	53	53
4	Wisła	37	45	54	51
5	Wisla	37	44	56	45
6	Arka Gdynia	37	39	57	40
7	Korona	37	29	48	35
8	LKS Lódz	37	33	68	24

TEMPORADA 2018/2019

LIGA POLACA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Piast	37	57	33	72
2	Legia	37	55	38	68
3	Lechia	37	54	38	67
4	KS Cracovia	37	45	43	57
5	Jagiellonia	37	55	52	57
6	Zaglebie	37	57	48	53
7	Pogon	37	57	54	52
8	Lech Poznań	37	49	48	52

TEMPORADA 2017/2018

LIGA POLACA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Legia	37	55	35	70
2	Jagiellonia	37	55	41	67
3	Lech Poznań	37	53	34	60
4	Górnik	37	68	54	60
5	Wisła	37	53	45	57
6	Wisla	37	51	42	55
7	Zaglebie	37	45	42	52
8	Korona	37	49	54	49

TEMPORADA 2016/2017

LIGA POLACA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Zaglebie	7	14	9	34
2	Piast	7	14	5	31
3	Śląsk	7	15	7	29
4	Wisła	7	7	13	28
5	Arka Gdynia	7	7	10	24
6	KS Cracovia	7	7	9	24
7	Górnik	7	11	11	22
8	Ruch	7	5	16	19

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	32
6	Pogon	7	7	13	30
7	Lech Poznań	7	5	9	27
8	Ruch	7	3	14	21

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	KS Cracovia	30	37	43	39
10	Jagiellonia	30	46	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	Wisla	30	28	35	38
8	Lechia	30	42	43	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	Jagiellonia	30	35	45	39
11	Widzew	30	25	26	39
12	Podbeskidzie	30	26	39	35
13	Lechia	30	21	30	31
14	Bełchatów	30	34	36	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	Lechia	30	37	36	43
9	Widzew	30	41	34	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	Korona	30	35	41	37
7	Polonia	30	29	31	37
8	Lechia	30	30	32	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

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	Odra	30	29	36	40
11	Arka Gdynia	30	43	39	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

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 Liga Polaca

USO DE MEMORIA

6,720,312 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.8315
Total Execution Time	0.8334

CADENA URL

/historico/Zaglebie-Lubin/2020

GET DATOS

$_GET['/historico/Zaglebie-Lubin/2020']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0192	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 = 'Zaglebie-Lubin' 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.0148	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=3974 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=3974 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152	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=3974 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0154	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=3974 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=3974 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0172	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.0189	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 = 56792
0.0149	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3974 AND type_rel = 2
0.0149	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3974 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148	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 (97638,111611,135482,138528,155052) ORDER BY n.cover_points DESC, update_date DESC
0.0157	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 = '3974' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0153	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 = '3974' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146	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 = 56792 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154	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=3974 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0146	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 (57380,57378,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.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 57378 AND teamId = 3974
0.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 57380 AND teamId = 3974
0.0225	SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 3974
0.0149	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.0167	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 = 3974 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.0158	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 = 3974 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153	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 = 3974 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153	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 = 3974 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.0147	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 = 56792 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.0149	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.0147	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.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* `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.0147	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.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 = 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.0147	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 = 38340 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* `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.0153	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.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* `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.0162	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.0149	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.0149	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.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* `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.0149	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.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* `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.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* `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.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* `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.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* `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.0147	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
0.0148	SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 128 AND l.year = 2020 ORDER BY l.group_code ASC

Zaglebie Lubin

Zaglebie Lubin

Selecciona un equipo

Competiciones que juega

Liga Polaca Grupo 1

RIVALES EN Copa Polonia

RIVALES EN Liga Polaca