4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Premier League Siria 1999
1998/1999

Premier League Siria 1999

Información Histórica
						
Final Table:

 1.Al-Jaish       26 16 10  0  64-20  58  [Damascus] [aka Army Club]  
 2.Al-Karama      26 16  7  3  40-23  55  [Homs]
 3.Al-Wahda       26 11 11  4  34-17  44  [Damascus]
 4.Al-Jihad       26  9 12  5  36-21  39  [Qamchli]
 5.Al-Ittihad     26 11  6  9  48-42  39  [Aleppo] 
 6.Jabala         26 11  6  9  28-22  39  [Jabala]
 7.Al-Horriya     26 10  6 10  30-28  36  [Aleppo]
 8.Hottin         26  8  9  9  39-30  33  [Latakia]
 9.Teshrin        26  9  6 11  35-49  33  [Latakia]
10.Al-Shourta     26  6 11  9  24-31  29  [Damascus] [aka Police]
11.Al-Shourta     26  8  3 15  29-40  27  [Aleppo] [aka Police]
12.Al-Wathba      26  6  8 12  29-41  26  [Homs]
13.Al-Majd        26  5  5 16  21-50  20  [Damascus]
14.Al-Mayadin     26  3  6 17  28-71  15  [Mayadin]

Round 1 
[Oct 8]
Majd        1-0 Jabala
A Shourta   4-1 Teshrin 
[Oct 9]
Horriya     0-2 Jaish 
  [Nouhad Al-Hajj Mustapha 7, Mohannad Bitar 85]
Karama      0-0 Wathba   
Hottin      2-3 Ittihad    
  [Ammar Yassin 35, Aref Al-Agha 90pen; Anas Sari 9, Youssouf Al-Hassan 72, 
   Yasser Lababidi 85]
Wahda       5-1 Mayadin 
  [Louay Taleb 47, 90, Mahmoud Mahmalji 57, 65, 75; Omar Al-Hamash 83]
Jihad       1-1 D Shourta
  [Haytham Kajjo 73; Samir Shibani 83.]

Round 2
[Oct 13]
Jaish       2-1 D Shourta
  [Nouhad Al-Hajj Mustapha 23, Ahmed Azzam 36; Maher  Mustapha 43]
[Oct 14]
Wahda       2-0 Majd    
Jabala      1-0 Wathba   
Ittihad     1-0 A Shourta   
Teshrin     1-1 Jihad   
Karama      3-2 Horriya  
Mayadin     1-4 Hottin      

