Publicidad 600x120.gif
Liga Uganda 2011
2010/2011

Liga Uganda 2011

Información Histórica
						 
Final Table:

 1.URA FC (Kampala)                         26 18  5  3 41-15 59  [*3]  Champions
 2.Kampala City Council FC                  26 14  6  6 26-14 48
 3.Bunamwaya SC (Wakiso)                    26 14  5  7 27-18 47
 4.Simba FC (Bombo)                         26 12  6  8 20-16 42
 5.Victors FC (Kampala)                     26 10  9  7 33-22 39  [*2]
 6.SC Villa (Kampala)                       26  9 12  5 22-11 39
 7.Express SC (Kampala)                     26  9 10  7 18-14 37
 8.Proline                                  26  9  9  8 28-24 36  [*1]
 9.Uganda Police FC (Kampala)               26  8  7 11 18-21 31
10.Masaka Local Council                     26  9  4 13 20-27 31
11.UTODA FC (Kampala)                       26  7  7 12 19-34 28
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
12.Maroons FC (Kampala)                     26  5 11 10 13-21 26  [*4]
----------------------------------------------------------------
13.Fire Masters (Kampala)                   26  4  7 15 23-38 19  [*4]  Relegated
14.Gulu United FC (Gulu)                    26  3  4 19 11-44 13  Relegated

[*1] Nalubaale were renamed Proline
[*2] Victors play home matches in Jinja
[*3] URA play home matches in Lugazi since Jan 2011
[*4] according to league regulations, the third team from bottom are
     to play off against the third place finishers of the second level;
     however, FUFA insist they did not approve this regulation and 
     three teams are to be promoted automatically; apparently the league
     is extended to 16 clubs by also reprieving Fire Masters

NB: Kinyara Sugar Works FC (Masindi) were dissolved;
    Children Restoration Outreach FC (Mbale) excluded for financial
      reasons; Boroboro Tigers FC (Lira) wanted to replace them
      but their request was rejected

Round 1
[Sep 17]
Express           1-1 URA
Bunamwaya         1-0 Masaka
  [Tony Odur]
Maroons           0-0 Gulu
Victors           0-1 KCC
Police            0-2 Proline
Fire Masters      3-1 UTODA             
[Oct 12]
Villa             0-1 Simba             [closed doors]
  [Godfrey Wakaza]

Round 2 [Sep 21]
URA               1-0 Simba
  [Augustine Nsumba 29]
Proline           0-0 Villa
Gulu              0-2 Police
  [Andrew Waisswa, Haruna Mukasa]
UTODA             1-1 Victors
Fire Masters      0-1 Express
  [Edris Kaye 34]
Masaka            0-1 Maroons
  [Okello Sylvester 53]
KCC               bye Bunamwaya

Round 3 [Sep 24]
Villa             1-1 URA 
Bunamwaya         1-3 KCC 
Express           0-0 Victors
Simba             1-0 Fire Masters
Gulu              1-4 Proline
Masaka            1-0 Police
Maroons           bye UTODA

Round 4
[Oct 12]
KCC               2-0 Maroons
  [Bruno Olobo 20, Eric Obua 79]
[Oct 15]
Fire Masters      0-2 Villa
  [Emmanuel Kalyowa, Isaac Muleme]
Proline           2-1 Masaka
Victors           2-0 Simba
  [Yuda Mugalu 2, Hassan Mubiru 16]
Police            0-0 Express
[Oct 26]
UTODA             0-0 Bunamwaya
Gulu              0-0 URA

Round 5
[Oct 19]
Villa             1-1 Victors
  [Emmanuel Kilyowa 41; Yuda Mugalu 90]
Bunamwaya         2-1 Express
  [Ronald Muganga 4, Robert Kimuli 34; Noah Ssemakula 74]
[Oct 22]
Fire Masters      1-4 URA
UTODA             0-0 Maroons
KCC               1-0 Police
  [Eric Obua (pen)]
Gulu              1-2 Masaka
Simba             1-1 Proline
  [Godfrey Wakaza; Patrick Edema]

Round 6 [Oct 29]
Police            0-1 Bunamwaya
Proline           1-2 KCC 
Gulu              1-2 UTODA
Express           2-0 Maroons 
Masaka            1-2 Fire Masters
Victors           0-1 URA 
Simba             bye Villa

NB: due to the confusion on the participation of Kinyara, CRO and
    Boroboro as well as a extensive trip abroad by Express there 
    was no functioning 'round system' after the end of October.

