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 2003
2002/2003

Premier League Siria 2003

Información Histórica
						

Final Table:
 
 1.Al-Jaish       24 18  3  3  62-21  57  (62-22) Champions  [Damascus] [aka Army Club]  
 2.Al-Ittihad     24 17  3  4  43-25  54  [Aleppo]       
 3.Qardaha        24 14  5  5  41-23  47  (41-24) [Qardaha]
 4.Al-Wahda       24 12  8  4  41-24  44  [Damascus]
 5.Al-Horriya     24 12  3  9  38-28  39  (39-28) [Aleppo]  
 6.Hottin         24 11  6  7  45-39  39  (45-38) [Latakia]   
 7.Al-Majd        24  8  7  9  45-47  31  [Damascus]
 8.Al-Wathba      24  8  2 14  27-45  26  [Homs]
 9.Al-Karama      24  7  4 13  25-42  25  [Homs]
10.Umayya         24  6  6 12  26-41  24  (27-41) [Idlib]                           
11.Jabala         24  5  7 12  19-23  22  (19-24) [Jabala]  
12.Al-Yaqaza      24  2  8 14  17-51  14  [Deir ez-Zor]
13.Al-Shorta      24  3  4 17  29-49  13  [Damascus] [aka Police]

NB: for some clubs differing goal differences are reported as indicated
    between brackets

Round 1
[Sep 26]
Al-Wahda      0-0 Al-Majd
[Sep 27]
Al-Jaish      3-0 Al-Shorta
  [Amer Al-Abtah 65, Raghdan Shehade 75pen, Mohamed Khalaf 81]
Al-Ittihad    3-0 Al-Wathba
  [Ammar Rihawi 43, Anas Sari 80, Mohamed Boudaqqa 82]
Qardaha       2-0 Jabala
  [Ammar Shemali 63, 85]
Al-Yaqaza     0-1 Hottin
  [Jamal Kazem 68]
Al-Karama     1-2 Al-Horriya
  [Ayham Al-Khatib 82; Amrou Diar-Bakarli 39, Samir Bakri 88]
Umayya        bye
 
Round 2
[Oct 3]
Al-Shorta     2-3 Al-Karama
  [Imad Ali 41, Mahmoud Abullah 67; Ahmed Turkmani 16, 66, 87]
[Oct 4]
Al-Horriya    3-1 Al-Yaqaza
  [Yamen Abboud 18, Samir Bakri 53, Amrou Diar-Bakarli 88; Mohammd Al-Hamad 50]
Hottin        3-0 Qardaha
  [Aref Al-Agha 29, 51, 90]
