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

Liga Irán 1999

Información Histórica 
						
Azadegan League

Official Final Table:

 1.Perspolis Tehran         30 19  8  3  56-21  65  Champions   *  
 2.Esteghlal Tehran         30 14 11  5  50-28  53
 3.Sepahan Isfahan          30 13 14  3  38-19  53
 4.Saipa Tehran             30 13 10  7  43-33  49
 5.Paas Tehran              30  9 15  6  30-25  42              *
 6.Chooka Talesh            30 11  7 12  33-48  40
 7.Foolad Ahvaz             30  9 11 10  31-37  38               
 8.AbooMoslem Mashhad       30 10  7 13  37-37  37              *
 9.Sanat-Naft Abadan        30  8 12 10  22-39  36               
10.Fajr-Sepasi Shiraz       30  8 10 12  27-31  34               
11.TeraktorSazi Tabriz      30  7 13 10  30-35  34              *
12.Zob-Ahan Isfahan         30  9  6 15  23-32  33              *
--------------------------------------------------
13.Malavan Bandar-Anzali    30  7 11 12  21-26  32  Relegated   *
14.Shahrdari Tabriz         30  5 16  9  29-33  31  Relegated
15.Poly-Akril Isfahan       30  5 12 13  24-36  27  Relegated
16.Bank-Melli Tehran        30  4 15 11  27-41  27  Relegated

[* indicates discrepancy with results]

