4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2000
Temporada Siguiente »
Publicidad 600x120.gif
Liga Irán 2000
1999/2000

Liga Irán 2000

Información Histórica 
						

Azadegan League

Final Table:

 1.Perspolis Tehran         26 15  9  2  45-23  54  Champions
 2.Esteghlal Tehran         26 12 11  3  32-16  47
 3.Fajr-Sepasi Shiraz       26 11 11  4  37-18  44
 4.Sepahan Isfahan          26 11  9  6  28-19  42
 5.Zob-Ahan Isfahan         26 11  6  9  35-29  39
 6.TeraktorSazi Tabriz      26 10  8  8  30-26  38
 7.Paas Tehran              26  9  8  9  35-31  35
 8.Bahman Karadj            26  8 10  8  24-26  34
 9.Saipa Tehran             26  6 13  7  24-21  31
10.Foolad Ahvaz             26  7  8 11  30-33  29
--------------------------------------------------
11.AbooMoslem Mashhad       26  7  7 12  32-39  28  Relegated
12.Sanat-Naft Abadan        26  6  9 11  29-35  27  Relegated
13.Chooka Talesh            26  4  9 13  22-45  21  Relegated
14.IrSotter Noshahr         26  3  6 17  22-64  15  Relegated

Round 1 [Aug 13]
Perspolis    3-1 Bahman  
Paas         3-1 Foolad  
Fajr-Sepasi  2-0 AbooMoslem  
Sanat-Naft   1-1 Sepahan
TeraktorSazi 1-3 Esteghlal  
Chooka       3-1 IrSotter  
Zob-Ahan     0-0 Saipa

Round 2 [Aug 20]
AbooMoslem   2-3 Paas  
TeraktorSazi 2-0 Fajr-Sepasi  
IrSotter     1-5 Perspolis
Esteghlal    1-1 Saipa
Sanat-Naft   3-0 Chooka  
Foolad       2-0 Bahman  
Zob-Ahan     0-3 Sepahan

Round 3 
[Aug 26]
Paas         1-1 Bahman  
Fajr-Sepasi  2-0 Saipa  
Perspolis    2-1 Sanat-Naft  
Chooka       1-0 Zob-Ahan 
IrSotter     3-1 Foolad  
AbooMoslem   2-1 TeraktorSazi
[Oct 14]
Sepahan      1-4 Esteghlal 

Round 4 
[Sep 10]
Fajr-Sepasi  0-0 Sepahan  
Foolad       2-0 Sanat-Naft  
Saipa        2-3 AbooMoslem
Bahman       3-1 IrSotter 
Zob-Ahan     1-1 Perspolis
TeraktorSazi 1-0 Paas  
[Nov 2]
Esteghlal    2-0 Chooka

Round 5
[Sep 17]
Zob-Ahan     4-0 Foolad 
Paas         7-0 IrSotter  
Chooka       0-1 Fajr-Sepasi  
Sepahan      3-0 AbooMoslem 
Sanat-Naft   2-2 Bahman  
TeraktorSazi 0-0 Saipa  
[Sep 24]
Perspolis    0-0 Esteghlal

Round 6
[Sep 23]
Saipa        1-2 Paas  
Bahman       1-0 Zob-Ahan  
AbooMoslem   1-1 Chooka  
Sepahan      1-0 TeraktorSazi
IrSotter     2-3 Sanat-Naft  
[Sep 28]
Foolad       2-0 Esteghlal  
Perspolis    3-1 Fajr-Sepasi

Round 7
[Oct 1]
Sanat-Naft   0-0 Paas  
Chooka       1-1 TeraktorSazi  
Zob-Ahan     3-1 IrSotter  
Saipa        1-2 Sepahan
[Oct 2]
AbooMoslem   1-2 Perspolis 
[Oct 3]
Fajr-Sepasi  3-0 Foolad 
Bahman       0-3 Esteghlal

Round 8 [Oct 7]
Paas         0-2 Sepahan  
Esteghlal    2-0 IrSotter  
TeraktorSazi 1-1 Perspolis
Fajr-Sepasi  1-1 Bahman
Chooka       1-1 Saipa  
Zob-Ahan     1-2 Sanat-Naft  
Foolad       0-0 AbooMoslem

Round 9
[Oct 15]
AbooMoslem   2-0 Bahman  
TeraktorSazi 2-1 Foolad  
IrSotter     2-2 Fajr-Sepasi
Saipa        1-2 Perspolis
Paas         2-0 Zob-Ahan
[Oct 19]
Sepahan      2-0 Chooka 
Sanat-Naft   0-1 Esteghlal 
 
