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 2003
2002/2003

Liga Uganda 2003

Información Histórica
						
Final Table:
  
 1.SC Villa (Kampala)                27 23  3  1 53- 4 72  [2-0]  Champions
 2.Express Red Eagles (Kampala)      27 23  3  1 55- 9 72  [2-1]
 3.Kampala City Council              27 16  5  6 52-25 53  [5-0]
 4.URA SC (Kampala)                  27 15  8  4 37-16 53  [2-1]  [*]
 5.Masaka Local Council              27 13  8  6 32-18 47  [1-0]  
 6.SC Simba (Lugazi)                 27 11  5 11 35-33 38  [2-1]
 7.Police (Jinja)                    27  9  9  9 34-29 36  [7-0]   
 8.Mbale Heroes                      27  9  6 12 28-35 33  [3-0] 
 9.Kinyara Sugar Works FC (Masindi)  27  9  5 13 27-37 32  [2-0]  
10.Tower Of Praise TV (Kampala)      27  8  7 12 31-41 31  [4-4]
---------------------------------------------------------
11.Iganga Town Council               27  9  4 14 27-42 31  [2-0] 
12.Buikwe Red Stars (Mukono)         27  6  4 17 17-42 22         Relegated
13.Mbarara United                    27  4  3 20 27-58 16  [0-1]  Relegated
14.Game Boys FC (Tororo)             27  3  2 22 21-59 11  [1-1]  Relegated 
15.Akol FC (Lira)                    14  1  2 11  7-35  5  [*1]   Relegated

 [*] the merger of URA and Lyantonde was dissolved before the start of the
     season; URA abbreviates Uganda Revenue Authority 
[*1] all matches Akol in 2nd half of season annulled; relevant results of
     opponents indicated between square brackets

NB: FUFA's Executive Committee awarded Villa the league title following 
    matches on Sep 4; FUFA president Denis Obua was unhappy with this 
    decision and set up a new committee.
    A later committee set up by the National Sports Council published
    findings so damning to FUFA that they decided to ignore it.
    On Jan 8, 2004, FUFA announced SC Villa (who had already been
    registered for the African Champions League in December) were
    indeed 2003 league champions.

Round 1
[Nov 23]
KCC             0-2     URA             [opening match]
[Nov 24]
Mbarara         3-4     Game Boys       
Heroes          0-0     Police
Express         3-0     Top TV
Kinyara         1-2     Simba
Akol            1-2     Masaka
Buikwe          1-0     Iganga

Round 2
[Nov 27]
Top TV          1-2     KCC
Game Boys       0-2     Buikwe
Masaka          1-0     Iganga
[Nov 28]
URA             1-0     Heroes

[Nov 30]
KCC             3-2     Mbarara         
[Dec 1]
Buikwe          0-2     Simba
Iganga          2-1     Top TV
Heroes          3-1     Kinyara

[Dec 4]
Simba           0-2     URA
Masaka          1-1     KCC
[Dec 5]
Top TV          0-0     Game Boys
[Dec 6]
URA             5-0     Akol    
[Dec 7]
Simba            -      Heroes          [1-2? 0-1?]
Mbarara         3-3     Iganga          
[Dec 8]
Game Boys       0-1     Masaka
Kinyara         1-1     Top TV

[Dec 11]
KCC             1-0     Kinyara
Masaka          3-0     Mbarara         
[Dec 12]
URA             2-1     Top TV
[Dec 14]
Akol            1-1     Kinyara
Iganga          2-0     Game Boys
KCC             4-1     Simba
[Dec 15]
Mbarara         1-2     URA             
Heroes           -      Masaka          [0-2?, 0-4?]

[Dec 20]
Masaka          2-1     Top TV
[Dec 21]
Buikwe          0-1     URA
Game Boys       1-0     Police
Mbarara         1-3     Kinyara         

[Dec 27]
Police          4-1     Buikwe
[Dec 28]
Simba           ppd     Express
Express         awd     Heroes          [awarded 2-0; Heroes dns]          
[Dec 29]
Akol            0-1     Villa

