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

Chrudim

Entrenador: Radek Krondak

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	26	45	41	38
6	Sparta Praha	25	45	41	35
7	Vlašim	25	34	30	35
8	Zbrojovka	26	34	34	34
9	SFC Opava	26	27	29	34
10	SK Líšeň	25	29	30	33
11	Pribram	26	28	39	33
12	Vysocina	26	38	39	31
13	Varnsdorf	26	45	45	29
14	Viktoria	25	36	45	29
15	Prostějov	25	33	47	27
16	Hanácká	25	24	40	23

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

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

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Chrudim	34	89	26	76
2	Loko Vltavin	34	69	40	71
3	Sokol Zápy	34	57	39	67
4	Jiskra	34	92	58	60
5	Viktorie	34	49	44	56
6	Benešov	34	50	41	54
7	Povltavská	34	63	68	53
8	Převýšov	34	60	53	52
9	Králův	34	52	59	52
10	Písek	34	58	44	51
11	Ústí	34	39	48	51
12	Dobrovice	34	47	44	46
13	Slavoj	34	54	59	43
14	Litomericko	34	47	59	43
15	Benátky	34	50	62	40
16	Sokol	34	58	72	40
17	Sokol	34	33	88	18
18	Polaban	34	18	81	15

TEMPORADA 2016/2017

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Viktorie	34	79	41	73
2	Olympia	34	73	34	70
3	Loko Vltavin	34	77	53	68
4	Tachov	34	77	58	64
5	Králův	34	55	33	63
6	Chrudim	34	61	38	62
7	Převýšov	34	52	35	60
8	Povltavská	34	58	53	57
9	Jiskra	34	62	54	51
10	Dobrovice	34	59	58	49
11	Sokol Zápy	34	68	54	48
12	Písek	34	53	57	47
13	Slavoj	34	60	70	45
14	Benátky	34	41	55	40
15	Litomericko	34	39	65	40
16	Benešov	34	47	77	32
17	Táborsko	34	35	97	23
18	Hořovicko	34	21	85	13

TEMPORADA 2015/2016

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sokol Zápy	36	69	36	83
2	Viktorie	36	71	44	79
3	Viktoria	36	89	35	78
4	Loko Vltavin	36	84	43	75
5	Chrudim	36	85	37	73
6	Jiskra	36	67	56	63
7	Králův	36	59	48	61
8	Dobrovice	36	76	56	59
9	Písek	36	54	48	59
10	Převýšov	36	63	53	52
11	Tachov	36	63	65	50
12	Benátky	36	48	65	48
13	Benešov	36	51	67	46
14	Táborsko	36	49	76	44
15	Povltavská	36	43	53	42
16	FK Kolín	36	45	58	41
17	Mostecký	36	29	87	19
18	FK Caslav	36	26	90	16
19	Sokol	36	32	86	15
20	Union Nový	0	0	0	0

TEMPORADA 2014/2015

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Bohemians	34	68	25	81
2	Slavoj	34	68	57	64
3	Jiskra	34	72	43	62
4	Viktorie	34	59	43	62
5	Chrudim	34	54	41	58
6	Louňovice	34	58	46	55
7	Králův	34	60	47	53
8	Loko Vltavin	34	50	41	51
9	Sokol Zápy	34	54	54	48
10	Převýšov	34	58	49	47
11	Písek	34	52	56	46
12	FK Caslav	34	37	53	44
13	Povltavská	34	40	37	43
14	Benešov	34	44	54	43
15	Union Nový	34	40	61	38
16	Chomutov	34	40	74	34
17	Admira Praha	34	38	67	32
18	Meteor Praha	34	36	80	24

TEMPORADA 2013/2014

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Viktorie	32	56	36	61
2	FK Kolín	32	54	30	60
3	Sparta Praha	32	54	38	55
4	Chrudim	32	60	44	53
5	Chomutov	32	60	45	52
6	FK Caslav	32	50	42	51
7	Králův	32	46	47	51
8	Jiskra	32	49	42	49
9	Povltavská	32	42	35	47
10	Admira Praha	32	51	45	46
11	Sokol Zápy	32	55	44	45
12	Meteor Praha	32	49	60	44
13	Převýšov	32	56	43	43
14	Roudnice	32	53	49	40
15	Karlovy Vary	32	47	64	34
16	FK Kunice	32	44	65	34
17	Horní	32	29	66	24
18	Strakonice	32	27	87	12

