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

ND Dravinja Kostroj

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA ESLOVENIA 2. SNL
Equipo		PJ	GF	GC	Puntos
1	Nafta	27	53	26	55
2	ND Gorica	26	46	20	51
3	Beltinci	26	39	18	50
4	Primorje	26	41	23	50
5	Brinje-Grosu	27	48	29	48
6	Triglav	27	42	27	48
7	Bistrica	26	39	38	38
8	Rudar	27	32	44	33
9	Dekani	27	28	33	30
10	ND Bilje	27	39	48	30
11	NK Tolmin	27	29	43	29
12	Dravinja	27	27	42	29
13	NK Krka	27	33	47	27
14	Ilirija 1911	27	27	41	25
15	Tabor	27	34	56	25
16	Fužinar	27	30	52	24

TEMPORADA 2022/2023

TERCERA ESLOVENIA 3. SNL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dravinja	25	48	20	51
2	Drava Ptuj	26	57	25	49
3	SD Videm	25	47	40	43
4	Dobrovce	25	40	37	42
5	Rače	25	49	38	41
6	Brežice	25	61	53	40
7	Podvinci	25	43	40	40
8	Zavrč	25	50	33	39
9	Šampion	25	52	36	38
10	Ljutomer	25	47	38	34
11	Cirkulane	25	19	35	27
12	Posavje	14	31	25	23
13	Smartno 1928	25	24	80	10
14	Dravograd	25	28	96	8

TEMPORADA 2021/2022

TERCERA ESLOVENIA 3. SNL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bistrica	26	81	21	57
2	Dravinja	26	54	27	53
3	Podvinci	26	51	35	44
4	Dravograd	26	59	49	44
5	Cirkulane	26	46	37	43
6	Smartno 1928	26	50	43	43
7	Šampion	26	53	45	40
8	Posavje	26	45	47	38
9	Zavrč	26	47	41	34
10	Dobrovce	26	47	55	30
11	SD Videm	26	42	60	29
12	Korotan	26	36	58	29
13	Šmarje	26	23	78	16
14	Zreče	26	28	66	13

TEMPORADA 2020/2021

TERCERA ESLOVENIA 3. SNL GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	NK Rogaška	5	12	6	12
2	Cirkulane	5	13	4	10
3	Bistrica	5	16	5	9
4	Dravinja	5	10	11	5
5	Dravograd	5	7	17	4
6	Zreče	5	1	16	2

TEMPORADA 2019/2020

TERCERA ESLOVENIA 3. SNL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Smartno 1928	11	37	19	26
2	Podvinci	11	22	9	22
3	Dravinja	11	41	20	20
4	Odranci	11	24	14	20
5	Zreče	11	20	16	19
6	Šampion	11	32	14	17
7	Korotan	11	21	15	16
8	Ljutomer	11	23	24	15
9	Bistrica	11	21	20	13
10	SD Videm	11	19	27	12
11	NK Verzej	11	11	39	5
12	Radgona	11	2	56	1

TEMPORADA 2018/2019

TERCERA ESLOVENIA 3. SNL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dravograd	25	60	51	48
2	Dravinja	25	54	45	43
3	Smartno 1928	25	58	47	42
4	Bistrica	25	45	28	41
5	Šampion	25	49	35	40
6	SD Videm	25	45	33	40
7	Zreče	25	36	35	36
8	NK Pesnica	25	28	65	19
9	NK Pohorje	25	51	82	17
10	Mons	9	11	16	8

TEMPORADA 2017/2018

TERCERA ESLOVENIA 3. SNL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dravograd	26	69	18	63
2	Šampion	26	60	19	59
3	Dravinja	26	49	27	46
4	NK Pesnica	26	39	30	45
5	Bistrica	26	40	32	41
6	Zreče	26	58	37	40
7	SD Videm	26	38	43	35
8	NK Pohorje	26	41	50	35
9	Mons	26	32	46	30
10	Dobrovce	26	36	45	28
11	NK Šentjur	26	34	65	24
12	Korotan	26	35	43	23
13	Lenart	26	30	64	23
14	Šmarje	26	26	68	19

TEMPORADA 2016/2017

TERCERA ESLOVENIA 3. SNL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Maribor II	26	107	25	66
2	NK Rogaška	26	76	29	54
3	Fužinar	26	48	34	42
4	Dravograd	26	40	38	41
5	Korotan	26	57	44	40
6	Mons	26	52	45	39
7	Šmarje	26	37	39	38
8	Dravinja	26	35	39	36
9	Šampion	26	47	57	33
10	SD Videm	26	36	54	29
11	Dobrovce	26	41	63	29
12	Lenart	26	37	59	27
13	Brunšvik	26	46	66	26
14	Smartno 1928	26	19	86	14

