Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Letohrad

Temporada 2023/2024

TEMPORADA 2023/2024

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Ústí	15	39	11	38
2	Benátky	15	24	7	37
3	Velke Hamry	15	31	19	33
4	Pěnčín-Tu	15	30	17	28
5	Vysoké	15	24	18	28
6	Slavia HK	15	23	24	25
7	Chrudim II	15	25	22	22
8	Benešov	15	25	25	19
9	Dobrovice	15	21	24	19
10	Spoje Prague	15	21	25	18
11	Trutnov	15	25	26	17
12	Hlinsko	15	19	22	17
13	Kosmonosy	15	22	34	17
14	Novy Bydzov	15	19	35	14
15	FK Caslav	15	17	31	7
16	Letohrad	15	9	34	5

TEMPORADA 2022/2023

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Slovan	30	89	22	73
2	Ústí	30	49	36	64
3	Benátky	30	60	31	58
4	Trutnov	30	59	48	52
5	Velke Hamry	30	64	33	50
6	Hlinsko	30	56	53	50
7	Chrudim II	30	55	53	42
8	Dobrovice	30	41	50	41
9	Pěnčín-Tu	30	59	65	38
10	Vysoké	30	50	43	37
11	Novy Bydzov	30	40	48	34
12	Letohrad	30	46	65	34
13	FK Caslav	30	39	65	28
14	Brandýs	30	35	71	28
15	Dvůr	30	27	67	25
16	Náchod	30	21	40	20

TEMPORADA 2021/2022

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	FK Kolín	30	96	35	79
2	Vysoké	30	81	32	63
3	Velke Hamry	30	75	39	57
4	Kosmonosy	30	70	55	48
5	FK Caslav	30	56	49	48
6	Benátky	30	62	32	46
7	Letohrad	30	48	46	41
8	Trutnov	30	40	55	40
9	Sokol Libiš	30	55	67	38
10	Dvůr	30	41	50	34
11	Hlinsko	30	41	54	34
12	Náchod	30	28	55	34
13	Tochovice	30	53	73	30
14	Poříčany	30	38	71	30
15	Horky	30	38	65	26
16	Kutna Hora	30	41	85	26

TEMPORADA 2020/2021

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	FK Kolín	8	36	7	22
2	Náchod	8	31	9	21
3	Vysoké	8	21	8	19
4	Velke Hamry	8	19	9	19
5	Kosmonosy	8	23	22	15
6	Benátky	8	23	17	13
7	Poříčany	8	12	10	11
8	Hlinsko	8	7	12	10
9	Dvůr	8	15	14	9
10	FK Caslav	8	15	18	9
11	Letohrad	8	11	16	8
12	Trutnov	8	14	17	7
13	Kutna Hora	8	12	37	6
14	Horky	7	13	19	5
15	Sokol Libiš	7	8	22	3
16	Polaban	8	6	29	3

TEMPORADA 2019/2020

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Vysoké	16	42	16	40
2	Benátky	16	33	17	37
3	Náchod	16	39	14	34
4	Dvůr	16	36	24	28
5	FK Kolín	16	29	18	27
6	Trutnov	16	24	35	24
7	Velke Hamry	16	29	22	23
8	Letohrad	16	24	24	22
9	Horky	16	25	33	22
10	Hlinsko	16	27	24	21
11	Ostrá	16	25	23	21
12	FK Caslav	16	27	35	18
13	Sokol Libiš	16	22	30	16
14	Kutna Hora	16	17	35	14
15	Poříčany	16	20	41	12
16	Polaban	16	13	41	10

TEMPORADA 2017/2018

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Sokol	15	34	14	38
2	Vysoké	15	33	20	28
3	Jiskra	15	36	25	28
4	FK Kolín	15	28	23	25
5	FK Zbuzany	15	38	30	21
6	Brandýs	15	34	30	21
7	Admira Praha	15	27	28	21
8	Sokol	15	30	33	21
9	Pardubice	15	22	24	20
10	FK Caslav	15	33	36	20
11	Spartak	15	36	41	19
12	Dvůr	15	19	20	18
13	Pěnčín-Tu	15	34	39	16
14	Trutnov	15	23	33	16
15	Cechy Vykan	15	29	37	15
16	Letohrad	15	16	39	8

