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

Belasica

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	KF Besa	26	56	10	67
2	Pelister	26	51	13	61
3	Detonit	26	39	15	55
4	Aresimi	26	46	28	44
5	FK Ohrid	26	29	25	39
6	FK Skopje	26	24	23	39
7	Bashkimi	26	27	36	38
8	Vardar	26	27	29	35
9	Belasica	26	31	29	34
10	Kozuv	26	31	32	34
11	Novaci	26	29	44	28
12	Pobeda	26	26	35	27
13	Teteks	26	30	48	24
14	Osogovo	26	27	48	23
15	Sasa	26	28	49	19
16	Karaorman	26	19	56	15

TEMPORADA 2022/2023

SEGUNDA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Voska Sport	30	84	25	75
2	Gostivar	30	71	11	73
3	Vardar	30	55	20	63
4	Pelister	30	64	26	58
5	Detonit	30	43	35	50
6	KF Besa	30	43	29	48
7	FK Ohrid	30	31	35	41
8	Aresimi	30	41	35	40
9	Kozuv	30	40	54	36
10	Belasica	30	36	47	35
11	Karaorman	30	30	40	34
12	Sasa	30	31	49	31
13	Teteks	30	31	78	31
14	Lokomotiva	30	35	41	30
15	Sloga Vinica	30	26	47	25
16	FK Borec	30	13	102	2

TEMPORADA 2020/2021

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Shkëndija	33	69	26	75
2	Shkupi	33	41	24	59
3	Struga	33	39	24	57
4	Makedonija	33	53	43	55
5	Rabotnički	33	45	39	48
6	Pelister	33	34	38	45
7	AP Brera	33	32	36	41
8	FK Borec	33	32	36	40
9	Sileks	33	49	45	36
10	Renova	33	36	46	36
11	Vardar	33	32	60	31
12	Belasica	33	23	68	17

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

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Shkëndija	36	80	29	79
2	Vardar	36	45	23	64
3	AP Brera	36	45	35	58
4	Shkupi	36	40	42	48
5	Renova	36	53	49	47
6	Makedonija	36	45	50	47
7	Rabotnički	36	43	49	46
8	Sileks	36	27	39	44
9	Belasica	36	37	49	38
10	Pobeda	36	26	76	23

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 2011/2012

SEGUNDA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Pelister	30	42	23	61
2	Drita	30	49	19	58
3	Gorno	30	60	30	56
4	FK Skopje	30	50	26	56
5	Miravci	30	46	23	54
6	Makedonija	30	48	31	48
7	Tikves	30	45	41	45
8	FK Rufeja	30	48	35	44
9	Lokomotiva	30	35	33	43
10	Gostivar	30	39	34	41
11	Pobeda	30	36	38	41
12	FK Korab	30	34	45	36
13	Vëllazërim	30	28	68	29
14	Osogovo	30	29	64	22
15	Ohrid Lote	30	24	74	19
16	Belasica	30	27	56	18

TEMPORADA 2010/2011

SEGUNDA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	11 Oktomvri	26	50	19	54
2	FK Ohrid	26	51	21	53
3	Tikves	26	45	27	48
4	Miravci	26	43	22	46
5	Belasica	26	39	26	43
6	Gostivar	26	25	19	39
7	Drita	26	37	29	35
8	Gorno	26	41	49	35
9	Lokomotiva	26	27	46	31
10	Ohrid Lote	26	40	49	29
11	Vëllazërim	26	28	56	27
12	Novaci	26	22	37	22
13	Cementarnica	26	20	41	22
14	Vlaznimi	26	24	51	22

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

SEGUNDA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Milano	33	74	31	69
2	Cementarnica	33	53	24	59
3	Teteks	33	48	32	54
4	FK Skopje	33	32	21	49
5	Turnovo	33	36	41	45
6	Sloga	33	48	46	43
7	Metalurg	33	38	37	43
8	Madzari	33	35	33	42
9	Belasica	33	36	59	40
10	Karaorman	33	37	50	39
11	Vardar	33	26	56	33
12	Ilinden	33	30	63	21

TEMPORADA 2005/2006

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Rabotnički	33	64	26	72
2	Makedonija	33	55	23	69
3	Vardar	33	42	19	64
4	Pobeda	33	58	46	54
5	Shkëndija	33	48	47	49
6	Bashkimi	33	50	49	45
7	Renova	33	45	49	44
8	Vëllazërim	33	44	57	43
9	Sileks	33	54	58	41
10	Bregalnica	33	43	54	36
11	Cementarnica	33	37	50	32
12	Belasica	33	22	84	8

TEMPORADA 2004/2005

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Rabotnički	33	66	23	78
2	Vardar	33	68	34	72
3	Pobeda	33	59	49	55
4	Sileks	33	56	37	51
5	Shkëndija	33	59	40	50
6	Bashkimi	33	53	47	49
7	Belasica	33	53	47	48
8	Bregalnica	33	55	59	48
9	Cementarnica	33	54	50	43
10	Madzari	33	35	46	41
11	Sloga	33	37	80	17
12	Napredok	33	16	99	7

