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

Zrinjski

Entrenador: Zeljko Petrovic

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Borac Banja	29	54	18	69
2	Zrinjski	29	61	25	64
3	Velež	29	39	24	49
4	Sarajevo	29	51	34	48
5	Posušje	29	30	25	41
6	Sloga Doboj	29	33	43	41
7	Siroki	29	32	37	35
8	Željeznicar	29	26	35	33
9	GOŠK Gabela	29	32	53	32
10	Igman Konjic	29	34	57	31
11	Tuzla City	29	42	52	27
12	Zvijezda 09	29	30	61	20

TEMPORADA 2022/2023

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Zrinjski	33	66	21	78
2	Borac Banja	33	39	32	58
3	Željeznicar	33	42	35	53
4	Sarajevo	33	50	46	52
5	Siroki	33	38	36	48
6	Velež	33	40	37	45
7	Tuzla City	33	43	46	37
8	Igman Konjic	33	42	48	37
9	Sloga Doboj	33	40	55	37
10	Posušje	33	28	46	37
11	Leotar	33	29	46	34
12	Sloboda	33	32	41	32

TEMPORADA 2021/2022

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Zrinjski	33	74	14	84
2	Tuzla City	33	49	36	57
3	Borac Banja	33	44	34	54
4	Sarajevo	33	37	33	46
5	Velež	33	42	37	44
6	Željeznicar	33	28	29	43
7	Siroki	33	31	35	39
8	Posušje	33	33	51	37
9	Leotar	33	25	46	34
10	Sloboda	33	26	35	33
11	Radnik	33	34	53	27
12	Rudar	33	28	48	26

TEMPORADA 2020/2021

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Borac Banja	33	59	31	67
2	Sarajevo	33	53	24	65
3	Velež	33	50	30	61
4	Siroki	33	47	30	59
5	Zrinjski	33	50	30	59
6	Tuzla City	33	36	35	48
7	Željeznicar	33	50	43	44
8	Sloboda	33	31	41	37
9	Mladost	33	26	57	30
10	Krupa Vrbasu	33	26	46	28
11	Radnik	33	26	51	25
12	Olimpik	33	22	58	25

TEMPORADA 2019/2020

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Sarajevo	22	38	19	45
2	Željeznicar	22	43	21	42
3	Zrinjski	22	30	12	38
4	Borac Banja	22	29	23	36
5	Tuzla City	22	27	29	35
6	Radnik	22	34	21	34
7	Siroki	22	31	26	32
8	Velež	22	25	23	32
9	Sloboda	22	21	35	21
10	Mladost	22	21	35	18
11	Celik Zenica	22	17	33	17
12	Zvijezda 09	22	12	51	8

TEMPORADA 2018/2019

LIGA BOSNIA-HERZEGOVINA
Equipo		PJ	GF	GC	Puntos
1	Sarajevo	33	68	20	70
2	Zrinjski	33	46	22	65
3	Siroki	33	37	23	54
4	Željeznicar	33	43	32	50
5	Radnik	33	29	26	44
6	Mladost	33	36	45	43
7	Celik Zenica	33	30	49	43
8	Sloboda	33	22	31	38
9	Zvijezda 09	33	33	45	38
10	Tuzla City	33	32	44	36
11	Krupa Vrbasu	33	40	48	33
12	GOŠK Gabela	33	23	54	23

TEMPORADA 2017/2018

LIGA BOSNIA-HERZEGOVINA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Zrinjski	10	18	12	69
2	Željeznicar	10	12	14	63
3	Sarajevo	10	14	9	56
4	Siroki	10	15	11	56
5	Radnik	10	14	14	45
6	Krupa Vrbasu	10	6	19	40

TEMPORADA 2016/2017

LIGA BOSNIA-HERZEGOVINA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Zrinjski	10	16	6	64
2	Željeznicar	10	13	8	63
3	Sarajevo	10	11	6	59
4	Krupa Vrbasu	10	13	12	46
5	Sloboda	10	8	18	43
6	Radnik	10	6	17	40

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

Conference League Grupo 5

Pos	Equipos		Pts
1		Aston Villa	13
2		Legia Warszawa	12
3		AZ Alkmaar	6
4		Zrinjski	4

	: Aston Villa
	: Legia Warszawa
	Eliminado : AZ Alkmaar, Zrinjski

RIVALES EN Fase Previa Cham.

RIVALES EN Conference Leagu.

RIVALES EN Copa Bosnia-Herz.

RIVALES EN Fase Previa Euro.

RIVALES EN Liga Bosnia-Herz.

USO DE MEMORIA

7,599,008 bytes

BENCHMARKS

Loading Time Base Classes	0.0015
Controller Execution Time ( Home / Category )	0.7884
Total Execution Time	0.7900

CADENA URL

/historico/Zrinjski

GET DATOS

$_GET['/historico/Zrinjski']

POST DATOS

No hay datos POST existentes

CONSULTAS (48)

0.0253	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 = 73884
0.0129	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 = 74195
0.0133	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 = 72093
0.0135	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 = 72094
0.0139	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 = 72101
0.0146	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 = 72104
0.0128	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4014 AND type_rel = 2
0.0132	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4014 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0134	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 (153522,305326,363802,465992,478253) ORDER BY n.cover_points DESC, update_date DESC
0.0162	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 = '4014' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135	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 = 72093 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130	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 = 73884 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133	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.0127	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 = 72104 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128	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 = 72411 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0139	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=4014 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0136	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,73884,72411,72104,72094,71432,67758) 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.0157	SELECT count(id) as num_players from rel_players WHERE league_id = 72411 AND teamId = 4014
0.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 73884 AND teamId = 4014
0.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 72094 AND teamId = 4014
0.0143	SELECT count(id) as num_players from rel_players WHERE league_id = 72104 AND teamId = 4014
0.0142	SELECT count(id) as num_players from rel_players WHERE league_id = 67758 AND teamId = 4014
0.0142	SELECT count(id) as num_players from rel_players WHERE league_id = 74195 AND teamId = 4014
0.0191	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4014
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 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 = 73884 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0175	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 = 73884 WHERE rp.league_id = 73884 AND rp.teamId = 4014 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.0168	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 = 73884 WHERE rp.league_id = 73884 AND rp.teamId = 4014 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 = 73884 WHERE rp.league_id = 73884 AND rp.teamId = 4014 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156	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 = 4014 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72411 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.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* `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 = 68030 AND t.round = 33 ORDER BY team.conference ASC,t.position 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* `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 = 63168 AND t.round = 33 ORDER BY team.conference ASC,t.position 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* `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 = 56832 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	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 = 49995 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.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* `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 = 43675 AND t.round = 33 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* `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 = 38713 AND t.round = 22 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* `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 = 43259 AND t.round = 10 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* `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 = 33382 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* `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 = 38217 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* `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.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* `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.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* `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.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* `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.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* `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.0132	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.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* `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.0132	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.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* `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

Zrinjski

Zrinjski

Selecciona un equipo

Competiciones que juega

Conference League Grupo 5

RIVALES EN Fase Previa Cham.

RIVALES EN Conference Leagu.

RIVALES EN Copa Bosnia-Herz.

RIVALES EN Fase Previa Euro.

RIVALES EN Liga Bosnia-Herz.