[Nov 2]
Maroons           2-1 Simba
  [Isaac Kisujju, Sanuel Oguttu; Henry Bagonza]
Bunamwaya         1-0 Villa
  [Mike Mutyaba 68]
Fire Masters      2-2 Victors
  [Efinit Gerald 65, Paddy Muhumuza 2-2; Paul Kibande 0-1,
   Hood Kaweesa 71]
UTODA             0-2 Proline
  [Anthony Bongole, Sula Matovu]

[Nov 16]
KCC               1-0 Gulu   
  [Andrew Ssekayombya 68]  
Villa             2-2 Maroons
  [Erukana Nkugwa 2, Isaac Kirabira 2-1; Samuel Ogutu 1-1,
   Sylvester Okello 70]
Simba             1-1 Police

[Nov 19]
KCC               2-1 Masaka
  [Brian Majwega 44, Isaac Mugabi 89; Ndiefi Kamada 1-1]
Victors           2-0 Gulu
Fire Masters      2-2 Police
Simba             0-1 UTODA

[Nov 23]
Proline           2-0 Maroons
  [Ivan Bukenya, Patrick Edema]
Police            1-0 Villa
  [Lawrence Segawa 38]
Masaka            0-0 Victors

[Nov 26]
UTODA             2-2 Masaka
Simba             1-0 Gulu

[Nov 30]
Gulu              0-1 Fire Masters
  [Julius Okotcha]
Police            2-1 UTODA          
  [Joram Katende, Haruna Mulindwa; Elijah Segane]   
Masaka            0-2 Villa 

[Dec 3]
Simba             1-0 Masaka
Fire Masters      1-1 Maroons

[Dec 7]
Express           1-1 Proline 
  [Godfrey Kavulu 1-0; Anthony Bongole 67]

[Dec 10]
Express           1-0 KCC

[Dec 14]
UTODA             0-1 Express
  [Francis Jjemba 34pen]

[Dec 17]
Bunamwaya         awd Fire Masters      [awarded 0-3; originally 3-1 (1-0?), 
URA               1-0 KCC                Bunamwaya used ineligible player]

[Dec 21]
Maroons           0-0 URA
Proline           0-1 Bunamwaya
  [Saddam Juma 45]

[Jan 4]
Gulu              0-0 Express

[Jan 7]
UTODA             0-3 Villa

[Jan 11]
Simba             1-0 Express
Police            0-1 Victors 

[Jan 14]
Express           0-1 Villa 
Maroons           1-1 Victors

[Jan 18]
Maroons           0-1 Police
  [Benson Ociti 66]
Masaka            0-1 Express
Villa             4-0 Gulu
  [Francis Alloh 40, Simon Sserunkuuma 66, 88, Elisa Sekisambu 81]

[Jan 20]
Victors           2-1 Bunamwaya
  [Hood Mayanja 1-0, Yuda Mugalu 2-1; Sadam Juma 1-1]
Fire Masters      0-3 KCC
  [Siraje Turyamuhebwa 13, Andrew Sekayombya (2)]
URA               3-1 UTODA             [in Lugazi]

[Jan 22]
Villa             0-0 KCC 
Bunamwaya         0-1 Simba 
Masaka            1-0 URA               

[Jan 24]
Proline           1-0 Fire Masters
URA               3-0 Police            [in Lugazi]
Gulu              0-1 Bunamwaya

[Jan 26]
KCC               2-0 UTODA
[Jan 27]
Maroons           1-2 Bunamwaya
  [Mohammed Kyeyune 7; Saddam Juma 24pen, Tony Odur 81]

[Feb 22]
URA               0-0 Bunamwaya         [in Lugazi]
Proline           0-1 Victors
  [Karim Nkugwa 70]
KCC               1-0 Simba
  [Richard Malinga]

[Feb 25]
Proline           0-2 URA

Round 14
[Mar 1]
KCC               0-0 Villa
Fire Masters      0-1 Simba
Victors           2-1 UTODA
Express           1-1 Masaka
Police            awd Gulu              [awarded 2-0, Gulu dns]
[Mar 4]
Bunamwaya         1-0 Maroons
URA               2-0 Proline           [in Lugazi]

Round 15
[Mar 4]
Gulu              0-1 KCC         
UTODA             2-1 Police
Victors           5-2 Fire Masters
[Mar 8]
Villa             1-1 Bunamwaya
[Mar 11]
URA               2-0 Masaka            [in Lugazi]
Maroons           0-0 Express
Proline           1-1 Simba 

