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

Liga Uganda 2001

Información Histórica 
						

Final Table (as reported by FUFA):
   
 1.SC Villa (Kampala)                 28    22    4    2    65-20    70  Champions
 2.Kampala City Council               28    18    9    1    68-20    63 
 3.Express Red Eagles (Kampala)       28    14    7    7    37-25    49 
 4.SCOUL (Lugazi)                     28    12   11    5    31-22    47
 5.SC Simba (Lugazi)                  28    12    8    8    41-31    44
 6.Mbarara United                     28    13    5   10    42-41    44
 7.Mbale Heroes                       26    12    7    7    54-28    43
 8.Masaka Local Council               28    11    8    9    25-35    41
 9.Iganga Town Council                28    11    7   10    23-30    40
10.Police (Jinja)                     28     9   11    8    31-26    38
-----------------------------------------------------------------------
11.Military Police (Kampala)          28     8    6   14    33-40    30  Relegated 
12.Chicago FC (Kampala)               28     5    8   15    20-46    23  Relegated
13.Horizon FC (Kabale)                27     1   14   12    19-39    17  Relegated 
14.Rock Star FC (Tororo)              27     2    4   21    18-58    10  Relegated
15.Black Rhino (Lira)                 28     1    4   23    15-71     7  Relegated

NB: one more loss than win; odd number of draws; records of Express
    and Mbale Heroes most probably swapped; record of KCC possibly
    incorrect in wins and draws

Known results:

[End of Mar]
Iganga          1-0     Police
[Mar/Apr ?]
Mbale Heroes    1-1     Military Police 
Military Police 2-1     Simba
Rock Star       2-2     Chicago
[Apr 1] 
SCOUL           0-1     KCC
Mbale Heroes    2-1     Express
[Apr ?] 
Masaka LC       1-3     Mbarara U. 
[Apr 6] 
Masaka LC       0-1     SC Villa
SCOUL           0-0     Chicago 
[Apr 7]
Horizon         0-0     Simba      
[Apr 8]
Police          lt      Express
Rockstar         -      Iganga
[Apr 9?]
SC Villa        4-2     Military Police
Mbarara         1-2     Simba
Black Rhino     0-0     Mbale Heroes
[Apr 11]
Express         4-0     Horizon
[Apr 12]
Chicago         0-0     Police
[Apr 15]
Horizon         1-1     Black Rhino 
Mbarara         1-3     Express
SCOUL           3-2     Heroes
[Apr] 
Mbarara          -      KCC           [reported as 4-3 but KCC won or not played]          
KCC             1-0     Police 
Rock Star        -      KCC           [reported as 0-0 but KCC won or not played]
[Apr 17]
Military Police 2-1     Rock Star
Masaka LC       4-0     Black Rhino 
[Apr 18] 
KCC             4-0     Iganga 
[Apr 22] 
Heroes          1-1     KCC
Iganga          1-0     Simba
SCOUL           0-0     Police
[Apr 24]
Military Police 1-1     Horizon
[Apr 25]
SC Villa        2-1     Iganga
[Apr 26]
KCC              -      Rockstar
[Apr 28]
Military Police 1-1     Express
[Apr 29] 
Simba           0-2     SC Villa 
Black Rhino     0-1     KCC 
Rock Star       0-2     Police 
Mbarara         1-0     SCOUL 
[Apr ?] 
Masaka LC       2-0     Heroes 
[May 3] 
Iganga          1-1     Military Police 
[May 3?] 
Masaka LC       1-1     Chicago 
[May 4?] 
Express         4-1     Simba 
[May 4] 
Chicago         1-1     Masaka LC 
[May 5?]
Police          1-1     SC Villa     
[May 6?]
Rock Star       0-1     Mbarara
SCOUL           1-0     Black Rhino 
Horizon         abd     KCC             [abd at 1-0 in 40' due to attacks against
  the referee after a penalty award to KCC]