TEMPORADA 2015/2016

TERCERA ESLOVENIA 3. SNL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Brežice	26	69	22	66
2	Maribor II	26	102	24	61
3	Šampion	26	74	34	55
4	SD Videm	26	51	44	46
5	Šmarje	26	59	40	45
6	Fužinar	26	44	50	43
7	Mons	26	41	34	42
8	Dravograd	26	42	42	33
9	Lenart	26	41	60	29
10	Dobrovce	26	48	73	23
11	Dravinja	26	34	56	22
12	Smartno 1928	26	31	58	21
13	Radlje Dravi	26	23	57	19
14	Podvinci	26	18	83	10

TEMPORADA 2014/2015

SEGUNDA ESLOVENIA 2. SNL
Equipo		PJ	GF	GC	Puntos
1	NK Krsko	27	48	28	51
2	Aluminij	27	49	21	50
3	Roltek Dob	27	52	26	49
4	AH Mes Tech	27	45	37	42
5	NK Tolmin	27	49	42	41
6	Triglav	27	45	41	39
7	NK Verzej	27	37	45	38
8	Šencur	27	34	48	32
9	Dravinja	27	45	47	29
10	Smartno 1928	27	19	88	8

TEMPORADA 2013/2014

TERCERA ESLOVENIA 3. SNL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dravinja	26	82	16	66
2	Drava Ptuj	26	59	23	57
3	Odranci	26	65	39	47
4	Rakičan	26	52	38	46
5	Beltinci	26	48	38	44
6	Šmarje	26	65	43	42
7	Nafta	26	39	38	39
8	Ljutomer	26	48	41	37
9	Malečnik	26	33	46	31
10	Tromejnik	26	44	53	30
11	NK Šentjur	26	31	80	25
12	NK Grad	26	39	55	22
13	Bistrica	26	40	70	16
14	Čarda	26	23	88	10

TEMPORADA 2012/2013

SEGUNDA ESLOVENIA 2. SNL
Equipo		PJ	GF	GC	Puntos
1	Zavrč	27	69	25	64
2	Roltek Dob	27	63	27	57
3	NK Krka	27	63	24	53
4	NK Krsko	27	39	41	37
5	Radomlje	27	38	42	34
6	Šencur	27	37	46	32
7	Šampion	27	32	50	32
8	Smartno 1928	27	31	51	30
9	Bela Krajina	27	24	56	25
10	Dravinja	27	32	66	17

TEMPORADA 2011/2012

SEGUNDA ESLOVENIA 2. SNL
Equipo		PJ	GF	GC	Puntos
1	Aluminij	27	54	12	68
2	Roltek Dob	27	42	33	48
3	Šencur	27	46	35	43
4	Interblock	27	33	30	38
5	Radomlje	27	36	42	32
6	NK Krsko	27	24	27	31
7	Šampion	27	38	40	28
8	Bela Krajina	27	31	40	28
9	Dravinja	27	25	49	28
10	Smartno 1928	27	33	54	27

TEMPORADA 2010/2011

SEGUNDA ESLOVENIA 2. SNL
Equipo		PJ	GF	GC	Puntos
1	Aluminij	27	54	22	48
2	Interblock	27	38	25	47
3	Dravinja	27	31	23	43
4	Mura 05	27	42	37	41
5	Drava Ptuj	27	38	41	39
6	Roltek Dob	27	43	44	38
7	Bela Krajina	27	38	39	37
8	NK Krsko	27	24	35	31
9	Šencur	27	37	52	22
10	Smartno 1928	27	31	58	22

TEMPORADA 2009/2010

SEGUNDA ESLOVENIA 2. SNL
Equipo		PJ	GF	GC	Puntos
1	Primorje	27	51	16	55
2	Triglav	27	33	25	47
3	Aluminij	27	67	34	46
4	Dravinja	27	44	32	39
5	Bela Krajina	27	28	36	39
6	Mura 05	27	36	51	34
7	Šencur	27	31	35	32
8	NK Krsko	27	27	45	28
9	Ivančna	27	27	43	27
10	NK Šentjur	27	29	56	22

TEMPORADA 2008/2009

TERCERA ESLOVENIA 3. SNL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dravinja	26	66	12	67
2	Dravograd	26	60	30	54
3	Store	26	47	32	50
4	Odranci	26	43	30	47
5	Smartno 1928	26	63	56	45
6	NK Stojnci	26	47	40	38
7	Šampion	26	45	45	37
8	NK Verzej	26	44	44	34
9	Malečnik	26	47	49	34
10	Sladki Vrh	26	33	53	27
11	Čarda	26	35	47	25
12	Mons	26	30	63	22
13	Črenšovci	26	25	52	18
14	Šmarje	26	35	67	18

