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

Resultados de Fútbol

Stargard Szczeciński

Temporada 2023/2024

TEMPORADA 2023/2024

CUARTA POLONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Świt	27	54	12	64
2	Elana Torun	27	41	17	54
3	Unia	28	51	39	50
4	Stargard	28	65	49	49
5	Zawisza	28	59	32	48
6	Pogoń	28	59	51	44
7	Polonia	28	47	45	44
8	Vineta Wolin	27	33	41	43
9	Nowe	28	45	44	40
10	Cartusia	27	51	36	39
11	Notec	27	56	50	38
12	Gedania	28	45	47	38
13	Sokół	27	42	49	33
14	Swinoujscie	27	34	51	32
15	Stolem	27	30	46	29
16	Unia Solec.	27	32	62	21
17	KTSK Luzino	28	37	67	20
18	Starogard	27	33	76	13

TEMPORADA 2022/2023

CUARTA POLONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Olimpia	34	73	18	76
2	Pogoń	34	69	25	69
3	Polonia	34	75	54	64
4	Zawisza	34	69	45	62
5	Gedania	34	63	59	61
6	Starogard	34	44	35	59
7	Świt	34	61	41	55
8	Nowe	34	51	46	54
9	Sokół	34	53	48	47
10	Unia	34	37	42	44
11	Cartusia	34	37	40	43
12	Stargard	34	46	45	42
13	Stolem	34	33	52	36
14	Vineta Wolin	34	47	66	35
15	Unia Solec.	34	40	59	35
16	Jarota	34	41	69	33
17	Bałtyk	34	43	70	28
18	Unia	34	17	85	10

TEMPORADA 2021/2022

CUARTA POLONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kotwica	34	75	25	78
2	Olimpia	34	77	24	77
3	Unia	34	62	47	60
4	Pogoń	34	60	36	58
5	Nowe	34	54	42	58
6	Świt	34	57	37	56
7	Sokół	34	53	40	56
8	Zawisza	34	57	51	50
9	Stargard	34	48	54	45
10	Polonia	34	40	63	43
11	Starogard	34	44	51	42
12	Stolem	34	43	66	41
13	Jarota	34	40	47	36
14	Przodkowo	34	40	51	36
15	Bałtyk	34	44	57	36
16	Bałtyk	34	40	58	35
17	Kluczevia	34	28	65	26
18	Elana Torun	34	36	84	21

TEMPORADA 2020/2021

TERCERA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Gornik	36	70	29	76
2	Katowice	36	67	41	70
3	Chojniczanka	36	63	34	67
4	Wigry	36	51	35	64
5	Kalisz	36	51	40	57
6	SKRA	36	51	42	52
7	Śląsk	36	61	57	52
8	Garbarnia	36	49	50	52
9	Stal Rzeszow	36	58	60	50
10	Motor Lublin	36	48	44	50
11	Sokół	36	50	56	46
12	Hutnik	36	47	61	45
13	Pogon	36	61	62	42
14	Lech Poznań	36	47	58	40
15	Znicz	36	37	55	38
16	Olimpia	36	39	52	37
17	Stargard	36	36	66	36
18	Olimpia	36	42	67	36
19	Bytovia	36	46	65	34

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

TERCERA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Jastrzębie	34	54	30	65
2	LKS Lódz	34	47	23	65
3	Warta Poznan	34	43	24	62
4	Garbarnia	34	48	35	57
5	Radomiak	34	52	37	55
6	Olimpia	34	43	42	50
7	Siarka	34	49	49	47
8	Bełchatów	34	50	43	46
9	Gryf	34	42	46	46
10	Rozwoj	34	36	44	44
11	Energetyk	34	49	57	44
12	Stal Stalowa	34	44	39	44
13	Znicz	34	44	48	42
14	Stargard	34	35	39	41
15	Kluczbork	34	37	51	39
16	Wisla Pulawy	34	34	44	36
17	Gwardia	34	36	72	28
18	Legionovia	34	36	56	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

TERCERA POLONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Chrobry	34	55	17	68
2	Bytovia	34	55	30	62
3	Zagłębie	34	41	28	59
4	Stargard	34	58	40	55
5	Kluczbork	34	57	46	52
6	Górnik	34	40	36	52
7	Rozwoj	34	40	36	52
8	Polonia	34	45	34	51
9	Warta Poznan	34	52	50	51
10	Raków	34	44	40	48
11	Gryf	34	52	49	45
12	Odra Opole	34	36	40	43
13	Ruch	34	50	52	41
14	Ostrovia	34	32	43	38
15	Calisia	34	39	57	36
16	Zielona	34	37	51	34
17	Jarota	34	31	56	32
18	Gornik	34	15	74	17

TEMPORADA 2012/2013

CUARTA POLONIA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Stargard	30	57	28	61
2	Kotwica	30	39	26	54
3	Lechia	30	43	32	46
4	Drawa	30	44	42	46
5	Cartusia	30	28	29	45
6	Gwardia	30	57	40	43
7	Pogoń	30	41	41	43
8	Arka Gdynia	30	40	41	42
9	Bałtyk	30	30	28	41
10	Koral	30	33	37	39
11	Chemik	30	42	38	38
12	Pogoń	30	43	48	38
13	Energetyk	30	34	42	36
14	Polonia	30	46	46	34
15	Dąb Dębno	30	44	57	34
16	Gryf Słupsk	30	22	68	18

TEMPORADA 2011/2012

