4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FK Ohrid
TEMPORADA 2023/2024
SEGUNDA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 KF Besa KF Besa 28 67 10 73
2 Pelister Pelister 28 56 14 67
3 Detonit Plachkovica Detonit 28 40 18 56
4 Aresimi Aresimi 28 51 28 50
5 FK Ohrid FK Ohrid 28 32 30 42
6 FK Skopje FK Skopje 28 26 26 40
7 Vardar Negotino Vardar 28 30 29 39
8 Belasica Belasica 28 35 29 38
9 Bashkimi Bashkimi 28 28 40 38
10 Kozuv Gevgelija Kozuv 28 33 34 37
11 Novaci Novaci 28 36 46 31
12 FK Pobeda Prilep Pobeda 28 27 39 28
13 Osogovo Osogovo 28 29 52 26
14 Teteks Teteks 28 30 58 24
15 Sasa Sasa 28 29 49 23
16 Karaorman Struga Karaorman 28 19 66 15
TEMPORADA 2022/2023
SEGUNDA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Voska Sport Voska Sport 30 84 25 75
2 Gostivar Gostivar 30 71 11 73
3 Vardar Skopje Vardar 30 55 20 63
4 Pelister Pelister 30 64 26 58
5 Detonit Plachkovica Detonit 30 43 35 50
6 KF Besa KF Besa 30 43 29 48
7 FK Ohrid FK Ohrid 30 31 35 41
8 Aresimi Aresimi 30 41 35 40
9 Kozuv Gevgelija Kozuv 30 40 54 36
10 Belasica Belasica 30 36 47 35
11 Karaorman Struga Karaorman 30 30 40 34
12 Sasa Sasa 30 31 49 31
13 Teteks Teteks 30 31 78 31
14 Lokomotiva Skopje Lokomotiva 30 35 41 30
15 Sloga Vinica Sloga Vinica 30 26 47 25
16 FK Borec FK Borec 30 13 102 2
TEMPORADA 2021/2022
SEGUNDA MACEDONIA DEL NORTE GRUPO 2
Equipo PJ GF GC Puntos
1 Sileks Sileks 27 55 9 66
2 Voska Sport Voska Sport 27 51 14 59
3 Vardar Skopje Vardar 27 47 15 58
4 Gostivar Gostivar 27 36 37 37
5 Teteks Teteks 27 32 44 36
6 KF Besa KF Besa 27 41 28 35
7 FK Ohrid FK Ohrid 27 34 32 32
8 FK Korab FK Korab 27 33 43 27
9 Veleshta Veleshta 27 25 61 18
10 Kadino Skopje Kadino 27 13 84 7
TEMPORADA 2020/2021
SEGUNDA MACEDONIA DEL NORTE GRUPO 2
Equipo PJ GF GC Puntos
1 FK Skopje FK Skopje 26 50 20 60
2 FK Ohrid FK Ohrid 26 26 13 46
3 Veleshta Veleshta 26 32 23 46
4 Gostivar Gostivar 26 33 30 43
5 FK Korab FK Korab 26 28 27 36
6 Kadino Skopje Kadino 26 24 24 28
7 Velazerimi 77 Velazerimi 26 26 34 27
8 Labunishta Labunishta 26 19 34 27
9 Drita Bogovinje Drita 26 28 41 21
10 Vardari Forino Vardari 18 15 35 13
TEMPORADA 2019/2020
SEGUNDA MACEDONIA DEL NORTE GRUPO 2
Equipo PJ GF GC Puntos
1 Pelister Pelister 16 32 14 33
2 FK Skopje FK Skopje 16 21 14 29
3 Labunishta Labunishta 16 25 18 27
4 Velazerimi 77 Velazerimi 16 15 19 25
5 Gostivar Gostivar 16 21 19 23
6 Vardari Forino Vardari 16 23 21 21
7 FK Korab FK Korab 16 24 23 21
8 Drita Bogovinje Drita 16 19 20 21
9 FK Ohrid FK Ohrid 16 15 29 14
10 Kadino Skopje Kadino 16 15 33 10
TEMPORADA 2012/2013
SEGUNDA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Makedonija GP Makedonija 30 60 21 67
2 Gostivar Gostivar 30 55 17 65
3 FK Skopje FK Skopje 30 59 18 63
4 Gorno Lisiče Gorno 30 47 16 61
5 FK Rufeja FK Rufeja 30 46 19 56
6 Miravci Miravci 30 50 29 53
7 Pobeda Junior Pobeda 30 34 44 39
8 Vrapciste Vrapciste 30 39 41 37
9 FK Korzo FK Korzo 30 42 42 35
10 Madzari Solidarnost Madzari 30 39 44 34
11 Novaci Novaci 30 40 57 34
12 Lokomotiva Skopje Lokomotiva 30 41 53 33
13 11 Oktomvri 11 Oktomvri 30 40 55 33
14 Babi Štip Babi Štip 30 35 44 30
15 Tikves Tikves 30 24 76 19
16 FK Ohrid FK Ohrid 30 25 100 13
TEMPORADA 2011/2012
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Vardar Skopje Vardar 33 50 15 76
2 Metalurg Skopje Metalurg 33 53 16 67
3 KF Shkëndija Shkëndija 33 53 28 66
4 Renova Renova 33 56 38 52
5 Bregalnica Štip Bregalnica 33 51 47 45
6 Sileks Sileks 33 42 51 42
7 Napredok Kičevo Napredok 33 37 51 42
8 Rabotnički Rabotnički 33 50 45 41
9 Turnovo Turnovo 33 34 42 38
10 Teteks Teteks 33 23 48 35
11 FK Ohrid FK Ohrid 33 26 62 26
12 11 Oktomvri 11 Oktomvri 33 26 58 16
TEMPORADA 2010/2011
SEGUNDA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 11 Oktomvri 11 Oktomvri 26 50 19 54
2 FK Ohrid FK Ohrid 26 51 21 53
3 Tikves Tikves 26 45 27 48
4 Miravci Miravci 26 43 22 46
5 Belasica Belasica 26 39 26 43
6 Gostivar Gostivar 26 25 19 39
7 Drita Bogovinje Drita 26 37 29 35
8 Gorno Lisiče Gorno 26 41 49 35
9 Lokomotiva Skopje Lokomotiva 26 27 46 31
10 Ohrid Lote Ohrid Lote 26 40 49 29
11 Vëllazërimi Vëllazërim 26 28 56 27
12 Novaci Novaci 26 22 37 22
13 Cementarnica 55 Cementarnica 26 20 41 22
14 Vlaznimi Struga Vlaznimi 26 24 51 22
TEMPORADA 2009/2010
SEGUNDA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 KF Shkëndija Shkëndija 26 57 15 57
2 FK Skopje FK Skopje 26 49 22 57
3 Napredok Kičevo Napredok 26 55 32 54
4 Bregalnica Štip Bregalnica 26 49 20 52
5 Drita Bogovinje Drita 26 36 34 41
6 Miravci Miravci 26 31 31 36
7 11 Oktomvri 11 Oktomvri 26 30 34 34
8 Belasica Belasica 26 27 40 33
9 Novaci Novaci 26 26 37 31
10 Lokomotiva Skopje Lokomotiva 26 29 30 29
11 Vlaznimi Struga Vlaznimi 26 26 42 28
12 Cementarnica 55 Cementarnica 26 21 40 26
13 Vëllazërimi Vëllazërim 26 16 49 14
14 FK Ohrid FK Ohrid 26 26 52 13
TEMPORADA 2008/2009
SEGUNDA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Teteks Teteks 29 50 13 63
2 Sloga Jugomagnat Sloga 29 31 12 59
3 KF Shkëndija Shkëndija 29 67 29 55
4 Bregalnica Štip Bregalnica 29 45 21 51
5 Drita Bogovinje Drita 29 45 30 50
6 Lokomotiva Skopje Lokomotiva 29 47 29 48
7 Miravci Miravci 29 36 23 43
8 Belasica Belasica 29 34 33 38
9 FK Skopje FK Skopje 29 36 38 38
10 Novaci Novaci 29 35 50 31
11 FK Ohrid FK Ohrid 29 31 50 30
12 Cementarnica 55 Cementarnica 29 25 45 29
13 Kozuv Gevgelija Kozuv 29 28 50 26
14 Vardar Negotino Vardar 29 25 75 25
15 Madzari Solidarnost Madzari 29 32 54 23
16 Nov Milenium Milenium 15 12 27 10
TEMPORADA 2007/2008
SEGUNDA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Turnovo Turnovo 32 58 23 71
2 Metalurg Skopje Metalurg 32 47 24 67
3 Miravci Miravci 32 60 22 65
4 Belasica Belasica 32 49 37 55
5 FK Skopje FK Skopje 32 53 44 54
6 Drita Bogovinje Drita 32 47 30 47
7 Teteks Teteks 32 32 30 47
8 Sloga Jugomagnat Sloga 32 36 34 44
9 FK Ohrid FK Ohrid 32 43 53 41
10 Madzari Solidarnost Madzari 32 33 39 40
11 Nov Milenium Milenium 32 41 36 39
12 Alumina Skopje Alumina 32 28 37 39
13 Vardar Negotino Vardar 32 42 58 39
14 Lokomotiva Skopje Lokomotiva 32 40 47 38
15 Bregalnica Štip Bregalnica 32 36 43 37
16 Karaorman Struga Karaorman 32 23 57 26
17 Vëllazërimi Vëllazërim 32 28 82 17

  USO DE MEMORIA  
6,105,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1271
Total Execution Time  0.1291
  CADENA URL  
/historico/Fk-Ohrid
  GET DATOS  
$_GET['/historico/Fk-Ohrid']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
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 = 'Fk-Ohrid' 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.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=59378 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=59378 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=59378 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=59378 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 = 73465
0.0025  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59378 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=374 AND type_rel = 3
0.0034  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 = '59378' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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.0024  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.0037  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=59378 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023  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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 73465 AND teamId = 59378
0.0036  SELECT count(id) as num_players from rel_players WHERE league_id = 73924 AND teamId = 59378
0.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 59378
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 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 = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '59378' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '59378' and rp.type = 4
0.0025  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 = '59378' 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 = 59378 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 = 59378 AND (e.action = 4 or e.action = 5) 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 = 59378 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 59378 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 = 28 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 `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.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 `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 = 58426 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.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.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 `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.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 `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 = 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.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 `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.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 `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.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 = 8670 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC