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

Miedz Legnica

Entrenador: Ireneusz Mamrot

Temporada 2019/2020

TEMPORADA 2019/2020

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Stal Mielec	34	57	31	67
2	Podbeskidzie	34	64	35	65
3	Warta Poznan	34	52	35	60
4	Radomiak	34	52	45	57
5	Miedz	34	49	44	51
6	Termalica	34	47	34	50
7	Chrobry	34	41	44	49
8	Puszcza	34	36	37	48
9	GKS Tychy	34	60	53	47
10	Stomil	34	30	38	46
11	Sandecja	34	45	49	44
12	Zagłębie	34	49	55	44
13	Odra Opole	34	33	39	42
14	Jastrzębie	34	41	46	41
15	Bełchatów	34	36	45	40
16	Olimpia	34	45	56	40
17	Chojniczanka	34	46	67	30
18	Wigry	34	27	57	26

TEMPORADA 2018/2019

LIGA POLACA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Wisla	37	67	63	49
2	Korona	37	42	54	47
3	Górnik	37	48	53	46
4	Śląsk	37	49	45	44
5	Arka Gdynia	37	49	51	42
6	Wisła	37	50	58	41
7	Miedz	37	40	65	40
8	Zagłębie	37	49	80	29

TEMPORADA 2017/2018

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Miedz	34	53	27	63
2	Zagłębie	34	46	32	58
3	Chojniczanka	34	48	33	56
4	GKS Tychy	34	41	40	55
5	Katowice	34	44	34	54
6	Wigry	34	40	37	52
7	Raków	34	50	40	51
8	Stal Mielec	34	51	46	51
9	Podbeskidzie	34	37	37	46
10	Chrobry	34	46	47	46
11	Odra Opole	34	37	43	45
12	Puszcza	34	38	38	44
13	Bytovia	34	36	45	40
14	Stomil	34	39	50	39
15	Pogon	34	42	50	38
16	Górnik	34	29	42	35
17	Olimpia	34	24	37	31
18	Ruch	34	35	58	27

TEMPORADA 2016/2017

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Sandecja	34	50	29	61
2	Górnik	34	53	34	58
3	Miedz	34	49	27	57
4	Zagłębie	34	53	44	57
5	Olimpia	34	48	35	56
6	Chojniczanka	34	54	48	56
7	Katowice	34	47	32	54
8	Podbeskidzie	34	40	39	53
9	Wigry	34	51	45	52
10	Stal Mielec	34	38	42	45
11	Pogon	34	34	46	44
12	Chrobry	34	50	50	43
13	Stomil	34	48	50	37
14	GKS Tychy	34	42	51	37
15	Bytovia	34	38	47	35
16	Wisla Pulawy	34	33	49	33
17	Znicz	34	35	64	30
18	Kluczbork	34	35	66	25

TEMPORADA 2015/2016

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Arka Gdynia	34	60	29	69
2	Wisła	34	51	28	63
3	Zawisza	34	57	51	52
4	Katowice	34	42	36	52
5	Zagłębie	34	53	53	52
6	Chrobry	34	47	33	51
7	Miedz	34	41	34	51
8	Bytovia	34	46	44	48
9	Sandecja	34	51	43	47
10	Wigry	34	41	35	45
11	Stomil	34	34	42	44
12	Chojniczanka	34	40	45	43
13	Olimpia	34	39	43	42
14	Kluczbork	34	40	55	41
15	Pogon	34	31	46	41
16	Bełchatów	34	35	40	38
17	Rozwoj	34	35	56	35
18	Dolcan Zabki	34	37	67	30

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

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Bełchatów	34	50	27	63
2	Górnik	34	45	27	61
3	Dolcan Zabki	34	60	39	55
4	Arka Gdynia	34	53	40	54
5	Termalica	34	42	33	53
6	Olimpia	34	38	39	53
7	Wisła	34	37	33	52
8	Katowice	34	44	45	46
9	Miedz	34	42	37	44
10	Kolejarz	34	36	38	44
11	Sandecja	34	29	40	44
12	Swinoujscie	34	29	34	42
13	Chojniczanka	34	35	33	41
14	Stomil	34	38	42	41
15	GKS Tychy	34	39	48	41
16	Energetyk	34	42	52	33
17	Puszcza	34	37	56	33
18	Brzesko	34	18	51	23

