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

Zbrojovka Brno

Entrenador: Lukas Kriz

Temporada 2023/2024

TEMPORADA 2023/2024

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Dukla Praha	25	39	26	47
2	Vyškov	25	42	29	46
3	Táborsko	25	36	22	42
4	Sigma	25	37	35	42
5	Chrudim	25	45	41	37
6	Sparta Praha	25	45	41	35
7	Vlašim	25	34	30	35
8	SK Líšeň	25	29	30	33
9	SFC Opava	25	27	29	33
10	Pribram	25	28	37	33
11	Zbrojovka	25	32	34	31
12	Vysocina	25	35	36	30
13	Viktoria	25	36	45	29
14	Varnsdorf	25	42	42	28
15	Prostějov	25	33	47	27
16	Hanácká	25	24	40	23

TEMPORADA 2022/2023

LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Baník	35	53	50	42
2	Teplice	35	45	67	42
3	Jablonec	35	49	63	40
4	Pardubice	35	38	63	37
5	Trinity	35	43	60	34
6	Zbrojovka	35	41	64	33

TEMPORADA 2021/2022

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Zbrojovka	30	61	29	69
2	Vlašim	30	61	39	53
3	SFC Opava	30	47	33	51
4	SK Líšeň	30	45	33	50
5	Sparta Praha	30	50	37	46
6	Varnsdorf	30	47	35	45
7	Vysocina	30	29	34	42
8	Táborsko	30	33	34	40
9	Dukla Praha	30	40	41	39
10	Chrudim	30	32	36	38
11	Prostějov	30	32	50	37
12	Vyškov	30	43	44	35
13	Pribram	30	38	51	35
14	Třinec	30	38	54	33
15	Viagem	30	26	49	28
16	Viktoria	30	29	52	18

TEMPORADA 2020/2021

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Slavia Praha	34	85	20	86
2	Sparta Praha	34	82	43	74
3	Jablonec	34	59	33	69
4	Slovácko	34	58	33	63
5	Viktoria	34	60	45	58
6	Slovan	34	44	32	52
7	Pardubice	34	41	42	52
8	Baník	34	48	38	49
9	Sigma	34	40	40	45
10	Bohemians	34	40	37	43
11	Mladá	34	49	54	39
12	Karviná	34	37	49	39
13	České	34	33	47	38
14	Trinity	34	30	50	32
15	Teplice	34	34	66	30
16	Zbrojovka	34	33	57	26
17	Pribram	34	26	65	25
18	SFC Opava	34	23	71	17

TEMPORADA 2019/2020

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Zbrojovka	30	75	29	67
2	Pardubice	29	54	19	67
3	Dukla Praha	30	62	40	59
4	Hradec	30	54	29	54
5	Vysocina	30	59	46	49
6	Viktoria	30	45	40	49
7	Viagem	30	46	47	41
8	SK Líšeň	30	49	47	36
9	Chrudim	30	44	61	36
10	Prostějov	30	33	42	35
11	Vlašim	29	30	42	34
12	Slavoj	30	40	55	33
13	Třinec	28	39	52	31
14	Baník	30	34	51	26
15	Varnsdorf	30	37	65	26
16	Vitkovice	30	35	71	17

TEMPORADA 2018/2019

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	České	30	60	24	72
2	Vysocina	30	50	33	58
3	Zbrojovka	30	63	31	57
4	Hradec	30	36	18	53
5	Viagem	30	44	39	49
6	Varnsdorf	30	33	26	48
7	Pardubice	30	45	34	44
8	Vitkovice	30	32	44	40
9	Třinec	30	36	42	36
10	Prostějov	30	28	37	36
11	Baník	30	28	40	33
12	Vlašim	30	30	38	32
13	Chrudim	30	39	56	29
14	Viktoria	30	33	59	27
15	Táborsko	30	37	53	25
16	Znojmo	30	40	60	25

TEMPORADA 2017/2018

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Viktoria	30	55	23	66
2	Slavia Praha	30	50	19	59
3	Jablonec	30	49	27	56
4	Sigma	30	41	22	55
5	Sparta Praha	30	43	25	53
6	Slovan	30	37	35	46
7	Bohemians	30	30	29	38
8	Mladá	30	31	43	34
9	Teplice	30	32	40	34
10	Trinity	30	31	48	33
11	Dukla Praha	30	32	55	32
12	Slovácko	30	23	32	31
13	Baník	30	36	43	31
14	Karviná	30	32	40	30
15	Vysocina	30	30	48	30
16	Zbrojovka	30	20	43	24

TEMPORADA 2016/2017

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Slavia Praha	30	65	22	69
2	Viktoria	30	47	21	67
3	Sparta Praha	30	47	26	57
4	Mladá	30	47	37	49
5	Teplice	30	38	25	48
6	Trinity	30	34	35	41
7	Dukla Praha	30	39	35	40
8	Jablonec	30	43	38	39
9	Slovan	30	31	28	39
10	Karviná	30	39	49	34
11	Slovácko	30	29	38	32
12	Zbrojovka	30	32	45	32
13	Bohemians	30	22	39	28
14	Vysocina	30	26	47	27
15	Hradec	30	29	51	27
16	Pribram	30	29	61	22

