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

Slavija

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Radnik	27	52	13	65
2	Laktaši	27	53	22	51
3	Rudar	27	47	20	48
4	Željezniča	27	44	28	43
5	Famos	27	35	33	42
6	Leotar	27	35	35	42
7	Kozara	27	43	35	41
8	Banja Luka	27	42	32	39
9	Sloboda	27	38	34	38
10	Sutjeska	27	31	39	37
11	Kozarska	27	32	43	35
12	Drina	27	27	31	34
13	Slavija	27	26	33	33
14	Ljubic	27	28	42	33
15	Velež	27	36	56	32
16	Romanija	27	31	50	31
17	FK Modrica	27	28	50	26
18	FK Omarska	27	25	57	16

TEMPORADA 2022/2023

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Krupa Vrbasu	34	98	24	85
2	Zvijezda 09	34	77	26	69
3	Laktaši	34	76	34	69
4	Slavija	34	56	40	55
5	Sloboda Novi	34	51	42	55
6	Rudar	34	48	34	53
7	Radnik	34	47	33	53
8	Sutjeska	34	48	60	46
9	Kozara	34	48	56	43
10	Željezniča	34	41	57	43
11	Ljubic	34	41	66	41
12	Famos	34	40	53	40
13	Sloboda	34	45	59	40
14	FK Omarska	34	42	76	38
15	Drina	34	44	53	38
16	FK Modrica	34	32	73	33
17	FK Podrinje	34	38	62	31
18	Tekstilac	34	28	52	31

TEMPORADA 2021/2022

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Krupa Vrbasu	30	73	16	75
2	Sloga Doboj	30	67	20	68
3	Sloboda Novi	30	52	16	65
4	Zvijezda 09	30	61	30	58
5	Sutjeska	30	59	39	55
6	Drina	30	49	36	50
7	Slavija	30	40	41	43
8	FK Omarska	30	34	41	39
9	Ljubic	30	52	57	38
10	Tekstilac	30	25	34	37
11	Željezniča	30	40	47	33
12	FK Modrica	30	33	63	31
13	Kozara	30	36	47	29
14	FK Podrinje	30	27	57	27
15	Kozarska	30	22	51	24
16	Buducnost	30	20	95	10

TEMPORADA 2020/2021

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Rudar	30	51	20	63
2	Leotar	30	47	27	54
3	Zvijezda 09	30	50	33	53
4	Željezniča	30	46	37	46
5	Tekstilac	30	35	36	45
6	Sloboda Novi	30	25	27	44
7	FK Modrica	30	52	37	43
8	Kozara	30	34	28	42
9	Slavija	30	30	33	41
10	Kozarska	30	35	38	39
11	Sloga Doboj	30	34	29	38
12	Ljubic	30	45	45	38
13	Drina	30	39	50	38
14	Sutjeska	30	39	40	35
15	FK Podrinje	30	17	56	21
16	Jedinstvo	30	29	72	18

TEMPORADA 2019/2020

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Krupa Vrbasu	14	34	6	38
2	Rudar	14	20	7	27
3	Kozara	14	15	16	22
4	Željezniča	14	20	12	19
5	Tekstilac	14	22	20	16
6	FK Modrica	13	15	15	14
7	Slavija	13	14	20	13
8	FK Podrinje	13	10	20	13
9	Jedinstvo	13	12	28	8
10	Sloga Gornje	2	0	18	0

TEMPORADA 2018/2019

PRIMERA RS BOSNIA-HERZEGOVINA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Slavija	10	17	10	42
2	FK Modrica	10	9	6	41
3	Tekstilac	10	8	4	40
4	Sutjeska	10	14	12	36
5	Drina	10	13	9	35
6	Sloboda	10	4	24	19

TEMPORADA 2017/2018

PRIMERA RS BOSNIA-HERZEGOVINA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Zvijezda 09	10	28	8	30
2	Rudar	10	19	5	22
3	FK Podrinje	10	14	23	9
4	Slavija	10	8	19	9
5	Drina	10	10	11	8
6	Tekstilac	10	6	19	5

TEMPORADA 2016/2017

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Borac Banja	32	61	12	81
2	FK Podrinje	32	47	29	59
3	Rudar	32	59	40	52
4	Drina	32	39	29	52
5	Sloga Doboj	32	61	52	47
6	Sloboda	32	43	51	46
7	Slavija	32	51	41	42
8	Zvijezda 09	32	36	51	42
9	Kozara	32	39	44	36
10	Tekstilac	32	18	26	36
11	Sutjeska	32	30	52	33
12	Borac Samac	32	24	81	11

