4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2001
Temporada Siguiente »
Publicidad 600x120.gif
Iraq Stars League 2001
2000/2001

Iraq Stars League 2001

Información Histórica 
						
Round 1 [Dec 25]
Najaf		4-0 Karkh		
Zawraa		2-1 Ramadi		
Quwa Jawiya     2-0 Nafat		
Shurta		3-0 Samawa		
Duhok		0-2 Talaba		
Samarra		3-1 Arbil		
Minaa		1-0 Karbala		
Kut		1-1 Defaa Jawiya    
 
Round 2  [Dec 29]
Arbil		0-3 Shurta		
Talaba	3-0 Quwa Jawiya     	
Zawraa		2-1 Kut		
Duhok		2-0 Samarra		
Nafat		2-1 Najaf		
Ramadi		1-2 Karkh		
Karbala		0-1 Defaa Jawiya    
Samawa		1-1 Minaa		
 
Round 3 [Jan 1]
Zawraa		3-2 Karkh            [at Al-Shaab]
  [Ammar Ahmed 36, Emad Mohammed 52, Laith Hussein 80pen;
   Abbas Hassan 29, 39]		
Karbala         3-2 Kut
  [Mahir Jalil 13, Fidaa Kadhim 67, Ahmed Shawat 81;
   Baha Al-Saghir 65, Ali Ibrahim 78]		
Ramadi		1-1 Nafat	
  [Shaker Shakr 75; Mushtaq Kadhim 34pen]	
Defaa Jawiya    1-0 Samawa	
  [Abbas Ali 38]	
Najaf		0-0 Talaba		
Minaa		0-0 Arbil		
Samarra		2-3 Quwa Jawiya     
  [Khalid Kadhim 15, Muayad Taha; Kadhim Hussein 1,
   Walid Dhahid 23pen, Loay Salah 37]	
Shurta		2-1 Duhok	
  [Ahmed Khudhair 15, 72; Hussein Abdullah 87]	
 
Round 4 [Jan 5]
Quwa Jawiya     1-0 Shurta	
  [Akram Emmanuel 70]	
Zawraa		8-0 Karbala	
  [Ammar Ahmed ?, ?, 32, Hussam Fawzi, Emad Mohammed 35, 71,
   Husham Mohammed 75, Ahmed Kadhim 85]	
Nafat		1-1 Karkh	
  [Ali Mohammed Abdullah 59; Haidar Hamed 19]	
Samawa		1-1 Kut	
  [Dhia Abdul-Hakim 29; Thair Zuwaid 5]	
Talaba	2-0 Ramadi	
  [Ahmed Ibrahim 25, Baha Kadhim 44]	
Defaa Jawiya    2-0 Arbil
  [Abbas Ali 35, Mohammed Jassim 90]		
Najaf		1-0 Samarra	
  [Ahmed Awaid 90]	
Duhok		2-0 Minaa		
  [Hussein Abdullah 70, Zirfan Saadallah 86]

Round 5 [Jan 9]
Zawraa		5-0 Nafat		
Defaa Jawiya    2-1 Duhok		
Shurta		3-0 Najaf		
Samarra		4-0 Ramadi		
Arbil		2-1 Kut		
Samawa		1-0 Karbala		
Karkh		0-0 Talaba		
Minaa		0-0 Quwa Jawiya     

Round 6 [Jan 12]
Zawraa		2-0 Samawa		
Nafat		1-2 Talaba		
Arbil		2-0 Karbala		
Karkh		5-1 Samarra		
Kut		0-1 Duhok		
Ramadi		0-2 Shurta		
Najaf		2-0 Minaa		
Quwa Jawiya     1-1 Defaa Jawiya     [inferred; played later]
 
Round 7 [Jan 19]
Talaba	1-0 Zawraa
Shurta		0-1 Karkh	
Defaa Jawiya    1-0 Najaf	
Samawa		1-0 Arbil	
Samarra		2-2 Nafat	
Karbala		1-3 Duhok	
Kut		0-1 Quwa Jawiya     
Minaa		2-2 Ramadi	
 
Round 8 [Jan 26]
Talaba	3-0 Samarra		
Arbil		0-4 Zawraa		
Shurta		1-0 Nafat		
Quwa Jawiya     2-0 Karbala		
Ramadi		0-1 Defaa Jawiya    
Minaa		1-4 Karkh		
Duhok		2-0 Samawa		
Najaf		1-0 Kut		

