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

Resultados de Fútbol

Pribram

Entrenador: Roman Bednar

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	25	45	41	37
6	Sparta Praha	25	45	41	35
7	Vlašim	25	34	30	35
8	SK Líšeň	25	29	30	33
9	SFC Opava	25	27	29	33
10	Pribram	25	28	37	33
11	Zbrojovka	25	32	34	31
12	Vysocina	25	35	36	30
13	Viktoria	25	36	45	29
14	Varnsdorf	25	42	42	28
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

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Slavia Praha	34	85	20	86
2	Sparta Praha	34	82	43	74
3	Jablonec	34	59	33	69
4	Slovácko	34	58	33	63
5	Viktoria	34	60	45	58
6	Slovan	34	44	32	52
7	Pardubice	34	41	42	52
8	Baník	34	48	38	49
9	Sigma	34	40	40	45
10	Bohemians	34	40	37	43
11	Mladá	34	49	54	39
12	Karviná	34	37	49	39
13	České	34	33	47	38
14	Trinity	34	30	50	32
15	Teplice	34	34	66	30
16	Zbrojovka	34	33	57	26
17	Pribram	34	26	65	25
18	SFC Opava	34	23	71	17

TEMPORADA 2019/2020

LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Sigma	3	3	3	40
2	Teplice	3	8	2	38
3	Trinity	3	5	5	33
4	Karviná	3	2	7	27
5	Pribram	3	2	1	25
6	SFC Opava	3	1	3	25

TEMPORADA 2018/2019

LIGA CHECA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Slovácko	5	11	2	45
2	SFC Opava	5	8	8	43
3	Pribram	5	10	10	40
4	Bohemians	5	4	6	40
5	Karviná	5	3	5	32
6	Dukla Praha	5	5	10	22

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

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Slavia Praha	30	65	22	69
2	Viktoria	30	47	21	67
3	Sparta Praha	30	47	26	57
4	Mladá	30	47	37	49
5	Teplice	30	38	25	48
6	Trinity	30	34	35	41
7	Dukla Praha	30	39	35	40
8	Jablonec	30	43	38	39
9	Slovan	30	31	28	39
10	Karviná	30	39	49	34
11	Slovácko	30	29	38	32
12	Zbrojovka	30	32	45	32
13	Bohemians	30	22	39	28
14	Vysocina	30	26	47	27
15	Hradec	30	29	51	27
16	Pribram	30	29	61	22

TEMPORADA 2015/2016

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Viktoria	30	57	25	71
2	Sparta Praha	30	61	24	64
3	Slovan	30	51	35	58
4	Mladá	30	63	37	57
5	Slavia Praha	30	48	26	52
6	Zbrojovka	30	37	38	47
7	Jablonec	30	46	39	41
8	Slovácko	30	37	51	40
9	Bohemians	30	35	37	37
10	Dukla Praha	30	44	41	35
11	Vysocina	30	31	54	31
12	Teplice	30	37	52	30
13	Trinity	30	34	50	30
14	Sigma	30	35	49	27
15	Pribram	30	33	53	27
16	Baník	30	27	65	14

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	Zbrojovka	30	34	45	33
14	Baník	30	23	41	33
15	Hradec	30	26	52	25
16	České	30	29	72	22

TEMPORADA 2013/2014

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Sparta Praha	30	78	19	79
2	Viktoria	30	64	21	66
3	Mladá	30	54	38	50
4	Slovan	30	37	46	48
5	Teplice	30	51	35	46
6	Slovácko	30	43	40	40
7	Dukla Praha	30	35	37	38
8	Vysocina	30	45	50	37
9	Zbrojovka	30	32	42	37
10	Baník	30	33	43	35
11	Jablonec	30	43	53	34
12	Pribram	30	34	49	34
13	Slavia Praha	30	24	51	30
14	Bohemians	30	26	40	30
15	Sigma	30	42	60	29
16	Znojmo	30	32	49	27

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	Teplice	30	36	47	32
12	Pribram	30	27	39	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	Slovan	30	45	36	43
7	Bohemians	30	33	33	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	Pribram	30	22	36	31
13	Slovácko	30	27	43	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	0

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

2. LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Bohemians	30	46	38	53
2	Pribram	30	33	18	52
3	SFC Opava	30	46	31	50
4	Hradec	30	34	24	50
5	Slovácko	30	40	27	48
6	Fulnek	29	34	34	46
7	Vysocina	30	42	35	43
8	HFK Olomouc	30	33	38	41
9	Baník	30	26	24	40
10	Vitkovice	30	35	41	36
11	FK Caslav	30	37	44	33
12	Dukla Praha	30	36	44	33
13	Viagem	29	33	42	33
14	Třinec	29	22	38	33
15	Hlučín	30	26	35	30
16	Sparta Krč	29	26	36	24

TEMPORADA 2006/2007

LIGA CHECA
Equipo		PJ	GF	GC	Puntos
1	Sparta Praha	30	44	20	62
2	Slovan	30	44	22	58
3	Mladá	30	48	27	58
4	Slavia Praha	30	44	23	58
5	Baník	30	43	33	46
6	Viktoria	30	35	29	46
7	Zbrojovka	30	34	32	46
8	Teplice	30	44	39	42
9	Jablonec	30	30	30	38
10	České	30	28	46	34
11	Mostecký	30	29	40	31
12	SK Kladno	30	23	37	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

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

BENCHMARKS

Loading Time Base Classes	0.0017
Controller Execution Time ( Home / Category )	0.1359
Total Execution Time	0.1376

CADENA URL

/historico/P-Ibram

GET DATOS

$_GET['/historico/P-Ibram']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0044	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 = 'P-Ibram' 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.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=10048 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=10048 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=10048 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=10048 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0044	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72248
0.0026	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 = 72506
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10048 AND type_rel = 2
0.0019	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10048 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	SELECT /35 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 (59209,69600,71127,536476,729613) ORDER BY n.cover_points DESC, update_date DESC
0.0029	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 = '10048' ORDER BY l.year DESC,cat.coefficient DESC
0.0025	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '10048' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0032	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 = '10048' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72506 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	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=10048 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	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,72248,71877,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 = 10048
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 72506 AND teamId = 10048
0.0046	SELECT count(id) as num_players from rel_players WHERE league_id = 71877 AND teamId = 10048
0.0029	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 10048
0.0020	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 = '10048' 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 = '10048' and rp.type = 4
0.0020	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 = '10048' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034	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 = 10048 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.0032	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 = 10048 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0044	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 = 10048 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 10048 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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* `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 = 49596 AND t.round = 5 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* `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.0023	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 33331 AND t.round = 30 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* `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.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* `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.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 = 8766 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

Pribram

Pribram

Selecciona un equipo

Competiciones que juega

2. Liga Checa

RIVALES EN Copa Checa

RIVALES EN 2. Liga Checa