4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Liga Botsuana 2003
2002/2003

Liga Botsuana 2003

Información Histórica
						
NB: after the 2001/02 season, an alternative FA (called Botswana Soccer
    Association, BOSA) was formed, including Centre Chiefs, Notwane, 
    Township Rollers,  Gaborone United, Mokgosi, Black Peril, Gabane Santos, 
    Miscellaneous, Orapa Bucs, Boteti Young Fighters and Rhinos; Tafic
    joined later, possibly others followed.  This new FA was not recognised
    by FIFA  (in contrast to the 'old' BFA).  The 2002/03 championship was
    supposed to start Sep 8, but was postponed.  In November, Extension
    Gunners joined the BOSA as well.

    In February 2003, BOSA and BFA found an agreement, with the new
    season to start on Feb 22/23.
 
Mini-League 2003

NB: played as single round robin (all teams play each other once)

Round 1 [Feb 22-26]
BMC      2-0 Gunners
Fighters 4-0 Notwane
Satmos   4-3 TASC
Comets   n/p BDF          [Comets dns]

Round 2 [possibly postponed]
Gunners   -  Prisons
Police    -  Comets
Tafic     -  BDF

[Mar 14]
TASC      -  BMC
Notwane   -  Tafic
Satmos   bt  Chiefs
[Mar 15]
Gunners   -  Police
[Mar 19]
Chiefs    -  Notwane

Round 4
Fighters bt  TASC
Police   bt  Satmos
Tafic    lost 2-3
BDF      ppd Notwane
Fighters and Police lead with 10 points from 4 matches

Round 5? [Apr 5,6]
Fighters  -  Comets
Tafic    2-3 Chiefs
BMC       -  Satmos
Police    -  Prisons
Gunners   -  BDF

[Apr 11]
Gunners   -  Fighters
Satmos    -  Prisons
Police    -  BMC
Chiefs   n/p TASC         [stadium booked for rugby match]
[Apr 12]
Tafic     -  BDF

[Apr ?]
Notwane   -  Police
Chiefs   2-0 Gunners

[Apr 20,21]
BMC       -  Notwane
TASC      -  Prisons
Satmos    -  Tafic
Comets    -  Chiefs

Leaders: Police
Chiefs     4     7 pts. 

[Apr 26,27]
Police   0-1 Chiefs
Tafic    3-1 Gunners
Satmos    -  Comets
BMC       -  Prisons
BDF       -  TASC

Leading: Fighters and Police XI ("neck to neck")

[May 3,4]
Fighters 2-0 BMC
BDF       -  Satmos
Tafic     -  TASC
Notwane  0-3 Comets

Table:

 1.Centre Chiefs 8       19
 .
 5.BDF XI        6       11

[May 10,11] 
BMC       -  Comets
Satmos    -  Notwane
TASC      -  Gunners
Fighters  -  Tafic
Chiefs    -  BDF

[Jun 2?]
BDF      2-0 Comets

[Jul 1]
Notwane   -  BDF
Chiefs    -  Fighters 

Top Final Table (after single round robin):

 1.Police                       25 pts
 2.Mogoditshane Fighters        24 pts

NB: as Police only gained 25 points after winning a protest against
    Centre Chiefs, a replay between the top-2 teams is staged, as
    the rules say that a team winning points by protest can only win
    the league outright if they are at least 4 points clear of the
    runners-up

Championship Playoff [Aug 6]
Fighters 2-1 Police


Super League will have 16 teams in 2004; both groups (North and
South) of First Division will have 12 each; third level will consist
of 14 regional leagues.


Coca-Cola Cup 2003 

64  participants

Preliminaries
[Jun 21,22]   
Rolling Stars           1-1     Teletswana            [3-5 pen]
Kopang Classic          lt      Kanye Swallows
[date?]
Gantsi Terrors          lt      Guff Gantsi
  [possibly awd to Terrors because Guff used an ineglible player]

NB: 12 top level teams and leaders of two First Division leagues only
    enter in round 2


Round 1
Debswana Young Stars    1-0     Kanye Swallows

Round 3 [Jul 19,20]
Boteti Young Fighters   lt      Centre Chiefs
Motlakase               1-0     Prisons
Red Lions               1-2     Jwaneng Comets        [asdet]
Tlokweng U.             0-1     Mogoditshane Fighters
Malaria Bugs            0-1     Gaborone U.
Debswana Young Stars    0-4     Notwane
Cosmos Blizzards        1-2     Ecco City             [asdet]
Blue Diamonds           2-0     Satmos
Stonebreakers           lt      BMC

Round 4 [Aug 2,3]
Gaborone United         0-1     Tafic
BMC                     0-1     Comets
Mogoditshane Fighters   2-0     Notwane
Nico                    lt      Police
TASC                    2-2     Rollers               [2-4 pen]
Ecco City               drw     Gunners               [6-5 pen]
Blue Diamonds           lt      BDF
Motlakase               lt      Centre Chiefs

