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.

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

České Budějovice

Entrenador: Jiri Lerch

Temporada 2018/2019

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

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	SFC Opava	30	76	33	63
2	Pribram	30	56	32	58
3	Pardubice	30	44	30	51
4	Hradec	30	50	36	50
5	Třinec	30	42	30	47
6	České	30	44	33	44
7	Baník	30	34	39	41
8	Vlašim	30	42	49	38
9	Znojmo	30	36	49	37
10	Viagem	30	37	47	36
11	Varnsdorf	30	40	46	35
12	Viktoria	30	42	52	35
13	Olympia	30	33	45	34
14	Táborsko	30	36	46	33
15	Vitkovice	30	35	52	30
16	Frýdek-Mís	30	26	54	27

TEMPORADA 2016/2017

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Sigma	30	59	22	69
2	Baník	30	48	20	64
3	SFC Opava	30	61	33	63
4	Vlašim	30	61	34	54
5	České	30	39	31	46
6	Znojmo	30	49	47	41
7	Viktoria	30	49	41	39
8	Pardubice	30	31	33	39
9	Viagem	30	34	41	37
10	Táborsko	30	38	48	36
11	Varnsdorf	30	44	46	35
12	Třinec	30	40	52	34
13	Baník	30	28	44	32
14	Vitkovice	30	35	47	31
15	Frýdek-Mís	30	40	57	29
16	Prostějov	30	20	80	12

TEMPORADA 2015/2016

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Karviná	28	50	17	59
2	Hradec	28	45	16	59
3	Znojmo	28	62	33	56
4	Baník	28	32	26	41
5	Táborsko	28	39	34	39
6	Pardubice	28	29	29	38
7	Vlašim	28	35	33	35
8	Viagem	28	39	38	35
9	Varnsdorf	28	35	44	34
10	Frýdek-Mís	28	30	37	33
11	SFC Opava	28	34	37	32
12	České	28	41	48	32
13	Třinec	28	29	41	27
14	Sigma	28	23	49	21
15	Slavoj	28	20	61	20

TEMPORADA 2014/2015

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Viktoria	30	70	24	72
2	Sparta Praha	30	57	20	67
3	Jablonec	30	58	22	64
4	Mladá	30	43	34	46
5	Pribram	30	40	45	43
6	Dukla Praha	30	34	40	41
7	Teplice	30	41	37	38
8	Bohemians	30	35	41	38
9	Slovácko	30	43	46	37
10	Vysocina	30	33	38	36
11	Slavia Praha	30	40	45	34
12	Slovan	30	39	43	33
13	Baník	30	23	41	33
14	Zbrojovka	30	34	45	33
15	Hradec	30	26	52	25
16	České	30	29	72	22

TEMPORADA 2013/2014

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	České	30	57	20	62
2	Hradec	30	54	27	61
3	Táborsko	30	46	27	59
4	Varnsdorf	30	42	31	47
5	Viktoria	30	39	30	47
6	Baník	30	33	37	46
7	Karviná	30	46	37	45
8	Viagem	30	38	37	43
9	Třinec	30	37	44	39
10	Trinity	30	33	30	37
11	Mostecký	30	34	46	37
12	Vlašim	30	29	46	36
13	Pardubice	30	30	34	34
14	Frýdek-Mís	30	33	40	34
15	Bohemians	30	30	66	22
16	Loko Vltavin	30	25	54	20

TEMPORADA 2012/2013

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Viktoria	30	54	21	65
2	Sparta Praha	30	55	23	63
3	Slovan	30	46	34	54
4	Jablonec	30	49	41	49
5	Sigma	30	38	29	47
6	Dukla Praha	30	48	37	46
7	Slavia Praha	30	41	33	42
8	Mladá	30	34	43	38
9	Slovácko	30	37	41	37
10	Vysocina	30	36	42	36
11	Pribram	30	27	39	32
12	Teplice	30	36	47	32
13	Zbrojovka	30	34	53	32
14	Baník	30	34	44	29
15	České	30	24	49	26
16	Hradec	30	27	44	25

TEMPORADA 2011/2012

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Slovan	30	68	29	66
2	Sparta Praha	30	51	25	64
3	Viktoria	30	66	33	63
4	Mladá	30	49	34	50
5	Teplice	30	36	30	46
6	Dukla Praha	30	42	35	42
7	Slovácko	30	29	32	41
8	Jablonec	30	54	43	40
9	Pribram	30	44	56	39
10	České	30	30	51	35
11	Sigma	30	42	38	34
12	Slavia Praha	30	28	34	34
13	Hradec	30	22	38	31
14	Baník	30	31	48	28
15	Bohemians	30	20	54	24
16	Viktoria	30	23	55	19