TEMPORADA 2015/2016

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Viktoria	30	57	25	71
2	Sparta Praha	30	61	24	64
3	Slovan	30	51	35	58
4	Mladá	30	63	37	57
5	Slavia Praha	30	48	26	52
6	Zbrojovka	30	37	38	47
7	Jablonec	30	46	39	41
8	Slovácko	30	37	51	40
9	Bohemians	30	35	37	37
10	Dukla Praha	30	44	41	35
11	Vysocina	30	31	54	31
12	Teplice	30	37	52	30
13	Trinity	30	34	50	30
14	Sigma	30	35	49	27
15	Pribram	30	33	53	27
16	Baník	30	27	65	14

TEMPORADA 2014/2015

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Viktoria	30	70	24	72
2	Sparta Praha	30	57	20	67
3	Jablonec	30	58	22	64
4	Mladá	30	43	34	46
5	Pribram	30	40	45	43
6	Dukla Praha	30	34	40	41
7	Teplice	30	41	37	38
8	Bohemians	30	35	41	38
9	Slovácko	30	43	46	37
10	Vysocina	30	33	38	36
11	Slavia Praha	30	40	45	34
12	Slovan	30	39	43	33
13	Zbrojovka	30	34	45	33
14	Baník	30	23	41	33
15	Hradec	30	26	52	25
16	České	30	29	72	22

TEMPORADA 2013/2014

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Sparta Praha	30	78	19	79
2	Viktoria	30	64	21	66
3	Mladá	30	54	38	50
4	Slovan	30	37	46	48
5	Teplice	30	51	35	46
6	Slovácko	30	43	40	40
7	Dukla Praha	30	35	37	38
8	Vysocina	30	45	50	37
9	Zbrojovka	30	32	42	37
10	Baník	30	33	43	35
11	Jablonec	30	43	53	34
12	Pribram	30	34	49	34
13	Slavia Praha	30	24	51	30
14	Bohemians	30	26	40	30
15	Sigma	30	42	60	29
16	Znojmo	30	32	49	27

TEMPORADA 2012/2013

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Viktoria	30	54	21	65
2	Sparta Praha	30	55	23	63
3	Slovan	30	46	34	54
4	Jablonec	30	49	41	49
5	Sigma	30	38	29	47
6	Dukla Praha	30	48	37	46
7	Slavia Praha	30	41	33	42
8	Mladá	30	34	43	38
9	Slovácko	30	37	41	37
10	Vysocina	30	36	42	36
11	Teplice	30	36	47	32
12	Pribram	30	27	39	32
13	Zbrojovka	30	34	53	32
14	Baník	30	34	44	29
15	České	30	24	49	26
16	Hradec	30	27	44	25

TEMPORADA 2011/2012

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Viagem	30	52	35	61
2	Vysocina	30	45	29	55
3	Baník	30	43	31	52
4	Zbrojovka	30	37	29	49
5	Bohemians	30	43	31	48
6	Karviná	30	36	35	43
7	Varnsdorf	30	33	34	42
8	SFC Opava	30	46	36	41
9	Mostecký	30	31	44	38
10	Vlašim	30	36	38	36
11	Trinity	30	28	36	36
12	Znojmo	30	28	35	34
13	FK Caslav	30	27	39	34
14	Táborsko	30	37	51	34
15	Třinec	30	31	41	30
16	Sparta Praha	30	37	46	27

TEMPORADA 2010/2011

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Viktoria	30	70	28	69
2	Sparta Praha	30	54	21	68
3	Jablonec	30	65	34	58
4	Sigma	30	47	29	47
5	Mladá	30	49	40	46
6	Slovan	30	45	36	43
7	Bohemians	30	33	33	43
8	Hradec	30	26	36	41
9	Slavia Praha	30	41	36	40
10	Teplice	30	39	46	39
11	České	30	30	48	33
12	Pribram	30	22	36	31
13	Slovácko	30	27	43	31
14	Baník	30	31	46	30
15	Zbrojovka	30	33	55	24
16	Viagem	30	22	67	19

TEMPORADA 2009/2010

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Sparta Praha	30	42	14	62
2	Jablonec	30	42	24	61
3	Baník	30	47	25	60
4	Teplice	30	44	25	55
5	Viktoria	30	42	33	48
6	Sigma	30	49	36	47
7	Slavia Praha	30	37	35	41
8	Mladá	30	47	41	39
9	Slovan	30	34	39	37
10	Pribram	30	35	41	36
11	Zbrojovka	30	31	40	35
12	Bohemians	30	21	29	34
13	České	30	24	35	31
14	Slovácko	30	28	42	30
15	SK Kladno	30	24	50	25
16	Bohemians	30	27	65	0

TEMPORADA 2008/2009

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Slavia Praha	30	57	25	62
2	Sparta Praha	30	48	25	56
3	Slovan	30	41	28	52
4	Sigma	30	39	36	48
5	Jablonec	30	43	37	46
6	Mladá	30	39	38	46
7	Teplice	30	33	25	43
8	Viktoria	30	45	38	43
9	Baník	30	38	36	39
10	České	30	30	37	36
11	Zbrojovka	30	32	36	35
12	Pribram	30	30	40	34
13	Bohemians	30	33	46	34
14	SK Kladno	30	21	41	31
15	Trinity	30	26	49	29
16	Viktoria	30	27	45	22

