4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Liga Uganda 2009
2008/2009

Liga Uganda 2009

Información Histórica
						
Super League

Final Table:

 1.URA FC (Kampala)                  34 24  6  4 60-16 78  Champions
 2.Kampala City Council FC           34 24  6  4 60-21 78
 3.SC Villa (Kampala)                34 21  9  4 57-22 72
 4.Bunamwaya SC (Wakiso)             34 19  6  9 60-29 63
 5.Simba FC (Lugazi)                 34 17 11  6 35-21 62
 6.Uganda Police FC (Kampala)        34 18  6 10 58-25 60
 7.Nalubaale FC (Buikwe)             34 17  8  9 46-31 59
 8.Express SC (Kampala)              34 14 11  9 28-24 53
 9.Maji FC (Kampala)                 34 14  5 15 36-36 47
10.Victors FC (Kampala)              34 11 11 12 31-30 44  [*]
11.Kinyara Sugar Works FC (Masindi)  34 10  8 16 32-41 38
12.Boroboro Tigers FC (Lira)         34  9 11 14 22-37 38
13.Iganga Town Council FC            34  9 10 15 29-39 37
---------------------------------------------------------
14.Mbarara United FC                 34  7 14 13 22-30 35  Relegated
15.Bugerere FC                       34  5  8 21 18-60 23  Relegated
16.Youfra FC (Lira)                  34  3 10 21 14-47 19  Relegated
17.Sharing FC (Kampala)              34  3  8 23 19-78 17  Relegated
18.Kakira FC                         34  2 10 22 18-58 16  Relegated

NB: Express had 3 points deducted for causing the abandonment 
    of their match against Bunamwaya in round 5 (and had 2 goals
    credited additionally against them); this penalty was
    apparently later revoked.

[*] Victors play in Jinja

NB: URA = Uganda Revenue Authority

Round 1
[Aug 2]
Police               0-1 Victors 
  [Edris Kaaye 64]
Villa                1-2 KCC   
  [Emmanuel Okwi 27; Vincent Kayizi 34, Patrick Ssenfuka 77]
[Aug 3]
Nalubaale            awd Bunamwaya    [awarded 2-0; originally 0-1; Bunamwaya 
  [Yuda Mugalu]                        player Hakim Ssenkumba was suspended]
URA                  4-0 Kinyara
Youfra               0-2 Simba
  [Godfrey Wakaza (2)]
Mbarara              0-1 Maji
Bugerere             3-0 Boroboro
  [Franco Barabara, Ausi Kaaya Junior, David Zziwa]
Kakira               0-2 Iganga
Express              1-0 Sharing     

Round 2
[Aug 6]
Sharing              2-0 Bugerere            
[Aug 8]
Villa                1-0 Youfra  
  [Emmanuel Okwi]            
Kinyara              awd Bunamwaya    [awarded 2-0; originally 1-2; Bunamwaya 
Kakira               0-1 Police        player Hakim Ssenkumba was suspended]        
Iganga               1-2 URA                 
Boroboro             0-1 KCC   
  [Patrick Ssenfuka]              
Express              2-1 Maji                
Nalubaale            1-2 Simba               
Mbarara              1-1 Victors           

Round 3
[Aug 13]
Villa                4-1 Kakira   
  [Geoffrey Luutu 9, Emmanuel Okwi 59, 83, Chris Ntambi; Ali Okito (pen)]           
KCC                  2-0 Youfra  
  [Sam Mubiru (pen), Vincent Kayizi]            
[Aug 15]
URA                  2-1 Maji                
Mbarara              2-1 Kinyara             
Victors              1-0 Express             
Bunamwaya            1-0 Police              
Bugerere             0-1 Iganga              
Nalubaale            4-0 Boroboro            
Simba                1-1 Sharing             

Round 4
[Aug 19]
Kakira               1-1 Bugerere    
  [Henry Kabasala; Charles Kaggwa 5]        
