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

Lech Poznań II

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Pogon	30	47	38	52
2	Kalisz	30	42	28	48
3	Kotwica	30	54	42	47
4	Radunia	30	42	36	46
5	Hutnik	30	43	39	45
6	Chojniczanka	30	38	35	45
7	LKS Lodz II	29	43	39	43
8	Zagłębie	30	44	41	42
9	Stal Stalowa	30	34	35	42
10	Polonia	30	43	44	41
11	Olimpia	30	33	40	38
12	Lech Poznań	29	33	41	38
13	Wisla Pulawy	30	43	44	36
14	SKRA	30	33	34	36
15	Jastrzębie	30	34	41	36
16	Olimpia	29	30	36	33
17	Stomil	29	25	34	30
18	Sandecja	30	29	43	28

TEMPORADA 2022/2023

TERCERA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Polonia	35	60	38	68
2	Znicz	34	49	37	59
3	Kotwica	34	45	33	59
4	Stomil	34	51	32	57
5	Wisla Pulawy	34	56	38	56
6	Motor Lublin	34	52	37	55
7	Kalisz	34	63	45	54
8	Pogon	34	41	42	48
9	Olimpia	34	40	36	47
10	Jastrzębie	34	41	45	47
11	Lech Poznań	34	45	60	42
12	Hutnik	34	41	48	40
13	Radunia	34	47	57	39
14	Zagłębie	34	44	68	38
15	Gornik	34	46	52	37
16	Siarka	34	37	57	33
17	Garbarnia	34	52	65	32
18	Śląsk	34	38	57	31

TEMPORADA 2021/2022

TERCERA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Stal Rzeszow	34	75	35	77
2	Chojniczanka	34	72	31	73
3	Ruch	34	48	27	63
4	Wigry	34	58	38	60
5	Motor Lublin	34	54	31	59
6	Radunia	34	60	51	53
7	Lech Poznań	34	41	45	52
8	Garbarnia	34	51	43	48
9	Olimpia	34	33	32	46
10	Pogon	34	47	55	46
11	Wisla Pulawy	34	56	54	44
12	Śląsk	34	51	53	43
13	Kalisz	34	43	48	42
14	Znicz	34	38	45	39
15	Hutnik	34	38	55	35
16	Pogon Grod.	34	34	54	31
17	Sokół	34	32	77	19
18	Bełchatów	34	17	74	18

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

CUARTA POLONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lech Poznań	34	86	33	75
2	Radunia	34	75	37	69
3	Kalisz	34	70	37	69
4	Kotwica	34	70	41	68
5	Mieszko	34	74	53	61
6	Polonia	34	59	44	60
7	Świt	34	50	33	58
8	Bałtyk	34	59	50	57
9	Sokół	34	48	50	53
10	Starogard	34	56	37	51
11	Pogoń	33	49	59	42
12	Górnik	34	46	56	41
13	Bałtyk	34	57	75	40
14	Jarota	34	37	50	38
15	Gwardia	34	35	71	33
16	Chemik	34	38	66	30
17	Wierzyca	34	34	81	14
18	Świecie	33	20	90	8

TEMPORADA 2017/2018

CUARTA POLONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Elana Torun	34	71	24	77
2	Świt	34	70	27	73
3	Bałtyk	34	74	36	69
4	Lech Poznań	34	69	34	66
5	Kalisz	34	52	33	63
6	Polonia	34	63	41	60
7	Sokół	34	52	32	59
8	Kotwica	34	48	37	57
9	Starogard	34	46	32	51
10	Pogoń	34	44	54	49
11	Jarota	34	45	50	42
12	Wierzyca	34	38	47	42
13	Świecie	34	52	72	35
14	Górnik	34	40	61	34
15	Centra	34	38	67	32
16	Przodkowo	34	38	75	25
17	Unia Solec.	34	33	80	19
18	Energetyk	34	9	80	11

TEMPORADA 2016/2017

CUARTA POLONIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Gwardia	34	55	32	66
2	Lech Poznań	34	71	38	65
3	Bałtyk	34	55	34	64
4	Jarota	34	57	47	59
5	Elana Torun	34	70	42	58
6	Przodkowo	34	62	40	57
7	Sokół	34	60	47	55
8	Świt	34	55	42	54
9	Kalisz	34	44	44	54
10	Świecie	34	66	53	49
11	Polonia	34	44	44	47
12	Chwaszczyno	34	56	63	46
13	Pogoń	34	46	50	44
14	Górnik	34	44	51	40
15	Chemik	34	39	59	36
16	Pogoń	34	36	71	30
17	Vineta Wolin	34	37	67	22
18	Leśnik	34	22	95	10

TEMPORADA 2015/2016

