4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Copa Albania 2003
2002/2003

Copa Albania 2003

Información Histórica
						
Albania Cup (Kupa e Shqipërisë) 2002/03


First Round 

First Legs
[Aug 30]
Skenderbeu         0-4 Dinamo
  [Ilir Qorri 10, Klodian Asllani 29, Egert Bakalli 40pen, Rigels Qose 53]
Naftetari          0-2 Teuta
  [Gentian Begeja 45, 74]
Laçi               1-4 Vllaznia
  [Martin Gjini 84; Vioresin Sinani 23, 50pen, Elvin Beqiri 27,
   Klodian Arberi 35] 
Dajti              2-3 Shkumbini
  [Jani 36, Besnik Fuçia 90; Dorian Bubeqi 8, 56, Oltion Osmani 51]
Albpetrol          0-3 KS Lushnja 
  [Vladimir Gjoni 12, 15, 53]
Min. Tepelena      2-2 Flamurtari
  [Ilir Selimi 12, Ruçi 81pen; Admir Shehaj 72, Robo 80]
Min. Memaliaj      1-0 Apolonia 
  [Ilir Seferi 17]
Perparimi          1-1 Beselidhja 
  [F. Çengu 20; Hektor Toma 48]
Permeti            0-0 Bylis
Butrinti           2-2 Luftetari 
  [Shehu 69, Meçani 73; Meçani 9og, Bashkim Gaxhaj 13]
Egnatia            3-0 Tomori 
  [Isufi 24, Mikel Koseja 41, Osmani 89]
Gramozi            1-5 KF Elbasani
  [M. Lubani 88; Shkelqim Hajdari 20, 30, Klevis Dalipi 22,
   Gentian Stojku 40, Memetaj 60]
Burreli            2-0 Besa               [played in Rreshen] 
  [Perparim Daiu 44og, Zhuli 68]
Kastrioti          0-2 Erzeni             [played in Shijak] 
  [Justin Bespalla 17, Qazim Buna 50]
[Sep 1]
Sopoti             1-1 Tirana
  [Isuf Ibershimi 70; Eldorado Merkoçi 55]
Pogradeci          2-4 Partizani
  [Ylli Çekiçi 57pen, Gezim Laçka 82; Edmond Kapllani 17, 81,
   Marcelo Junior Tawata 'Marcelinho' 21, 59]

Second Legs
[Sep 6]
Teuta              1-1 Naftetari          [played in Shijak]   
  [Joja 20; Afrim Deliu 89]
Beselidhja         5-0 Perparimi
  [Alket Kruja 1, Alban Bruka 16, Kreshnik Ivanaj 70, 85, 88]
[Sep 7]
Dinamo             4-1 Skenderbeu
  [Klodian Asllani 45, Ilir Qorri 70, Ligor Tiko 77, Daniel Xhafa 86;
   Blendi Kadiu 63]
Tirana             0-0 Sopoti
Partizani          3-0 Pogradeci
  [Edmond Kapllani 7, 88, Marcelo Junior Tawata 'Marcelinho' 13]
Vllaznia           9-0 Laçi
  [Albert Kaçi 2, 49, 76, Vioresin Sinani 8, 48, 54, Admir Teli 14,
   Elvin Beqiri 44, Hasim Djokoviç 72]             
Shkumbini          2-0 Dajti
  [Neritan Bajaziti 80, Dorian Bubeqi 84]
KS Lushnja         4-2 Albpetrol
  [Vladimir Gjoni 8, 39, Saimir Malko 33, Arben Çela 84;
   Erion Kapaj 18pen, Naka 26]
Flamurtari         6-0 Minatori Tepelena  
  [Admir Shehaj 17, 54, Bujar Muça 51, Gentian Liçi 65pen, Ervin Aliaj 75,
   Albert Paço 86]
Apolonia           2-0 Minatori Memaliaj  
  [Raimond Shala 60, Ervin Buzi 80]
Bylis              6-0 Permeti            [played in Kuçova] 
  [Klodian Brahimi 7, 11, 17, Hajredini 27pen, Bardhyl Elezi 76pen,
   Ermal Serjani 84]
Luftetari          4-1 Butrinti           
  [Mikel Çenko 12, 52, Dhjogen Muço 77, 79; Dordi 80]