TEMPORADA 2010/2011

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Viktoria	30	70	28	69
2	Sparta Praha	30	54	21	68
3	Jablonec	30	65	34	58
4	Sigma	30	47	29	47
5	Mladá	30	49	40	46
6	Bohemians	30	33	33	43
7	Slovan	30	45	36	43
8	Hradec	30	26	36	41
9	Slavia Praha	30	41	36	40
10	Teplice	30	39	46	39
11	České	30	30	48	33
12	Slovácko	30	27	43	31
13	Pribram	30	22	36	31
14	Baník	30	31	46	30
15	Zbrojovka	30	33	55	24
16	Viagem	30	22	67	19

TEMPORADA 2009/2010

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Sparta Praha	30	42	14	62
2	Jablonec	30	42	24	61
3	Baník	30	47	25	60
4	Teplice	30	44	25	55
5	Viktoria	30	42	33	48
6	Sigma	30	49	36	47
7	Slavia Praha	30	37	35	41
8	Mladá	30	47	41	39
9	Slovan	30	34	39	37
10	Pribram	30	35	41	36
11	Zbrojovka	30	31	40	35
12	Bohemians	30	21	29	34
13	České	30	24	35	31
14	Slovácko	30	28	42	30
15	SK Kladno	30	24	50	25
16	Bohemians	30	27	65	1

TEMPORADA 2008/2009

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Slavia Praha	30	57	25	62
2	Sparta Praha	30	48	25	56
3	Slovan	30	41	28	52
4	Sigma	30	39	36	48
5	Jablonec	30	43	37	46
6	Mladá	30	39	38	46
7	Teplice	30	33	25	43
8	Viktoria	30	45	38	43
9	Baník	30	38	36	39
10	České	30	30	37	36
11	Zbrojovka	30	32	36	35
12	Pribram	30	30	40	34
13	Bohemians	30	33	46	34
14	SK Kladno	30	21	41	31
15	Trinity	30	26	49	29
16	Viktoria	30	27	45	22

TEMPORADA 2007/2008

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Slavia Praha	30	45	24	60
2	Sparta Praha	30	53	26	57
3	Baník	30	51	28	55
4	Zbrojovka	30	43	32	55
5	Teplice	30	40	27	53
6	Slovan	30	35	31	44
7	Mladá	30	37	36	42
8	Trinity	30	28	31	38
9	Viktoria	30	32	37	38
10	Viktoria	30	35	48	37
11	Sigma	30	20	26	36
12	Jablonec	30	24	32	33
13	České	30	27	35	32
14	SK Kladno	30	31	45	27
15	Bohemians	30	24	40	26
16	Mostecký	30	31	58	20

TEMPORADA 2006/2007

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Sparta Praha	30	44	20	62
2	Slavia Praha	30	44	23	58
3	Mladá	30	48	27	58
4	Slovan	30	44	22	58
5	Zbrojovka	30	34	32	46
6	Viktoria	30	35	29	46
7	Baník	30	43	33	46
8	Teplice	30	44	39	42
9	Jablonec	30	31	32	38
10	České	30	28	46	34
11	SK Kladno	30	23	37	31
12	Mostecký	30	31	41	31
13	Trinity	30	21	34	27
14	Sigma	30	29	43	26
15	Pribram	30	15	37	21
16	Slovácko	30	20	39	19

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

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Sparta Praha	30	53	28	64
2	Slavia Praha	30	39	25	53
3	Teplice	30	36	27	53
4	Sigma	30	39	34	51
5	Slovan	30	45	26	46
6	Jablonec	30	33	27	45
7	Baník	30	33	36	37
8	Drnovice	30	30	34	35
9	Pribram	30	30	41	35
10	Trinity	30	29	35	33
11	Zbrojovka	30	30	42	33
12	Chmel	30	25	38	32
13	Slovácko	30	30	22	32
14	Mladá	30	26	35	31
15	České	30	28	39	25
16	SFC Opava	30	25	42	18

TEMPORADA 2003/2004

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Baník	30	60	25	63
2	Sparta Praha	30	48	24	58
3	Sigma	30	43	24	55
4	Slavia Praha	30	43	24	52
5	Synot	30	43	37	48
6	Slovan	30	38	27	46
7	Trinity	30	31	39	41
8	České	30	38	38	40
9	Teplice	30	32	32	39
10	Jablonec	30	27	32	38
11	Pribram	30	33	37	37
12	SFC Opava	30	34	55	31
13	Chmel	30	34	54	30
14	Zbrojovka	30	33	43	30
15	Viktoria	30	18	34	27
16	Viktoria	30	23	53	19

TEMPORADA 2002/2003

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Sparta Praha	30	51	17	65
2	Slavia Praha	30	65	19	64
3	Viktoria	30	38	33	50
4	Slovan	30	43	36	50
5	Baník	30	41	38	45
6	Teplice	30	33	32	45
7	Trinity	30	34	41	42
8	Synot	30	39	40	40
9	Zbrojovka	30	35	31	39
10	Pribram	30	34	30	39
11	Sigma	30	29	33	34
12	Jablonec	30	29	39	34
13	České	30	36	54	30
14	Chmel	30	28	39	28
15	Bohemians	30	34	56	24
16	Hradec	30	23	54	22

