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

2019/2020

División D

Eliminatoria

4. Liga Checa 2020 G 4

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Sokol	1	5	0	3
2	Start Brno	1	4	0	3
3	Sokol	1	5	3	3
4	Zbrojovka	1	2	0	3
5	Ždírec	1	2	0	3
6	Vysocina	1	3	2	3
7	Humpolec	1	2	1	3
8	Žďár	1	2	3	0
9	Břeclav	1	1	2	0
10	Havlíčkův	1	3	5	0
11	Stará	1	0	2	0
12	Spartak	1	0	2	0
13	Slavoj	1	0	4	0
14	Bystřice	1	0	5	0

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Blansko	28	95	20	78
2	Slovan	28	74	20	65
3	Stará	28	74	31	55
4	Sokol	28	69	33	54
5	Žďár	28	53	35	50
6	Sokol	28	62	31	48
7	Slavoj	28	51	48	41
8	Spartak	28	56	55	40
9	Bzenec	28	43	53	36
10	FC Strani	28	38	44	32
11	Ždírec	28	26	45	30
12	Břeclav	28	35	62	25
13	Humpolec	28	29	60	23
14	Havlíčkův	28	31	74	21
15	Nove Sady	28	25	77	21
16	Bystrc	28	20	93	10

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Vrchovina	29	60	30	63
2	Slovan	29	72	26	54
3	Žďár	27	59	31	52
4	Sokol	29	51	48	48
5	Šumperk	29	53	39	46
6	Stará	29	48	38	46
7	Bzenec	27	62	54	42
8	Slavoj	28	60	57	41
9	Ždírec	29	27	35	40
10	Břeclav	29	39	43	38
11	Blansko	29	31	38	33
12	Spartak	28	38	52	31
13	FC Strani	29	41	59	27
14	Tišnov	11	25	4	24
15	Havlíčkův	29	35	80	24
16	Třebíč	29	29	96	10

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Hodonín-Ša	30	90	34	73
2	Uhersky Brod	30	70	29	73
3	Slovan	30	50	23	57
4	Slavičín	30	39	24	48
5	Sokol	30	54	49	48
6	Břeclav	30	44	46	46
7	Slavoj	30	70	67	45
8	Bzenec	30	59	63	39
9	Vrchovina	30	36	50	36
10	Brumov	30	46	59	33
11	Stará	30	35	55	33
12	Spartak	30	43	55	32
13	Holešov	30	49	60	31
14	Žďár	30	42	53	31
15	Bystřice	30	46	68	31
16	Pelhřimov	30	24	62	18

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	Blansko	30	55	34	57
2	Hodonín-Ša	30	69	42	56
3	Kozlovice	30	52	35	51
4	Uhersky Brod	30	48	39	50
5	Sokol	30	50	41	48
6	Slovan	30	54	37	45
7	Stará	30	50	39	45
8	Slavoj	30	43	56	42
9	Šumperk	30	44	46	39
10	Přerov	30	39	45	37
11	Vrchovina	30	36	47	37
12	Pelhřimov	30	39	61	36
13	Žďár	30	34	39	34
14	Bystřice	30	49	59	34
15	Ždírec	30	36	54	28
16	Havlíčkův	30	34	58	27

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Velké	30	65	23	66
2	FC Zlínsko	30	59	40	52
3	Vrchovina	30	44	30	51
4	Havlíčkův	30	49	42	49
5	Stará	30	37	39	47
6	Hodonín-Ša	30	55	34	46
7	Bystřice	30	47	45	40
8	Slovan	30	45	39	39
9	Sokol	30	38	53	37
10	Slavoj	30	55	52	36
11	Pelhřimov	30	40	47	36
12	Žďár	30	37	45	36
13	Uhersky Brod	30	38	47	33
14	Blansko	30	34	52	33
15	Napajedla	30	46	72	27
16	Mutenice	30	34	63	27

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	Vyškov	30	70	31	66
2	Slovan	30	65	34	65
3	Vrchovina	30	40	37	53
4	SK Líšeň	30	59	32	49
5	Blansko	30	53	50	42
6	Velké	30	43	48	41
7	Bystřice	30	40	48	39
8	Pelhřimov	30	60	57	38
9	Slavoj	30	51	57	38
10	Stará	30	43	58	36
11	Hodonín-Ša	30	37	41	35
12	Uhersky Brod	30	28	48	35
13	Napajedla	30	36	47	34
14	Sokol	30	46	53	33
15	Bystrc	30	48	60	31
16	Tatran Brno	30	37	55	29

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Třebíč	26	46	13	58
2	SK Líšeň	26	52	27	52
3	Napajedla	27	50	35	43
4	Velké	26	43	41	39
5	FC Zlínsko	26	41	37	36
6	Bystřice	26	44	50	33
7	Slavoj	27	36	43	33
8	Vyškov	26	29	25	32
9	Vrchovina	26	28	34	32
10	Pelhřimov	26	36	46	32
11	Bystrc	26	35	53	32
12	Sokol	26	36	46	31
13	Hodonín-Ša	26	28	32	30
14	Slovácká	26	30	50	27
15	Tatran Brno	26	43	45	26
16	Vracov	0	0	0	0

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	Žďár	30	59	25	66
2	Napajedla	30	48	33	50
3	Bystrc	30	44	28	48
4	Třebíč	30	55	34	47
5	Vrchovina	30	34	38	46
6	Vyškov	30	36	34	43
7	Sokol	30	55	54	43
8	Slovácká	30	43	56	43
9	Slavoj	30	51	46	41
10	Pelhřimov	30	40	41	41
11	Přerov	30	45	50	36
12	Hodonín-Ša	30	37	55	35
13	Velké	30	41	43	34
14	Tatran Brno	30	49	56	34
15	FC Zlínsko	30	33	48	34
16	Sparta Brno	30	31	60	27

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos
1	Slovan	30	62	35	53
2	FC Zlínsko	30	54	35	53
3	Pelhřimov	30	60	44	52
4	Vyškov	30	44	27	50
5	Hodonín-Ša	30	55	37	49
6	Třebíč	30	44	31	47
7	Žďár	30	61	48	46
8	Sokol	30	51	50	40
9	Bystrc	30	38	54	39
10	Velké	30	38	54	39
11	Vrchovina	30	26	30	38
12	Sparta Brno	30	33	45	34
13	Napajedla	30	43	50	32
14	Blansko	30	31	58	28
15	Uhersky Brod	30	28	55	28
16	Sokol Konice	30	34	49	26

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	Šardice	28	58	18	61
2	Slovácko	28	56	27	51
3	Žďár	28	47	35	49
4	Velké	28	35	47	42
5	Třebíč	28	40	36	39
6	Sokol Konice	28	35	39	39
7	Uhersky Brod	28	41	36	38
8	Slovan	28	38	42	37
9	Napajedla	28	38	44	37
10	Pelhřimov	28	35	40	36
11	FC Zlínsko	28	37	32	35
12	Vyškov	28	28	34	32
13	Blansko	28	39	50	31
14	Rousínov	28	30	42	29
15	Boskovice	28	32	67	18

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	SK Líšeň	30	63	24	68
2	Šardice	29	62	25	65
3	Spartak	29	57	21	56
4	Třebíč	30	42	23	51
5	Vyškov	30	45	34	47
6	FC Zlínsko	30	49	40	43
7	Sokol	30	35	36	39
8	Žďár	30	48	56	38
9	Sokol Konice	30	46	67	38
10	Velké	30	38	48	36
11	Rousínov	30	33	39	35
12	Napajedla	30	36	53	33
13	Boskovice	30	29	53	31
14	Ždírec	30	29	45	30
15	Rájec-Jestr	30	32	51	28
16	Mohelnice	30	33	62	25

