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 E

Eliminatoria

4. Liga Checa 2020 G 5

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Slavičín	1	3	0	3
2	Skaštice	1	5	3	3
3	FC Vsetín	1	3	1	3
4	Bzenec	1	2	1	3
5	HFK Olomouc	1	2	1	3
6	Přerov	1	2	1	3
7	Hranice	1	1	1	1
8	Kozlovice	1	1	1	1
9	Hodonín-Ša	1	1	2	0
10	Šumperk	1	1	2	0
11	Tatran	1	1	2	0
12	Brumov	1	3	5	0
13	FC Strani	1	1	3	0
14	Nove Sady	1	0	3	0

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Slavičín	30	68	35	65
2	Frýdlant	30	54	27	59
3	Nový	30	68	36	58
4	Hranice	30	71	43	50
5	Opava II	30	66	37	49
6	Bohumin	30	70	58	49
7	Kozlovice	30	49	39	47
8	Bruntal	30	46	41	47
9	Havířov	30	45	55	44
10	FC Vsetín	30	48	53	38
11	Heřmanice	30	56	69	38
12	Detmarovice	30	62	67	36
13	HFK Olomouc	30	39	59	30
14	Šumperk	30	35	59	28
15	Přerov	30	29	69	19
16	Sokol Ústí	30	23	82	12

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Dolní	30	55	32	60
2	Havířov	30	75	41	59
3	Kozlovice	30	65	36	59
4	Nový	30	53	29	55
5	Sokol Ústí	30	64	41	55
6	Opava II	30	60	33	54
7	Slavičín	30	62	42	50
8	Frýdlant	30	44	47	43
9	Nove Sady	30	39	50	41
10	Bohumin	30	49	47	37
11	FC Vsetín	30	31	35	37
12	Jeseník	30	41	69	30
13	Hranice	30	30	60	27
14	Lokomotiva	30	40	61	25
15	Šternberk	30	39	72	21
16	Brumov	30	27	79	20

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Valašské	30	66	33	67
2	Jiskra	30	64	34	60
3	Havířov	30	47	40	52
4	Nový	30	64	49	49
5	Dolní	30	50	41	45
6	Jeseník	30	56	63	42
7	Hranice	30	46	53	41
8	Kozlovice	30	47	51	40
9	Šumperk	30	52	52	39
10	Lokomotiva	30	38	50	38
11	Frýdlant	30	40	44	37
12	Nove Sady	30	40	45	37
13	Opava II	30	36	50	37
14	Pustá Polom	30	35	42	36
15	Přerov	30	36	49	33
16	Velké	30	26	47	21

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	Odra	30	53	29	64
2	Lokomotiva	30	54	23	55
3	Slavičín	30	50	31	53
4	Valašské	30	50	36	51
5	Nový	30	46	32	49
6	Jiskra	30	58	40	46
7	Nove Sady	30	51	47	41
8	Dolní	30	41	47	41
9	Opava II	30	44	42	38
10	Hranice	30	48	48	37
11	Brumov	30	33	59	36
12	Havířov	30	37	56	35
13	Velké	30	25	37	34
14	Frýdlant	30	36	61	33
15	Krnov	30	34	54	31
16	FC Vsetín	30	28	46	28

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Mohelnice	30	53	25	59
2	Vitkovice	30	62	34	57
3	Slavičín	30	53	39	54
4	Brumov	30	58	41	51
5	Hranice	30	58	41	47
6	Lokomotiva	30	37	41	46
7	Nový	30	47	43	45
8	Havířov	30	51	52	42
9	Jiskra	30	53	45	41
10	Valašské	30	44	51	39
11	Kozlovice	30	56	60	38
12	Přerov	30	41	51	38
13	Dolní	30	43	53	31
14	REAL	30	37	68	31
15	Velké	30	29	49	28
16	Sokol	30	32	61	24

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	REAL	30	60	38	53
2	Opava II	30	53	44	51
3	Slavičín	30	43	38	49
4	Dolní	30	59	45	48
5	Mohelnice	30	37	26	48
6	Havířov	30	47	57	44
7	Lokomotiva	30	47	36	43
8	Brumov	30	44	49	42
9	Nový	30	41	50	41
10	Sokol	30	35	41	38
11	FC Zlínsko	30	46	39	37
12	Přerov	30	42	45	37
13	Hranice	30	36	42	37
14	Valašské	30	50	59	36
15	Karviná II	30	42	50	35
16	Šumperk	30	33	56	26

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Mikulovice	30	44	33	56
2	Přerov	30	52	41	47
3	Opava II	30	56	43	46
4	Hranice	30	44	43	46
5	Valašské	30	54	53	45
6	Šumperk	30	51	41	43
7	Mohelnice	30	44	41	41
8	Brumov	30	41	40	40
9	Havířov	30	43	45	40
10	Slavičín	30	49	52	40
11	Lokomotiva	30	35	42	40
12	Nový	30	46	37	39
13	REAL	30	34	36	38
14	Karviná II	30	42	48	36
15	Kravaře	30	43	50	35
16	Morkovice	30	29	62	29

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	Slavia	30	62	29	66
2	Prostějov	30	62	26	64
3	Mikulovice	30	70	52	55
4	Šumperk	30	56	36	53
5	Mohelnice	30	53	49	50
6	Brumov	30	43	52	42
7	Lokomotiva	30	41	44	40
8	REAL	30	46	47	39
9	Kravaře	30	46	52	37
10	Opava II	30	49	61	36
11	Valašské	30	45	59	36
12	Slavičín	30	50	46	35
13	Havířov	30	47	51	35
14	Nový	30	52	69	33
15	Dolní	30	26	58	30
16	Krnov	30	45	62	27

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	Zlín II	30	81	34	61
2	Jakubcovice	30	47	22	60
3	Spartak	30	47	24	54
4	Mikulovice	30	60	41	53
5	Šumperk	30	44	30	51
6	Dolní	30	39	46	44
7	Opava II	30	47	43	43
8	Valašské	30	54	64	40
9	Slavia	30	47	45	39
10	Havířov	30	42	45	38
11	Brumov	30	45	53	38
12	Poruba	30	46	60	37
13	Kravaře	30	35	54	31
14	Jiskra	30	46	61	26
15	Hranice	30	44	78	26
16	Lázne	30	46	70	24

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	Slavičín	30	69	29	63
2	Šumperk	30	62	26	63
3	Lázne	30	70	43	58
4	Slavia	30	46	31	52
5	Brumov	30	60	51	47
6	Mesto	30	39	50	42
7	Havířov	30	40	41	41
8	Poruba	30	44	46	41
9	Dolní	30	46	48	40
10	Jiskra	30	46	46	35
11	Kravaře	30	32	43	35
12	Valašské	30	51	67	34
13	Hranice	30	40	66	34
14	Bystrice	30	29	46	31
15	Velké	30	34	52	27
16	Beskyd	30	27	50	22

Ver

TEMPORADA 2007/2008

Equipo		PJ	GF	GC	Puntos
1	Baník	30	70	19	69
2	Kravaře	30	45	25	51
3	Slavičín	30	64	33	49
4	Jiskra	30	56	48	43
5	Beskyd	30	39	32	42
6	Hranice	30	49	48	40
7	Lázne	30	42	51	40
8	Slavia	30	29	32	39
9	Brumov	30	41	53	39
10	Bystrice	30	30	32	38
11	Napajedla	30	42	50	38
12	Havířov	30	33	44	37
13	Mesto	30	35	51	37
14	Velké	30	29	43	36
15	Bohuslavice	30	34	46	34
16	FC Vsetín	30	29	60	24

Ver

TEMPORADA 2006/2007

Equipo		PJ	GF	GC	Puntos
1	Kromeriz	30	77	22	73
2	Detmarovice	30	54	38	52
3	Spartak	30	56	27	51
4	Napajedla	30	42	35	50
5	Slavičín	30	64	34	48
6	Jiskra	30	46	59	42
7	FC Zlínsko	30	40	36	40
8	Slavia	30	38	35	40
9	Kravaře	30	44	47	40
10	Bystrice	30	45	49	38
11	Velké	30	40	56	38
12	Beskyd	30	34	45	35
13	Mesto	30	36	44	32
14	Banik	30	39	56	31
15	Cesky Tesin	30	45	79	28
16	Lokomotiva	30	36	74	20