[Jan 2]
Villa           2-0     Simba   
[Jan 3]
Police          1-0     Iganga
[Jan 4]
Game Boys       2-0     Akol
Kinyara         1-2     Express
[Jan 5]
Heroes          0-2     SC Villa
Mbarara         2-1     Top TV          [also reported 2-0; to be annulled?]    

[Jan 8]
SC Villa        2-0     Buikwe
[Jan 9]
URA             1-0     Police
Masaka          0-1     Kinyara         
[Jan 10]
Express         5-1     Akol
[Jan 11]
KCC             1-2     SC Villa
Heroes          2-1     Mbarara            

[Jan 15]
SC Villa        1-0     Iganga
Masaka           -      Buikwe          [home win?]
[Jan 16]
URA             1-1     Express

[Jan 18]
Police          2-1     KCC
Game Boys       1-2     Villa
[Jan 19] 
Kinyara         0-0     URA
Iganga          1-0     Simba
Buikwe          1-4     Express 
[Jan 22]
Police           -      Kinyara         [home win?]
[Jan 24]
Mbarara         1-3     Simba           
Game Boys       0-2     KCC

NB: break due to CECAFA club championship 2003

[Feb 13]
KCC             1-0     Buikwe
[Feb 14]
Express         0-0     Police
Akol            2-1     Heroes

NB: Heroes suspended from the league until March 2; if they fail to
    name a legal executive by then, they will be disqualified from the
    league (and all other FUFA competitions).

[Feb 18]
Akol            1-4     Police
Simba           3-1     Top TV 
[Feb 19]
SC Villa        3-0     Mbarara          
[Feb 20]
Express         1-0     Masaka 
[Feb 21]
Top TV          2-0     Akol 
[Feb 22]
Police          0-2     SC Villa 
Kinyara         2-3     Iganga 
[Feb 23]
Buikwe          2-2     Top TV          [abandoned in injury time after
Mbarara         1-2     Express          home fans rioted following late
[Feb 26]                                 equaliser TOP TV]
KCC             2-0     Iganga
Police          1-2     Simba 
Akol             -      Buikwe          [Akol did not win]
[Feb 27]
URA             3-3     Game Boys
[Mar 1]
Simba            -      Express         [away win ?]
[Mar 5]
Iganga          0-0     URA
Simba           2-0     Masaka

[Mar 10]
Akol            0-4     KCC         
[Mar 12]
Iganga          1-0     Heroes
Simba           4-0     Akol

[Mar 21] 
Simba           2-0     Game Boys
Masaka           -      Police          [away win?]
[Mar 23]
Mbarara         awd     Akol            [awarded 2-0; Akol dns]   

[Mar 29]
Game Boys        -      Heroes
[Apr 3]
Villa           4-0     Kinyara
[Apr 4]
Police           -      Mbarara         [home win?]
[Apr 5]
Iganga          0-2     Express
Top TV          0-2     Villa     

[Apr 12]
Heroes          2-0     KCC 
URA             1-2     Masaka
[Apr 18]
Masaka           -      Police
[Apr 19]
Express         1-0     KCC
[Apr 22]
Villa           2-0     URA

[Apr 30]
Masaka          0-1     Villa           [inferred]
Express         awd     Game Boys       [awarded 2-0; originally 1-1]
[May 1]
Police          3-1     Kinyara
[May 4]
Top TV          1-1     Police
[May 5]
Villa           0-0     Express 

Half-Way Table (May 5):
  
 1.SC Villa (Kampala)                14 13  1  0 26- 2 40
 2.Express Red Eagles (Kampala)      14 11  3  0 26- 5 36        
 3.URA SC (Kampala)                  14  8  4  2 21-10 28  [*]   
 4.Masaka Local Council              14  8  2  4 16-10 26  [25-19?]  
 5.Kampala City Council              14  8  1  5 22-14 25   
 6.SC Simba (Lugazi)                 14  8  0  6 22-16 24 
 7.Police (Jinja)                    14  6  4  4 21-13 22 
 8.Mbale Heroes                      14  6  2  6 16-15 20  
 9.Iganga Town Council               14  6  2  6 14-17 20     
10.Kinyara Sugar Works FC (Masindi)  14  4  3  7 15-21 15  
---------------------------------------------------------  
11.Buikwe Red Stars (Mukono)         14  3  2  9 10-22 11        
12.Game Boys FC (Tororo)             14  3  2  9 10-23 11       
13.TOP TV (Kampala)                  14  1  5  8 11-21  8  [+]   
14.Mbarara United                    14  2  1 11 18-31  7        
15.Akol FC (Lira)                    14  1  2 11  7-35  5  

[*] the merger of URA and Lyantonde was dissolved before the start of the
    season; URA abbreviates Uganda Revenue Authority 
[+] TOP abbreviates Tower Of Praise (TV=TeleVision)

[May 16]
Villa           3-0     Heroes
[May 17]
Police          4-2     Game Boys        
[May 18]
Express         3-0     Mbarara
Akol             -      Simba
Top TV          2-2     URA
Kinyara         0-0     Masaka
Iganga          0-4     KCC

[May 21]
Simba           ppd     Villa
Mbarara         2-0     Police
Buikwe          1-1     Heroes
Masaka          1-0     Top TV

[May 25]
Mbarara         2-2     Kinyara
[May 27]
Police          2-2     Heroes
[May 30]
Game Boys       1-2     Mbarara
[May 31]
Iganga          3-2     Mbarara
Heroes          ann     Akol            [annulled; originally 3-0]
[Jun 4]
Heroes          2-0     Simba           [reported 2-1; awarded?]
Akol            ann     Top TV          [annulled; originally 4-4]
Kinyara         2-0     Buikwe
[Jun 8]
Game Boys       1-2     Kinyara
Top TV          3-2     Iganga
[Jun 12]
Mbarara         0-0     Heroes
Kinyara         ann     Akol            [annulled; originally 2-0]
[Jun 15]
Iganga          0-0     Masaka
Akol            ann     Game Boys       [annulled; originally 1-1]
[Jun 18]
Simba           4-1     Iganga
Heroes          2-1     Game Boys       
[Jun 19]
Masaka LC       ann     Akol            [annulled; originally 1-0]
[Jun 21]
Iganga          2-0     Buikwe          [inferred; played later?; awarded?]
Game Boys       lt      Top TV
[Jun 22]
Mbarara         1-2     Masaka
[Jul 4]
Simba           2-2     KCC
[Jul 6]
Police          0-1     Top TV
Buikwe          0-4     Villa
[Jul 8]
KCC             4-1     Game Boys
[Jul 9]
Express         4-1     Iganga
[Jul 10]
Villa           2-0     Top TV
[Jul 11]
URA             2-0     Simba
Game Boys       2-3     Iganga
[Jul 12]
Police          1-0     Express
[Jul 13]
Mbarara         0-1     Villa           
Kinyara         0-2     KCC
[Jul 15]
Top TV          1-1     Simba
[Jul 16]
Masaka          0-1     URA
Iganga          0-1     Villa
Express         2-0     Buikwe
[Jul 17]
Police          ann     Akol            [annulled; originally 7-0]
  [Rogers Kyeyune scored 6 goals, equalling the one-match record held
   by Jimmy Kirunda and Hassan Mubiru]