Round 3
[Oct 22]
D Shourta   2-3 A Shourta
  [Ayyad Abdulkarim 22, Rami Bastanli 60; Nader Hallaq 21, 90, Ahmed Daada'a 40]
Horriya     0-0 Jihad
[Oct 23]
Ittihad     0-1 Wahda
  [Mahmoud Mahmalji 15]
Teshrin     2-0 Hottin 
  [Amjad Hajj Abdou 2, Adel Jouni 27]
Wathba      4-2 Majd 
  [Hassan Ibrahim 9, 58, 59, Tamam Hourani 44; Nabil Al-Shahma 13, 85]
Mayadin     0-1 Jabala
  [Mazen Assa'ad 59]
[Oct 26]
Jaish       0-0 Karama  

Round 4
[Oct 29]
Wahda       1-1 Teshrin 
  [Jamal Ma'ao 58; Al-Youssouf 37]
[Oct 30]
Majd        0-3 Karama  
  [Hassan Abbas 30,Fawwaz Mando 70, Akram Ghreir 90]
Jabala      0-1 Ittihad
  [Laurence Shémali 83 og]
Jihad       1-4 Jaish
  [Abdulghani Albulrazzaq 32; Mohannad Bitar 12, Ahmad Koussa 28, 
   Sayyed Bayazid 36, 85pen]
Wathba      1-1 Mayadin  
  [Tamam Hourani 20; Hisham Khalaf 65]
Hottin      2-0 D Shourta
  [Talal Shouman 4, Aref Al-Agha 82]
A Shourta   1-2 Horriya
  [Nader Hallaq 35; Abdulkarim Al-Saleh 43, Mahmoud Rahim 53]

Round 5
[Nov 5]
Jaish       2-1 A Shourta
Ittihad     1-0 Wathba
[Nov 6]
Teshrin     2-1 Jabala
  [Mohamed Al-Youssouf 78 pen, Ahmed Kerdeghli 90; Hossam Rifayi 47]
Horriya     3-2 Hottin 
  [Abdulkarim Saleh 35, Mustapha Homsi 48pen, 52; Aref Al-Agha 42, 80]
Karama      2-0 Jihad
  [Tamer Al-Lawz 41, Fawwaz Mando 90]
Mayadin     2-1 Majd 
  [Mahib Al-Sayer 36, 63; Nabil Al-Shahma 53]
D Shourta   1-0 Wahda
  [Hussein Damiriyyeh 53]

Round 6
[Nov 12]
Wahda       1-2 Horriya
  [Tareq Mallah 90; Mohamed Mustapha 20, Mohannad Al-Sheikh Dib 60]
[Nov 13]
Hottin      0-0 Jaish
Wathba      3-4 Teshrin 
  [Ayyad Mando 7, Hassan Ibrahim 51, Mohamed Shahérli 60; Amjad Salah Abdu 71, 
   Salem Baraka 84, Mohamed Al-Youssouf 91, Ahmed Kerdeghli 92]
Majd        0-5 Ittihad
  [Fathallah Al-Tawil 19, Anas Sari 45, 49pen, Samer Hozam 58, Jamal Hamami 83]
A Shourta   0-1 Jihad
  [Hassan Jajan 52 pen]
Mayadin     0-1 Karama  
  [Shadi Hajj-Beik 75]
Jabala      1-0 D Shourta
  [Mazen Assa'ad 90]

Round 7
[Nov 19]
D Shourta   0-0 Wathba
Ittihad     4-0 Mayadin 
  [Mohannad Al-Boushi 5, Anas Sari 12, 40, Mahmoud Hammo 65]
[Nov 20]
Jaish       2-1 Wahda
  [Ahmad Azzam 65, Tareq Jabban 78; Safwan Habayeb 73]
Karama      2-1 A Shourta
  [Shadi Hajj-Beik 61,  Fawwaz Mando 69; Nader Hallaq 57]
Horriya     0-1 Jabala
  [Mazen Assa'ad 83]
Teshrin     2-1 Majd 
  [Amjad Hajj-Abdou 63, Mohamed Al-Youssouf 73pen; Nabil Shahma 40]
Jihad       0-0 Hottin 

Round 8
[Nov 26]
Majd        0-1 D Shourta
  [Maher Mustapha 63]
[Nov 27]
Ittihad     2-2 Karama  
  [Mohannad Al-Boushi 40, 51; Akram Ghreir 78, Ahmad Ghreir 90]
Jabala      0-0 Jaish
Wahda       1-1 Jihad
  [Jamal Maoud 36; Jawhar Damous 71]
Wathba      2-1 Horriya
  [Mahamed Bakkour 10og, Hassan Ibrahim 73pen; Mustapha Homsi 49pen]
Hottin      0-1 A Shourta
  [Wahid Owayyes 56]
Mayadin     1-1 Teshrin 
  [Hisham Khalaf 82; Abdullah Mando 63]

Round 9
[Dec 3]
Jaish       2-1 Wathba
  [Tareq Jabban 46, Maher Al-Sayyed 77; Hassan Ibrahim 57pen]
A Shourta   0-1 Wahda
  [Ismail Fatout 32]
[Dec 4]
Teshrin     2-1 Ittihad
  [Abdullah Mando 30, 33pen; Ammar Rihawi 75]
Karama      1-0 Hottin 
  [Ahmad Ghreir 63]
D Shourta   2-2 Mayadin 
  [Khalil Shawi 10, Maher Mustapha 60; Omar Al-Hamash 7, 81]
Horriya     1-0 Majd
  [Mohamed Shaikhali 33]
Jihad       1-0 Jabala
  [Abdulghani Saleh 27]

Round 10
[Dec 10]
Wahda       2-0 Hottin 
  [Safwan Habayeb 18, Ismail Fatout 42]
[Dec 11]
Teshrin     1-1 Karama
  [Shadi Marhi 53; Tamer Al-Lawz 82]
Majd        1-6 Jaish   
  [Sharif Kurdiyyeh 6og; Sayyed Bayazid 25, 49, 90, Mohamed Khalaf 40, 
   Sharif Kurdiyyeh 70, Yamen Shibli 78]
Ittihad     6-3 D Shourta
  [Anas Sari 8, 52, Ammar Rihawi 20, 55, Mohannad Al-Boushi 25, 49; 
   Mohamed Khalaf 40, two goals missing]
Wathba      1-0 Jihad
  [Ayyad Mando 67]
Jabala      3-0 A Shourta
  [Ali Moussa 23, Ahmad Najjar 27, Ammar Shémali 55]
Mayadin     1-1 Horriya
  [Saddam Al-Rahmo 23; Mohamed Mustapha 61]

Round 11
[Dec 17]
Jaish       7-2 Mayadin 
  [Sayyed Bayazid 5, 55, 60, Nouhad Hajj-Mustapha 28, Maher Al-Sayyed 45,
   Yamen Shebli 75, Ahmad Koussa 86; Saddam Al-Rahmo 20, Walid Al-Ali 25]
A Shourta   1-0 Wathba
  [Nader Hallaq 42]
[Dec 18]
Horriya     2-2 Ittihad
  [Mohamed Shaikhali 36, Mustapha Homsi 90; Anas Sari 72pen, Mohamed Hammoud 76]
Karama      0-0 Wahda
D Shourta   0-1 Teshrin 
  [Oussama Zouzou 86]
Hottin      5-1 Jabala
  [Aref Agha 5, Talal Shouman 27, 53, Ziad Sha'abo 40, Wafi Taha 82;
   Mazen Assa'ad 6]
Jihad       2-0 Majd
  [Qazzafi Ismat 7, Jomarad Moussa 69]

Round 12
[Dec 24]
Majd        2-0 A Shourta
  [Omar Khalil 63, 66]
[Dec 25]
Ittihad     1-1 Jaish   
  [Ammar Rihawi 34; Ahmed Koussa 42]
D Shourta   0-2 Karama
  [Tamer Al-Lawz 23, 90]
Teshrin     2-1 Horriya
  [Salem Baraka 9, Amjad Hajj Abdou 65; Mustapha Homsi 25]
Jabala      2-1 Wahda
  [Mazen Assa'ad 69, Laurence Shémali 79; Zakariya Alloush 60]
Wathba      2-2 Hottin 
  [Tamam Hourani 7, Mohamed Shahérli 42; Ziad Sha'abo 17, 83]
Mayadin     1-2 Jihad
  [Omar Al-Hamash 74; Haytham Kajjo 30, Malek Sahdo 50]

Round 13
[Dec 31]
Wahda       5-0 Wathba
  [Assaf Khalifa 23, 58, Rashid Al-Halabi 36, 74, Jamal Mao 87]
A Shourta   2-1 Mayadin 
  [Nader Halaq 27, Abdullah Dabbah 71; Bashar Al-Sheikh 53]
[Jan 1]
Jaish       3-0 Teshrin 
  [Sayyed Bayazid 2, Mohamed Khalaf 8, Ahmed Koussa 54]
Karama      1-4 Jabala
  [Samer Ouyoun Al-Soud 86; Ali Moussa 46, Mazen Assa'ad 48, 
   Laurence Shémali 68, Ahmed al-Najjar 90]
Jihad       5-0 Ittihad
  [Haytham Kajjo 30, 60, Malek Sahdo 45, Abdulghani Abdulrazzaq 63, 89]
Horriya     2-0 D Shourta
  [Mustapha Homsi 18, Mohamed Shaikhali 42]
Hottin      4-0 Majd
  [Aref Al-Agha 1, 42, Talal Shouman 72, 90]

Round 14
[Feb 4]
D Shourta   0-0 Jihad
[Feb 5]
Jabala      2-0 Majd
  [Laurence Shémali 13, 16]
Teshrin     3-1 A Shourta
  [Abdullah Mando 1pen, 74, Salem Baraka 62; Ahmad Daada'a 46]
Jaish       3-0 Horriya
  [Maher Al-Sayyed 50, 81, Mohamed Koussa 77og]
Karama      2-1 Wathba  
  [Hassan Abbas 20, Tamer Al-Lawz 69; Ayyad Mando 47]
Ittihad     1-2 Hottin 
  [Nouhad Al-Boushi 55; Talal Shouman 38, Bilal Sari 79]
Mayadin     0-1 Wahda
  [Assaf Khalifa 50]

Round 15
[Feb 11]
D Shourta   1-1 Jaish
  [Mohamed Attar 45; Mohamed Khalaf 60]
A Shourta   0-3 Ittihad
  [Anas Sari 70, 83pen, Nouhad al-Boushi 80]
[Feb 12]
Wahda       0-0 Majd
Wathba      0-0 Jabala
Jihad       1-1 Teshrin 
  [Haytham Kajjo 34; Salem Baraka 77]
Horriya     3-1 Karama
  [Mohamed Shaikhali 9, Ahmad Basla 52, Haji Qader 70; Tamer al-Lawz 11]
Hottin      2-1 Mayadin 
  [Ziad Sha'abo 39, Talal Shouman 84; Omar al-Hamash 87]

Round 16
[Feb 18]
Majd        1-1 Wathba
  [Nabil Shahma 57; Mohamed Shahérli 73]
[Feb 19]
Karama      0-0 Jaish
Wahda       2-0 Ittihad
  [Louay Taleb 24, Zakariya Alloush 74]
Jihad       1-0 Horriya 
  [Jomrad Moussa 13]
A Shourta   1-2 D Shourta 
  [Mohamed Wahid Owaid 71, Firas Qashoush 8, Mohamed al-Attar 45]
Hottin      6-1 Teshrin 
  [Talal Shouman 25, 30, Aref al-Agha 39, 80, Ziad Sha'abo 50, Jamal Kazem 90,
   Ali Sheikh-Dib 60]
Jabala      3-1 Mayadin 
  [Ali Moussa 35, 80, Mazen Assa'ad 90, Hossam Rahbawi 10]

Round 17 [Feb 31-Mar 2]
Jaish       5-0 Jihad
  [Sayyed Bayazid 27pen, 46, 58, 62, Raghdan Shehade 73]
Horriya     2-0 A Shourta   
  [Mohannad Sheikh-Dib 42, Mohamed Shaikhali 45]
Teshrin     1-1 Wahda   
  [Abdullah Mando 90; Louay Taleb 75]
Karama      0-1 Majd
  [Mahmoud al-Youssouf 4]
Ittihad     1-0 Jabala
  [Mohamed Hammo 38]
D Shourta   0-0 Hottin  
Mayadin     3-1 Wathba
  [Saddam al-Rahmo 1, Maher Al-Rahbawi 20, Hafez al-Sahw 40pen; Mohamed Shaherli 33]

Round 18 [Mar 4,5]
A Shourta   2-2 Jaish
  [Amer Qara-Ali 70, Ahmed Da'ada'a 85; Abdulmonhem Ahmad 8og, Ahmad Azzam 26]
Wathba      4-2 Ittihad
  [Tamam Hourani 24, 58, Hassan Ibrahim 42pen, 79pen; Anas Sari 25, Mohamed Hammo 28]
Jihad       1-2 Karama
  [Dawood Yaaqoub 44; Tamer al-Lawz 13, Mohannad Shamma 76]
Wahda       1-1 D Shourta
  [Mahmoud Mahmalji 45; Mohamed Attar 42]
Jabala      4-1 Teshrin
  [Ussama al-Basha 28, 52, Mazen Assa'ad 48, Laurence Shémali 87; Abdullah Mando 89]
Hottin      1-0 Horriya
  [Ziad Sha'abo 10]
Majd        3-1 Mayadin
  [Nabil al-Shahma 45, 48, Mohamed Shéblaq 84; Hafez al-Sahw 79pen]

Round 19 [Mar 11,12]
Horriya     1-1 Wahda
  [Mahmoud Rahin 26; Ibrahim Kabtoul 90]
Karama      4-1 Mayadin
  [Abdulbasset Najjar 1, Ahmad Ghreir 20, 38, Sobhi Aqoul 60; Zoheir Owain (69pen]
Teshrin     0-1 Wathba
  [Hassan Ibrahim 43]
Ittihad     5-2 Majd
  [Anas Sabouni 27, Mohannad al-Boushi 57, 82, Youssouf Sheikh al-Ashra 62,
   Fathallah al-Tawil 78; Nabil al-Shahma 22, Ibrahim Mohamed 65]
Jaish       2-2 Hottin
  [Maher Melki 1, Tareq Jabban 79; Talal Shouman 37, 90]
D Shourta   0-0 Jabala
Jihad       1-0 A Shourta
  [Haytham Kajjo 90]

Round 20 [Mar 18,19]
Majd        3-1 Teshrin
  [Maher Shamlas 53og, Nabil Shahma 62, 76; Salem Baraka 90]
Mayadin     2-1 Ittihad
  [Nasser al-Kashash 67, Saddam Rahmo 84; Anas Sari 63]
Jabala      1-0 Horriya
  [Khaled Jadiba 90]
Wathba      1-1 D Shourta
  [Hassan Ibrahim 12; Mohannad Eissa 70]
A Shourta   1-2 Karama
  [Amer al-Ali 73; Fawwaz Mando 17, 27]
Hottin      1-1 Jihad 
  [Talal Shouman 12pen; Abdulghani Abdulrazzaq 80]
[Jun 4]
Wahda       0-0 Jaish

Round 21 [Mar 25,26]
Jaish       0-0 Jabala
A Shourta   3-1 Hottin
  [Abdulmonhem Ahmed 17, Wahid Oways 20, Ghazi Kathibi 78; Shehab Berro 60]
Karama      2-1 Ittihad
  [Ahmad Ghreir 24, Tamer al-Lawz 55; Anas Sabouni 40]
D Shourta   1-0 Majd
  [Mohamed Attar 34]
Teshrin     3-2 Mayadin
  [Abdullah Mando 12, Ali Sheikh-Dib 60, Salem Baraka 86; Saddam Rahmo 22,
   Bashar al-Sheikh 49]
Jihad       0-0 Wahda
Horriya     1-0 Wathba
  [Mohamed Shaikhali 73]

Round 22 [Apr 1,2]
Wahda       2-1 A Shourta
  [Mahmoud Mahmalji 18, 23; Amer al-Ali 84]
Hottin      0-1 Karama
  [Hossam Mousalli 47]
Wathba      1-3 Jaish
  [Mohamed Shaherli 47; Maher al-Sayyed 19, 87, Sayyed Bayazid 22]
Ittihad     2-1 Teshrin
  [Ammar Rihawi 3, Anas Sari 56; Ussama Zouzou 45]
Jabala      1-1 Jihad
  [Mazen Assa'ad 75; Dawood Ya'aqoub 7]
Mayadin     1-1 D Shourta
  [Abdou al-Dabal 53; Mohamed Attar 78]
Majd        0-0 Horriya

Round 23 [Apr 7,8]
Jaish       4-1 Majd
  [Imad Shéhadé 1, Mohamed Khalaf 41, Massa'ab Mohamed 68, Maher Melki 90;
   Nabil al-Shahma 87]
Hottin      0-0 Wahda
Karama      2-1 Teshrin
  [Ahmad Turkmani 7, Ahmad Ghreir 64; Salem Baraka 29.]
D Shourta   1-1 Ittihad
  [Mohannad Eissa 45; Ammar Rihawi 15]
A Shourta   1-0 Jabala
  [Ahmad Da'ada'a 75]
Jihad       3-0 Wathba
  [Haytham Kajjo 16, 77, Ghandi Hussein 45]
Horriya     2-1 Mayadin
  [Mohamed Shaikhali 19, Mustapha Homsi 63; Saddam al-Rahmo 48]

Round 24 [Jun 10,11]
Majd        0-0 Jihad
Wahda       1-1 Karama
  [Assaf Khalifa 11; Hassan al-Masri 82]
Mayadin     0-4 Jaish
  [Imad Shéhadé 14, Maher Malki 26, Badr al-Ali 72, Maher al-Sayyed 74]
Ittihad     1-1 Horriya
  [Anas Sari 17; Mustapha Homsi 52pen]
Jabala      1-1 Hottin
  [Mazen Assa'ad 30; Aref al-Agha 87]
Wathba      1-1 A Shourta
  [Hassan Ibrahim 67; Mustapha Qadir (80]
Teshrin     1-3 D Shourta 
  [Abdullah Mando 55; Mohamed Gharibeh 32, Samir Shibani 39, Maher Mustapha 65]

Round 25 
[Jun 17]
A Shourta   2-1 Majd
  [Ahmad Daada'a 71, Amer al-Ali 83; Nabil al-Shahma (36]
Wahda       1-0 Jabala
  [Ismail Fatout 75]
[Jun 18]
Jaish       7-3 Ittihad
  [Badr al-Ali 33, Ahmad Azzam 40, 55, Tareq Jabban 77pen, Maher al-Sayyed 79,
   Nouhad Hajj-Mustapha 89, Maher Malki 90; Samer Hozam 4,
   Mohannad al-Boushi 45, 63]
Horriya     3-0 Teshrin
  [Mohamed Shaikhali 35, 81, 87]
Karama      2-1 D Shourta 
  [Fares Shahin 66, Hossam Janyat 79; Hatem al-Ghayeb (85]
Hottin      1-2 Wathba
  [Aref al-Agha 10; Hassan Ibrahim 27, Mohamed Shaherli 65]
Jihad      12-0 Mayadin
  [Haytham Kajjo 25, 47, 51, 65, 71, 72, 74, 75, 85, 88, Dawood Ya'aqoub 53, 
   Ghanem Shabo 80]
 
Round 26 
[Jun 25]
D Shourta   1-0 Horriya
  [Samir Shibani 15'] 
[Jun 26]
Majd        1-1 Hottin
  [Nabil al-Shahma 11; Talal Shouman 59]
Jabala      1-3 Karama
  [Mazen Assa'ad 10; Fawwaz Mando 14, Jihad Qassab 65, Riyadh al-Masri 90]
Teshrin     1-2 Jaish 
  [Marwan Nahluos 49; Ahmad Koussa 25, Mohamed Khalaf 84]
Ittihad     0-0 Jihad
Wathba      2-3 Wahda
  [Hassan Ibrahim 70pen, 85; Assaf Khalifa 23, Safwan Habayeb 27,
   Mahmoud Mahmakli 90]
Mayadin     2-2 A Shourta
  [Bashar al-Sheikh 32, Maher Rahbawi 90; Nazmi Hassan 39, Ahmad Da'ada'a 46]

Final Table:

 1.Al-Jaish       26 16 10  0  64-20  58  [Damascus] [aka Army Club]  
 2.Al-Karama      26 16  7  3  40-23  55  [Homs]
 3.Al-Wahda       26 11 11  4  34-17  44  [Damascus]
 4.Al-Jihad       26  9 12  5  36-21  39  [Qamchli]
 5.Al-Ittihad     26 11  6  9  48-42  39  [Aleppo] 
 6.Jabala         26 11  6  9  28-22  39  [Jabala]
 7.Al-Horriya     26 10  6 10  30-28  36  [Aleppo]
 8.Hottin         26  8  9  9  39-30  33  [Latakia]
 9.Teshrin        26  9  6 11  35-49  33  [Latakia]
10.Al-Shourta     26  6 11  9  24-31  29  [Damascus] [aka Police]
11.Al-Shourta     26  8  3 15  29-40  27  [Aleppo] [aka Police]
12.Al-Wathba      26  6  8 12  29-41  26  [Homs]
13.Al-Majd        26  5  5 16  21-50  20  [Damascus]
14.Al-Mayadin     26  3  6 17  28-71  15  [Mayadin]

Relegated: Al-Shourta (Aleppo) and Al-Mayadin.
Promoted: Al-Foutoua (Deir ez-Zor) and Al-Mouhafaza.

NB: relegation is decided taking into account the points in the 
    youth league as well.

Topscorers:

Haytham Kajjo (Al Jihad)           18
Anas Sari (Al Ittihad)             15
Talal Shouman (Hottin)             15
Sayyed Bayazid (Al Jaish)          14 




Authors:
Mohamed S. Chbaro and Mohammed Qayed
Last updated: 2 Jan 2009

(C) Copyright Mohamed S. Chbaro, Mohammed Qayed and RSSSF 1999/2009
						


  USO DE MEMORIA  
4,272,416 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1058
Total Execution Time  0.1079
  CADENA URL  
/premier_league_siria1999
  GET DATOS  
$_GET['/premier_league_siria1999']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0018  SELECT type FROM routes WHERE alias = 'premier_league_siria1999'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_siria' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=504 AND type_rel = 3
0.0027  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 504 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0027  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 (1235933,1226851,842063,784104,757608) ORDER BY n.cover_points DESC, update_date DESC
0.0024  SELECT text_es as historical_text FROM leagues_text WHERE id=1863
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 = 30126 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='1999' WHERE c.parentId=504 GROUP BY c.id ORDER BY c.order_id ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 13:38:01' 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-27 13:38:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 13:38:01' 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-27 13:38:01' 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 = 'premier_league_siria' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1999 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 events1999 e WHERE e.league_id IN (30126) 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.0019  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 (30126) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (30126) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  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 (30126) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (30126) AND (e.action IN (3,4) ) 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 (30126) 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 events1999 e WHERE e.league_id IN (30126) AND (e.action IN (22) ) 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 (30126) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  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 = 30126 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0019  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 = 30126 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0024  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=30126 AND rel.round=26
0.0022  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 = 30126 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0022  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 = 30126 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-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30126 ORDER BY creation_date DESC LIMIT 0, 10
0.0025  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-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30126
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 `calendars1999` 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` = 30126 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 200
0.0018  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 `events1999` e INNER JOIN calendars1999 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 = 30126 ORDER BY total DESC LIMIT 40
0.0021  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 `events1999` e INNER JOIN calendars1999 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 = 30126 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0025  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 = 30126 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT *,(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 = 30126 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 30126 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0025  SELECT data1, data2 FROM services_tags WHERE categoryId=504
0.0025  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 504 AND l.year = 1999 ORDER BY l.group_code ASC
0.0025  SELECT group_code, extraName from `leagues` WHERE categoryId=504 AND year=1999