TEMPORADA 2016/2017

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Ústí	30	56	20	67
2	Sokol	30	76	33	60
3	Vysoké	30	52	27	56
4	FK Caslav	30	65	35	55
5	FK Kolín	30	49	31	53
6	Ostrá	30	41	30	42
7	Pěnčín-Tu	30	58	61	42
8	Letohrad	30	35	39	41
9	Pardubice	30	54	55	40
10	Dvůr	30	41	48	40
11	Spartak	30	58	65	37
12	Sokol	30	50	49	36
13	Trutnov	30	49	60	36
14	Přední	30	37	71	26
15	Kutna Hora	30	23	58	25
16	Náchod	30	34	96	11

TEMPORADA 2015/2016

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Olympia	28	72	15	72
2	Sokol	28	73	31	61
3	Admira Praha	28	41	35	51
4	Vysoké	28	50	40	48
5	Dvůr	28	61	41	47
6	Pěnčín-Tu	28	52	51	47
7	Letohrad	28	54	47	43
8	Kutna Hora	28	43	47	41
9	Nový Bor	28	43	49	41
10	Jablonec	28	46	48	40
11	Trutnov	28	49	60	39
12	Sokol	28	37	34	38
13	Ústí	28	37	42	38
14	Jaroměř	28	24	77	14
15	Semily	28	21	86	12
16	Litol	0	0	0	0

TEMPORADA 2014/2015

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dobrovice	30	72	23	71
2	Benátky	30	55	27	61
3	Kutna Hora	30	52	39	58
4	Sokol	30	45	30	55
5	Trutnov	30	58	26	49
6	Český Brod	30	45	46	44
7	Pěnčín-Tu	30	65	58	43
8	Jablonec	30	54	60	43
9	Letohrad	30	34	35	42
10	Dvůr	30	43	55	41
11	Vysoké	30	42	47	40
12	Ústí	30	35	39	39
13	Náchod	30	29	45	34
14	Pardubice	30	37	59	30
15	Česká	30	37	46	28
16	Týnište	30	27	95	19

TEMPORADA 2013/2014

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Nová Paka	30	78	31	70
2	Dobrovice	30	65	29	61
3	Pěnčín-Tu	30	74	52	54
4	Sokol	30	55	34	54
5	Vysoké	30	55	45	48
6	Ústí	30	55	38	44
7	Dvůr	30	49	54	42
8	Kutna Hora	30	50	39	41
9	Jablonec	30	55	58	41
10	Trutnov	30	56	61	41
11	Letohrad	30	47	49	39
12	Náchod	30	52	55	39
13	Pardubice	30	48	59	39
14	Svitavy	30	53	66	34
15	Železný	30	40	83	21
16	Rapid	30	30	109	11

TEMPORADA 2012/2013

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Viktorie	30	97	10	85
2	Kutna Hora	30	57	35	54
3	Jiskra	30	56	29	51
4	Pardubice	30	51	37	50
5	Svitavy	30	62	55	47
6	Letohrad	30	52	43	46
7	Nová Paka	30	44	47	45
8	Dobrovice	30	40	35	42
9	Ústí	30	51	59	40
10	Náchod	30	49	47	37
11	Dvůr	30	42	45	37
12	Sokol Lhota	30	35	51	37
13	Pěnčín-Tu	30	42	60	37
14	Union Nový	30	32	56	32
15	Semily	30	38	66	27
16	SK Holice	30	23	96	12

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

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Vlašim	34	70	16	83
2	Písek	34	54	32	70
3	Sparta Krč	34	45	33	57
4	Slavia Praha	34	35	26	56
5	Viktoria	34	44	43	46
6	Varnsdorf	34	42	36	45
7	Karlovy Vary	34	43	40	45
8	Táborsko	34	39	48	44
9	České	34	48	46	43
10	Viktoria	34	40	42	43
11	Hlavice	34	38	51	43
12	Mladá	34	51	46	42
13	Králův	34	45	64	40
14	Slovan	34	46	55	39
15	Jablonec II	34	44	53	39
16	Slavoj	34	39	50	38
17	Náchod	34	38	66	37
18	Letohrad	34	35	49	35

