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

Sloboda Novi Grad

Temporada 2022/2023

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 2015/2016

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Krupa Vrbasu	30	58	19	70
2	Mladost	30	64	25	59
3	Tekstilac	30	41	26	47
4	Zvijezda 09	30	42	34	47
5	Kozara	30	41	31	46
6	Sutjeska	30	38	36	46
7	Sloboda	30	38	44	44
8	Leotar	30	36	42	42
9	Sloboda Novi	30	40	41	38
10	Borac Samac	30	33	49	31
11	Drina	30	19	51	24
12	Vlasenica	30	22	74	11

TEMPORADA 2014/2015

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Rudar	26	31	14	50
2	Leotar	26	29	22	48
3	Krupa Vrbasu	26	34	25	43
4	Kozara	26	44	31	41
5	Tekstilac	26	23	18	41
6	Sutjeska	26	30	29	39
7	Sloboda Novi	26	36	40	37
8	Vlasenica	26	30	32	36
9	Proleter	26	33	35	34
10	FK Podrinje	26	22	20	33
11	Sloboda	26	28	34	33
12	Drina	26	29	37	30
13	Mladost	26	28	47	24
14	Napredak	26	31	44	20

TEMPORADA 2013/2014

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Drina	26	38	16	53
2	FK Podrinje	26	51	32	44
3	Sloboda	26	49	32	44
4	Kozara	26	32	26	42
5	Drina	26	42	34	40
6	Napredak	26	34	27	39
7	Sloboda Novi	26	40	32	38
8	Sutjeska	26	24	30	36
9	Proleter	26	42	41	35
10	Sloga Doboj	26	27	30	35
11	Mladost	26	26	30	35
12	FK Modrica	26	25	31	32
13	Borac Samac	26	25	42	20
14	Rudar	26	12	64	12

TEMPORADA 2012/2013

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Mladost	52	84	72	86
2	Sloboda	26	35	22	43
3	Kozara	26	42	39	43
4	Sloga Doboj	26	46	29	42
5	FK Podrinje	26	44	26	41
6	Drina	26	29	31	37
7	FK Modrica	26	39	39	36
8	Sloboda Novi	26	32	35	36
9	Drina	26	39	38	35
10	Sutjeska	26	26	21	31
11	Rudar	26	30	45	30
12	Borac Samac	26	28	45	28
13	Ljubic	26	27	59	21

TEMPORADA 2011/2012

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Radnik	26	31	19	50
2	Sloga Doboj	26	48	31	49
3	Sloboda	26	40	21	46
4	Sutjeska	26	34	36	38
5	Crvena	26	40	35	37
6	FK Modrica	26	31	22	36
7	Drina	26	22	25	36
8	FK Podrinje	26	32	29	34
9	Drina	26	24	23	33
10	Mladost	26	25	33	33
11	Rudar	26	27	30	32
12	Sloboda Novi	26	24	32	32
13	Laktaši	26	34	55	28
14	Proleter	26	34	55	20

TEMPORADA 2010/2011

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Kozara	26	46	12	58
2	Radnik	26	38	20	43
3	Sutjeska	26	37	27	43
4	Mladost	26	35	38	40
5	FK Podrinje	26	39	27	39
6	Sloga Doboj	26	35	41	38
7	Proleter	26	30	26	37
8	Sloboda Novi	26	37	33	36
9	FK Modrica	26	32	33	35
10	Laktaši	26	21	28	35
11	Sloboda	26	30	33	30
12	Drina	26	26	36	29
13	Famos	26	29	42	28
14	Banja Luka	26	15	54	17

TEMPORADA 2009/2010

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Drina	26	39	18	47
2	Radnik	26	47	32	43
3	Banja Luka	26	34	26	39
4	Proleter	26	27	22	37
5	Kozara	26	35	22	36
6	Sutjeska	26	31	30	36
7	Sloga Doboj	26	27	25	35
8	Sloboda Novi	26	29	28	35
9	Famos	26	28	34	35
10	Mladost	26	31	43	35
11	Drina	26	28	30	34
12	Romanija	26	32	33	32
13	Ljubic	26	26	52	25
14	Sloga Trn	26	25	44	21

TEMPORADA 2008/2009

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Rudar	30	49	19	64
2	Kozara	30	54	25	57
3	Radnik	30	50	32	52
4	Proleter	30	39	35	41
5	Sloga Doboj	30	29	33	41
6	Sutjeska	30	34	34	40
7	Ljubic	30	35	41	40
8	Drina	30	39	38	39
9	Sloboda Novi	30	37	37	39
10	Famos	30	40	46	39
11	Mladost	30	28	37	39
12	Drina	30	29	44	39
13	Banja Luka	30	35	42	38
14	Borac Samac	30	33	40	37
15	Glasinac	30	31	45	34
16	Jedinstvo	30	31	45	33