Round 9 [Feb 2]
Zawraa		6-2 Samarra
Karkh           2-2 Air Defence 
Shurta          2-3 Talaba  
Arbil		1-1 Duhok
Kut             2-1 Ramadi
Samawa          0-1 Air Force
Air Force       2-1 Ramadi
Najaf           1-0 Karbala
Minaa            1-0 Nafat

Round 10 [Feb 9]
Zawraa		4-0 Duhok		
Shurta		1-3 Samarra		
Nafat		1-1 Defaa Jawiya    
Karkh		1-0 Kut		
Najaf		2-0 Samawa		
Ramadi		1-0 Karbala		
Quwa Jawiya     0-0 Arbil		
Talaba	1-1 Minaa		
 
Round 11 [Feb 16]
Shurta		2-1 Zawraa		
Duhok		1-1 Quwa Jawiya     	
Minaa		0-0 Samarra		
Arbil		0-2 Najaf		
Defaa Jawiya    1-1 Talaba		
Samawa		9-0 Ramadi		
Nafat		2-1 Kut		
Karbala		0-3 Karkh		
 
Round 12 [Feb 23]
Zawraa		4-2 Quwa Jawiya     	
Kut		0-1 Talaba		
Shurta		1-0 Minaa		
Samarra		1-0 Defaa Jawiya    
Najaf		0-0 Duhok		
Karkh		0-0 Samawa		
Nafat		0-0 Karbala		
Arbil		2-1 Ramadi		

Round 13 [Mar 3]
Minaa		0-1 Zawraa		
Shurta		2-2 Defaa Jawiya    
Quwa Jawiya     2-1 Najaf		
Arbil		0-0 Karkh		
Duhok		2-0 Ramadi		
Samarra		 -  Kut		
Samawa		1-3 Nafat		
Talaba	0-0 Karbala		
 
Round 14 [Mar 9] 
Kut		0-3 Shurta		
Najaf		1-0 Zawraa		
  [Ahmed Awaid 6]
Nafat		1-1 Arbil
  [Mushtaq Kadhim 32; Haidar Yahya 48]
Samarra		2-1 Karbala
  [Ahmed Khalaf 14, Alaa Awoj 68; Fidaa Ibrahim 43]
Samawa		1-3 Talaba
  [Ahmed Ibrahim 88; Abdul-Amir Hassan 50, Arkan Najib,
   Baha Kadhim 83]
Quwa Jawiya     4-3 Ramadi           [at Al-Zawraa]
  [Uday Abdul-Khaliq 42, 71, Dhargham Ali 8, Aqil Karim 55;
   Mohammed Hamed 48, Hikmat Arzej 60, Jassim Sarhan 70]
Defaa Jawiya    0-0 Minaa
Karkh		1-3 Duhok
  [Aqil Mutaab 26; Hussein Abdullah 58, 91,
   Jassim Mohammed Suliman 83]

Round 15 [Mar 16] 
Zawraa		5-0 Defaa Jawiya     
  [Husham Mohammed 14, Ammar Ahmed 54, Laith Hussein pen,
   Mohammed Jassim 2]
Arbil		1-1 Talaba 
Shurta		2-0 Karbala
Quwa Jawiya     1-1 Karkh		
Duhok		4-0 Nafat
Ramadi		1-1 Najaf		
Minaa		2-0 Kut
Samawa		2-0 Samarra		

Round 16 [Apr 20] 
Karkh		1-2 Najaf		
Ramadi	        1-0 Zawraa		
Nafat	        0-1 Quwa Jawiya     
Samawa		0-0 Shurta		
Talaba          0-1 Duhok		
Arbil		0-0 Samarra		
Karbala         0-2 Minaa		
Kut		0-1 Defaa Jawiya    

Round 17
Zawraa		6-1 Kut
Shurta		5-1 Arbil
Quwa Jawiya     2-0 Talaba
Karkh		3-2 Ramadi		
Defaa Jawiya    3-0 Karbala
Nafat		0-0 Najaf
Samarra		1-2 Duhok
  [Ahmed Khalaf 82; Jassim Mohammed Suliman 54, Hussein Abdullah 72]
Minaa		1-0 Samawa
  [Ghazi Fahad 77]

Round 18 [May 4]
Karkh		1-0 Zawraa
  [Ammar Abdul-Hussein 39]
Duhok		3-0 Shurta		
Karbala		1-0 Kut
Nafat		4-2 Ramadi		
Quwa Jawiya     5-1 Samarra
Samawa		1-0 Defaa Jawiya    
Talaba 		1-0 Najaf            [at Al-Shurta]
Arbil		0-2 Minaa