TEMPORADA 2001/2002

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	České	30	58	20	66
2	Trinity	30	56	24	64
3	Mladá	30	40	29	52
4	Viktoria	30	56	34	50
5	Pardubice	30	39	30	46
6	Xaverov	30	44	36	46
7	Vysocina	30	47	46	42
8	Vitkovice	30	38	38	40
9	HFK Olomouc	29	36	39	37
10	Mostecký	30	36	37	36
11	Prostějov	30	33	34	36
12	Sigma	29	33	53	34
13	Chomutov	30	30	50	34
14	Neratovice-B	30	33	39	30
15	FK Kolín	30	22	56	21
16	Ratiskovice	30	19	55	21

TEMPORADA 2000/2001

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Sparta Praha	30	71	31	68
2	Slavia Praha	30	46	32	52
3	Sigma	30	47	33	52
4	Pribram	30	40	26	51
5	Viktoria	30	45	40	46
6	Slovan	30	39	31	45
7	Drnovice	30	35	36	41
8	Bohemians	30	33	34	40
9	Teplice	30	45	39	40
10	Chmel	30	35	35	40
11	Synot	30	37	35	37
12	Jablonec	30	26	40	32
13	Zbrojovka	30	24	35	30
14	Baník	30	28	45	30
15	České	30	32	56	26
16	Viktoria	30	30	65	21

TEMPORADA 1999/2000

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Sparta Praha	30	81	23	76
2	Slavia Praha	30	53	25	68
3	Drnovice	30	36	32	48
4	Zbrojovka	30	35	33	42
5	Teplice	30	38	38	41
6	Pribram	30	33	36	40
7	Bohemians	30	24	28	40
8	Slovan	30	21	24	38
9	Viktoria	30	37	41	37
10	Chmel	30	28	45	37
11	Baník	30	43	45	35
12	Sigma	30	31	38	34
13	Jablonec	30	24	36	32
14	České	30	34	49	32
15	SFC Opava	30	31	39	28
16	Hradec	30	21	38	23

Competiciones que juega

Grupo 1

2. Liga Checa

Pos	Equipos		Pts
1		České Budějovice	72
2		Vysocina Jihlava	58
3		Zbrojovka Brno	57
4		Hradec Králové	53
5		FK Viagem Ústí nad Labem	49
6		Varnsdorf	48
7		Pardubice	44
8		Vitkovice	40
9		Třinec	36
10		Prostějov	36
11		Baník Sokolov	33
12		Vlašim	32
13		Chrudim	29
14		Viktoria Žižkov	27
15		FC Táborsko	25
16		Znojmo	25

	Ascenso : České Budějovice
	Playoff Ascenso : Vysocina Jihlava, Zbrojovka Brno
	Descenso : FC Táborsko, Znojmo

RIVALES EN Copa Checa

RIVALES EN 2. Liga Checa

USO DE MEMORIA

7,720,912 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6550
Total Execution Time	0.6562

CADENA URL

/historico/Eske-Bud-Jovice/2019

GET DATOS

$_GET['/historico/Eske-Bud-Jovice/2019']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0191	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 = 'Eske-Bud-Jovice' AND l.year = 2019 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.0132	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=10051 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132	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=10051 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=10051 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=10051 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10051 AND type_rel = 2
0.0139	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 = '10051' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0134	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 = '10051' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0141	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=10051 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0133	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 (56780,50426,49506,44039) 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.0144	SELECT count(id) as num_players from rel_players WHERE league_id = 56780 AND teamId = 10051
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 44039 AND teamId = 10051
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 50426 AND teamId = 10051
0.0225	SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 10051
0.0127	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 = '10051' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10051' and rp.type = 4
0.0127	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 = '10051' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0142	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 events2019 e ON e.player_id = p.id AND e.league_id = 44039 WHERE rp.league_id = 44039 AND rp.teamId = 10051 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.0143	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 events2019 e ON e.player_id = p.id AND e.league_id = 44039 WHERE rp.league_id = 44039 AND rp.teamId = 10051 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136	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 events2019 e ON e.player_id = p.id AND e.league_id = 44039 WHERE rp.league_id = 44039 AND rp.teamId = 10051 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134	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 = 10051 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129	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.0128	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 = 38788 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 33332 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 15518 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 3883 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 2835 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 2041 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 1355 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 1083 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 865 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 243 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 8741 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 8745 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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.0132	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 = 8749 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 8750 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 8751 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 8775 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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* `tables2001` 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 = 8753 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

České Budějovice

České Budějovice

Selecciona un equipo

Competiciones que juega

2. Liga Checa

RIVALES EN Copa Checa

RIVALES EN 2. Liga Checa