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

Znojmo

Temporada 2019/2020

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

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

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	SFC Opava	30	76	33	63
2	Pribram	30	56	32	58
3	Pardubice	30	44	30	51
4	Hradec	30	50	36	50
5	Třinec	30	42	30	47
6	České	30	44	33	44
7	Baník	30	34	39	41
8	Vlašim	30	42	49	38
9	Znojmo	30	36	49	37
10	Viagem	30	37	47	36
11	Varnsdorf	30	40	46	35
12	Viktoria	30	42	52	35
13	Olympia	30	33	45	34
14	Táborsko	30	36	46	33
15	Vitkovice	30	35	52	30
16	Frýdek-Mís	30	26	54	27

TEMPORADA 2016/2017

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Sigma	30	59	22	69
2	Baník	30	48	20	64
3	SFC Opava	30	61	33	63
4	Vlašim	30	61	34	54
5	České	30	39	31	46
6	Znojmo	30	49	47	41
7	Viktoria	30	49	41	39
8	Pardubice	30	31	33	39
9	Viagem	30	34	41	37
10	Táborsko	30	38	48	36
11	Varnsdorf	30	44	46	35
12	Třinec	30	40	52	34
13	Baník	30	28	44	32
14	Vitkovice	30	35	47	31
15	Frýdek-Mís	30	40	57	29
16	Prostějov	30	20	80	12

TEMPORADA 2015/2016

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Karviná	28	50	17	59
2	Hradec	28	45	16	59
3	Znojmo	28	62	33	56
4	Baník	28	32	26	41
5	Táborsko	28	39	34	39
6	Pardubice	28	29	29	38
7	Vlašim	28	35	33	35
8	Viagem	28	39	38	35
9	Varnsdorf	28	35	44	34
10	Frýdek-Mís	28	30	37	33
11	SFC Opava	28	34	37	32
12	České	28	41	48	32
13	Třinec	28	29	41	27
14	Sigma	28	23	49	21
15	Slavoj	28	20	61	20

TEMPORADA 2014/2015

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Sigma	30	64	25	63
2	Varnsdorf	30	47	27	59
3	Viktoria	30	50	23	55
4	Trinity	30	53	32	55
5	Baník	30	44	39	48
6	Táborsko	30	55	42	47
7	Karviná	30	39	31	46
8	Pardubice	30	37	34	45
9	SFC Opava	30	36	35	42
10	Vlašim	30	36	50	39
11	Znojmo	30	37	43	38
12	Viagem	30	34	46	34
13	Třinec	30	33	51	30
14	Frýdek-Mís	30	28	41	28
15	Mostecký	30	25	51	21
16	FK Kolín	30	26	74	15

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

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Bohemians	31	51	25	59
2	Znojmo	30	45	24	58
3	Baník	30	36	26	50
4	HFK Olomouc	30	41	44	50
5	Varnsdorf	30	49	37	49
6	Trinity	30	49	37	48
7	Pardubice	30	47	31	46
8	Viktoria	30	38	30	45
9	Karviná	30	43	43	42
10	Viagem	30	32	42	39
11	Bohemians	30	30	33	35
12	Táborsko	30	35	42	34
13	Mostecký	30	33	48	31
14	Vlašim	30	37	58	31
15	FK Caslav	30	24	43	25
16	SFC Opava	30	34	60	21
17	Pardubice	1	0	1	0

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

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Dukla Praha	30	55	18	63
2	Viktoria	30	44	31	55
3	Vysocina	30	49	29	53
4	Karviná	30	42	36	46
5	Třinec	30	32	34	44
6	Baník	30	53	51	43
7	Vlašim	30	38	32	42
8	FK Caslav	30	37	48	41
9	Táborsko	30	42	40	40
10	Sparta Praha	30	35	47	39
11	Trinity	30	46	45	38
12	Varnsdorf	30	33	38	37
13	Mostecký	30	35	46	37
14	Znojmo	30	30	40	36
15	SK Kladno	30	42	48	31
16	Hlučín	30	36	66	21

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

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sigma	30	65	28	61
2	Znojmo	30	57	35	60
3	Mutenice	30	60	30	57
4	Karviná	30	48	30	50
5	Frýdek-Mís	30	50	38	48
6	Břeclav	30	40	38	48
7	Bystrc	30	42	34	47
8	Slovácko	30	36	38	42
9	Vysocina	30	44	54	38
10	Zábřeh	30	28	50	38
11	Zbrojovka	30	23	30	35
12	Hanácká	30	34	39	34
13	Uničov	30	30	40	33
14	Zlín II	30	31	49	27
15	SK Lipová	30	33	59	25
16	Dolní	30	22	51	21

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

Competiciones que juega

Grupo 1

3. Liga Checa Grupo 1

Pos	Equipos		Pts
1		Blansko	36
2		Odra Petřkovice	34
3		Frýdek-Místek	34
4		Uničov	33
5		Slovan Rosice	32
6		Baník Ostrava II	31
7		SK Hanácká	30
8		Sigma Olomouc II	29
9		Vrchovina	28
10		Vyškov	24
11		Velké Meziříčí	23
12		FC Zlínsko	22
13		Znojmo	20
14		Uhersky Brod	18
15		Hlučín	18
16		Slovácko II	18
17		Zlín II	14
18		Dolní Benešov	6

	Ascenso : Blansko
	Playoff Descenso : Slovácko II, Zlín II
	Descenso : Dolní Benešov

RIVALES EN 3. Liga Checa

RIVALES EN Copa Checa

USO DE MEMORIA

7,454,840 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1631
Total Execution Time	0.1644

CADENA URL

/historico/Znojmo/2020

GET DATOS

$_GET['/historico/Znojmo/2020']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0030	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 = 'Znojmo' AND l.year = 2020 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=5714 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=5714 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=5714 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=5714 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 50313
0.0025	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 = 50426
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5714 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1524 AND type_rel = 3
0.0027	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 = '5714' ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '5714' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '5714' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 50313 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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 = 50426 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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=5714 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (57119,57023,56547,44039) 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 = 44039 AND teamId = 5714
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 57119 AND teamId = 5714
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 57023 AND teamId = 5714
0.0096	SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 5714
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	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 = '5714' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5714' and rp.type = 4
0.0020	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 = '5714' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0039	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 events2020 e ON e.player_id = p.id AND e.league_id = 50313 WHERE rp.league_id = 50313 AND rp.teamId = 5714 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.0031	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 events2020 e ON e.player_id = p.id AND e.league_id = 50313 WHERE rp.league_id = 50313 AND rp.teamId = 5714 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 events2020 e ON e.player_id = p.id AND e.league_id = 50313 WHERE rp.league_id = 50313 AND rp.teamId = 5714 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030	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 = 5714 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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 = 38788 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* `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 = 33332 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* `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 = 15518 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* `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 = 3884 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* `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.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* `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 = 8760 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* `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.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* `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 = 8762 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* `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.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* `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 = 24640 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* `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.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* `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.0027	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* `tables2004` 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 = 24489 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* `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.0020	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 50313 ORDER BY nameShow LIMIT 100

Znojmo

Znojmo

Selecciona un equipo

Competiciones que juega

3. Liga Checa Grupo 1

RIVALES EN 3. Liga Checa

RIVALES EN Copa Checa