Tomori             1-1 Egnatia            [played in Poliçan]
  [Altin Fasku 70pen; Hyka 15pen]
KF Elbasani        6-0 Gramozi
  [Shkelqim Hajdari 2, 28, Bashkim Arifi 10, Gentian Stojku 52,
   Bledar Hila 60, Mehmeti 70]
Erzeni             2-0 Kastrioti
  [Shala 20og, Alion Hasho 70]
[Sep 8]
Besa               6-0 Burreli            [played in Lushnja]
  [Edmond Kodra 9, Parid Xhihani 27, Ervin Bardhi 30, Shkelzen Ypi 38,
   Fatjon Ymeri 71, Artan Bano 75] 

Second Round

First Legs 
[Jan 22]
Erzeni            1-0 Flamurtari
  [Genti Gjondeda 83og]
Apolonia          1-1 Shkumbini
  [Vaske Ruko 88; Artur Xhyra 65]
Egnatia           0-3 Teuta
  [Migen Memelli 15, Gentian Begeja 59, Admir Toskollari 67]
Beselidhja        2-3 Lushnja
  [Altin Bruka 37, Ervin Lika 93pen; Amarildo Boriçi 27, 45, Bledi Kadiu 42]
Luftetari         0-3 Dinamo
  [Papa 31, Rezart Maho 85, 86]
Elbasani          1-4 Vllaznia
  [Dorian Bylykbashi 60pen; Vioresin Sinani 32, Skerdi Bejzade 43, 50,
   Klodian Asllani 71]
Bylis             1-2 Partizani          [played in Kuçova] 
  [Perparim Daiu 44pen; Luan Asllani 50pen, Pavlin Dhembi 89]
[Jan 25]
Besa              0-0 SK Tirana
 
Second Legs 
[Jan 29]
Partizani         4-0 Bylis              [played at Skender Halili ground]
  [Bekim Kuli 12, Edmond Kaplllani 30, Romeo Hamzaj 48, 
   Perparim Daiu 65pen]
Dinamo            2-2 Luftetari 
  [Jovan Papa 60, Egert Bakalli 64; Dritan Mehmeti 54, Ermal Capuni 76]
Vllaznia          2-1 Elbasani           [played in Koplik]
  [Klodian Asllani 28, Vioresin Sinani 30; Taulant Bakiu 85pen]
Shkumbini         3-0 Apolonia 
  [Dorian Bubeqi 23, Lorenc Pasha 53, Astrit Nexha 75]
Flamurtari        2-0 Erzeni 
  [Daniel Xhafa 12, Andi Shtrepi 49]
Teuta             2-3 Egnatia 
  [Bledar Mançaku 44, Migen Memelli 56; Alban Rexha 86, 88, 89]
Lushnja           3-1 Beselidhja 
  [Amarildo Boriçi 32, 47, Edi Martini 70; Alban Byzhyti 92] 
[Jan 30]
SK Tirana         1-0 Besa
  [Ervin Bulku 76pen]

Quarterfinals

First Legs [Feb 22]
Flamurtari        0-0 Teuta
Vllaznia          0-0 Partizani
Lushnja           0-0 Dinamo
Shkumbini         2-4 Tirana
  [Daniele Zaccanti 47, 81pen; Fjodor Xhafa 45, 48, 89, Redi Jupi 75]

Second Legs 
[Apr 8]
Tirana            2-0 Shkumbini
  [Suad Lici 45, Fjodor Xhafa 47]
[Apr 9]
Dinamo            0-0 Lushnja            [3-2 pen]
  [penalties: Bledi Kadiu (L) cross bar 0-0, Luan Pinari (D) saved 0-0;
              Endrit Vrapi (L)          0-1, Arjan Pisha (D)       1-1;
              Arlind Nora (L)           1-2, Ilir Qorri (D) saved  1-2;
              Gentian Cela (L) saved    1-2, Ardian Dashi (D)      2-2;
              Saimir Malko (L) saved    2-2, Edmond Dalipi (D)     3-2]
Partizani         2-2 Vllaznia
  [Gezim Ndreka 39, Alexander Antonio Viana 'Carioca' 44; Elvin Beqiri 73,
   Albert Kaçi 93]