[May 8] 
Police          2-1     Military Police 
[May 9]  
Express         3-2     Masaka LC 
[May 10] 
Chicago         1-3     Simba 
[May 12] 
Black Rhino     1-3     Mbarara 
Heroes          3-1     Rock Star 
[May 13] 
SCOUL           1-0     Express 
Iganga          1-0     Horizon 
[May 15] 
Simba           2-2     Masaka LC 
[May 18]
Masaka LC       1-0     Military Police
[May 18?]
Express         3-1     Chicago
[May 19] 
SC Villa        1-1     KCC 
[May 20]
Iganga          0-3     Express
Rock Star       3-3     SCOUL
Mbarara         2-2     Chicago
Heroes          2-1     Police
[May 22]
Military Police 2-3     Mbarara
[May 23]
Police          lt      KCC
[May 27] 
Rock Star       2-1     Black Rhino  
Heroes          1-0     Chicago 
[May 29] 
Police          3-3     Simba 
[May 31]
Masaka LC       2-1     Rock Star 
[Jun 5]
Simba           2-0     Heroes
[Jun 6]
Masaka LC       0-0     KCC
Chicago         0-6     SC Villa
[Jun 7]
Military Police 0-2     SCOUL
[Jun 9]
Horizon          -      Police
KCC             1-1     Express          
[Jun 10]
Iganga          0-0     Masaka LC
Villa           2-1     Heroes
Mbarara         1-1     Police
[Jun 12] 
Express         8-1     Black Rhino  
  [6 goals by Hassan Mubiru]
[Jun 13] 
Simba           1-2     KCC 
[Jun 14] 
Military Police 5-1     Black Rhino  
Masaka LC       0-1     SCOUL 
Rock Star       0-2     Heroes 
[Jun 16 or 17]
KCC             1-1     Chicago
[Jun 17] 
Rock Star       0-2     Express 
Horizon         0-2     SC Villa 
[Jun 18?]
Iganga          1-1     Heroes
[Jun 19] 
KCC             3-1     Military Police 
[Jun 20]
SC Villa        1-0     SCOUL             [2-0?]
[Jun 22] 
Chicago         0-1     Iganga 
[Jun 23] 
KCC             5-2     Mbarara LC    
[Jun 24] 
Black Rhino     2-3     SC Villa 
[Jun 27] 
SC Villa        6-0     Rock Star 
[Jun 28] 
Chicago         1-0     Military Police 
[Jun 30]
Express         1-1     SC Villa    
[date]
Mbarare         0-1     SC Villa

Horizon FC decided to pull out of the Nile Super League after club
sponsor Khalid Letif was banned for life; however, the players have
vowed to carry on, taking charge of the team themselves.

Halfway Table:
   
 1.SC Villa (Kampala)                 14    11    3    0    34-10    36 
 2.Kampala City Council               14     9    5    0    29- 8    32 
 3.Express Red Eagles (Kampala)       14     9    3    2    37-12    30 
 4.SCOUL (Lugazi)                     14     7    4    3    14- 7    25 
 5.Mbarara United                     14     7    3    4    27-22    24 
 6.Mbale Heroes                       14     6    4    4    19-16    22 
 7.Masaka Local Council               14     5    5    4    17-13    20 
 8.SC Simba (Lugazi)                  14     5    4    5    17-18    19 
 9.Iganga Town Council                14     4    5    5    11-16    17 
10.Police (Jinja)                     14     3    7    4    11-13    16 
11.Military Police (Kampala)          14     3    4    7    19-23    13 
12.Chicago FC (Kampala)               14     1    8    5    10-21    11 
13.Rock Star FC (Tororo)              14     2    3    9    12-31     9 
14.Horizon FC (Kabale)                14     0    6    8     5-25     6 
15.Black Rhino (Lira)                 14     0    2   12     7-34     2 

Rock Star may have to withdraw because of financial problems
        
(start 2nd half of season)

