4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2003/2004
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 KF Tirana KF Tirana 36 90 36 80
2 Dinamo City Dinamo City 36 68 39 71
3 Vllaznia Shkodër Vllaznia 36 77 51 68
4 Partizani Tirana Partizani 36 65 39 67
5 Teuta Durrës Teuta 36 57 49 52
6 Lushnja Lushnja 36 35 52 42
7 Shkumbini Peqin Shkumbini 36 44 61 41
8 KF Elbasani KF Elbasani 36 47 55 40
9 Besa Kavajë Besa Kavajë 36 36 81 29
10 Flamurtari Vlorë Flamurtari 36 24 80 14
TEMPORADA 2002/2003
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 KF Tirana KF Tirana 26 57 18 60
2 Vllaznia Shkodër Vllaznia 26 51 32 49
3 Partizani Tirana Partizani 26 41 27 46
4 Teuta Durrës Teuta 26 38 27 40
5 Shkumbini Peqin Shkumbini 26 33 23 40
6 Dinamo City Dinamo City 26 29 24 38
7 Flamurtari Vlorë Flamurtari 26 27 28 36
8 KF Elbasani KF Elbasani 26 33 35 36
9 Besa Kavajë Besa Kavajë 26 29 37 36
10 Lushnja Lushnja 26 27 27 35
11 Apolonia Fier Apolonia 26 27 33 35
12 Erzeni Shijak Erzeni 26 23 37 24
13 Bylis Ballsh Bylis Ballsh 26 19 61 16
14 Besëlidhja Lezhë Besëlidhja 26 22 47 13
TEMPORADA 2001/2002
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 Dinamo City Dinamo City 26 55 15 63
2 KF Tirana KF Tirana 26 52 15 62
3 Partizani Tirana Partizani 26 41 24 46
4 Teuta Durrës Teuta 26 31 19 42
5 Vllaznia Shkodër Vllaznia 26 44 27 40
6 Shkumbini Peqin Shkumbini 26 32 36 33
7 Lushnja Lushnja 26 32 32 31
8 Flamurtari Vlorë Flamurtari 26 26 32 29
9 Apolonia Fier Apolonia 26 22 48 29
10 Besëlidhja Lezhë Besëlidhja 26 20 25 28
11 Bylis Ballsh Bylis Ballsh 26 28 42 28
12 Erzeni Shijak Erzeni 26 31 54 28
13 KF Luftëtari Luftëtari 26 24 50 27
14 Tomori Berat Tomori Berat 26 29 48 25
TEMPORADA 1999/2000
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 KF Tirana KF Tirana 26 40 14 52
2 Tomori Berat Tomori Berat 26 35 22 52
3 Teuta Durrës Teuta 26 37 16 49
4 Vllaznia Shkodër Vllaznia 26 29 28 37
5 Bylis Ballsh Bylis Ballsh 26 28 30 37
6 Lushnja Lushnja 26 34 31 35
7 Shkumbini Peqin Shkumbini 26 31 32 35
8 Skënderbeu Korçë Skënderbeu 26 33 33 34
9 Shqiponja Shqiponja 26 21 21 33
10 Dinamo City Dinamo City 26 27 31 31
11 Apolonia Fier Apolonia 26 22 41 31
12 Flamurtari Vlorë Flamurtari 26 25 35 30
13 KF Elbasani KF Elbasani 26 20 32 29
14 Partizani Tirana Partizani 26 21 37 24
TEMPORADA 1998/1999
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 KF Tirana KF Tirana 30 48 20 61
2 Vllaznia Shkodër Vllaznia 30 57 18 60
3 Bylis Ballsh Bylis Ballsh 30 51 19 59
4 Tomori Berat Tomori Berat 30 31 25 46
5 Lushnja Lushnja 30 52 40 44
6 Dinamo City Dinamo City 30 37 37 40
7 Shkumbini Peqin Shkumbini 30 30 38 40
8 Teuta Durrës Teuta 30 28 48 40
9 KF Elbasani KF Elbasani 30 30 30 39
10 Partizani Tirana Partizani 30 37 46 39
11 Flamurtari Vlorë Flamurtari 30 40 47 38
12 Skënderbeu Korçë Skënderbeu 30 44 53 38
13 Apolonia Fier Apolonia 30 32 42 37
14 Besa Kavajë Besa Kavajë 30 25 40 36
15 Laçi Laçi 30 36 55 33
16 Burreli Burreli 30 40 60 27
TEMPORADA 1997/1998
LIGA ALBANIA
Equipo PJ GF GC Puntos
1 Vllaznia Shkodër Vllaznia 34 42 24 72
2 KF Tirana KF Tirana 34 54 19 65
3 Partizani Tirana Partizani 34 62 27 64
4 Shkumbini Peqin Shkumbini 34 56 49 54
5 Teuta Durrës Teuta 34 39 39 54
6 KF Elbasani KF Elbasani 34 48 31 52
7 Apolonia Fier Apolonia 34 38 34 52
8 Laçi Laçi 34 47 49 48
9 Lushnja Lushnja 34 54 38 47
10 Tomori Berat Tomori Berat 34 37 45 47
11 Skënderbeu Korçë Skënderbeu 34 40 50 46
12 Dinamo City Dinamo City 34 42 36 45
13 Bylis Ballsh Bylis Ballsh 34 41 39 45
14 Besa Kavajë Besa Kavajë 34 48 47 44
15 Flamurtari Vlorë Flamurtari 34 38 41 43
16 KF Luftëtari Luftëtari 34 34 58 40
17 Sopoti Librazhd Sopoti 34 39 64 35
18 Albpetrol Patos Albpetrol 34 24 93 19

  USO DE MEMORIA  
5,545,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5787
Total Execution Time  0.5799
  CADENA URL  
/historico/Partizani-Tirana/2004
  GET DATOS  
$_GET['/historico/Partizani-Tirana/2004']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0182  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 = 'Partizani-Tirana' AND l.year = 2004 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.0128  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=9105 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=9105 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=9105 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 = 8861
0.0132  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 = 11989
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9105 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9105 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0129  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (87949,92805,257742,262260,632684) ORDER BY n.cover_points DESC, update_date DESC
0.0144  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 = '9105' ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '9105' AND l.year = 2004 ORDER BY l.year DESC,cat.coefficient DESC
0.0133  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 = '9105' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0134  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 = 11989 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 = 8861 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0138  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=9105 AND l.year in (2003,2004,2005) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (55728,42359,23892,11989,8862) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 8862 AND teamId = 9105
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 42359 AND teamId = 9105
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 23892 AND teamId = 9105
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 11989 AND teamId = 9105
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 55728 AND teamId = 9105
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 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 = 8861 AND t.round = 36 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '9105' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9105' and rp.type = 4
0.0127  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 = '9105' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0126  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 events2004 e ON e.player_id = p.id AND e.league_id = 8861 WHERE rp.league_id = 8861 AND rp.teamId = 9105 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.0126  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 events2004 e ON e.player_id = p.id AND e.league_id = 8861 WHERE rp.league_id = 8861 AND rp.teamId = 9105 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 events2004 e ON e.player_id = p.id AND e.league_id = 8861 WHERE rp.league_id = 8861 AND rp.teamId = 9105 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 9105 AND l.year <= 2004 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 8861 AND t.round = 36 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 `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 = 8859 AND t.round = 26 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 `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 = 8857 AND t.round = 26 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 `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 = 8853 AND t.round = 26 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 `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 = 8852 AND t.round = 30 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 `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 = 9849 AND t.round = 34 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 = 8861 ORDER BY nameShow LIMIT 100