TEMPORADA 2012/2013

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Loko Vltavin	34	59	37	71
2	FK Kolín	34	63	38	66
3	FK Kunice	34	63	46	62
4	Jiskra	34	81	52	59
5	Roudnice	34	69	50	58
6	Sparta Praha	34	60	35	56
7	Chrudim	34	58	43	52
8	Chomutov	34	59	45	50
9	Sokol Zápy	34	41	36	49
10	Ceská Lípa	34	58	52	48
11	Převýšov	34	43	38	47
12	Karlovy Vary	34	53	59	42
13	Horní	34	48	61	41
14	Králův	34	54	62	40
15	Strakonice	34	38	48	40
16	SK Kladno	34	42	51	38
17	Písek	34	36	65	24
18	Hlavice	34	27	134	7

TEMPORADA 2011/2012

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Chrudim	34	67	34	77
2	Pardubice	34	81	32	68
3	FK Kunice	34	59	32	60
4	Mladá	34	71	50	52
5	Chomutov	34	55	61	51
6	Jiskra	34	65	50	50
7	Roudnice	34	68	63	50
8	Králův	34	44	50	50
9	Loko Vltavin	34	50	51	48
10	Sokol Ovcary	34	50	47	47
11	Ceská Lípa	34	39	54	45
12	Karlovy Vary	34	37	58	44
13	Viktoria	34	55	63	42
14	Písek	34	45	56	42
15	Slovan	34	45	72	38
16	Hlavice	34	44	67	37
17	SK Kladno	34	48	64	33
18	Letohrad	34	44	63	33

TEMPORADA 2010/2011

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Letohrad	28	61	22	64
2	Chrudim	28	64	28	59
3	Velim	28	47	40	51
4	Hradec	28	50	28	48
5	FK Kolín	28	44	27	45
6	Náchod	28	47	38	39
7	Horní	28	41	36	37
8	Ústí	28	41	38	37
9	Trutnov	28	57	51	36
10	Union Nový	28	33	51	36
11	Dvůr	28	40	39	35
12	Pěnčín-Tu	28	39	52	35
13	Nová Paka	28	29	47	35
14	Semily	28	33	68	20
15	Jicín	28	12	73	10

TEMPORADA 2009/2010

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Pardubice	30	70	16	78
2	Chrudim	30	49	39	51
3	Ústí	30	43	34	47
4	Horní	30	37	40	47
5	Nová Paka	30	37	36	44
6	Letohrad	30	35	38	44
7	Hradec	30	41	30	42
8	Velim	30	35	36	42
9	Podjestedsky	30	36	46	42
10	Union Nový	30	41	43	41
11	Dvůr	30	42	48	41
12	Náchod	30	37	42	40
13	Sokol	30	44	51	37
14	Pěnčín-Tu	30	36	45	37
15	Převýšov	30	34	49	32
16	Dobrovice	30	30	54	15

TEMPORADA 2008/2009

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Sokol Ovcary	30	57	24	60
2	Hradec	30	45	34	52
3	Chrudim	30	46	41	50
4	Union Nový	30	37	30	49
5	Dvůr	30	46	51	47
6	Bohemians	30	40	39	46
7	FK Kunice	30	54	38	44
8	FK Kolín	30	51	47	44
9	Sokol	30	38	34	43
10	Horní	30	36	32	43
11	Pardubice	30	37	31	41
12	Pěnčín-Tu	30	35	29	41
13	Velim	30	41	47	36
14	Převýšov	30	30	44	36
15	Týnište	30	28	41	28
16	SK Holice	30	22	81	9

TEMPORADA 2007/2008

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hlavice	30	65	21	66
2	Sokol Ovcary	30	57	28	56
3	Dvůr	30	55	38	54
4	Pardubice	30	60	31	50
5	Velim	30	50	35	49
6	Hradec	30	56	37	48
7	Pěnčín-Tu	30	48	39	47
8	Chrudim	30	61	41	45
9	Převýšov	30	33	33	42
10	Týnište	30	40	48	40
11	SK Holice	30	32	56	37
12	Union	30	35	51	36
13	Dobrovice	30	51	44	34
14	Trutnov	30	43	58	34
15	Agria Chocen	30	33	48	30
16	Predmerice	30	9	120	6