TEMPORADA 2015/2016

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Zrinjski	30	52	17	69
2	Sloboda	30	44	23	62
3	Siroki	30	56	21	61
4	Sarajevo	30	56	28	57
5	Željeznicar	30	36	20	55
6	Celik Zenica	30	35	28	46
7	Radnik	30	25	25	45
8	Olimpik	30	36	33	39
9	Vitez	30	36	41	39
10	Mladost	30	29	39	39
11	Borac Banja	30	27	33	36
12	Slavija	30	25	37	35
13	Travnik	30	36	47	29
14	Rudar	30	24	38	25
15	Drina	30	24	66	22
16	Velež	30	10	55	9

TEMPORADA 2014/2015

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Sarajevo	30	55	17	66
2	Željeznicar	30	52	22	63
3	Zrinjski	30	41	13	59
4	Siroki	30	46	23	56
5	Borac Banja	30	26	26	49
6	Olimpik	30	41	34	46
7	Celik Zenica	30	34	35	41
8	Sloboda	30	33	28	40
9	Velež	30	32	33	38
10	Radnik	30	29	39	31
11	Travnik	30	22	42	31
12	Slavija	30	30	44	28
13	Drina	30	26	40	27
14	Vitez	30	21	43	26
15	Mladost	30	18	44	26
16	Zvijezda	30	30	53	25

TEMPORADA 2013/2014

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Zrinjski	30	56	21	61
2	Siroki	30	66	23	59
3	Sarajevo	30	45	21	58
4	Željeznicar	30	51	29	57
5	Velež	30	42	23	54
6	Borac Banja	30	39	32	45
7	Celik Zenica	30	35	32	43
8	Olimpik	30	39	30	41
9	Vitez	30	34	39	36
10	Radnik	30	34	50	36
11	Slavija	30	27	43	34
12	Mladost	30	24	38	33
13	Travnik	30	31	44	31
14	Zvijezda	30	25	49	31
15	Rudar	30	24	39	27
16	Leotar	30	11	70	9

TEMPORADA 2012/2013

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Željeznicar	30	48	20	66
2	Sarajevo	30	52	19	60
3	Borac Banja	30	43	25	51
4	Celik Zenica	30	44	30	51
5	Olimpik	30	34	26	49
6	Siroki	30	48	31	45
7	Slavija	30	29	28	43
8	Leotar	30	28	40	39
9	Zrinjski	30	26	42	39
10	Rudar	30	37	42	36
11	Zvijezda	30	38	44	36
12	Radnik	30	27	35	35
13	Velež	30	31	34	34
14	Travnik	30	29	45	34
15	GOŠK Gabela	30	29	42	30
16	Gradina	30	17	57	9

TEMPORADA 2011/2012

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Željeznicar	30	68	17	71
2	Siroki	30	48	17	63
3	Borac Banja	30	46	26	55
4	Sarajevo	30	48	31	54
5	Olimpik	30	44	23	52
6	Zrinjski	30	47	41	45
7	Zvijezda	30	37	35	45
8	Travnik	30	42	53	35
9	Celik Zenica	30	31	39	34
10	Rudar	30	30	46	34
11	Velež	30	28	35	33
12	Leotar	30	27	40	33
13	GOŠK Gabela	30	26	43	33
14	Slavija	30	36	61	32
15	Sloboda	30	23	48	32
16	Kozara	30	19	45	19

TEMPORADA 2010/2011

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Borac Banja	30	37	15	64
2	Sarajevo	30	51	26	57
3	Željeznicar	30	50	25	55
4	Siroki	30	59	45	50
5	Olimpik	30	35	33	48
6	Sloboda	30	28	29	46
7	Zrinjski	30	41	39	42
8	Zvijezda	30	40	38	42
9	Rudar	30	37	41	41
10	Celik Zenica	30	30	30	40
11	Slavija	30	44	46	38
12	Travnik	30	44	43	37
13	Velež	30	31	43	36
14	Leotar	30	29	49	35
15	Buducnost	30	25	44	25
16	Drina	30	18	53	23

TEMPORADA 2009/2010

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Željeznicar	30	52	22	61
2	Siroki	30	46	27	55
3	Borac Banja	30	37	29	53
4	Zrinjski	30	46	33	51
5	Sarajevo	30	43	25	50
6	Olimpik	30	30	34	44
7	Velež	30	42	33	43
8	Sloboda	30	30	34	42
9	Travnik	30	40	41	39
10	Rudar	30	27	32	38
11	Leotar	30	32	48	38
12	Zvijezda	30	35	47	37
13	Celik Zenica	30	33	37	35
14	Slavija	30	32	46	35
15	Laktaši	30	38	46	34
16	FK Modrica	30	28	57	24

