4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Musongati
TEMPORADA 2023/2024
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Vital'O Vital'O 28 49 10 69
2 Flambeau du Centre Flambeau 28 46 18 63
3 Musongati Musongati 28 39 15 57
4 Rukinzo Rukinzo 28 50 28 57
5 Le Messager Ngozi Messager 28 38 23 51
6 Aigle Noir Aigle Noir 28 36 25 50
7 Olympic Star Olympic Star 28 32 24 41
8 Bumamuru Bumamuru 28 38 31 40
9 Dynamik Dynamik 28 45 43 36
10 LLB Académic Académic 28 27 33 31
11 Kayanza Kayanza 28 26 39 27
12 Moso Sugar Moso Sugar 28 27 37 25
13 Inter Star Inter Star 29 22 44 25
14 Telaviv Telaviv 29 30 63 24
15 Tigre Noir Tigre Noir 28 15 37 19
16 Magara Young Boys Magara Young 28 25 75 8
TEMPORADA 2022/2023
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Bumamuru Bumamuru 30 71 21 68
2 Flambeau du Centre Flambeau 30 55 27 67
3 Le Messager Ngozi Messager 30 44 19 56
4 Vital'O Vital'O 30 42 30 54
5 Aigle Noir Aigle Noir 30 34 24 53
6 Rukinzo Rukinzo 30 29 32 42
7 Kayanza Kayanza 30 34 39 40
8 Musongati Musongati 30 33 34 37
9 Olympic Star Olympic Star 30 30 35 37
10 Tigre Noir Tigre Noir 30 34 34 34
11 Magara Young Boys Magara Young 30 38 50 34
12 Dynamik Dynamik 30 21 39 29
13 Inter Star Inter Star 30 25 47 29
14 Bujumbura City Bujumbura 30 30 43 27
15 New Oil New Oil 30 28 50 27
16 TOP Junior TOP Junior 30 15 39 19
TEMPORADA 2021/2022
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Flambeau du Centre Flambeau 30 40 24 53
2 New Oil New Oil 30 35 22 52
3 Bumamuru Bumamuru 30 40 27 51
4 TOP Junior TOP Junior 30 37 29 51
5 Aigle Noir Aigle Noir 30 41 32 46
6 Olympic Star Olympic Star 30 31 25 46
7 Le Messager Ngozi Messager 30 27 21 46
8 Dynamik Dynamik 30 35 33 46
9 Musongati Musongati 30 27 22 44
10 Rukinzo Rukinzo 30 26 26 39
11 Vital'O Vital'O 30 32 39 39
12 Bujumbura City Bujumbura 30 35 37 37
13 Kayanza Kayanza 30 34 38 33
14 Les Crocos Les Crocos 30 20 30 24
15 Flambeau de l'Est Flambeau 30 18 54 23
16 Royal de Muramvya Royal 30 24 43 22
TEMPORADA 2020/2021
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Le Messager Ngozi Messager 30 42 26 55
2 Kayanza Kayanza 30 50 35 55
3 Flambeau du Centre Flambeau 30 43 26 54
4 Aigle Noir Aigle Noir 30 49 33 53
5 Musongati Musongati 30 48 30 50
6 Rukinzo Rukinzo 30 41 35 50
7 Vital'O Vital'O 30 34 33 44
8 Olympic Star Olympic Star 30 35 30 42
9 Royal de Muramvya Royal 30 36 32 42
10 Dynamik Dynamik 30 24 27 41
11 Bumamuru Bumamuru 30 33 39 39
12 Athlético Olympic Athlético 30 35 42 37
13 Bujumbura City Bujumbura 30 38 45 36
14 Inter Star Inter Star 30 31 42 31
15 Les Eléphants Eléphants 30 30 58 25
16 Muzinga Muzinga 30 15 51 12
TEMPORADA 2019/2020
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Le Messager Ngozi Messager 30 51 18 64
2 Musongati Musongati 30 45 26 56
3 Aigle Noir Aigle Noir 30 56 39 48
4 Dynamik Dynamik 30 32 25 48
5 Flambeau du Centre Flambeau 30 44 40 48
6 Vital'O Vital'O 30 41 33 44
7 Bujumbura City Bujumbura 30 47 41 43
8 Olympic Star Olympic Star 30 54 48 39
9 Rukinzo Rukinzo 30 40 44 39
10 Bumamuru Bumamuru 30 41 37 38
11 Inter Star Inter Star 30 29 32 38
12 Kayanza Kayanza 30 35 39 37
13 Athlético Olympic Athlético 30 46 44 36
14 LLB Académic Académic 30 23 41 35
15 Ngozi City Ngozi City 30 28 62 22
16 Les Lierres Les Lierres 30 26 69 20
TEMPORADA 2018/2019
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Aigle Noir Aigle Noir 26 66 23 61
2 Musongati Musongati 26 48 28 48
3 Vital'O Vital'O 26 28 17 46
4 Le Messager Ngozi Messager 26 36 28 43
5 Bujumbura City Bujumbura 27 32 28 39
6 Bumamuru Bumamuru 26 25 28 36
7 Ngozi City Ngozi City 26 23 33 36
8 Rukinzo Rukinzo 26 30 25 35
9 Les Lierres Les Lierres 27 26 32 33
10 Kayanza Kayanza 26 24 29 30
11 Flambeau du Centre Flambeau 26 32 35 30
12 Olympic Star Olympic Star 26 28 41 30
13 Le Messager de Bujumbura Messager 28 29 46 30
14 Athlético Olympic Athlético 26 22 32 29
15 Flambeau de l'Est Flambeau 26 15 25 26
16 LLB Académic Académic 28 25 39 26
TEMPORADA 2017/2018
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 Le Messager Ngozi Messager 30 52 24 70
2 LLB Académic Académic 30 57 22 69
3 Aigle Noir Aigle Noir 30 66 32 59
4 Vital'O Vital'O 30 34 9 59
5 Olympic Star Olympic Star 30 55 26 58
6 Bujumbura City Bujumbura 30 32 30 44
7 Les Lierres Les Lierres 30 38 35 40
8 Musongati Musongati 30 38 31 39
9 Flambeau du Centre Flambeau 30 43 45 39
10 Flambeau de l'Est Flambeau 30 30 32 37
11 Athlético Olympic Athlético 30 34 44 33
12 Ngozi City Ngozi City 30 24 35 30
13 Le Messager de Bujumbura Messager 30 32 48 30
14 Inter Star Inter Star 30 22 41 26
15 Jeunes Athlétiques Jeunes 30 22 63 20
16 Delta Star Delta Star 30 13 75 9
TEMPORADA 2016/2017
LIGA BURUNDI
Equipo PJ GF GC Puntos
1 LLB Académic Académic 30 58 16 68
2 Athlético Olympic Athlético 30 43 15 60
3 Vital'O Vital'O 30 46 15 57
4 Aigle Noir Aigle Noir 30 32 16 55
5 Musongati Musongati 30 49 27 49
6 Le Messager Ngozi Messager 30 33 25 47
7 Olympic Star Olympic Star 30 22 31 39
8 Bujumbura City Bujumbura 30 28 31 37
9 Les Lierres Les Lierres 30 33 40 34
10 Le Messager de Bujumbura Messager 30 26 35 33
11 Flambeau de l'Est Flambeau 30 27 35 32
12 Ngozi City Ngozi City 30 19 33 32
13 Inter Star Inter Star 30 20 47 29
14 Nyanza United Nyanza 30 32 47 27
15 Rusizi Rusizi 30 31 54 26
16 Muzinga Muzinga 30 14 46 23

  USO DE MEMORIA  
5,638,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1087
Total Execution Time  0.1101
  CADENA URL  
/historico/Musongati-Fc
  GET DATOS  
$_GET['/historico/Musongati-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0032  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Musongati-Fc' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=92780 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=92780 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73193
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=92780 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=331 AND type_rel = 3
0.0021  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.0023  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.0024  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '92780' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '92780' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '92780' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73193 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=92780 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73193,71578) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73193 AND teamId = 92780
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 71578 AND teamId = 92780
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 FROM `tables2024` 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 = 73193 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '92780' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '92780' and rp.type = 4
0.0021  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '92780' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73193 WHERE rp.league_id = 73193 AND rp.teamId = 92780 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73193 WHERE rp.league_id = 73193 AND rp.teamId = 92780 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73193 WHERE rp.league_id = 73193 AND rp.teamId = 92780 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 92780 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024` 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 = 73193 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2023` 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 = 68728 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2022` 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 = 63883 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2021` 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 = 58403 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2020` 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 = 51030 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2019` 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 = 44926 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 `tables2018` 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 = 40147 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 `tables2017` 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 = 34813 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC