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

Premier League Siria 2002

Información Histórica
						

Final Table:

 1.Al-Jaish       18 10  7  1  29- 6  37  [2-1,3-0,1-0,n/p]  [Damascus] [aka Army Club]  
 2.Al-Ittihad     18 10  5  3  29-14  35  [2-0,2-0,2-0,3-0]  [Aleppo]                
 3.Al-Wahda       18  8  5  5  28-18  29  [1-1,1-0,3-1,1-2]  [Damascus]
 4.Al-Karama      18  7  4  7  24-22  25  [1-0,1-2,0-1,3-3]  [Homs]                    
 5.Umayya         18  6  6  6  26-24  24  [2-2,1-1,0-2,1-0]  [Idlib]
 6.Hottin         18  5  7  6  30-32  22  [1-1,1-2,0-1,1-1]  [Latakia]
 7.Jabala         18  5  5  8  21-29  20  [1-1,0-0,0-0,1-1]  [Jabala]
 8.Al-Wathba      18  4  5  9  21-38  17  [0-1,3-4,1-1,1-1]  [Homs]
 9.Al-Horriya     18  3  7  8  23-35  16  [3-2,0-2,3-2,n/p]  [Aleppo]      
10.Al-Majd        18  3  7  8  27-40  16  [3-3,1-1,1-1,2-2]  [Damascus]

NB: results between square brackets indicate matches annulled against Jihad
    and Teshrin

Al-Jihad (Qameshli) and Teshrin (Latakia) were excluded from the championship
and their matches annulled after round 21; their records at the time were
 -.Al-Jihad       21  8  8  5  30-24  32  Relegated  [Qameshli]            
 -.Teshrin        21  3  8 10  22-38  17  Relegated [Latakia]

Round 1
[Sep 20]
Majd        1-2 Jabala
  [Raja Rafe'e 60; Oussama Al-Basha 44, Akram Ali 64]
[Sep 21]
Wahda       1-1 Teshrin       [annulled]
  [Mahmoud Mahmalji 74; Abdulqader Bash-Biouk 6]
Wathba      2-2 Horriya
  [Majed Al-Ali 44, Hassan Ibrahim 50pen; Youssouf Al-Youssouf 24,
   Mustapha Homsi 30]
Ittihad     2-1 Karama
  [Anas Sari 53, Radwan Al-Abrash 65: Ahmed Turkmani 22]
Umayya      2-2 Jihad         [annulled]
  [Sobhi Yaziji 29, Ahmed Samer 90og; Haytham Kajjo 65, 86]
[Sep 22]
Jaish       4-0 Hottin
  [Jomarad Moussa 36, Raghdan Shehade 47, Mohamed Mansour 62, Ahmed Hariri 81]

Round 2
[Sep 27]
Teshrin     1-1 Umayya        [annulled]
  [Abdullah Mando 38; Shadi Njouri 61]
[Sep 28]
Jaish       1-0 Ittihad
  [Mohamed Mansour 3]
Karama      3-0 Wathba
  [Firas Al-Masry 43, Nizar Al-Hussein 54, Hassan Al-Masry 60]
Horriya     1-0 Wahda
  [Mohamed Hammidi 14]
Jabala      3-2 Hottin
  [Monaf Ramadan 5pen, Ayham Al-Basha 60, Oussama Al-Basha 62;
   Ziad Sha'abo 26,]
Jihad       3-3 Majd          [annulled]
  [Haytham Kajjo 11, 34, 45; Raja Rafe'e 3, 38, Omar Khalil 63]

Round 3
[Oct 4]
Wahda       1-2 Karama
  [Ismail Fatout 59; Ali Khalil 38og, Ahmed Turkmani 66]
[Oct 5]
Ittihad     2-1 Jabala
  [Radwan Al-Abrash 25, 83; Laurence Shemali 64]
Majd        1-1 Teshrin       [annulled]
  [Omar Khalil 23; Fadi Moubayyad 71]
Umayya      1-1 Horriya
  [Saeed Yaziji 75; Bassel Youssouf 72]
Hottin      1-1 Jihad         [annulled]
  [Imad Hassan 57; Abdulghani Abdulrazzaq 75]
Wathba      1-1 Jaish
  [Ayyad Mando 24; Ahmed Hariri 15]

Round 4
[Oct 13]
Jihad       0-2 Ittihad       [annulled]
  [Radwan Al-Abrash 39, Abdulqader Joubaily 76]
Jaish       0-0 Wahda
Teshrin     2-1 Hottin        [annulled]
  [Mohamed Al-Youssouf 55, Abdullah Mando 80; Ziad Sha'abo 30]
Karama      1-1 Umayya 
  [Tamer Al-Lawz 45; Nader Harbali 44]
Horriya     1-1 Majd
  [Mustapha Homsi 68; Yasser Hammo 58]
[Oct 15]
Jabala      3-1 Wathba
  [Jamal Rifayi 12, 49, Oussama Al-Basha 56; Bassem Rajab 32]

Round 5
[Oct 18]
Jaish       1-0 Umayya 
  [Yahya Al-Rashed 17]
[Oct 19]
Ittihad     2-0 Teshrin       [annulled]
  [Samer Hozam 45, Radwan Al-Abrash 80pen]
Jabala      0-1 Wahda
  [Ismail Fatout 67]
Hottin      1-1 Horriya
  [Nizar Al-Khatib 85; Youssouf Al-Youssouf 62]
Wathba      0-1 Jihad         [annulled]
  [Mustapha Ahmed 27]
Majd        1-2 Karama
  [Ammar Arnaout 27; Ahmed Turkmani 30, 89]

Round 6 [Oct 26]
Horriya     1-4 Ittihad
  [Mohamed Hammidi 21; Radwan Al-Abrash 29pen, 72, 88, Oussama Haddad 65]
Majd        0-2 Jaish 
  [Ahmed Hariri 14, Mohamed Mansour 80]
Hottin      0-0 Karama
Wathba      3-4 Teshrin       [annulled]
  [Hassan Ibrahim 23, 63, 90'pen; Abdulqader Bash-Biouk 23, 28,
   Salem Baraka 34, Mazen Assa'ad 82]
Jihad       0-1 Wahda         [annulled]
  [Ismail Fatout 48]
Umayya      4-0 Jabala
  [Hazem Harba 20, 90, Mohamed Hammo 53, 70]

Round 7 [Nov 2]
Wahda       2-0 Wathba
  [Jamal Mao 1, Mohamed Ja'afar 77]
Karama      0-1 Jaish
  [Ayyad Abdulkarim 85]
Ittihad     1-1 Hottin
  [Annas Sari 17; Abdullah Makkiyya 89]
Teshrin     2-3 Horriya       [annulled]
  [Abdulqader Bash-Biouk 61, Salem Baraka 62; Abdulkarim Al-Saleh 9, 74,
   Mohamed Estanbli 86]
Jabala      1-1 Jihad         [annulled]
  [Jamal Al-Rifayi 68; Mowaffaq Al-Hussein 14] 
Umayya      1-1 Majd
  [Mohamed Hammo 10; Raja Rafe'e 63]

Round 8
[Nov 8]
Majd        1-4 Wathba
  [Abdulhadi Hariri 82; Bassem Rajab 21, Fouad Al-Masry 57, 
   Abdulhakim Youssouf 84, Mohamed Shaherli 90]
[Nov 9]
Jaish       2-1 Jihad         [annulled]
  [Mohamed Mansour 13, Nouhad Hajj-Mustapha 60pen; Mustapha Ahmed 31]
Karama      1-0 Teshrin       [annulled]
  [Firas Al-Masry 53]
Ittihad     3-0 Wahda
  [Youssouf Sheikh Al-Ashra 31, Radwan Al-Abrash 64, 82]
Hottin      2-1 Umayya
  [Marwan Mona 45, Salim Jabalawi 80; Nader Harbali 75]
Jabala      3-2 Horriya
  [Jamal Rifayi 10, 60, Walid Hammo 90; Youssouf Al-Youssouf 45, 
   Mohamed Hammidi 65]

Round 9
[Nov 16]
Horriya     1-4 Jaish
  [Youssouf Al-Youssouf 60; Stefan Chubano 34, Mohamed Mansour 57,
   Nabil Al-Shahma 83, 85]
Umayya      0-1 Ittihad
  [Radwan Al-Abrash 85]
Jihad       2-1 Karama        [annulled]
  [Abbdulghani Abdulrazzaq 2, Hatham Kajjo 90; Jihad Al-Hussein 29]
Wahda       2-2 Majd
  [Ayyad Mando 54, Hassan Ibrahim 58; Ziad Sha'abo 26, Marwan Mona 60]
Wathba      0-0 Hottin
[Nov 17]
Teshrin     0-0 Jabala        [annulled]

Round 10
[Nov 22]
Wahda       3-0 Umayya
[Nov 23]
Jabala      0-0 Jaish
Wathba      1-1 Ittihad
  [Abdulhakim Youssouf 90; Samer Hozam 56]
Majd        0-4 Hottin
  [Talal Shouman 45, Hisham Abdin 60, Salim Jabalawi 67, 68]
Teshrin     2-4 Jihad         [annulled]
  [Fouad Rihawi 51, Fouad Tantawi 90; Abdulghani Abdulrazzaq 6,
   Mouwaffaq Al-Hussein 17, Haytham Kajjo 43, 45]
Horriya     1-0 Karama
  [Mohamed Hammidi 78]

Round 11
[Nov 30]
Umayya      3-1 Wathba
  [Yasser Hawwash 1, Samer Hamada 57pen, Nader Harbali 65; Thaer Ibrahim 35]
Ittihad     2-2 Majd
  [Radwan Al-Abrash 12, 77; Omar Khalil 59, Abdulhadi Hariri 63]
Karama      1-1 Jabala
  [Hassan Al-Masry 86; Oussama Al-Basha 8]
Jihad       2-0 Horriya       [annulled]
  [Kazzafi Ismat 25, Saleh Suleyman 85]
[Dec 7]
Jaish       3-0 Teshrin       [annulled]
  [Mohamed Mansour 48, Jomarad Moussa 78, 87]
Hottin      1-3 Wahda
  [Salim Jabalawi 22; Kevin Motali 14, 75, Mohamed Ja'afar 61]

Round 12
[Jan 13]
Hottin      1-1 Jaish
  [Salim Jabalawi 17; Jomarad Moussa 66]
[Jan 14]
Karama      0-1 Ittihad
  [Samer Hozam 40]
Jihad       2-0 Umayya        [annulled]
  [Najmar Othman 28, Abdulghani Abdulrazzaq 55]
Teshrin     1-3 Wahda         [annulled]
  [Omar Suwayyed 89; Edu 10, Walid Al-Sharif 41pen, Mahmoud Mahmalji 72]
Horriya     1-2 Wathba
  [Mustapha Homsi 34; Ayyad Mando 7, Tammam Hourani 90]
Jabala      2-2 Majd
  [Jamal Darwish 4, 20; Walid Hammo 57, Oussama Al-Basha 63]

Round 13
[Jan 17]
Wahda       0-0 Horriya
[Jan 18]
Ittihad     1-0 Jaish
  [Ali Sheikh-Dib 94]
Wathba      1-3 Karama
  [Thaer Ibrahim 29; Abdulqader Al-Rifayi 17, 87pen, Sobhi Aqoul 78]
Majd        1-1 Jihad         [annulled]
  [Abbdulhadi Al-Hariri 32; Haytham Kajjo 88]
Hottin      3-1 Jabala
  [Hisham Abdin 54, Talal Shouman 82, Dida Iliescu 87; Hassan Hamidoush 9]
Umayya      1-0 Teshrin       [annulled]
  [Shadi Bakhouri 62]

Round 14 [Jan 25]
Jabala      1-2 Ittihad
  [Mouwaffaq Al-Youssouf 83; Ali Sheikh-Dib 71, Radwan Al-Abrash 88pen]
Jaish       5-0 Wathba
  [Mohamed Khalaf 47, Ahmed Hariri 65, Jomarad Moussa 70, Ahmed Azzam 77, 
   Stefan Dumitrescu 89]
Jihad       1-0 Hottin        [annulled]
  [Abdulghani Abdulrazzaq 80]
Karama      2-1 Wahda
  [Abdulqader Al-Rifayi 58, 90pen; Walid Al-Sharif 68]
Horriya     1-2 Umayya
  [Salah Aliko 32; Hazem Harba 84, Mohannad Sheikh-Dib 90]
Teshrin     2-2 Majd          [annulled]
  [Mohamed Al-Youssouf 22, Mo'otaz Kilouni 57; Raja Rafe'e 10, 45]

Round 15
[Feb 7]
Majd        5-4 Horriya
  [Zakaria Al-Hussein 3og, Abdulhadi Al-Hariri 24, Raja Fafe'e 50, 59, Ahmed Ayyoub 52;
   Youssouf Al-Youssouf 10, Omar Bakarli 51, 66, Hassan Al-Shoufi 78pen]
[Feb 8]
Ittihad     2-0 Jihad         [annulled]
  [Oussama Haddad 8, Ammar Habib 58]
Wahda       0-0 Jaish 
Umayya      2-2 Karama
  [Mustapha Boukarkour 70, Saeed Yaziji 84; Fawwaz Mando 52, 82]
Hottin      1-1 Teshrin       [annulled] 
  [Andrea Borbili 28; Abdullah Mando 90]
Wathba      3-1 Jabala
  [Mohamed Shaherli 48, Thaer Ibrahim 50, Tammam Hourani 90; Jamal Rifayi 66]

Round 16
[Feb 14]
Wahda       1-1 Jabala 
  [Walid Al-Sharif 78; Oussama Al-Basha 90]
[Feb 15]
Umayya      0-0 Jaish
Karama      1-3 Majd
  [Abdulqader Al-Rifayi 16; Raja Rafe'e 33, 53, 71]
Horriya     4-2 Hottin
  [Omar Diar-Bakarli 37, 85, Salah Aliko 60, Bassel Youssouf 90; Salah Aliko 25og,
   Ziad Sha'abo 35]
Jihad       1-1 Wathba        [annulled] 
  [Mouwaffaq Al-Hussein 38; Thaer Ibrahim 69]
[Feb 16]
Teshrin     0-3 Ittihad       [annulled]  
  [Ammar Habib 16, Radwan Al-Abrash 45, Ammar Rihawi 90]

Round 17
[Feb 21]
Wahda       1-2 Jihad         [annulled] 
  [Mahmoud Mahlamji 70; Qazzafi Ismat 20pen, Mouwaffaq Al-Hussein 90]
Jabala      0-2 Umayya
  [Samer Hammadi 57pen, 86]
[Feb 22]
Ittihad     1-1 Horriya 
  [Radwan Al-Abrash 30; Youssouf Al-Youssouf 41]
Jaish       2-2 Majd
  [Mohamed Khalaf 42, Jomarad Moussa 45; Jamal Darwish 18, Samer Awad 60]
Karama      3-2 Hottin
  [Nizar Al-Hussein 5, 78, Ahmed Amir 35; Shehab Berro 27, Salim Jabalawi 75]
Teshrin     1-1 Wathba        [annulled] 
  [Abdullah Mando 35; Khaled Al-Shater 83]

Round 18
[Mar 15] 
Hottin      2-1 Ittihad
  [Ziad Sha'abo 61, 90; Anas Sari 81]
Jihad       0-0 Jabala        [annulled] 
Wathba      3-2 Wahda
  [Ayyad Mando 7, 76, Tammam Hourani 45; Kevin Motali 53, 90]
Horriya     3-2 Teshrin       [annulled]  
  [Mohamed Hammidi 21, 63, Youssouf Al-Youssouf 59; Amjad Hajj-Abdou 15,
   Mo'otaz Kilouni 35]
Majd        1-5 Umayya 
  [Bashar Qaddour 63; Nader Harbali 36, 86, Saeed Yaziji 50, Hazem Harba 55, 
   Yasser Yaziji 88]
[Mar 16]
Jaish       1-0 Karama 
  [Raghdan Shehade 53]

Round 19
[Apr 18]
Wathba      0-2 Majd
  [Bashar Qadour 34, Abdulhadi Hariri 78]
Horriya     0-0 Jabala
Teshrin     1-0 Karama        [annulled]  
  [Salem Baraka 27]
Umayya      1-1 Hottin
  [Saeed Yaziji 90; Ilia Chuba 2]
[Apr 19]
Wahda       1-0 Ittihad
  [Kevin Motali 34]
Jihad       0-1 Jaish         [annulled]  
  [Yahya Al-Rashed 45]

Round 20
[Apr 25]
Jaish       4-0 Horriya
  [Nabil Al-Shahma 14, 30, Yahya Al-Rashed 36, Mohamed Khalaf 45]
Karama      3-3 Jihad         [annulled]  
  [Hassan Al-Masry 29, Ahmed Omair 34, 44; Haytham Kajjo 37, 63,
   Mustapha Al-Ahmed 73]
[Apr 26]
Ittihad     5-0 Umayya 
  [Ammar Rihawi 28, 72, Anas Sari 33pen, Youssouf Sheikh Al-Ashra 90,
   Radwan Al-Abrash 91] 
Wahda       3-1 Majd
  [Ismail Fatout 12, 38, Walid Al-Sharif 68pen; Ammar Arnaout 71]
Hottin      4-0 Wathba 
  [Hisham Abdin 32, Salim Jabalawi 53, 86, Ilia Chuba 90]
Jabala      1-1 Teshrin       [annulled]  
  [Jamal Rifayi 57; Abdullah Mando 73]

Round 21 [May 4]
Jaish       2-0 Jabala
  [Nouhad Hajj-Mustapha 35pen, Yahya Al-Rashed 41]
Ittihad     1-1 Wathba
  [Ammar Habib 23; Fouad Al-Masry 3]
Umayya      0-2 Wahda
  [Kevin Motali 12, Ismail Fatout 66]
Hottin      2-2 Majd
  [Ilia Chuba 74, Ziad Sha'abo 90; Raja Nafe'e 3, Mohamed Ayyoub 76]
Jihad       3-0 Teshrin       [annulled]  
  [Araz Othman 25, Mowaffaq Al-Habsi 75, 80; two players of Jihad accepted
   a bribe from Teshrin, Jihad officials were notified of this before kick-off
   but failed to pass on the information to the FA; as punishment, both teams
   are relegated and all their matches declared void]
Karama      3-1 Horriya 
  [Hassan Al-Masry 9, 37, Firas Ma'asarani 62; Mohamed Hammidi 53]

Round 22 [May 10]
Wathba      1-3 Umayya
  [Ayyad Mando 21; Samer Hamada 10, Samer Yaziji 65, 68]
Majd        0-1 Ittihad
  [Anas Sari 40]
Jabala      2-0 Karama
  [Jamal Rifayi 39pen, Akram Ali 76]
Horriya     n/p Jihad
Teshrin     n/p Jaish
Wahda       6-2 Hottin

Final Table:

 1.Al-Jaish       18 10  7  1  29- 6  37  [2-1,3-0,1-0,n/p]  [Damascus] [aka Army Club]  
 2.Al-Ittihad     18 10  5  3  29-14  35  [2-0,2-0,2-0,3-0]  [Aleppo]                
 3.Al-Wahda       18  8  5  5  28-18  29  [1-1,1-0,3-1,1-2]  [Damascus]
 4.Al-Karama      18  7  4  7  24-22  25  [1-0,1-2,0-1,3-3]  [Homs]                    
 5.Umayya         18  6  6  6  26-24  24  [2-2,1-1,0-2,1-0]  [Idlib]
 6.Hottin         18  5  7  6  30-32  22  [1-1,1-2,0-1,1-1]  [Latakia]
 7.Jabala         18  5  5  8  21-29  20  [1-1,0-0,0-0,1-1]  [Jabala]
 8.Al-Wathba      18  4  5  9  21-38  17  [0-1,3-4,1-1,1-1]  [Homs]
 9.Al-Horriya     18  3  7  8  23-35  16  [3-2,0-2,3-2,n/p]  [Aleppo]      
10.Al-Majd        18  3  7  8  27-40  16  [3-3,1-1,1-1,2-2]  [Damascus]

NB: results between square brackets indicate matches annulled against Jihad
    and Teshrin

Al-Jihad (Qameshli) and Teshrin (Latakia) were excluded from the championship
and their matches annulled after round 21; their records at the time were
 -.Al-Jihad       21  8  8  5  30-24  32  Relegated  [Qameshli]            
 -.Teshrin        21  3  8 10  22-38  17  Relegated [Latakia]

Al-Jaish champions.

Promoted from 2nd level for 2002/03:
Al-Shorta (Damascus)
Qardaha (Qardaha)
Al-Shorta (Aleppo) [promotion annulled]
Al-Yaqaza (Deir ez-Zor)
 
NB: in September 2002 the Syrian FA decided that minor affiliations of major
    governmental institutions (like Jaish, Shorta) are prevented from entering
    the first level.
 
Author:
Mohamed S. Chbaro
(sp_editor@terra.net.lb)

Last updated: 29 Sep 2002

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


  USO DE MEMORIA  
4,266,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1026
Total Execution Time  0.1045
  CADENA URL  
/premier_league_siria2002
  GET DATOS  
$_GET['/premier_league_siria2002']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0018  SELECT type FROM routes WHERE alias = 'premier_league_siria2002'
0.0038  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 = 2002 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.0021  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.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 (1235933,1226851,842063,784104,757608) ORDER BY n.cover_points DESC, update_date DESC
0.0021  SELECT text_es as historical_text FROM leagues_text WHERE id=1852
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 = 30115 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=504 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 504 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 10:25:15' 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-28 10:25:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 10:25:15' 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-28 10:25:15' 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 = 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 (30115) 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.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 (30115) 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 (30115) 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 (30115) 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 events2002 e WHERE e.league_id IN (30115) AND (e.action IN (3,4) ) 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 (30115) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (30115) AND (e.action IN (22) ) 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 (30115) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  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 = 30115 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0018  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 = 30115 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0023  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=30115 AND rel.round=18
0.0020  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 30115 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  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 = 30115 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-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30115 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-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30115
0.0019  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` = 30115 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0017  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 = 18 AND e.real_date IS NOT NULL AND e.league_id = 30115 ORDER BY total DESC LIMIT 40
0.0022  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 = 30115 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0022  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 = 30115 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 30115 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 30115 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=504
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 504 AND l.year = 2002 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=504 AND year=2002