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

Blansko

Temporada 2023/2024

TEMPORADA 2023/2024

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Baník	26	43	17	55
2	FC Zlínsko	26	34	29	49
3	Znojmo	26	44	29	46
4	Uničov	26	48	28	45
5	Třinec	26	48	32	43
6	Karviná II	26	49	37	43
7	Hlučín	26	44	32	43
8	Hodonín-Ša	26	32	36	37
9	Frýdek-Mís	26	35	29	36
10	Start Brno	26	37	44	35
11	Slovan	26	34	32	33
12	Blansko	26	37	41	33
13	Zlín II	26	30	32	29
14	Hranice	26	29	51	26
15	Uhersky Brod	26	28	51	26
16	Slovácko	26	25	32	24
17	Frýdlant	26	32	55	22
18	Tatran Brno	26	20	42	19

TEMPORADA 2022/2023

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Hanácká	34	87	36	77
2	Hlučín	34	74	35	75
3	Slovan	34	59	30	66
4	Baník	34	89	47	65
5	Uničov	34	76	37	65
6	Hodonín-Ša	34	56	47	55
7	Slovácko	34	61	46	49
8	Zlín II	34	50	49	45
9	Blansko	34	57	59	44
10	Frýdek-Mís	34	46	48	43
11	FC Zlínsko	34	58	68	43
12	Hranice	34	45	59	41
13	Znojmo	34	43	67	41
14	Uhersky Brod	34	40	61	34
15	Frýdlant	34	43	74	34
16	Vrchovina	34	34	57	31
17	Velké	34	53	88	30
18	Vitkovice	34	28	91	15

TEMPORADA 2021/2022

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sigma	32	86	24	80
2	Hanácká	32	71	34	70
3	Hlučín	32	75	31	63
4	Baník	32	71	41	63
5	Slovan	32	48	36	57
6	Slovácko	32	67	49	50
7	Uničov	32	56	52	49
8	Frýdek-Mís	32	53	57	48
9	Velké	32	52	52	45
10	Znojmo	32	62	74	38
11	Blansko	32	51	66	38
12	Uhersky Brod	32	40	49	35
13	FC Vratimov	32	42	74	33
14	FC Zlínsko	32	44	70	30
15	Zlín II	32	38	55	29
16	Vrchovina	32	28	62	28
17	Vysocina	32	29	87	13
18	Dolní	0	0	0	0

TEMPORADA 2020/2021

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Hradec	26	51	22	58
2	SK Líšeň	26	43	24	50
3	Prostějov	26	40	35	43
4	Viktoria	26	42	38	42
5	Viagem	26	24	29	41
6	Vlašim	26	38	33	37
7	Vysocina	26	44	44	35
8	Dukla Praha	26	36	30	34
9	Třinec	26	32	33	33
10	Chrudim	26	33	36	31
11	Táborsko	26	25	28	31
12	Varnsdorf	26	20	27	30
13	Blansko	26	30	34	27
14	Slavoj	26	15	60	7

TEMPORADA 2019/2020

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Blansko	18	33	12	36
2	Odra	18	32	17	34
3	Frýdek-Mís	18	29	16	34
4	Uničov	18	32	24	33
5	Slovan	18	19	12	32
6	Baník	18	39	19	31
7	Hanácká	18	31	23	30
8	Sigma	18	36	22	29
9	Vrchovina	18	22	19	28
10	Vyškov	18	27	24	24
11	Velké	18	22	35	23
12	FC Zlínsko	18	27	37	22
13	Znojmo	18	17	32	20
14	Uhersky Brod	18	28	31	18
15	Hlučín	18	11	25	18
16	Slovácko	18	19	36	18
17	Zlín II	18	20	34	14
18	Dolní	18	18	44	6

TEMPORADA 2018/2019

4. LIGA CHECA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Blansko	28	95	20	78
2	Slovan	28	74	20	65
3	Stará	28	74	31	55
4	Sokol	28	69	33	54
5	Žďár	28	53	35	50
6	Sokol	28	62	31	48
7	Slavoj	28	51	48	41
8	Spartak	28	56	55	40
9	Bzenec	28	43	53	36
10	FC Strani	28	38	44	32
11	Ždírec	28	26	45	30
12	Břeclav	28	35	62	25
13	Humpolec	28	29	60	23
14	Havlíčkův	28	31	74	21
15	Nove Sady	28	25	77	21
16	Bystrc	28	20	93	10