Ver

TEMPORADA 2007/2008

Equipo		PJ	GF	GC	Puntos
1	Blansko	30	64	34	62
2	Žďár	30	63	41	59
3	Spartak	30	59	35	54
4	SK Líšeň	30	53	35	49
5	Velké	30	48	49	47
6	Sokol	30	48	38	46
7	Sokol Konice	30	50	40	44
8	FC Zlínsko	30	57	48	41
9	Vyškov	30	38	33	39
10	Třebíč	30	42	41	38
11	Rousínov	30	40	48	38
12	Rájec-Jestr	30	40	44	35
13	Boskovice	30	44	61	34
14	CAFC	30	30	46	33
15	Havlíčkův	30	37	70	25
16	Hrusovany	30	35	85	22

Ver

TEMPORADA 2006/2007

Equipo		PJ	GF	GC	Puntos
1	Zábřeh	30	56	23	65
2	SK Líšeň	30	56	27	58
3	Rousínov	30	42	28	53
4	Vyškov	30	51	37	44
5	Rájec-Jestr	30	37	32	44
6	Sokol Konice	30	47	37	42
7	Hrusovany	30	42	46	42
8	CAFC	30	34	47	40
9	Žďár	30	46	49	39
10	Velké	30	42	48	38
11	Třebíč	30	52	53	37
12	Boskovice	30	44	49	37
13	Sokol	30	32	47	36
14	Šardice	30	42	57	35
15	Hartvikovice	30	38	57	33
16	Morkovice	30	32	56	28

