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

Baník Ostrava II

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

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Slovácko	10	23	6	22
2	Vyškov	9	19	9	20
3	Frýdek-Mís	10	23	17	19
4	Odra	10	17	15	19
5	FC Zlínsko	10	22	20	18
6	Hlučín	10	13	10	17
7	Kromeriz	10	14	12	17
8	Uničov	10	31	17	16
9	Baník	10	15	14	15
10	Uhersky Brod	10	15	17	14
11	Velké	10	16	22	13
12	Slovan	10	12	13	12
13	Vrchovina	10	16	24	11
14	Sigma	9	12	14	9
15	Zlín II	10	12	17	9
16	Znojmo	10	13	23	7
17	Dolní	10	11	23	7
18	Vysocina	10	11	22	3

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 2012/2013

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Třinec	30	80	27	68
2	Frýdek-Mís	30	60	27	64
3	Prostějov	30	74	50	57
4	Sigma	30	53	34	46
5	Břeclav	30	49	42	43
6	Hlučín	30	42	35	42
7	Slovácko	30	59	57	42
8	Uničov	30	53	57	42
9	Zábřeh	30	43	45	39
10	Baník	30	41	48	39
11	Zlín II	30	38	50	38
12	Slavia	30	43	50	36
13	Hanácká	30	39	66	32
14	Žďár	30	31	65	31
15	Spartak	30	36	56	28
16	Slovan	30	33	65	26

TEMPORADA 2011/2012

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	HFK Olomouc	30	63	21	64
2	Frýdek-Mís	30	64	27	63
3	Břeclav	30	43	30	52
4	Sigma	30	48	40	51
5	Uničov	30	44	37	48
6	Zábřeh	30	48	47	44
7	Slovácko	30	53	53	41
8	Hlučín	30	48	49	38
9	Zbrojovka	30	38	46	38
10	Zlín II	30	50	48	37
11	Spartak	30	45	56	37
12	Vysocina	30	46	48	36
13	Baník	30	33	46	35
14	Slovan	30	39	59	32
15	Hanácká	30	41	66	29
16	SK Líšeň	30	34	64	21

TEMPORADA 2010/2011

4. LIGA CHECA GRUPO 5
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2009/2010

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Znojmo	48	88	41	101
2	HFK Olomouc	47	90	54	84
3	Sigma	48	78	54	84
4	Frýdek-Mís	47	71	54	72
5	Břeclav	46	55	49	72
6	Zábřeh	47	52	51	69
7	Uničov	47	78	54	68
8	Slavičín	48	45	57	68
9	Hanácká	47	50	59	65
10	Zbrojovka	46	51	49	60
11	Vysocina	47	64	63	55
12	SK Líšeň	46	41	60	53
13	Baník	47	49	76	46
14	Mutenice	46	30	76	44
15	Bystrc	47	31	76	34

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 5
Equipo		PJ	GF	GC	Puntos
1	Baník	30	70	19	69
2	Kravaře	30	45	25	51
3	Slavičín	30	64	33	49
4	Jiskra	30	56	48	43
5	Beskyd	30	39	32	42
6	Hranice	30	49	48	40
7	Lázne	30	42	51	40
8	Slavia	30	29	32	39
9	Brumov	30	41	53	39
10	Bystrice	30	30	32	38
11	Napajedla	30	42	50	38
12	Havířov	30	33	44	37
13	Mesto	30	35	51	37
14	Velké	30	29	43	36
15	Bohuslavice	30	34	46	34
16	FC Vsetín	30	29	60	24

TEMPORADA 2006/2007

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Fulnek	30	64	30	64
2	Mutenice	30	50	32	57
3	Slovácko	30	47	32	51
4	Uničov	30	50	35	49
5	Frýdek-Mís	30	49	37	49
6	Zlín II	30	38	27	47
7	Břeclav	30	42	35	47
8	Karviná	30	47	40	42
9	Vysocina	30	38	38	40
10	Zbrojovka	30	43	45	39
11	Znojmo	30	39	49	38
12	Dolní	30	33	42	37
13	SK Lipová	30	27	46	35
14	Baník	30	31	34	34
15	Brumov	30	36	67	28
16	Hranice	30	28	73	16