TEMPORADA 2007/2008

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sparta Praha	34	61	22	72
2	Vlašim	34	69	40	66
3	Táborsko	33	51	45	64
4	Mladá	34	47	33	58
5	Karlovy Vary	34	55	41	57
6	Varnsdorf	34	46	35	56
7	České	34	46	37	50
8	Jablonec II	34	59	56	48
9	Viktoria	34	45	41	45
10	Slovan	33	55	52	44
11	Náchod	34	47	53	43
12	Slavoj	34	43	45	42
13	Letohrad	34	39	48	42
14	Slavia Praha	34	41	36	41
15	Hvězda Cheb	34	32	40	41
16	FK Kolín	34	31	47	36
17	Příbram	34	37	63	27
18	Chmel	34	25	95	16

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

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Slovan	30	42	30	56
2	Xaverov	30	38	26	53
3	FK Caslav	30	44	29	51
4	Náchod	30	49	34	48
5	Hradec	31	34	30	42
6	Varnsdorf	30	47	49	42
7	Bohemians	30	35	40	41
8	Strakonice	31	30	43	40
9	Příbram	31	36	39	39
10	Slavia Praha	30	37	38	38
11	Chomutov	29	39	41	38
12	FK Kolín	30	35	41	38
13	České	31	38	34	36
14	Brevnov	30	26	32	36
15	Baník Most	30	43	51	36
16	Karlovy Vary	29	44	52	35
17	Letohrad	30	34	42	35

TEMPORADA 2003/2004

3. LIGA CHECA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Viagem	34	62	22	70
2	Náchod	34	58	48	54
3	Brevnov	34	35	35	51
4	Bohemians	34	44	52	49
5	Slavia Praha	34	42	33	48
6	Varnsdorf	34	50	52	48
7	Hradec	34	45	35	47
8	Chomutov	34	50	47	47
9	Karlovy Vary	34	42	51	46
10	České	34	54	55	45
11	Letohrad	34	42	45	43
12	FK Kolín	34	40	49	43
13	Semily	34	31	44	43
14	Příbram	34	54	52	42
15	Slovan	34	39	43	42
16	Chrudim	34	41	44	41
17	Teplice II	34	38	41	39
18	Sparta Krč	34	36	55	32

Competiciones que juega

Grupo 3

4. Liga Checa Grupo 3

Pos	Equipos		Pts
1		Ústí nad Orlicí	38
2		Benátky nad Jizerou	37
3		Velke Hamry	33
4		Pěnčín-Turnov	28
5		Vysoké Mýto	28
6		Slavia HK	25
7		Chrudim II	22
8		Benešov	19
9		Dobrovice	19
10		Spoje Prague	18
11		Trutnov	17
12		Hlinsko	17
13		Kosmonosy	17
14		Novy Bydzov	14
15		FK Caslav	7
16		Letohrad	5

	Ascenso : Ústí nad Orlicí

RIVALES EN 4. Liga Checa

RIVALES EN Copa Checa

USO DE MEMORIA

7,517,952 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.1315
Total Execution Time	0.1327

CADENA URL

/historico/Letohrad

GET DATOS

$_GET['/historico/Letohrad']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0041	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 = 72426
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30976 AND type_rel = 2
0.0019	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1523 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0019	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 (714382) ORDER BY n.cover_points DESC, update_date DESC
0.0024	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 = '30976' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 72426 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=30976 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 (72506,72426,67320) 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.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 72426 AND teamId = 30976
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 30976
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 30976
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 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 = 72426 AND t.round = 15 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 = '30976' 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 = '30976' and rp.type = 4
0.0021	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 = '30976' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020	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 = 72426 WHERE rp.league_id = 72426 AND rp.teamId = 30976 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.0020	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 = 72426 WHERE rp.league_id = 72426 AND rp.teamId = 30976 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020	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 = 72426 WHERE rp.league_id = 72426 AND rp.teamId = 30976 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 30976 AND l.year <= 2024 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* `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 = 72426 AND t.round = 15 ORDER BY team.conference ASC,t.position 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* `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 = 68190 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.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* `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 = 63520 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.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* `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 = 57124 AND t.round = 8 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 = 50443 AND t.round = 16 ORDER BY team.conference ASC,t.position 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* `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 = 39717 AND t.round = 15 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 = 33442 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 = 16001 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 = 9185 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 = 25085 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 = 25093 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 = 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.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* `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.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* `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.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* `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 = 24643 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* `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 = 24515 AND t.round = 34 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* `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.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 = 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 = 24492 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* `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 = 24482 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Letohrad

Letohrad

Selecciona un equipo

Competiciones que juega

4. Liga Checa Grupo 3

RIVALES EN 4. Liga Checa

RIVALES EN Copa Checa