[Jul 18]
KCC             ann     Akol            [annulled; originally 5-0]
Masaka          1-1     Simba
[Jul 19]
Express         2-0     Villa       
[Jul 20]
Iganga          0-1     Kinyara
Game Boys       0-2     URA     
[Jul 23]
Masaka          5-0     Heroes
KCC             0-0     URA
[Jul 24]
Simba           1-1     Police
[Jul 25]
Villa           0-0     Masaka
[Jul 26]
URA             1-0     Kinyara         [inferred]
Game Boys       0-3     Express
Mbarara         0-2     Buikwe          [inferred]
[Jul 27]
KCC             4-1     Top TV
Akol            ann     Simba           [annulled; originally 1-2]
[Jul 29]
Villa           7-0     Game Boys
[Jul 30]
Express         3-0     Kinyara
Buikwe          0-3     KCC
Akol            ann     Mbarara         [annulled; originally 1-0]
[Jul 31]
Police          1-1     Masaka
[Aug 1]
URA             4-1     Mbarara
[Aug 5]
TOP TV          awd     Mbarara         [awarded 2-0; Mbarara dns]      
Akol            ann     URA             [annulled, originally 1-2]
[Aug 6]
Buikwe          2-0     Game Boys
Heroes          4-1     Iganga
[Aug 9]
Villa           0-0     KCC
[Aug 10]
Buikwe          2-1     Police
Express         2-1     Simba
Kinyara         1-0     Heroes
[Aug 12]
Simba           0-0     Buikwe
[Aug 13]
URA             0-2     Villa
Iganga          0-0     Police
[Aug 14]
KCC             2-2     Masaka
[Aug 15]
TOP TV          3-1     Kinyara       
[Aug 16]
Heroes          awd     Express         [awarded 0-2; abandoned at 0-0 in 85']  
Simba           0-3     Villa
[Aug 17]
Akol            ann     Iganga          [annulled, originally 0-2]
Mbarara         1-4     KCC             [Mbarara officials say the team
   playing KCC was not Mbarara, as they had failed to raise a team, but
   Ngabo Academy boys]
[Aug 19]
Police          0-0     URA
[Aug 20]
Masaka          awd     Game Boys       [awarded 2-0, Game Boys dns]
[Aug 22]
URA             2-0     Iganga          [inferred]
[Aug 23]
Akol            ann     Express         [annulled, originally 1-2]
  [FUFA president Obua, present at the game, had to draw his gun at
   one stage in order to have the match continued]
KCC             2-1     Police
Heroes          1-2     Top TV
Buikwe          0-2     Masaka
[Aug 24]
Game Boys       0-1     Simba
[Aug 25]
URA             awd     Buikwe          [awarded 2-0, Buikwe dns]
[Aug 26]
KCC             2-0     Heroes
[date unknown]
TOP TV          1-0     Buikwe          [inferred]
[Aug 27]
Masaka          0-2     Express
Villa           ann     Akol            [annulled; originally 22-1;
   Akol showed up with only 9 players, some of them ineligible; a match
   was played with Hakim Magumba scoring 7 and Villa leading 12-0
   at half-time; awarded 2-0 on Sep 9, following an investigation 
   of incidents before the match (a bus with Akol players stopping
   before reaching the match venue, apparently after Express (who had 
   an interest in preventing Akol from playing and so restricting 
   Villa to a 2-0 win) induced the bus driver and some players not 
   to reach the venue; the Akol team split into two groups, one 
   reaching the stadium and one going off to another destination)]
Kinyara         1-2     Police
[Aug 28]
Simba           awd     Mbarara         [awarded 2-0; Mbarara dns]      
Buikwe          n/p     Akol
[Aug 29]
Heroes          0-0     URA
Simba           0-2     Kinyara         [inferred]
[Aug 30]
KCC             1-3     Express
[Sep 1]
Express         1-0     URA
  [URA protested the result after controversial refereeing saw
   two URA players sent off and Express awarded two penalties, one
   converted for the winning goal; their protest was thrown out]
Villa           2-0     Police
[Sep 4]
Kinyara         0-2     Villa
TOP TV          awd     Express         [awarded 0-2; abandoned at 0-2 
                                         in 1st half; TOP TV relegated]

Final Table:
  
 1.SC Villa (Kampala)                27 23  3  1 53- 4 72  [2-0]  Champions
 2.Express Red Eagles (Kampala)      27 23  3  1 55- 9 72  [2-1]
 3.Kampala City Council              27 16  5  6 52-25 53  [5-0]
 4.URA SC (Kampala)                  27 15  8  4 37-16 53  [2-1]  [*]
 5.Masaka Local Council              27 13  8  6 32-18 47  [1-0]  
 6.SC Simba (Lugazi)                 27 11  5 11 35-33 38  [2-1]
 7.Police (Jinja)                    27  9  9  9 34-29 36  [7-0]   
 8.Mbale Heroes                      27  9  6 12 28-35 33  [3-0] 
 9.Kinyara Sugar Works FC (Masindi)  27  9  5 13 27-37 32  [2-0]  
10.Tower Of Praise TV (Kampala)      27  8  7 12 31-41 31  [4-4]
---------------------------------------------------------
11.Iganga Town Council               27  9  4 14 27-42 31  [2-0] 
12.Buikwe Red Stars (Mukono)         27  6  4 17 17-42 22         Relegated
13.Mbarara United                    27  4  3 20 27-58 16  [0-1]  Relegated
14.Game Boys FC (Tororo)             27  3  2 22 21-59 11  [1-1]  Relegated 
15.Akol FC (Lira)                    14  1  2 11  7-35  5  [*1]   Relegated

 [*] the merger of URA and Lyantonde was dissolved before the start of the
     season; URA abbreviates Uganda Revenue Authority 
[*1] all matches Akol in 2nd half of season annulled; relevant results of
     opponents indicated between square brackets

NB: FUFA's Executive Committee awarded Villa the league title following 
    matches on Sep 4; FUFA president Denis Obua was unhappy with this 
    decision and set up a new committee.
    A later committee set up by the National Sports Council published
    findings so damning to FUFA that they decided to ignore it.
    On Jan 8, 2004, FUFA announced SC Villa (who had already been
    registered for the African Champions League in December) were
    indeed 2003 league champions.

NB: eventually both TOP TV and Iganga TC remained at top level

NB: Game Boys unsuccessfully tried to buy or merge with newly promoted
    Moyo Town Council FC in order to retain their place

Topscorer (Jul 31):

16 Hassan Mubiru (Express) 


NB: 2004 Super League to start Jan 30 with 16 clubs (following the
    re-instatement of TOP TV).



Author: Hans Schöggl

Last updated: 27 Aug 2010

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


  USO DE MEMORIA  
4,314,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0970
Total Execution Time  0.0989
  CADENA URL  
/super_league_uganda2003
  GET DATOS  
$_GET['/super_league_uganda2003']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0017  SELECT type FROM routes WHERE alias = 'super_league_uganda2003'
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 = 2003 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.0021  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.0022  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.0023  SELECT text_es as historical_text FROM leagues_text WHERE id=1014
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 = 29336 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='2003' 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-18 12:20:43' 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-18 12:20:43' 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-18 12:20:43' 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-18 12:20:43' 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 = 2003 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 events2003 e WHERE e.league_id IN (29336) 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 (29336) 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 events2003 e WHERE e.league_id IN (29336) 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 (29336) 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 events2003 e WHERE e.league_id IN (29336) 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 (29336) 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 events2003 e WHERE e.league_id IN (29336) 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 (29336) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  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 = 29336 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0017  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 = 29336 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0022  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=29336 AND rel.round=27
0.0019  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 = 29336 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 = 29336 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-19" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29336 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-19" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29336
0.0020  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 `calendars2003` 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` = 29336 AND c.`round` = 27 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 `events2003` e INNER JOIN calendars2003 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 = 27 AND e.real_date IS NOT NULL AND e.league_id = 29336 ORDER BY total DESC LIMIT 40
0.0023  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 `events2003` e INNER JOIN calendars2003 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 = 29336 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0022  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 `tables2003` 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 = 29336 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2003` 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 = 29336 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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-18 00:00:00' AND c.`shedule` < '2024-04-22 23:59:59' AND l.id = 29336 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0022  SELECT data1, data2 FROM services_tags WHERE categoryId=481
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 481 AND l.year = 2003 ORDER BY l.group_code ASC
0.0022  SELECT group_code, extraName from `leagues` WHERE categoryId=481 AND year=2003