TEMPORADA 2012/2013

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Zawisza	34	69	26	66
2	KS Cracovia	34	48	35	64
3	Termalica	34	54	28	63
4	Swinoujscie	34	57	33	63
5	Arka Gdynia	34	46	29	57
6	GKS Tychy	34	44	28	55
7	Dolcan Zabki	34	52	41	54
8	Miedz	34	49	42	53
9	Olimpia	34	39	34	51
10	Katowice	34	43	36	50
11	Kolejarz	34	47	45	50
12	Górnik	34	37	42	46
13	Stomil	34	37	45	38
14	Sandecja	34	35	54	37
15	Brzesko	34	38	54	32
16	Warta Poznan	34	34	57	28
17	Polonia	34	29	64	22
18	LKS Lódz	34	17	82	14

TEMPORADA 2011/2012

TERCERA POLONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Miedz	34	62	23	64
2	GKS Tychy	34	50	27	59
3	Bytovia	34	47	45	54
4	Jarota	34	41	36	52
5	Górnik	34	37	29	50
6	Elana Torun	34	46	41	50
7	Ruch	34	36	36	50
8	Chojniczanka	34	58	45	49
9	Chrobry	34	36	38	49
10	Kluczbork	34	44	35	48
11	Energetyk	34	46	59	44
12	Raków	34	37	51	44
13	Czarni	34	34	53	44
14	Zagłębie	34	46	45	40
15	Tur Turek	34	41	46	38
16	Calisia	34	47	60	36
17	Bałtyk	34	29	42	29
18	Nielba	34	36	62	29

TEMPORADA 2010/2011

TERCERA POLONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Olimpia	34	66	30	71
2	Zawisza	34	56	24	66
3	GKS Tychy	34	63	30	65
4	Miedz	34	45	31	56
5	Zagłębie	34	49	36	55
6	Ruch	34	45	32	54
7	Chojniczanka	34	45	34	53
8	Bałtyk	34	40	31	53
9	Nielba	34	61	51	50
10	Górnik	34	44	34	48
11	Elana Torun	34	42	43	47
12	Czarni	34	54	47	45
13	Jarota	34	40	34	45
14	Raków	34	42	40	44
15	Tur Turek	34	51	71	30
16	Zielona	34	25	66	22
17	Polonia Nowy	33	23	84	15
18	Polonia	33	11	84	10

TEMPORADA 2009/2010

TERCERA POLONIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ruch	34	61	25	76
2	Gornik	34	56	31	68
3	Zagłębie	34	44	21	62
4	Zawisza	34	54	30	59
5	Nielba	34	48	38	55
6	Olimpia	34	44	40	53
7	Jarota	34	42	39	48
8	GKS Tychy	34	40	41	48
9	Czarni	34	46	42	47
10	Raków	34	38	31	45
11	Bałtyk	34	44	38	41
12	Polonia	34	31	47	39
13	Zielona	34	33	54	36
14	Tur Turek	34	27	36	35
15	Miedz	34	33	58	35
16	Elana Torun	34	31	47	34
17	Unia	34	44	72	33
18	Ślęza	34	30	56	22

TEMPORADA 2008/2009

TERCERA POLONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kluczbork	34	59	33	67
2	Pogon	34	55	35	62
3	Gawin	34	57	37	59
4	Nielba	34	62	44	57
5	Raków	34	46	32	54
6	Kotwica	34	45	33	53
7	Elana Torun	34	49	41	51
8	Zawisza	34	47	43	51
9	Zagłębie	34	36	31	49
10	Unia	34	30	27	48
11	GKS Tychy	34	35	34	48
12	Jarota	34	51	44	45
13	Miedz	34	39	51	39
14	Czarni	34	31	50	38
15	Victoria	34	27	50	33
16	Zielona	34	37	61	30
17	Chemik	34	31	65	28
18	Polonia	34	36	62	26

TEMPORADA 2007/2008

TERCERA POLONIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Warta	30	41	14	61
2	Raków	30	58	26	59
3	Gawin	30	59	29	57
4	Kluczbork	30	55	31	56
5	Miedz	30	54	25	53
6	Polonia	30	50	31	49
7	Zielona	30	50	41	46
8	Rozwoj	30	37	30	46
9	Orzeł	30	46	47	45
10	Walka	30	42	37	43
11	1910	30	49	47	40
12	Chrobry	30	29	37	32
13	ARKA Nowa S.	30	35	60	31
14	Unia Kunice	30	23	59	22
15	Skalnik	30	20	70	19
16	Pogoń	30	17	81	9

