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

Bregalnica Štip

Entrenador: Trajce Senev

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Struga	29	50	28	58
2	Shkupi	29	40	18	58
3	Shkëndija	29	48	23	55
4	Sileks	29	33	35	41
5	Tikves	29	35	33	39
6	AP Brera	29	26	26	37
7	Gostivar	29	29	36	37
8	Rabotnički	29	25	31	35
9	Voska Sport	29	32	39	34
10	Vardar	29	21	40	29
11	Makedonija	29	24	35	26
12	Bregalnica	29	24	43	26

TEMPORADA 2022/2023

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Struga	30	53	19	68
2	Shkupi	30	62	27	58
3	Shkëndija	30	43	23	57
4	Sileks	30	41	34	48
5	Bregalnica	30	33	34	41
6	Tikves	30	40	37	40
7	Makedonija	30	37	33	39
8	Rabotnički	30	37	48	37
9	AP Brera	30	34	38	28
10	FK Skopje	30	17	44	22
11	Pobeda	30	18	78	13
12	Renova	0	0	0	0

TEMPORADA 2021/2022

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Shkupi	33	66	21	76
2	AP Brera	33	55	32	64
3	Shkëndija	33	49	26	60
4	Makedonija	33	46	44	57
5	Renova	33	43	29	50
6	Struga	33	33	33	47
7	Bregalnica	33	45	47	45
8	Rabotnički	33	29	35	43
9	FK Skopje	33	27	45	35
10	Tikves	33	36	38	34
11	FK Borec	33	25	66	21
12	Pelister	33	16	54	14

TEMPORADA 2020/2021

SEGUNDA MACEDONIA DEL NORTE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bregalnica	27	74	18	73
2	Tikves	27	59	23	61
3	Pehchevo	27	41	33	42
4	Sloga Vinica	27	33	34	36
5	Kozuv	27	29	35	36
6	Sasa	27	35	32	35
7	Osogovo	27	32	43	29
8	Pobeda	27	30	35	27
9	Plačkovica	27	20	43	22
10	Rosoman 83	27	26	83	9

TEMPORADA 2019/2020

SEGUNDA MACEDONIA DEL NORTE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Belasica	16	37	9	40
2	Bregalnica	16	39	9	37
3	Tikves	16	30	12	31
4	Pehchevo	16	23	13	31
5	Kozuv	16	26	16	30
6	Sasa	16	26	23	23
7	Plačkovica	16	17	30	13
8	Pobeda	16	17	29	12
9	Osogovo	16	12	44	6
10	Pitu Guli	16	11	53	4

TEMPORADA 2018/2019

SEGUNDA MACEDONIA DEL NORTE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	FK Borec	18	37	12	46
2	Tikves	18	31	10	39
3	Kozuv	18	24	9	36
4	Bregalnica	18	37	18	34
5	Pehchevo	18	26	12	30
6	Detonit	18	17	32	17
7	Plačkovica	18	15	30	16
8	Partizan	18	10	32	13
9	Vardar	18	14	31	11
10	Sasa	18	13	38	10

TEMPORADA 2017/2018

SEGUNDA MACEDONIA DEL NORTE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Belasica	25	81	11	59
2	Bregalnica	25	54	20	53
3	FK Borec	25	43	15	53
4	Kozuv	25	34	33	40
5	Tikves	25	45	43	38
6	Plačkovica	25	40	50	30
7	Sasa	25	32	42	25
8	Osogovo	25	26	53	19
9	Pobeda	25	25	95	11
10	Turnovo	9	8	26	3

TEMPORADA 2016/2017

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Vardar	36	75	24	83
2	Shkëndija	36	71	39	70
3	Rabotnički	36	49	41	54
4	Pelister	36	44	35	52
5	Renova	36	42	37	52
6	Sileks	36	41	43	47
7	Pobeda	36	34	50	41
8	Shkupi	36	27	39	37
9	Bregalnica	36	39	69	24
10	Makedonija	36	35	80	23

TEMPORADA 2015/2016

