4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Premier League Nigeria 1999
1998/1999

Premier League Nigeria 1999

Información Histórica
						

Final Table:

 1.Iwuanyanwu Nationale (Owerri)  34 16  9  9  36-22  57  Championship Playoff
 2.Wikki Tourists (Bauchi)        34 18  2 14  39-29  56  Championship Playoff
 3.Plateau United (Jos)           34 16  6 12  35-35  54  Championship Playoff
 4.Lobi Stars FC (Makurdi)        34 16  4 14  37-31  52  Championship Playoff
 - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.Enugu Rangers                  34 13 10 11  30-25  49
 6.Jasper United (Onitsha)        34 15  4 15  31-31  49
 7.Julius Berger (Lagos)          34 13  9 12  40-33  48  [46 pts?]
 8.Kwara United (Ilorin)          34 14  5 15  31-27  47
 9.Kwara Stars FC (Ilorin)        34 13  8 13  26-27  47
10.Enyimba (Aba)                  34 13  8 13  38-40  47
11.Gombe United (Bauchi)          34 13  8 13  33-36  47
12.Katsina United                 34 12 10 12  32-37  46
13.Bendel Insurance (Benin City)  34 12  9 13  31-34  45 
14.Gabros International           34 13  6 15  29-34  45
--------------------------------------------------------
15.Eagle Cement (Port Harcourt)   34 13  5 16  35-30  44  Relegated
16.El-Kanemi Warriors (Maiduguri) 34 12 18 14  24-35  44  Relegated
17.Shooting Stars (Ibadan)        34 12  7 15  28-37  43  Relegated [*]
18.Kano Pillars                   34  9  6 19  22-36  33  Relegated

[*] first time defending champions were relegated in 27-year history of
    National League (Stationery Stores went also down in 1993 as
    defending champions but because of off-the-pitch events)

Known Results:

Round 1 [Jan 24]
Wikki Tourists     2-1 Julius Berger
Lobi Stars         1-0 Kano Pillars       [inferred]
Eagle Cement       0-1 Shooting Stars     [inferred, played later]
Kwara United       1-0 Nationale          [inferred]
Rangers            1-0 Plateau United     [inferred]
Jasper United      0-0 Katsina United     [inferred]
Enyimba            0-0 Gabros             [inferred]
El-Kanemi          0-0 Insurance          [inferred]
Gombe              1-0 Kwara Stars        [inferred]        

Round 2 [Jan 29]
Julius Berger      1-1 Jasper United     
Shooting Stars     1-0 El-Kanemi         
Plateau United     2-1 Gombe      
Nationale          2-2 Eagle Cement    
Kano Pillars       1-1 Rangers             
Katsina United     2-0 Kwara United       [inferred]
Insurance          1-1 Lobi Stars         [inferred]
Gabros             1-0 Wikki Tourists     [inferred]
Kwara Stars        1-1 Enyimba            [inferred]
                  
Round 3 [Jan 31]
Kwara United       2-0 Jasper United  
Rangers            1-0 Insurance        
El-Kanemi          1-0 Nationale       
Eagle Cement       1-1 Katsina United     [inferred]
Gabros             0-0 Julius Berger      [inferred]
Gombe              1-0 Kano Pillars       [inferred]
Enyimba            0-1 Plateau United     [inferred]
Wikki              2-0 Kwara Stars        [inferred]
Lobi Stars         2-0 Shooting Stars     [played later]  
  
Round 4 [Feb 5]
Shooting Stars     2-2 Rangers    
Nationale          1-0 Lobi Stars     
Julius Berger      2-1 Kwara United     
Kwara Stars        2-0 Gabros      
Jasper United      1-2 Eagle Cement   
Insurance          1-0 Gombe              [inferred]
Kano Pillars       1-0 Enyimba            [inferred]
Katsina United     0-0 El-Kanemi          [inferred]
Plateau United     2-0 Wikki              [inferred]

