4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2006
Temporada Siguiente »
Publicidad 600x120.gif
Liga Uganda 2006
2005/2006

Liga Uganda 2006

Información Histórica 
						
Super League

Final Table:

 1.URA SC (Kampala)                  28 19  8  1 47-13 65  Champions
 2.Police (Jinja)                    28 16  7  5 42-13 55
 3.Express Red Eagles (Kampala)      28 15  9  4 32-16 54
 4.Kampala City Council              28 15  8  5 34-17 53
 5.SC Villa (Kampala)                28 13 10  5 39-19 49
 6.Victor FC                         28 14  7  7 28-20 49
 7.SC Simba (Lugazi)                 28 12 11  5 36-21 47
 8.Kinyara Sugar Works FC (Masindi)  28  7 13  8 26-26 34
 9.Mbale Heroes (Mbale)              28  8  8 12 18-25 32
10.Maji FC (Kampala)                 28  7  9 12 23-27 30
11.Bunamwaya FC (Wakiso)             28  7  8 13 26-35 29
12.Masaka Local Council              28  6  9 13 20-31 27
---------------------------------------------------------
13.Kampala United                    28  5 10 13 22-31 25  Relegated
14.KB Lions                          28  2  5 21 14-68 11  Relegated  [aka Kajjansi Boys] 
15.Super Cubs (Kampala)              28  0  6 22 10-55  6  Relegated

