Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

Tikves

Entrenador: Gjorgji Mojsov

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

SEGUNDA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	AP Brera	27	69	24	66
2	FK Skopje	27	43	26	54
3	Novaci	27	39	27	45
4	Turnovo	27	37	29	36
5	Gorno	27	29	30	35
6	Vëllazërim	27	33	36	32
7	Teteks	27	16	29	28
8	Tikves	27	25	53	28
9	Metalurg	27	27	50	26
10	Vardar	27	17	31	25

TEMPORADA 2012/2013

SEGUNDA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Makedonija	30	60	21	67
2	Gostivar	30	55	17	65
3	FK Skopje	30	59	18	63
4	Gorno	30	47	16	61
5	FK Rufeja	30	46	19	56
6	Miravci	30	50	29	53
7	Pobeda	30	34	44	39
8	Vrapciste	30	39	41	37
9	FK Korzo	30	42	42	35
10	Madzari	30	39	44	34
11	Novaci	30	40	57	34
12	Lokomotiva	30	41	53	33
13	11 Oktomvri	30	40	55	33
14	Babi Štip	30	35	44	30
15	Tikves	30	24	76	19
16	FK Ohrid	30	25	100	13

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 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 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 1999/2000

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Sloga	26	55	13	61
2	Pobeda	26	57	23	52
3	Rabotnički	26	41	26	50
4	Pelister	26	47	29	47
5	Cementarnica	26	43	29	47
6	Sileks	26	42	28	40
7	Makedonija	26	29	28	36
8	Tikves	26	37	54	31
9	FK Borec	26	30	43	30
10	Vardar	26	40	38	29
11	Sasa	26	22	34	28
12	Osogovo	26	35	54	26
13	Napredok	26	30	48	20
14	Kumanovo	26	16	77	9

TEMPORADA 1998/1999

LIGA MACEDONIA DEL NORTE
Equipo		PJ	GF	GC	Puntos
1	Sloga	26	40	12	60
2	Sileks	26	62	21	57
3	Pobeda	26	52	18	53
4	Vardar	26	61	32	49
5	Cementarnica	26	47	37	44
6	Makedonija	26	44	40	37
7	Tikves	26	34	38	36
8	FK Borec	26	31	34	32
9	Rabotnički	26	38	46	32
10	Pelister	26	30	50	29
11	Sasa	26	28	38	26
12	Osogovo	26	27	48	25
13	FK Skopje	26	26	59	17
14	FK Balkan	26	13	60	16

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

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,727,144 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1305
Total Execution Time	0.1317

CADENA URL

/historico/Tikves

GET DATOS

$_GET['/historico/Tikves']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59386 AND type_rel = 2
0.0028	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 = '59386' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	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.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=59386 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 72279 AND teamId = 59386
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 73924 AND teamId = 59386
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 59386
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 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 = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0049	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 = 59386 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.0053	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 = 59386 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 59386 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 = 59386 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 30 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 = 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.0035	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.0034	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.0030	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.0038	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.0039	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.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* `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 = 33982 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040	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 = 2856 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037	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.0032	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.0030	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.0030	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.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* `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.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* `tables2000` 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 = 8663 AND t.round = 26 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* `tables1999` 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 = 8664 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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
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

Tikves

Tikves

Selecciona un equipo

Competiciones que juega

Liga Macedonia del Norte

RIVALES EN Copa Macedonia d.

RIVALES EN Liga Macedonia d.