4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
 
Temporada 2010
Temporada Siguiente »
Publicidad 600x120.gif
Liga Burundi 2010
2009/2010

Liga Burundi 2010

Información Histórica 
						
Final Table:

 1.Vital'ô (Bujumbura)                 22 18  2  2  57-16  56  Champions
 2.Inter Star (Bujumbura)              22 13  6  3  41-18  45
 3.Athlético Olympic (Bujumbura)       22 13  5  4  47-21  44
 4.LLB Académic (Bujumbura)            22 10  5  7  46-23  35  [*]
 5.Académie Tchité FC (Bujumbura)      22  8  9  5  29-22  33
 6.Prince Louis (Bujumbura)            22  8  8  6  26-27  32
 7.Muzinga (Bujumbura)                 22  6  9  7  27-25  27
 8.Espoir (Mutimbuzi)                  22  5  7 10  22-40  22
 9.Flamengo de Ngagara (Bujumbura)     22  5  6 11  24-39  21
10.Union Sporting (Bujumbura)          22  4  8 10  23-44  20
-------------------------------------------------------------
11.Wazee (Rumonge)                     22  4  7 11  16-37  19  Relegated
12.Delta Star de Gatumba (Mutimbuzi)   22  0  4 18  10-56   4  Relegated

[*] full name Lydia Ludic Burundi Académic
 
Round 1
[Dec 24]
Flamengo            2-1 Delta Star
[Dec 26]
Espoir              0-4 Vital'ô
Muzinga             4-1 Wazee
[Dec 27]
Prince Louis        2-1 Inter Star
Athlético Olympic   1-0 LLB Académic
[Jan 13]
Académie Tchité     2-0 Union Sporting   
 
Round 2
[Jan 2]
Wazee               1-0 Espoir
Delta Star          1-2 Académie Tchité
Union Sporting      1-1 Flamengo
Prince Louis        0-0 LLB Académic
[Jan 3]
Vital'ô             1-1 Muzinga
Athlético Olympic   1-2 Inter Star   
 
Round 3
[Jan 8]
LLB Académic        0-1 Inter Star
Prince Louis        0-3 Athlético Olympic
[Jan 9]
Union Sporting      1-0 Wazee
Académie Tchité     2-0 Muzinga
[Jan 10]
Vital'ô             1-0 Delta Star
Espoir              2-1 Flamengo
 
Round 4
[Jan 16]
Inter Star          2-1 Espoir
LLB Académic        1-2 Vital'ô
Wazee               0-1 Prince Louis
Delta Star          0-2 Muzinga
[Jan 17]
Flamengo            1-3 Académie Tchité
Athlético Olympic   7-1 Union Sporting
 
Round 5
[Jan 23]
Muzinga             1-1 Athlético Olympic
Union Sporting      0-6 Inter Star
Wazee               0-1 LLB Académic
Espoir              1-1 Delta Star   
[Jan 24]
Académie Tchité     0-0 Prince Louis
Vital'ô             6-0 Flamengo
 
Round 6
[Jan 29] 
Prince Louis        0-1 Vital'ô
[Jan 30]
Espoir              1-1 Muzinga
Athlético Olympic   4-1 Wazee
LLB Académic        0-1 Flamengo
[Jan 31]
Union Sporting      2-1 Delta Star
Inter Star          1-1 Académic Tchité
 
Round 7
[Feb 6]
Espoir              0-0 Athlético Olympic
Flamengo            1-3 Inter Star
Vital'ô             4-1 Union Sporting
[Feb 7]
LLB Académic        2-1 Delta Star
Prince Louis        1-1 Muzinga
Wazee               0-0 Académie Tchité
 
Round 8
[Feb 20]
Flamengo            0-1 Prince Louis
Vital'ô             1-0 Wazee
Athlético Olympic   1-0 Delta Star
[Feb 21]
Inter Star          2-1 Muzinga
[Feb 26]
Académie Tchité     2-2 Espoir
Union Sporting      0-3 LLB Académic   
 