Round 10 
[Oct 23]
Saipa        1-0 Foolad  
AbooMoslem   1-1 IrSotter  
Bahman       0-0 TeraktorSazi  
Chooka       0-1 Paas
Fajr-Sepasi  2-1 Sanat-Naft  
Esteghlal    2-1 Zob-Ahan  
[Nov 20]
Sepahan      0-0 Perspolis 
  
Round 11 [Oct 29]
Saipa        0-1 Bahman  
Perspolis    3-0 Chooka  
Paas         1-1 Esteghlal  
Zob-Ahan     1-1 Fajr-Sepasi
Foolad       2-1 Sepahan  
Sanat-Naft   2-2 AbooMoslem  
TeraktorSazi 4-1 IrSotter

Round 12 
[Nov 5]
AbooMoslem   0-1 Zob-Ahan  
Sepahan      1-0 Bahman  
Sanat-Naft   1-2 TeraktorSazi 
IrSotter     0-0 Saipa
Chooka       0-0 Foolad  
Fajr-Sepasi  awd Esteghlal     [abd at 2-1 in 87' due to crowd riots; awarded 3-0]
[Nov 25]
Perspolis    3-1 Paas   

Round 13 [Nov 14]
Zob-Ahan     1-0 TeraktorSazi  
IrSotter     1-0 Sepahan  
Saipa        1-0 Sanat-Naft 
Bahman       1-1 Chooka
Foolad       1-2 Perspolis
Paas         0-1 Fajr-Sepasi  
Esteghlal    1-0 AbooMoslem

Round 14
[Jan 14]
Foolad       1-1 Paas  
AbooMoslem   1-0 Fajr-Sepasi  
Sepahan      1-0 Sanat-Naft  
IrSotter     1-1 Chooka
Saipa        1-1 Zob-Ahan
[Jan 24]
Esteghlal    1-1 TeraktorSazi
[Jan 27]
Bahman       1-1 Perspolis

Round 15 
[Jan 20]
Fajr-Sepasi  1-1 TeraktorSazi  
Chooka       3-2 Sanat-Naft 
Bahman       1-0 Foolad  
Sepahan      0-0 Zob-Ahan  
Paas         2-2 AbooMoslem  
[Feb 13]
Esteghlal    1-0 Saipa
[May 2]
Perspolis    2-0 IrSotter
  [Behnam Seraj 12, 41 - att: 10,000]  

Round 16 
[Jan 28]
Saipa        1-1 Fajr-Sepasi  
Zob-Ahan     4-2 Chooka  
Foolad       5-1 IrSotter  
Esteghlal    2-1 Sepahan  
TeraktorSazi 3-1 AbooMoslem  
Bahman       2-1 Paas  
[May 16]
Sanat-Naft   3-0 Perspolis 
  [Omid Sharifi-Nasab 34, Mohannad-Mehdi Al-Nadavi 80, 85pen - att: 22,000]

Round 17 
[Feb 4]
Paas         1-0 TeraktorSazi  
Sepahan      0-0 Fajr-Sepasi 
Sanat-Naft   0-0 Foolad  
AbooMoslem   0-1 Saipa  
IrSotter     0-1 Bahman  
[Feb 8]
Chooka       0-0 Esteghlal
[May 24]
Perspolis    0-2 Zob-Ahan 
  [Majid Nowroozi 81, Rahman Rezayi 85] 

Round 18 
[Feb 9]
Saipa        2-0 TeraktorSazi 
[Feb 10]
Bahman       3-0 Sanat-Naft  
IrSotter     2-1 Paas 
Foolad       1-2 Zob-Ahan  
AbooMoslem   2-0 Sepahan  
Fajr-Sepasi  6-0 Chooka  
[Feb 27]
Esteghlal    0-2 Piroozi
  [Mehdi Hashemi-Nasab 8, Payan Rafat 81 - att: 80,000]

Round 19
[Feb 19]
Paas         0-0 Saipa
  [att: 10,000]
[Feb 20]
Chooka       4-3 AbooMoslem   
  [Davud Nazar-Mohammadi 6, Rahmat Feyzi-Moghadam 30, Reza Mohammadiyani 50, 
   Asghar Rasulzadeh 90 - Vahid Khodaverdi 24, Hamidreza Ebrahimi 82, 
   Hadi Abdollahzadeh 87 - att: 4,000]
TeraktorSazi 1-1 Sepahan
  [Abduljalil Golcheshmeh 53 - Davud Dehghani 23 - att: 8,000]
Sanat-Naft   2-1 IrSotter 
  [Mohannad-Mehdi Al-Naddavi 17, Hamidreza Khedmatkari 38 - Bahman Tahmasebi 68
   - att: 6,000]
Zob-Ahan     2-1 Bahman
  [Reza Sahebi [pen] 6, Saeed Ramezani 33 - Alimirza Ostovari [pen] 85 - att: 5,000]
[Feb 23]
Esteghlal    0-0 Foolad
  [att: 10,000]
Fajr-Sepasi  1-1 Perspolis
  [Ali Samereh 11 - Behnam Seraj 89 - att: 25,000]

Round 20
[Feb 25]
Paas         2-2 Sanat-Naft 
  [Leys Naseri 45, Javad Nekoonam 57; Mohannad-Mehdi Al-Nadavi 17, 22 - att: 2,000]
TeraktorSazi 2-0 Chooka
  [Davud Rostami 50, Babak Zolrahmi 51 - att: 12,000]
IrSotter     0-2 Zob-Ahan
  [Reza Sahebi 14, Saeed Ramezani 44 - att: 6,000]
Sepahan      0-0 Saipa
[Feb 27]
Foolad       0-0 Fajr-Sepasi
  [att: 1,000]
[Mar 3]
Esteghlal    0-0 Bahman
  [att: 15,000]
[Mar 4]
Perspolis    1-1 AbooMoslem
  [Mehdi Hashemi-Nasab (pen) 89; Hadi Abdollahzadeh 90 - att: 10,000]

Round 21
[Mar 3]
Saipa        1-0 Chooka
  [Mahdi Amirabadi 60 - att: 10,000]
Sepahan      2-2 Paas   
  [Leon Stepanian 60, Hooshang Loveynian 65; Hosseyn Khatibi 6, 
   Aref Mohammadvand 73 - att: 8,000]
Sanat-Naft   1-1 Zob-Ahan 
  [Abbas Hashempour 23; Reza Sahebi 86]
[Mar 8]
IrSotter     1-1 Esteghlal
  [Omidreza Ramezani 71; Arastoo Mohammadi 74]
Bahman       0-0 Fajr-Sepasi  
  [att: 100]
[Mar 9]
Perspolis    5-2 TeraktorSazi
  [Edmond Bezik 36, 47, Ali Karimi 63, Behnam Seraj 77, Mehdi Hashemi-Nasab 
   (pen) 80; Assadollah Tavakkoli 8, Davud Rostami 45 - att: 20,000]
AbooMoslem   1-2 Foolad
  [Hadi Abdollahzadeh 67; Yahya Golmahammadi 12, Bakhshali Rahimi (og) 69]

Round 22
[Mar 10]
Zob-Ahan     0-1 Paas   
  [Edmond Akhtar 23 - att: 10,000]
Chooka       0-0 Sepahan 
[Mar 12]
Esteghlal    0-0 Sanat-Naft 
  [att: 15,000]
[Mar 13]
Bahman       2-1 AbooMoslem 
  [Amin Rasti 80, Tofigh Aameri 91; Hadi Abdollahzadeh 21 - att: 100]
Foolad       1-2 TeraktorSazi
  [Naim Sa'davi (pen) 53; Alireza Pejman 69, Abdullah Riahi 88 - att 2,000]
Fajr-Sepasi  4-0 IrSotter 
  [Amir Vaziri 18, 85, Reza Rezayi-Kamal 52, Davud Seyd-Abbasi 77 - att: 4,000]
Perspolis    0-0 Saipa
  [att: 15,000]

Round 23 
[Apr 28]
Zob-Ahan     1-4 Esteghlal 
  [Davud Mahabadi 63 - Ali Latifi 26, Ali Akbarpoor 56, Dariyoush Yazdani 70, 
   Mohammad Navazi 79 - att: 20,000]
Paas         2-1 Chooka
  [Vahid Mazaheri [pen.] 15, Leys Naseri 89 - Saber Taghizadeh 50 - att: 5,000]
Perspolis    1-0 Sepahan 
  [Behnam Seraj 31 - att: 20,000]
Sanat Naft   1-0 Fajr-Sepasi
  [Mohannad-Mehadi Al-Nadavi 43 - att: 7,000]
Foolad       1-1 Saipa 
  [Yahya Golmohammadi 6 - Mehdi Amirabadi 32 - att: 3,000]
IrSotter     0-2 AbooMoslem 
  [Hadi Abdollahzadeh 1 (7 sec), Rahim Ebrahimpoor 79 - att: 1,500]
TeraktorSazi 1-0 Bahman
  [Abduljalil Golcheshmeh 60 - att: 10,000]

Round 24
[May 5]
Saipa        1-1 Bahman
  [Mohammad Momeni 42; Reza Jabbari 30 - att: 5,000]
Esteghlal    3-0 Paas
  [Ali Latifi 14, Behzad Dadashzadeh 28, Mahmood Fekri 55 - att: 40,000]
Sepahan      2-1 Foolad
  [Majid Basirat (pen) 21, Mahmood Karimi 44; Naim Sa'davi (pen) 27- att: 7,000] 
AbooMoslem   3-1 Sanat Naft
  [Ramin Mohtashami 30, 45, Hamid Ebrahimi (pen) 59; Mohannad-Mehdi Al-Nadavi 55] 
[May 6]
Fajr-Sepasi  3-2 Zob-Ahan
  [Bahram Esmaili 28, Ali Samereh 54, Amir Vaziri (pen) 70; Soheyl Karami 60,
   Reza Ostovari (pen) 71 - att: 5,000] 
[May 7]
Chooka       1-2 Perspolis 
  [Saber Taghizadeh 74; Mehdi Hashemi-Nasab (pen) 44, Esmail Helali 76 - att: 10,000] 
IrSotter     0-0 TeraktorSazi 
  [att: 1,000]

Round 25
[May 11]
Esteghlal    0-0 Fajr-Sepasi 
  [att: 20,000]
Bahman       0-1 Sepahan
  [Leon Stepanian 75]
[May 12]
Zob-Ahan     4-1 AbooMoslem   
  [Soheyl Karami 4, Reza Ostovari 25, 36, 65; Hamidreza Ebrahimi 87pen]
TeraktorSazi 2-0 Sanat Naft
  [Assadollah Tavakkoli 74, Abdullah Riahi 90]
Foolad       4-1 Chooka
  [Omid Zahedi 39, Amir Khalife-Asl 55, Kazem Jenami 80, Yahya Golmohammadi 87;
   Rahmat Faizi-Moghaddam 84pen]
Paas         0-1 Perspolis 
  [Behnam Seraj 46; att: 40,000]
Saipa        6-1 IrSotter
  [Behnam Abolghasempoor 1, 16, 50, Farhad Koochakzadeh 3, Yadollah Akbari 66, 
   Mohsen Rasouli 87; Amir Mahmoudi 44]

Round 26 [May 21]
Fajr-Sepasi  2-1 Paas
  [Mahmood Khorramzi 25, Ali Samereh 39 - Hosseyn Khatibi 14; att: 5000]
Piroozi      2-2 Foolad
  [Ali Karimi 18, 77pen - Rashid Hoveyzeh 44, Naim Sa'davi 48; att: 10,000]
AbooMoslem   0-0 Esteghlal
  [att: 10,000]
Chooka       1-1 Bahman
  [Saber Taghizadeh 87pen - Farzad Majidi 30; att: 1,000]
TeraktorSazi 0-1 Zob-Ahan
  [Reza Sahebi 83pen]
Sepahan      3-1 IrSotter
  [Amin Mousavi 3, 36, 48 - Bahram Sama'ei 50; att: 5,000]
Sanat-Naft   1-1 Saipa
  [Mohannad-Mehdi Al-Nadavi 6 - Mojtaba Taghavi 70; att: 18,000]

Final Table:

 1.Perspolis Tehran         26 15  9  2  45-23  54  Champions
 2.Esteghlal Tehran         26 12 11  3  32-16  47
 3.Fajr-Sepasi Shiraz       26 11 11  4  37-18  44
 4.Sepahan Isfahan          26 11  9  6  28-19  42
 5.Zob-Ahan Isfahan         26 11  6  9  35-29  39
 6.TeraktorSazi Tabriz      26 10  8  8  30-26  38
 7.Paas Tehran              26  9  8  9  35-31  35
 8.Bahman Karadj            26  8 10  8  24-26  34
 9.Saipa Tehran             26  6 13  7  24-21  31
10.Foolad Ahvaz             26  7  8 11  30-33  29
--------------------------------------------------
11.AbooMoslem Mashhad       26  7  7 12  32-39  28  Relegated
12.Sanat-Naft Abadan        26  6  9 11  29-35  27  Relegated
13.Chooka Talesh            26  4  9 13  22-45  21  Relegated
14.IrSotter Noshahr         26  3  6 17  22-64  15  Relegated

Champions (involved in at least 1 match) with Perspolis:
GK: Davud Fanayi, Ahmadreza Abedzadeh
DF: Mehdi Hashemi-Nasab, Behrooz Rahbarifar, Nader Mohammad-Khani, Afshin Peyrovani,
    Ali Ansarian, Mohammad Barzegar, Reza Shahroodi
MF: Esmail Halali, Hosseyn Abdi, Hamid Estili, Hamed Kavianpoor, Ali Karimi, 
    Hadi Mahdavikia, Alireza Emamifar, Mehdi Tartar
FW: Behnam Seraj, Edmond Bezik, Payan Rafat, Ali Baghmisheh, Koorosh Barmak 
Manager: Ali Parvin


Topscorers:

15 Mohannad-Mehdi Al-Nadavi (Sanat-Naft)

12 Hamidreza Ebrahimi (AbooMoslem)

11 Behnam Seraj (Perspolis)

10 Hadi Abdollahzadeh (AbooMoslem)
   Mehdi Hashemi-Nasab (Perspolis)
   Reza Sahebi (Zob-Ahan)
   Ali Samereh (Fajr-Sepasi)
   Bahman Tahmasebi (IrSotter) [at Esteghlal since Mar 5, 2000]
   Omid Zahedi (Foolad)

 



Authors: Roberto Lahsen,
Milad Niqui
and Sina Sepehri

Last updated: 16 Oct 2014

(C) Copyright Roberto Lahsen, Milad Niqui,
Sina Sepehri and RSSSF 1999/2014

INFORMACIÓN

El Irán Pro League (IPL) (Persa: Actualmente conocido como el Copa del Golfo Pérsico es un profesional fútbol liga de la competencia para los clubes situados en el nivel más alto de la sistema de liga de fútbol de Irán.

La liga sistema se asemeja al sistema que se utiliza en Inglaterra en la actualidad. La Liga Premier es el nivel superior de una amplia estructura piramidal, por encima de la Liga Azadegan (O primera división), el 2 ª división, La 3 ª División y las ligas menores locales.

  USO DE MEMORIA  
4,305,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1026
Total Execution Time  0.1045
  CADENA URL  
/iran2000
  GET DATOS  
$_GET['/iran2000']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0018  SELECT type FROM routes WHERE alias = 'iran2000'
0.0046  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'iran' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2000 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=57 AND type_rel = 3
0.0027  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 57 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  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 (1311329,1284366,1235391,1217995,1213703) ORDER BY n.cover_points DESC, update_date DESC
0.0023  SELECT text_es as historical_text FROM leagues_text WHERE id=907
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 = 29228 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='2000' WHERE c.parentId=57 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-20 00:57:58' 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-20 00:57:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-20 00:57:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-20 00:57:58' 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 = 'iran' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2000 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 events2000 e WHERE e.league_id IN (29228) 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 (29228) 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 events2000 e WHERE e.league_id IN (29228) 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 (29228) 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 events2000 e WHERE e.league_id IN (29228) 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 (29228) 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 events2000 e WHERE e.league_id IN (29228) 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 (29228) 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 = 29228 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 = 29228 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0022  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=29228 AND rel.round=255
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 = 29228 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 = 29228 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-21" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29228 ORDER BY creation_date DESC LIMIT 0, 10
0.0023  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-21" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29228
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 `calendars2000` 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` = 29228 AND c.`round` = 255 ORDER BY shedule ASC LIMIT 200
0.0018  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2000` e INNER JOIN calendars2000 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 = 255 AND e.real_date IS NOT NULL AND e.league_id = 29228 ORDER BY total DESC LIMIT 40
0.0020  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 `events2000` e INNER JOIN calendars2000 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 = 29228 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0021  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 `tables2000` 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 = 29228 AND t.round = 253 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2000` 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 = 29228 AND t.round = 255 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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-20 00:00:00' AND c.`shedule` < '2024-04-24 23:59:59' AND l.id = 29228 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=57
0.0021  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 57 AND l.year = 2000 ORDER BY l.group_code ASC
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=57 AND year=2000