TEMPORADA 2017/2018

4. LIGA CHECA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Vrchovina	29	60	30	63
2	Slovan	29	72	26	54
3	Žďár	27	59	31	52
4	Sokol	29	51	48	48
5	Šumperk	29	53	39	46
6	Stará	29	48	38	46
7	Bzenec	27	62	54	42
8	Slavoj	28	60	57	41
9	Ždírec	29	27	35	40
10	Břeclav	29	39	43	38
11	Blansko	29	31	38	33
12	Spartak	28	38	52	31
13	FC Strani	29	41	59	27
14	Tišnov	11	25	4	24
15	Havlíčkův	29	35	80	24
16	Třebíč	29	29	96	10

TEMPORADA 2016/2017

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Uničov	30	72	30	63
2	Sigma	30	55	26	55
3	Hlučín	30	44	40	51
4	Hanácká	30	54	46	47
5	Spartak	30	53	50	47
6	Odra	30	53	45	45
7	Velké	30	68	66	43
8	Slovácko	30	41	41	40
9	Vyškov	30	45	43	39
10	FC Zlínsko	30	43	65	37
11	Mohelnice	30	38	51	36
12	Zlín II	30	53	62	35
13	SK Líšeň	30	43	52	35
14	Třebíč	30	44	58	35
15	HFK Olomouc	30	31	52	35
16	Blansko	30	31	41	24

TEMPORADA 2015/2016

4. LIGA CHECA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Blansko	30	55	34	57
2	Hodonín-Ša	30	69	42	56
3	Kozlovice	30	52	35	51
4	Uhersky Brod	30	48	39	50
5	Sokol	30	50	41	48
6	Slovan	30	54	37	45
7	Stará	30	50	39	45
8	Slavoj	30	43	56	42
9	Šumperk	30	44	46	39
10	Přerov	30	39	45	37
11	Vrchovina	30	36	47	37
12	Pelhřimov	30	39	61	36
13	Žďár	30	34	39	34
14	Bystřice	30	49	59	34
15	Ždírec	30	36	54	28
16	Havlíčkův	30	34	58	27

TEMPORADA 2014/2015

4. LIGA CHECA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Velké	30	65	23	66
2	FC Zlínsko	30	59	40	52
3	Vrchovina	30	44	30	51
4	Havlíčkův	30	49	42	49
5	Stará	30	37	39	47
6	Hodonín-Ša	30	55	34	46
7	Bystřice	30	47	45	40
8	Slovan	30	45	39	39
9	Sokol	30	38	53	37
10	Slavoj	30	55	52	36
11	Pelhřimov	30	40	47	36
12	Žďár	30	37	45	36
13	Uhersky Brod	30	38	47	33
14	Blansko	30	34	52	33
15	Napajedla	30	46	72	27
16	Mutenice	30	34	63	27

TEMPORADA 2013/2014

4. LIGA CHECA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Vyškov	30	70	31	66
2	Slovan	30	65	34	65
3	Vrchovina	30	40	37	53
4	SK Líšeň	30	59	32	49
5	Blansko	30	53	50	42
6	Velké	30	43	48	41
7	Bystřice	30	40	48	39
8	Pelhřimov	30	60	57	38
9	Slavoj	30	51	57	38
10	Stará	30	43	58	36
11	Hodonín-Ša	30	37	41	35
12	Uhersky Brod	30	28	48	35
13	Napajedla	30	36	47	34
14	Sokol	30	46	53	33
15	Bystrc	30	48	60	31
16	Tatran Brno	30	37	55	29

TEMPORADA 2010/2011

4. LIGA CHECA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Slovan	30	62	35	53
2	FC Zlínsko	30	54	35	53
3	Pelhřimov	30	60	44	52
4	Vyškov	30	44	27	50
5	Hodonín-Ša	30	55	37	49
6	Třebíč	30	44	31	47
7	Žďár	30	61	48	46
8	Sokol	30	51	50	40
9	Bystrc	30	38	54	39
10	Velké	30	38	54	39
11	Vrchovina	30	26	30	38
12	Sparta Brno	30	33	45	34
13	Napajedla	30	43	50	32
14	Blansko	30	31	58	28
15	Uhersky Brod	30	28	55	28
16	Sokol Konice	30	34	49	26

TEMPORADA 2009/2010