LIGA MACEDONIA DEL NORTE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Vardar	5	8	2	15
2	Shkëndija	5	12	3	12
3	Rabotnički	5	4	4	7
4	Bregalnica	5	4	6	5
5	Sileks	5	3	8	4
6	Shkupi	5	1	9	0

TEMPORADA 2014/2015

LIGA MACEDONIA DEL NORTE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Vardar	27	46	15	61
2	Rabotnički	27	43	23	55
3	Shkëndija	27	49	27	47
4	Renova	27	34	27	44
5	Sileks	27	26	34	34
6	Metalurg	27	31	31	33
7	Bregalnica	27	22	28	30
8	Turnovo	27	21	30	30
9	Pelister	27	16	28	23
10	Teteks	27	17	62	11

TEMPORADA 2013/2014

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Rabotnički	33	66	35	62
2	Turnovo	33	61	33	60
3	Metalurg	33	48	29	59
4	Shkëndija	33	53	32	57
5	Vardar	33	55	32	56
6	Pelister	33	40	40	52
7	Bregalnica	33	34	34	44
8	Renova	33	42	46	44
9	Gorno	33	34	37	39
10	Makedonija	33	40	56	32
11	Napredok	33	27	75	18
12	Gostivar	33	19	70	15

TEMPORADA 2012/2013

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Vardar	33	71	21	68
2	Metalurg	33	48	28	63
3	Turnovo	33	49	31	63
4	Rabotnički	33	47	42	53
5	Shkëndija	33	52	49	44
6	Bregalnica	33	37	35	43
7	Napredok	33	29	39	43
8	Renova	33	35	46	43
9	Drita	33	35	50	40
10	Pelister	33	27	36	37
11	Teteks	33	22	47	25
12	Sileks	33	33	61	23

TEMPORADA 2011/2012

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Vardar	33	50	15	76
2	Metalurg	33	53	16	67
3	Shkëndija	33	53	28	66
4	Renova	33	56	38	52
5	Bregalnica	33	51	47	45
6	Sileks	33	42	51	42
7	Napredok	33	37	51	42
8	Rabotnički	33	50	45	41
9	Turnovo	33	34	42	38
10	Teteks	33	23	48	35
11	FK Ohrid	33	26	62	26
12	11 Oktomvri	33	26	58	16

TEMPORADA 2010/2011

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Shkëndija	33	65	23	72
2	Metalurg	33	48	24	61
3	Renova	33	54	31	60
4	Rabotnički	33	53	31	55
5	Sileks	33	39	38	47
6	Turnovo	33	35	35	45
7	Teteks	33	38	36	44
8	Bregalnica	33	33	49	41
9	FK Skopje	33	36	39	37
10	Napredok	33	30	48	37
11	Vardar	33	24	44	29
12	Pelister	33	25	82	18

TEMPORADA 2009/2010

SEGUNDA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Shkëndija	26	57	15	57
2	FK Skopje	26	49	22	57
3	Napredok	26	55	32	54
4	Bregalnica	26	49	20	52
5	Drita	26	36	34	41
6	Miravci	26	31	31	36
7	11 Oktomvri	26	30	34	34
8	Belasica	26	27	40	33
9	Novaci	26	26	37	31
10	Lokomotiva	26	29	30	29
11	Vlaznimi	26	26	42	28
12	Cementarnica	26	21	40	26
13	Vëllazërim	26	16	49	14
14	FK Ohrid	26	26	52	13

TEMPORADA 2008/2009

SEGUNDA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Teteks	29	50	13	63
2	Sloga	29	31	12	59
3	Shkëndija	29	67	29	55
4	Bregalnica	29	45	21	51
5	Drita	29	45	30	50
6	Lokomotiva	29	47	29	48
7	Miravci	29	36	23	43
8	Belasica	29	34	33	38
9	FK Skopje	29	36	38	38
10	Novaci	29	35	50	31
11	FK Ohrid	29	31	50	30
12	Cementarnica	29	25	45	29
13	Kozuv	29	28	50	26
14	Vardar	29	25	75	25
15	Madzari	29	32	54	23
16	Milenium	15	12	27	10