Round 5 [Feb 8]
Eagle Cement       0-1 Kwara United   
Gabros             0-1 Plateau United    
Rangers            1-1 Nationale 
Enyimba            1-0 Insurance    
El-Kanemi          1-0 Jasper United   
Kwara Stars        1-0 Julius Berger     
Lobi Stars         3-1 Katsina United   
Gombe              1-0 Shooting Stars     
Wikki              1-0 Kano Pillars          

[GD different from table: Gombe 4-3 (3-3), Katsina 4-4 (4-5), Julius 4-5 (4-4),
                          Gabros 1-3 (2-3)]

Round 6 [Feb 10]
Shooting Stars     awd Enyimba            [awarded 0-3]
Jasper United      3-0 Lobi Stars         [inferred]
Plateau United     2-1 Kwara Stars        [inferred]
Nationale          1-0 Gombe              [inferred]
Julius Berger      0-0 Eagle Cement       [inferred]
Insurance          2-0 Wikki              [inferred]
Kwara United       2-0 El-Kanemi          [inferred]
Kano Pillars       2-0 Gabros             [inferred]
Katsina United     1-0 Rangers            [played later] 

Round 7 [Feb 15]
Wikki              2-0 Shooting Stars      
Lobi Stars         2-1 Kwara United    
Kwara Stars        2-1 Kano Pillars  
Gabros             1-0 Insurance     
El-Kanemi          1-0 Eagle Cement    
Rangers            1-1 Jasper United
Enyimba            1-1 Nationale   
Gombe              0-0 Katsina    
Plateau United     1-1 Julius Berger      [played later, inferred]

Round 8 [Feb 22]
Nationale          3-0 Wikki Tourists         
Julius Berger      2-1 El-Kanemi     
Katsina United     1-0 Enyimba         
Kwara United       1-0 Rangers  
Jasper United      1-0 Gombe      
Eagle Cement       1-0 Lobi Stars  
Insurance          1-0 Kwara Stars   
Kano Pillars       0-1 Plateau United   
Shooting Stars     1-0 Gabros           

Round 9 [Feb 28/Mar 1?]
Rangers            0-0 Eagle Cement      
Gombe              3-1 Kwara United          
Gabros             1-1 Nationale  
Enyimba            0-1 Jasper United   
Kano Pillars       3-1 Julius Berger       
Plateau United     1-0 Insurance     
Wikki Tourists     2-0 Katsina United  
Lobi Stars         1-0 El-Kanemi        
Kwara Stars        2-0 Shooting Stars      

Table given:

Plateau        22 9 7 1 1 11  4 +7   
Lobi Stars     16 9 5 1 3 10  8 +2
Kwara Utd      15 9 5 0 4 10  9 +1
Wikki          15 9 5 0 4  9  9  0
Nationale      13 9 3 4 2 10  7 +3
Kwara Stars    13 9 4 1 4  9  8 +1
Gombe          13 9 4 1 4  6  6  0    
Katsina Utd.   13 9 3 4 2  6  7 -1 
Jasper Utd.    12 9 3 3 3  8  7 +1   
Rangers        11 9 2 5 2  7  7  0    
Insurance      11 9 3 2 4  5  5  0    
El-Kanemi      11 9 3 2 4  4  6 -2   
Kano Pillars   10 9 3 1 5  8  8  0
Julius Berger  10 9 2 4 3  8  9 -1  
Eagle Cement   10 9 2 4 3  6  7 -1
Shoot. Stars   10 9 3 1 5  5 12 -7
Enyimba         9 9 2 3 4  7  7  0
Gabros          9 9 2 3 4  4  7 -3

Round 10 [Mar 3]
Katsina United      -  Gabros  
Jasper United       -  Wikki Tourists  
Kwara United        -  Enyimba
Eagle Cement        -  Gombe
El-Kanemi           -  Rangers 
Insurance           -  Kano Pillars 
Shooting Stars     bt  Plateau United     
Nationale           -  Kwara Stars  
Julius Berger      1-1 Lobi Stars          [inferred]

Round 11 [Mar 6]
Plateau United      -  Nationale 
Insurance          0-1 Julius Berger 
Rangers             -  Lobi Stars
Gombe               -  El-Kanemi
Enyimba             -  Eagle Cement
Wikki Tourists      -  Kwara United      
Kwara Stars         -  Katsina United  
Kano Pillars        -  Shooting Stars 
Gabros              -  Jasper United            