TEMPORADA 2003/2004

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Pobeda	33	78	42	71
2	Sileks	33	67	32	66
3	Vardar	33	66	39	60
4	Rabotnički	33	58	40	58
5	Sloga	33	69	36	57
6	Madzari	33	44	30	50
7	Cementarnica	33	48	41	45
8	Bashkimi	33	44	54	43
9	Napredok	33	51	52	41
10	Belasica	33	37	55	36
11	Tikves	33	25	62	19
12	Bregalnica	33	20	124	7

TEMPORADA 2002/2003

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Vardar	33	73	37	72
2	Belasica	33	50	32	69
3	Pobeda	33	55	33	65
4	Rabotnički	33	41	35	54
5	Sloga	33	62	50	51
6	Sileks	33	40	35	46
7	Cementarnica	33	45	39	42
8	Napredok	33	39	41	42
9	Tikves	33	37	58	37
10	Bregalnica	33	44	49	36
11	Pelister	33	30	60	28
12	Kumanovo	33	24	71	17

TEMPORADA 2001/2002

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Pobeda	22	41	23	44
2	Belasica	22	36	19	44
3	Vardar	22	29	18	41
4	Rabotnički	22	40	25	39
5	Cementarnica	22	32	19	35
6	Sloga	22	32	22	35
7	Sileks	22	44	35	33
8	Kumanovo	22	27	42	32
9	Napredok	22	17	33	24
10	Pelister	22	24	40	19
11	Osogovo	22	18	40	16
12	Makedonija	22	14	38	15

TEMPORADA 2000/2001

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Sloga	26	61	15	63
2	Vardar	26	52	16	63
3	Pobeda	26	64	27	56
4	Belasica	26	56	22	55
5	Sileks	26	52	40	43
6	Rabotnički	26	43	36	39
7	Cementarnica	26	38	31	36
8	Pelister	26	41	38	34
9	Osogovo	26	39	42	34
10	Makedonija	26	45	42	31
11	Sasa	26	39	47	29
12	Shkëndija	26	34	48	28
13	FK Borec	26	18	80	13
14	Tikves	26	12	110	3

TEMPORADA 1997/1998

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Sileks	25	40	21	48
2	Sloga	25	25	16	43
3	Makedonija	25	34	21	42
4	Vardar	25	34	25	41
5	Pobeda	25	29	21	39
6	Pelister	25	31	24	37
7	FK Borec	25	27	30	33
8	FK Balkan	25	20	21	31
9	Cementarnica	25	28	31	30
10	FK Skopje	25	31	45	30
11	Tikves	25	23	27	29
12	Sasa	25	21	32	29
13	Belasica	25	25	35	28
14	Bregalnica	13	13	32	12

Competiciones que juega

Segunda Macedonia del Norte

Pos	Equipos		Pts
1		KF Besa	67
2		Pelister	61
3		Detonit Plachkovica	55
4		Aresimi	44
5		FK Ohrid	39
6		FK Skopje	39
7		Bashkimi	38
8		Vardar Negotino	35
9		Belasica	34
10		Kozuv Gevgelija	34
11		Novaci	28
12		FK Pobeda Prilep	27
13		Teteks	24
14		Osogovo	23
15		Sasa	19
16		Karaorman Struga	15

	Ascenso : KF Besa, Pelister
	Playoff Ascenso : Detonit Plachkovica
	Playoff Descenso : Osogovo
	Descenso : Sasa, Karaorman Struga

RIVALES EN Copa Macedonia d.

RIVALES EN Segunda Macedoni.

USO DE MEMORIA

6,996,152 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	1.6988
Total Execution Time	1.7007

CADENA URL

/historico/Belasica

GET DATOS

$_GET['/historico/Belasica']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.1078	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 = 'Belasica' 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.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=59385 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=59385 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=59385 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=59385 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59385 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=374 AND type_rel = 3
0.1116	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 = '59385' ORDER BY l.year DESC,cat.coefficient DESC
0.0706	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 = '59385' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.1198	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 = '59385' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0249	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.0188	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 = 73465 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0895	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=59385 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0224	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,73465,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.0386	SELECT count(id) as num_players from rel_players WHERE league_id = 73465 AND teamId = 59385
0.1100	SELECT count(id) as num_players from rel_players WHERE league_id = 73924 AND teamId = 59385
0.0722	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 59385
0.0434	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 = 73465 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0194	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 = '59385' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0050	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '59385' and rp.type = 4
0.0071	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 = '59385' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0170	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 = 73465 WHERE rp.league_id = 73465 AND rp.teamId = 59385 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.0345	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 = 73465 WHERE rp.league_id = 73465 AND rp.teamId = 59385 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0170	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 = 73465 WHERE rp.league_id = 73465 AND rp.teamId = 59385 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0922	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 = 59385 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0726	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 = 73465 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0575	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 = 68725 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.0266	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 = 57381 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.0101	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.0339	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 = 44668 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125	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.0209	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 = 8666 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0230	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 = 8669 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0240	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.0362	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.0211	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.0381	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 = 8671 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0240	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 = 8657 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0271	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 = 8658 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0299	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 = 8659 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0491	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* `tables2003` 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 = 8660 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0539	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* `tables2002` 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 = 8661 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0294	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* `tables2001` 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 = 8662 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0221	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* `tables1998` 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 = 8665 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Belasica

Belasica

Selecciona un equipo

Competiciones que juega

Segunda Macedonia del Norte

RIVALES EN Copa Macedonia d.

RIVALES EN Segunda Macedoni.