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

FK Modrica

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA RS BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Radnik	27	52	13	65
2	Laktaši	28	54	23	52
3	Rudar	28	48	21	49
4	Famos	28	38	35	45
5	Leotar	28	36	35	45
6	Željezniča	28	44	29	43
7	Banja Luka	28	44	32	42
8	Kozara	28	44	36	42
9	Sloboda	28	39	34	41
10	Sutjeska	27	31	39	37
11	Kozarska	28	33	44	36
12	Drina	28	28	33	34
13	Slavija	28	26	34	33
14	Ljubic	27	28	42	33
15	Velež	28	38	59	32
16	Romanija	28	31	52	31
17	FK Modrica	28	30	51	29
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 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

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

TEMPORADA 2005/2006

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Siroki	30	37	18	63
2	Sarajevo	30	57	26	60
3	Zrinjski	30	47	29	54
4	FK Modrica	30	50	31	53
5	Slavija	30	41	47	41
6	Željeznicar	30	38	32	40
7	Jedinstvo	30	38	40	40
8	NK Žepce	30	28	40	40
9	Leotar	30	43	47	39
10	Sloboda	30	31	37	39
11	Posušje	30	38	46	39
12	Orasje	30	50	51	38
13	Radnik	30	37	52	38
14	Celik Zenica	30	33	45	35
15	Travnik	30	33	41	34
16	Buducnost	30	29	48	33

TEMPORADA 2004/2005

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Zrinjski	30	56	30	61
2	Željeznicar	30	31	22	51
3	Siroki	30	42	33	45
4	Sarajevo	30	39	37	45
5	Travnik	30	42	47	44
6	FK Modrica	30	38	32	42
7	Orasje	30	46	44	42
8	Buducnost	30	37	40	42
9	Posušje	30	35	44	42
10	Slavija	30	36	34	41
11	Sloboda	30	30	28	41
12	NK Žepce	30	33	36	41
13	Celik Zenica	30	29	37	41
14	Leotar	30	35	45	41
15	Borac Banja	30	36	39	40
16	Rudar	30	26	43	25

TEMPORADA 2003/2004

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Siroki	30	58	32	61
2	Željeznicar	30	67	35	59
3	Sarajevo	30	58	25	56
4	Leotar	30	46	23	56
5	Sloboda	30	38	36	42
6	FK Modrica	30	43	43	40
7	Borac Banja	30	40	42	39
8	Orasje	30	40	51	39
9	Rudar	30	31	43	39
10	Posušje	30	35	48	39
11	Zrinjski	30	40	47	38
12	Celik Zenica	30	42	43	37
13	NK Žepce	30	26	38	37
14	Travnik	30	30	43	37
15	Glasinac	30	34	49	33
16	Brotnjo	30	29	59	19

Competiciones que juega

Primera RS Bosnia-Herzegovina

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

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

RIVALES EN Primera RS Bosni.

USO DE MEMORIA

6,826,928 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5967
Total Execution Time	0.5979

CADENA URL

/historico/Fk-Modrica

GET DATOS

$_GET['/historico/Fk-Modrica']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0145	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 = 'Fk-Modrica' 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.0125	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=13129 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=13129 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13129 AND type_rel = 2
0.0155	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 = '13129' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0159	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 = '13129' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137	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=13129 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0129	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 (72796,70050) 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.0135	SELECT count(id) as num_players from rel_players WHERE league_id = 72796 AND teamId = 13129
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 70050 AND teamId = 13129
0.0130	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 = '13129' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13129' and rp.type = 4
0.0131	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 = '13129' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0138	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 = 13129 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.0136	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 = 13129 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138	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 = 13129 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 = 13129 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0134	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.0137	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.0135	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.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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.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 = 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.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* `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.0134	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
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* `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 = 8973 AND t.round = 30 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* `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 = 8972 AND t.round = 30 ORDER BY team.conference 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* `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 = 8970 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

FK Modrica

FK Modrica

Selecciona un equipo

Competiciones que juega

Primera RS Bosnia-Herzegovina

RIVALES EN Primera RS Bosni.