Round 16
[Mar 15]
Express           1-0 Gulu     
  [Moses Ndaula]         
Maroons           1-1 Proline    
  [Kenneth Igama 1-0; Ivan Bukenya 89]       
Simba             1-2 URA          
  [Yusuf Bagonza 10; Robert Ssentongo 48, Moses Feni 76]     
Bunamwaya         0-1 Police   
  [Benson Ociti 14]         
Masaka            1-1 UTODA             
[Mar 16]
Villa             1-0 Fire Masters 
  [Dennis Guma 70]     
[Apr 27]
KCC               0-0 Victors           

Round 17
[Apr 1]
Masaka            1-0 KCC               
  [Herman Wasswa]
Proline           0-0 Express           
Gulu              0-1 Villa             
  [Elias Sekisambu] 
Police            0-0 Maroons          
Fire Masters      0-0 Bunamwaya         
UTODA             2-1 URA               
  [Derrick Walulya 18og, Mike Birungi 2-0; Justus Anene 2-1]
[Apr 19]
Simba             1-1 Victors           
	
[Apr 5]
Police            0-0 Fire Masters      
Gulu              0-2 Simba             
KCC               1-3 Bunamwaya         
URA               1-0 Villa             [in Lugazi]             
	
[Apr 8]
URA               3-0 Gulu              [in Lugazi]
  [Hamis Kizza 19, 2-0, Robert Ssentongo 3-0]
Simba             1-1 KCC               
  [Godfrey Wakaza 1-0; Tom Masiko]
Express           1-0 Fire Masters      
  [Moses Ndaula 44]
Maroons           0-0 UTODA             

[Apr 12]
URA               3-1 Express           [in Lugazi]           
[Apr 15]
Simba             1-0 Maroons           

[Apr 19]
KCC               1-0 Proline           
  [Caesre Sapeo 41]
Gulu              2-1 Maroons           
Express           3-0 UTODA     
  [Moses Ndawula, Sulaiman Jjingo, Willy Kavuma]        
Masaka            0-1 Bunamwaya         
URA               3-2 Fire Masters      [in Lugazi]      

[Apr 25]
Fire Masters      2-3 Proline           
Maroons           1-0 Masaka            
Bunamwaya         2-1 URA               
 
[Apr 26]
Express           0-1 Simba          
  [Robert Omunku]   
Villa             2-1 UTODA           
  [Emma Kalyowa (2); Yasin Mubiru 1]  

[May 3]
Police            0-1 URA               
  [Moses Feni 54]
Villa             0-0 Proline           
KCC               0-0 Fire Masters      
Victors           3-1 Masaka            

[May 6]
Simba             0-0 Villa             
Express           0-1 Bunamwaya         
Masaka            1-0 Gulu              
Proline           2-0 UTODA             
URA               1-0 Maroons           [in Lugazi]           
Victors           2-1 Police          

[May 10]
Bunamwaya         4-0 Gulu
  [Mike Mutyaba (2), Luwagga Kizito, Sadam Juma]
Express           0-0 Police 
Victors           0-1 Maroons
  [Muzamil Mutyaba 90]
UTODA             0-0 Fire Masters
Masaka            0-1 Simba
  [Robert Nakyenarine 72]

[May 17]
URA               2-1 Victors
  [Robert Ssentongo 1, Dan Wagaluka 2-1; Obed Mayanja 1-1]
KCC               2-1 Express
  [Andy Sekayombya 48, Kamada Ssebagala 2-1; Yusuf Juuko 17]
Simba             1-0 Bunamwaya
  [Robert Nakyenalire]
Villa             1-0 Police
  [Francis Aloh 79]

[May 20]
Maroons           0-1 KCC
Bunamwaya         1-1 Proline
Fire Masters      1-2 Masaka
Villa             0-0 Victors 

[May 23]
Villa             0-1 Masaka
  [Herman Wasswa]
Proline           0-2 Police
  [Jimmy Kakembo (2)]
[May 24]
KCC               1-2 URA  
  [Andy Ssekayombya 40; Robert Ssentongo 31, 61]
UTODA             1-0 Simba
Gulu              0-5 Victors
  [Dan Sserunkuma (2) Obed Mayanja (2), Yudah Mugalu]

