4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica
						
Final Table:

 1.Ismaily (Ismailiya)       26 20  6  0  52-14  66  Champions
 2.Al-Ahly (Cairo)           26 20  4  2  50-17  64
 3.Zamalek (Cairo)           26 16  5  5  58-37  53
 4.Ghazl Al-Mehalla          26  9  8  9  28-28  35
 5.Mokawloon al-Arab (Cairo) 26  8  9  9  32-31  33
 6.Goldy (Fayoom)            26  8  8 10  26-34  32  [*]
 7.Mansoura (Mansoura)       26  8  7 11  27-31  31
 8.Al-Tersana (Cairo)        26  8  6 12  36-45  30  [aka Arsenal]
 9.Al-Masry (Port Said)      26  7  9 10  24-33  30
10.Baladiyyat Al-Mehalla     26  6 10 10  30-34  28
11.Ittihad (Alexandria)      26  6  9 11  23-32  27
---------------------------------------------------
12.Ghazl Al-Suez             26  7  5 14  29-40  26  Relegated
13.Qanat (Port Said)         26  6  6 14  37-46  24  Relegated  [aka Canal]   
14.Sohag                     26  1 12 13  23-53  15  Relegated

[*] Al-Ma'aden (aka Metals) changed name to Goldy

Round 1 
[Sep 21]
G Mehalla 3-1 Masry
  [Ekrami Abdulaziz 26, 45, Ramadan Ragab 75; Ahmed Abdulmonhem 89]
Sohag     1-1 B Mehalla
  [Abdou Mahmoud 45; Akram Abdulmajid 50]
[Sep 22]
Mokawloon 1-0 Qanat
  [Saeed Saad 78]
Ittihad   2-0 Mansoura
  [Yasser Al-Shanwani 21, Boubacar Bah 27]
[Sep 25]
G Suez    2-0 Ahly
  [Mahmoud Al-Nadi 43, Amido Karim 85]
[Sep 26]
Ismaily   2-0 Tersana
  [Simon Molama 23, Abdulhamid Bassiouni 70]
[Sep 27]
Zamalek   3-0 Goldy
  [Tamer Abdulhamid 34, Hossam Hassan 44pen, 75]

Round 2
[Sep 29]
Qanat     2-1 G Suez
  [Ahmed Al-Agouz 44, Mohamed Abdulrahman 85; Hamdi Abdulal 64]
B Mehalla 0-0 Mokawloon
[Sep 30] 
Ahly      1-0 Ittihad
  [Ahmed Bilal 56]
Masry     1-1 Sohag
  [Yasser Mohamed 34; Abdou Mahmoud 73]
Ismaily   2-0 Goldy
  [Imad Al-Nahhas 61, Abdulhamid Bassiouni 73]
Tersana   1-1 G Mehalla
  [Mohannad Al-Boushi 66; Ahmed Ramadan 25]
[Oct 1]
Mansoura  1-2 Zamalek
  [Mohamed Mahmoud 63; Hossam Hassan 86, 91]

Round 3
[Oct 5]
Ittihad   2-2 Qanat
  [Ayman Al-Gamal 61, 70; Mohamed Abdulrahman 69, Ayman Fathi 83]
Sohag     0-0 Tersana
B Mehalla 1-2 G Suez
  [Ridha Mustapha 36; Islam Fathi 9, Sameh Adlan 59]
[Oct 6]
Ismaily   0-0 Zamalek
Mokawloon 1-1 Masry
  [Mohamed Adel 14; Amrou Al-Dousouqi 89]
G Mehalla 1-1 Goldy
  [Ramadan Ragab 89; Hassan Awwad 12]
[Nov 30]
Ahly      2-0 Mansoura
  [Mohamed Farouq 53, Khaled Bibo 70]

Round 4
[Oct 14]
Zamalek   3-0 G Mehalla
  [Karam Jaber 25og, Mohamed Abdulwahed 43, Hossam Abdulmonhem 66]
