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 Hanácká

Entrenador: Martin Onda

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

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 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

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 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

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	SFC Opava	30	48	21	62
2	Sigma	30	57	31	57
3	Prostějov	30	53	41	51
4	Spartak	30	44	34	48
5	Zábřeh	30	44	35	48
6	Slovácko	30	40	39	45
7	Třebíč	30	29	28	45
8	HFK Olomouc	30	39	35	38
9	Uničov	30	39	38	38
10	Slavia	30	31	32	38
11	Hlučín	30	33	42	36
12	Zlín II	30	39	49	34
13	Mikulovice	30	33	53	34
14	Hanácká	30	42	38	33
15	Břeclav	30	25	46	28
16	Žďár	30	31	65	23

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

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

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 2005/2006

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	SK Kladno	29	45	19	57
2	České	30	55	26	55
3	Viagem	30	47	39	49
4	Hradec	30	31	28	49
5	Viktoria	29	40	33	43
6	Hanácká	30	34	32	42
7	HFK Olomouc	30	27	31	41
8	Xaverov	30	36	37	37
9	Vitkovice	30	26	33	36
10	Hlučín	30	31	47	36
11	Kunovice	30	35	43	35
12	Pardubice	30	35	38	34
13	Sparta Praha	30	32	37	34
14	Sigma	30	33	40	34
15	Drnovice	30	24	40	34
16	Zbrojovka	30	24	32	32

TEMPORADA 2004/2005

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Mostecký	28	58	30	61
2	Viktoria	28	32	23	46
3	Viktoria	28	42	36	46
4	Vysocina	27	43	29	45
5	SK Kladno	28	37	22	43
6	Vitkovice	28	35	30	42
7	Zbrojovka	27	32	28	36
8	Hradec	28	37	38	34
9	Kunovice	28	29	42	33
10	Sparta Praha	28	24	30	32
11	Sigma	28	32	39	31
12	Viagem	28	27	40	30
13	Hanácká	28	29	45	28
14	Pardubice	28	20	34	27
15	Tatran	28	28	39	26

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

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,708,520 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1717
Total Execution Time	0.1729

CADENA URL

/historico/Hanacka

GET DATOS

$_GET['/historico/Hanacka']

POST DATOS

No hay datos POST existentes

CONSULTAS (49)

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 = 'Hanacka' 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=30936 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=30936 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=30936 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017	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=30936 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=30936 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039	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.0024	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 = 74939
0.0017	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30936 AND type_rel = 2
0.0025	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 = '30936' ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '30936' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '30936' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025	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 = 72506 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019	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.0023	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=30936 AND l.year in (2023,2024,2025) 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 (74939,72506,72248,71432,68185) 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 = 72248 AND teamId = 30936
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 68185 AND teamId = 30936
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 30936
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 30936
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 74939 AND teamId = 30936
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 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 = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021	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 = '30936' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '30936' and rp.type = 4
0.0022	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 = '30936' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0046	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 = 30936 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.0045	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 = 30936 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0040	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 = 30936 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034	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 = 30936 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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.0033	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.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* `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.0032	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.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* `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.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* `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.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* `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.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* `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 = 24454 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* `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.0020	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.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.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* `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.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* `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* `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 = 8768 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* `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 = 8770 AND t.round = 27 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* `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.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* `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.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* `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

SK Hanácká

SK Hanácká

Selecciona un equipo

Competiciones que juega

2. Liga Checa

RIVALES EN Copa Checa

RIVALES EN 2. Liga Checa