TEMPORADA 2006/2007

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Ruch	44	68	37	92
2	Jagiellonia	44	67	39	85
3	Polonia	43	75	43	73
4	Zagłębie	43	70	48	73
5	Gornik	44	56	43	70
6	Lechia	44	68	47	69
7	Zawisza	44	49	68	65
8	Polonia	43	65	50	64
9	Piast	43	53	44	58
10	Śląsk	42	38	43	55
11	KSZO	44	34	39	53
12	Odra Opole	44	37	46	52
13	Stal Stalowa	43	38	58	49
14	Kmita	43	45	61	46
15	Podbeskidzie	44	33	64	46
16	Unia	44	47	67	43
17	LKS Łomża	40	41	60	38
18	Miedz	44	38	65	37

Competiciones que juega

Segunda Polonia

Pos	Equipos		Pts
1		Stal Mielec	67
2		Podbeskidzie	65
3		Warta Poznan	60
4		Radomiak Radom	57
5		Miedz Legnica	51
6		Termalica Nieciecza	50
7		Chrobry Głogów	49
8		Puszcza Niepolomice	48
9		GKS Tychy	47
10		Stomil Olsztyn	46
11		Sandecja Nowy Sacz	44
12		Zagłębie Sosnowiec	44
13		Odra Opole	42
14		Jastrzębie	41
15		GKS Bełchatów	40
16		Olimpia Grudziadz	40
17		Chojniczanka Chojnice	30
18		Wigry Suwalki	26

	Ascenso : Stal Mielec, Podbeskidzie
	Playoff Ascenso : Warta Poznan, Radomiak Radom, Miedz Legnica, Termalica Nieciecza
	Descenso : Olimpia Grudziadz, Chojniczanka Chojnice, Wigry Suwalki

RIVALES EN Copa Polonia

RIVALES EN Segunda Polonia

RIVALES EN Segunda Polonia.

USO DE MEMORIA

7,234,832 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.2010
Total Execution Time	0.2022

CADENA URL

/historico/Miedz-Legnica-57813/2020

GET DATOS

$_GET['/historico/Miedz-Legnica-57813/2020']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0032	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 = 'Miedz-Legnica-57813' 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.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=13372 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13372 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13372 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13372 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13372 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 49994
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 = 57469
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13372 AND type_rel = 2
0.0022	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13372 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	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 (44367,471865,568615,646951,693203) ORDER BY n.cover_points DESC, update_date DESC
0.0026	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 = '13372' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0031	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 = '13372' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023	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 = 49913 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 = 49994 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 57469 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028	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=13372 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0022	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 (58338,57469,57380,56547,49563) 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.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 49563 AND teamId = 13372
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 58338 AND teamId = 13372
0.0029	SELECT count(id) as num_players from rel_players WHERE league_id = 57380 AND teamId = 13372
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 57469 AND teamId = 13372
0.0285	SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 13372
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 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 = 49994 AND t.round = 34 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 = '13372' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13372' and rp.type = 4
0.0023	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 = '13372' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0069	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 = 49994 WHERE rp.league_id = 49994 AND rp.teamId = 13372 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.0056	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 = 49994 WHERE rp.league_id = 49994 AND rp.teamId = 13372 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038	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 = 49994 WHERE rp.league_id = 49994 AND rp.teamId = 13372 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	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 = 13372 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0028	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 = 49994 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* `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.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* `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 = 49563 AND t.round = 7 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* `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 = 38760 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 = 33387 AND t.round = 34 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 = 15593 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.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 = 2863 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* `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 = 8850 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* `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 = 25076 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* `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 = 25066 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043	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 = 25051 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0047	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 = 25048 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048	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 = 25022 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* `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 = 8836 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 49994 ORDER BY nameShow LIMIT 100

Miedz Legnica

Miedz Legnica

Selecciona un equipo

Competiciones que juega

Segunda Polonia

RIVALES EN Copa Polonia

RIVALES EN Segunda Polonia

RIVALES EN Segunda Polonia.