Jabala        0-0 Al-Ittihad
Al-Wathba     0-4 Al-Wahda
  [Omar Al-Aqel 15, 69, Mohammed Ja'afar 65, Mohannad Kharrat 90]
Al-Majd       1-0 Umayya
  [Bashar Qaddour 70]
Al-Jaish      bye

Round 3 
[Nov 1]
Umayya        0-0 Al-Wathba
Al-Wahda      2-1 Jabala
  [Yanal Abaza 41, Mohamed Ja'afar 45; Akram Ali 75]
Qardaha       2-1 Al-Horriya
  [Samer Ouyoun Al-Soud 17, Ammar Ghazal 79; Amrou Diar-Bakarli 57]
Al-Yaqaza     2-2 Al-Shorta
  [Ahad Al-Saeed 40, Abdulajabbar Abdullah 85; Ayman Al-Aswad 39og,
   Mohamed Zaynou 47]
Al-Karama     1-0 Al-Jaish
  [Tareq Jabban 14og]
[Nov 3]
Al-Ittihad    3-2 Hottin
  [Radwan Al-Abrash 9, 26, 68; Ilia Chuba 17, Aref Al-Agha 62]
Al-Majd       bye

Round 4
[Nov 7]
Al-Jaish      4-0 Al-Yaqaza
  [Ziad Sha'abo 38, 39, Mohamed Al-Hamad 51og, Jomarad Moussa 66]
[Nov 8]
Al-Shorta     2-3 Qardaha
  [Yamen Shebli 75, Khaled Aqla 90; Mohamed Hammidi 25,
   Samer Ouyoun Al-Sood 28, Younes Suleyman 78]
Al-Horriya    2-0 Al-Ittihad
  [Mohannad Sheikh Deeb 10, Youssouf Al-Youssouf 63]
Hottin        1-1 Al-Wahda
  [Ilia Chuba 14; Mohamed Ja'far 45]
Jabala        0-0 Umayya
Al-Wathba     0-4 Al-Majd
  [Raja Nafe'e 42, 62, 71, Omar Khalil 79]
Al-Karama     bye

Round 5 
[Nov 14]
Al-Majd       1-4 Jabala
  [Abdulhadi Hariri 75; Oussama Al-Basha 15, 57, 87, 90]
[Nov 15]
Umayya        4-4 Hottin
  [Samer Yaziji 20, 42, 90, Adnan Mohamed 65; Ilia Chuba 25, 40, 45,
   Aref Al-Agha 44]
Al-Wahda      0-1 Al-Horriya
  [Mahmoud Al-Amneh 60]
Al-Ittihad    1-0 Al-Shorta
  [Nouhad Al-Boushi 82]
Al-Yaqaza     0-0 Al-Karama
[Nov 16]
Qardaha       2-0 Al-Jaish
  [Ammar Shemali 21, Mohamed Hammidi 61]
Al-Wathba     bye

Round 6
[Nov 21]
Al-Shorta     3-4 Al-Wahda    
[Nov 22]
Al-Karama     1-0 Qardaha          
Al-Jaish      2-1 Al-Ittihad
  [Ziad Sha’abo 27, 51; Anas Sari 43]
Al-Horriya    4-1 Umayya
  [Mohamed Istambouli 28, Mohamed Koussa 59, Youssouf Al-Youssouf 89,
   Imad Jaqalan 90; Hazem Harba 56]
Hottin        2-2 Al-Majd         
Jabala        1-2 Al-Wathba
  [Wafi Darwishe 75; Mohammed Turkmani 43, Talal Shouman 56]
Al-Yaqaza     bye 

Round 7
[Nov 29]
Al-Majd       0-2 Al-Horriya
  [Mahmoud Amneh 67, 75]
Qardaha       0-0 Al-Yaqaza
Al-Wathba     1-0 Hottin
  [Mohamed Shaherli 20]
Umayya        2-1 Al-Shorta
  [Hazem Harba 26, Samer Yaziji 43; Mohamed Zeino 86]
[Dec 1]
Al-Jaish      1-1 Al-Wahda
  [Ziad Sha’abo 78; Mohannad Kharrat 88]
Al-Ittihad    2-0 Al-Karama
  [Samer Hozam 42, Oussama Haddad (87]
Jabala        bye

Round 8
[Jan 2]
Al-Shorta     1-2 Al-Majd
  [Mohamed Zaynou 5; Mahmoud Mahmalji 32, Raja Rafe’e 37]
Hottin        0-0 Jabala
[Jan 3]
Al-Horriya    5-0 Al-Wathba
  [Ahmed Barakat 23, Samir Bakri 49, Yamen Abboud 65, Mahmoud Amneh 78,
   Mahmoud Rahim 84]
Al-Karama     0-1 Al-Wahda
  [Mohannad Kharrat 85]
Al-Jaish      5-0 Umayya
  [Ziad Sha’abo 27, 58, Ahmed Omayr 85, 90, Ahmed Koussa 89]
Al-Yaqaza     0-1 Al-Ittihad
  [Mohannad Al--Boushi 31]
Qardaha       bye

Round 9
[Jan 6]
Al-Ittihad    1-1 Qardaha
  [Mohannad Al-Boushi 44; Ammar Shemail 4]
Al-Wahda      4-1 Al-Yaqaza
  [Omar Al-Aqel 8, Nabil Al-Shahma 19, Ayyad Mando 37, 48;
   Mohamed Al-Hamad 45pen]
[Jan 7]
Al-Majd       1-3 Al-Jaish
  [Yazan Al-Sayyed 88; Ziad Sha’abo 39, 66pen, Hossam Zenko 82]
Jabala        0-0 Al-Horriya
Umayya        4-2 Al-Karama
  [Adnan Mohamed 10, 68pen, Samer Harba 43, Saeed Yaziji 75;
   Hassan Al-Masry 55pen, 59]
Al-Wathba     3-0 Al-Shorta
  [Firas Qashoush 1, Mohamed Shaherli 44, 60]
Hottin        bye

Round 10
[Jan 10]
Al-Horriya    0-1 Hottin
  [Aref Al-Agha 76]
Al-Jaish      1-0 Al-Wathba
  [Ahmed Ameer 7]
Al-Karama     1-1 Al-Majd
  [Hassan Al-Masry 68; Omar Khalil 80]
Al-Yaqaza     1-0 Umayya
  [Mohamed Al-Hamad 62]
Qardaha       1-2 Al-Wahda
  [Bassem Sheikh-Youssouf 50; Nabil Al-Shahma 4, Maher Mustapha 10]
[Jan 11]
Al-Shorta     2-1 Jabala          
Al-Ittihad    bye

Round 11
[Jan 13]
Al-Wahda      0-1 Al-Ittihad
  [Samer Hozam 54]
[Jan 17]
Al-Majd       2-0 Al-Yaqaza
  [Raja Rafe’e 39, 79]
Jabala        0-0 Al-Jaish
Hottin        2-1 Al-Shorta
  [Aref Al-Agha 18pen, 55; Mohamed Zaynou 19]
Al-Wathba     2-1 Al-Karama
  [Firas Qashoush 2, Mohannad Turkmani 39; Nizar Al-Hussein 18]
Umayya        0-3 Qardaha
  [Younes Suleyman 20, Raed Kurdi 19, 67]
Al-Horriya    bye       

Round 12
[Jan 20]
Al-Shorta     1-2 Al-Horriya
  [Mohannad Barakat 85; Amrou Bakarli 53, Youssouf Al-Youssouf 67]
Al-Ittihad    1-0 Umayya
  [Mohamed Boudaqqa 21]
[Jan 21]
Al-Karama     1-0 Jabala
  [Nizar Al-Hussein 88]
Al-Jaish      3-1 Hottin
  [Ziad Sha’abo 36, 57, Jomarad Moussa 88; Omran Al-Agha 86]
Al-Yaqaza     0-0 Al-Wathba  
Qardaha       3-0 Al-Majd
  [Younes Suleyman 20, Samer Ouyoun Al-Soud 58, Moqawwam Abbas 69]
Al-Wahda      bye
   
Round 13 
[Jan 24]
Al-Horriya    0-2 Al-Jaish
  [Ahmed Omayr 57, Raghdan Shehade 87]
Al-Majd       2-4 Al-Ittihad
  [Mahmoud Majmalji 26, Samer Awad 80; Radwan Al-Abrash 10, Anas Sari 25,
   Mohamed Boudaqqa 53, Ammar Rihawi 68]
Hottin        3-1 Al-Karama
  [Hisham Abdin 41, Salim Jabalawi 62, Aref Al-Agha 84; Ahmed Turkmani 87]
Al-Wathba     2-4 Qardaha
  [Moqawwam Abbas 16, Idriss Darwishe 57; Ammar Shemali 32, 
   Ahmed Ghazal 35, Mohamed Hammidi 60, 63]
Jabala        2-0 Al-Yaqaza
  [Walid Hammo 45, Wafi Darwishe 65]
[Jan 25]
Umayya        1-1 Al-Wahda           
Al-Shorta     bye                   

Round 14
[Jan 30]
Al-Jaish      4-2 Al-Shorta
  [Ziad Sha’abo 17, Ahmed Azzam 30, Bassel Sha’ar 90, Jomarad Moussa 90;
   Youssouf Al-Qaissi 45, 75]
[Jan 31]
Al-Wathba     1-2 Al-Ittihad
  [Firas Qashoush 34; Mohamed Boudaqqa 44, Ammar Rihawi 79]
Jabala        0-1 Qardaha 
  [Yoounes Suleyman 90]
Hottin        2-0 Al-Yaqaza 
  [Salim Jabalawi 60, Abdullatif Al-Helou 85]
Al-Wahda      3-3 Al-Majd 
  [Ayyad Mando 1, Walid Al-Sharif 52, 59pen; Samer Awad 45,
   Mahmoud Mahmalji 63, Omar Khalil 86]
Al-Horriya    0-0 Al-Karama
Umayya        bye

Round 15
[Feb 3]
Umayya        3-2 Al-Majd
  [Samer Yaziji 14, 24, Samer Hammadi 38pen; Omar Khalil 28, Raja Rafe’e 32]
[Feb 4]
Al-Ittihad    2-1 Jabala
  [Mohannad Al-Boushi 66, Mohamed Boudaqqa 82; Mohamed Idriss 17]
Qardaha       2-1 Hottin
  [Ammar Shemali 33, Samer Ouyoun Al-Soud 88; Aref Al-Agha 61]
Al-Wahda      0-1 Al-Wathba
  [Bilal Mogharbel 44]
Al-Yaqaza     1-0 Al-Horriya
  [Mahmoud Al-Naza’a 71]
Al-Karama     1-0 Al-Shorta
  [Abdulqader Al-Rifayi 47]
Al-Jaish      bye

Round 16
[Feb 7]
Hottin        3-2 Al-Ittihad
  [Aref Al-Agha 25pen, Jamal Kazem 63, Salim Jabalawi 68; Anas Sari 23, 67]
Al-Horriya    2-1 Al-Qardaha
  [Zakaria Al-Hussein 37, Mustapha Homsi 78; Ahmed Ghazal 17]
Al-Jaish      2-0 Al-Karama
  [Ahmed Azzam 48, Ziad Sha’abo 90]
Jabala        1-3 Al-Wahda
  [Akram Ali 84; Darrar Radawi 65, Ra’afat Mohamed 80, Mo’atassem Alaya 90]
Al-Wathba     1-0 Umayya
  [Mohamed Shaherli 28]
[Feb 8]
Al-Shourta    1-1 Al-Yaqaza 
  [Mohamed Barakat 45; Mohamed Al-Naza’a 66]
Al-Majd       bye

Round 17 
Al-Yaqaza     1-7 Al-Jaish    
Qardaha       1-0 Al-Shorta      
Al-Ittihad    2-1 Al-Horriya
Al-Wahda      2-1 Hottin
Umayya        1-0 Jabala
Al-Majd       2-1 Al-Wathba
Al-Karama     bye

Round 18
Jabala        1-1 Al-Majd 
Hottin        2-0 Umayya
Al-Horriya    0-2 Al-Wahda
Al-Shorta     2-4 Al-Ittihad
Al-Karama     2-2 Al-Yaqaza
Al-Jaish      0-0 Qardaha      
Al-Wathba     bye

Round 19 
Al-Wahda      1-1 Al-Shorta
Qardaha       3-0 Al-Karama
Al-Ittihad    3-1 Al-Jaish      
Umayya        1-1 Al-Horriya
Al-Majd       2-2 Hottin
Al-Wathba     0-1 Jabala
Al-Yaqaza     bye 

Round 20 
Al-Horriya    2-1 Al-Majd
Al-Yaqaza     0-3 Qardaha    
Hottin        3-0 Al-Wathba
Al-Shorta     1-1 Umayya
Al-Wahda      0-2 Al-Jaish
Al-Karama     1-3 Al-Ittihad
Jabala        bye

Round 21
Al-Majd       2-1 Al-Shorta    
Jabala        0-0 Hottin
Al-Wathba     1-0 Al-Horriya   
Al-Wahda      3-1 Al-Karama
Umayya        1-3 Al-Jaish
Al-Ittihad    0-0 Al-Yaqaza
Qardaha       bye

Round 22
[May 1]
Al-Shorta     3-2 Al-Wathba
  [Mohamed Camara 49, Mohamed Mansour 52, Ahmed Mulla Hassan 86;
   Talal Shouman 28pen, 77]
[May 2]
Al-Qardaha    1-2 Al-Ittihad
  [Ammar Shemali 14; Mohamed Boudaqqa 40pen, Anas Sari 57]
Al-Jaish      5-3 Al-Majd 
  [Ziad Sha’abo 1, 65, 82, Yahya Al-Rashed 45, Ahmed Azzam 70;
   Bashar Qaddour 13pen, Omar Khalil 77, 90]
Al-Horriya    3-1 Jabala 
  [Bassel Al-Youssouf 4, 85, Mahmoud Rahim 39pen; Wafi Darwishe 27]
Al-Karama     2-3 Umayya
  [Ahmed Turkmani 21, 55; Abdulmonhem Ahmed 30, 33, Hazem Harba 41]
Al-Yaqaza     1-1 Al-Wahda
  [Hekmat Na’asane 36; Mohamed Ja’afar 90]
Hottin        bye

Round 23 [May 6]
Hottin        5-4 Al-Horriya
  [Abdullatif Al-Helou 12, Salim Jabalawi 35, 37, Aref Al-Agha 44,
   Ammar Yassin 50; Mahmoud Amneh 21, Bassel Al-Youssouf 33,
   Mohannad Sheikh 65, Mahmoud Rahim 80]
Al-Wathba     2-4 Al-Jaish
  [Mahmoud Badawi 11, Ziad Majzoub 32; Majed Al-Hajj 11, Yahya Al-Rashed 13,
   Amer Al-Abtah 37, Ziad Sha’abo 63] 
Al-Majd       4-0 Al-Karama
  [Raja Rafe’e 5, 78, Samer Awadh 55, Mahmoud Mahmalji 65]
Jabala        1-0 Al-Shorta 
  [Khaled Jadiba 23]
Umayya        3-1 Al-Yaqaza
  [Hazem Harba 9, Nader Harbali 37, Samer Hamada 65; Yasser Assef 67]
Al-Wahda      1-1 Al-Qardaha
  [Omar Al-Aqel 90; Ammar Shemali 11]
Al-Ittihad    bye

Round 24
[May 8]
Al-Shorta     2-0 Hottin
  [Youssouf Al-Qaissi 66, Mohannad Barakat 88]
[May 9]
Al-Yaqaza     3-4 Al-Majd
  [Ayman Al-Aswad 17, Akram Mahmoud 34pen, Ghannam Al-Eissa 90;
   Ibrahim Kabtoul 1, Raja Rafe’e 6, 69, Hisham Sharbini 89]
Al-Jaish      1-0 Jabala
  [Ziad Sha’abo 77]
Al-Ittihad    0-3 Al-Wahda
  [Ayyad Mando 5, Ali Khalil 80, 84]
Al-Karama     2-1 Al-Wathba
  [Adbulqader Al-Rifayi 17, Jihad Al-Hussein 45; Ala’a Bahri 90]
Al-Qardaha    1-0 Umayya 
  [Ahmed Ghazal 32]
Al-Horriya    bye

Round 25 
Umayya        0-2 Al-Ittihad   
Jabala        0-1 Al-Karama   
Hottin        2-6 Al-Jaish
Al-Wathba     5-2 Al-Yaqaza
Al-Majd       3-3 Qardaha
[May 22]
Al-Horriya    3-1 Al-Shorta 
Al-Wahda      bye
   
Round 26 
[May 18]
Al-Jaish      3-0 Al-Horriya
  [Ayyad Abdulkarim 33, Ziad Sha’abo 55, Raghdan Shehade 73]
Al-Ittihad    3-2 Al-Majd
  [Anas Sari 42, Radwan Al-Abrash 63, Oussama Haddad 80;
   Raja Rafe’e 48, 67]
Qardaha       3-2 Al-Wathba
  [Lawrence Shemali 13, Ammar Shemali 55, 76; Tamam Hourani 60pen,
   Bilal Mogharbel 80]
[May 19]
Al-Wahda      2-1 Umayya     
  [Omar Al-Aqel 1, Walid Al-Sharif 68pen; Hazem Harba (24]   
Al-Karama     3-4 Hottin
  [Ahmed Turkmani 2, Atef Jeniat 58, 80; Aref Al-Agha 9, 30,
   Salim Jabalawi 25, 59]
[May 22, inferred]
Al-Yaqaza     0-4 Jabala       
Al-Shorta     bye                   

Final Table:
 
 1.Al-Jaish       24 18  3  3  62-21  57  (62-22) Champions  [Damascus] [aka Army Club]  
 2.Al-Ittihad     24 17  3  4  43-25  54  [Aleppo]       
 3.Qardaha        24 14  5  5  41-23  47  (41-24) [Qardaha]
 4.Al-Wahda       24 12  8  4  41-24  44  [Damascus]
 5.Al-Horriya     24 12  3  9  38-28  39  (39-28) [Aleppo]  
 6.Hottin         24 11  6  7  45-39  39  (45-38) [Latakia]   
 7.Al-Majd        24  8  7  9  45-47  31  [Damascus]
 8.Al-Wathba      24  8  2 14  27-45  26  [Homs]
 9.Al-Karama      24  7  4 13  25-42  25  [Homs]
10.Umayya         24  6  6 12  26-41  24  (27-41) [Idlib]                           
11.Jabala         24  5  7 12  19-23  22  (19-24) [Jabala]  
12.Al-Yaqaza      24  2  8 14  17-51  14  [Deir ez-Zor]
13.Al-Shorta      24  3  4 17  29-49  13  [Damascus] [aka Police]

NB: for some clubs differing goal differences are reported as indicated
    between brackets

Promoted: Al-Foutoua (Deir ez-Zor) en Teshrin (Latakia)





Authors: Mohamed S. Chbaro
(sp_editor@terra.net.lb),
Roberto Lahsen
(rlahsen@entelchile.net)
and Mohammed Qayed
(mhqayed@hotmail.com)

Last updated: 19 Aug 2010

(C) Copyright Mohamed S. Chbaro,
Roberto Lahsen, Mohammed Qayed and RSSSF 2002/10
						


  USO DE MEMORIA  
4,265,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.6735
Total Execution Time  0.6755
  CADENA URL  
/premier_league_siria2003
  GET DATOS  
$_GET['/premier_league_siria2003']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0144  SELECT type FROM routes WHERE alias = 'premier_league_siria2003'
0.0291  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 = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=504 AND type_rel = 3
0.0145  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.0148  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.0151  SELECT text_es as historical_text FROM leagues_text WHERE id=1853
0.0145  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 = 30116 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  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=504 GROUP BY c.id ORDER BY c.order_id ASC
0.0145  SELECT type,rule FROM rules WHERE categoryId = 504 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 21:36:49' 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 21:36:49' 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 21:36:49' 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 21:36:49' 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 = 'premier_league_siria' 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.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (30116) 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.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 (30116) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (30116) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0144  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 (30116) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (30116) AND (e.action IN (3,4) ) 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 (30116) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (30116) 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 (30116) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  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 = 30116 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0144  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 = 30116 AND rp.events > 0 ORDER BY rp.events 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=30116 AND rel.round=24
0.0155  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 = 30116 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0155  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 = 30116 AND esl.points > 0
0.0150  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` = 30116 ORDER BY creation_date DESC LIMIT 0, 10
0.0152  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` = 30116
0.0146  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` = 30116 AND c.`round` = 24 ORDER BY shedule ASC LIMIT 200
0.0145  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 = 24 AND e.real_date IS NOT NULL AND e.league_id = 30116 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 = 30116 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0148  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 `tables2003` 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 = 30116 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2003` 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 = 30116 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 30116 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0148  SELECT data1, data2 FROM services_tags WHERE categoryId=504
0.0148  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 504 AND l.year = 2003 ORDER BY l.group_code ASC
0.0148  SELECT group_code, extraName from `leagues` WHERE categoryId=504 AND year=2003