Round 16
[Aug 11] 
Heroes          2-0     Simba        
Black Rhino     3-0     Rock Stars      
SC Villa        2-0     Masaka 
[Aug 12] 
Iganga          0-0     Police 
[Aug 14]
Express         1-3     SCOUL 
Chicago         0-2     Military 
Mbarara         1-5     KCC 
Horizon         bye

Round 17
[Aug 14]
Heroes          0-1     SC Villa 
[Aug 17]
Chicago         awd     Horizon          [awarded 2-0 to Chicago as Horizon 
Masaka          1-0     Simba             appeared without uniforms]
[Aug 18]
Black Rhino     0-1     Iganga 

Round 18
[Aug 21]
KCC             4-0     Chicago 
Black Rhino     1-3     Masaka 
Military        0-1     Heroes 
[Aug 22] 
Simba           5-0     Iganga 
[Aug 23] 
Police          2-0     Mbarara 
Rock Star       1-2     SC Villa

Round 19
[Aug 25]
Military        1-4     Express 
Iganga          2-0     Chicago          [corrected from 1-1]
Black Rhino     1-1     Horizon          [inferred]
[Aug 26] 
SCOUL           2-1     Mbarara 
Heroes          2-1     Rock Star 
KCC             2-2     Police 

Round 20
[Aug 28] 
Express         1-2     Iganga 
Chicago         0-1     Mbarara 
[Aug 29] 
Rock Star       0-1     Military 
KCC             0-0     SCOUL 
Masaka          2-3     Police 
[Aug 31] 
Simba           3-0     Black Rhino 

Round 21
[Sep 1]
SC Villa        1-0     Express 
[Sep 2]
SCOUL           1-2     Military 
Horizon         1-1     Mbarara 
KCC             4-0     Black Rhino  

Round 22
[Sep 8]
Rock Star       2-2     Masaka 
[Sep 9]
Iganga          1-2     Mbarara 
Horizon         0-0     Military 
Heroes          2-1     Masaka 
SCOUL           0-0     SC Villa 

Round 23
[Sep 12] 
Express         0-0     Heroes 
[Sep 13] 
Military        0-2     Police 
[Sep 14]
SC Villa        2-1     Mbarara 
[Sep 16]
Iganga          0-7     KCC 
Rock Star       0-2     Simba 
Black Rhino     1-2     SCOUL 

Moved Matches
[Sep 18]
SC Villa        6-2     Horizon 
[Sep 21]
Chicago         0-2     Heroes 

Round 24
[Sep 22]
SC Villa        1-0     Police 
SCOUL           0-0     Horizon 
Iganga          awd     Rock Star           [abandoned at 2-0 in 65' after Rock 
[Sep 23]                                     Star left the pitch, awarded 2-0]
Mbarara         0-2     Masaka 
Heroes          3-0     Black Rhino 
Express         1-1     Simba 

Moved Matches
[Sep 25]
KCC             3-3     Horizon 
[Sep 27]
SC Villa        1-2     Simba 

Round 25
[Sep 28]
Police          0-0     Heroes 
Masaka          1-0     Express 
[Sep 29]
Military        1-3     KCC 
Horizon         3-0     Rock Star 
SCOUL           2-1     Chicago 
Iganga          3-1     SC Villa 

[Sep 30]
Mbarara         2-0     Rock Star 
[Oct 1]
Simba           1-0     Police 
[Oct 2] 
Military Police 2-0     Masaka 
[Oct 3] 
Express         2-1     Mbarara 
[Oct 4] 
Police          2-2     SCOUL 
[Oct 5] 
Simba           2-2     Horizon 
[Oct 6] 
SC Villa        awd     KCC                 [abandoned at 1-0 in 70' after KCC
Black Rhino     1-1     Express              refused to continue following fan
[Oct 7]                                      trouble, awarded 2-0]
Iganga          0-0     Military 
SCOUL           1-1     Masaka
[Oct 8] 
Police          2-1     Rock Star 
[Oct 10] 
Simba           1-1     Mbarara 
Masaka          3-1     Chicago 
KCC             2-1     Heroes 