CUARTA POLONIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Warta Poznan	30	57	24	62
2	Pelikan	30	60	28	62
3	Lech Poznań	30	69	23	60
4	Sokół	30	63	30	53
5	Jarota	30	47	27	51
6	Polonia	30	45	28	51
7	Świecie	30	37	37	49
8	Kalisz	30	41	41	45
9	Elana Torun	30	51	41	44
10	Unia	30	39	55	38
11	Start	30	40	45	35
12	Centra	30	39	67	31
13	Ostrovia	30	36	48	29
14	Nielba	30	32	68	23
15	Sparta	30	26	55	22
16	Kujawianka	30	26	91	12

TEMPORADA 2014/2015

CUARTA POLONIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Warta Poznan	34	70	33	76
2	Sokół	34	69	27	68
3	Lech Poznań	34	73	34	60
4	Polonia	34	67	46	59
5	Start	34	47	29	56
6	Nielba	34	54	42	56
7	Centra	34	53	35	55
8	Jarota	34	46	38	54
9	Ostrovia	34	56	49	54
10	Świecie	34	57	34	52
11	Sparta	34	49	45	52
12	Unia	34	64	47	46
13	Victoria	34	44	62	42
14	Pogoń	34	50	62	39
15	Unia Solec.	34	39	66	31
16	Tarnovia	34	46	82	27
17	Chełminiank	34	39	91	21
18	Włocłavia	34	17	118	8

TEMPORADA 2013/2014

CUARTA POLONIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sokół	34	75	33	73
2	Start	34	81	42	64
3	Unia Solec.	34	58	30	61
4	Świecie	34	60	42	61
5	Lech Poznań	34	70	51	60
6	Polonia	34	60	39	56
7	Włocłavia	34	51	42	55
8	Nielba	34	58	41	54
9	Centra	34	53	51	51
10	Unia	34	58	44	50
11	Pogoń	34	57	57	49
12	Polonia	34	48	45	48
13	Elana Torun	34	42	48	47
14	Grom	34	51	64	43
15	Cuiavia	34	39	88	29
16	Dopiewo	34	39	68	27
17	Notecianka	34	32	94	22
18	Fogo Luboń	34	28	81	20

Competiciones que juega

Tercera Polonia

Pos	Equipos		Pts
1		Pogon Siedlce	52
2		Kalisz	48
3		Kotwica Kołobrzeg	47
4		Radunia Stężyca	46
5		Hutnik Krakow	45
6		Chojniczanka Chojnice	45
7		LKS Lodz II	43
8		Zagłębie Lubin II	42
9		Stal Stalowa Wola	42
10		TS Polonia Bytom	41
11		Olimpia Elblag	38
12		Lech Poznań II	38
13		Wisla Pulawy	36
14		SKRA Częstochowa	36
15		Jastrzębie	36
16		Olimpia Grudziadz	33
17		Stomil Olsztyn	30
18		Sandecja Nowy Sacz	28

	Ascenso : Pogon Siedlce, Kalisz
	Playoff Ascenso : Kotwica Kołobrzeg, Radunia Stężyca, Hutnik Krakow, Chojniczanka Chojnice
	Descenso : Jastrzębie, Olimpia Grudziadz, Stomil Olsztyn, Sandecja Nowy Sacz

RIVALES EN Copa Polonia

RIVALES EN Tercera Polonia

USO DE MEMORIA

6,706,768 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.4691
Total Execution Time	0.4703

CADENA URL

/historico/Lech-Poznan-Ii

GET DATOS

$_GET['/historico/Lech-Poznan-Ii']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0123	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 = 'Lech-Poznan-Ii' 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.0108	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=60048 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0109	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=60048 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111	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=60048 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111	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=60048 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0109	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60048 AND type_rel = 2
0.0136	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 = '60048' ORDER BY l.year DESC,cat.coefficient DESC
0.0121	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 = '60048' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0116	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 = '60048' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0109	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 = 72234 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0113	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=60048 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0107	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 (72234,72171,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.0109	SELECT count(id) as num_players from rel_players WHERE league_id = 72234 AND teamId = 60048
0.0112	SELECT count(id) as num_players from rel_players WHERE league_id = 72171 AND teamId = 60048
0.0109	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 60048
0.0109	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 = '60048' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60048' and rp.type = 4
0.0107	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 = '60048' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0120	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 = 72234 WHERE rp.league_id = 72234 AND rp.teamId = 60048 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.0123	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 = 72234 WHERE rp.league_id = 72234 AND rp.teamId = 60048 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0122	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 = 72234 WHERE rp.league_id = 72234 AND rp.teamId = 60048 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0108	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 = 60048 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0215	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 = 68006 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.0113	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 = 63257 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.0111	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.0111	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.0111	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 = 44317 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 38927 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 33763 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 15913 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 9174 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 28010 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Lech Poznań II

Lech Poznań II

Selecciona un equipo

Competiciones que juega

Tercera Polonia

RIVALES EN Copa Polonia

RIVALES EN Tercera Polonia