Mansoura  0-2 Ismaily
  [Mohamed Muhsin Abou-Greishah 3, Ala'a Khalifa 88]
Masry     1-0 G Suez
  [Mohamed Mohamed 90]
B Mehalla 4-1 Ittihad
  [Akram Abdulmajid 19, 74, Bassem Wajdi 59, 79; Tamer Abdulhamid 73]
Tersana   2-2 Mokawloon
  [Mohannad Al-Boushi 19, Mohamed Abou-Tarikah 66; Ayman Zeid 51,
   Mohamed Seddiq 75]
[Oct 15]
Ahly      1-0 Qanat
  [Cherno Mansarai 2]
Goldy     2-2 Sohag
  [Hassan Awwad 4, Nabil Abou-Zeid 14; Adel Abdullah 73, Oussama Hamed 80]

Round 5
[Oct 19]
Sohag     3-3 Zamalek
  [Walid Saad 45pen, Harbi Toufiq 48, 68; Hossam Hassan 21, 72,
   Ahmed Felix Aboagye 36]
G Suez    1-0 Tersana
  [Islam Fathi 61]
G Mehalla 0-1 Ismaily
  [Abdulhamid Bassiouni 26]
Qanat     2-1 Mansoura
  [Ahmed Ayyoub 27, Mohamed Abdulrahman 45; Mohamed Mahmoud 47pen]
[Oct 20]
Mokawloon 4-1 Goldy
  [Ali Ashour 20, Sameh Youssouf 30, 89, Ali Abdulghani 90; Nabil Abou-Zeid 53pen]
Ittihad   0-0 Masry
[Oct 28?]
Ahly      2-0 B Mehalla
  [Ahmed Abou-Moslem 62, Khaled Bibo 90]

Round 6
[Oct 26]
Masry     1-1 Ahly
  [Mazhar Abdulrahman 92pen; Cherno Mansarai 51]
Ismaily   5-0 Sohag
  [Mohamed Muhsin Abou-Greishah 6, 40, Abdulhamid Bassiouni 35, 45, 79]
Tersana   2-1 Ittihad
  [Boubacar Bah 43, Mohannad Al-Boushi 69; Ayman Khalil 2pen]
Goldy     2-1 G Suez
  [Amrou Al-Dali 5, 61; Islam Fathi 54'pen]
B Mehalla 2-1 Qanat
  [Peter Soul 5, Akram Abdulmajid 45; Ahmed Al-Agouz 25]
[Oct 27]
Mokawloon 1-3 Zamalek
  [Ahmed Fekri Al-Saghir 73; Mohamed Awda 36og, Hossam Hassan 66, 
   Mohamed Abou Al-Ila 90]
Mansoura  0-1 G Mehalla
  [Ashraf Kabounga 39]

Round 7
[Nov 2]
Ismaily   2-0 Mokawloon
  [Abdulhamid Bassiouni 24, Abdulrazzaq  Ekimi Yoko 85]
Zamalek   2-1 G Suez
  [Mohamed Kammouna 70, Gamal Hamza 81; Gamal Gad 32]
Mansoura  0-0 B Mehalla
Ittihad   0-0 Goldy
G Mehalla 0-0 Sohag
[Nov 3]
Qanat     0-0 Masry
[Nov 11]
Ahly      2-0 Tersana
  [Ibrahim Saeed 32pen, Ala'a Ibrahim 90]

Round 8 
[Nov 19]
Ittihad   0-4 Zamalek
  [Hossam Hassan 57, Hazem Emam 75, 90, Tareq Al-Sayyed 78]
Ismaily   4-0 G Suez
  [Islam Al-Shater 1pen, Simon Molama 31, Imad Al-Nahhas 56pen, Atiyya Saber 64]
Masry     1-3 B Mehalla
  [Mazhar Abdulrahman 7; Anthony Samuel 11, 67, ?]
Tersana   5-3 Qanat
  [Mohamed Abou-Tarikah 26, 71, Imad Ayyoub 31, 45, Mohannad Al-Boushi 80;
   Ahmed Al-Agouz 66, 68, Mohamed Abdulrahman 90]
Sohag     0-1 Mansoura
  [Yasser Farouq 63]
Mokawloon 0-0 G Mehalla
[Feb 12]
Goldy     0-1 Ahly
  [Wael Goma'a 67]

Round 9
[Nov 23]
Ahly      1-2 Zamalek
  [Ala'a Ibrahim 89; Hazem Emam 21pen, 55]
B Mehalla 1-2 Tersana
  [Akram Abdulmajid 44; Imad Ayyoub 45, Moemen Abdulghaffar 85]
G Suez    2-4 G Mehalla
[Nov 24]
Ittihad   0-0 Ismaily
Mokawloon 5-1 Sohag
  [Robert Okobori 12, 41, 63, Ahmed Fekri Al-Saghir 45, 79; Mohamed Abdulaziz 78]
Qanat     2-2 Goldy
  [Hassan Moussa 23, Mohamed Hankash 54; Sidi Camara 8og, Tareq Mustapha 87]
Masry     0-0 Mansoura

Round 10
[Nov 30]
Tersana   3-0 Masry
  [Mohannad Al-Boushi 17, Moemen Abdulghaffar 59, Imad Ayyoub 89]
G Mehalla 0-1 Ittihad
  [Yasser Ali 89]
Sohag     2-2 G Suez
  [Oussama Hamed 35, Ahmed Khalaf 58pen; Hani Kamel 49, 85pen]
[Dec 2]
Zamalek   3-1 Qanat
  [Hazem Emam 28, 90, Walid Salah Abdullatif 89; Hassan Moussa 15]
Goldy     1-1 B Mehalla
  [Hani Younes 64; Mohamed Gamal 13]
[Dec 10?]
Mansoura  1-1 Mokawloon
  [Yasser Farouq 31; Mohamed Abdulaziz 66]
[Feb 16]
Ismaily   1-1 Ahly
  [Amro Fahim 4; Galletro 39]

Round 11
[Dec 6]
Tersana   3-1 Mansoura
  [Mohamed Abou-Tarikah 47, 84, Ahmed Aabdulzaher 58; Ashraf Khamis 28]
G Suez    1-0 Mokawloon
  [Hani Kamel 17pen]
[Dec 7]
B Mehalla 1-1 Zamalek
  [Mohamed Salam 73pen; Hazem Emam 33pen]
Qanat     1-3 Ismaily
  [Hassan Moussa 30; Imad Al-Nahhas 51, Mohamed Salah Abou-Greyshah 75, 
   Mohamed Barakat 80]
Masry     1-2 Goldy
  [Mustapha Ja'afar 5; Nabil Abou-Zeid 28, Amrou Abdou 81]
Ittihad   1-1 Sohag
  [Tareq Al-Sayyed 18; Oussama Hamed 33]
[Feb 21]
Ahly      1-0 G Mehalla
  [Khaled Bibo 66]

Round 12
[Dec 13]
Goldy     1-2 Tersana
  [Denis Abramovic 21; Imad Ayyoub 12, 15]
[Dec 14]
G Suez    0-0 Mansoura
Ismaily   1-0 B Mehalla
  [Mohamed Barakat 76]
G Mehalla 0-0 Qanat
Sohag     0-1 Ahly
  [Khaled Bibo 76]
Mokawloon 0-3 Ittihad
  [Boubacar Bah 23, Youssouf Hamdi 55, Ayman Kamal 89]
[Dec 15]
Zamalek   4-2 Masry
  [Hossam Hassan 17, 30, Tareq Al-Sayyed 53, 80; 
   Walid Abou Al-Ila 77, Abdullah Ragab 89]

Round 13
[Dec 22]
Qanat     5-2 Sohag
  [Hassan Moussa 13, 55, Ahmed Ayyoub 31, Mohamed Abdulrahman 40, Ahmed Al-Agouz 76;
   Mohamed Abdulkarim 37, Ahmed Khalaf 50pen]
B Mehalla 2-3 G Mehalla
  [Akram Abdulmajid 32, Mohamed Gamal 73; Hossam Abdulal 11, Ramadan Ragab 44,
   Ekrami Abdulaziz 65]
Tersana   2-5 Zamalek
  [Imad Ayyoub 77, 92; Hazem Emam 18, Medhat Abdulhadi 26, Mohamed Abou Al-Ila 32, 56, 
   Hossam Hassan 68]
Mansoura  1-0 Goldy
  [Mohamed Salam 81]
Ittihad   2-0 G Suez
  [Ayman Al-Gamal 1, 76]
Masry     0-1 Ismaily
  [Abbdulhamid Bassiouni 75]
[Feb 25]
Ahly      1-0 Mokawloon
  [Khaled Bibo 45]

Round 14
[Mar 1]
Zamalek   2-1 Goldy
  [Hazem Emam 6, Hossam Hassan 55pen; Wael Al-Qabbani 69og]
Tersana   1-1 Ismaily
  [Mohamed Omar 62; Atiyya Saber 45]
Masry     2-2 G Mehalla
  [Ekrami Abdulaziz 8pen, 82; Ashraf Kabonga 45og, Amrou Al-Dousouqi 87]
Mansoura  1-1 Ittihad
  [Mohamed Ramadan 68pen; Tamer Abdulhakim 55]
Qanat     1-1 Mokawloon
  [Hassan Moussa 28; Ayman Zein 84]
[Mar 2]
Ahly      2-0 G Suez
  [Ala'a Ibrahim 80, Ibrahim Saeed 90pen]
B Mehalla 1-0 Sohag
  [Mohamed Salam 4]

Round 15
[Mar 16]
G Suez    2-1 Qanat
  [Hamdi Abdulal 60, Sameh Adlan 89; Mohamed Abou Al-Ezz 41]
Ismaily   1-0 Goldy
  [Mohamed Muhsin Abou-Greyshah 38]
Sohag     0-1 Masry
  [Moulai Keita 76]
Zamalek   3-1 Mansoura 
  [Abdulhalim Ali 14, Mohamed Abdulwahed 32, Hossam Hassan 70; Amrou Zaki 51]
[Mar 17]
Mokawloon 1-0 B Mehalla
  [Saeed Saad 27]
Tersana   0-1 G Mehalla
  [Hossam Abdulal 45]
[May 7]
Ittihad   1-2 Ahly
  [Ayman Saeed 62; Ahmed Bilal 37, Mohamed Abonde 79]

Round 16
[Mar 29]
B Mehalla 5-1 G Suez
  [Akram Abdulmajid 30, Talhat Ragheb 33, 84, Mohamed Salem 68, Sami Qomsan 90;
   Nazih Aatiyya 10]
Tersana   3-1 Sohag
  [Ayman Khalil 41, 83, Mohamed Abou-Tarikah 89; Mahmoud Khalil 60]
Goldy     2-1 G Mehalla
  [Nabil Abou-Zeid 30, Amrou Al-Dali 51; Ramadan Ragab 70]
Qanat     1-0 Ittihad 
  [Hassan Moussa 57]
[Mar 30]
Zamalek   3-4 Ismaily 
  [Ahmed Felix Aboagye 54, Hazem Emam 71, 82; Abdulhamid Bassiouni 12, 61,
   Mohamed Abdullah 31, Mohamed Barakat 43]
Mansoura  0-1 Ahly
  [Ala'a Ibrahim 90]
Masry     1-0 Mokawloon
  [Ahmed 'Koshari' Abdulmonhem 52]

Round 17
[Apr 2]
Sohag     0-0 Goldy
Ittihad   0-0 B Mehalla
[Apr 3]
Ismaily   3-0 Mansoura
  [Mohamed Salah Abou-Greyshah 25, Saad Abdulbaqi 88pen, Mohamed Muhsin Abou-Greyshah 90]
G Mehalla 0-1 Zamalek
  [Mohamed Abdulwahed 20]
Ahly      2-1 Qanat
  [Wael Goma'a 72, Ahmed Bilal 81; Ahmed Ayyoub 27]
G Suez    1-0 Masry 
  [Hamdi Abdulal 38]
Tersana   2-2 Mokawloon
  [Imad Ayyoub 34, Hossam Mabrouk 83; Ahmed Fekri Al-Saghir 38, Sameh Youssouf 52]

Round 18
[Apr 7]
Ismaily   1-0 G Mehalla
  [Mohamed Salah Abou-Greyshah 8]
B Mehalla 1-2 Ahly
  [Akram Abdulmajid 70; Ahmed Bilal 20, 37]
Zamalek   3-3 Sohag
  [Ahhmed Felix Aboagye 10, Mohamed Abdulwahed 20, Hossam Hassan 30;
   Oussama Hamed 13, 44, 85]
Goldy     1-0 Mokawloon
Tersana   2-2 G Suez
Mansoura  2-2 Qanat
[Apr 9]
Masry     1-0 Ittihad
  [Yasser Mohamed 42]

Round 19
[Apr 19]
G Suez    0-1 Goldy
  [Samuel Eto 40]
Ittihad   1-0 Tersana
  [Yasser Ali 79pen]
[Apr 20]
G Mehalla 1-0 Mansoura
  [Ashraf Mamdouh 84]
Mokawloon 2-1 Zamalek 
  [Sameh Youssouf 35, Mamdouh Abdulhayy 50; Hossam Hassan 85]
Sohag     0-1 Ismaily
  [Amrou Fahim 71]
Qanat     1-2 B Mehalla
  [Hassan Moussa 90; Ahmed Samir 30, 62]
[Apr 21]
Ahly      1-0 Masry
 [Ahmed Bilal 5]

Round 20
[May 2]
Mokawloon 0-1 Ismaily   
  [Abdulhamid Bassiouni 69]
B Mehalla 0-4 Mansoura  
  [Omar Zaki 10, Saber Al-Sharbini 40, Mohamed Mahmoud 5. 59]
Goldy     1-0 Ittihad  
  [Tareq Mustapha 53]
Sohag     0-1 G Mehalla 
  [Ashraf Mamdouh 43]
[May 3] 
Masry     2-1 Qanat
Tersana   0-5 Ahly
  [Hossam Ghali 15, Ridha Shahata 35, Ahmed Bilal 50, 56, Khaled Bibo 84]
[May 4]
G Suez    0-2 Zamalek
  [Ahmed Felix Aboagye 58, Hossam Hassan 87pen]

Round 21 [May 11]
G Suez    1-1 Ismaily
  [Hani Kamel 33pen; Ahmed Fathi 70]
B Mehalla 0-0 Masry
Sohag     0-1 Mansoura
Qanat     3-1 Tersana
Ittihad   1-2 Zamalek
  [Tamer Abdulhakim 53; Hossam Hassan 50pen, Walid Salah Abdullatif 82]
Ahly      2-1 Goldy
  [Gilberto 1pen, Khaled Bibo 71pen; Nabil Abou-Zeid 25pen]
Mokawloon 4-2 G Mehalla
  [Ali Ashour 10, 50, Sameh Youssouf 74, 77; Ekrami Abdulaziz 45,
   Oussama Nabih 89pen]

Round 22
[May 15]
Ismaily   3-0 Ittihad
  [Islam Al-Shater 9pen, Mohamed Salah Abou-Greyshah 90, Atiyya Saber 90]
Mansoura  4-1 Masry
  [Ahmed Salem 56, Hisham Saeed 63, Mohamed Mahmoud 73, Ahmed Farghali 83;
   Abdullah Ragab 37]
G Mehalla 2-1 G Suez
  [Hossam Abdulal 25, Ameer Salah Zaki 45; Nasr Abdulfattah 50]
Goldy     2-1 Qanat 
  [Mustapha Merhi 22, Hassan Awwad 54; Mohamed Abou Al-Ezz 47]
Tersana   3-2 B Mehalla
  [Mohannad Al-Boushi 11, Mohamed Abou-Tarikah 65, Hussein Shukri 88;
   Bassem Wajdi 29, Mohamed Salam 90]
Sohag     1-1 Mokawloon
  [Ahmed Al-Sayyed 28; Sameh Youssouf 66]
[May 16]
Zamalek   1-6 Ahly
  [Hossam Hassan 41; Ridha Shehata 4, Ibrahim Saeed 28,
   Khaled Bibo 38, 64, 73, 90]

Round 23 [May 20]
Ahly      4-4 Ismaily
  [Ahmed Bilal 39, 76, Mohamed Farouq 45, Ala'a Ibrahim 88pen;
   Mohamed Barakat 30, Amrou Fahim 42, Islam Al-Shater 63pen, Atiyya Saber 90pen]
Qanat     1-0 Zamalek
  [Mohamed Abdulrahman 8pen].
Ittihad   1-0 G Mehalla
  [Mohamed Ibrahim 61]
Mokawloon 0-0 Mansoura
B Mehalla 1-1 Goldy
  [Akram Abdulmajid 54; Amrou Abdou 90]
G Suez    6-0 Sohag 
  [Amido Karim 7, Ahmed Saeed 13, Husni Hassan 24, Hani Kamel 66, 83,
   Mohamed Omar Al-Nour 71]
Masry     2-0 Tersana
  [Mohamed Shawqi 76, Yasser Mohamed 82]

Round 24 [May 24]
Qanat     1-2 Ismaily 
  [Moatassem Bellah 27; Mohamed Salah Abou-Greyshah 35, Imad Al-Nahhas 77]
G Mehalla 1-1 Ahly
  [Mohamed Mohsen Al-Etrawi 89; Ridha Shehata 29]
Zamalek   2-2 B Mehalla
  [Hazem Emam 24, Gamal Hamza 42; Mohamed Salam 45, Akram Abdulmajid 45]
Mansoura  2-1 Tersana
  [Hisham Saeed 42, Ahmed Farghali 69; Mustapha Al-Sherqawi 44] 
Sohag     2-2 Ittihad
Goldy     1-1 Masry 
  [Abdullah Ragab 38; Samuel 6]
Mokawloon 1-0 G Suez
  [Rami Saeed 36]

Round 25 [May 28]
B Mehalla 0-3 Ismaily
  [Mohamed Salah Abou-Greyshah 23, 79, Abdulhamid Bassiouni 69]
Ahly      4-0 Sohag
  [Ahmed Bilal 17, 77, Ala'a Ibrahim 60, 70]
Masry     2-1 Zamalek
  [Amrou Al-Dousouqi 29, Walid Abou Al-Ela 71; Medhat Abdulhadi 55]
Mansoura  2-1 G Suez
Ittihad   2-4 Mokawloon
  [Abdel Hakim (2); Rami Adel, Ali Ashour, Said Saad, Ayman Zain]
Qanat     2-4 G Mehalla
Tersana   0-1 Goldy

Round 26
Sohag     3-2 Qanat
  [Hammam Ahmed (2), A.El-Sayed; Ahmed El-Agouz (2)]
G Mehalla 0-0 B Mehalla
Zamalek   2-1 Tersana
  [Ahmed Felix, Tamer Abdel Hamid; Moa'men Abdel Ghafar]
Goldy     2-4 Mansoura
  [Hani Younis, Samara; R.Mahmoud, A.Salem, H.Said, M.Ramadan]
G Suez    1-1 Ittihad
  [Hani Kamel; Wakil Salama]
Ismaily   3-2 Masry
  [Amr Fahim (2), Emad El-Nahhas; Ihab Galal, Amr El-Desouki]
Mokawloon 1-3 Ahly
  [Haytham Hussein; Ahmed Belal (2), Mohamed Farouk]

Final Table:

 1.Ismaily (Ismailiya)       26 20  6  0  52-14  66  Champions
 2.Al-Ahly (Cairo)           26 20  4  2  50-17  64
 3.Zamalek (Cairo)           26 16  5  5  58-37  53
 4.Ghazl Al-Mehalla          26  9  8  9  28-28  35
 5.Mokawloon al-Arab (Cairo) 26  8  9  9  32-31  33
 6.Goldy (Fayoom)            26  8  8 10  26-34  32  [*]
 7.Mansoura (Mansoura)       26  8  7 11  27-31  31
 8.Al-Tersana (Cairo)        26  8  6 12  36-45  30  [aka Arsenal]
 9.Al-Masry (Port Said)      26  7  9 10  24-33  30
10.Baladiyyat Al-Mehalla     26  6 10 10  30-34  28
11.Ittihad (Alexandria)      26  6  9 11  23-32  27
---------------------------------------------------
12.Ghazl Al-Suez             26  7  5 14  29-40  26  Relegated
13.Qanat (Port Said)         26  6  6 14  37-46  24  Relegated  [aka Canal]   
14.Sohag                     26  1 12 13  23-53  15  Relegated

[*] Al-Ma'aden (aka Metals) changed name to Goldy

Promoted: ENPPI, Border Guards, Aswan



Authors: Mohamed S. Chbaro
(sp_editor@terra.net.lb)
and Tarek Said
(tsaid3@yahoo.com)

Last updated: 26 Sep 2002

(C) Copyright Mohamed S. Chbaro, Tarek Said and RSSSF 2001/02
						


  USO DE MEMORIA  
4,295,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1173
Total Execution Time  0.1194
  CADENA URL  
/egipto2002
  GET DATOS  
$_GET['/egipto2002']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0018  SELECT type FROM routes WHERE alias = 'egipto2002'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'egipto' 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.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64 AND type_rel = 3
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 64 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0026  SELECT /*53 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 (1306103,1298220,1280408,1278941,1251811) ORDER BY n.cover_points DESC, update_date DESC
0.0023  SELECT text_es as historical_text FROM leagues_text WHERE id=366
0.0020  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 = 28679 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=64 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 64 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-02 11:04:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-02 11:04:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-02 11:04:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-02 11:04:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'egipto' 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.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (28679) 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 (28679) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (28679) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0022  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 (28679) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0027  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (28679) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0025  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 (28679) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0029  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (28679) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0025  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 (28679) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0023  SELECT 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.league_id = 28679 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0021  SELECT 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.league_id = 28679 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0030  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=28679 AND rel.round=26
0.0028  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 = 28679 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0028  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 = 28679 AND esl.points > 0
0.0027  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-04-02" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28679 ORDER BY creation_date DESC LIMIT 0, 10
0.0044  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-04-02" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28679
0.0028  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` = 28679 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 200
0.0020  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 = 26 AND e.real_date IS NOT NULL AND e.league_id = 28679 ORDER BY total DESC LIMIT 40
0.0034  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 = 28679 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0037  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 = 28679 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  SELECT *,(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 = 28679 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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-05-02 00:00:00' AND c.`shedule` < '2024-05-06 23:59:59' AND l.id = 28679 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0037  SELECT data1, data2 FROM services_tags WHERE categoryId=64
0.0037  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 64 AND l.year = 2002 ORDER BY l.group_code ASC
0.0037  SELECT group_code, extraName from `leagues` WHERE categoryId=64 AND year=2002