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

SK Líšeň

Entrenador: Milan Valachovic

Temporada 2023/2024

TEMPORADA 2023/2024

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

TEMPORADA 2022/2023

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Karviná	30	58	37	56
2	Vyškov	30	45	29	52
3	Pribram	30	48	32	51
4	Dukla Praha	30	51	45	47
5	SK Líšeň	30	38	27	46
6	Varnsdorf	30	54	46	43
7	Táborsko	30	39	43	42
8	Chrudim	30	32	32	39
9	Sigma	30	41	46	39
10	Sparta Praha	30	32	39	39
11	Vlašim	30	54	49	38
12	Prostějov	30	39	57	36
13	SFC Opava	30	26	29	34
14	Vysocina	30	37	51	34
15	Slavia Praha	30	42	56	32
16	Třinec	30	30	48	27

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

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

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

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	SK Líšeň	30	67	33	61
2	Odra	30	58	35	60
3	Frýdek-Mís	30	54	33	60
4	Hanácká	30	62	31	57
5	Vyškov	30	59	35	51
6	Uničov	30	54	36	51
7	Velké	30	55	61	42
8	FC Zlínsko	30	63	55	40
9	Hlučín	30	46	41	39
10	Uhersky Brod	30	46	48	39
11	Dolní	30	37	52	37
12	Hodonín-Ša	30	43	43	35
13	Jiskra	30	49	55	35
14	Vrchovina	30	44	58	35
15	Spartak	30	40	75	23
16	Valašské	30	14	100	5

TEMPORADA 2017/2018

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Prostějov	30	79	33	70
2	Velké	30	75	49	60
3	SK Líšeň	30	63	44	54
4	Kromeriz	30	57	48	50
5	Hlučín	30	52	41	46
6	Hodonín-Ša	30	54	52	43
7	Jiskra	30	51	61	42
8	Spartak	30	65	60	41
9	Vyškov	30	54	51	41
10	Uhersky Brod	30	36	44	41
11	Uničov	30	62	46	40
12	Odra	30	49	49	40
13	FC Zlínsko	30	45	61	36
14	Valašské	30	43	72	35
15	HFK Olomouc	30	39	74	22
16	Mohelnice	30	34	73	14

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

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Prostějov	30	66	31	62
2	Vitkovice	30	50	32	57
3	Spartak	30	57	35	55
4	Uničov	30	52	32	51
5	Hlučín	30	49	34	49
6	Vyškov	30	58	33	47
7	Hanácká	30	48	50	44
8	Mohelnice	30	39	36	42
9	Zlín II	30	41	47	42
10	FC Zlínsko	30	39	46	39
11	Slovácko	30	50	46	35
12	Velké	30	45	52	35
13	SK Líšeň	30	32	52	32
14	HFK Olomouc	30	27	54	26
15	Třebíč	30	36	66	24
16	Břeclav	30	29	72	20

TEMPORADA 2014/2015

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sigma	30	77	27	64
2	Hanácká	30	50	36	54
3	Prostějov	30	57	37	51
4	Slovácko	30	63	47	50
5	Uničov	30	53	42	48
6	Hlučín	30	46	45	46
7	Zábřeh	30	39	33	45
8	Spartak	30	54	49	45
9	Zlín II	30	49	45	43
10	SK Líšeň	30	52	53	39
11	Slavia	30	40	44	37
12	Vyškov	30	47	48	36
13	Třebíč	30	27	48	32
14	HFK Olomouc	30	29	54	31
15	Břeclav	30	40	60	30
16	Opava II	30	25	80	10

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

4. LIGA CHECA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Třebíč	26	46	13	58
2	SK Líšeň	26	52	27	52
3	Napajedla	27	50	35	43
4	Velké	26	43	41	39
5	FC Zlínsko	26	41	37	36
6	Bystřice	26	44	50	33
7	Slavoj	27	36	43	33
8	Vyškov	26	29	25	32
9	Vrchovina	26	28	34	32
10	Pelhřimov	26	36	46	32
11	Bystrc	26	35	53	32
12	Sokol	26	36	46	31
13	Hodonín-Ša	26	28	32	30
14	Slovácká	26	30	50	27
15	Tatran Brno	26	43	45	26
16	Vracov	0	0	0	0

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

3. LIGA CHECA GRUPO 1
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