Teuta             2-1 Flamurtari
  [Bledar Mançaku 17, Edlir Tetova 82; Roland Nenaj 54]

Semifinals

First Legs [Apr 23]
Tirana            0-2 Dinamo
  [Ilir Qorri 70, 77]
  [Tirana: Ndubuisi Egbo, Nevil Dede, Rezart Dabulla, Elvis Sina, Suad Lici
           (Alban Tafaj 71), Saimir Patushi, Ervin Bulku, Devi Muka, Redi
           Jupi (Indrit Fortuzi 71 (Sokol Prenga 88)), Fjodor Xhafa, Mahir
           Halili; trainer: Fatmir Frashëri; subs not used: Isli Hidi,
           Gentian Hajdari, ?;
   Dinamo: Ilion Lika, Luçian Bica, Arjan Pisha, Luan Pinari, Ardian Dashi,
           Egert Bakalli, Edmond Dalipi (Ogert Muka 67), Rigels Qosa (Ilir
           Kalari 63), Ilir Qorri, Ligor Tiko, January Ziambo (Artim
           Pollozhani 80); trainer: Aurel Ticleanu; subs non used: Ermal
           Cela, Rezart Maho, Johan Papa, Arnold Cipi;
   ref: Sokol Çekaj (Laç), Arben Pregja (Tiranë), Arjan Mali (Patos);
   yellow cards: Fjodor Xhafa, Ervin Bulku, Arjan Pisha, Ardian Dashi]
Teuta             2-1 Vllaznia
  [Gentian Begeja 65, Arjan Zëre 73; Klodian Asllani 76]
  [Teuta: Orges Shehi, Marenglen Xhai, Arjan Zëre, Erind Tetova, Nkosilathi 
          Khumalo, Renato Abonicio De Sousa, Admir Toshkollari, Ervin
          Kotemelo, Julian Ahmataj, Bledar Mancaku (Migen Memelli 71), 
          Gentian Begeja (Vasian Ballço 86); trainer: Hasa Lika;
   Vllaznia: Armir Grima, Luan Zmijani, Bledar Devolli, Elvin Beqiri, Ilir
             Dibra, Albert Kaçi, Serhiy Romanishin (Klodian Asllani 66),
             Amarildo Belisha (Hasim Gjokoviç 76), Richard Bokatola-Lossombo,
             Vioresin Sinani (Skedri Bejzade 84), Sokol Ishka; trainer:
             Ramadan Shehu;
   ref: Sokol Jareci, Sokol Avdo (Tiranë), Fatmir Hysomema (Vlorë);
   yellow cards: Bledat Mançaku, Nkosilathi Kumalo, Bledar Devolli,
                 Richard Bokatola-Lossombo]

Second Legs [May 7]
Dinamo            2-1 Tirana
  [Ligor Tiko 41, 61; Fjodor Xhafa 14]
  [Dinamo: Ilion Lika, Arjan Pisha, Luan Pinari, Luçiano Bica, Egert 
           Bakalli, Ardian Dashi (Ogert Muka 73), Edmond Dalipi (Ilir 
           Kalari 87), Rigels Qosa, Ilir Qorri, Ligor Tiko, January
           Ziambo (Artim Pollozhani 59); trainer: Aurel Ticleanu;
   Tirana: Ndubuisi Egbo, Gentian Hajdari, Ervin Bulku, Rezart Dabulla,
           Suat Lici (Sokol Prenga 46), Saimir Patushi, Alban Tafaj, Redi 
           Jupi, Elvis Sina (Sokol Bulku 76), Mahir Halili, Fjodor Xhafa;
           trainer: F.Frashëri;
   ref: Sokol Velçani (Patos), Fatmir Hysomema (Vlorë), Arben Pregja (Tiranë);
   yellow cards: Ervin Bulku, Redi Jupi, Ilir Qorri]
