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

Liga Uganda 2002

Información Histórica 
						Final Table (as reported by FUFA):
  
 1.SC Villa (Kampala)                28 26  1  1 62- 9 79  Champions
 2.Express Red Eagles (Kampala)      28 21  3  4 62-20 66
 3.Kampala City Council              28 20  4  4 47-20 64 
 4.Lyantonde/URA (Kampala)           28 11 13  4 28-20 46
 5.Police (Jinja)                    28 11 11  6 34-25 44
 6.SC Simba (Lugazi)                 28 13  4 11 33-26 43  
 7.Masaka Local Council              28 10 11  7 30-21 41
 8.Iganga Town Council               28  8  9 11 24-32 33
 9.Mbale Heroes                      28  8  9 11 25-34 33 
10.Mbarara United                    28  9  5 14 30-46 32
---------------------------------------------------------
11.SCOUL (Lugazi)                    28  6  7 15 21-39 25  [=]
12.Maji FC (Kampala)                 28  7  2 19 25-53 23       
13.Nile FC/Military Police (Jinja)   28  6  4 18 26-43 22  [*]
14.Arua Garage (Mbale)               28  5  5 18 26-48 20  [*]
15.Kasese Town Council               28  1  6 21 14-53  9

NB: 2 more losses than wins, total goal difference -2, apparently
    due to award Simba vs Kasese

[*] promoted club Nile FC and relegated club Military Police merged; 
    promoted club Arua United merged with Garage FC (Mbale), who lost 
    a promotion final 2001; Arua Garage were moved from Lira to Mbale
    for security reasons in August 2002.
[=] SCOUL abbreviates Sugar Corporation Of Uganda Limited.

NB: Kasese had a 3 point deduction for fielding Med Tamale, allegedly
    ineligible, against Mbarara, revoked on appeal.