[date unknown]
Chicago         0-3     Express

[Oct 11] 
Express         0-3     Police 
[Oct 13] 
Horizon         lt      Heroes 
Black Rhino      -      Military 
[Oct 14] 
Mbarara         3-0     Heroes              [protest Heroes on eligibiliy of 
[Oct 16]                                     Mbarara player Mbula Maina]
SC Villa        2-1     Chicago 
Rock Star       0-2     KCC 
Masaka          1-0     Horizon 
Simba           2-1     Military 
[Oct 17] 
Iganga          1-0     SCOUL 
Police          3-0     Black Rhino 

Table:
   
 1.SC Villa (Kampala)                 26    20    4    2    55-20    64
 2.Kampala City Council               25    16    8    1    61-18    56 
 3.Mbale Heroes                       26    13    6    7    32-24    45  [*1]
 4.Express Red Eagles (Kampala)       25    12    6    7    50-26    42 
 5.SCOUL (Lugazi)                     25    11    9    5    27-17    42  [26-18?]
 6.SC Simba (Lugazi)                  25    11    7    7    36-27    40
 7.Masaka Local Council               26    11    7    8    34-27    40
 8.Police (Jinja)                     26     9   11    6    30-22    38
 9.Mbarara United                     26    11    5   10    41-40    38  [38-40?]
10.Iganga Town Council                25    10    7    8    23-32    36
-----------------------------------------------------------------------
11.Military Police (Kampala)          25     7    6   12    29-36    27 
12.Horizon FC (Kabale)                25     1   12   12    17-41    15  [*1] Relegated  [17-35?]
13.Chicago FC (Kampala)               24     2    8   14    15-42    14  Relegated
14.Rock Star FC (Tororo)              25     2    4   19    17-54    10  Relegated
15.Black Rhino (Lira)                 24     1    4   19    14-55     7  Relegated

[*1] missing goals Horizon vs Heroes

[Oct 19] 
Chicago          -      Rock Star 
[Oct 20] 
Heroes           -      SCOUL 
Horizon         ppd     Express 
Masaka          lt      Iganga 
Simba           ppd     KCC              
[Oct 21] 
Mbarara         2-1     Military 
Horizon         1-1     Iganga 
[Oct 24]
Rock Star       1-2     SCOUL 
Heroes          2-0     Iganga 
Mbarara          -      Black Rhino 
Police          bt      Horizon          
[Oct 25] 
Simba           4-0     Chicago             [played 2x36 mins]
[Oct 26] 
Military        ppd     SC Villa 
[Oct 29] 
SC Villa        9-0     Black Rhino 
[Oct 30] 
Chicago         2-0     Black Rhino 
Express          -      Rock Star           [Rock Star dns] 
SCOUL           1-1     Simba 
[Oct 31] 
KCC             2-0     Masaka 
[Nov 1]
Police          0-1     Chicago           
[Nov 2] 
KCC             3-2     Express 
[Nov 5]
Simba           0-3     KCC              
[Nov 6]
Military        0-1     SC Villa
[tba] 
Horizon          -      Express 

Table (based on known results since Oct 18):
   
 1.SC Villa (Kampala)                 28    22    4    2    65-20    70  Champions
 2.Kampala City Council               28    19    8    1    69-20    65 
 3.Mbale Heroes                       27    14    6    7    34-24    48  [*1]
 4.SCOUL (Lugazi)                     27    12   10    5    30-19    46  [29-20?]
 5.SC Simba (Lugazi)                  28    12    8    8    41-31    44
 6.Express Red Eagles (Kampala)       26    12    6    8    52-29    42 
 7.Police (Jinja)                     28    10   11    7    30-23    41  [*3]
 8.Mbarara United                     27    12    5   10    43-41    41  [40-41?]
 9.Masaka Local Council               28    11    7   10    34-29    40  [*2]