CUARTA POLONIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Gryf	30	63	18	64
2	Orkan Rumia	30	52	25	64
3	Kotwica	30	50	23	63
4	Gwardia	30	35	33	46
5	Cartusia	30	44	35	45
6	Pogoń	30	44	38	44
7	Stargard	30	37	39	40
8	Chemik	30	32	35	39
9	Lechia	30	35	36	38
10	Gryf Słupsk	30	35	35	37
11	Dąb Dębno	30	33	50	34
12	Koral	30	31	50	34
13	Drawa	30	36	45	33
14	Bałtyk	30	28	35	30
15	Kaszubia	30	27	41	30
16	Gryf Tczew	30	24	68	25

TEMPORADA 2010/2011

CUARTA POLONIA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Bytovia	30	49	20	69
2	Stargard	30	51	28	57
3	Kotwica	30	47	31	48
4	Dąb Dębno	30	29	30	47
5	Orkan Rumia	30	50	37	45
6	Pogoń	30	34	33	45
7	Gryf	30	42	32	43
8	Lechia	30	37	31	43
9	Cartusia	30	35	34	43
10	Kaszubia	30	38	33	41
11	Gwardia	30	45	48	41
12	Chemik	30	35	46	37
13	Gryf Słupsk	30	43	42	34
14	Energetyk	30	25	41	28
15	Rega	30	28	62	20
16	Orlęta Reda	30	18	58	15

TEMPORADA 2009/2010

CUARTA POLONIA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Chojniczanka	30	70	42	63
2	Rega	30	50	27	58
3	Orkan Rumia	30	67	39	57
4	Gryf Słupsk	30	58	42	50
5	Kaszubia	30	56	40	50
6	Cartusia	30	45	39	45
7	Stargard	30	56	52	43
8	Dąb Dębno	30	39	42	41
9	Gryf	30	42	48	40
10	Kotwica	30	53	51	37
11	Chemik	30	44	51	37
12	Energetyk	30	41	51	37
13	Piast	30	41	42	35
14	Bytovia	30	43	45	29
15	Astra	30	38	77	23
16	Darzbór	30	27	82	16

TEMPORADA 2008/2009

CUARTA POLONIA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Bałtyk	30	58	22	63
2	Stargard	30	67	26	58
3	Gryf Słupsk	30	54	29	57
4	Bytovia	30	39	19	51
5	Kaszubia	30	49	34	51
6	Rega	30	46	39	51
7	Dąb Dębno	30	43	36	50
8	Orkan Rumia	30	47	37	48
9	Cartusia	29	58	40	46
10	Darzbór	30	39	40	42
11	Zatoka Puck	30	39	39	41
12	Astra	30	44	53	41
13	Slawa Slawno	30	37	60	31
14	Rodlo	30	24	50	25
15	Orlęta Reda	29	10	66	10
16	Olimpia	30	14	78	6

Competiciones que juega

Grupo 2

Cuarta Polonia Grupo 2

Pos	Equipos		Pts
1		Świt Skolwin	64
2		TKP Elana Torun	54
3		Unia Swarzędz	50
4		Stargard Szczeciński	49
5		Zawisza Bydgoszcz	48
6		Pogoń Szczecin II	44
7		Polonia Środa	44
8		Vineta Wolin	43
9		Nowe Skalmierzyce	40
10		Cartusia Kartuzy	39
11		Notec Czarnków	38
12		Gedania Gdansk	38
13		Sokół Kleczew	33
14		Swinoujscie	32
15		Stolem Gniewino	29
16		Unia Solec Kujawski	21
17		KTSK Luzino	20
18		Starogard Gdański	13

	Ascenso : Świt Skolwin
	Descenso : Unia Solec Kujawski, KTSK Luzino, Starogard Gdański

RIVALES EN Cuarta Polonia

USO DE MEMORIA

7,134,648 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.7277
Total Execution Time	0.7290

CADENA URL

/historico/Stargard-Szczeci-Ski

GET DATOS

$_GET['/historico/Stargard-Szczeci-Ski']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0194	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 = 'Stargard-Szczeci-Ski' 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.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=17741 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=17741 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0296	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 = 72657
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17741 AND type_rel = 2
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1520 AND type_rel = 3
0.0150	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1520 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0152	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 (1162591,992027,681028,133540,54950) 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 = '17741' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0161	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 = '17741' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0156	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 = 72657 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0164	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=17741 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0148	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 (72657) 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.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 72657 AND teamId = 17741
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 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 = 72657 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146	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 = '17741' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17741' 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 = '17741' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0156	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 = 72657 WHERE rp.league_id = 72657 AND rp.teamId = 17741 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.0157	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 = 72657 WHERE rp.league_id = 72657 AND rp.teamId = 17741 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 events2024 e ON e.player_id = p.id AND e.league_id = 72657 WHERE rp.league_id = 72657 AND rp.teamId = 17741 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 = 17741 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72657 AND t.round = 28 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* `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 = 68531 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.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* `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 = 63688 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* `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 = 58339 AND t.round = 38 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* `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.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* `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.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 = 38759 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* `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.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 = 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.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* `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.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 = 3651 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163	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 = 28053 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166	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 = 28058 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165	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 = 28072 AND t.round = 30 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* `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 = 28073 AND t.round = 30 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 = 28099 AND t.round = 30 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

Stargard Szczeciński

Stargard Szczeciński

Selecciona un equipo

Competiciones que juega

Cuarta Polonia Grupo 2

RIVALES EN Cuarta Polonia