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

Copa Albania 2004

Información Histórica 
						

Cup (Kupa e Shqipërisë) 2003/04


First Round 
Fushëmbreti (Elbasan) 2-0 1-0  Sopoti    
Maliqi                1-2 1-2  Pogradeci     
Domosdova             1-4 0-11 Egnatia   
Kukësi                1-3 0-5  Laçi  
Albania               4-3 2-3  Ada Velipojë 
Nacional (Tiranë)     2-1 1-0  Iliria          
Burreli               0-1 0-1  Dajti        
Korabi (withdrew)     awd awd  Veleçiku        [both 0-2 against Korabi]
Gramshi               2-2 1-5  Cërriku     
Butrinti              0-1 1-5  Luftëtari     
Poliçani              2-2 0-4  Albpetrol      
Rrësheni              1-4 0-6  Kastrioti
Cakrani               1-4 2-3  Apolonia     
Melesini              1-3 awd  Devolli         [0-2 against Melesini]
Gramozi               0-0 1-5  Skënderbeu  
Tepelena              3-2 1-5  Delvina       
Përmeti               1-4 0-2  Bylis       
Këlcyra               2-0 0-2  Memaliaj        [2-4 pen]  
Çlirimi               2-0 0-0  Erzeni     
Frakulla (withdrew)   awd awd  Naftëtari       [both 0-2 against Frakulla]
Suçi                  0-5 0-0  Besëlidhja    
Skrapari              0-4 0-2  Tomori   

NB: National is new name for Akademia (Partizani) Tiranë

Second Round [Sep 17 and Oct 1]
Cërriku               0-3 2-5  Tirana
  [Eldorado Merkoci 40, 78, Alban Tafaj 68]
  [Eldorado Merkoçi 40, 66, Sokol Prenga 80, Gledis Sharra 82,
   Ansi Agolli 89, Ranxha 42, 87]
Ada                   0-2 0-9  Vllaznia
  [Safet Osja 3, Armando Cungu 74]
  [Hamdi Salihi 6, 26, 56, 74, Edmir Luka 29, 35, Vioresin Sinani 37,
   Altin Xhahysa 65, Erjon Hoti 75]
Fushë Mbreti          2-8 0-6  Partizani
  [Gezim Ndreka 8, Vasian Ballco 17, 44, Abilio 40, Karioka 42, 72, 
   Albano Plaku 50, Mateo Metani 53, Saimir Shengjergji 23, Lumani 89pen]
  [Entonio Pashaj 9, Adenilson Da Rosha 45, Vasian Ballço 58, Elis Bakaj 62,
   Artim Pollozhani 64, Sebino Plaku 78]
Egnatia               0-1 0-0  Teuta
  [Bledar Mancaku 10pen]
Skënderbeu            1-1 1-4  Shkumbini
  [Eriol Merxha 2, Mario Ngjela 6]
  [Donald Kosta 25, Eriol Merxha 31, 59, Roland Dervishi 46, Sektur Geço 81]
Pogradeci             1-1 0-1  Dinamo          [2nd leg Sep 30]
  [Sokol Ishka 27, Genti Lacka 40]
  [Edmond Dalipi 60]
Albpetrol             0-2 3-0  Flamurtari
  [Ardian Bega 30, Elidon Serjani 83]
  [Gentian Ibrahimi 49, Vladimir Gjoni 73pen, Muça 89]
Devolli               1-1 2-8  Elbasani
  [Endri Dalipi 26, Cezari 72]
  [Migen Memelli 10, 26, 40, Gentian Stojku 24, Endri Dalipi 30,
   Alert Sejdini 47, 80, Elton Guranjaku 55, Shirgli 84, Shkëmbi 88pen]
Naftëtari             2-2 0-2  Besa
  [Edmond Kapllani 23, Ramiz Kollcaku 36, Cekrezi 72,
   Adriatik Kanani 82pen]
  [Bekim Kuli 15, 65]
Memaliaj              0-3 0-10 Lushnja         [2nd leg Sep 30]
  [Arlind Nora 12pen, 60pen, Miroslav Mindev 65]
  [Ervin Bardhi 6, 68, 90, Gentian Çela 10, 87, Bledi Kadiu 16pen,
   Arlind Nora 30, 60, Endri Zhuli 85]