TEMPORADA 2006/2007

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Slovan	30	58	21	67
2	Letohrad	30	41	18	60
3	Dvůr	30	68	34	52
4	Dobrovice	30	54	41	51
5	Pardubice	30	38	26	45
6	Velim	30	44	38	43
7	Týnište	30	32	32	43
8	Trutnov	30	46	47	42
9	Hlavice	30	31	33	40
10	Český Brod	30	53	54	36
11	Predmerice	30	46	62	35
12	Agria Chocen	30	35	60	35
13	Chrudim	30	34	41	34
14	Hlinsko	30	47	64	33
15	Ústí	30	31	43	26
16	Sedmihorky	30	24	68	17

TEMPORADA 2005/2006

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	FK Kolín	30	63	15	66
2	Velim	30	56	36	54
3	Dobrovice	30	47	28	52
4	Letohrad	30	41	26	51
5	Dvůr	30	39	28	50
6	Predmerice	30	45	48	44
7	Chrudim	30	29	32	42
8	Kacov	30	44	45	41
9	Ústí	30	33	39	38
10	Agria Chocen	30	39	29	37
11	Pardubice	30	31	30	36
12	Hlavice	30	23	34	34
13	Týnište	30	42	56	34
14	Pardubice	30	36	54	33
15	SK Skalice	30	34	54	33
16	Svitavy	30	24	72	13

TEMPORADA 2004/2005

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Jablonec II	30	66	18	71
2	Dvůr	30	49	40	55
3	Dobrovice	30	54	46	50
4	Union	30	47	42	50
5	Velim	30	66	44	46
6	Ústí	30	41	38	46
7	Chrudim	30	39	30	43
8	Kacov	30	48	50	42
9	Pardubice	30	46	51	41
10	Týnište	30	54	55	40
11	Agria Chocen	30	39	42	40
12	Pardubice	30	42	41	39
13	Český Brod	30	41	49	38
14	Skutec	30	44	62	34
15	Uhelne	30	41	72	22
16	Cesky Dub	30	24	61	22

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	38
6		Sparta Praha II	35
7		Vlašim	35
8		Zbrojovka Brno	34
9		SFC Opava	34
10		SK Líšeň	33
11		Pribram	33
12		Vysocina Jihlava	31
13		Varnsdorf	29
14		Viktoria Žižkov	29
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,921,800 bytes

BENCHMARKS

Loading Time Base Classes	0.0016
Controller Execution Time ( Home / Category )	0.1680
Total Execution Time	0.1696

CADENA URL

/historico/Chrudim

GET DATOS

$_GET['/historico/Chrudim']

POST DATOS

No hay datos POST existentes

CONSULTAS (45)

0.0041	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 = 'Chrudim' 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=30934 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=30934 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=30934 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=30934 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=30934 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30934 AND type_rel = 2
0.0062	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 = '30934' ORDER BY l.year DESC,cat.coefficient DESC
0.0052	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 = '30934' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0033	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 = '30934' 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 = 72248 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	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=30934 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021	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 (74936,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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 72248 AND teamId = 30934
0.0032	SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 30934
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 30934
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 74936 AND teamId = 30934
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 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.0022	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 = '30934' 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 = '30934' 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 = '30934' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036	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 = 30934 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.0038	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72248 WHERE rp.league_id = 72248 AND rp.teamId = 30934 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72248 WHERE rp.league_id = 72248 AND rp.teamId = 30934 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	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 = 30934 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 = 26 ORDER BY team.conference ASC,t.position 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* `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.0021	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0021	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.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* `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.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* `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.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* `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 = 38899 AND t.round = 34 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* `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 = 33704 AND t.round = 34 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 = 15611 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 9182 AND t.round = 34 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 = 33761 AND t.round = 32 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 = 24660 AND t.round = 34 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* `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 = 24658 AND t.round = 34 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* `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 = 25108 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 25130 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041	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 = 25138 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* `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 = 27571 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037	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 = 27585 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* `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 = 27593 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2005` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 27602 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Chrudim

Chrudim

Selecciona un equipo

Competiciones que juega

2. Liga Checa

RIVALES EN Copa Checa

RIVALES EN 2. Liga Checa