TEMPORADA 2008/2009

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Zrinjski	30	50	37	57
2	Slavija	30	36	28	52
3	Sloboda	30	32	26	50
4	Borac Banja	30	45	26	49
5	Sarajevo	30	43	30	49
6	Siroki	30	47	38	45
7	Zvijezda	30	43	38	43
8	Laktaši	30	43	39	42
9	Željeznicar	30	30	35	42
10	Celik Zenica	30	30	32	41
11	Leotar	30	32	43	39
12	Velež	30	42	45	37
13	FK Modrica	30	37	41	37
14	Travnik	30	38	53	37
15	Orasje	30	33	43	34
16	Posušje	30	31	58	23

TEMPORADA 2007/2008

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	FK Modrica	30	57	45	55
2	Siroki	30	44	29	54
3	Celik Zenica	30	38	32	52
4	Zrinjski	30	46	27	49
5	Sarajevo	30	42	29	48
6	Sloboda	30	44	38	47
7	Željeznicar	30	47	35	45
8	Slavija	30	39	44	44
9	Velež	30	39	46	44
10	Laktaši	30	42	40	43
11	Posušje	30	42	46	43
12	Orasje	30	50	45	42
13	Travnik	30	35	39	42
14	Leotar	30	38	45	41
15	Jedinstvo	30	28	43	40
16	NK Žepce	30	25	73	7

TEMPORADA 2006/2007

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Sarajevo	30	44	26	57
2	Zrinjski	30	67	40	55
3	Slavija	30	41	35	53
4	Siroki	30	39	32	45
5	Željeznicar	30	51	40	44
6	FK Modrica	30	42	42	44
7	Leotar	30	47	48	43
8	Velež	30	41	42	43
9	Jedinstvo	30	46	58	43
10	NK Žepce	30	30	37	40
11	Posušje	30	42	51	40
12	Sloboda	30	36	45	40
13	Orasje	30	40	35	39
14	Borac Banja	30	42	47	39
15	Celik Zenica	30	29	34	39
16	Radnik	30	25	50	25

Competiciones que juega

Primera RS Bosnia-Herzegovina

Pos	Equipos		Pts
1		Radnik Bijeljina	65
2		Laktaši	51
3		Rudar Prijedor	48
4		Željezničar Banja Luka	43
5		Famos Vojkovici	42
6		Leotar	42
7		Kozara Gradiška	41
8		BSK Banja Luka	39
9		Sloboda Mrkonjic Grad	38
10		Sutjeska Foča	37
11		Kozarska Dubica	35
12		Drina Zvornik	34
13		Slavija	33
14		Ljubic Prnjavor	33
15		Velež Nevesinje	32
16		Romanija Pale	31
17		FK Modrica	26
18		FK Omarska	16

	Ascenso : Radnik Bijeljina
	Playoff Descenso : Velež Nevesinje, Romanija Pale
	Descenso : FK Modrica, FK Omarska

RIVALES EN Copa Bosnia-Herz.

RIVALES EN Primera RS Bosni.

USO DE MEMORIA

7,179,856 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7657
Total Execution Time	0.7669

CADENA URL

/historico/Slavija

GET DATOS

$_GET['/historico/Slavija']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0158	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 = 'Slavija' 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=4061 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=4061 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=4061 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0290	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 = 72796
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4061 AND type_rel = 2
0.0145	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4061 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0145	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 (55808) ORDER BY n.cover_points DESC, update_date DESC
0.0150	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 = '4061' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0151	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 = '4061' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148	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 = 74195 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146	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 = 72796 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151	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=4061 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0148	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 (74195,72796) 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.0159	SELECT count(id) as num_players from rel_players WHERE league_id = 72796 AND teamId = 4061
0.0161	SELECT count(id) as num_players from rel_players WHERE league_id = 74195 AND teamId = 4061
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 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 = 72796 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0155	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 = 72796 WHERE rp.league_id = 72796 AND rp.teamId = 4061 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.0154	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 = 72796 WHERE rp.league_id = 72796 AND rp.teamId = 4061 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159	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 = 72796 WHERE rp.league_id = 72796 AND rp.teamId = 4061 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154	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 = 4061 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0155	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 = 72796 AND t.round = 28 ORDER BY team.conference ASC,t.position 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* `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 = 68498 AND t.round = 34 ORDER BY team.conference ASC,t.position 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* `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 = 63575 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.0163	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 = 57038 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.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 = 50482 AND t.round = 18 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 = 44656 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 49721 AND t.round = 10 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 = 38953 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 43368 AND t.round = 10 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* `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 = 33946 AND t.round = 32 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* `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 = 15433 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156	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 = 4147 AND t.round = 30 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* `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 = 2485 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166	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 = 2033 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171	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 = 1375 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165	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 = 8982 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158	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 = 8981 AND t.round = 30 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* `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 = 8979 AND t.round = 30 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* `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 = 8977 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 8975 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Slavija

Slavija

Selecciona un equipo

Competiciones que juega

Primera RS Bosnia-Herzegovina

RIVALES EN Copa Bosnia-Herz.

RIVALES EN Primera RS Bosni.