Ver

TEMPORADA 2005/2006

Equipo		PJ	GF	GC	Puntos
1	Mutenice	30	87	28	68
2	Hrusovany	30	55	34	51
3	Brumov	30	44	48	51
4	Morkovice	30	58	46	45
5	Žďár	30	54	52	44
6	Napajedla	30	37	35	44
7	Slavičín	30	40	33	43
8	Šardice	30	37	37	43
9	SK Líšeň	30	51	48	42
10	Velké	30	52	52	42
11	Třebíč	30	40	49	40
12	Rousínov	30	40	36	38
13	Vyškov	30	33	36	37
14	CAFC	30	44	67	31
15	Kyjov 1919	30	27	58	27
16	Ždírec	30	27	67	20

Ver

TEMPORADA 2004/2005

Equipo		PJ	GF	GC	Puntos
1	Vysocina	30	90	35	66
2	Břeclav	30	54	41	56
3	Mutenice	30	71	44	52
4	Napajedla	30	55	43	51
5	Slavičín	30	53	41	51
6	Brumov	30	51	48	50
7	Třebíč	30	42	44	45
8	Vyškov	30	44	39	44
9	Hrusovany	30	52	44	43
10	Horka	30	45	50	42
11	Ždírec	30	34	38	37
12	Rousínov	30	38	64	36
13	Kyjov 1919	30	48	49	33
14	Žďár	30	54	67	31
15	Lipnik	30	23	68	17
16	Prostějov	30	27	66	15

Ver

TEMPORADA 2003/2004

Equipo		PJ	GF	GC	Puntos
1	SK Lipová	30	76	35	66
2	Mutenice	30	45	20	64
3	Vysocina	30	57	42	51
4	Vyškov	30	69	40	46
5	Slavičín	30	47	36	46
6	Horka	30	51	52	44
7	Třebíč	30	53	56	42
8	Břeclav	30	36	39	42
9	Rousínov	30	40	48	39
10	Kyjov 1919	30	41	55	37
11	Ždírec	30	45	43	36
12	Napajedla	30	50	54	36
13	Brumov	30	33	59	34
14	Spartak	30	34	59	31
15	Morkovice	30	47	57	29
16	Uhersky Brod	30	36	65	22

Equipos de esta liga

USO DE MEMORIA

6,845,000 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.1143
Total Execution Time	0.1163

CADENA URL

/4_liga_republica_checa2020/grupo4/historico

GET DATOS

$_GET['/4_liga_republica_checa2020/grupo4/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0018	SELECT type FROM routes WHERE alias = '4_liga_republica_checa2020'
0.0039	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '4_liga_republica_checa' AND (l.group_code = 4 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=4 DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1523 AND type_rel = 3
0.0020	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.0018	SELECT id,name,alias,stepParent FROM categories WHERE parentId=1523 ORDER BY order_id ASC
0.0019	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 50444 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1523 AND group_code = 4 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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* `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 = 50444 AND t.round = 1 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 = 44437 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 39718 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* `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 = 33749 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 16002 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* `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 = 9186 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 25087 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 25096 AND t.round = 28 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* `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 = 25123 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* `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 = 25110 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 = 25131 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* `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 = 25139 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 = 27577 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 = 27586 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* `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 = 27594 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* `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 = 27604 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* `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 = 27612 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 21:58:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 21:58:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 21:58:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 21:58:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '4_liga_republica_checa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0027	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50444 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50444 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50444 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50444 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50444 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50444 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029	SELECT ,(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 = 50444 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC