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

Pelister

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 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

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 2
Equipo		PJ	GF	GC	Puntos
1	Pelister	16	32	14	33
2	FK Skopje	16	21	14	29
3	Labunishta	16	25	18	27
4	Velazerimi	16	15	19	25
5	Gostivar	16	21	19	23
6	Vardari	16	23	21	21
7	FK Korab	16	24	23	21
8	Drita	16	19	20	21
9	FK Ohrid	16	15	29	14
10	Kadino	16	15	33	10

TEMPORADA 2018/2019

SEGUNDA MACEDONIA DEL NORTE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Struga	18	20	13	34
2	Gostivar	18	29	22	27
3	Labunishta	18	14	14	27
4	FK Skopje	18	21	14	26
5	Pelister	18	15	15	26
6	Velazerimi	18	22	21	25
7	FK Korab	18	23	21	23
8	FK Goblen	18	14	20	20
9	Gench	18	19	26	18
10	Teteks	18	14	25	16

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

SEGUNDA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Pobeda	27	40	23	47
2	Makedonija	27	35	33	46
3	Teteks	27	27	25	39
4	Pelister	27	33	32	39
5	Vëllazërim	27	30	30	38
6	FK Skopje	27	27	23	36
7	Gorno	27	26	29	36
8	Ljubanci	27	32	31	34
9	Gostivar	27	29	34	33
10	Kozuv	27	17	36	17

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

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

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

TEMPORADA 2005/2006

SEGUNDA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Pelister	30	51	22	61
2	Napredok	30	44	37	52
3	Karaorman	30	47	38	50
4	Madzari	30	33	30	41
5	Sloga	30	35	39	40
6	FK Skopje	30	31	36	40
7	Turnovo	30	39	36	39
8	Vardar	30	34	45	37
9	Teteks	30	36	45	36
10	Metalurg	30	28	36	35
11	Novaci	30	28	42	31

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,806,312 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.1586
Total Execution Time	0.1600

CADENA URL

/historico/Pelister-Mk

GET DATOS

$_GET['/historico/Pelister-Mk']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0046	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 = 'Pelister-Mk' 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=17730 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=17730 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=17730 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=17730 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 73465
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17730 AND type_rel = 2
0.0017	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=374 AND type_rel = 3
0.0029	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 = '17730' ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '17730' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '17730' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 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 = 73465 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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=17730 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	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.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 73465 AND teamId = 17730
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 73924 AND teamId = 17730
0.0195	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17730
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 = 73465 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	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 = '17730' 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 = '17730' 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 = '17730' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020	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 = 17730 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.0019	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 = 17730 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020	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 = 17730 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 = 17730 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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.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* `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.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.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* `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 = 50614 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.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 = 44791 AND t.round = 18 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.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.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 = 15839 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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.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* `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
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* `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 = 8672 AND t.round = 33 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 = 73465 ORDER BY nameShow LIMIT 100

Pelister

Pelister

Selecciona un equipo

Competiciones que juega

Segunda Macedonia del Norte

RIVALES EN Copa Macedonia d.

RIVALES EN Segunda Macedoni.