[Feb 16]
KCC           1-1 Police
[Feb 17]
Heroes        2-1 Maji
Kasese        0-1 Simba
Mbarara       1-1 Masaka
Nile-Military 1-2 Iganga
[Feb 19]
Lyantonde/URA 1-0 Simba
Police        0-0 SCOUL
[Feb 20] 
Maji          6-1 Arua Garage
[Feb 23]
Kasese        2-2 Police
Iganga        2-1 Mbarara
KCC           2-0 Maji
[Feb 24]
Heroes        1-2 Mbarara
SCOUL         0-0 Lyantonde/URA
[Feb 26] 
Express       1-1 Police
[Feb 27]
Simba         0-2 KCC
[Mar 1]
Maji          1-2 Nile/Mil.P.
[Mar 2]
Iganga        0-0 Heroes
Express       5-0 Kasese
SCOUL         2-1 Mbarara
[Mar 4] 
Masaka        0-0 Kasese
[Mar 5] 
Maji          0-0 Simba
[Mar 6]
Lyantonde/URA 0-0 Police
Arua Garage   2-2 Heroes
[Mar 7]
Nile/Mil.P.   1-1 Masaka
Kasese        1-1 SCOUL
[Mar 10]
Heroes        0-0 Kasese
[Mar 12]
Mbarara       0-0 Lyantonde/URA
Simba         3-0 Arua Garage
[Mar 13] 
Police        1-0 Iganga
Masaka        0-1 Express
[Mar 14]
KCC           2-1 Arua Garage
[Mar 15]
Masaka        1-1 Lyantonde/URA 
SC Villa      2-0 Iganga
[Mar 16]
Maji          0-6 Express
Mbarara       1-0 Simba         
Nile/Mil.P.   2-3 SCOUL
[Mar 17]
Heroes        awd KCC             [awarded 0-2; abandoned at 1-2 in 70']
[Mar 20] 
Lyantonde/URA 1-0 Kasese
Arua Garage   2-3 Mbarara
[Mar 22] 
Masaka        2-1 Maji      
Nile/Mil.P.   ppd Heroes
[Mar 26]
Simba         1-0 SCOUL
[Mar 27] 
Arua Garage   0-0 Kasese
Masaka        1-0 Iganga
Police        0-1 SC Villa
[Mar 29] 
Maji          3-1 Kasese
SCOUL         1-2 KCC
[Mar 30] 
Express       0-0 SC Villa
[Apr 1] 
Iganga        1-2 Maji
Kasese        awd Mbarara         [awarded 0-2, originally 1-1, 
Lyantonde/URA 0-0 Heroes           ineligible player Kasese]
[Apr 2] 
SC Villa      3-1 Masaka
[Apr 3] 
Arua Garage   2-1 Nile/Mil.P.
[Apr 5] 
SCOUL         1-3 Heroes
[Apr 6]
Kasese        0-1 SC Villa        
Simba         4-5 Express
[Apr 7]
Iganga        2-1 KCC
[Apr 9] 
SC Villa      4-0 Maji
[Apr 10] 
Police        0-1 Masaka
Nile/Mil.P.   2-1 Mbarara
Arua Garage   1-0 SCOUL
[Apr 11] 
Heroes        0-1 Simba
Lyantonde/URA 1-1 Iganga
[Apr 16]
Masaka        3-3 Arua Garage
Nile/Mil.P.   0-0 Lyantonde/URA
Police        5-0 Maji
[Apr 17]
Simba         2-0 Iganga
[Apr 18]
Lyantonde/URA 2-0 Arua Garage
[Apr 18]
SC Villa      3-1 Heroes
[Apr 21]
SCOUL         1-0 Iganga
Mbarara       2-4 SC Villa
[Apr 22]
KCC           1-1 Nile/Mil.P.
[Apr 23]
Express       awd Arua Garage     [awarded 2-0, originally 1-1]
[Apr 24] 
Mbarara       3-0 Maji
[Apr 25]
Simba         1-1 Masaka
Iganga        2-2 Kasese
[Apr 28]
Heroes        0-0 Police
Kasese        awd Nile/Mil.P.     [Nile/Mil.P. dns; awarded 2-0]
[Apr 30]
Maji          0-2 SCOUL
[May 1]
SC Villa      1-0 Simba
[May 2]
Express       2-0 Mbarara
[May 3]
Masaka        2-0 Heroes 
[May 4] 
Mbarara       0-1 Police
[May 5]
Iganga        1-3 Express
KCC           0-1 SC Villa
[May 6]
SCOUL         0-1 Masaka
Nile/Mil.P.   1-2 Heroes
[May 8]
KCC           1-0 Lyantonde/URA
Arua Garage   0-2 SC Villa
[May 9] 
Simba         2-0 Nile/Mil.P.
SCOUL         awd Express         [abandoned at 1-1, awarded 0-2]
[May 11]
Kasese        0-3 KCC
[May 12]
SC Villa      1-0 Nile/Mil.P.
Arua Garage   1-1 Police
[May 14]
Maji          1-3 Lyantonde/URA   [protest running]
[May 15]
KCC           1-0 Masaka
Heroes        awd Express         [abandoned at 0-2 in 44', awarded 0-2]
[May 16]
Police        0-2 Simba
[May 18]
Mbarara       1-2 KCC
Nile/Mil.P.   1-2 Express
SC Villa      1-0 SCOUL
Iganga        1-0 Arua Garage
[May 22]
Express       4-1 Lyantonde/URA
[May 23]
Police        2-1 Nile/Mil.P.
[May 25]
Express       0-1 KCC
[May 26]
Lyantonde/URA 0-2 SC Villa

[Jun 21]
SC Villa      0-1 Police 
[Jun 22]
Express       2-1 Masaka 
Mbarara       0-0 SCOUL        
Arua Garage   3-1 Heroes 
[Jun 23]
Kasese        0-2 Maji 
Iganga        1-1 Nile/Mil.P.
Lyantonde/URA 3-1 KCC             [protest KCC on allegedly ineligible player]
[Jun 25]
Simba         2-3 SC Villa 
[Jun 26] 
Express       3-0 Nile/Mil.P. 
SCOUL         1-1 Police 
[Jun 27]
Nile/Mil.P.    -  Maji 
KCC           1-1 Iganga 
[Jun 28] 
Masaka        1-0 Simba 
[Jun 29]
Heroes        2-1 SCOUL 
Mbarara       awd Kasese          [awarded 2-0, Kasese dns] 
SC Villa      1-0 Express 
[Jun 30]
Masaka        0-1 KCC 
[Jul 2]
Heroes        1-1 Lyantonde/URA 
Iganga        2-0 Simba 
Police        1-2 Mbarara 
[Jul 3]
SCOUL         1-3 Villa 
Maji          0-1 KCC 
Nile/Mil.P.   awd Kasese          [awarded 2-0, Kasese dns] 
Arua Garage   2-2 Masaka 
[Jul 5]
Express       2-1 Heroes 
[Jul 6] 
Kasese        0-2 Arua Garage 
Maji           -  Police 
Iganga        0-2 SC Villa 
[Jul 7]
SCOUL         1-2 Nile/Mil.P. 
Mbarara       1-0 Arua Garage
[Jul 8]
Police        0-1 Express 
[Jul 9]
Simba         0-0 Lyantonde/URA   [also reported 1-1]
[Jul 10]
Arua          awd Maji            [abd at 0-1 in 21', awarded 0-2]
Masaka        2-0 Nile/Mil.P.
SC Villa      5-1 Kasese
[Jul 11]
KCC           3-0 Mbarara 
[Jul 13]
Nile/Mil.P.    -  Masaka 
Lyantonde/URA 0-0 Maji            [inferred]
Kasese         -  Heroes 
Express       2-1 Iganga 
[Jul 14]
Mbarara       1-1 Heroes 
[Jul 15]
KCC           5-1 SCOUL 
[Jul 16]
Iganga        1-0 Masaka 
Police         -  Lyantonde/URA 
Nile/Mil.P.   0-2 SC Villa 
[Jul 17]
Simba         3-2 Mbarara 
[Jul 18]
SCOUL         2-1 Kasese 
[Jul 19]
Maji          0-1 SC Villa        [inferred]
[Jul 20]
Express       0-0 Simba 
Lyantonde/URA 0-0 Masaka 
Mbarara       1-1 Iganga 
Heroes        1-0 Nile/Mil.P. 
[Jul 21]
Kasese        awd Iganga          [awarded 0-2 to Iganga, originally 1-1, 
[Jul 23]                           ineligible player]
SCOUL         1-0 Arua 
[Jul 24]
Police         -  Kasese 
Nile/Mil.P    awd KCC             [awarded 0-2, originally 2-0, ineligible 
[Jul 25]                           player]
Maji          2-0 Mbarara 
[Jul 26]
Simba         1-2 Heroes
[Jul 27]
Iganga         -  Police 
[Jul 28]
Lyantonde/URA 3-0 Mbarara 
[Jul 30]
Iganga        0-0 SCOUL 
KCC           2-0 Simba
[Jul 31]
Mbarara        -  Nile/Mil.P.
Arua Garage    -  Lyantonde/URA 
[Aug 3]
Lyantonde/URA 2-1 SCOUL 
[Aug 4]
Heroes        0-0 Masaka 
[Aug 7]
Nile/Mil.P.   2-1 Arua Garage 
Maji          0-2 Masaka
[Aug 11]
Arua Garage   1-2 Simba
Iganga        0-0 Lyantonde/URA 
Kasese        0-2 Masaka 
[Aug 14]
Masaka        4-0 Mbarara 
Maji          0-2 Heroes 
[Aug 15]
Nile/Mil.P.   2-0 Simba 

[suspension league due to ANC qualifier against Ghana]

[Sep 11]
Maji          1-3 Express        
Masaka        1-1 Police
Arua Garage   0-1 KCC
[Sep 12]
Villa         6-0 Lyantonde/URA
SCOUL         0-1 Simba
[Sep 14]
KCC           2-0 Heroes
SCOUL         0-2 Maji
Kasese        0-3 Lyantonde/URA   [inferred]
[Sep 15]
Arua Garage   4-0 Iganga
[Sep 16]
Police        3-2 Kasese
[Sep 17]
KCC           3-2 Kasese
[Sep 18]
Police        2-1 Nile/Mil.P.
Maji          0-1 Iganga
[date? - inferred]
Masaka        0-0 SCOUL 
Simba         awd Kasese          [apparently awarded a 0-2 loss against both] 
[Sep 19]
Express       5-1 SCOUL
[Sep 20]
SC Villa      2-0 KCC
[Sep 22]
Heroes        1-1 Iganga
[Sep 23]
Lyantonde/URA 1-0 Nile/Mil.P.
[Sep 25]
Arua Garage   0-3 Lyantonde/URA
[Sep 27]
SC Villa      awd Arua Garage     [awarded 2-0, Arua Garage dns] 
Mbarara       1-3 Express
[Sep 28]
Police        2-2 KCC
[Sep 29]
Heroes        0-2 SC Villa 
Kasese        0-2 Express
[Oct 1]
Police        1-0 Heroes
[Oct 2]
Lyantonde/URA 2-1 Express
Masaka        0-1 SC Villa 
[Oct 3]
Police        awd Arua Garage     [awarded 2-0, Arua Garage dns] 
[Oct 4]
Simba         4-0 Maji
[Oct 5]
SC Villa      6-0 Mbarara
Arua Garage    -  Express
[Oct 7]
Lyantonde/URA 0-0 Police
[Oct 10]
Simba          -  Police
[Oct 11?]
Iganga        1-2 Police
[Oct 12]
KCC            -  Express 

Final Table (as reported by FUFA):
  
 1.SC Villa (Kampala)                28 26  1  1 62- 9 79  Champions
 2.Express Red Eagles (Kampala)      28 21  3  4 62-20 66
 3.Kampala City Council              28 20  4  4 47-20 64 
 4.Lyantonde/URA (Kampala)           28 11 13  4 28-20 46
 5.Police (Jinja)                    28 11 11  6 34-25 44
 6.SC Simba (Lugazi)                 28 13  4 11 33-26 43  
 7.Masaka Local Council              28 10 11  7 30-21 41
 8.Iganga Town Council               28  8  9 11 24-32 33
 9.Mbale Heroes                      28  8  9 11 25-34 33 
10.Mbarara United                    28  9  5 14 30-46 32
---------------------------------------------------------
11.SCOUL (Lugazi)                    28  6  7 15 21-39 25  [=]
12.Maji FC (Kampala)                 28  7  2 19 25-53 23       
13.Nile FC/Military Police (Jinja)   28  6  4 18 26-43 22  [*]
14.Arua Garage (Mbale)               28  5  5 18 26-48 20  [*]
15.Kasese Town Council               28  1  6 21 14-53  9

NB: 2 more losses than wins, total goal difference -2, apparently
    due to award Simba vs Kasese

[*] promoted club Nile FC and relegated club Military Police merged; 
    promoted club Arua United merged with Garage FC (Mbale), who lost 
    a promotion final 2001; Arua Garage were moved from Lira to Mbale
    for security reasons in August 2002.
[=] SCOUL abbreviates Sugar Corporation Of Uganda Limited.

NB: Kasese had a 3 point deduction for fielding Med Tamale, allegedly
    ineligible, against Mbarara, revoked on appeal.

Leading scorer: Mubiru (Express)  22 goals.

Express have chosen to enter CAF Cup (as league runners-up) rather
than the Cup Winners Cup (as losing cup finalists), meaning Police
will play the Cup Winners Cup 2003.


Author: Hans Schöggl 
Last updated: 27 Aug 2010

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


  USO DE MEMORIA  
4,297,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1011
Total Execution Time  0.1030
  CADENA URL  
/super_league_uganda2002
  GET DATOS  
$_GET['/super_league_uganda2002']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0020  SELECT type FROM routes WHERE alias = 'super_league_uganda2002'
0.0052  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 = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0027  SELECT text_es as historical_text FROM leagues_text WHERE id=1012
0.0028  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 = 29334 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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='2002' WHERE c.parentId=481 GROUP BY c.id ORDER BY c.order_id ASC
0.0023  SELECT type,rule FROM rules WHERE categoryId = 481 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-18 04:28:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-18 04:28:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-18 04:28:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-18 04:28:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0032  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 = 2002 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 events2002 e WHERE e.league_id IN (29334) 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 (29334) 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 events2002 e WHERE e.league_id IN (29334) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0020  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 (29334) 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 events2002 e WHERE e.league_id IN (29334) 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 (29334) 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 events2002 e WHERE e.league_id IN (29334) 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 (29334) 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 = 29334 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 = 29334 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=29334 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 = 29334 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 = 29334 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-19" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29334 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-19" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29334
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 `calendars2002` 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` = 29334 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 `events2002` e INNER JOIN calendars2002 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 = 29334 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 `events2002` e INNER JOIN calendars2002 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 = 29334 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0023  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 `tables2002` 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 = 29334 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2002` 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 = 29334 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 29334 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0023  SELECT data1, data2 FROM services_tags WHERE categoryId=481
0.0023  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 481 AND l.year = 2002 ORDER BY l.group_code ASC
0.0023  SELECT group_code, extraName from `leagues` WHERE categoryId=481 AND year=2002