Round 12 [Mar 10]
Julius Berger      1-1 Rangers 
Kwara United       3-0 Gabros      
Nationale          1-0 Kano Pillars      
Shooting Stars      -  Insurance         
Katsina United      -  Plateau United
Jasper United       -  Kwara Stars   
Eagle Cement        -  Wikki Tourists 
Lobi Stars          -  Gombe  
El-Kanemi           -  Enyimba  

Round 13 [Mar 13]
Plateau United     1-0 Jasper United       
Shooting Stars     0-0 Julius Berger 
Insurance          0-0 Nationale       
Wikki Tourists      -  El-Kanemi
Gabros              -  Eagle Cement
Kwara Stars         -  Kwara United
Enyimba             -  Lobi Stars
Gombe               -  Rangers
Kano Pillars        -  Katsina United

Round 14 [Mar 17]
Nationale          3-0 Shooting Stars   
Rangers            3-2 Enyimba           
Kwara United       2-0 Plateau United     
Eagle Cement       1-0 Kwara Stars         
Jasper United      1-0 Kano Pillars  
Katsina United     2-2 Insurance      
Lobi Stars         0-0 Wikki Tourists      
El-Kanemi          1-1 Gabros    
[Aug]
Gombe              abd Julius Berger       [abd at 1-1]
Gombe              1-2 Julius Berger

Round 15 [Mar 20]
Nationale          2-0 Julius Berger             
Plateau United     1-0 Eagle Cement
Insurance          2-1 Jasper United    
Kwara Stars        2-1 El-Kanemi       
Gabros             1-0 Lobi Stars        
Wikki Tourists     2-0 Rangers 
Shooting Stars     1-1 Katsina United
Enyimba            2-0 Gombe           
Kano Pillars        -  Kwara United

Top of Table:

Plateau     32 15 10 2 3 16  7 +9
Nationale   24 15  6 6 3 16  9 +7
Jasper Utd. 24 15  7 3 5 14 10 +4
Kwara Utd   22 13  7 1 5 15 10 +5
Wikki       22 13  7 1 5 12 11 +1
Lobi Stars  21 15  6 3 6 14 13 +1 
Enyimba     20 15  5 5 5 17 14 +3

Round 16 [Mar 24,25]
Julius Berger      4-1 Enyimba         
El-Kanemi          2-0 Plateau United    
Rangers            1-0 Gabros            
Gombe              1-0 Wikki Tourists            
Jasper United      1-0 Shooting Stars
Katsina United     1-0 Nationale         
Kwara United       0-2 Insurance           [inferred]  
Lobi Stars         1-3 Kwara Stars         [inferred]
Eagle Cement        -  Kano Pillars

Round 17 [Mar 27]
Nationale          1-0 Jasper United        
Plateau United     0-1 Lobi Stars        
Julius Berger      2-0 Katsina United          
Kwara Stars        1-1 Rangers         
Kano Pillars        -  El-Kanemi           
Gabros              -  Gombe
Insurance           -  Eagle Cement                     
Enyimba            ppd Wikki Tourists
Shooting Stars     ppd Kwara United

Round 18 [May 1,2]
Katsina United     1-1 Julius Berger   
Eagle Cement       3-0 Insurance         
El-Kanemi          ppd Kano Pillars     
Rangers            0-0 Kwara Stars       
Gombe              1-0 Gabros   
Jasper United      0-0 Nationale    
Lobi Stars         1-0 Plateau United      [inferred]
Wikki              ppd Enyimba
Kwara United       0-0 Shooting Stars

Round 19 [May 8,9]
Nationale          3-0 Kwara United        
Gabros             3-3 Enyimba         
Insurance          3-2 El-Kanemi      
Kano Pillars       1-1 Lobi Stars            
Katsina United     1-0 Jasper United   
Kwara Stars        1-0 Gombe      
Plateau United     0-0 Rangers             [inferred]
Julius Berger      ppd Wikki   
Shooting Stars     1-0 Eagle Cement 