TEMPORADA 2007/2008

SEGUNDA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Turnovo	32	58	23	71
2	Metalurg	32	47	24	67
3	Miravci	32	60	22	65
4	Belasica	32	49	37	55
5	FK Skopje	32	53	44	54
6	Drita	32	47	30	47
7	Teteks	32	32	30	47
8	Sloga	32	36	34	44
9	FK Ohrid	32	43	53	41
10	Madzari	32	33	39	40
11	Milenium	32	41	36	39
12	Alumina	32	28	37	39
13	Vardar	32	42	58	39
14	Lokomotiva	32	40	47	38
15	Bregalnica	32	36	43	37
16	Karaorman	32	23	57	26
17	Vëllazërim	32	28	82	17

TEMPORADA 2006/2007

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Pobeda	33	73	42	71
2	Rabotnički	33	75	25	67
3	Makedonija	33	65	29	64
4	Vardar	33	63	34	59
5	Renova	33	54	31	59
6	Pelister	33	37	32	45
7	Napredok	33	50	47	45
8	Bashkimi	33	54	60	42
9	Sileks	33	54	50	41
10	Shkëndija	33	39	63	38
11	Bregalnica	33	19	97	13
12	Vëllazërim	33	22	95	9

Competiciones que juega

Liga Macedonia del Norte

Pos	Equipos		Pts
1		Struga	58
2		Shkupi	58
3		KF Shkëndija	55
4		Sileks	41
5		Tikves	39
6		AP Brera	37
7		Gostivar	37
8		Rabotnički	35
9		Voska Sport	34
10		Vardar Skopje	29
11		Makedonija GP	26
12		Bregalnica Štip	26

	Campeón : Struga
	: Shkupi
	Playoff Descenso : Voska Sport, Vardar Skopje
	Descenso : Makedonija GP, Bregalnica Štip

RIVALES EN Copa Macedonia d.

RIVALES EN Liga Macedonia d.

USO DE MEMORIA

6,697,424 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1574
Total Execution Time	0.1587

CADENA URL

/historico/Bregalnica-Stip

GET DATOS

$_GET['/historico/Bregalnica-Stip']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0039	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 = 'Bregalnica-Stip' 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.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=11161 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=11161 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=11161 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=11161 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043	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 = 73924
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11161 AND type_rel = 2
0.0020	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=302 AND type_rel = 3
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 302 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025	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 (860396,835971,810791,799136,674706) 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 = '11161' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026	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 = '11161' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 73924 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020	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 = 72279 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	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=11161 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (73924,72279,71432) 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.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 72279 AND teamId = 11161
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 73924 AND teamId = 11161
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 11161
0.0024	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 = 72279 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0040	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 = 72279 WHERE rp.league_id = 72279 AND rp.teamId = 11161 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.0035	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 = 72279 WHERE rp.league_id = 72279 AND rp.teamId = 11161 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	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 = 72279 WHERE rp.league_id = 72279 AND rp.teamId = 11161 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 11161 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72279 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 68122 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.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* `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 = 63538 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.0072	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 = 58425 AND t.round = 27 ORDER BY team.conference ASC,t.position 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* `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 = 50613 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.0026	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 = 44790 AND t.round = 18 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* `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 = 38856 AND t.round = 27 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* `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 = 33947 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 15466 AND t.round = 27 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* `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 = 24432 AND t.round = 5 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 = 13702 AND t.round = 6 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* `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 = 4151 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 3589 AND t.round = 33 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* `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 = 2207 AND t.round = 33 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* `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 = 8651 AND t.round = 33 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* `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 = 8652 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 8667 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* `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 = 8668 AND t.round = 29 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 8670 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72279 ORDER BY nameShow LIMIT 100

Bregalnica Štip

Bregalnica Štip

Selecciona un equipo

Competiciones que juega

Liga Macedonia del Norte

RIVALES EN Copa Macedonia d.

RIVALES EN Liga Macedonia d.