Delvina               5-0 0-6  Apolonia
  [Yzeiri 3, Kalo 35, Pipiko 47, Muho 72, Cafa 81]
  [Mariol Miho 2, 15, Vaske Ruko 43, 77, Marenglen Kule 64, Prifti 69]
Tomori                1-0 1-1  Çlirimi     
  [Klodian Arbri 85]
  [G. Varfi 80pen; Edmond Gjata 36]
Luftëtari             2-0 0-4  Bylis
  [Dhjogen Muco 38, 72]
  [Dorian Bubeqi 14, 23, Bardhyl Elezi 45, Bledar Devolli 80]
Kastrioti             2-1 1-1  Besëlidhja
  [Arjan Hasa 22, R.Maloku 67, Mallota 76]
  [Alban Bruka 15, Tepelena 28]
Nacional              2-0 0-3  Laçi
  [Ceka 16, Misha 46]
  [Kastriot Farruku 14, Osusi 28, Xhelal Farruku 47]
Dajti                 2-0 1-2  Veleçiku
  [Enio Samarxhi 88, Malluta 90]
  [Hasani 28, Isufi 66pen; Jani 23]

Third Round [Nov 12 and 26]
Bylis                 2-0 0-4  Shkumbini       [1st leg in Vlorë;
  [Ermal Varfi 2, Bardhyl Elezi 5]              2nd leg aet]
  [Eriol Merxha 50, Klodian Dervishi 88, 110pen, Dashamir Muça 116]
Albpetrol             1-1 2-3  Elbasani
  [Ujuku 20; Elton Ceno 65]
  [Oltion Osmani 1pen, Migen Memelli 11, Gentian Stojku 25;
   Ojuku 43, Saimir Hoxha 53]
Kastrioti             1-2 1-6  Partizani       [2nd leg Nov 25]
  [Afrim Deliu 70pen; Abilio Neves Dos Reies 8, 33]
  [Abilio Neves Dos Reies 5, 57, Robert Grizha 7, Blendi Nallbani 52pen,
   Sebino Plaku 59, Mateo Metani 86; Beqja 90]
Laçi                  1-2 2-4  Dinamo          [1st leg in Lezhë]
  [Gentian Shkoza 86; Ilir Qorri 47, Edmond Dalipi 88pen]
  [Rigels Qose 2, Edmond Dalipi 14, January ZIambo 50, 67;
   Martin Gjini 42, Alban Rexha 79pen]
Lushnja               0-1 0-2  Tirana          [1st leg in Peqin]
  [Rezart Dabulla 80]
  [Indrit Fortuzi 75, Mahir Halili 86]
Tomori                1-2 0-1  Besa            [2nd leg in Rrogozhinë]
  [Edmond Gjata 73; Bekim Kuli 57, Shkelzen Ypi 77]
  [Edmond Kapllani 3]
Dajti                 3-3 0-4  Teuta
  [Klevis(?) Jani 2, 21, Osmanlliu 57; Nkosilathi Khumalo 14, 34, 
   Oerd Kotja 80]
  [Daniel Xhafa 20, Bledar Mançaku 29, 48pen, Nkosilathi Khumalo 85]
Apolonia              2-4 0-7  Vllaznia        [1st leg in Tiranë]
  [Vaske Ruko 14, 30; Edi Martini 15, 88, Vioresin Sinani 82, 89]
  [Vioresin Sinani 1, 7, 26, Edi Martini 21, 50, 58, Altin Xhahysa 35]

Quarterfinals [Mar 10 and 24]
Dinamo                2-1 2-2  Teuta
  [Keima Keita 64, Artion Poçi 71; Dritan Babamusta 79]
  [Bledar Mancaku 20, Daniel Xhafa 36; Keima Keita 34, Ligor Tiko 47]
Elbasani              0-0 1-2  Partizani
  [Shpëtim Imeraj 55, Elis Bakaj 77; Endri Dalipi 17]
Shkumbini             1-0 0-2  Vllaznia
  [Astrit Nexha 74]
  [Vioresin Sinani 19, Edi Martini 84]