Round 9 
[Mar 6] 
Flamengo            0-0 Wazee       
[Apr 3]
Muzinga             1-2 Union Sporting  
[Apr 7]
Académie Tchité     1-3 LLB Académic   
[Apr 8]
Inter Star          awd Delta Star          [awarded 2-0; abandoned at
Vital'ô             1-0 Athlético Olympic    3-0 in 5' as Delta had only
[Apr 10]                                     6 players left (they started
Espoir              2-0 Prince Louis         the match with 8)]

Round 10
[Apr 3]
LLB Académic        0-0 Espoir 
Académie Tchité     1-2 Athlético Olympic
[Apr 4]
Inter Star          2-1 Vital'ô
[Apr 7]
Muzinga             3-2 Flamengo
[Apr 11]
Delta Star          1-3 Wazee
[Apr ?]
Union Sporting      1-1 Prince Louis   

Round 11
[Mar 31?]
Delta Star          1-2 Prince Louis       
[Apr 6]
Espoir              1-1 Union Sporting
[Apr 24]
Wazee               2-2 Inter Star
Athlético Olympic   3-0 Flamengo
[Apr 25]
Vital'ô             1-0 Académie Tchité 
LLB Académic        0-0 Muzinga

Round 12
[May 7]
Académie Tchité     1-1 Vital'ô                       
[May 8]
Muzinga             1-1 LLB Académic
Flamengo            4-2 Athlético Olympic
[May 9]
Inter Star          6-0 Wazee
Union Sporting      3-3 Prince Louis

Round 13
[May 15]
Prince Louis        2-0 Espoir
Inter Star          2-0 Delta Star
[May 16]
LLB Académic        1-1 Académie Tchité
Flamengo            0-0 Muzinga
Athlético Olympic   2-3 Vital'ô

Moved Matches [May 29]
Espoir              0-2 Union Sporting
Wazee               1-1 Delta Star

Round 14
[May 16?]
Athlético Olympic   1-1 Académie Tchité
[May 29]
Vital'ô             2-0 Inter Star
[Jun 12]
Prince Louis        1-1 Delta Star
LLB Academic        7-2 Espoir
[Jun 13]
Union Sporting      0-1 Muzinga
Flamengo            1-1 Wazee      
 
Round 15
[Jun 25]
LLB Academic        3-1 Union Sporting
[Jun 26]
Vital'ô             5-0 Wazee
Espoir              4-0 Académie Tchité   
Muzinga             2-2 Inter Star
[Jun 27]
Prince Louis        2-1 Flamengo
Athlético Olympic   6-0 Delta Star      

Round 16 
[Jul 9]
LLB Academic        9-0 Delta Star
Vital'ô             2-1 Union Sporting
[Jul 10]
Wazee               1-1 Académie Tchité 
Muzinga             1-1 Prince Louis
[Jul 11]
Inter Star          1-1 Flamengo
Athlético Olympic   1-1 Espoir 
 
Round 17
[Jul 17]
Union Sporting      1-1 Delta Star 
Athlético Olympic   1-0 Wazee
Inter Star          0-0 Académie Tchité
Flamengo            1-2 LLB Academic
[Jul 18]
Muzinga             5-0 Espoir
Vital'ô             3-1 Prince Louis   
 
Round 18
[Jul 22]
Flamengo            0-3 Vital'ô             
[Jul 24]
Delta Star          0-1 Espoir
Prince Louis        2-1 Académie Tchité
Wazee               1-5 LLB Academic
[Jul 25]
Inter Star          2-1 Union Sporting      
Athlético Olympic   3-0 Muzinga             
 
Round 19
[Jul 29]
Union Sporting      2-2 Athlético Olympic   
[Jul 30]
Inter Star          2-0 Espoir
Flamengo            1-2 Académie Tchité
Muzinga             2-0 Delta Star          
[Jul 31]
Prince Louis        1-2 Wazee               
Vital'ô             2-4 LLB Academic

Round 20
[Aug 3]
Vital'ô             5-0 Delta Star          
Muzinga             0-1 Académie Tchité
[Aug 4]
Flamengo            2-1 Espoir
Wazee               0-0 Union Sporting      
Prince Louis        2-3 Athlético Olympic   
Inter Star          2-1 LLB Academic

