4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Belasica
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
TEMPORADA 2006/2007
SEGUNDA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 FK Milano Kumanovo Milano 33 74 31 69
2 Cementarnica 55 Cementarnica 33 53 24 59
3 Teteks Teteks 33 48 32 54
4 FK Skopje FK Skopje 33 32 21 49
5 Turnovo Turnovo 33 36 41 45
6 Sloga Jugomagnat Sloga 33 48 46 43
7 Metalurg Skopje Metalurg 33 38 37 43
8 Madzari Solidarnost Madzari 33 35 33 42
9 Belasica Belasica 33 36 59 40
10 Karaorman Struga Karaorman 33 37 50 39
11 Vardar Negotino Vardar 33 26 56 33
12 Ilinden Velmej Ilinden 33 30 63 21
TEMPORADA 2005/2006
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Rabotnički Rabotnički 33 64 26 72
2 Makedonija GP Makedonija 33 55 23 69
3 Vardar Skopje Vardar 33 42 19 64
4 FK Pobeda Prilep Pobeda 33 58 46 54
5 KF Shkëndija Shkëndija 33 48 47 49
6 Bashkimi Bashkimi 33 50 49 45
7 Renova Renova 33 45 49 44
8 Vëllazërimi Vëllazërim 33 44 57 43
9 Sileks Sileks 33 54 58 41
10 Bregalnica Štip Bregalnica 33 43 54 36
11 Cementarnica 55 Cementarnica 33 37 50 32
12 Belasica Belasica 33 22 84 8
TEMPORADA 2004/2005
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Rabotnički Rabotnički 33 66 23 78
2 Vardar Skopje Vardar 33 68 34 72
3 FK Pobeda Prilep Pobeda 33 59 49 55
4 Sileks Sileks 33 56 37 51
5 KF Shkëndija Shkëndija 33 59 40 50
6 Bashkimi Bashkimi 33 53 47 49
7 Belasica Belasica 33 53 47 48
8 Bregalnica Štip Bregalnica 33 55 59 48
9 Cementarnica 55 Cementarnica 33 54 50 43
10 Madzari Solidarnost Madzari 33 35 46 41
11 Sloga Jugomagnat Sloga 33 37 80 17
12 Napredok Kičevo Napredok 33 16 99 7
TEMPORADA 2003/2004
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 FK Pobeda Prilep Pobeda 33 78 42 71
2 Sileks Sileks 33 67 32 66
3 Vardar Skopje Vardar 33 66 39 60
4 Rabotnički Rabotnički 33 58 40 58
5 Sloga Jugomagnat Sloga 33 69 36 57
6 Madzari Solidarnost Madzari 33 44 30 50
7 Cementarnica 55 Cementarnica 33 48 41 45
8 Bashkimi Bashkimi 33 44 54 43
9 Napredok Kičevo Napredok 33 51 52 41
10 Belasica Belasica 33 37 55 36
11 Tikves Tikves 33 25 62 19
12 Bregalnica Delcevo Bregalnica 33 20 124 7
TEMPORADA 2002/2003
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Vardar Skopje Vardar 33 73 37 72
2 Belasica Belasica 33 50 32 69
3 FK Pobeda Prilep Pobeda 33 55 33 65
4 Rabotnički Rabotnički 33 41 35 54
5 Sloga Jugomagnat Sloga 33 62 50 51
6 Sileks Sileks 33 40 35 46
7 Cementarnica 55 Cementarnica 33 45 39 42
8 Napredok Kičevo Napredok 33 39 41 42
9 Tikves Tikves 33 37 58 37
10 Bregalnica Delcevo Bregalnica 33 44 49 36
11 Pelister Pelister 33 30 60 28
12 Kumanovo Kumanovo 33 24 71 17
TEMPORADA 2001/2002
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 FK Pobeda Prilep Pobeda 22 41 23 44
2 Belasica Belasica 22 36 19 44
3 Vardar Skopje Vardar 22 29 18 41
4 Rabotnički Rabotnički 22 40 25 39
5 Cementarnica 55 Cementarnica 22 32 19 35
6 Sloga Jugomagnat Sloga 22 32 22 35
7 Sileks Sileks 22 44 35 33
8 Kumanovo Kumanovo 22 27 42 32
9 Napredok Kičevo Napredok 22 17 33 24
10 Pelister Pelister 22 24 40 19
11 Osogovo Osogovo 22 18 40 16
12 Makedonija GP Makedonija 22 14 38 15
TEMPORADA 2000/2001
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Sloga Jugomagnat Sloga 26 61 15 63
2 Vardar Skopje Vardar 26 52 16 63
3 FK Pobeda Prilep Pobeda 26 64 27 56
4 Belasica Belasica 26 56 22 55
5 Sileks Sileks 26 52 40 43
6 Rabotnički Rabotnički 26 43 36 39
7 Cementarnica 55 Cementarnica 26 38 31 36
8 Pelister Pelister 26 41 38 34
9 Osogovo Osogovo 26 39 42 34
10 Makedonija GP Makedonija 26 45 42 31
11 Sasa Sasa 26 39 47 29
12 KF Shkëndija Shkëndija 26 34 48 28
13 FK Borec FK Borec 26 18 80 13
14 Tikves Tikves 26 12 110 3
TEMPORADA 1997/1998
LIGA MACEDONIA DEL NORTE
Equipo PJ GF GC Puntos
1 Sileks Sileks 25 40 21 48
2 Sloga Jugomagnat Sloga 25 25 16 43
3 Makedonija GP Makedonija 25 34 21 42
4 Vardar Skopje Vardar 25 34 25 41
5 FK Pobeda Prilep Pobeda 25 29 21 39
6 Pelister Pelister 25 31 24 37
7 FK Borec FK Borec 25 27 30 33
8 FK Balkan FK Balkan 25 20 21 31
9 Cementarnica 55 Cementarnica 25 28 31 30
10 FK Skopje FK Skopje 25 31 45 30
11 Tikves Tikves 25 23 27 29
12 Sasa Sasa 25 21 32 29
13 Belasica Belasica 25 25 35 28
14 Bregalnica Delcevo Bregalnica 13 13 32 12

  USO DE MEMORIA  
5,848,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6077
Total Execution Time  0.6090
  CADENA URL  
/historico/Belasica/2009
  GET DATOS  
$_GET['/historico/Belasica/2009']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0137  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 = 2009 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.0125  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.0125  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.0125  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.0253  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 = 8668
0.0131  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 = 21437
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59385 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=374 AND type_rel = 3
0.0131  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.0129  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 = 2009 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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.0126  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 = 21437 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 8668 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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 (2008,2009,2010) ORDER BY l.id DESC, l.year DESC ;
0.0129  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 (63144,43631,21438,8670) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 8670 AND teamId = 59385
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 21438 AND teamId = 59385
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 43631 AND teamId = 59385
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 63144 AND teamId = 59385
0.0139  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0136  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.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '59385' and rp.type = 4
0.0135  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.0136  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 events2009 e ON e.player_id = p.id AND e.league_id = 8668 WHERE rp.league_id = 8668 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.0137  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 events2009 e ON e.player_id = p.id AND e.league_id = 8668 WHERE rp.league_id = 8668 AND rp.teamId = 59385 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 events2009 e ON e.player_id = p.id AND e.league_id = 8668 WHERE rp.league_id = 8668 AND rp.teamId = 59385 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 <= 2009 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0139  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.0135  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.0129  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.0129  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.0131  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.0129  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.0129  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.0128  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.0129  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.0130  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.0126  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 = 8668 ORDER BY nameShow LIMIT 100