TEMPORADA 2006/2007

SEGUNDA ESLOVENIA 2. SNL
Equipo		PJ	GF	GC	Puntos
1	Ivančna	27	37	36	45
2	Bonifika	27	46	39	42
3	Triglav	27	29	24	39
4	NK Krsko	27	38	43	39
5	Zagorje	27	37	30	37
6	Aluminij	27	29	29	37
7	Rudar	27	44	41	34
8	Mura 05	27	37	37	34
9	Šencur	27	35	41	33
10	Dravinja	27	26	38	30

TEMPORADA 2005/2006

SEGUNDA ESLOVENIA 2. SNL
Equipo		PJ	GF	GC	Puntos
1	Interblock	27	37	27	50
2	Dravinja	27	46	24	49
3	Triglav	27	36	18	48
4	Aluminij	27	37	24	43
5	NK Krsko	27	34	36	40
6	Šencur	27	34	43	33
7	Ivančna	27	31	38	27
8	Zagorje	27	22	34	26
9	Dravograd	27	26	52	26
10	Svoboda	27	26	33	25

TEMPORADA 2004/2005

SEGUNDA ESLOVENIA 2. SNL
Equipo		PJ	GF	GC	Puntos
1	Rudar	33	76	40	72
2	Nafta	33	67	28	70
3	Svoboda	33	52	33	61
4	Dravinja	33	43	36	58
5	Dravograd	33	55	43	54
6	Ivančna	33	48	38	49
7	Aluminij	33	68	51	47
8	Triglav	33	50	39	46
9	Interblock	33	49	58	38
10	NK Krsko	33	46	59	38
11	MNK Izola	33	25	71	19
12	Smartno 1928	33	25	108	8

Competiciones que juega

Segunda Eslovenia 2. SNL

Pos	Equipos		Pts
1		Nafta Lendava	55
2		ND Gorica	51
3		Beltinci	50
4		Primorje	50
5		Brinje-Grosuplje	48
6		Triglav Kranj	48
7		Bistrica iz Slovenske	38
8		Rudar Velenje	33
9		Dekani	30
10		ND Bilje	30
11		NK Tolmin	29
12		ND Dravinja Kostroj	29
13		NK Krka	27
14		Ilirija 1911	25
15		Tabor Sežana	25
16		Fužinar	24

	Ascenso : Nafta Lendava
	Playoff Ascenso : ND Gorica
	Descenso : Tabor Sežana, Fužinar

RIVALES EN Segunda Esloveni.

RIVALES EN Copa Eslovenia

USO DE MEMORIA

6,890,344 bytes

BENCHMARKS

Loading Time Base Classes	0.0015
Controller Execution Time ( Home / Category )	0.5860
Total Execution Time	0.5876

CADENA URL

/historico/Nd-Dravinja-Kostroj

GET DATOS

$_GET['/historico/Nd-Dravinja-Kostroj']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18066 AND type_rel = 2
0.0124	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=389 AND type_rel = 3
0.0129	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 = '18066' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128	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=18066 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (73730,72187,71432,68721) 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.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 72187 AND teamId = 18066
0.0124	SELECT count(id) as num_players from rel_players WHERE league_id = 68721 AND teamId = 18066
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 73730 AND teamId = 18066
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 18066
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 = '18066' 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 = '18066' and rp.type = 4
0.0126	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 = '18066' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0135	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 = 72187 WHERE rp.league_id = 72187 AND rp.teamId = 18066 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.0134	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 = 72187 WHERE rp.league_id = 72187 AND rp.teamId = 18066 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147	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 = 72187 WHERE rp.league_id = 72187 AND rp.teamId = 18066 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130	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 = 18066 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0133	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 = 72187 AND t.round = 27 ORDER BY team.conference ASC,t.position 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* `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 = 68721 AND t.round = 26 ORDER BY team.conference ASC,t.position 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* `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 = 63890 AND t.round = 26 ORDER BY team.conference ASC,t.position 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* `tables2021` 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 = 58349 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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* `tables2021` 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 = 62535 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 50428 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141	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 = 44615 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144	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 = 38918 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142	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 = 33922 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 15893 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140	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 = 3875 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 24371 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 15282 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138	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 = 15281 AND t.round = 27 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 = 15280 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 15279 AND t.round = 27 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* `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 = 24395 AND t.round = 26 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* `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 = 15276 AND t.round = 27 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* `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 = 15275 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 15274 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

ND Dravinja Kostroj

ND Dravinja Kostroj

Selecciona un equipo

Competiciones que juega

Segunda Eslovenia 2. SNL

RIVALES EN Segunda Esloveni.

RIVALES EN Copa Eslovenia