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

Vardar Skopje

Entrenador: Gorazd Mihajlov

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Shkëndija	31	53	25	61
2	Struga	31	53	31	61
3	Shkupi	31	40	22	58
4	Tikves	31	39	38	42
5	Rabotnički	31	29	32	41
6	Sileks	31	34	38	41
7	Voska Sport	31	36	40	40
8	Gostivar	31	31	37	40
9	AP Brera	31	29	30	38
10	Vardar	31	25	40	35
11	Bregalnica	31	25	47	27
12	Makedonija	31	24	38	26

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 2021/2022

SEGUNDA MACEDONIA DEL NORTE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sileks	27	55	9	66
2	Voska Sport	27	51	14	59
3	Vardar	27	47	15	58
4	Gostivar	27	36	37	37
5	Teteks	27	32	44	36
6	KF Besa	27	41	28	35
7	FK Ohrid	27	34	32	32
8	FK Korab	27	33	43	27
9	Veleshta	27	25	61	18
10	Kadino	27	13	84	7

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

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Vardar	23	33	14	46
2	Sileks	23	24	21	36
3	Shkëndija	23	38	20	35
4	Renova	23	25	33	31
5	Shkupi	23	28	28	29
6	Makedonija	23	24	28	29
7	AP Brera	23	20	20	28
8	Rabotnički	23	21	29	28
9	FK Borec	23	20	31	27
10	Struga	23	19	28	25

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

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Shkëndija	36	101	27	91
2	Vardar	36	53	41	56
3	Rabotnički	36	50	43	52
4	Shkupi	36	51	46	51
5	Sileks	36	30	37	50
6	AP Brera	36	43	47	42
7	Renova	36	36	53	41
8	Pobeda	36	36	56	38
9	FK Skopje	36	24	43	35
10	Pelister	36	37	68	34

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

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Renova	26	45	21	55
2	Rabotnički	26	38	20	50
3	Metalurg	26	35	16	47
4	Pelister	26	28	27	39
5	Sileks	26	29	33	32
6	Vardar	26	31	28	30
7	Teteks	26	31	30	30
8	Turnovo	26	27	35	26
9	Milano	26	14	81	6
10	Makedonija	10	23	5	0
11	Pobeda	0	0	0	0
12	Sloga	10	9	14	0

TEMPORADA 2008/2009

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Makedonija	30	46	15	61
2	Milano	30	48	35	55
3	Renova	30	41	26	54
4	Rabotnički	30	40	25	47
5	Vardar	30	35	23	45
6	Turnovo	30	25	39	37
7	Sileks	30	38	41	36
8	Pobeda	30	31	47	32
9	Metalurg	30	25	35	29
10	Pelister	30	25	42	28
11	Napredok	30	26	52	21

TEMPORADA 2007/2008

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Rabotnički	33	51	11	79
2	Milano	33	74	35	66
3	Pelister	33	42	27	58
4	Vardar	33	44	40	47
5	Renova	33	34	34	47
6	Pobeda	33	48	48	45
7	Makedonija	33	34	42	44
8	Napredok	33	38	49	42
9	Sileks	33	33	36	41
10	Bashkimi	33	40	63	30
11	Shkëndija	33	26	57	26
12	Cementarnica	33	24	46	24

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		KF Shkëndija	61
2		Struga	61
3		Shkupi	58
4		Tikves	42
5		Rabotnički	41
6		Sileks	41
7		Voska Sport	40
8		Gostivar	40
9		AP Brera	38
10		Vardar Skopje	35
11		Bregalnica Štip	27
12		Makedonija GP	26

	Campeón : KF Shkëndija
	: Struga
	Playoff Descenso : AP Brera, Vardar Skopje
	Descenso : Bregalnica Štip, Makedonija GP

RIVALES EN Copa Macedonia d.

RIVALES EN Liga Macedonia d.

USO DE MEMORIA

6,755,928 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1531
Total Execution Time	0.1543

CADENA URL

/historico/Vardar

GET DATOS

$_GET['/historico/Vardar']

POST DATOS

No hay datos POST existentes

CONSULTAS (49)

0.0042	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 = 'Vardar' 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=17733 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=17733 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=17733 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=17733 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0044	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=17733 AND type_rel = 2
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17733 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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 (265225,281721,284746,291263,297551) ORDER BY n.cover_points DESC, update_date DESC
0.0036	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 = '17733' ORDER BY l.year DESC,cat.coefficient DESC
0.0032	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 = '17733' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0031	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 = '17733' 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.0019	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.0025	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=17733 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,71741,71432,68725) 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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 72279 AND teamId = 17733
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 68725 AND teamId = 17733
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 73924 AND teamId = 17733
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 71741 AND teamId = 17733
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17733
0.0021	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 = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021	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 = '17733' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17733' and rp.type = 4
0.0020	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 = '17733' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036	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 = 17733 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 72279 WHERE rp.league_id = 72279 AND rp.teamId = 17733 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 17733 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 = 17733 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 = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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.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* `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 = 64026 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* `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.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 = 50135 AND t.round = 23 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* `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.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* `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 = 38855 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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.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* `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.0020	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.0020	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 = 13701 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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.0021	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.0021	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.0021	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.0021	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.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* `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 = 8653 AND t.round = 31 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* `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 = 8654 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* `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 = 8655 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* `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 = 8656 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Vardar Skopje

Vardar Skopje

Selecciona un equipo

Competiciones que juega

Liga Macedonia del Norte

RIVALES EN Copa Macedonia d.

RIVALES EN Liga Macedonia d.