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

Dobrovice

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 2018/2019

3. LIGA CHECA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Slavoj	33	68	31	70
2	Sokol Zápy	33	62	37	67
3	Loko Vltavin	32	67	38	63
4	Radotín	33	52	34	59
5	Jiskra	33	62	42	56
6	Litomericko	33	45	50	49
7	Převýšov	32	49	52	48
8	Dobrovice	32	47	42	46
9	Benešov	33	50	58	42
10	Sokol	33	40	45	41
11	Velvary	33	50	58	40
12	Ústí	32	32	44	40
13	Povltavská	32	48	58	39
14	Králův	33	46	44	35
15	Písek	32	44	62	29
16	Karlovy Vary	32	41	62	27
17	Sokol	32	32	62	24
18	Viktorie	9	3	19	5

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

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

TEMPORADA 2003/2004

4. LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	FK Caslav	30	62	22	71
2	Sibrina	30	66	35	67
3	Velim	30	67	44	52
4	Dobrovice	30	48	36	52
5	Jablonec II	30	58	28	48
6	Český Brod	30	54	51	46
7	Ústí	30	56	45	44
8	Agria Chocen	30	27	26	40
9	Pardubice	30	46	51	38
10	Cesky Dub	30	43	46	37
11	Týnište	30	47	55	36
12	Pardubice	30	52	51	35
13	Loko Vltavin	30	41	45	35
14	Xaverov B	30	35	61	31
15	Union Nový	30	39	51	30
16	Semice	30	16	110	7

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

USO DE MEMORIA

6,714,520 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1416
Total Execution Time	0.1429

CADENA URL

/historico/Dobrovice

GET DATOS

$_GET['/historico/Dobrovice']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0076	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 = 'Dobrovice' 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.0022	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=30927 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=30927 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=30927 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0061	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.0022	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30927 AND type_rel = 2
0.0055	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 = '30927' ORDER BY l.year DESC,cat.coefficient DESC
0.0038	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 = '30927' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0051	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 = '30927' 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.0021	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=30927 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 (72426,71432,68174) 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 = 30927
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 68174 AND teamId = 30927
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 30927
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 = '30927' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '30927' and rp.type = 4
0.0019	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 = '30927' 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 = 30927 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.0019	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 = 30927 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	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 = 30927 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022	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 = 30927 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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 = 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.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* `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 = 44269 AND t.round = 34 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* `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.0029	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.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* `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.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.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 = 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.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* `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.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.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 = 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.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.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2005` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 27602 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* `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 = 27610 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Dobrovice

Dobrovice

Selecciona un equipo

Competiciones que juega

4. Liga Checa Grupo 3

RIVALES EN 4. Liga Checa