Round 19 
[Apr 27]
Karbala		 -  Zawraa
Karkh		 -  Nafat
Ramadi		 -  Talaba
Minaa		 -  Duhok
Samarra		 -  Najaf
Kut		 -  Samawa
Arbil		 -  Defaa Jawiya    
[Apr 28]
Quwa Jawiya     2-1 Shurta		

Round 20 [May 7]
Zawraa		4-2 Nafat	     [at Al-Shaab]
  [Laith Hussein 8, Husham Mohammed 24, Abbas Rahim 25,
   Adnan Mohammed 44; Mahdi Karim 3, 59]
Samawa		3-0 Karbala
  [Basim Thijeel 31, 39, Ali Mansour 60]
Najaf		0-2 Shurta		
  [Ahmed Khudhair 16, Mudar Khalaf 79]
Arbil		1-0 Kut
  [Mohammed Kadhim 15
Quwa Jawiya     0-0 Minaa	     [at Al-Karkh]
Ramadi		1-2 Samarra
  [Falah Jahid 16; Ahmed Khalaf 76, Mohammed Jassim 86]
Talaba		1-1 Karkh	     [at Al-Shurta]
  [Ali Wahaib 7; Taiseer Abdul-Hussein 55]
Duhok		2-0 Defaa Jawiya    
  [Hussein Abdullah 20, Nassir Abdul-Amir 92]

Round 21 
Shurta	        1-0 Ramadi		
  [Ahmed Khudhair 69]
Kut		1-1 Duhok
  [Hussein Mashadi 38; Ahmed Jadih 70]
Karkh		1-1 Samarra
  [Aqil Mutaab 28; Awad Kadhim 30]
Minaa		0-1 Najaf
  [Falah Hassan]
Karbala		0-1 Arbil
  [Rafid Badraddin 93]
Nafat		0-1 Talaba           [at Al-Karkh]
  [Alaa Kadhim 82]
[May 12]
Defaa Jawiya    0-2 Quwa Jawiya      [at Al-Shurta]
  [Haidar Ahmed 10, Dhargham Ali 47]
Samawa		1-3 Zawraa
  [Khalid Aoda 58; Alaa Abdul-Sattar 17, Abbas Rahim 30,
   Ahmed Kadhim 39]

Round 22 [May 15]
Najaf		1-0 Defaa Jawiya    
  [Ali Hashim 67]
Karkh		1-2 Shurta		
  [Aqil Mutaab 33; Riyadh Abdul-Abbas 46, Amer Mushraf]
Nafat		1-1 Samarra
  [Mahdi Karim 35; Ali Hussein 41]
Ramadi		1-2 Minaa
  [Amer Hadi 63; Ali Salman 47, Ghazi Fahad 50]
Arbil		3-2 Samawa
  [Anmar Salam 52, Mohammed Kadhim 60, 70 pen; Ahmed Ibrahim 44, 57]
Duhok		5-1 Karbala
  [Hussein Abdullah 28, 61, 71, Ahmed Jadih 59, Zirvan Saadallah 85;  
   Ali Jaber 88]
[Jun 11]
Zawraa		3-0 Talaba
  [Husham Mohammed 5, 85, Essam Hamad 69]
Quwa Jawiya     3-0 Kut		     [at Al-Shurta]
  [Uday Abdul-Khaliq 55, 85, Ali Zaghir 70 pen]

Round 23 [May 20]
Zawraa		5-2 Arbil		
  [Hussam Fawzi 12, 28, Alaa Abdul-Wahid 40, Laith Hussein 48pen,
   Ahmed Abdul-Jabar 82; Anmar Salam 64, Kifah Abdul-Rahman 889
Shurta		3-0 Nafat
  [Mazin Abdul-Sattar, Mahir Ogla, Uday Mohammed 37]
Karbala		1-5 Quwa Jawiya     
  [Abbas Shalal 47; Dhargham Ali 4, 29, 78, Uday Abdul-Khaliq 43,
   Naem Saddam 53]
Kut		0-2 Najaf
  [Haidar Najim 67, 86]
Samawa		0-0 Duhok
Ramadi		0-3 Defaa Jawiya    
  [Abbas Jafar 8, 12, Jumaa Khudhair 28 pen]
Samarra		0-1 Talaba
  [Abdul-Amir Hassan 4]
Minaa		1-2 Karkh
  [Mahmoud Yassir 60 pen; Ammar Abdul-Hussein 67, Abbas Hassan 80]

Round 24
Najaf		3-0 Karbala
Nafat		3-0 Minaa
  [Mahdi Karim 40, Ali Mohammed Abdullah 45, 50]
Duhok		2-0 Arbil
Ramadi		2-1 Kut
  [Amer Hadi 34, Nadhal Najib 82; Thair Zuwaid 21]
Karkh		1-3 Defaa Jawiya    
  [Ammar Abdul-Hussein 89; Abbas Jafar 18, Ali Faisal 47,
   Mohammed Jassim 75]
Samarra		0-1 Zawraa
Talaba 		2-0 Shurta		
Quwa Jawiya      -  Samawa
 
Round 25 [May 26]
Duhok		0-1 Zawraa
  [Munir Jaber o.g 52]
Shurta		3-0 Samarra
Kut		2-1 Karkh
  [Abbas Alewi 27, Rahim Saeed 80; Abbas Hassan 31 pen]
Arbil		0-1 Quwa Jawiya     
  [Ameer Obaid 14]
Minaa		3-0 Talaba
  [Asaad Abdul-Razzaq 9, 78 pen, Naif Falah 50]
Samawa		0-0 Najaf
Defaa Jawiya    1-0 Nafat
  [Mohammed Jassim 52]
 
Round 26
Zawraa		2-0 Shurta		
  [Laith Hussein 59 pen, Husham Mohammed 68]
Samarra		1-0 Minaa
  [Uday Abdul-Ridha 36]
Ramadi		2-1 Samawa
  [Falah Jahid 43, Jumaa Jadih 84; Ahmed Abdul-Razzaq 10]
Najaf		1-0 Arbil
  [Abbas Wahoudi 9]
Quwa Jawiya     4-0 Duhok
  [Ameer Obaid 3, Uday Abdul-Khaliq 21, Ali Zaghir 33,
   Dhargham Ali 83]
Talaba		1-1 Defaa Jawiya     [at Al-Zawraa]
Kut		0-2 Nafat
  [Ahmed Hassan Fadhil 59, Mahdi Karim 63]

Round 27
Quwa Jawiya     2-2 Zawraa
  [Hammam Salih 21, Ali Zaghir 61; Abbas Rahim 10,
   Husham Mohammed 60]
Minaa		1-1 Shurta		
  [Asaad Abdul-Razzaq 47 pen; Haidar Hamed 50]
Karbala		0-2 Nafat
  [Mahdi Karim 42, ?]
Ramadi		2-2 Arbil		
  [Rasheed Ahmed 16, Falah Jahid 88; Muwafaq Younis 3,
   Mohammed Kadhim 67]
Talaba		3-1 Kut
  [Alaa Kadhim 12, Adil Abdul-Massih 15, Ahmed Ibrahim 85;
   Thair Zuweid 80]
Samawa		0-1 Karkh
  [Abbas Hassan 25]
Duhok		0-0 Najaf

Round 28
Ramadi	        0-3 Duhok
  [Hussein Abdullah 54, Ahmed Jadih 58, Ali Numan]
Nafat		0-0 Samawa
Najaf		0-0 Quwa Jawiya     
Karbala	        1-3 Talaba
Shurta		3-1 Defaa Jawiya    
  [Ahmed Khudhair; Ghanim Khudhair]
Minaa		0-3 Zawraa
  [Husham Mohammed 14, Adnan Mohammed 32, Abbas Rahim]
Karkh		2-0 Arbil
  [Taiseer Abdul-Hussein 46, Azhar Tahar 90]
 
Round 29
Zawraa		1-0 Najaf
  [Hussam Fawzi 70 pen]
Quwa Jawiya     0-1 Ramadi		
  [Amer Hadi 90]
Talaba		2-0 Samawa
Kut		1-5 Shurta		
  [Ahmed Khudhair 10, 20, 52, 70, 88; Thair Zuwaid 90]
Duhok		1-0 Karkh
Minaa		1-0 Defaa Jawiya    
  [Ghazi Fahad 5]
Karbala 	5-1 Samarra
  [Mohanad Talib 43, Saad Mashawi 50, 90, Adil Abid Zaid 67,
   Rajah Mohammed 83; Ahmed Khalaf]
Nafat		1-1 Arbil
  [Mahdi Karim 44; Mohammed Kadhim 25]
  [Note: seven clean sheets for Najaf keeper Jassim Mohammed Hamad 
   and 70 minutes of the match against Zawraa a total of 700 minutes]
 
Round 30
Kut		0-2 Minaa
  [Ali Salman 7, 11]
Defaa Jawiya    2-1 Zawraa
  [Farid Jafar 11, Younis Ashour 86; Husham Mohammed 12]
Shurta		7-0 Karbala
  [Rahim Raboa 17, Qais Issa 21, Amer Mushraf 24, 44, 80,
   Mahir Ogla 70, Ayad Abbas 75]
Samarra		1-1 Samawa
  [Ahmed Hamed 85; Muhsin Abdul-Nabhi 69]
Talaba 		2-2 Arbil	     [at Al-Zawraa]
  [Alaa Kadhim 2, Habib Jafar 12; Thair Saliwa 42,
   Kifah Abdul-Rahman 58]
Karkh		2-1 Quwa Jawiya     
  [Azhar Tahar 31, Ahmed Khalaf 48; Dhargham Ali 50]
Najaf		4-1 Ramadi		
  [Jassib Sultan 41 pen, Fuad Jawad 52, 70, Haidar Najim 75;
   Amer Hadi 80]
Nafat		2-1 Duhok
  [Ali Hussein Abdullah 52, Mahdi Karim 92; Hussein Abdullah 18]

Final Table:

 1.Al-Zawraa          30  23  1  6  80-24   70  Champions
 2.Al-Quwa Al-Jawiya  30  18  8  4  53-24   62  [Air Force]
 3.Al-Shurta          30  19  3  8  60-26   60  [Police]
 4.Talaba             30  17  9  4  42-21   60
 5.Duhok              30  16  7  7  44-24   55
 6.Al-Najaf           30  15  7  8  31-16   52
 7.Al-Karkh           30  14  8  8  48-33   50
 8.Al-Defaa Al-Jawiya 30  13  9  8  33-29   48  [Air Defence]
 9.Al-Minaa           30  10 10 10  24-26   40  [Port]
10.Samarra            30  10  6 14  34-41   36
11.Al-Nafat           30   8 10 12  32-41   34  [Nafat]
12.Arbil	      30   6 11 13  24-46   29
13.Samawa             30   6  8 16  26-37   26
14.Ramadi             30   6  4 20  31-67   22
----------------------------------------------  
15.Kut                30   3  3 24  17-55   12  Relegated
16.Al-Karbala         30   3  2 25  17-77   11  Relegated

NB: total GD +9


Topscorers:

1.Husain Abdulla (Duhok)  21
2.Ahmad Khudair (Shurta)  19
3.Ammar Ahmed (Zawraa)    14



Authors: Hassanin Mubarak and Mohammed Qayed

Last updated: 18 Dec 2008

(C) Copyright Hassanin Mubarak,
Mohammed Qayed and RSSSF 2001/08


  USO DE MEMORIA  
4,257,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0936
Total Execution Time  0.0955
  CADENA URL  
/super_league_iraq2001
  GET DATOS  
$_GET['/super_league_iraq2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0017  SELECT type FROM routes WHERE alias = 'super_league_iraq2001'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'super_league_iraq' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2001 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=476 AND type_rel = 3
0.0021  SELECT text_es as historical_text FROM leagues_text WHERE id=905
0.0019  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 = 29227 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='2001' WHERE c.parentId=476 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 09:42:04' 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 09:42:04' 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-27 09:42:04' 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 09:42:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'super_league_iraq' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2001 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 events2001 e WHERE e.league_id IN (29227) 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 (29227) 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 events2001 e WHERE e.league_id IN (29227) AND (e.action IN (4,5) ) 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 (29227) 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 events2001 e WHERE e.league_id IN (29227) 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 (29227) 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 events2001 e WHERE e.league_id IN (29227) 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 (29227) 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 = 29227 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 = 29227 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0026  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=29227 AND rel.round=30
0.0019  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 = 29227 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0020  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 = 29227 AND esl.points > 0
0.0021  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` = 29227 ORDER BY creation_date DESC LIMIT 0, 10
0.0022  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` = 29227
0.0020  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 `calendars2001` 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` = 29227 AND c.`round` = 30 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 `events2001` e INNER JOIN calendars2001 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 = 30 AND e.real_date IS NOT NULL AND e.league_id = 29227 ORDER BY total DESC LIMIT 40
0.0024  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 `events2001` e INNER JOIN calendars2001 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 = 29227 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0023  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 `tables2001` 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 = 29227 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2001` 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 = 29227 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 29227 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0023  SELECT data1, data2 FROM services_tags WHERE categoryId=476
0.0023  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 476 AND l.year = 2001 ORDER BY l.group_code ASC
0.0023  SELECT group_code, extraName from `leagues` WHERE categoryId=476 AND year=2001