[Jan 28]
KCC                1-2 Police   
[Jan 31]
Super Cubs         0-0 KB Lions
Victor             1-0 Masaka
Villa              0-2 URA
[Feb 1]
Heroes             0-1 KCC
Kinyara            0-2 Express
Simba              0-2 Police
[Feb 3]
Bunamwaya          1-0 Super Cubs
[Feb 4]
Maji               0-1 Villa 
Express            2-0 Masaka
Kinyara            0-2 Victor
Police             1-0 URA
[Feb 7]
Masaka             0-0 Police
KB Lions           1-1 Heroes
Kampala U.         0-0 Kinyara
Bunamwaya          0-4 Villa
[Feb 8]
Simba              2-3 Victor
URA                2-1 Express
[Feb 10]
Bunamwaya          2-1 KB Lions         [also reported 2-0]
Police             2-0 Villa
[Feb 11]
Express            1-0 Victor 
URA                1-0 Masaka 
Heroes             1-0 Super Cubs
KCC                0-3 Simba 
[Feb 14]
Kinyara            1-0 Super Cubs
Masaka             1-1 Kampala U.
Simba              3-1 KB Lions  
[Feb 15]
Maji               2-3 Express
[Feb 17]
Bunamwaya          0-0 Victor           [inferred]
Kinyara            0-0 Simba            [inferred]
Masaka             1-1 Villa 
[Feb 21]
Express            1-0 Super Cubs 
Maji               0-0 Bunamwaya
[Feb 22]
KB Lions           0-2 Villa
Victor             1-0 Police
[Feb 24 - apparently postponed]
Super Cubs          -  Masaka 
[Feb 25]
Heroes             0-0 Police
Kinyara            1-0 Bunamwaya
KB Lions           0-5 KCC
Victor             1-0 Maji
[Feb 28]
URA                2-0 Heroes 
KB Lions           0-0 Maji 
Victor             1-2 Villa 
[Mar 1]
Bunamwaya          1-1 Simba 
Kampala U.         1-1 Express 
Masaka             0-0 KCC 
[Mar 3]
Super Cubs         0-3 Villa         
Kinyara            4-1 KB Lions
[Mar 6]
Simba              0-1 Heroes
[Mar 7]
KCC                3-2 Bunamwaya
Masaka             1-0 Kinyara 
Super Cubs         0-1 Maji
[Mar 8]
URA                2-0 Victor
[Mar 9]
KB Lions           2-1 Kampala U. 
[Mar 10]
Villa              1-2 Express 
[Mar 11]
Masaka             0-1 Heroes
Maji               1-0 Police
URA                0-0 KCC      
[Mar 14]
Maji               1-2 URA
[Mar 15]
Villa              1-1 Kinyara
Simba              5-1 Super Cubs
[Mar 16]
Express            2-0 KB Lions   
[Mar 17]
Kinyara            0-0 Maji             [inferred]
Bunamwaya          1-2 Masaka
KCC                2-1 Kampala U.       [inferred]
[Mar 21]
Kampala U.         2-1 Super Cubs       [inferred]
KB Lions           2-2 Masaka   
[Mar 22]
Bunamwaya          1-2 URA
Villa              1-2 Simba
Victor             0-0 Heroes  
[Mar 24]
Express            0-0 KCC              [inferred (1-1?)]
Kampala U.         0-1 Victor           [inferred]
[Mar 25]
Super Cubs         0-2 URA      
Heroes             0-2 Villa            [inferred]
Police             4-0 Bunamwaya
[Mar 27]
KCC                1-0 Maji
Police             3-2 Kinyara  
[Mar 28]
Express            2-1 Heroes
Kampala U.         1-1 Simba    
[Mar 31]
Masaka             0-1 Maji
Super Cubs         0-0 KCC
[Apr 4]
Express            1-0 Bunamwaya
[Apr 5]
Police             7-0 KB Lions         [also reported 0-0]
Simba              0-0 Masaka 
Heroes             2-0 Kampala U.
[Apr 6]
Victor             1-1 Super Cubs 
[Apr 7]
KCC                abd Villa            [abandoned at 2-2 in 85']
[Apr 8]
Police             0-1 Express         
Kampala U.         0-0 Bunamwaya   
[Apr 11]
Super Cubs         0-1 Police
SC Villa           0-0 Kampala U.
KCC                2-1 Kinyara
[Apr 12]
Bunamwaya          0-0 Heroes
Maji               0-1 Simba
[Apr 14]
Kinyara            2-2 URA   
KB Lions           0-0 Victor
[Apr 15]
Maji               1-1 Kampala U.
[Apr 16]
Victor             1-1 KCC  
[Apr 18]
URA                7-0 KB Lions
[Apr 19]
Simba              0-0 Express
Heroes             1-1 Maji  
[Apr 21 (replay of Apr 7)]
KCC                0-0 Villa
[Apr 23?; ppd from Feb 24]
Kampala U.         1-1 URA    
[Apr 26]
Police             2-1 Kampala U.
[Apr 27]
URA                1-1 Simba
[May 2]
Super Cubs         awd Masaka           [awarded 0-2, Super Cubs had no boots]

[May 14]
Express            3-2 Maji
URA                ppd Bunamwaya
Mbale              0-1 Victor 
Kinyara            0-0 Kampala U.
[May 15]
Maji               0-1 KCC 
[May 17]
Super Cubs         1-1 Express
Kinyara            1-1 Masaka
Heroes             2-0 KB Lions
Victor             0-0 Simba
URA                2-0 Kampala U.
[May 19]
Simba              4-1 Maji    
[May 20]
Kampala U.         1-2 KCC
Masaka             2-0 Super Cubs
Bunamwaya          0-1 Express
Kinyara            0-0 Heroes      
[May 21]
KB Lions           0-3 URA
[May 23]
Heroes             1-0 Masaka
KCC                1-1 Super Cubs
[May 24]
Simba              2-2 Kinyara
KB Lions           0-2 Express
URA                1-0 Maji    
[May 25]
Victor             2-1 Bunamwaya   
[May 27]
Masaka             4-2 KB Lions
URA                2-0 Super Cubs
Express            0-0 Simba
[May 28]
Bunamwaya          0-2 KCC
Maji               3-0 Heroes
[May 30]
Victor             0-1 Kinyara
Express            2-0 Kampala U.
[May 31]
KCC                4-0 KB Lions
Masaka             0-1 URA
Villa              2-0 Maji  
[Jun 3]
Villa              4-1 KB Lions  
[Jun 6]
Villa              2-2 Super Cubs 
Bunamwaya          1-1 Police 
[Jun 7]
Simba              0-2 KCC 
[Jun 8]
Express            1-1 Kinyara 
Maji               0-3 Victor 
[Jun 10]
Simba              0-0 URA
[Jun 12]
Kampala U.         0-1 Villa
Police             0-0 Maji
[Jun 13]
URA                1-1 Bunamwaya
[Jun 15]
Simba              0-0 Villa 
Police             1-0 Heroes 
[Jun 16]
Super Cubs         0-3 Victor 
Kampala U.         0-0 Maji             [played later?] 
[Jun 17]
Masaka             1-1 Express 
Kinyara            1-0 KCC
[Jun 18]
Bunamwaya          0-2 Villa 
[Jun 20]
KB Lions           1-0 Super Cubs
Victor             1-0 Kampala U.
[Jun 21]
Simba              1-0 Bunamwaya
[Jun 22]
Maji               0-0 Kinyara
[Jun 24]
KCC                1-1 Express
[Jun 25]
Maji               1-1 Masaka
Heroes             0-2 URA
[Jun 28]
Villa              3-1 Heroes
Police             2-0 Masaka
[Jul 4]
KCC                1-0 Heroes
KB Lions           1-2 Police 
[Jul 5]
Villa              3-0 Masaka
Bunamwaya          1-0 Kinyara
Maji               6-1 Super Cubs
[Jul 6]
Simba              3-2 Kampala U.
[Jul 7]
URA                0-0 Police
Victor             abd Express          [abandoned at 1-1 just before half-time,
[Jul 8]                                  referee attacked by spectator]   
Villa              0-1 KCC  
[Jul 9]
KB Lions           1-2 Simba
[Jul 10]
URA                3-2 Kinyara
[Jul 11]
Kampala U.         2-0 Heroes 
[Jul 12]
Villa              0-0 Police
Masaka             1-3 Bunamwaya
[Jul 13]
Super Cubs         0-2 Kinyara          [also reported 0-1]
[date?; inferred]
Kampala U.         0-1 Police
Heroes             1-1 Kinyara 
[Jul 14, inferred]
Maji               1-0 KB Lions    
[Jul 15]
Kampala U.         2-0 Masaka
Express            0-1 Villa
Heroes             1-0 Simba 
[Jul 16]
Kinyara            0-2 Police  
[Jul 17]
Victor             1-2 URA
Bunamwaya          0-1 Maji 
[Jul 18]
KCC                1-0 Masaka
[Jul 19]
Police             4-0 Super Cubs
Kampala U.         1-0 KB Lions 
[Jul 21]
Heroes             0-1 Express
URA                1-1 Villa 
[Jul 22]
Police             5-0 Victor
Super Cubs         0-1 Simba    
[Jul 24]
Heroes             1-1 Bunamwaya
[Jul 25]
Masaka             1-0 Victor
[Jul 26]
Super Cubs         0-3 Kampala U.
[Jul 27]
KB Lions           0-3 Bunamwaya
[Jul 29]
Victor             1-0 Express          [replay Jul 7]   
Kinyara            1-1 Villa
[Jul 30]
Bunamwaya          4-1 Kampala U.
[Aug 1]
Masaka             0-2 Simba
[Aug 2]
KCC                0-2 URA
Express            0-0 Police 
[Aug 3]
Super Cubs         2-3 Bunamwaya 
[Aug 6]
Super Cubs         0-3 Heroes           [inferred; also reported 0-0]
[Aug 7]
Police             awd Simba            [awarded 0-2, Police forfeit due to 
[Aug 8]                                  Tusker Cup]
KCC                0-1 Victor
[Aug 11]
Villa              1-1 Victor
[Aug 12]
Police             awd KCC              [awarded 0-2, Police forfeit due to 
Express            0-1 URA               Tusker Cup]
[Aug 13]
Victor             awd KB Lions         [awarded 2-0, KB Lions dns]
[date?]
KB Lions           awd Kinyara          [awarded 0-2]

Final Table:

 1.URA SC (Kampala)                  28 19  8  1 47-13 65  Champions
 2.Police (Jinja)                    28 16  7  5 42-13 55
 3.Express Red Eagles (Kampala)      28 15  9  4 32-16 54
 4.Kampala City Council              28 15  8  5 34-17 53
 5.SC Villa (Kampala)                28 13 10  5 39-19 49
 6.Victor FC                         28 14  7  7 28-20 49
 7.SC Simba (Lugazi)                 28 12 11  5 36-21 47
 8.Kinyara Sugar Works FC (Masindi)  28  7 13  8 26-26 34
 9.Mbale Heroes (Mbale)              28  8  8 12 18-25 32
10.Maji FC (Kampala)                 28  7  9 12 23-27 30
11.Bunamwaya FC (Wakiso)             28  7  8 13 26-35 29
12.Masaka Local Council              28  6  9 13 20-31 27
---------------------------------------------------------
13.Kampala United                    28  5 10 13 22-31 25  Relegated
14.KB Lions                          28  2  5 21 14-68 11  Relegated  [aka Kajjansi Boys] 
15.Super Cubs (Kampala)              28  0  6 22 10-55  6  Relegated

NB: five clubs to be promoted

Topscorer (Aug 1):
15 Dan Walusimbi (Police)   
14 Ronald Muangana (Bunamwaya)
13 Godfrey Wakaza (Simba)
12 Geoffrey Sserunkuma (KCC)
11 Hassan Mubiri (Express)
10 Hamis Kitagenda (KCC)
 9 Oscar Kadenge (Villa)  



Author: Hans Schöggl

Last updated: 27 Aug 2010

(C) Copyright Hans Schöggl and RSSSF 2005/10


  USO DE MEMORIA  
4,302,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1043
Total Execution Time  0.1062
  CADENA URL  
/super_league_uganda2006
  GET DATOS  
$_GET['/super_league_uganda2006']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0018  SELECT type FROM routes WHERE alias = 'super_league_uganda2006'
0.0043  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 = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=481 AND type_rel = 3
0.0027  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.0024  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.0019  SELECT text_es as historical_text FROM leagues_text WHERE id=1019
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 = 29341 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='2006' WHERE c.parentId=481 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 481 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 05:04:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 05:04:21' 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=4 AND last_update > '2024-04-19 05:04:21' 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-19 05:04:21' 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 = 'super_league_uganda' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (29341) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29341) 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 events2006 e WHERE e.league_id IN (29341) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29341) 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 events2006 e WHERE e.league_id IN (29341) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29341) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (29341) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29341) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  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 = 29341 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0019  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 = 29341 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0018  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 481 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=481 GROUP BY l.year ORDER BY l.year DESC
0.0021  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=29341 AND rel.round=28
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 = 29341 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 29341 AND esl.points > 0
0.0019  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-20" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29341 ORDER BY creation_date DESC LIMIT 0, 10
0.0022  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-20" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29341
0.0019  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2006` 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` = 29341 AND c.`round` = 28 ORDER BY shedule ASC LIMIT 200
0.0017  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 `events2006` e INNER JOIN calendars2006 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 = 28 AND e.real_date IS NOT NULL AND e.league_id = 29341 ORDER BY total DESC LIMIT 40
0.0020  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2006` e INNER JOIN calendars2006 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 = 29341 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` 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 = 29341 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` 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 = 29341 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-19 00:00:00' AND c.`shedule` < '2024-04-23 23:59:59' AND l.id = 29341 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=481
0.0021  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 481 AND l.year = 2006 ORDER BY l.group_code ASC
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=481 AND year=2006