4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Iraq Stars League 1992
1991/1992

Iraq Stars League 1992

Información Histórica
						

Round 1 [Oct 3, 4] and 20 [Feb 20, 21]
Zawraa         3-2 3-2 Talaba
  [Ahmad Radi (3); Alaa Kadim, Mahdi Kadim]
  [I. Abid Nadir 8, Ali Hadi 34, A. Radi 58; Habib Jafar 15, Alaa Kadim 90]                    
Salam          0-1 0-1 Shurta
  [Saeed Nuri]
  [Saad Najim]
Tijara         1-2 0-0 Shabab
  [Daman Muneer; Mazin Abdul Sattar, Salah Hussain]
Salikh         1-0 0-2 Salah-Al-Deen
  [Khudair Abbas 90]
Karkh          3-1 2-2 Arbil 
Najaf          0-0 0-2 Nafat
Samarra        2-0 0-0 Amana
  [Zahid Kasim, Fuad Ghazi]
Khutot         2-0 1-1 Mosil
  [Raheem Hameed (2)]
Kut            0-0 1-1 Sinaa
Minaa          2-2 1-1 Quwa Jawiya
  [1st Round match played Oct 7]
  [Amer Taha, Radi Ishnaishil (og); Majid Abbas, Akrum Ammanueel]

Round 2 [Oct 10, 11] and 21 [Feb 27, 28]
Shurta         1-1 1-0 Talaba
  [Yonis A. Ali (pen); Mahdi Kadim]
  [Nasir Hussain 10]
Salam          0-0 0-1 Amana
  [Inad Abid]
Samarra        1-1 0-0 Salah-Al-Deen
Mosil          3-2 0-0 Tijara
Karkh          2-3 1-0 Quwa Jawiya
  [Saad Kais 45]
Zawraa         1-1 1-1 Nafat
  [I. Abid Nadir; Ghassan Raof (pen)]
  [A. Radi (pen); Shakir Abod] 
Shabab         0-0 0-2 Najaf
  [Muhammad Izgair 25, Ali Hashim 77]
Salikh         0-2 0-0 Arbil 
Khutot         0-0 0-0 Kut 
Sinaa          1-0 0-0 Minaa

Round 3 [Oct 17, 18] and 22 [Mar 5, 6]
Nafat          1-2 0-0 Talaba
  [Habib Jafar, Amer Kasim; Majeed Abdul Rida]
Shurta         1-0 0-0 Amana
Kut            1-3 0-1 Tijara
Minaa          0-1 0-0 Khutot 
Karkh          0-0 1-0 Sinaa
  [Saad Kais]
Zawraa         2-0 3-0 Shabab
  [A. Radi (2)]
  [Kareem Sadam, A. Radi (2)]
Salam          2-2 0-0 Salah-Al-Deen
Najaf          3-0 0-1 Mosil
Samarra        1-0 1-3 Arbil 
Salikh         1-0 1-0 Quwa Jawiya

Round 4 [Oct 24, 25] and 23 [Mar 12, 13]
Amana          0-0 0-2 Talaba
  [Habib Jafar, Alaa Kadim]
Nafat          4-2 0-0 Shabab
Shurta         1-0 1-1 Salah-Al-Deen
Mosil          1-4 0-1 Zawraa
  [Haris Muhammad; Raid Khalil, A. Radi (2), Laith Hussain]
  [Laith Hussain]          
Quwa Jawiya    3-0 1-0 Samarra
  [Ali Izgair]
Salam          1-1 0-0 Arbil 
Najaf          2-2 2-1 Kut 
  [in the round 4 match, Ali Raheem (Kut), a former handball player, scored
   the first goal after 19 seconds, the fastest ever league goal in Iraq]
Tijara         0-1 2-2 Minaa
Salikh         1-2 1-1 Sinaa
Khutot         1-3 0-1 Karkh
  [?; Kareem Alawi, Saad Kais (2)]
  [Saad Kais]