10.Iganga Town Council                28    11    8    9    24-35    40  [*2]
-----------------------------------------------------------------------
11.Military Police (Kampala)          27     7    6   14    30-39    27  Relegated 
12.Chicago FC (Kampala)               27     4    8   15    18-46    20  Relegated
13.Horizon FC (Kabale)                27     1   13   13    18-42    16  [*1,*3] Relegated  [18-36?]
14.Rock Star FC (Tororo)              26     2    4   20    18-56    10  Relegated
15.Black Rhino (Lira)                 26     1    4   21    14-66     7  Relegated

[*1] missing goals Horizon vs Heroes
[*2] missing goals Masaka vs Iganga
[*3] missing goals Police vs Horizon


Final Table (as reported by FUFA):
   
 1.SC Villa (Kampala)                 28    22    4    2    65-20    70  Champions
 2.Kampala City Council               28    18    9    1    68-20    63 
 3.Express Red Eagles (Kampala)       28    14    7    7    37-25    49 
 4.SCOUL (Lugazi)                     28    12   11    5    31-22    47
 5.SC Simba (Lugazi)                  28    12    8    8    41-31    44
 6.Mbarara United                     28    13    5   10    42-41    44
 7.Mbale Heroes                       26    12    7    7    54-28    43
 8.Masaka Local Council               28    11    8    9    25-35    41
 9.Iganga Town Council                28    11    7   10    23-30    40
10.Police (Jinja)                     28     9   11    8    31-26    38
-----------------------------------------------------------------------
11.Military Police (Kampala)          28     8    6   14    33-40    30  Relegated 
12.Chicago FC (Kampala)               28     5    8   15    20-46    23  Relegated
13.Horizon FC (Kabale)                27     1   14   12    19-39    17  Relegated 
14.Rock Star FC (Tororo)              27     2    4   21    18-58    10  Relegated
15.Black Rhino (Lira)                 28     1    4   23    15-71     7  Relegated

NB: one more loss than win; odd number of draws; records of Express
    and Mbale Heroes most probably swapped; record of KCC possibly
    incorrect in wins and draws


Topscorers:

Hassan Mubiru (Express) 27
Morris Sunguti (Villa)  23



Author: Hans Schöggl

Last updated: 27 Aug 2010

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


  USO DE MEMORIA  
4,317,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0930
Total Execution Time  0.0950
  CADENA URL  
/super_league_uganda2001
  GET DATOS  
$_GET['/super_league_uganda2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'super_league_uganda2001'
0.0041  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 = 2001 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0025  SELECT text_es as historical_text FROM leagues_text WHERE id=1009
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 = 29331 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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='2001' WHERE c.parentId=481 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 12:32: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=2 AND last_update > '2024-04-19 12:32: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-19 12:32: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-19 12:32:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  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 = 2001 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 events2001 e WHERE e.league_id IN (29331) 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 (29331) 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 events2001 e WHERE e.league_id IN (29331) 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 (29331) 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 events2001 e WHERE e.league_id IN (29331) AND (e.action IN (3,4) ) 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 (29331) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (29331) AND (e.action IN (22) ) 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 (29331) 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 = 29331 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0018  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 = 29331 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0023  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=29331 AND rel.round=28
0.0020  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 = 29331 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0020  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 = 29331 AND esl.points > 0
0.0020  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` = 29331 ORDER BY creation_date DESC LIMIT 0, 10
0.0024  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` = 29331
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 `calendars2001` 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` = 29331 AND c.`round` = 28 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 `events2001` e INNER JOIN calendars2001 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 = 29331 ORDER BY total DESC LIMIT 40
0.0021  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 `events2001` e INNER JOIN calendars2001 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 = 29331 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0024  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 `tables2001` 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 = 29331 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2001` 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 = 29331 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 29331 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0024  SELECT data1, data2 FROM services_tags WHERE categoryId=481
0.0024  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 481 AND l.year = 2001 ORDER BY l.group_code ASC
0.0024  SELECT group_code, extraName from `leagues` WHERE categoryId=481 AND year=2001