4. LIGA CHECA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Šardice	28	58	18	61
2	Slovácko	28	56	27	51
3	Žďár	28	47	35	49
4	Velké	28	35	47	42
5	Třebíč	28	40	36	39
6	Sokol Konice	28	35	39	39
7	Uhersky Brod	28	41	36	38
8	Slovan	28	38	42	37
9	Napajedla	28	38	44	37
10	Pelhřimov	28	35	40	36
11	FC Zlínsko	28	37	32	35
12	Vyškov	28	28	34	32
13	Blansko	28	39	50	31
14	Rousínov	28	30	42	29
15	Boskovice	28	32	67	18

TEMPORADA 2008/2009

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Hlučín	30	49	31	60
2	Znojmo	30	54	30	59
3	Bystrc	30	45	37	49
4	Uničov	30	41	31	48
5	Hanácká	30	31	22	47
6	Frýdek-Mís	30	41	37	43
7	Břeclav	30	31	37	43
8	Baník	30	28	34	41
9	Zbrojovka	30	34	29	37
10	Sigma	30	46	47	37
11	Mutenice	30	37	37	36
12	Vysocina	30	30	48	36
13	Zábřeh	30	27	44	34
14	Zlín II	30	38	48	33
15	Blansko	30	39	49	30
16	Slovácko	30	27	37	30

TEMPORADA 2007/2008

4. LIGA CHECA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Blansko	30	64	34	62
2	Žďár	30	63	41	59
3	Spartak	30	59	35	54
4	SK Líšeň	30	53	35	49
5	Velké	30	48	49	47
6	Sokol	30	48	38	46
7	Sokol Konice	30	50	40	44
8	FC Zlínsko	30	57	48	41
9	Vyškov	30	38	33	39
10	Třebíč	30	42	41	38
11	Rousínov	30	40	48	38
12	Rájec-Jestr	30	40	44	35
13	Boskovice	30	44	61	34
14	CAFC	30	30	46	33
15	Havlíčkův	30	37	70	25
16	Hrusovany	30	35	85	22

Competiciones que juega

Grupo 1

3. Liga Checa Grupo 1

Pos	Equipos		Pts
1		Baník Ostrava II	55
2		FC Zlínsko	49
3		Znojmo	46
4		Uničov	45
5		Třinec	43
6		Karviná II	43
7		Hlučín	43
8		Hodonín-Šardice	37
9		Frýdek-Místek	36
10		Start Brno	35
11		Slovan Rosice	33
12		Blansko	33
13		Zlín II	29
14		Hranice	26
15		Uhersky Brod	26
16		Slovácko II	24
17		Frýdlant	22
18		Tatran Brno Bohunice	19

	Ascenso : Baník Ostrava II
	Descenso : Slovácko II, Frýdlant, Tatran Brno Bohunice

RIVALES EN 3. Liga Checa

RIVALES EN Copa Checa

USO DE MEMORIA

7,067,112 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6244
Total Execution Time	0.6255

CADENA URL

/historico/Blansko

GET DATOS

$_GET['/historico/Blansko']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0195	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 = 'Blansko' 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.0127	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=30932 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=30932 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=30932 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=30932 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30932 AND type_rel = 2
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1524 AND type_rel = 3
0.0129	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 = '30932' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130	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 = '30932' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 72398 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133	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=30932 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (72506,72398,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.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 72398 AND teamId = 30932
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 30932
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 30932
0.0130	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 = 72398 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128	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 = '30932' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '30932' and rp.type = 4
0.0131	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 = '30932' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0181	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 = 72398 WHERE rp.league_id = 72398 AND rp.teamId = 30932 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.0170	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 = 72398 WHERE rp.league_id = 72398 AND rp.teamId = 30932 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143	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 = 72398 WHERE rp.league_id = 72398 AND rp.teamId = 30932 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131	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 = 30932 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129	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 = 72398 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 68185 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.0131	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 = 63515 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.0134	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 = 58012 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 50313 AND t.round = 32 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140	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 = 44437 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	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 = 39718 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	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 = 33705 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	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 = 16002 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 9186 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 25087 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 25110 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	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 = 25131 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142	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 = 24632 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* `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 = 27577 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Blansko

Blansko

Selecciona un equipo

Competiciones que juega

3. Liga Checa Grupo 1

RIVALES EN 3. Liga Checa

RIVALES EN Copa Checa