Round 21
[Aug 6]
Athlético Olympic   1-0 Inter Star          
Muzinga             0-2 Vital'ô             
[Aug 7]
Wazee               0-1 Espoir
LLB Academic        2-3 Prince Louis        
Union Sporting      2-2 Flamengo            
[Aug 8]
Delta Star          0-6 Académie Tchité
	
Round 22
[Aug 14]
LLB Academic        1-2 Athlético Olympic   
Wazee               awd Muzinga             [awarded 2-0, forfait Muzinga
Delta Star          0-2 Flamengo             due to colour clash shirts]
Inter Star          0-0 Prince Louis        
[Aug 15]
Vital'ô             6-2 Espoir             
Union Sporting      0-1 Académie Tchité

Final Table:

 1.Vital'ô (Bujumbura)                 22 18  2  2  57-16  56  Champions
 2.Inter Star (Bujumbura)              22 13  6  3  41-18  45
 3.Athlético Olympic (Bujumbura)       22 13  5  4  47-21  44
 4.LLB Académic (Bujumbura)            22 10  5  7  46-23  35  [*]
 5.Académie Tchité FC (Bujumbura)      22  8  9  5  29-22  33
 6.Prince Louis (Bujumbura)            22  8  8  6  26-27  32
 7.Muzinga (Bujumbura)                 22  6  9  7  27-25  27
 8.Espoir (Mutimbuzi)                  22  5  7 10  22-40  22
 9.Flamengo de Ngagara (Bujumbura)     22  5  6 11  24-39  21
10.Union Sporting (Bujumbura)          22  4  8 10  23-44  20
-------------------------------------------------------------
11.Wazee (Rumonge)                     22  4  7 11  16-37  19  Relegated
12.Delta Star de Gatumba (Mutimbuzi)   22  0  4 18  10-56   4  Relegated

[*] full name Lydia Ludic Burundi Académic
 



Ligue B
Author: Hans Schöggl

Last updated: 21 Jun 2012

(C) Copyright Hans Schöggl and RSSSF 2010/12


  USO DE MEMORIA  
4,233,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5894
Total Execution Time  0.5914
  CADENA URL  
/liga_burundi2010
  GET DATOS  
$_GET['/liga_burundi2010']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0125  SELECT type FROM routes WHERE alias = 'liga_burundi2010'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_burundi' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=331 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 331 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  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 (389309,821541,820545,820131,817945) ORDER BY n.cover_points DESC, update_date DESC
0.0131  SELECT text_es as historical_text FROM leagues_text WHERE id=259
0.0126  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 = 28576 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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='2010' WHERE c.parentId=331 GROUP BY c.id ORDER BY c.order_id ASC
0.0125  SELECT type,rule FROM rules WHERE categoryId = 331 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 01:18:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 01:18:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 01:18:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0133  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 01:18:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0141  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_burundi' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0133  SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (28576) 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.0134  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 (28576) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0133  SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (28576) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0131  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 (28576) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0130  SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (28576) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0128  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 (28576) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0129  SELECT e.action, count(e.action) as total, e.player_id FROM events2010 e WHERE e.league_id IN (28576) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0128  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 (28576) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  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 = 28576 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0125  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 = 28576 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0129  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=28576 AND rel.round=22
0.0127  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 = 28576 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0126  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 = 28576 AND esl.points > 0
0.0127  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-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28576 ORDER BY creation_date DESC LIMIT 0, 10
0.0130  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-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28576
0.0127  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 `calendars2010` 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` = 28576 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0124  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 `events2010` e INNER JOIN calendars2010 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 = 22 AND e.real_date IS NOT NULL AND e.league_id = 28576 ORDER BY total DESC LIMIT 40
0.0133  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 `events2010` e INNER JOIN calendars2010 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 = 28576 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0126  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 `tables2010` 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 = 28576 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` 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 = 28576 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 28576 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0126  SELECT data1, data2 FROM services_tags WHERE categoryId=331
0.0126  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 331 AND l.year = 2010 ORDER BY l.group_code ASC
0.0126  SELECT group_code, extraName from `leagues` WHERE categoryId=331 AND year=2010