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

Termalica Nieciecza

Entrenador: Marcin Brosz

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Lechia	30	50	26	59
2	Arka Gdynia	30	50	31	58
3	GKS Tychy	30	40	34	51
4	Katowice	30	51	31	50
5	Wisla	30	56	37	49
6	Motor Lublin	30	41	36	49
7	Wisła	30	43	39	48
8	Odra Opole	30	36	30	46
9	Górnik	30	30	26	46
10	Stal Rzeszow	30	45	47	42
11	Miedz	30	39	32	41
12	Znicz	30	28	37	37
13	Termalica	30	43	45	34
14	Chrobry	30	30	47	34
15	Polonia	30	36	44	30
16	Resovia	30	34	54	29
17	Podbeskidzie	30	24	50	22
18	Zagłębie	30	19	49	15

TEMPORADA 2022/2023

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	LKS Lódz	34	58	36	66
2	Ruch	34	48	33	62
3	Termalica	34	55	37	61
4	Wisla	34	61	38	60
5	Puszcza	34	49	36	58
6	Stal Rzeszow	34	57	44	51
7	Podbeskidzie	34	56	47	49
8	Arka Gdynia	34	56	45	48
9	Chrobry	34	44	53	46
10	Katowice	34	41	39	44
11	Zagłębie	34	33	43	42
12	Górnik	34	40	45	40
13	GKS Tychy	34	46	52	39
14	Resovia	34	43	51	38
15	Odra Opole	34	39	48	37
16	SKRA	34	19	50	31
17	Chojniczanka	34	35	57	27
18	Sandecja	34	28	54	27

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

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

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

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Raków	34	54	22	70
2	LKS Lódz	34	58	23	69
3	Stal Mielec	34	59	28	64
4	Sandecja	34	35	29	55
5	Jastrzębie	34	43	38	48
6	Podbeskidzie	34	52	46	48
7	GKS Tychy	34	48	41	47
8	Termalica	34	45	46	46
9	Puszcza	34	37	45	44
10	Stomil	34	38	43	43
11	Chojniczanka	34	49	49	42
12	Odra Opole	34	47	58	40
13	Warta Poznan	34	31	43	39
14	Chrobry	34	29	39	39
15	Wigry	34	40	56	37
16	Bytovia	34	45	50	37
17	Katowice	34	34	45	37
18	Garbarnia	34	21	64	21

TEMPORADA 2017/2018

LIGA POLACA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Śląsk	7	15	6	50
2	KS Cracovia	7	11	12	50
3	Pogon	7	12	6	45
4	Arka Gdynia	7	8	16	43
5	Lechia	7	7	7	39
6	Piast	7	12	10	37
7	Termalica	7	7	14	36
8	Sandecja	7	7	8	33

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 3
Equipo		PJ	GF	GC	Puntos
1	Wisla	7	16	10	32
2	Śląsk	7	13	9	31
3	Jagiellonia	7	9	8	28
4	Korona	7	7	8	27
5	Termalica	7	6	7	26
6	Górnik	7	10	10	24
7	Górnik	7	5	5	23
8	Podbeskidzie	7	8	17	20

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

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Piast	34	57	40	64
2	Pogon	34	54	30	61
3	Zawisza	34	47	39	59
4	Kolejarz	34	40	34	57
5	Termalica	34	42	26	56
6	Górnik	34	50	37	54
7	Arka Gdynia	34	50	41	51
8	Swinoujscie	34	46	43	49
9	Ruch	34	46	51	48
10	Warta Poznan	34	44	36	46
11	Olimpia	34	46	41	43
12	Sandecja	34	42	46	40
13	Katowice	34	33	38	39
14	Dolcan Zabki	34	40	53	39
15	Polonia	34	37	51	36
16	Wisła	34	39	50	35
17	Gornik	34	40	64	30
18	Olimpia	34	33	66	22

TEMPORADA 2010/2011

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	LKS Lódz	34	59	34	71
2	Podbeskidzie	34	53	23	69
3	Swinoujscie	34	58	34	66
4	Sandecja	34	52	34	56
5	Piast	34	45	31	52
6	Pogon	34	55	42	51
7	Górnik	34	44	39	50
8	Warta Poznan	34	44	43	50
9	Ruch	34	34	32	46
10	Gornik	34	31	39	42
11	Katowice	34	47	57	41
12	Kolejarz	34	30	43	38
13	Dolcan Zabki	34	33	39	37
14	Termalica	34	40	53	37
15	Kluczbork	34	36	44	36
16	KSZO	34	32	43	36
17	Odra	34	29	58	32
18	Warta	34	28	62	29

