4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2002
Temporada Siguiente »
Publicidad 600x120.gif
Copa Albania 2002
2001/2002

Copa Albania 2002

Información Histórica 
						
Albania Cup (Kupa e Shqipërisë) 2001/02


First Round 

First Legs [Aug 18]
Ada Velipoje       2-1 Vllaznia 
  [Pjetri 42pen, Ervis Kraja 52, Luca 90]
Laçi               0-3 SK Tirana 
  [Devolli 53, Sheta 74, Agolli 90]
Dajti Kamze        2-6 Dinamo               [played in Tirana]
  [Noka 75, Rami 83; Qorri 18, Ahmataj 35, Qose 41, Pinari 60pen, Daniel Xhafa 65,
   Çerçizaj 69]
Memaliaj           0-1 Bylis 
  [Bubeqi 33]
Besa               0-1 Shkumbini 
  [Bujar Muça 67]
Egnatia Rrogozhine 0-1 Teuta 
  [Bespalla 62]
Delvina            2-2 Luftëtari 
  [Hasani 22, 58; Çenko 61, Muça 66]
Perparimi Kukes    2-1 Besëlidhja
  [Alcani 16, Braho 21, Bela 67] 
Naftëtari Kuçova   0-1 Tomori 
  [Gjata 14]
Albpetrol          1-1 Flamurtari 
  [Pashollari 75, Selami 80]
Përmeti            0-1 KS Lushnja 
  [Boriçi 1]
Tepelena           2-1 Apolonia 
  [Gaba 23, Muzha 37, Dervishi 77]
Kastrioti          1-1 Partizani 
  [Prenga 54, Kadillari 75]
Sopoti             2-0 Skenderbeu 
  [Çota 28, Zhdravo 88]
Gramozi Erseka     0-0 Elbasani
Burreli            1-0 Erzeni
  [Kastriot Farruku 24]

Second Legs 
[Aug 24]
Erzeni             3-0 Burreli              [played in Durrës]
  [Yzeiri 48, Çiçiku 54, Ymeri 62]
[Aug 25]
SK Tirana          3-0 Laçi   
  [Agolli 8, 87, Ervin Bulku 16]
Dinamo             7-0 Dajti
  [Çerçizaj 13, 68, Fjodor Xhafa 19, Dhëmbi 31, Jupi 43, Qose 57, 84]
Bylis              4-0 Memaliaj
  [Bubeqi 24, 31, Nenaj 29, Elezi 78]
Shkumbini          3-0 Besa
  [Bujar Muça 37, 85, Vladimir Gjoni 46]
Teuta              4-1 Egnatia
  [Memeli 9, 12, Sokol Gosa 33pen, Muka 58, Cungu 65]
Luftëtari          3-0 Delvina
  [Çenko 26, Kaçi 52, Shehaj 69]
Besëlidhja         2-0 Perparimi
  [Braho 19og, Neziri 85]
Tomori             1-0 Naftëtari 
  [Dino 68]
Flamurtari         3-1 Albpetrol
  [Semini 10, Serjani 35, Kapaj 38pen, Çela 50]
KS Lushnja        10-0 Përmeti
  [Gjini 14, Zyla 26, 28, 51, Dervishi 30, Boriçi 61, 75, Hasalla 64,
   Bano 73, Gazheli 77]
Apolonia           3-0 Tepelena
  [Bita 6, Muzha 20, Gerganchev 70]
Partizani          4-0 Kastrioti
  [Abilio 27, Shkelzen Rustami 36, Kapllani 47, Hysi 78]
Skenderbeu         1-0 Sopoti
  [Shirgu 19]
Elbasani           2-0 Gramozi
  [Guranjaku 30, 86]
[Sep 8]
Vllaznia           4-0 Ada
  [Belisha 10, Dalipi 14, Doçi 65, Lici 77]

Second Round

First Leg [Jan 26]
Flamurtari         0-2 Dinamo  
  [Julian Ahmataj 34, 82]
Elbasani           1-0 Shkumbini
  [Ferdinand Bilali 22pen] 
Partizani          0-4 Tirana 
  [Indrit Fortuzi 13, Sokol Bulku 67, Mahiri Halili 90, Alban Tafaj 91]
Sopoti             1-1 Luftetari 
  [Brikeno Bizi 34, Shkelqim Hajdari 70]
Lushnja            0-1 Teuta 
  [Bledar Mançaku 70]
Apolonia           1-2 Vllaznia 
  [Vaske Ruko (or Gentian Lako?) 45; Skerdi Bejzade 56, 84]
Erzeni             2-0 Beselidhja 
  [Sokol Ishka 64pen, Armando Balliu 83]
Tomori             2-0 Bylis 
  [Saimir Maloku 10, Elton Fani 70]

Second Leg 
[Feb 1]
Dinamo             1-0 Flamurtari
  [Fjodor Xhafa 72]
[Feb 2]
Shkumbini          0-1 Elbasani
  [Gentian Stojku 1]
Tirana             1-1 Partizani 
  [Krenar Alimehmeti 39pen; Abilio Neves 15pen]
Luftetari          3-1 Sopoti 
  [Saimir Haxhiu 35, Erion Kaçi 37, Elton Marini 66; Isuf Ibershimi 47]
Teuta              2-1 Lushnja
  [Migen Memelli 33, Ogert Muka 76; Saimir Malko 39pen]
Vllaznia           1-0 Apolonia 
  [Vioresin Sinani 42]