Quarterfinals
[Aug 9]
Rollers                 drw     Comets                [5-2 pen]
Tafic                   drw     Centre Chiefs         [4-2 pen]
[Aug 10]
Fighters                drw     Police                [8-7 pen]
[Aug 13?]
Ecco City               2-1     BDF

Semifinals [Aug 16]
Mogoditshane Fighters   2-0     Ecco City
Township Rollers        3-0     Tafic                 [also reported 3-1]

Third Place Playoff [Aug 17?]
Ecco City               1-1     Tafic                 [5-4 pen]

Final [Aug 30, National Stadium]
Mogoditshane Fighters   1-0     Township Rollers
  [Mompati Banda 52]

NB: Tafic are also known as Matjimenyenga


Independence Cup [Start Aug 16]

1/8 Finals
Group A
Police XI                -      Satmos
Extension Gunners       lt      BMC
Group B         
Mogoditshane Fighters   0-2     Notwane
Tafic                   lt      Prisons XI
Group C 
BDF XI                  bt      Nico United 
Jwaneng Comets          lt      TASC 
Group D 
Wonder Sporting         1-3     Township Rollers 
Mochudi Centre Chiefs    -      Boteti Young Fighters

Quarterfinals [Sep 6,7]
between winners 1/8 finals within the same group
Group A
BMC                     bt      Satmos or Police
Group B
Notwane                 3-2     Prisons               [asdet]    
Group C
TASC                    bt      BDF XI    
Group D
Township Rollers        bt      Chiefs (or Young Fighters?)

Semifinals [Sep 13,14] 
BMC                     4-2     TASC
Notwane                 2-1     Township Rollers      [asdet]

Final [Sep 30]
BMC                     0-2     Notwane



Orange Kabelano Charity Cup (6th edition) (one-day event)

Participants: Gaborone United, Notwane, Centre Chiefs,
              Township Rollers

Winners: Gaborone United


Author:
Hans Schöggl (hans.schoeggl@sbg.ac.at) Last updated: 13 Aug 2006 (C) Copyright Hans Schöggl and RSSSF 2003/06

INFORMACIÓN

La primera edición se disputó en el año 1966 con el nombre de MLO Cup. En ella participaron equipos como el Tlokweng Pirates, Notwane, Black Peril, Queens Park Rangers y un equipo del distrito de Ngwaketse. La competición ha estado, históricamente, dominada por los equipos del sur de país, hasta la temporada 2006/07 en la que el ECCO City Greens se convirtió en el primer equipo del norte en ganar la competición.

  USO DE MEMORIA  
4,278,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6725
Total Execution Time  0.6744
  CADENA URL  
/liga_botsuana2003
  GET DATOS  
$_GET['/liga_botsuana2003']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0144  SELECT type FROM routes WHERE alias = 'liga_botsuana2003'
0.0293  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_botsuana' 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.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=329 AND type_rel = 3
0.0149  SELECT text_es as historical_text FROM leagues_text WHERE id=125
0.0151  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 = 28410 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153  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=329 GROUP BY c.id ORDER BY c.order_id ASC
0.0145  SELECT type,rule FROM rules WHERE categoryId = 329 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 02:54:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 02:54:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 02:54:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 02:54:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0154  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_botsuana' 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.0149  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (28410) 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.0149  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 (28410) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0149  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (28410) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0144  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 (28410) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (28410) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (28410) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (28410) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0146  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 (28410) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  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 = 28410 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0145  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 = 28410 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0145  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 329 GROUP BY l.categoryId
0.0144  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=329 GROUP BY l.year ORDER BY l.year DESC
0.0148  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=28410 AND rel.round=10
0.0147  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 = 28410 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0146  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 = 28410 AND esl.points > 0
0.0145  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-04-04" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28410 ORDER BY creation_date DESC LIMIT 0, 10
0.0149  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-04-04" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28410
0.0147  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` = 28410 AND c.`round` = 10 ORDER BY shedule ASC LIMIT 200
0.0145  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 = 10 AND e.real_date IS NOT NULL AND e.league_id = 28410 ORDER BY total DESC LIMIT 40
0.0152  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 = 28410 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0147  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 = 28410 AND t.round = 8 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 28410 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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-05-04 00:00:00' AND c.`shedule` < '2024-05-08 23:59:59' AND l.id = 28410 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0147  SELECT data1, data2 FROM services_tags WHERE categoryId=329
0.0147  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 329 AND l.year = 2003 ORDER BY l.group_code ASC
0.0147  SELECT group_code, extraName from `leagues` WHERE categoryId=329 AND year=2003