Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

Puszcza Niepolomice

Entrenador: Tomasz Tulacz

Temporada 2023/2024

TEMPORADA 2023/2024

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

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

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

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

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

TERCERA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Odra Opole	34	69	34	71
2	Raków	34	64	29	71
3	Puszcza	34	42	24	62
4	Radomiak	34	42	34	56
5	Olimpia	34	59	49	50
6	Siarka	34	51	50	47
7	Stargard	34	45	39	45
8	Legionovia	34	51	49	45
9	Bełchatów	34	37	39	42
10	Stal Stalowa	34	41	49	42
11	Energetyk	34	39	47	41
12	Warta Poznan	34	40	53	41
13	Rozwoj	34	32	39	39
14	Gryf	34	45	57	38
15	Polonia	34	40	45	35
16	Kotwica	34	39	52	35
17	Olimpia	34	37	55	33
18	Polonia	34	25	54	26

TEMPORADA 2015/2016

TERCERA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Stal Mielec	34	56	27	69
2	Znicz	34	53	33	64
3	GKS Tychy	34	46	27	59
4	Wisla Pulawy	34	47	30	57
5	Raków	34	59	48	53
6	Siarka	34	47	43	53
7	Radomiak	34	44	34	50
8	Puszcza	34	40	29	50
9	Kotwica	34	33	33	48
10	Legionovia	34	41	35	47
11	Polonia	34	42	44	44
12	Stargard	34	37	36	42
13	Energetyk	34	37	47	38
14	Olimpia	34	37	54	37
15	Stal Stalowa	34	36	48	37
16	Nadwiślan	34	38	61	34
17	Gryf	34	35	51	33
18	Brzesko	34	23	71	25

TEMPORADA 2014/2015

TERCERA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Kluczbork	34	44	30	59
2	Zagłębie	34	53	37	58
3	Rozwoj	34	54	40	57
4	Raków	34	43	34	57
5	Energetyk	34	52	37	56
6	Stargard	34	46	42	55
7	Stal Stalowa	34	54	41	54
8	Stal Mielec	34	49	42	52
9	Znicz	34	40	35	46
10	Nadwiślan	34	49	52	45
11	Legionovia	34	48	48	42
12	Siarka	34	41	51	41
13	Wisla Pulawy	34	45	54	39
14	Brzesko	34	32	43	39
15	Puszcza	34	37	43	36
16	Kotwica	34	45	51	35
17	Górnik	34	30	57	30
18	Limanovia	34	30	55	27

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

TERCERA POLONIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Wisła	34	59	27	70
2	Puszcza	34	61	35	70
3	Pelikan	34	47	25	65
4	Resovia	34	40	27	60
5	Wisla Pulawy	34	42	32	53
6	Znicz	34	37	34	50
7	Pogon	34	44	38	48
8	Olimpia	34	23	18	48
9	Radomiak	34	43	42	47
10	Stal Stalowa	34	28	33	45
11	Stal Rzeszow	34	34	36	39
12	Wigry	34	36	39	39
13	Unia Tarnów	34	38	51	38
14	Motor Lublin	34	41	54	35
15	Garbarnia	34	39	65	35
16	Swit Nowy D.	34	34	49	33
17	Concordia	34	25	47	31
18	Siarka	34	36	55	29

TEMPORADA 2011/2012

TERCERA POLONIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Brzesko	26	43	8	64
2	Stomil	27	41	29	52
3	Puszcza	26	36	23	46
4	Znicz	26	28	16	43
5	Resovia	26	33	19	41
6	Motor Lublin	27	36	34	41
7	Stal Stalowa	27	31	32	38
8	Swit Nowy D.	28	30	30	36
9	Wigry	27	25	26	34
10	Pogon	26	30	38	30
11	Wisla Pulawy	26	25	30	28
12	Pelikan	26	28	38	28
13	Stal Rzeszow	27	24	33	27
14	Jeziorak	27	24	36	25
15	Garbarnia	26	27	41	25
16	KSZO	26	16	44	24
17	Sokol	0	0	0	0

TEMPORADA 2010/2011

TERCERA POLONIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Olimpia	34	39	25	61
2	Wisła	34	61	39	60
3	Swit Nowy D.	34	42	26	60
4	Brzesko	34	42	27	59
5	Stomil	34	43	34	53
6	Znicz	34	46	36	52
7	Stal Stalowa	34	32	25	50
8	Stal Rzeszow	34	55	46	48
9	Resovia	34	31	24	46
10	Jeziorak	34	39	39	46
11	Wigry	34	38	38	41
12	Sokol	34	33	38	41
13	Pelikan	34	35	34	39
14	Nadarzyn	34	29	39	39
15	Ruch Wysokie	34	34	55	38
16	Motor Lublin	34	25	51	29
17	Puszcza	34	31	47	26
18	Start Otwock	34	37	69	24

TEMPORADA 2009/2010

CUARTA POLONIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Puszcza	34	65	27	70
2	Garbarnia	34	55	34	64
3	Unia Tarnów	34	53	38	63
4	Hutnik Nowa	34	77	46	58
5	Dalin	34	68	47	58
6	Orlicz	34	52	38	56
7	Juventa	34	50	44	56
8	Czarni	34	52	39	53
9	Wierna	34	34	26	52
10	Kmita	34	54	41	51
11	Nida	34	44	46	49
12	Górnik	34	63	60	45
13	Beskid	34	59	66	45
14	Naprzód	34	52	57	43
15	Alwernia	34	28	48	34
16	Lubrzanka	34	28	87	25
17	Glinik	34	25	67	21
18	Hetman	34	28	76	20

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

Liga Polaca

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

	Campeón : Jagiellonia Bialystok
	: Śląsk Wrocław, Lech Poznań
	Descenso : Korona Kielce, Ruch Chorzów, LKS Lódz

RIVALES EN Copa Polonia

RIVALES EN Liga Polaca

USO DE MEMORIA

7,490,784 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7464
Total Execution Time	0.7476

CADENA URL

/historico/Puszcza-Niepolomice

GET DATOS

$_GET['/historico/Puszcza-Niepolomice']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0157	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 = 'Puszcza-Niepolomice' 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=13294 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=13294 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=13294 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=13294 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13294 AND type_rel = 2
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=128 AND type_rel = 3
0.0151	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 128 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148	SELECT /53 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 (1308917,1277727,1235369,1231836,1227810) ORDER BY n.cover_points DESC, update_date DESC
0.0151	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 = '13294' ORDER BY l.year DESC,cat.coefficient DESC
0.0149	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 = '13294' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0150	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 = '13294' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=13294 AND l.year in (2023,2024,2025) 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 (72171,72168,71933,71432,67920) 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.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 72168 AND teamId = 13294
0.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 67920 AND teamId = 13294
0.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 72171 AND teamId = 13294
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 71933 AND teamId = 13294
0.0155	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13294
0.0147	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 = '13294' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13294' and rp.type = 4
0.0146	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 = '13294' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0165	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 = 13294 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.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 = 72168 WHERE rp.league_id = 72168 AND rp.teamId = 13294 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155	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 = 13294 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150	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 = 13294 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0297	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 = 31 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* `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.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* `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.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* `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.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* `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.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 = 33388 AND t.round = 34 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 = 15696 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* `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 = 4480 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* `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.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* `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 = 25077 AND t.round = 34 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* `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 = 25071 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0168	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 = 25061 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0175	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 = 28078 AND t.round = 34 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 = 28089 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Puszcza Niepolomice

Puszcza Niepolomice

Selecciona un equipo

Competiciones que juega

Liga Polaca

RIVALES EN Copa Polonia

RIVALES EN Liga Polaca