TEMPORADA 2005/2006

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Jakubcovice	30	49	21	61
2	Bystrc	29	35	25	50
3	Dolní	30	47	41	48
4	SK Lipová	30	49	33	47
5	Třinec	30	44	34	47
6	Uničov	30	35	28	46
7	Znojmo	30	47	36	43
8	Baník	30	35	36	40
9	Břeclav	30	36	41	40
10	Zlín II	29	34	33	39
11	Slovácko	30	38	38	37
12	Vitkovice B	30	33	42	35
13	Vysocina	30	36	47	33
14	Hranice	30	23	33	29
15	Kohoutovice	30	19	38	27
16	Bystrice	30	21	55	23

TEMPORADA 2004/2005

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	HFK Olomouc	30	60	23	68
2	Hlučín	30	64	25	63
3	Uničov	30	67	39	53
4	Zlín II	29	47	34	53
5	Baník	30	38	27	48
6	Dolní	30	45	43	45
7	Vitkovice B	30	35	36	42
8	Bystrc	30	43	39	41
9	Slovácko	30	49	48	39
10	Znojmo	30	39	42	38
11	Bystrice	29	39	45	37
12	Hranice	30	36	41	35
13	Třinec	30	31	52	30
14	Kohoutovice	30	27	43	27
15	SK Lipová	30	28	54	23
16	Postorna	30	27	84	17

TEMPORADA 2003/2004

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hanácká	30	60	28	69
2	Uničov	30	48	28	54
3	Synot B	30	56	37	54
4	Baník	30	50	23	53
5	Bystrc	29	45	33	53
6	Třinec	30	41	30	47
7	Vitkovice B	29	35	42	41
8	Hranice	30	46	48	40
9	Dolní	30	41	45	35
10	Znojmo	30	47	54	34
11	Dolni	30	30	46	34
12	Zlín II	30	30	35	33
13	Bystrice	30	35	48	33
14	Postorna	30	36	41	32
15	Frýdek-Mís	30	28	45	29
16	Prostějov	30	30	75	25

TEMPORADA 2002/2003

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Drnovice	29	49	26	63
2	Zbrojovka	30	45	20	55
3	Baník	29	67	25	54
4	Frýdek-Mís	30	35	29	50
5	Hranice	30	38	25	47
6	Uničov	30	31	29	45
7	Znojmo	30	42	40	43
8	Hanácká	30	35	34	42
9	Dolní	30	44	39	41
10	Synot B	30	36	40	40
11	Postorna	30	30	54	37
12	Bystrice	29	49	52	35
13	Třinec	30	44	59	34
14	Zlín II	30	27	46	33
15	Kyjov 1919	30	28	49	23
16	Detmarovice	29	19	52	20

TEMPORADA 2001/2002

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kunovice	30	54	23	59
2	Dolni	30	57	27	59
3	Hanácká	30	41	34	49
4	Baník	30	50	35	48
5	Bystrice	29	45	38	48
6	Uničov	30	35	35	44
7	Postorna	30	42	30	43
8	Zbrojovka	30	34	32	43
9	Kyjov 1919	30	33	34	39
10	Dolní	30	38	44	36
11	Synot B	29	35	37	34
12	FC Vratimov	30	34	51	34
13	Třinec	30	25	44	34
14	Frýdek-Mís	30	39	51	30
15	Zábřeh	30	27	55	30
16	Karviná	30	28	47	28

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

USO DE MEMORIA

7,068,192 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1103
Total Execution Time	0.1116

CADENA URL

/historico/Benik-Ostrava-Ii

GET DATOS

$_GET['/historico/Benik-Ostrava-Ii']

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0027	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 = 'Benik-Ostrava-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.0018	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=86743 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=86743 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=86743 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=86743 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1524 AND type_rel = 3
0.0023	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 = '86743' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021	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 = '86743' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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=86743 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 72398 AND teamId = 86743
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 86743
0.0038	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 = 86743 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.0033	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 = 86743 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 86743 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022	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 = 86743 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0024	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.0022	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.0021	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 = 57119 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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.0022	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 = 24662 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 24657 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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 = 25113 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 24647 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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.0022	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 = 27580 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables2007` 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 = 24511 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables2006` 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 = 24502 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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* `tables2005` 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 = 24497 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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* `tables2003` 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 = 24480 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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* `tables2002` 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 = 24466 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Baník Ostrava II

Baník Ostrava II

Selecciona un equipo

Competiciones que juega

3. Liga Checa Grupo 1

RIVALES EN 3. Liga Checa