Round 5 [Oct 31, Nov 1] and 24 [Mar 19, 20]
Shabab         1-2 0-1 Talaba
  [Ismaeel Muhammad (pen); Amer Kasim, Ali Hussain]
  [Habib Jafar]
Amana          2-1 1-2 Salah-Al-Deen
Nafat          0-0 0-1 Mosil
Shurta         2-0 1-0 Arbil 
Karkh          1-0 4-1 Tijara
  [Kareem Shakir (2), Saad Kais, ?; ?]
Salikh         0-0 1-2 Khutot 
Samarra        1-3 0-2 Sinaa
Minaa          0-0 0-0 Najaf
Salam          1-2 2-3 Quwa Jawiya
  [?; Hazim Yasir, Sabah Ijair (2)]
Zawraa         6-0 1-0 Kut 
  [Naeem Sadam]

Round 6 [Nov 7, 8] and 25 [Mar 26, 27]
Talaba         3-0 3-3 Salah-Al-Deen
  [Kadim Jabir 8, Habib Jafar 27pen, Ali Husain 80]
Shurta         0-0 0-1 Quwa Jawiya
  [Saad Abdul Hameed (pen)]
Salam          4-0 2-0 Sinaa
  [Muhammad Tuma (3), Husain Shakir]
Najaf          1-0 0-1 Karkh
  [Majid Najim] [Sharar Haider]
Tijara         2-0 1-0 Salikh 
Mosil          1-1 0-0 Shabab
Amana          3-1 3-1 Arbil 
Nafat          3-0 1-2 Kut 
Zawraa         5-2 2-0 Minaa
  [Ahmad Radi (2)]
Khutot         2-2 1-0 Samarra
  [Raheem Hameed]

Round 7 [Nov 14, 15] and 26 [Apr 2, 3]
Kut            2-2 2-0 Shabab
Amana          1-2 0-1 Quwa Jawiya
  [Hazim Yasir]
Minaa          0-3 1-2 Nafat
Shurta         4-0 1-0 Sinaa
  [Ziad Tarik, Sadoon Yosif, Saeed Nori, Saad Najim]
  [Ziad Tarik]
Salam          1-2 0-0 Khutot 
Mosil          0-3 0-2 Talaba
  [Alaa Kadim (2), Ali Hussain]
Salah-Al-Deen  1-3 4-2 Arbil 
Zawraa         2-3 2-2 Karkh
  [A. Radi, Kareem Sadam; Munthir Khalaf (2), Mudhir Khalaf]
Salikh         0-0 0-4 Najaf
Samarra        0-1 1-1 Tijara

Round 8 [Nov 21, 22] and 27 [Apr 9, 10]
Talaba         4-1 3-1 Arbil 
  [Kadim Jabir (2), Ali Hussain; ?]
Quwa Jawiya    1-0 0-1 Salah-Al-Deen
  [Akrum Ammanueel]
  [Maitham Kamal]
Amana          1-1 1-2 Sinaa
Nafat          0-0 1-3 Karkh
Najaf          0-0 1-0 Samarra
Kut            1-0 0-0 Mosil
Shabab         1-1 1-3 Minaa
Shurta         0-0 0-0 Khutot 
Zawraa         8-0 2-0 Salikh 
  [A. Radi (2), K. Sadam (2), L. Hussain (2), I. Abid Nadir, Raid Khalil] 
  [Ali Hadi, Muhammad Jasim]
Salam          3-2 0-0 Tijara

Round 9 [Nov 28, 29] and 27 [Apr 16, 17]
Quwa Jawiya    3-1 3-0 Arbil 
  [Akrum Ammanueel 29, 54, Sabah Ijair 57; Tarik Abdul Rahman 81]
Karkh          1-1 1-1 Shabab
  [Saad Kais; Alaa Abdul Jabbar]
  [Salim Hussain; ?]