Round 20 [May 15,16]
Eagle Cement       0-1 Nationale           [inferred]
Gombe               -  Plateau United        
Rangers             -  Kano Pillars
Lobi Stars         2-0 Insurance           [inferred]
Jasper United       -  Julius Berger      
El-Kanemi           -  Shooting Stars         
Kwara United        -  Katsina United 
Wikki               -  Gabros   
Enyimba             -  Kwara Stars 

Round 21
Katsina United      -  Eagle Cement
Nationale          1-0 El-Kanemi           [inferred]
Insurance           -  Rangers      
Kano Pillars       0-0 Gombe    
Plateau United      -  Enyimba
Kwara Stars         -  Wikki           
Julius Berger       -  Gabros
Jasper United       -  Kwara United       
Shooting Stars     1-0 Lobi Stars

Round 22 [May 29,30]
Rangers            2-0 Shooting Stars      [played later]
Lobi Stars         2-0 Nationale  
Kwara United        -  Julius Berger     
Gabros              -  Kwara Stars
Eagle Cement        -  Jasper United
Gombe               -  Insurance
Enyimba             -  Kano Pillars  
El-Kanemi           -  Katsina United   
Wikki               -  Plateau United 

Round 23 [Jun 9]
Kwara United       1-0 Eagle Cement      
Plateau United     0-0 Gabros     
Nationale          2-0 Rangers        
Insurance          1-0 Enyimba    
Jasper United      2-0 El-Kanemi    
Julius Berger      1-0 Kwara Stars   
Katsina United      -  Lobi Stars 
Shooting Stars      -  Gombe
Kano Pillars        -  Wikki

Round 24 
Enyimba            2-1 Shooting Stars      
Lobi Stars         3-1 Jasper United   
Kwara Stars        3-1 Plateau United     
Gombe              3-2 Nationale    
Eagle Cement       2-1 Julius Berger       
Wikki              3-1 Insurance                
El-Kanemi          1-1 Kwara United   
Gabros             ppd Kano Pillars             
Rangers            awd Katsina United      [awarded 3-0]

Round 25 [Jun 19,20]
Julius Berger      5-0 Plateau United  
Nationale           -  Enyimba
Jasper United      1-0 Rangers          
Kwara United        -  Lobi Stars
Shooting Stars      -  Wikki
Kano Pillars        -  Kwara Stars
Insurance           -  Gabros
Eagle Cement        -  El-Kanemi
Katsina United      -  Gombe

Round 26 [Jun 26,27]
Gombe               -  Jasper United           
Rangers             -  Kwara United
Lobi Stars          -  Eagle Cement
Plateau United      -  Kano Pillars
Kwara Stars        1-1 Insurance       
Wikki Tourists     1-0 Nationale       
El-Kanemi           -  Julius Berger
Enyimba             -  Katsina United
Gabros              -  Shooting Stars

Round 27 [Jul 3,4]
El-Kanemi           -  Lobi Stars   
Eagle Cement       0-0 Rangers       
Kwara United       0-0 Gombe         
Katsina United      -  Wikki   
Nationale          1-0 Gabros          
Insurance           -  Plateau United 
Julius Berger      2-0 Kano Pillars       
Jasper United       -  Enyimba  
Shooting Stars      -  Kwara Stars  

Round 28 [Jul 10,11]
Kwara Stars        1-1 Nationale         
Plateau United     3-1 Shooting Stars     
Gombe              3-0 Eagle Cement       
Kano Pillars       1-1 Insurance        
Gabros             3-0 Katsina United     
Enyimba            1-0 Kwara United         
Rangers            3-0 El-Kanemi     
Lobi Stars         2-1 Julius Berger      
[Jul 28]
Wikki Tourists      -  Jasper United     