[Aug 20]
KCC                  2-0 Iganga              
Simba                1-0 Victors             
Youfra               0-3 Nalubaale           
Express              0-0 Mbarara             
Villa                6-0 Sharing        
  [Emmanuel Okwi (3), Andrew Nkurunungi (2), Stephen Bengo]     
Maji                 3-2 Boroboro            
Kinyara              2-1 Police    
  [Hesborn Mundia, Sam Nadduli; Peter Ssenyonjo]          
[Aug 24]
URA                  0-0 Bunamwaya           

Round 5
[Aug 27]
Victors              1-1 Villa       
  [Julius Engude 60; Emmanuel Okwi (pen)]        
Sharing              1-2 Boroboro
  [Anthony Egesa 90; Robert Ojok 52, Caesar Ssepewo 56]           
[Aug 29]
Bunamwaya            awd Express       [awarded 2-0; abandoned at 0-0 in  
URA                  1-0 Police          36' due to crowd trouble] 
Kinyara              1-2 Simba               
Iganga               abd Nalubaale     [abandoned at 0-1 due to rain]  
Maji                 0-1 KCC                 
Mbarara              1-1 Kakira              
Youfra               1-0 Bugerere  
[Sep 5]        
Iganga               0-1 Nalubaale             

Round 6
[Sep 10]
Sharing              1-0 Mbarara   
  [Musa Noah]          
Victors              1-0 Youfra    
  [Idriss Kaye]          
[Sep 11]
Bunamwaya            1-1 Villa        
  [Owen Kasule 74; Steven Bengo 9]       
[Sep 12]
Police               0-2 KCC                 
Iganga               1-1 Boroboro            
Kinyara              1-1 Express             
Maji                 0-0 Nalubaale           
Bugerere             0-1 Simba               
[Sep 14]
URA                  5-2 Kakira              

Round 7
[Sep 16]
Youfra               3-1 Sharing             
[Sep 17]
KCC                  2-0 URA            
  [Jeremiah Ssebuyira 56, Brian Omwony 78]     
Police               1-0 Iganga    
  [Abraham Nega 72]          
Boroboro             0-1 Bunamwaya  
  [Denis Kizito 20]         
Nalubaale            2-1 Kinyara             
Simba                3-0 Maji         
  [Godfrey Wakaza (2), Willy Kavuma]       
Kakira               1-3 Victors  
  [Crespo Asiku; Simon Sserunkuma, Julius Engudde, Edriss Kaye]           
Bugerere             1-1 Mbarara  
  [Moses Lutwama; Simon Olivier]           
[Sep 19]
Express              2-1 Villa               

Round 8
[Sep 21]           
Boroboro             0-0 Police              
Simba                2-1 KCC       
  [Godfrey Wakaza (pen), Willy Kavuma; Brian Omwony]          
Nalubaale            0-0 Victors             
Mbarara              1-2 URA                 
Maji                 2-1 Bugerere            
Kakira               0-1 Sharing  
[Sep 22]
Bunamwaya            2-1 Youfra              
[Sep 23]
Villa                3-2 Kinyara    
  [Yusuf Juuko ?, 90, Emma Okwi 80pen; Gideon Ssekamwa 58, 74]         
Iganga               0-0 Express             

Round 9
[Sep 24]
Sharing              2-2 Victors             
[Sep 26]
URA                  0-0 Villa               
Police               2-1 Express      
  [Dan Mubiru 1, Bruno Olobo; Daniel Sserunkuma]       
[Sep 28]
Simba                2-1 Boroboro      
  [Musa Mudde, Churchill Kamba 88; Dan Egwel]      
Iganga               1-0 Kinyara       
  [Edgar Luzige 70]      
Maji                 1-1 Kakira              
  [Asad Makibwe; Ibrahim Kapengere]
Bunamwaya            3-1 KCC     
  [Yuda Mugalu (2), Caesar Okhuti; ?]            
Bugerere             0-2 Nalubaale 
  [Jonathan Abgibe (2)]          
Youfra               0-1 Mbarara   
  [Moses Tumwebaze]           

Round 10
[Oct 15]
Victors              2-0 Maji                
[Oct 17]
KCC                  0-1 Kinyara             
Villa                2-0 Mbarara             
Iganga               1-1 Sharing             
Express              2-1 Youfra              
Bugerere             0-0 Bunamwaya           
Simba                1-2 Police              
Nalubaale            2-0 Kakira              
Boroboro             1-0 URA                 

Round 11
[Oct 22]
Bunamwaya            6-1 Kakira   
  [Yudah Mugalu (2), Ceaser Okhuti 45, Owen Kasule, Robert Kimuli,
   Boban Zirintusa; Ibrahim Segere 89]           
URA                  6-0 Youfra     
  [Ismail Kigozi 4, Eric Obua 10, ?, Dan Wagaluka 45pen,
   Patrick Ochan, Tonny Mawejje]         
[Oct 23]
Sharing              0-5 KCC       
  [Robert Sentongo 20, 90, Brain Umwony 30, Vincent Kayizi,
   Zuma Atulobo]          
[Oct 24]
Iganga               1-0 Maji                
Bugerere             0-2 Police              
Mbarara              0-1 Simba               
Villa                3-0 Nalubaale           
Express              1-0 Boroboro            
Victors              1-1 Kinyara             

Round 12
[Oct 29]
URA                  5-0 Sharing   
  [Patrick Ochan 23, 47, Dan Wagaluka 25, Martin Muwanga 70, ?]          
Victors              3-1 Bugerere    
  [Julius Engude (2), Noah Ssemakula; Ausi Kaaya]        
[Oct 31]
Kakira               1-2 KCC      
  [Ibrahim Kisengere; Robert Ssentongo, Sam Mubiru 80pen]           
Police               3-0 Youfra    
  [Bruno Olobbo (3)]          
Maji                 3-1 Kinyara             
Simba                3-0 Express   
  [Ibrahim Jingo (2), Godfrey Wakaza]          
Nalubaale            0-0 Mbarara             
Boroboro             0-1 Villa     
  [Chrisestom Ntambi]          
Bunamwaya            3-0 Iganga   
  [Caesar Okhuti (3)]           

Round 13
[Nov 4]
Kakira               0-1 Express    
  [Julius Ogwang]         
KCC                  3-1 Bugerere  
  [Brian Umony 6, Robert Ssentongo 15, ?; Edirisa Makoona]          
[Nov 5]
URA                  0-0 Simba               
Maji                 0-2 Villa  
  [Emmanuel Okwi, Ali Alishe]             
Mbarara              2-2 Iganga              
Boroboro             1-0 Victors             
Kinyara              2-1 Youfra              
Nalubaale            1-0 Police   
  [Jonathan Ayigbe]           
Sharing             1-10 Bunamwaya   
  [Stephen Okumu; Caesar Okhuti (5), Denis Kizito (2), Owen Kasule,
   Arthur Ssemazi, Ronald Muganga]        

Round 14 [Nov 9]
KCC                  1-1 Victors   
  [Vincent Kayizi 3; Ayub Kizza 80]          
Police               3-1 Sharing             
Youfra               1-1 Maji                
Mbarara              0-1 Bunamwaya 
  [Caesar Okhuti]          
Kinyara              1-0 Boroboro            
Express              0-1 Nalubaale           
Bugerere             0-4 URA         
  [Martin Muwanga (2), Ismail Kigozi, Sam Mubiru]        
Kakira               0-2 Simba  
  [Henry Kalanzi, Sula Ssebuunza]             
Iganga               1-2 Villa    
  [Edgar Luzige; Geoffrey Luutu 38, Mathias Ndaula 75]           

Round 15
[Nov 12]
Youfra               1-1 Kakira              
Maji                 3-0 Sharing     
  [Kassim Kasawuli, Emma Mudde, Asadi Makibwe]        
Police               1-2 Villa   
  [Alex Ndugga 89; Emmanuel Okwi 9, Matthias Ndawula 78]            
[Nov 14]
Nalubaale            1-1 URA                 
Simba                0-2 Bunamwaya           
Iganga               0-0 Victors             
Boroboro             1-1 Mbarara             
KCC                  2-1 Express             
Kinyara              0-0 Bugerere            

Round 16
[Nov 19]
Sharing              0-2 Nalubaale        
  [Paul Kibende 28, Moses Ssemakula (og)]   
[Nov 21]
Maji                 0-2 Police     
  [Peter Ssenyonjo, Amran Mukasa]         
Villa                3-1 Bugerere    
  [Emmanuel Okwi, Godfrey Walusimbi, Franco Balabala (og);
   Ausi Kaaya 8]        
Simba                1-1 Iganga    
  [Godfrey Wakaza; Juma Gabili 88]          
Boroboro             1-0 Youfra              
Kinyara              1-1 Kakira              
Express              1-0 URA      
  [Daniel Sserunkuma 87]           
Victors              1-1 Bunamwaya           
Mbarara              0-1 KCC  
  [Brian Umony 45]               

Round 17
[Nov 26]
Sharing              0-2 Kinyara             
[Nov 27]
Bunamwaya            1-1 Maji 
Villa                1-0 Simba                 
[Nov 28]             
KCC                  3-2 Nalubaale 
[Nov 29]  
Kakira               2-2 Boroboro 
[Nov 30]
Youfra               0-0 Iganga              
Express              2-1 Bugerere            
Police               3-0 Mbarara             
Victors              1-2 URA                 

Round 18
[Jan 17]
Sharing              1-4 Police
  [?; Peter Ssenyonjo (3), Bruno Olobo]
[Jan 18]
Bugerere             0-0 Victors
Express              0-0 Kakira
Maji                 3-1 Youfra
  [Abbey Kavuma, Kasim Kasawuli, Assad Makibwe; Innocent Alimadri]
Mbarara              1-0 Nalubaale
  [Twaha Sendi 2]
Villa                0-0 URA
[Jan 19]
KCC                  2-1 Boroboro
  [Jeremiah Ssebuyira 39, Sam Mubiru 70pen; Julius Okocha 80]
Iganga               0-1 Simba
  [Godfrey Wakaza]
[Jan 20]
Bunamwaya            2-1 Kinyara
  [Ayub Kisalita 56, Owen Kasule 88pen; George Manda 10]

Round 19
[Jan 21]
URA                  1-0 Bugerere
  [Sam Mubiru 9]
[Jan 23]
Victors              2-1 Iganga
Police               1-3 Bunamwaya
Kinyara              0-1 KCC
  [Robert Ssentongo]
Youfra               0-0 Villa
Kakira               0-2 Maji
Simba                0-0 Mbarara
Nalubaale            1-1 Sharing
[Jan 24?]
Boroboro             1-0 Express

Round 20
[Feb 3]
Boroboro             0-0 Simba
[Feb 4]
Nalubaale            4-0 Bugerere
  [James Odoch, Hood Mayanja, Paul Kibande, Hamis Kiiza]
Maji                 abd Bunamwaya     [abandoned at 1-0 in 24' due to rain] 
  [Caesar Ssempijja 10]
Mbarara              0-0 Express
Kakira               0-1 URA
  [Patrick Ochan 2]
Sharing              1-2 Villa
  [Walter Simiyu 46; Stephen Bengo 73, Tony Ndolo 85]
Youfra               0-0 Police
[Feb 17]
Maji                 2-0 Bunamwaya     [replay]
  [Kasim Kasawuli 30, Assad Makibwe]
[Mar 3]
Kinyara              3-2 Victors
  [Najib Yusuf, Siraje Turyamuhebwa, Robert Lugolobi (og);
   Ismael Ssegawa, Moses Ndawula]
Iganga               0-3 KCC 
  [Brian Umony 4, 69, Tommy Okello 59]

Round 21
[Feb 7]
URA                  1-0 Boroboro
Sharing              0-1 Simba
[Feb 8]
Bugerere             0-1 KCC
  [Brian Umony 38]
Villa                3-1 Iganga
  [Augustine Nsumba, Emmanuel Okwi, Andrew Nkurunungi; Edgar Luzige 32]
Bunamwaya            0-1 Mbarara
  [Adam Igga 87]
Victors              1-0 Kakira
Nalubaale            awd Youfra        [awarded 2-0, Youfra dns]
Express              1-0 Kinyara
[Feb 9]
Police               1-1 Maji    
  [Bruno Olobo 53; Caesar Ssempijja 8]          

Round 22
[Feb 18]
Police               7-0 Bugerere 
  [Bruno Olobo (3), Peter Ssenyonjo (3), Suudi Kayembe]
[Feb 20]
Boroboro             0-0 Nalubaale
Express              1-1 Iganga
Kakira               1-2 Villa
KCC                  1-2 Maji 
Kinyara              1-0 Sharing
URA                  2-0 Mbarara
Simba                1-1 Youfra 
[Feb 21]
Bunamwaya            2-0 Victors

Round 23
[Feb 25]
Bunamwaya            3-0 Sharing
  [Caesar Okhuti 26, 46pen, Owen Kasule 58pen]
[Feb 27]
Victors              2-2 Boroboro
Bugerere             0-5 Villa
  [Andrew Nkurunungi (3), Augustine Nsumba, Crizestom Ntambi]
Youfra               1-0 Express
  [Samuel Lastge]
Nalubaale            2-0 Iganga
KCC                  2-0 Kakira 
  [Brian Umony, Sam Mubiru]
Simba                1-1 Kinyara
Maji                 0-1 URA
  [Martin Muwanga 46]
Mbarara              0-0 Police

Round 24
[Mar 18]
Bunamwaya            4-1 Boroboro
[Mar 20]
Bugerere             0-4 Maji 
Express              1-1 Police
Kakira               0-3 Nalubaale 
[Mar 23]
KCC                  1-1 Simba  
  [Brian Umony 53; Jetta Waidi 43]
URA                  4-0 Iganga
  [Tonny Mawejje 33, Rogers Wandwasi 38, Eric Obua 72,
   Martin Muwanga 86]
Victors              2-0 Mbarara
   [Obed Mayanja, Julius Engude]
[Mar 31]
Sharing              1-1 Youfra
[Apr 15]
Kinyara              0-1 Villa

Round 25
[Mar 25]
Sharing              0-0 Express
[Mar 26]
Youfra               0-0 KCC
Bunamwaya            1-2 Bugerere
  [Tony Odur 63; Moses Lutwama, Ayub Balyejusa 71]
Mbarara              1-1 Villa
  [Ezra Mujasi 37; Andrew Nkurunungi 52]
[Mar 27]
Police               1-2 URA
Victors              0-1 Nalubaale
Boroboro             1-0 Iganga
Simba                1-0 Kakira
Kinyara              1-0 Maji

Round 26
[Apr 6]
Sharing              0-3 URA
  [Henry Kisekka 8, Sam Mubiru, Alex Isabirye 87]
Boroboro             1-1 Bugerere
Police               3-0 Kakira      
[Apr 7]
Villa                1-0 Maji
Express              1-0 Simba
Iganga               0-0 Bunamwaya
Youfra               0-1 Victors      
Kinyara              1-1 Nalubaale
[Apr 13]
KCC                  1-0 Mbarara

Round 27 [Apr 10]
Villa                0-0 Boroboro
Simba                0-0 Bugerere
Kakira               0-2 Bunamwaya     
Nalubaale            1-1 Express
Iganga               1-2 Police
KCC                  5-0 Sharing 
  [Robert Ssentongo (2), Brian Umony (2), ?]
Kinyara              1-1 Mbarara
Youfra               0-2 URA      
Maji                 awd Victors       [awarded 2-0]

Round 28
[Apr 18]
URA                  2-1 Nalubaale
Maji                 0-1 Simba
[Apr 19]
Villa                1-0 Victors
  [Godfrey Sentongo]
Boroboro             1-0 Sharing
Bugerere             1-0 Kinyara
Express              2-0 Bunamwaya
  [Francis Jemba, Daniel Sserunkuma]
Iganga               awd Youfra        [awarded 2-0, Youfra showed
Kakira               1-1 Mbarara        two hours late]
[Apr 22]
KCC                  2-2 Police
  [Tommy Okello 35, Sam Mubiru (pen); Peter Senyonjo 20,
   Juma Lubega]

Round 29
[Apr 21]
Maji                 1-0 Mbarara
[Apr 22]
Bugerere             1-0 Youfra
Express              1-0 Victors
Kinyara              2-1 Iganga
[Apr 23]
Sharing              0-0 Kakira
[Apr 24]
Nalubaale            2-1 Villa
Simba                1-0 URA
Police               4-0 Boroboro
[May 9]
KCC                  2-0 Bunamwaya

Round 30
[Apr 29]
Maji                 0-3 Express
  [Francis Jemba 17, Badru Kiyega 65, Daniel Sserunkuma 88]
Mbarara              0-0 Boroboro
Bugerere             3-2 Sharing
Iganga               3-1 Kakira
Youfra               1-1 Kinyara
Victors              0-0 Simba
Police               4-0 Nalubaale 
  [Ssudi Kayemba (2), Bruno Olobo, Peter Ssenyonjo]
[May 1]
Villa                3-1 Bunamwaya
[Jun 13]
URA                  1-1 KCC

Round 31
[May 13]
Youfra               0-0 Boroboro
Iganga               3-0 Bugerere
Bunamwaya            3-1 Simba
  [Tony Odur, Mike Mutyaba, Kizito Luwaga; ?]
Kakira               1-0 Kinyara
Nalubaale            3-0 Maji
Mbarara              3-0 Sharing
Victors              0-2 Police
[May 14]
URA                  2-0 Express
  [Jonnie Karangwa 45, Rogers Nandwa 81]
[Jun 10]
KCC                  2-1 Villa                 
  [Anthony Bongole 58, Brian Umony 60; Emmanuel Okwi 85]

Round 32
[May 19]
Police               2-0 Kinyara
  [Peter Ssenyonjo (2)]
[May 20]
Boroboro             1-0 Kakira
  [Sam Kolokolo]
Iganga               2-0 Mbarara
  [Antoney Musana, Edgar Luzige]
Simba                0-0 Villa
URA                  1-0 Victors
  [Martin Muwanga 70]
[May 21]
Youfra               0-1 Bunamwaya
[May 22]
Bugerere             0-1 Express
Sharing              0-1 Maji
Nalubaale            0-4 KCC

Round 33
[May 25]
Kinyara              1-2 URA
Villa                1-1 Express
Bunamwaya            4-1 Nalubaale
[May 27]
Boroboro             0-1 Maji
Police               3-0 Simba
  [Peter Ssenyonjo (2), Bruno Olobo]
Sharing              1-1 Iganga
[May 31]
Bugerere             0-0 Kakira
Mbarara              awd Youfra        [awarded 2-0; abandoned at 1-0,
[Jun 6]                                 Youfra walked off]
Victors              0-1 KCC
  [Brian Umony]

Round 34
[May 19]
Express              0-0 KCC
[May 27]
Kakira               1-0 Youfra
Mbarara              awd Bugerere      [awarded 2-0, Bugerere dns]
[May 31]
Boroboro             1-0 Kinyara
Maji                 0-1 Iganga
Simba                2-0 Nalubaale
Victors              2-0 Sharing
[Jun 10]
Bunamwaya            0-1 URA
  [Patrick Ochan 37]
[Jun 13]
Villa                1-0 Police

Final Table:

 1.URA FC (Kampala)                  34 24  6  4 60-16 78  Champions
 2.Kampala City Council FC           34 24  6  4 60-21 78
 3.SC Villa (Kampala)                34 21  9  4 57-22 72
 4.Bunamwaya SC (Wakiso)             34 19  6  9 60-29 63
 5.Simba FC (Lugazi)                 34 17 11  6 35-21 62
 6.Uganda Police FC (Kampala)        34 18  6 10 58-25 60
 7.Nalubaale FC (Buikwe)             34 17  8  9 46-31 59
 8.Express SC (Kampala)              34 14 11  9 28-24 53
 9.Maji FC (Kampala)                 34 14  5 15 36-36 47
10.Victors FC (Kampala)              34 11 11 12 31-30 44  [*]
11.Kinyara Sugar Works FC (Masindi)  34 10  8 16 32-41 38
12.Boroboro Tigers FC (Lira)         34  9 11 14 22-37 38
13.Iganga Town Council FC            34  9 10 15 29-39 37
---------------------------------------------------------
14.Mbarara United FC                 34  7 14 13 22-30 35  Relegated
15.Bugerere FC                       34  5  8 21 18-60 23  Relegated
16.Youfra FC (Lira)                  34  3 10 21 14-47 19  Relegated
17.Sharing FC (Kampala)              34  3  8 23 19-78 17  Relegated
18.Kakira FC                         34  2 10 22 18-58 16  Relegated

NB: Express had 3 points deducted for causing the abandonment 
    of their match against Bunamwaya in round 5 (and had 2 goals
    credited additionally against them); this penalty was
    apparently later revoked.

[*] Victors play in Jinja

NB: URA = Uganda Revenue Authority


In July 2009, Nalubaale FC were bought by Proline Academy and a 
new team called Proline FC was to compete in 2009/10; however, 
they were later refused entry to the league for failure to 
fulfil financial obligations



Authors: Hans Schöggl and Ian King

Last updated: 5 Feb 2015

(C) Copyright Hans Schöggl, Ian King and RSSSF 2008/15
						


  USO DE MEMORIA  
4,330,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4607
Total Execution Time  0.4627
  CADENA URL  
/super_league_uganda2009
  GET DATOS  
$_GET['/super_league_uganda2009']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0104  SELECT type FROM routes WHERE alias = 'super_league_uganda2009'
0.0212  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'super_league_uganda' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0112  SELECT text_es as historical_text FROM leagues_text WHERE id=1028
0.0106  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 = 29349 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  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='2009' WHERE c.parentId=481 GROUP BY c.id ORDER BY c.order_id ASC
0.0104  SELECT type,rule FROM rules WHERE categoryId = 481 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0104  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-18 22:08:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0104  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-18 22:08:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-18 22:08:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-18 22:08:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'super_league_uganda' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0105  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (29349) 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.0105  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 (29349) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0105  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (29349) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0105  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 (29349) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0105  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (29349) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0105  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 (29349) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (29349) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0105  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 (29349) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0105  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 = 29349 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0104  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 = 29349 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0107  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=29349 AND rel.round=34
0.0106  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 = 29349 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0106  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 = 29349 AND esl.points > 0
0.0106  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-19" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29349 ORDER BY creation_date DESC LIMIT 0, 10
0.0110  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-19" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29349
0.0106  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 `calendars2009` 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` = 29349 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0104  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 `events2009` e INNER JOIN calendars2009 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 = 29349 ORDER BY total DESC LIMIT 40
0.0108  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 `events2009` e INNER JOIN calendars2009 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 = 29349 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0106  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 `tables2009` 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 = 29349 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` 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 = 29349 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106  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-19 00:00:00' AND c.`shedule` < '2024-04-23 23:59:59' AND l.id = 29349 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0106  SELECT data1, data2 FROM services_tags WHERE categoryId=481
0.0106  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 481 AND l.year = 2009 ORDER BY l.group_code ASC
0.0106  SELECT group_code, extraName from `leagues` WHERE categoryId=481 AND year=2009