Besa                  1-3 1-2  Tirana 
  [Bekim Kuli 75; Mahir Halili 43, Eldorado Merkoçi 67, Indrit Fortuzi 69]
  [Mahir Halili 11, Devi Muka 73; Përparim Daiu 47pen] 

Semifinals 
[Apr 7 and 21]
Dinamo                3-1 2-1  Tirana   
  [Keima Keita 47, Leandro Do Nascimento 87, January Ziambo 89;
   Fjodor Xhafa 48]
  [Elvis Sina 28; Leandro Do Nascimento 68, Ilir Qorri 88]
[Apr 7 and 22]
Vllaznia              0-2 0-3  Partizani
  [Abilio Dos Reies 45+2, Dorian Bylykbashi 67]
  [Abilio Dos Reies 15, Julian Ahmataj 45, Gjergji Muzaka 53]

Final [May 19]
Dinamo                  0-1    Partizani
  [Gezim Henri Ndreka 12]
  [Partizani: Blendi Nallbani, Ardian Behari, Marcelo Brashini, Alert Alcani,
     Gezim Ndreka, Ardit Beqiri, Julian Ahamtaj, Igli Allmuça (Dorian
     Bylykbashi 74'), Gjergji Muzaka, Skerdi Bejzade, Abilio Dos Reies;
     trainer: Sulejman Mema;
   Dinamo: Ilion Lika, Rodrigo Do Nascimento, Arjan Pisha, Erald Xhafa,
     Papa Sene, January Ziambo, Ilir Qorri (Fabian Da Silva 28), Egert
     Bakalli, Rigels Qosa (Artion Poçi 40), Leandro Da Silva, Pavlin Dhëmbi;
     trainer: Vasil Bici;   
   ref: Artan Taullai (Tiranë); Artan Kuluri (Shkodër), Vangjell Lamaj (Durrës); 
   yellow cards: Arjan Pisha, January Ziambo, Alert Alcani, Julian Ahmataj,
     Skerdi Bejzade;
   red cards: Arjan Pisha, Abilio Dos Reies]




Author: Giovanni Nappi
(dxpdis@tin.it)

Last updated: 21 Sep 2004

(C) Copyright Giovanni Nappi and RSSSF 2003/04


  USO DE MEMORIA  
4,284,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1331
Total Execution Time  0.1351
  CADENA URL  
/copa_albania2004
  GET DATOS  
$_GET['/copa_albania2004']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0020  SELECT type FROM routes WHERE alias = 'copa_albania2004'
0.0042  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 = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1564 AND type_rel = 3
0.0020  SELECT text_es as historical_text FROM leagues_text WHERE id=2302
0.0019  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 = 30540 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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='2004' WHERE c.parentId=1564 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 1564 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 01:04:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-25 01:04:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-25 01:04:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-25 01:04:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1564 AND l.year = 2004
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (30540) 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.0020  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 (30540) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1564 AND l.year = 2004
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (30540) AND (e.action IN (4,5) ) 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 (30540) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0026  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1564 AND l.year = 2004
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (30540) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0170  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 (30540) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0160  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1564 AND l.year = 2004
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (30540) 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 (30540) 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 = 2004 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0022  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 = 2004 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0023  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=30540 AND rel.round=5
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 = 30540 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0020  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 = 30540 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` = 30540 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` = 30540
0.0021  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 `calendars2004` 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` = 30540 AND c.`round` = 5 ORDER BY c.type ASC,((c.team1*c.team1)+(c.team2*c.team2)) ASC,shedule ASC LIMIT 200
0.0025  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 `events2004` e INNER JOIN calendars2004 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 = 5 AND e.real_date IS NOT NULL AND e.league_id = 30540 ORDER BY total DESC LIMIT 40
0.0025  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 `events2004` e INNER JOIN calendars2004 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 = 30540 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0025  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 = 30540 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0025  SELECT data1, data2 FROM services_tags WHERE categoryId=1564
0.0025  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1564 AND l.year = 2004 ORDER BY l.group_code ASC
0.0025  SELECT group_code, extraName from `leagues` WHERE categoryId=1564 AND year=2004