4. LIGA CHECA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	SK Líšeň	30	63	24	68
2	Šardice	29	62	25	65
3	Spartak	29	57	21	56
4	Třebíč	30	42	23	51
5	Vyškov	30	45	34	47
6	FC Zlínsko	30	49	40	43
7	Sokol	30	35	36	39
8	Žďár	30	48	56	38
9	Sokol Konice	30	46	67	38
10	Velké	30	38	48	36
11	Rousínov	30	33	39	35
12	Napajedla	30	36	53	33
13	Boskovice	30	29	53	31
14	Ždírec	30	29	45	30
15	Rájec-Jestr	30	32	51	28
16	Mohelnice	30	33	62	25

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

TEMPORADA 2006/2007

4. LIGA CHECA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Zábřeh	30	56	23	65
2	SK Líšeň	30	56	27	58
3	Rousínov	30	42	28	53
4	Vyškov	30	51	37	44
5	Rájec-Jestr	30	37	32	44
6	Sokol Konice	30	47	37	42
7	Hrusovany	30	42	46	42
8	CAFC	30	34	47	40
9	Žďár	30	46	49	39
10	Velké	30	42	48	38
11	Třebíč	30	52	53	37
12	Boskovice	30	44	49	37
13	Sokol	30	32	47	36
14	Šardice	30	42	57	35
15	Hartvikovice	30	38	57	33
16	Morkovice	30	32	56	28

TEMPORADA 2005/2006

4. LIGA CHECA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Mutenice	30	87	28	68
2	Hrusovany	30	55	34	51
3	Brumov	30	44	48	51
4	Morkovice	30	58	46	45
5	Žďár	30	54	52	44
6	Napajedla	30	37	35	44
7	Slavičín	30	40	33	43
8	Šardice	30	37	37	43
9	SK Líšeň	30	51	48	42
10	Velké	30	52	52	42
11	Třebíč	30	40	49	40
12	Rousínov	30	40	36	38
13	Vyškov	30	33	36	37
14	CAFC	30	44	67	31
15	Kyjov 1919	30	27	58	27
16	Ždírec	30	27	67	20

Competiciones que juega

2. Liga Checa

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

	Ascenso : FK Dukla Praha
	Playoff Ascenso : Vyškov, Sigma Olomouc II
	Descenso : Prostějov, SK Hanácká

RIVALES EN Copa Checa

RIVALES EN 2. Liga Checa

USO DE MEMORIA

7,421,920 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.8492
Total Execution Time	0.8504

CADENA URL

/historico/Lise

GET DATOS

$_GET['/historico/Lise']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0158	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 = 'Lise' 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.0145	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=30979 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=30979 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=30979 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147	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=30979 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293	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 = 72248
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30979 AND type_rel = 2
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=367 AND type_rel = 3
0.0145	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 367 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148	SELECT /53 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 (808298,779859,463893,375302) ORDER BY n.cover_points DESC, update_date DESC
0.0153	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 = '30979' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0164	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 = '30979' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0153	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 = 72248 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155	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=30979 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146	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,72248,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.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 72248 AND teamId = 30979
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 30979
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 30979
0.0149	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 = 72248 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146	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 = '30979' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '30979' and rp.type = 4
0.0147	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 = '30979' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0160	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 = 30979 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.0158	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 = 30979 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154	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 = 30979 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151	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 = 30979 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0149	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 = 26 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* `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 = 68039 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.0149	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.0151	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.0148	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 = 44268 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 38900 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 15612 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 9181 AND t.round = 30 ORDER BY team.conference 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* `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.0151	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 = 25096 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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.0155	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 = 24650 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0172	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.0167	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 = 25139 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156	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
0.0159	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 = 27586 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163	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 = 27594 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 72248 ORDER BY nameShow LIMIT 100
0.0179	SELECT c.name,l.categoryId,l.group_code,c.CountryCode,c.alias FROM categories_besoccer c INNER JOIN leagues_besoccer l ON l.categoryId = c.id WHERE c.active_year = l.year AND c.location = 'cz' AND (c.ctype = 1) AND c.id != 367 GROUP BY c.id ORDER BY c.troncal=1 DESC,c.coefficient DESC LIMIT 10
0.0152	SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 367 AND l.group_code = 1 ORDER BY l.year DESC

SK Líšeň

SK Líšeň

Selecciona un equipo

Competiciones que juega

2. Liga Checa

RIVALES EN Copa Checa

RIVALES EN 2. Liga Checa