TEMPORADA 2007/2008

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Borac Banja	30	62	29	67
2	Sloga Doboj	30	60	41	53
3	Kozara	30	44	25	52
4	Sloboda Novi	30	43	29	50
5	Famos	30	48	38	48
6	Sutjeska	30	39	32	46
7	Ljubic	30	39	34	46
8	Drina	30	42	30	45
9	Proleter	30	49	42	42
10	Drina	30	38	48	41
11	Mladost	30	23	36	40
12	Banja Luka	30	42	47	38
13	Radnik	30	39	36	37
14	Borac Samac	30	30	44	32
15	Rudar	30	22	47	24
16	Jedinstvo	30	14	76	9

TEMPORADA 2006/2007

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Laktaši	30	45	21	59
2	Borac Samac	30	61	32	55
3	Rudar	30	35	24	47
4	Drina	30	41	21	46
5	Sloga Doboj	30	33	34	45
6	Drina	30	42	36	44
7	Glasinac	30	34	35	44
8	Ljubic	30	29	37	44
9	Sloboda Novi	30	49	43	43
10	Kozara	30	41	38	43
11	Famos	30	37	36	43
12	Mladost	30	41	41	42
13	Banja Luka	30	32	33	42
14	Jedinstvo	30	27	34	42
15	Rudar	30	36	41	40
16	Omladinac	30	20	97	4

TEMPORADA 2005/2006

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Borac Banja	30	50	19	62
2	Ljubic	30	45	28	53
3	Drina	30	39	28	50
4	Kozara	30	37	33	47
5	Banja Luka	30	34	36	47
6	Rudar	30	36	39	44
7	Rudar	30	40	34	43
8	Sloga Doboj	30	37	31	43
9	Glasinac	30	32	28	43
10	Mladost	30	39	43	43
11	Jedinstvo	30	38	38	40
12	Sloboda Novi	30	36	51	40
13	Famos	30	34	35	39
14	Laktaši	30	44	49	39
15	Sloga Trn	30	27	37	34
16	Nikos	30	18	57	16

Competiciones que juega

Primera RS Bosnia-Herzegovina

Pos	Equipos		Pts
1		Krupa na Vrbasu	85
2		Zvijezda 09	69
3		Laktaši	69
4		Slavija	55
5		Sloboda Novi Grad	55
6		Rudar Prijedor	53
7		Radnik Bijeljina	53
8		Sutjeska Foča	46
9		Kozara Gradiška	43
10		Željezničar Banja Luka	43
11		Ljubic Prnjavor	41
12		Famos Vojkovici	40
13		Sloboda Mrkonjic Grad	40
14		FK Omarska	38
15		Drina Zvornik	38
16		FK Modrica	33
17		FK Podrinje	31
18		Tekstilac Derventa	31

	Ascenso : Krupa na Vrbasu
	Playoff Descenso : FK Omarska, Drina Zvornik
	Descenso : FK Modrica, FK Podrinje, Tekstilac Derventa

RIVALES EN Copa Bosnia-Herz.

RIVALES EN Primera RS Bosni.

USO DE MEMORIA

6,564,104 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.1862
Total Execution Time	0.1882

CADENA URL

/historico/Sloboda-Novi-Grad

GET DATOS

$_GET['/historico/Sloboda-Novi-Grad']

POST DATOS

No hay datos POST existentes

CONSULTAS (58)

0.0023	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 = 'Sloboda-Novi-Grad' 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.0036	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 = 'Sloboda-Novi-Grad' 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.0018	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0054	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=13131 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027	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 = 68498
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13131 AND type_rel = 2
0.0045	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=365 AND type_rel = 3
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 365 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0020	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 (743245) ORDER BY n.cover_points DESC, update_date DESC
0.0026	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 = '13131' ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '13131' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '13131' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023	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 = '13131' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0035	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=13131 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (70050,68498) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 68498 AND teamId = 13131
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 70050 AND teamId = 13131
0.0023	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 = '13131' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13131' and rp.type = 4
0.0023	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 = '13131' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0050	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 events2023 e ON e.player_id = p.id AND e.league_id = 68498 WHERE rp.league_id = 68498 AND rp.teamId = 13131 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.0049	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 events2023 e ON e.player_id = p.id AND e.league_id = 68498 WHERE rp.league_id = 68498 AND rp.teamId = 13131 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 events2023 e ON e.player_id = p.id AND e.league_id = 68498 WHERE rp.league_id = 68498 AND rp.teamId = 13131 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 13131 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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.0027	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.0054	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 = 15786 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 = 4321 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 14709 AND t.round = 26 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* `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 = 2832 AND t.round = 26 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* `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 = 14710 AND t.round = 26 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* `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 = 14711 AND t.round = 26 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 = 14712 AND t.round = 26 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* `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 = 14713 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 = 14714 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* `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 = 14717 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* `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 = 14719 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Sloboda Novi Grad

Sloboda Novi Grad

Selecciona un equipo

Competiciones que juega

Primera RS Bosnia-Herzegovina

RIVALES EN Copa Bosnia-Herz.

RIVALES EN Primera RS Bosni.