4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Spartak Plovdiv
TEMPORADA 1994/1995
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Levski Sofia Levski Sofia 30 84 15 79
2 Lokomotiv Sofia Lokomotiv 30 59 30 68
3 Botev Plovdiv Botev 30 66 31 60
4 Slavia Sofia Slavia Sofia 30 63 35 53
5 CSKA Sofia CSKA Sofia 30 51 46 46
6 Spartak Plovdiv Spartak 30 33 34 43
7 Lokomotiv Plovdiv Lokomotiv 30 48 38 42
8 Neftochimik Neftochimik 30 41 50 39
9 Shumen 2010 Shumen 2010 30 33 50 36
10 Litex Lovech Litex Lovech 30 25 46 36
11 Etar Etar 30 31 54 36
12 Dobrudzha Dobrich Dobrudzha 30 32 43 35
13 Montana Montana 30 31 41 34
14 Gorna Lokomotiv Oryahovitsa Gorna 30 35 53 33
15 Pirin Blagoevgrad Pirin 30 30 46 30
16 Beroe Beroe 30 27 77 12
TEMPORADA 1966/1967
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Botev Plovdiv Botev 30 39 24 51
2 Slavia Sofia Slavia Sofia 30 33 27 50
3 Levski Sofia Levski Sofia 30 46 32 49
4 Spartak Sofia Spartak 30 40 26 48
5 Cherno More Varna Cherno More 30 40 29 45
6 CSKA Sofia CSKA Sofia 30 42 34 45
7 Botev Vratsa Botev Vratsa 30 45 40 45
8 Lokomotiv Sofia Lokomotiv 30 39 34 43
9 Chernomoretz Burgas Chernomoretz 30 38 35 40
10 Beroe Beroe 30 37 41 39
11 Lokomotiv Plovdiv Lokomotiv 30 30 31 35
12 Spartak Plovdiv Spartak 30 26 35 35
13 Dobrudzha Dobrich Dobrudzha 30 24 43 35
14 Dunav Ruse Dunav Ruse 30 35 60 31
15 FK Minyor Pernik Minyor 30 24 30 29
16 Marek Marek 30 24 41 29
TEMPORADA 1965/1966
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 CSKA Sofia CSKA Sofia 30 53 30 59
2 Levski Sofia Levski Sofia 30 59 31 56
3 Slavia Sofia Slavia Sofia 30 38 25 55
4 Spartak Sofia Spartak 30 45 30 50
5 Lokomotiv Plovdiv Lokomotiv 30 36 33 43
6 Dunav Ruse Dunav Ruse 30 29 40 42
7 Beroe Beroe 30 41 41 40
8 Lokomotiv Sofia Lokomotiv 30 46 35 39
9 Spartak Plovdiv Spartak 30 28 42 37
10 Botev Plovdiv Botev 30 41 39 36
11 Marek Marek 30 39 51 36
12 Cherno More Varna Cherno More 30 30 35 35
13 Botev Vratsa Botev Vratsa 30 30 41 34
14 Chernomoretz Burgas Chernomoretz 30 34 48 33
15 Spartak Varna Spartak 30 32 48 28
16 Spartak Pleven Spartak 30 30 42 27
TEMPORADA 1964/1965
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Levski Sofia Levski Sofia 30 59 28 60
2 Lokomotiv Sofia Lokomotiv 30 42 33 55
3 CSKA Sofia CSKA Sofia 30 48 26 48
4 Slavia Sofia Slavia Sofia 30 45 33 46
5 Lokomotiv Plovdiv Lokomotiv 30 43 40 42
6 Beroe Beroe 30 48 41 41
7 Spartak Pleven Spartak 30 30 47 40
8 Spartak Plovdiv Spartak 30 42 42 39
9 Cherno More Varna Cherno More 30 37 37 39
10 Botev Vratsa Botev Vratsa 30 29 35 39
11 Spartak Sofia Spartak 30 32 34 37
12 Botev Plovdiv Botev 30 40 49 36
13 Marek Marek 30 34 41 35
14 Dunav Ruse Dunav Ruse 30 28 41 35
15 OFC Sliven 2000 Sliven 2000 30 29 40 34
16 Akademik Sofia Akademik 30 29 48 28
TEMPORADA 1959/1960
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 CSKA Sofia CSKA Sofia 22 42 18 44
2 Levski Sofia Levski Sofia 22 32 21 39
3 Lokomotiv Sofia Lokomotiv 22 30 22 30
4 Slavia Sofia Slavia Sofia 22 30 28 30
5 FK Minyor Pernik Minyor 22 27 25 30
6 Septemvri Sofia Septemvri 22 34 31 29
7 Botev Plovdiv Botev 22 30 31 29
8 Dunav Ruse Dunav Ruse 22 29 34 27
9 Spartak Varna Spartak 22 27 38 26
10 Spartak Plovdiv Spartak 22 21 28 24
11 Spartak Sofia Spartak 22 21 29 24
12 Spartak Pleven Spartak 22 14 32 17
TEMPORADA 1957/1958
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 CSKA Sofia CSKA Sofia 11 19 9 25
2 Spartak Varna Spartak 22 27 40 23
3 Levski Sofia Levski Sofia 11 18 9 20
4 Spartak Pleven Spartak 11 12 9 19
5 Slavia Sofia Slavia Sofia 11 23 17 16
6 FK Minyor Pernik Minyor 11 20 19 16
7 Lokomotiv Sofia Lokomotiv 11 17 17 16
8 Spartak Plovdiv Spartak 11 18 16 14
9 Botev Plovdiv Botev 11 14 18 12
10 Beroe Beroe 11 13 19 11
11 Dunav Ruse Dunav Ruse 11 11 19 10
TEMPORADA 1955/1956
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 CSKA Sofia CSKA Sofia 22 46 25 42
2 Botev Plovdiv Botev 22 27 20 34
3 Levski Sofia Levski Sofia 22 30 24 34
4 Slavia Sofia Slavia Sofia 22 37 31 31
5 FK Minyor Pernik Minyor 22 40 34 30
6 Spartak Plovdiv Spartak 22 28 29 28
7 Spartak Pleven Spartak 22 19 26 27
8 Lokomotiv Sofia Lokomotiv 22 20 22 26
9 Spartak Sofia Spartak 22 25 30 24
10 Spartak Varna Spartak 22 22 28 24
11 Zavod 12 Zavod 12 22 20 29 24
12 Dunav Ruse Dunav Ruse 22 16 32 19
TEMPORADA 1952/1953
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Levski Sofia Levski Sofia 29 48 25 62
2 CSKA Sofia CSKA Sofia 29 64 24 60
3 Cherno More Varna Cherno More 29 30 23 43
4 Slavia Sofia Slavia Sofia 29 44 34 42
5 Lokomotiv Plovdiv Lokomotiv 29 30 31 40
6 FK Minyor Pernik Minyor 28 33 35 39
7 Spartak Pleven Spartak 29 29 31 39
8 Lokomotiv Sofia Lokomotiv 29 31 35 39
9 Spartak Plovdiv Spartak 29 30 32 36
10 Akademik Akademik 29 26 49 34
11 United Team of DSO United Team 13 36 8 33
12 Botev Plovdiv Botev 29 29 33 32
13 Stroitel Stroitel 29 24 30 30
14 Spartak Sofia Spartak 29 24 38 29
15 VVS Sofia VVS Sofia 28 26 35 27
16 Marek Marek 29 24 65 16

  USO DE MEMORIA  