Table [Jul 14]:
Nationale      47 28 13  8  7 30 17 +13 
Plateau        47 28 14  5  9 27 27   0   
Wikki          44 25 14  2  9 24 18  +6       
Lobi Stars     43 27 13  4 10 29 24  +5   
Jasper Utd.    43 27 13  4 10 25 20  +5     
Kwara Utd      41 28 12  5 11 24 21  +3   
Rangers        40 28 10 10  8 26 20  +6      
Julius Berger  39 28 10  9  9 31 25  +6       
Gombe          39 28 11  6 10 27 25  +2     
Insurance      39 28 11  6 11 26 29  -3       
El-Kanemi      36 28 10  6 12 26 32  -6     
Eagle Cement   35 28 10  5 13 29 26  +3      
Kwara Stars    34 26  9  7 10 20 21  -1     
Enyimba        34 28  9  7 12 29 32  -3     
Gabros         33 28  9  6 13 20 27  -7     
Katsina Utd.   30 26  7  9 10 21 30  -9     
Shoot. Stars   29 26  8  5 13 19 30 -11  
Kano Pillars   28 27  7  7 13 19 28  -9     

Round 29 [Jul 17]
Lobi Stars          -  Rangers
El-Kanemi           -  Gombe
Eagle Cement        -  Enyimba
Kwara United       3-0 Wikki Tourists     [inferred]
Katsina United      -  Kwara Stars
Nationale          3-2 Plateau United    
Shooting Stars      -  Kano Pillars 
Julius Berger      3-2 Insurance           
Jasper United       -  Gabros         

Round 30 [Jul 24]
Kano Pillars       1-0 Nationale          [Aug 4]
Insurance          2-2 Shooting Stars      
Plateau United     awd Katsina United     [awarded 3-0]
Kwara Stars         -  Jasper United
Wikki Tourists      -  Eagle Cement 
Rangers             -  Julius Berger       
Gombe               -  Lobi Stars
Gabros              -  Kwara United
Enyimba             -  El-Kamemi    

Round 31 [Jul 31]
Jasper United       -  Plateau United  
Julius Berger      1-0 Shooting Stars  
Nationale          1-1 Insurance   
El-Kanemi           -  Wikki Tourists  
Eagle Cement        -  Gabros     
Kwara United        -  Kwara Stars   
Lobi Stars          -  Enyimba    
Rangers             -  Gombe    
Katsina United      -  Kano Pillars   

Round 32
Shooting Stars      -  Nationale 
Julius Berger       -  Gombe
Enyimba             -  Rangers   
Plateau United      -  Kwara United 
Kwara Stars         -  Eagle Cement
Kano Pillars        -  Jasper United  
Insurance           -  Katsina United 
Wikki Tourists      -  Lobi Stars
Gabros              -  El-Kanemi  

Round 33
Julius Berger       -  Nationale
Eagle Cement        -  Plateau United 
Jasper United       -  Insurance
El-Kanemi           -  Kwara Stars  
Lobi Stars          -  Gabros
Rangers             -  Wikki Tourists   
Katsina United      -  Shooting Stars
Gombe               -  Enyimba
Kwara United        -  Kano Pillars   

Round 34
Enyimba             -  Julius Berger
Plateau United      -  El-Kanemi  
Gabros              -  Rangers 
Wikki Tourists      -  Gombe
Shooting Stars      -  Jasper United
Nationale           -  Katsina United
Insurance           -  Kwara United
Kwara Stars         -  Lobi Stars
Kano Pillars        -  Eagle Cement

Final Table:

 1.Iwuanyanwu Nationale (Owerri)  34 16  9  9  36-22  57  Championship Playoff
 2.Wikki Tourists (Bauchi)        34 18  2 14  39-29  56  Championship Playoff
 3.Plateau United (Jos)           34 16  6 12  35-35  54  Championship Playoff
 4.Lobi Stars FC (Makurdi)        34 16  4 14  37-31  52  Championship Playoff
 - - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.Enugu Rangers                  34 13 10 11  30-25  49
 6.Jasper United (Onitsha)        34 15  4 15  31-31  49
 7.Julius Berger (Lagos)          34 13  9 12  40-33  48  [46 pts?]
 8.Kwara United (Ilorin)          34 14  5 15  31-27  47
 9.Kwara Stars FC (Ilorin)        34 13  8 13  26-27  47
