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

NK Krsko

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA ESLOVENIA 3. SNL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Drava Ptuj	22	69	21	51
2	SD Videm	22	43	32	41
3	NK Krsko	22	71	36	38
4	Korotan	22	43	30	38
5	Brežice	22	60	45	37
6	Šampion	22	41	47	33
7	Podvinci	22	42	34	32
8	Zavrč	22	39	34	32
9	Ljutomer	22	41	49	30
10	Hajdina	22	37	38	29
11	Rače	22	28	32	26
12	Smartno 1928	22	30	51	24
13	Dobrovce	22	23	45	22
14	Dravograd	22	14	87	4

TEMPORADA 2022/2023

SEGUNDA ESLOVENIA 2. SNL
Equipo		PJ	GF	GC	Puntos
1	NK Rogaška	30	52	23	68
2	Aluminij	30	58	23	64
3	Ilirija 1911	30	55	30	54
4	NK Krka	30	46	28	53
5	Beltinci	30	47	45	44
6	Nafta	30	50	43	41
7	Primorje	30	42	40	41
8	Brinje-Grosu	30	30	37	38
9	Bistrica	30	39	40	37
10	ND Bilje	30	40	53	37
11	Dekani	30	27	29	35
12	Triglav	30	33	52	35
13	Rudar	30	41	51	32
14	Fužinar	30	39	56	31
15	NK Krsko	30	36	59	24
16	Roltek Dob	30	37	63	21

TEMPORADA 2021/2022

SEGUNDA ESLOVENIA 2. SNL
Equipo		PJ	GF	GC	Puntos
1	ND Gorica	30	55	20	72
2	Triglav	30	55	19	62
3	NK Krka	30	54	35	51
4	NK Rogaška	30	51	38	51
5	Rudar	30	51	43	49
6	Nafta	30	68	36	47
7	ND Bilje	30	38	39	45
8	Primorje	30	46	36	41
9	Roltek Dob	30	45	46	39
10	Ilirija 1911	30	35	37	38
11	Fužinar	30	46	52	37
12	Beltinci	30	34	47	35
13	Dekani	30	31	38	31
14	NK Krsko	30	25	54	26
15	Brežice	30	28	60	20
16	Drava Ptuj	30	30	92	20

TEMPORADA 2020/2021

SEGUNDA ESLOVENIA 2. SNL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Primorje	7	14	5	14
2	Drava Ptuj	7	10	7	12
3	Dekani	7	10	11	12
4	Smartno 1928	7	8	8	10
5	Fužinar	7	13	10	8
6	NK Krsko	7	9	13	8
7	Beltinci	7	10	13	6
8	Brda Dobrovo	7	9	16	5

TEMPORADA 2019/2020

SEGUNDA ESLOVENIA 2. SNL
Equipo		PJ	GF	GC	Puntos
1	FC Koper	20	42	13	44
2	ND Gorica	20	40	22	41
3	Radomlje	20	48	23	40
4	Nafta	20	45	24	37
5	Fužinar	20	35	22	37
6	NK Krsko	20	37	25	31
7	NK Krka	20	31	32	31
8	ND Bilje	20	28	25	29
9	Roltek Dob	20	37	35	29
10	Dekani	20	29	40	24
11	Drava Ptuj	20	28	34	21
12	Beltinci	20	20	36	20
13	Brda Dobrovo	20	22	38	19
14	Brežice	20	13	29	16
15	NK Rogaška	20	16	47	14
16	Dravograd	20	23	49	10

TEMPORADA 2018/2019

LIGA ESLOVENA SNL
Equipo		PJ	GF	GC	Puntos
1	Maribor	36	82	34	78
2	Olimpija	36	73	47	69
3	Domžale	36	76	47	63
4	NS Mura	36	53	37	52
5	Celje	36	45	51	49
6	Aluminij	36	50	53	48
7	Rudar	36	50	73	43
8	Triglav	36	51	83	37
9	ND Gorica	36	44	63	31
10	NK Krsko	36	29	65	24

TEMPORADA 2017/2018

LIGA ESLOVENA SNL
Equipo		PJ	GF	GC	Puntos
1	Maribor	36	76	28	80
2	Olimpija	36	61	17	80
3	Domžale	36	79	31	73
4	Celje	36	56	51	50
5	Rudar	36	50	49	50
6	ND Gorica	36	40	48	47
7	NK Krsko	36	36	61	34
8	Aluminij	36	40	63	33
9	Triglav	36	29	68	28
10	Ankaran	36	33	84	26

TEMPORADA 2016/2017

LIGA ESLOVENA SNL
Equipo		PJ	GF	GC	Puntos
1	Maribor	36	63	30	73
2	ND Gorica	36	48	39	60
3	Olimpija	36	49	35	60
4	Domžale	36	63	45	56
5	Celje	36	48	39	55
6	FC Koper	36	43	40	50
7	Rudar	36	49	53	41
8	NK Krsko	36	39	50	39
9	Aluminij	36	38	52	38
10	Radomlje	36	23	80	13