TEMPORADA 2007/2008

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Slavia Praha	30	45	24	60
2	Sparta Praha	30	53	26	57
3	Baník	30	51	28	55
4	Zbrojovka	30	43	32	55
5	Teplice	30	40	27	53
6	Slovan	30	35	31	44
7	Mladá	30	37	36	42
8	Trinity	30	28	31	38
9	Viktoria	30	32	37	38
10	Viktoria	30	35	48	37
11	Sigma	30	20	26	36
12	Jablonec	30	24	32	33
13	České	30	27	35	32
14	SK Kladno	30	31	45	27
15	Bohemians	30	24	40	26
16	Mostecký	30	31	58	20

TEMPORADA 2006/2007

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Sparta Praha	30	44	20	62
2	Slovan	30	44	22	58
3	Mladá	30	48	27	58
4	Slavia Praha	30	44	23	58
5	Baník	30	43	33	46
6	Viktoria	30	35	29	46
7	Zbrojovka	30	34	32	46
8	Teplice	30	44	39	42
9	Jablonec	30	30	30	38
10	České	30	28	46	34
11	Mostecký	30	29	40	31
12	SK Kladno	30	23	37	31
13	Trinity	30	21	34	27
14	Sigma	30	29	43	26
15	Pribram	30	15	37	21
16	Slovácko	30	20	39	19

TEMPORADA 2005/2006

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Slovan	30	43	22	59
2	Slavia Praha	30	56	34	54
3	Mladá	30	50	36	54
4	Teplice	30	38	24	52
5	Sparta Praha	30	43	39	45
6	Baník	30	35	32	40
7	Slovácko	30	29	28	38
8	Jablonec	30	35	39	37
9	Sigma	30	34	44	37
10	Mostecký	30	34	41	36
11	Zbrojovka	30	35	36	35
12	Trinity	30	27	33	35
13	Pribram	30	36	36	34
14	Viktoria	30	30	43	31
15	Vysocina	30	20	36	29
16	Chmel	30	22	44	26

Competiciones que juega

2. Liga Checa

Pos	Equipos		Pts
1		FK Dukla Praha	47
2		Vyškov	46
3		FC Táborsko	42
4		Sigma Olomouc II	42
5		Chrudim	37
6		Sparta Praha II	35
7		Vlašim	35
8		SK Líšeň	33
9		SFC Opava	33
10		Pribram	33
11		Zbrojovka Brno	31
12		Vysocina Jihlava	30
13		Viktoria Žižkov	29
14		Varnsdorf	28
15		Prostějov	27
16		SK Hanácká	23

	Ascenso : FK Dukla Praha
	Playoff Ascenso : Vyškov, FC Táborsko
	Descenso : Prostějov, SK Hanácká

RIVALES EN Copa Checa

RIVALES EN 2. Liga Checa

USO DE MEMORIA

7,661,488 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5890
Total Execution Time	0.5902

CADENA URL

/historico/Zbrojovka-Brno

GET DATOS

$_GET['/historico/Zbrojovka-Brno']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10053 AND type_rel = 2
0.0126	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10053 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0131	SELECT /35 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 (304303,317047) ORDER BY n.cover_points DESC, update_date DESC
0.0134	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 = '10053' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135	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=10053 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 (74938,72506,72248,71576,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 = 71576 AND teamId = 10053
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 72248 AND teamId = 10053
0.0141	SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 10053
0.0140	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 10053
0.0135	SELECT count(id) as num_players from rel_players WHERE league_id = 74938 AND teamId = 10053
0.0166	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 = 72248 WHERE rp.league_id = 72248 AND rp.teamId = 10053 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 = 72248 WHERE rp.league_id = 72248 AND rp.teamId = 10053 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141	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 = 72248 WHERE rp.league_id = 72248 AND rp.teamId = 10053 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160	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 = 10053 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72248 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 68036 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 71576 AND t.round = 5 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 = 63120 AND t.round = 30 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* `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 = 50144 AND t.round = 30 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 = 44039 AND t.round = 30 ORDER BY team.conference 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* `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 = 38696 AND t.round = 30 ORDER BY team.conference 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* `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 = 33331 AND t.round = 30 ORDER BY team.conference 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* `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 = 15408 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 = 3883 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* `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 = 2481 AND t.round = 30 ORDER BY team.conference 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* `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 = 2041 AND t.round = 30 ORDER BY team.conference 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* `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 = 8761 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 1083 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 865 AND t.round = 30 ORDER BY team.conference 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* `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 = 243 AND t.round = 30 ORDER BY team.conference 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* `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 = 8741 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* `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 = 8745 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 8747 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Zbrojovka Brno

Zbrojovka Brno

Selecciona un equipo

Competiciones que juega

2. Liga Checa

RIVALES EN Copa Checa

RIVALES EN 2. Liga Checa