10.Enyimba (Aba)                  34 13  8 13  38-40  47
11.Gombe United (Bauchi)          34 13  8 13  33-36  47
12.Katsina United                 34 12 10 12  32-37  46
13.Bendel Insurance (Benin City)  34 12  9 13  31-34  45 
14.Gabros International           34 13  6 15  29-34  45
--------------------------------------------------------
15.Eagle Cement (Port Harcourt)   34 13  5 16  35-30  44  Relegated
16.El-Kanemi Warriors (Maiduguri) 34 12 18 14  24-35  44  Relegated
17.Shooting Stars (Ibadan)        34 12  7 15  28-37  43  Relegated [*]
18.Kano Pillars                   34  9  6 19  22-36  33  Relegated

[*] first time defending champions were relegated in 27-year history of
    National League (Stationery Stores went also down in 1993 as
    defending champions but because of off-the-pitch events)


Championship Playoff

Round 1 [Sep 2]
Lobi Stars         0-0 Plateau U.
Iwuanyanwu         1-1 Wikki Tourists    

Round 2
Lobi Stars         3-0 Wikki Tourists
Iwuanyanwu         1-0 Plateau U.

Round 3 
Lobi Stars         1-1 Iwuanyanwu
Plateau U.         3-1 Wikki Tourists      [3-2?]

Final Table:

 1.Lobi Stars FC (Makurdi)         3  1  2  0   4- 1   5  Champions
 2.Iwuanyanwu Nationale (Owerri)   3  1  2  0   3- 2   5 
 3.Plateau United (Jos)            3  1  1  1   3- 2   4  
 4.Wikki Tourists (Bauchi)         3  0  1  2   2- 7   1

Lobi Stars win the title as newly-promoted team!

Promoted: Jigawa Golden Stars from Division Two A
          Udoji United (Awka) from Division Two B
            [2nd Mobil Pegasus (Eket); other clubs NEPA, Nigerdock (both Lagos)]

Second level champions: Udoji United (beating Jigawa in playoff)



Authors: Eric Boesenberg,
Karel Stokkermans,
and Hans Schöggl

Last updated: 7 Jun 2013

(C) Copyright Eric Boesenberg, Karel Stokkermans,
Hans Schöggl and RSSSF 1999/2013
						


  USO DE MEMORIA  
4,336,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.1034
Total Execution Time  0.1069
  CADENA URL  
/premier_league_nigeria1999
  GET DATOS  
$_GET['/premier_league_nigeria1999']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0018  SELECT type FROM routes WHERE alias = 'premier_league_nigeria1999'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_nigeria' 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.0023  SELECT text_es as historical_text FROM leagues_text WHERE id=533
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 = 28847 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='1999' WHERE c.parentId=490 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 490 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-16 09:55:44' 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=2 AND last_update > '2024-04-16 09:55:44' 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=4 AND last_update > '2024-04-16 09:55:44' 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-16 09:55:44' 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 = 'premier_league_nigeria' 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.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (28847) 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.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 (28847) 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 events1999 e WHERE e.league_id IN (28847) 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 (28847) 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 events1999 e WHERE e.league_id IN (28847) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0020  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 (28847) 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 events1999 e WHERE e.league_id IN (28847) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0021  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 (28847) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0023  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 = 28847 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0020  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 = 28847 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0019  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 490 GROUP BY l.categoryId
0.0018  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=490 GROUP BY l.year ORDER BY l.year DESC
0.0024  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=28847 AND rel.round=34
0.0022  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 = 28847 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0023  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 = 28847 AND esl.points > 0
0.0024  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-17" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28847 ORDER BY creation_date DESC LIMIT 0, 10
0.0035  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-17" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28847
0.0024  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` = 28847 AND c.`round` = 34 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 `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 = 34 AND e.real_date IS NOT NULL AND e.league_id = 28847 ORDER BY total DESC LIMIT 40
0.0030  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 = 28847 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0035  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 = 28847 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 28847 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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-16 00:00:00' AND c.`shedule` < '2024-04-20 23:59:59' AND l.id = 28847 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0035  SELECT data1, data2 FROM services_tags WHERE categoryId=490
0.0035  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 490 AND l.year = 1999 ORDER BY l.group_code ASC
0.0035  SELECT group_code, extraName from `leagues` WHERE categoryId=490 AND year=1999