TEMPORADA 2015/2016

LIGA ESLOVENA SNL
Equipo		PJ	GF	GC	Puntos
1	Olimpija	36	75	25	74
2	Maribor	36	78	37	68
3	Domžale	36	46	31	55
4	ND Gorica	36	48	49	52
5	Celje	36	32	46	45
6	Rudar	36	34	52	41
7	NK Krsko	36	24	48	41
8	Zavrč	36	32	41	40
9	FC Koper	36	40	54	40
10	NK Krka	36	30	56	34

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

SEGUNDA ESLOVENIA 2. SNL
Equipo		PJ	GF	GC	Puntos
1	Roltek Dob	25	47	23	60
2	Radomlje	25	57	32	47
3	Aluminij	25	42	19	44
4	NK Verzej	25	50	47	41
5	NK Krsko	25	42	32	36
6	Smartno 1928	25	33	33	36
7	AH Mes Tech	25	37	37	35
8	Šencur	25	40	47	30
9	Šampion	25	32	59	16
10	Bela Krajina	25	9	60	6

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

SEGUNDA ESLOVENIA 2. SNL
Equipo		PJ	GF	GC	Puntos
1	Olimpija	26	69	25	56
2	Aluminij	26	65	40	49
3	Triglav	26	46	42	43
4	Mura 05	26	56	49	36
5	NK Šentjur	26	38	47	35
6	NK Krsko	26	40	47	33
7	Bela Krajina	26	34	40	31
8	Ivančna	26	34	40	30
9	Bonifika	18	32	30	18
10	Zagorje	26	17	71	13

TEMPORADA 2007/2008

SEGUNDA ESLOVENIA 2. SNL
Equipo		PJ	GF	GC	Puntos
1	Rudar	27	70	31	50
2	Bonifika	27	44	29	43
3	Bela Krajina	27	40	30	43
4	Aluminij	27	39	30	41
5	Mura 05	27	31	42	37
6	Zavrč	27	36	35	36
7	NK Krsko	27	33	42	36
8	Zagorje	27	43	45	35
9	Triglav	27	36	40	35
10	NK Krka	27	23	71	17

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

Competiciones que juega

Grupo 2

Tercera Eslovenia 3. SNL Grupo 2

Pos	Equipos		Pts
1		Drava Ptuj	51
2		SD Videm	41
3		NK Krsko	38
4		NK Korotan Prevalje	38
5		Brežice	37
6		Šampion Celje	33
7		Podvinci	32
8		Zavrč	32
9		Ljutomer	30
10		Hajdina	29
11		Rače	26
12		Smartno 1928	24
13		Dobrovce	22
14		Dravograd	4

	Ascenso : Drava Ptuj
	Playoff Descenso : Smartno 1928
	Descenso : Dobrovce, Dravograd

RIVALES EN Tercera Esloveni.

RIVALES EN Copa Eslovenia

USO DE MEMORIA

6,671,352 bytes

BENCHMARKS

Loading Time Base Classes	0.0023
Controller Execution Time ( Home / Category )	0.7635
Total Execution Time	0.7658

CADENA URL

/historico/Krsko-Posavje

GET DATOS

$_GET['/historico/Krsko-Posavje']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0178	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 = 'Krsko-Posavje' 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.0146	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=13515 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=13515 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149	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=13515 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=13515 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293	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 = 73232
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13515 AND type_rel = 2
0.0145	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13515 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0146	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 (6515,61412) ORDER BY n.cover_points DESC, update_date DESC
0.0149	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 = '13515' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0149	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 = '13515' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147	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 = 73232 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0159	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=13515 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146	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,73232,71432,68064) 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.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 68064 AND teamId = 13515
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 73232 AND teamId = 13515
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 73730 AND teamId = 13515
0.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13515
0.0148	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 = 73232 WHERE rp.league_id = 73232 AND rp.teamId = 13515 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.0146	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 = 73232 WHERE rp.league_id = 73232 AND rp.teamId = 13515 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146	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 = 73232 WHERE rp.league_id = 73232 AND rp.teamId = 13515 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153	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 = 13515 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0149	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 = 73232 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 68064 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.0150	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 = 63332 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.0146	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 = 62247 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 50029 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 44072 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 38695 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 33391 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 15441 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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.0150	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 = 2874 AND t.round = 25 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* `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.0150	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.0151	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.0151	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.0151	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 = 15278 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 15277 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162	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.0167	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.0152	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73232 ORDER BY nameShow LIMIT 100

NK Krsko

NK Krsko

Selecciona un equipo

Competiciones que juega

Tercera Eslovenia 3. SNL Grupo 2

RIVALES EN Tercera Esloveni.

RIVALES EN Copa Eslovenia