Vllaznia          1-1 Teuta
  [Skerdi Bejzade 62; Migen Memelli 6]
  [Vllaznia: Armir Grima, Luan Zmijani, Elvin Beqiri, Ilir Dibra, Bledar 
             Devolli, Safet Osja (Albert Kaçi 56), Serhiy Romanishin,
             Skerdi Bejzade, Sokol Ishka, Klodian Asllani, Vioresin Sinani;
             trainer: Ramadan Shehu;
   Teuta: Orges Shehi, Ervin Kotemelo, Arjan Zëre (Vasian Ballço 33),
          Marenglen Xhai, Erind Tetova, Renato Abonicio De Sousa, Admir 
          Toshkollari, Nkosilathi Khumalo, Julian Ahmataj, Bledar Mancaku
          (Edar Bërzezi 70), Migen Memelli (Gentian Begeja 65); trainer:
          Hasan Lika;
   ref: B. Pregja, S. Avdo, L. Çuko (Tiranë);
   yellow cards: Ishka, Mancaku, Bërzezi (2), Ballço;
   red card: Bërzezi]


Final [May 31, Qemal Stafa, Tiranë; att: 6,000]
Dinamo            1-0 Teuta
  [January Ziambo 54]
  [Dinamo: Ilion Lika, Luçiano Bica, Ilir Kalari (Artim Pollozhani 79),
           Luan Pinari, Edmond Dalipi, Arjan Pisha, Egert Bakalli 
           (Ogert Muka 79), Ligor Tiko, Ilir Qorri, Rigels Qose,
           January Ziambo (Rezart Maho 86); coach: Agim Canaj;
   Teuta: Orges Shehi, Markelian Xhai, Arjan Zere, Ervin Kotomelo
          (Vasian Ballço 70), Admir Toshkollari, Nkosilathi Khumalo,
          Renato Abonicio De Sousa, Erind Tetova, Julian Ahmataj,
          Gentian Begeja (Migen Memelli 63), Bledar Mançaku;
          coach: Hasan Lika;
   ref: Gianluca Paparesta; Paolo Calcagno, Gianpiero Gregari (all Italy)]


Playoff Final [Jun 8]
Egnatia    2-1 Tomori   
  [Alban Rexha 37, 41; Vangjell Mile 68]
  

Author: Giovanni Nappi
(dxpdis@tin.it)

Last updated: 24 Aug 2003

(C) Copyright Giovanni Nappi and RSSSF 2002/03
						


  USO DE MEMORIA  
4,256,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.6936
Total Execution Time  0.6957
  CADENA URL  
/copa_albania2003
  GET DATOS  
$_GET['/copa_albania2003']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0146  SELECT type FROM routes WHERE alias = 'copa_albania2003'
0.0294  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 = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1564 AND type_rel = 3
0.0150  SELECT text_es as historical_text FROM leagues_text WHERE id=2301
0.0146  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 = 30541 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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='2003' WHERE c.parentId=1564 GROUP BY c.id ORDER BY c.order_id ASC
0.0145  SELECT type,rule FROM rules WHERE categoryId = 1564 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 23:52:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 23:52:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 23:52:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 23:52:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  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 = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0149  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1564 AND l.year = 2003
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (30541) 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.0147  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 (30541) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1564 AND l.year = 2003
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (30541) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (30541) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0148  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1564 AND l.year = 2003
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (30541) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0256  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 (30541) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0241  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1564 AND l.year = 2003
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (30541) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (30541) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  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 = 2003 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0144  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 = 2003 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0147  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=30541 AND rel.round=5
0.0148  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 = 30541 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0150  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 = 30541 AND esl.points > 0
0.0149  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-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30541 ORDER BY creation_date DESC LIMIT 0, 10
0.0146  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-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30541
0.0148  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 `calendars2003` 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` = 30541 AND c.`round` = 5 ORDER BY c.type ASC,((c.team1*c.team1)+(c.team2*c.team2)) ASC,shedule ASC LIMIT 200
0.0148  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 `events2003` e INNER JOIN calendars2003 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 = 30541 ORDER BY total DESC LIMIT 40
0.0148  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 `events2003` e INNER JOIN calendars2003 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 = 30541 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0148  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-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 30541 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0148  SELECT data1, data2 FROM services_tags WHERE categoryId=1564
0.0148  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1564 AND l.year = 2003 ORDER BY l.group_code ASC
0.0148  SELECT group_code, extraName from `leagues` WHERE categoryId=1564 AND year=2003