Ver

TEMPORADA 2005/2006

Equipo		PJ	GF	GC	Puntos
1	Fulnek	30	77	23	75
2	Frýdek-Mís	30	80	26	68
3	Karviná	30	56	32	52
4	Sokol Konice	30	48	32	52
5	Cesky Tesin	30	46	43	48
6	Zábřeh	30	61	43	46
7	Mesto	30	38	40	43
8	Velké	30	46	49	43
9	Beskyd	30	40	43	43
10	Slavia	30	39	30	42
11	Kravaře	30	32	34	39
12	Detmarovice	30	35	45	35
13	Banik	30	31	45	33
14	Nove Sady	30	34	75	25
15	Horka	30	24	70	16
16	Lázne	30	27	84	11

Ver

TEMPORADA 2004/2005

Equipo		PJ	GF	GC	Puntos
1	Jakubcovice	30	69	22	67
2	Kravaře	30	44	29	55
3	Zábřeh	30	49	31	51
4	Opava II	30	60	43	51
5	Karviná	30	59	51	50
6	Slavia	30	42	29	44
7	Velké	30	45	51	44
8	Cesky Tesin	30	38	40	41
9	Frýdek-Mís	30	43	56	38
10	Mesto	30	41	48	36
11	Nove Sady	30	39	57	35
12	Detmarovice	30	34	39	34
13	Lázne	30	45	61	33
14	Banik	30	34	39	31
15	Mikulovice	30	36	57	31
16	1. Valassky	30	43	68	27

Ver

TEMPORADA 2003/2004

Equipo		PJ	GF	GC	Puntos
1	Hlučín	30	83	25	68
2	Opava II	30	65	21	64
3	Zábřeh	30	47	28	61
4	1. Valassky	30	71	35	57
5	Mokre Lazce	30	46	32	47
6	Cesky Tesin	30	35	34	42
7	Slavia	30	40	48	42
8	Kravaře	30	45	49	37
9	Mesto	30	45	58	36
10	Kralova	30	46	52	35
11	Detmarovice	30	31	55	35
12	Banik	30	28	43	34
13	Lázne	30	40	59	34
14	Lipnik	30	37	52	33
15	Valašské	30	38	73	30
16	Jiskra	30	35	68	24

Equipos de esta liga

USO DE MEMORIA

6,738,792 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.5030
Total Execution Time	0.5049

CADENA URL

/4_liga_republica_checa2020/grupo5/historico

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0108	SELECT type FROM routes WHERE alias = '4_liga_republica_checa2020'
0.0225	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 = 5 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=5 DESC LIMIT 1
0.0106	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1523 AND type_rel = 3
0.0108	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.0107	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.0106	SELECT id,name,alias,stepParent FROM categories WHERE parentId=1523 ORDER BY order_id ASC
0.0112	SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1523 GROUP BY l.categoryId
0.0110	SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1523 GROUP BY l.year ORDER BY l.year DESC
0.0108	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 = 50445 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1523 AND group_code = 5 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0110	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 = 50445 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.0113	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 = 44438 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 39719 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 33750 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 16003 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 9187 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 25088 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 25098 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 25124 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107	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 = 25113 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 25134 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 25140 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 27580 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 27588 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 27597 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 27605 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 27614 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 20:50:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 20:50:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 20:50:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 20:50:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0121	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.0117	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 = 50445 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50445 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.0112	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 = 50445 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50445 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0109	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 = 50445 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50445 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0120	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 = 50445 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