Nafat          1-0 0-1 Salikh 
  [Majeed Abdul Rida 5]
  [Haider Najim]
Shurta         2-0 1-0 Tijara
  [Yonis Abid Ali, Sadoon Yosif]
Najaf          1-0 1-0 Salam
  [Muhammad Ijwad 78]
Kut            0-0 0-2 Talaba
   [Ali Hussain 11, Alaa Kadim 29pen]
Mosil          4-1 0-3 Minaa
Sinaa          0-0 0-0 Salah-Al-Deen
Zawraa         4-0 0-0 Samarra
  [A. Radi (2), K. Sadam, L. Hussain]
Amana          0-0 0-0 Khutot 

Round 10 [Dec 5, 6] and 29 [Apr 23, 24]
Quwa Jawiya    2-0 2-0 Talaba
  [Akrum Ammanueel 5, 7]
  [Hazim Yasir, Majid Abbas]
Sinaa          3-0 1-0 Arbil 
Khutot         2-1 0-0 Salah-Al-Deen
Shabab         0-0 2-1 Salikh 
Samarra        1-0 1-0 Nafat
  [Adnan Hamad]
Zawraa         1-0 1-2 Salam
  [L. Hussain]
  [A. Radi (pen); Muhammad Tuma, Hassan Kamal]
Shurta         1-0 0-0 Najaf
  [Sadoon Yosif]
Amana          1-0 1-0 Tijara
Mosil          1-2 0-2 Karkh
  [Isam Hamad, Ali Abdul Kadim]
Minaa          1-0 1-0 Kut 

Round 11 [Dec 12, 13] and 30 [Apr 30, May 1]
Talaba         3-0 0-2 Minaa
  [Hisham Ali 41, Ali Hussain 61, Haitham Kadim 79]
Khutot         5-1 1-2 Arbil 
  [wali Kareem; ?, ?]
Tijara         1-2 0-0 Salah-Al-Deen
Najaf          0-0 0-0 Amana
Nafat          2-1 2-0 Salam
  [Majeed Abdul Rida, Safaa Shakir; Muhammad Tuma]
Quwa Jawiya    2-0 3-0 Sinaa
  [Akrum Ammanueel, Sabah Ijair]
  [Sabah Ijair, A. Ammanueel, own goal]
Kut            1-1 1-2 Karkh
  [?; Saad Kais, Ali Abdul Kadim]