[May 27]
Maroons           0-0 Villa             
Bunamwaya         0-1 UTODA      
  [Hussein Zinda 70]       
Fire Masters      1-2 Gulu           
  [Ronnie Segujja; Luke Ojok, Abdul Olema]   
Masaka            1-0 Proline           
Police            1-0 Simba             
Victors           0-1 Express

[May 30]
Bunamwaya         2-0 Victors        
  [Tony Odur, Kizito Luwaga]   
UTODA             1-0 KCC         
  [Davis Kasirye (pen)]      
[May 31]
Proline           2-2 Gulu              
Police            1-2 Masaka
[Jun 1]
Villa             0-0 Express

[Jun 2]
Police            0-0 KCC               
[Jun 3]
UTODA             0-2 Gulu              
Proline           2-1 Victors           
Maroons           1-0 Fire Masters      

Final Table:

 1.URA FC (Kampala)                         26 18  5  3 41-15 59  [*3]  Champions
 2.Kampala City Council FC                  26 14  6  6 26-14 48
 3.Bunamwaya SC (Wakiso)                    26 14  5  7 27-18 47
 4.Simba FC (Bombo)                         26 12  6  8 20-16 42
 5.Victors FC (Kampala)                     26 10  9  7 33-22 39  [*2]
 6.SC Villa (Kampala)                       26  9 12  5 22-11 39
 7.Express SC (Kampala)                     26  9 10  7 18-14 37
 8.Proline                                  26  9  9  8 28-24 36  [*1]
 9.Uganda Police FC (Kampala)               26  8  7 11 18-21 31
10.Masaka Local Council                     26  9  4 13 20-27 31
11.UTODA FC (Kampala)                       26  7  7 12 19-34 28
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
12.Maroons FC (Kampala)                     26  5 11 10 13-21 26  [*4]
----------------------------------------------------------------
13.Fire Masters (Kampala)                   26  4  7 15 23-38 19  [*4]  Relegated
14.Gulu United FC (Gulu)                    26  3  4 19 11-44 13  Relegated

[*1] Nalubaale were renamed Proline
[*2] Victors play home matches in Jinja
[*3] URA play home matches in Lugazi since Jan 2011
[*4] according to league regulations, the third team from bottom are
     to play off against the third place finishers of the second level;
     however, FUFA insist they did not approve this regulation and 
     three teams are to be promoted automatically; apparently the league
     is extended to 16 clubs by also reprieving Fire Masters

NB: Kinyara Sugar Works FC (Masindi) were dissolved;
    Children Restoration Outreach FC (Mbale) excluded for financial
      reasons; Boroboro Tigers FC (Lira) wanted to replace them
      but their request was rejected


Author: Ian King

Last updated: 26 Jul 2012

(C) Copyright Ian King and RSSSF 2010/12
						

Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
4,307,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3671
Total Execution Time  0.3691
  CADENA URL  
/super_league_uganda2011
  GET DATOS  
$_GET['/super_league_uganda2011']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0105  SELECT type FROM routes WHERE alias = 'super_league_uganda2011'
0.0213  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 = 2011 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=481 AND type_rel = 3
0.0108  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 481 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108  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 (1221330,759847,638011,637509,489377) ORDER BY n.cover_points DESC, update_date DESC
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 = 29353 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='2011' WHERE c.parentId=481 GROUP BY c.id ORDER BY c.order_id ASC
0.0106  SELECT type,rule FROM rules WHERE categoryId = 481 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 09:22:57' 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=2 AND last_update > '2024-03-29 09:22:57' 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-03-29 09:22:57' 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-03-29 09:22:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  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 = 2011 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0109  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=29353 AND rel.round=26
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 = 29353 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 = 29353 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-02-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29353 ORDER BY creation_date DESC LIMIT 0, 10
0.0113  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-02-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29353
0.0111  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 `calendars2011` 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` = 29353 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 200
0.0111  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 `events2011` e INNER JOIN calendars2011 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 = 26 AND e.real_date IS NOT NULL AND e.league_id = 29353 ORDER BY total DESC LIMIT 40
0.0107  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 `events2011` e INNER JOIN calendars2011 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 = 29353 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0113  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 `tables2011` 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 = 29353 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` 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 = 29353 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  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-03-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 29353 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0112  SELECT data1, data2 FROM services_tags WHERE categoryId=481
0.0112  SELECT group_code, extraName from `leagues` WHERE categoryId=481 AND year=2011