5,430,520 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1070
Total Execution Time  0.1084
  CADENA URL  
/historico/Spartak-Plovdiv/2005
  GET DATOS  
$_GET['/historico/Spartak-Plovdiv/2005']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0041  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 = 'Spartak-Plovdiv' AND l.year = 2005 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=17436 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=17436 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17436 AND type_rel = 2
0.0033  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 = '17436' ORDER BY l.year DESC,cat.coefficient DESC
0.0034  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 = '17436' AND l.year = 2005 ORDER BY l.year DESC,cat.coefficient DESC
0.0030  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 = '17436' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0028  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=17436 AND l.year in (2004,2005,2006) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (20929,14028) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 14028 AND teamId = 17436
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 20929 AND teamId = 17436
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 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 = 20929 AND t.round = 4 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 = '17436' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0024  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 = '17436' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 events2005 e ON e.player_id = p.id AND e.league_id = 20929 WHERE rp.league_id = 20929 AND rp.teamId = 17436 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.0022  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 events2005 e ON e.player_id = p.id AND e.league_id = 20929 WHERE rp.league_id = 20929 AND rp.teamId = 17436 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 events2005 e ON e.player_id = p.id AND e.league_id = 20929 WHERE rp.league_id = 20929 AND rp.teamId = 17436 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 = 17436 AND l.year <= 2005 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0029  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 `tables1995` 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 = 26175 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 `tables1967` 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 = 26289 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables1966` 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 = 26290 AND t.round = 30 ORDER BY team.conference 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 `tables1965` 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 = 26292 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 `tables1960` 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 = 26294 AND t.round = 22 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 `tables1958` 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 = 26296 AND t.round = 11 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 `tables1956` 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 = 26298 AND t.round = 22 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 `tables1953` 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 = 26301 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 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 = 20929 ORDER BY nameShow LIMIT 100
0.0034  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 854 AND l.year = 2005 ORDER BY l.group_code ASC