[5 goals more scored than conceded, 1 more win than loss; probably
 both due to AbooMoslem's record]

Table (based on known results):

 1.Pirouzi Tehran           30 19  8  3  55-21  65  Champions
 2.Esteghlal Tehran         30 14 11  5  50-28  53
 3.Sepahan Isfahan          30 13 14  3  38-19  53
 4.Saipa Tehran             30 13 10  7  43-33  49
 5.Paas Tehran              30  9 15  6  29-27  42
 6.Chooka Talesh            30 11  7 12  33-48  40
 7.Foolad Ahvaz             30  9 11 10  31-37  38
 8.AbooMoslem Mashhad       30 10  7 13  36-37  37
 9.Sanat-Naft Abadan        30  8 12 10  22-39  36
10.TeraktorSazi Tabriz      30  7 13 10  29-33  34
11.Fajr-Sepasi Shiraz       30  8 10 12  27-31  34
12.Zob-Ahan Isfahan         30  9  6 15  26-32  33
--------------------------------------------------
13.Malavan Bandar-Anzali    30  7 11 12  22-26  32  Relegated
14.Shahrdari Tabriz         30  5 16  9  29-33  31  Relegated
15.Poly-Akril Isfahan       30  5 12 13  24-36  27  Relegated
16.Bank-Melli Tehran        30  4 15 11  27-41  27  Relegated

Round 1 [Sep 11]
Bank-Melli   1-2 Fajr-Sepasi 
Saipa        3-1 Zob-Ahan    
Paas         3-2 AbooMoslem  
Malavan      2-0 Sanat-Naft  
Shahrdari    1-0 Chooka      
Sepahan      3-1 TeraktorSazi
Perspolis    3-0 Poly-Akril  
Foolad       0-3 Esteghlal    [Dec 27]

Round 2 [Sep 18]
Sepahan      1-0 Zob-Ahan     
Chooka       3-1 Perspolis   
Esteghlal    1-1 Sanat-Naft  
Fajr-Sepasi  2-1 Shahrdari   
TeraktorSazi 1-1 Foolad       
Saipa        1-1 Bank-Melli  
Poly-Akril   1-0 AbooMoslem  
Paas         1-0 Malavan      [Nov 3]

Round 3 [Sep 25]
AbooMoslem   1-0 Malavan     
Sanat-Naft   2-2 TeraktorSazi 
Shahrdari    1-3 Saipa        
Zob-Ahan     2-3 Foolad       
Esteghlal    1-1 Paas        
Bank-Melli   0-0 Sepahan     
Perspolis    0-0 Fajr-Sepasi  
Poly-Akril   0-0 Chooka           

Round 4 [Oct 2]
AbooMoslem   3-0 Chooka      
Perspolis    1-0 Saipa       
Sanat-Naft   2-1 Zob-Ahan     
Shahrdari    1-1 Sepahan          
Foolad       2-0 Bank-Melli  
Malavan      1-2 Esteghlal   
Fajr-Sepasi  0-0 Poly-Akril   
TeraktorSazi 1-2 Paas          

Round 5 [Oct 9]
Chooka       2-1 Fajr-Sepasi  
Saipa        1-0 Poly-Akril   
Foolad       0-0 Shahrdari   
Sepahan      1-0 Perspolis   
Malavan      0-0 TeraktorSazi
Bank-Melli   0-0 Sanat-Naft  
Esteghlal    1-2 AbooMoslem   [Nov 3]    
Paas         0-0 Zob-Ahan     [Dec 1]

Round 6 [Oct 16]
Zob-Ahan     1-1 Malavan     
Saipa        4-1 Chooka      
Shahrdari    0-0 Sanat-Naft  
Bank-Melli   0-0 Paas        
Sepahan      1-0 Poly-Akril  
AbooMoslem   3-1 Fajr-Sepasi 
Perspolis    1-0 Foolad      
TeraktorSazi 1-4 Esteghlal    

Round 7 [Oct 23]
TeraktorSazi 2-1 AbooMoslem   
Chooka       1-0 Sepahan     
Sanat-Naft   1-4 Perspolis    
Poly-Akril   3-0 Foolad      
Malavan      0-1 Bank-Melli  
Fajr-Sepasi  2-1 Saipa       
Shahrdari    2-1 Paas         [Dec 27]
Esteghlal    0-1 Zob-Ahan     [Jan 1]

Round 8 [Oct 30]
Zob-Ahan     0-2 TeraktorSazi 
Sanat-Naft   1-0 Poly-Akril   
Sepahan      1-0 Fajr-Sepasi 
Saipa        2-1 AbooMoslem   
Malavan      1-0 Shahrdari    
Foolad       4-1 Chooka      
Paas         0-4 Perspolis    [Jan 3]
Esteghlal    3-1 Bank-Melli   [Jan 5]

Round 9 [Nov 6]
Chooka       0-0 Sanat-Naft  
Bank-Melli   1-4 TeraktorSazi 
Sepahan      1-1 Saipa           
AbooMoslem   2-1 Zob-Ahan     
Perspolis    1-0 Malavan     
Shahrdari    0-0 Esteghlal   
Paas         2-1 Poly-Akril       
Fajr-Sepasi  1-0 Foolad  

Round 10 [Nov 13]
Sanat-Naft   0-0 Fajr-Sepasi 
TeraktorSazi 2-2 Shahrdari    
Saipa        1-0 Foolad       
Zob-Ahan     0-1 Bank-Melli    
Chooka       2-1 Paas        
Esteghlal    0-1 Perspolis    
Poly-Akril   0-1 Malavan     
Sepahan      0-0 AbooMoslem       

Round 11 [Nov 20]
Bank-Melli   0-0 AbooMoslem
Malavan      3-1 Chooka
Sanat-Naft   2-0 Saipa
Fajr-Sepasi  0-0 Paas
Foolad       0-3 Sepahan    
Zob-Ahan     0-0 Shahrdari
Esteghlal    4-2 Poly-Akril   [Jan 13]
TeraktorSazi 2-4 Perspolis    [Jan 13]

Round 12 [Nov 27]
Poly-Akril   1-1 TeraktorSazi
Sepahan      1-1 Sanat-Naft 
Foolad       1-0 AbooMoslem
Shahrdari    1-1 Bank-Melli
Malavan      0-0 Fajr-Sepasi
Paas         1-3 Saipa
Perspolis    2-0 Zob-Ahan     [Jan 19]
Chooka       1-1 Esteghlal    [Jan 19]

Round 13 [Dec 4]
TeraktorSazi 0-0 Chooka
Sanat-Naft   0-3 Foolad
AbooMoslem   4-3 Shahrdari
Zob-Ahan     1-2 Poly-Akril
Saipa        1-0 Malavan      [Jan 13]
Sepahan      0-0 Paas         [Jan 19]
Bank-Melli   1-2 Perspolis    [Mar 4]
Fajr-Sepasi  0-1 Esteghlal    [Mar 10]

Round 14 [Dec 11]
Paas         1-1 Foolad
AbooMoslem   6-2 Sanat-Naft
Bank-Melli   3-3 Poly-Akril
Chooka       1-0 Zob-Ahan
Fajr-Sepasi  0-0 TeraktorSazi
Malavan      0-0 Sepahan
Shahrdari    0-0 Perspolis    [Apr 4]
Saipa        0-0 Esteghlal    [Apr 7]

Round 15 [Dec 18]
Poly-Akril   2-2 Shahrdari
Foolad       4-1 Malavan
Chooka       2-1 Bank-Melli
Zob-Ahan     1-0 Fajr-Sepasi
TeraktorSazi 1-0 Saipa        [Jan 19]
Perspolis    1-0 AbooMoslem   [Apr 12]
Esteghlal    1-1 Sepahan      [Apr 13] 
Sanat-Naft   1-0 Paas         [May 4]

Round 16 [Jan 24]
Fajr-Sepasi  2-1 Bank-Melli   [Jan 22]
Sanat-Naft   0-0 Malavan      [Jan 22]
Poly-Akril   0-2 Perspolis    [Jan 23]
Zob-Ahan     2-1 Saipa       
AbooMoslem   0-2 Paas  
Chooka       2-1 Shahrdari
TeraktorSazi 0-2 Sepahan
Esteghlal    3-0 Foolad

Round 17 [Jan 30]
Zob-Ahan     0-3 Sepahan
Malavan      1-2 Paas
Foolad       1-0 TeraktorSazi
Esteghlal    1-0 Sanat-Naft
Perspolis    4-0 Chooka
Bank-Melli   0-3 Saipa     
AbooMoslem   1-0 Poly-Akril
Shahrdari    1-1 Fajr-Sepasi

Round 18 [Feb 6]
Fajr-Sepasi  2-3 Pirouzi
Paas         1-1 Esteghlal  
Saipa        1-1 Shahrdari
TeraktorSazi 0-0 Sanat-Naft   [originally given 0-1; either finished 0-0 
Malavan      1-1 AbooMoslem    or awarded as such]
Chooka       4-2 Poly-Akril
Sepahan      1-1 Bank-Melli
Foolad       0-2 Zob-Ahan     [Feb 7]

Round 19 [Feb 14]
Chooka       1-0 AbooMoslem 
Bank-Melli   1-1 Foolad  
Esteghlal    1-1 Malavan
Zob-Ahan     2-0 Sanat-Naft  
Poly-Akril   0-0 Fajr-Sepasi  [Apr 13]
Paas         0-0 TeraktorSazi [Apr 13]
Saipa        1-1 Perspolis    [May 3]  
Sepahan      5-3 Shahrdari    [May 13]  

Round 20 [Feb 22]
Poly-Akril   0-1 Saipa               
Shahrdari    1-1 Foolad       [Feb 20]
Sanat-Naft   2-1 Bank-Melli   [Feb 20]
Fajr-Sepasi  3-1 Chooka       [May 4]   
TeraktorSazi 1-0 Malavan  
Zob-Ahan     0-2 Paas 
Perspolis    3-1 Sepahan   
AbooMoslem   1-2 Esteghlal    [May 4]  

Round 21 [Feb 25]
Chooka       2-2 Saipa    
Malavan      1-0 Zob-Ahan  
Fajr-Sepasi  1-2 AbooMoslem  
Poly-Akril   0-0 Sepahan  
Paas         1-1 Bank-Melli   
Foolad       0-3 Perspolis    [Mar 2]
Sanat-Naft   0-3 Shahrdari    [Mar 2]
Esteghlal    3-2 TeraktorSazi [May 13]

Round 22 [Mar 8]
Perspolis    4-1 Sanat-Naft
Sepahan      2-0 Chooka
Zob-Ahan     1-1 Esteghlal
AbooMoslem   2-1 TeraktorSazi
Foolad       1-1 Poly-Akril 
Saipa        1-5 Fajr-Sepasi
Bank-Melli   0-0 Malavan
Shahrdari    0-0 Paas

Round 23 [Mar 13]
TeraktorSazi 1-1 Zob-Ahan 
Poly-Akril   2-0 Sanat-Naft
Chooka       1-1 Foolad
AbooMoslem   1-1 Saipa
Perspolis    1-2 Paas         [Mar 11]
Shahrdari    2-0 Malavan
Bank-Melli   0-2 Esteghlal
Fajr-Sepasi  0-2 Sepahan

Round 24 [Mar 21]
Malavan      1-1 Perspolis    [Mar 18] 
Esteghlal    1-0 Shahrdari
Foolad       0-0 Fajr-Sepasi  [originally 4-2, replayed May 13]
Saipa        2-0 Sepahan
Sanat-Naft   1-0 Chooka
Zob-Ahan     2-0 AbooMoslem
Poly-Akril   0-0 Paas
TeraktorSazi 0-0 Bank-Melli

Round 25 [Apr 9]
Perspolis    1-1 Esteghlal
Paas         1-1 Chooka
Shahrdari    0-1 TeraktorSazi
AbooMoslem   1-1 Sepahan
Fajr-Sepasi  1-2 Sanat-Naft
Malavan      0-0 Poly-Akril
Foolad       3-2 Saipa
Bank-Melli   0-3 Zob-Ahan

Round 26 [Apr 18]
Perspolis    0-0 TeraktorSazi
Saipa        0-0 Sanat-Naft
Shahrdari    1-0 Zob-Ahan
Poly-Akril   1-0 Esteghlal
Paas         3-1 Fajr-Sepasi
Sepahan      1-1 Foolad
Chooka       2-1 Malavan
AbooMoslem   0-3 Bank-Melli

Round 27 [Apr 23]
Fajr-Sepasi  0-2 Malavan
TeraktorSazi 3-1 Poly-Akril
Saipa        0-0 Paas
Sanat-Naft   0-3 Sepahan
AbooMoslem   0-0 Foolad
Zob-Ahan     1-1 Pirouzi
Bank-Melli   1-1 Shahrdari
Esteghlal    6-1 Chooka       [May 21]

Round 28 [Apr 29]
Perspolis    1-1 Bank-Melli
Paas         1-1 Sepahan
Malavan      2-2 Saipa
Chooka       1-0 TeraktorSazi
Foolad       1-1 Sanat-Naft
Shahrdari    0-0 AbooMoslem 
Poly-Akril   0-2 Zob-Ahan
Esteghlal    2-1 Fajr-Sepasi  [May 17]

Round 29 [May 7]
Esteghlal    3-4 Saipa
Poly-Akril   2-2 Bank-Melli
Perspolis    3-1 Shahrdari
Foolad       2-1 Paas
TeraktorSazi 0-0 Fajr-Sepasi
Sepahan      1-0 Malavan
Sanat-Naft   2-1 AbooMoslem
Zob-Ahan     1-0 Chooka 

Round 30 [May 21]
AbooMoslem   1-2 Perspolis    [May 22]
Shahrdari    0-0 Poly-Akril
Fajr-Sepasi  1-0 Zob-Ahan
Malavan      2-0 Foolad
Paas         0-0 Sanat-Naft
Saipa        1-0 TeraktorSazi
Bank-Melli   3-2 Chooka       [May 24]
Sepahan      1-1 Esteghlal    [May 24]

Table (based on above results):

 1.Perspolis Tehran         30 19  8  3  55-21  65  Champions
 2.Esteghlal Tehran         30 14 11  5  50-28  53
 3.Sepahan Isfahan          30 13 14  3  38-19  53
 4.Saipa Tehran             30 13 10  7  43-33  49
 5.Paas Tehran              30  9 15  6  29-27  42
 6.Chooka Talesh            30 11  7 12  33-48  40
 7.Foolad Ahvaz             30  9 11 10  31-37  38
 8.AbooMoslem Mashhad       30 10  7 13  36-37  37
 9.Sanat-Naft Abadan        30  8 12 10  22-39  36
10.TeraktorSazi Tabriz      30  7 13 10  29-33  34
11.Fajr-Sepasi Shiraz       30  8 10 12  27-31  34
12.Zob-Ahan Isfahan         30  9  6 15  26-32  33
--------------------------------------------------
13.Malavan Bandar-Anzali    30  7 11 12  22-26  32  Relegated
14.Shahrdari Tabriz         30  5 16  9  29-33  31  Relegated
15.Poly-Akril Isfahan       30  5 12 13  24-36  27  Relegated
16.Bank-Melli Tehran        30  4 15 11  27-41  27  Relegated

Official Final Table:

 1.Perspolis Tehran         30 19  8  3  56-21  65  Champions   *  
 2.Esteghlal Tehran         30 14 11  5  50-28  53
 3.Sepahan Isfahan          30 13 14  3  38-19  53
 4.Saipa Tehran             30 13 10  7  43-33  49
 5.Paas Tehran              30  9 15  6  30-25  42              *
 6.Chooka Talesh            30 11  7 12  33-48  40
 7.Foolad Ahvaz             30  9 11 10  31-37  38               
 8.AbooMoslem Mashhad       30 10  7 13  37-37  37              *
 9.Sanat-Naft Abadan        30  8 12 10  22-39  36               
10.Fajr-Sepasi Shiraz       30  8 10 12  27-31  34               
11.TeraktorSazi Tabriz      30  7 13 10  30-35  34              *
12.Zob-Ahan Isfahan         30  9  6 15  23-32  33              *
--------------------------------------------------
13.Malavan Bandar-Anzali    30  7 11 12  21-26  32  Relegated   *
14.Shahrdari Tabriz         30  5 16  9  29-33  31  Relegated
15.Poly-Akril Isfahan       30  5 12 13  24-36  27  Relegated
16.Bank-Melli Tehran        30  4 15 11  27-41  27  Relegated

[* indicates discrepancy with results]


Author: Roberto Lahsen

Last updated: 16 Oct 2014

(C) Copyright Roberto Lahsen 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,294,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6193
Total Execution Time  0.6212
  CADENA URL  
/iran1999
  GET DATOS  
$_GET['/iran1999']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0145  SELECT type FROM routes WHERE alias = 'iran1999'
0.0294  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 = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0152  SELECT text_es as historical_text FROM leagues_text WHERE id=898
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 = 29221 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155  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='1999' WHERE c.parentId=57 GROUP BY c.id ORDER BY c.order_id ASC
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 03:02:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 03:02:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 03:02:14' 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 03:02:14' 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 = 'iran' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (29221) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29221) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (29221) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29221) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (29221) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29221) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (29221) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29221) 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 = 29221 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0147  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 = 29221 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0152  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=29221 AND rel.round=30
0.0155  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 29221 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0158  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 = 29221 AND esl.points > 0
0.0150  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29221 ORDER BY creation_date DESC LIMIT 0, 10
0.0151  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` = 29221
0.0147  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 `calendars1999` 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` = 29221 AND c.`round` = 30 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 `events1999` e INNER JOIN calendars1999 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 = 29221 ORDER BY total DESC LIMIT 40
0.0151  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 `events1999` e INNER JOIN calendars1999 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 = 29221 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` 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 = 29221 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` 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 = 29221 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 29221 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0148  SELECT data1, data2 FROM services_tags WHERE categoryId=57
0.0148  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 57 AND l.year = 1999 ORDER BY l.group_code ASC
0.0148  SELECT group_code, extraName from `leagues` WHERE categoryId=57 AND year=1999