Mosil          0-0 0-0 Salikh 
Shabab         3-3 0-0 Samarra
Shurta         0-1 0-3 Zawraa
  [K. Sadam]
  [K. Sadam (2), A. Radi]
  [the attendance of the match in round 11, at Shabab stadium, was 60,000, 
   a record for the venue (in fact exceeding its capacity so some spectators
   were located near the grass or behind the goals]

Round 12 [Dec 19, 20] and 31 [May 7, 8]
Quwa Jawiya    1-1 2-0 Khutot 
  [Sabah Ijair; Raheem Hameed 59]
  [Hazim Yasir, Ali Izgair]
Salikh         0-0 0-1 Kut 
  [Ali Faris]
Tijara         0-1 1-0 Arbil 
Shabab         1-1 0-0 Salam
Shurta         3-0 0-0 Nafat
Karkh          3-0 3-2 Minaa
  [Ali Abdul Kadim (2), Saad Kais; A. Aldiwan, Karem Jasim]
Sinaa          0-1 0-5 Talaba
  [Kadim Jabir 6]
  [Hisham Ali, Alaa Kadim (2), Ahmad Khalaf (2)]
Mosil          1-1 0-1 Samarra
Najaf          0-0 1-2 Salah-Al-Deen
  [Basim Muhammad; Maitham Kamal, Muhammad Hanon (pen)]
Amana          1-0 0-2 Zawraa
  [Inad Abid 10]
  [A. Radi, K. Sadam]

Round 13 [Dec 26, 27] and 32 [May 14, 15]
Karkh          1-2 0-1 Talaba
  [Ali Abdul Kadim 39; Alaa Kadim 61, Ahmad Khalaf 65] 
  [Saad Kais 89]
Quwa Jawiya    1-0 1-1 Tijara
  [A. Ammanueel (pen)]
  [Basil Fadil; Hassan Hilal]
Mosil          0-0 1-3 Salam
Shurta         1-1 0-0 Shabab
Nafat          3-1 2-3 Amana
Sinaa          1-2 2-1 Khutot 
Minaa          0-0 2-1 Salikh 
Samarra        3-0 0-0 Kut 
  [Faik Abdullah, Zahid Kasim, Saman Salah-Al-Deen]
Najaf          2-0 4-0 Arbil  
  [Muhammad Ijwad 30, Ali Hashim 82]
Zawraa         0-0 4-1 Salah-Al-Deen
  [L. Hussain 15, Raid Khalil 23, A. Radi 45, 74; Muhammad Hanon 58pen]

Round 14 [Jan 2, 3] and 33 [May 21, 22]
Karkh          3-0 4-0 Salikh 
Sinaa          0-0 0-0 Tijara
Kut            0-2 0-0 Salam
Zawraa         2-1 2-0 Arbil 
  [L. Hussain, K. Sadam (pen); ?]
  [K. Sadam, A. Radi]
Nafat          0-0 3-2 Salah-Al-Deen
Khutot         1-1 0-1 Talaba
  [Raheem Hameed; Alaa Kadim]
  [Habib Jafar 2]
Minaa          3-0 0-1 Samarra
Najaf          0-2 0-0 Quwa Jawiya
  [Shakir Tahir (2)]
Mosil          1-0 1-1 Shurta
  [Muhammad Fathi]
  [Muhammad Fathi; Yonis Abid Ali (pen)]
Shabab         0-0 1-1 Amana

Round 15 [Jan 9, 10] and 34 [May 28, 29]
Salam          0-2 1-2 Talaba
  [Kadim Jabir 19, Habib Jafar 32]
  [Muhammad Tuma 1; Ali Hussain 45, Kadim Jabir 77]
Nafat          1-0 1-2 Tijara
Salikh         0-2 0-0 Amana
Shabab         1-0 1-1 Khutot 
Karkh          2-1 1-1 Salah-Al-Deen
Najaf          1-4 0-2 Zawraa
  [Abdul Ameer Naji, L. Hussain, K. Sadam (2); Ali Hashim (pen)]
  [A. Radi, K. Sadam]
Shurta         2-0 0-1 Samarra
Sinaa          1-1 0-0 Mosil
  [Haris Muhammad (pen); ?]
Minaa          1-1 3-0 Arbil 
Quwa Jawiya    3-1 0-0 Kut 
  [A. Ammanueel (2), Hasan Mula; Ali Raheem]

Round 16 [Feb 6, 7; dates exchanged with round 19] and 35 [Jun 4, 5]
Tijara         0-2 2-3 Talaba
  [Alaa Kadim, Mahdi Kadim]
Salikh         1-1 1-2 Samarra 
Karkh          0-1 2-0 Salam
  [Ali Abdul Kadim, Saad Kais]
Sinaa          1-4 1-3 Zawraa
  [Ali Hassan; K. Sadam, Naeem Sadam, A. Radi]
  [N. Sadam, K. Sadam, Abdul Ameer Naji; Khalid Obaid]
Shabab         1-2 1-0 Arbil 
Najaf          0-0 0-2 Khutot 
Minaa          2-2 0-1 Shurta
  [Ziad Tarik]
Quwa Jawiya    2-1 2-1 Nafat
  [A. Ammanueel (2); Jafar Umran] [?, Samir Kadim; Nazar Ali]
Kut            0-0 0-3 Amana
Mosil          1-1 1-0 Salah-Al-Deen

Round 17 [Jan 23, 24] and 36 [Jun 11, 12]
Salikh         0-0 0-1 Salam  
Karkh          2-0 3-2 Shurta
  [Kareem Shakir, Munthir Khalaf] 
  [Saad Kais, ?, Najah Mikhail; Yonis Adib Ali (2)]
Quwa Jawiya    0-0 1-0 Shabab
  [Muhammad Jasim]
Kut            1-2 2-0 Salah-Al-Deen
  [Jamal Khalil 10, Salah-Al-DeenMuhammad 61; Ali Raheem 44]
Mosil          1-0 3-0 Arbil 
Samarra        1-5 0-1 Talaba
  [Ahmad Sami 44; Ali Hussain 15, Habib Jafar 21, Alaa Kadim 20, 25, 55]
  [Mahdi Kadim] 
Najaf          1-1 2-1 Tijara
  [Haider Najim; ?]
Khutot         0-0 1-3 Zawraa
  [?; A. Radi (3)]
Nafat          2-0 0-0 Sinaa
Amana          0-0 0-2 Minaa

Round 18 [Jan 30, 31?] and 37 [Jun 18, 19]
Talaba         2-0 1-0 Najaf
  [Alaa Kadim, Ahmad Khalaf]
Samarra        0-1 1-1 Salam
Tijara         0-2 0-3 Zawraa
  [K. Sadam (pen), Laith Hussain]
  [A. Radi (2), K. Sadam]
Karkh          1-0 3-0 Amana
  [Saad Kais]
  [Sharar Haider, ?, Najah Mikhail]
Shabab         0-1 1-0 Sinaa
Shurta         1-0 0-2 Salikh 
  [Saad Najim 68]
  [?, Muhanad Zaidan]
Khutot         0-4 2-1 Nafat
  [Jafar Umran 7, 37, Nassir Hussain 53, Ahmad Khudair 55]
  [Khalid Ghani, Kadim Muhsin, Ahmad Khudair]
Minaa          0-0 1-0 Salah-Al-Deen
Quwa Jawiya    2-0 1-0 Mosil
  [Shakir Tahir 69, Hazim Yasir 73]
Arbil          2-2 1-2 Kut 
  [Kameran Muhammad 17, Tarik A. Raham 72; Haider Ibrahim 82, Ali Raheem 90]

Round 19 [Jan 16, 17; dates exchanged with round 16] and 38 [Jun 25]
Khutot         0-0 1-0 Tijara
Karkh          3-1 2-0 Samarra
  [Saad Kais (2), Mudhir Khalaf; Ahmad Sami]
Salam          2-1 1-0 Minaa
Nafat          0-0 1-0 Arbil 
Shabab         1-3 0-0 Salah-Al-Deen
Salikh         1-3 0-0 Talaba
  [Muhammad Karam 1; Ahmad Khalaf 15, Mahdi Kadim 60, Alaa Kadim]
Sinaa          0-1 2-4 Najaf
  [Ali Hashim 65]
Mosil          2-0 2-0 Amana
  [Muhammad Fathi 12, Haris Muhammad 61]
Kut            1-0 0-1 Shurta
  [Abbas Ilaiwi 40]
  [Yonis Abid Ali]
Quwa Jawiya    0-0 1-0 Zawraa
  [Akrum Ammanueel 8]
  [round 38 match (championship decider) played Jun 26]

Final Table:

 1.Al-Quwa Al-Jawiya (Baghdad) 38  27  9  2  56-17  63  
 2.Al-Zawraa (Baghdad)         38  27  7  4  87-24  61  
 3.Al-Karkh (Baghdad)          38  26  8  4  70-29  60  
 4.Al-Talaba (Baghdad)         38  24  7  7  66-29  55  
 5.Al-Shurta (Baghdad)         38  17 12  9  33-21  46  
 6.Al-Najaf                    38  13 14 11  33-27  40  
 7.Khutot (Baghdad)            38  11 18  9  32-31  40  
 8.Al-Nafat (Baghdad)          38  14 11 13  44-24  39  
 9.Al-Minaa (Basra)            38  12 13 13  39-42  37  
10.Amana (Baghdad)             38  10 14 14  26-34  34  
11.Mosul                       38  10 14 14  26-39  34  
12.Al-Salam (Baghdad)          38  10 13 15  28-34  33  
13.Salah-Al-Deen (Tikrit)      38   8 17 13  34-42  33  
14.Al-Shabab (Baghdad)         38   6 21 11  28-39  33  
15.Samarra                     38   9 13 16  27-57  31  
16.Al-Sinaa (Baghdad)          38   9 13 16  26-48  31  
17.Kut                         38   6 15 17  22-48  27  
 - - - - - - - - - - - - - - - - - - - - - - - - - - - 
18.Al-Tijara (Baghdad)         38   7 11 20  24-42  25  Relegation Playoff
19.Al-Salikh (Baghdad)         38   3 13 22  12-51  19  Relegation Playoff
20.Arbil                       38   6  7 25  30-71  19  Relegation Playoff

NB: total goal difference -5


Relegation Playoff: Tijara, Salikh  and Arbil  played off with Bahri (Basra)
                    for 2 places, won by Tijara and Arbil 

Promoted: Jaish, Ramadi, Diwania, Karkuk, Aldoor Al-Ahli

Topscorers:

 1.Ahmed Radi (Zawraa)          34
 2.Kareem Saddam (Zawraa)       22
 3.Saad Kais (Karkh)            20
 4.Alaa Kadim (Talaba)          17
   Akrem Amanueel (Quwa Jawiya)  17



Authors: Refel Hashim 
(refel76@hotmail.com)
and Hassanin Mubarak
(Iraqifootball@yahoo.com)

Last updated: 2 Apr 2006

(C) Copyright Refel Hashim, Hassanin Mubarak and RSSSF 2002/06
						


  USO DE MEMORIA  
4,264,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.6440
Total Execution Time  0.6460
  CADENA URL  
/super_league_iraq1992
  GET DATOS  
$_GET['/super_league_iraq1992']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0149  SELECT type FROM routes WHERE alias = 'super_league_iraq1992'
0.0298  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 = 1992 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0148  SELECT text_es as historical_text FROM leagues_text WHERE id=927
0.0150  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 = 29248 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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='1992' WHERE c.parentId=476 GROUP BY c.id ORDER BY c.order_id ASC
0.0148  SELECT type,rule FROM rules WHERE categoryId = 476 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 06:40:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 06:40:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 06:40:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 06:40:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  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 = 1992 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (29248) 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.0147  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 (29248) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0148  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (29248) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0150  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 (29248) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0153  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (29248) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0149  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 (29248) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (29248) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0146  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 (29248) 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 = 29248 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0149  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 = 29248 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0162  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=29248 AND rel.round=38
0.0156  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 = 29248 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0157  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 = 29248 AND esl.points > 0
0.0154  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` = 29248 ORDER BY creation_date DESC LIMIT 0, 10
0.0169  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` = 29248
0.0155  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 `calendars1992` 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` = 29248 AND c.`round` = 38 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 `events1992` e INNER JOIN calendars1992 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 = 38 AND e.real_date IS NOT NULL AND e.league_id = 29248 ORDER BY total DESC LIMIT 40
0.0149  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 `events1992` e INNER JOIN calendars1992 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 = 29248 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0150  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 `tables1992` 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 = 29248 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1992` 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 = 29248 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 29248 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0150  SELECT data1, data2 FROM services_tags WHERE categoryId=476
0.0150  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 476 AND l.year = 1992 ORDER BY l.group_code ASC
0.0150  SELECT group_code, extraName from `leagues` WHERE categoryId=476 AND year=1992