TEMPORADA 2009/2010

TERCERA POLONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Termalica	34	56	21	72
2	Kolejarz	34	53	35	61
3	Resovia	34	51	25	60
4	Start Otwock	34	44	33	59
5	Brzesko	34	46	42	59
6	Swit Nowy D.	34	57	46	58
7	Ruch Wysokie	34	53	36	56
8	Wigry	33	52	34	53
9	Jeziorak	34	37	27	51
10	Pelikan	34	39	36	45
11	Olimpia	34	45	53	45
12	Stal Rzeszow	34	47	49	42
13	Stomil	33	36	41	39
14	Jastrzębie	34	43	50	38
15	Sokół	34	29	43	34
16	Piotrków	34	34	49	34
17	Przebój	34	35	73	20
18	Hetman	34	20	84	16

TEMPORADA 2008/2009

CUARTA POLONIA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Korona	30	48	18	67
2	Termalica	30	57	20	64
3	Hutnik Nowa	30	60	23	55
4	Dalin	30	52	23	50
5	Puszcza	30	55	31	49
6	Garbarnia	30	40	23	48
7	Wierna	30	37	29	48
8	Czarni	30	35	26	47
9	Glinik	30	34	29	39
10	Lubrzanka	30	37	50	38
11	Naprzód	30	38	39	37
12	Unia Tarnów	29	27	33	35
13	Orlicz	30	33	48	27
14	Pohon 1945.	30	25	71	22
15	Granat	29	22	74	19
16	Neptun	30	14	77	14

Competiciones que juega

Segunda Polonia

Pos	Equipos		Pts
1		Lechia Gdansk	59
2		Arka Gdynia	58
3		GKS Tychy	51
4		GKS Katowice	50
5		Wisla Kraków	49
6		Motor Lublin	49
7		Wisła Płock	48
8		Odra Opole	46
9		Górnik Łęczna	46
10		Stal Rzeszow	42
11		Miedz Legnica	41
12		Znicz Pruszkow	37
13		Termalica Nieciecza	34
14		Chrobry Głogów	34
15		Polonia Warszawa	30
16		Resovia Rzeszów	29
17		Podbeskidzie	22
18		Zagłębie Sosnowiec	15

	Ascenso : Lechia Gdansk, Arka Gdynia
	Playoff Ascenso : GKS Tychy, GKS Katowice, Wisla Kraków, Motor Lublin
	Descenso : Resovia Rzeszów, Podbeskidzie, Zagłębie Sosnowiec

RIVALES EN Copa Polonia

RIVALES EN Segunda Polonia

USO DE MEMORIA

7,227,128 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.8029
Total Execution Time	0.8043

CADENA URL

/historico/Termalica-Bruk-Bet-Nieciecza

GET DATOS

$_GET['/historico/Termalica-Bruk-Bet-Nieciecza']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0159	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 = 'Termalica-Bruk-Bet-Nieciecza' 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.0145	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=13357 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=13357 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=13357 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=13357 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0295	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 = 72171
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13357 AND type_rel = 2
0.0145	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13357 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0146	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 (36584,1141779) ORDER BY n.cover_points DESC, update_date DESC
0.0150	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 = '13357' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0152	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 = '13357' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150	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 = 72171 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 72233 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151	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=13357 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0151	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 (72233,72171,71933,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.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 72233 AND teamId = 13357
0.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 72171 AND teamId = 13357
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 71933 AND teamId = 13357
0.0155	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13357
0.0161	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 = 72233 WHERE rp.league_id = 72233 AND rp.teamId = 13357 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.0159	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 = 72233 WHERE rp.league_id = 72233 AND rp.teamId = 13357 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159	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 = 72233 WHERE rp.league_id = 72233 AND rp.teamId = 13357 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149	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 = 13357 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0292	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 = 72233 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.0292	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 = 67920 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.0306	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.0158	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.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* `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.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* `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 = 44126 AND t.round = 34 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 = 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 = 43272 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* `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.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* `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.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* `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.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* `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 = 23686 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157	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.0157	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.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* `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 = 8848 AND t.round = 34 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 = 8845 AND t.round = 34 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* `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 = 25055 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* `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 = 28089 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Termalica Nieciecza

Termalica Nieciecza

Selecciona un equipo

Competiciones que juega

Segunda Polonia

RIVALES EN Copa Polonia

RIVALES EN Segunda Polonia