Beselidhja         2-0 Erzeni               [2-4 pen]
  [Julian Brahja 12, Saimir Xhetani 43]
  [Erion Matraku 0-1, Xhelal Farruku 1-1; Besnik Hasa 1-2, Gentian Liçi miss;
   Erjon Xhafa 1-3, Leon Perloshi 2-3; Artan Karapici 2-4, Alban Neziri held]
Bylis              1-1 Tomori 
  [Dorian Bubeqi 9; Klodian Arberi 85]

Quarterfinals 

First Legs [Feb 9]
Erzeni             0-1 SK Tirana
  [Ervin Bulku 89]
Tomori             1-0 Teuta
  [Klodian Arbëri 58]
Elbasani           2-0 Vllaznia
  [Gentian Stojku 30, Besnik Façja 58]
Luftetari          2-3 Dinamo
  [Admir Shehaj 15, Serhiy Romanishin 43, Daniel Xhafa 50, Arben Çoni 74pen,
   Klodian Asllani 84]

Second Legs 
[Feb 15]
SK Tirana          3-1 Erzeni
  [Indrit Fortuzi (pen), Eldorado Merkoçi, Indrit Fortuzi; Artan Karapici]
[Feb 16]
Teuta              2-0 Tomori               [in Tirana]
  [Migen Memelli 22, Bledar Mançaku 48]
Vllaznia           2-1 Elbasani             [aet]
  [Safet Osja 74, Edmond Dalipi 90+3; Gentian Stojku 95]
Dinamo             1-0 Luftetari
  [Klodian Asllani 58]

Semifinals

First Legs
[Apr 2]
SK Tirana          3-0 Elbasani
  [Indrit Fortuzi 45pen, 69pen, 88]
[Apr 3]
Dinamo             1-0 Teuta
  [Klodian Asllani 36]

Second Legs [Apr 10]
Elbasani           1-2 SK Tirana
  [Ferdinand Bilali 81; Nevil Dede 20, Mahir Halili 80]
Teuta              1-1 Dinamo               [in Shijak]
  [Habib Rexhepi 70pen: Rigels Qose 31]


Final [Jun 1]
SK Tirana          1-0 Dinamo
  [Indrit Fortuzi 30]
  [Tirana: Emanuel Ndubuisi Egbo, Elvis Sina (Gentian Hajdari 79), Arjan Sheta,
           Rezart Dabulla, Krenar Alimehmeti, Nevil Dede (Ardian Mema 56),
           Sokol Bulku, Ervin Bulku, Mahir Halili, Eldorado Merkoçi 
           (Bledar Devolli 83), Indrit Fortuzi; trainers: Agustin Kola,
           Sulejman Mema
   Dinamo: Ilion Lika, Alpin Gallo, Serhiy Romanishin (Rigels Qose 85),
           Pavlin Dhëmbi (Albert Duro 85), Luan Pinari, Julian Ahmataj,
           Redi Jupi, Klodian Asllani, Fjodor Xhafa, Daniel Xhafa 
           (Ilir Qorri 53); trainer: Faruk Sejdini
   ref: Sokol Jareci (Tiranë); Sokol Avdo (Tiranë), Arben Pregja (Tiranë)
   yellow cards: Ervin Bulku, Rezart Dabulla, Julian Ahmataj, Ilir Qorri, 
                 Redi Jupi, Ardian Mema, Albert Duro]



Author: Giovanni Nappi
(dxpdis@tin.it)

Last updated: 19 Oct 2002

(C) Copyright Giovanni Nappi and RSSSF 2001/02


  USO DE MEMORIA  
4,264,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1694
Total Execution Time  0.1713
  CADENA URL  
/copa_albania2002
  GET DATOS  
$_GET['/copa_albania2002']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0020  SELECT type FROM routes WHERE alias = 'copa_albania2002'
0.0047  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_albania' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1564 AND type_rel = 3
0.0023  SELECT text_es as historical_text FROM leagues_text WHERE id=2300
0.0031  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_albania' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0025  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 30542 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='2002' WHERE c.parentId=1564 GROUP BY c.id ORDER BY c.order_id ASC
0.0022  SELECT type,rule FROM rules WHERE categoryId = 1564 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 16:39:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-25 16:39:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-25 16:39:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-25 16:39:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1564 AND l.year = 2002
0.0023  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (30542) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0030  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (30542) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0024  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1564 AND l.year = 2002
0.0032  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (30542) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0024  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (30542) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0033  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1564 AND l.year = 2002
0.0025  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (30542) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0444  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (30542) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0153  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1564 AND l.year = 2002
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (30542) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (30542) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT SUM(rp.lineup) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.category_id = 1564 AND rp.year = 2002 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0018  SELECT SUM(rp.events) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.category_id = 1564 AND rp.year = 2002 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0021  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=30542 AND rel.round=6
0.0020  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 30542 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 30542 AND esl.points > 0
0.0020  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-26" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30542 ORDER BY creation_date DESC LIMIT 0, 10
0.0018  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-03-26" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30542
0.0019  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2002` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 30542 AND c.`round` = 6 ORDER BY shedule ASC LIMIT 200
0.0022  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2002` e INNER JOIN calendars2002 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 6 AND e.real_date IS NOT NULL AND e.league_id = 30542 ORDER BY total DESC LIMIT 40
0.0022  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2002` e INNER JOIN calendars2002 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 30542 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0022  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-25 00:00:00' AND c.`shedule` < '2024-04-29 23:59:59' AND l.id = 30542 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=1564
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1564 AND l.year = 2002 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=1564 AND year=2002