4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Namungo
TEMPORADA 2023/2024
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Young Africans Young 24 55 12 62
2 Azam FC Azam FC 24 50 16 54
3 Simba SC Simba SC 21 41 21 46
4 Coastal Union Coastal 24 18 18 33
5 KMC KMC 24 25 33 32
6 Tanzania Prisons Tanzania 24 25 26 31
7 Kagera Sugar Kagera Sugar 24 17 21 29
8 Dodoma Dodoma 23 17 22 28
9 Namungo Namungo 23 18 21 26
10 JKT Tanzania Tanzania 24 18 25 26
11 Singida Big Stars Singida 24 22 31 26
12 Ihefu Ihefu 24 20 32 25
13 Geita Gold Geita Gold 24 16 26 24
14 Mashujaa FC Mashujaa FC 24 19 28 23
15 Kitayosce FC Kitayosce 24 16 29 23
16 Mtibwa Sugar Mtibwa Sugar 23 23 39 17
TEMPORADA 2022/2023
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Young Africans Young 30 61 18 78
2 Simba SC Simba SC 30 75 17 73
3 Azam FC Azam FC 30 55 29 59
4 Singida Big Stars Singida 30 35 26 55
5 Namungo Namungo 30 29 33 40
6 Ihefu Ihefu 30 31 32 39
7 Geita Gold Geita Gold 30 35 44 37
8 Tanzania Prisons Tanzania 30 29 38 37
9 Dodoma Dodoma 30 26 37 37
10 Mtibwa Sugar Mtibwa Sugar 30 34 45 35
11 Kagera Sugar Kagera Sugar 30 23 36 35
12 Coastal Union Coastal 30 25 35 33
13 KMC KMC 30 25 31 32
14 Mbeya City Mbeya City 30 34 44 31
15 AS Polisi AS Polisi 30 25 54 25
16 Ruvu Shooting Ruvu 30 19 42 20
TEMPORADA 2021/2022
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Young Africans Young 30 49 8 74
2 Simba SC Simba SC 30 41 14 61
3 Azam FC Azam FC 30 41 28 49
4 Geita Gold Geita Gold 30 32 26 46
5 Namungo Namungo 30 42 34 41
6 Kagera Sugar Kagera Sugar 30 20 25 39
7 Coastal Union Coastal 30 22 31 38
8 AS Polisi AS Polisi 30 21 23 37
9 Mbeya City Mbeya City 30 25 29 37
10 KMC KMC 30 34 35 35
11 Dodoma Dodoma 30 25 37 35
12 Ruvu Shooting Ruvu 30 28 39 34
13 Mtibwa Sugar Mtibwa Sugar 30 25 34 31
14 Tanzania Prisons Tanzania 30 21 34 29
15 Biashara United Biashara 30 23 35 28
16 Mbeya Kwanza Mbeya Kwanza 30 22 39 25
TEMPORADA 2020/2021
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Simba SC Simba SC 34 78 14 83
2 Young Africans Young 34 52 21 74
3 Azam FC Azam FC 34 50 22 68
4 Biashara United Biashara 34 28 32 50
5 KMC KMC 34 39 27 48
6 AS Polisi AS Polisi 34 29 27 45
7 Tanzania Prisons Tanzania 34 25 25 44
8 Dodoma Dodoma 34 28 31 44
9 Namungo Namungo 34 24 31 43
10 Mbeya City Mbeya City 34 30 33 42
11 Ruvu Shooting Ruvu 34 34 38 41
12 Kagera Sugar Kagera Sugar 34 34 38 40
13 Coastal Union Coastal 34 29 46 40
14 Mtibwa Sugar Mtibwa Sugar 34 21 31 39
15 JKT Tanzania Tanzania 34 34 47 39
16 Gwambina Gwambina 34 29 37 35
17 Ihefu Ihefu 34 22 41 35
18 Mwadui Mwadui 34 24 69 19
TEMPORADA 2019/2020
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Simba SC Simba SC 38 78 21 88
2 Young Africans Young 38 45 28 72
3 Azam FC Azam FC 38 52 26 70
4 Namungo Namungo 38 46 37 64
5 AS Polisi AS Polisi 38 37 35 55
6 JKT Tanzania Tanzania 38 34 32 54
7 Coastal Union Coastal 38 33 30 53
8 Kagera Sugar Kagera Sugar 38 44 41 52
9 Biashara United Biashara 38 29 27 50
10 Tanzania Prisons Tanzania 38 35 30 49
11 Mwadui Mwadui 38 39 45 47
12 Ruvu Shooting Ruvu 38 34 42 47
13 KMC KMC 38 35 47 46
14 Mtibwa Sugar Mtibwa Sugar 38 30 34 45
15 Mbeya City Mbeya City 38 33 42 45
16 Mbao Mbao 38 33 43 45
17 Alliance Alliance 38 36 48 45
18 Lipuli Lipuli 38 43 51 44
19 Ndanda Ndanda 38 28 35 41
20 Singida United Singida 38 23 73 18

  USO DE MEMORIA  
5,335,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1007
Total Execution Time  0.1019
  CADENA URL  
/historico/Namungo-Fc
  GET DATOS  
$_GET['/historico/Namungo-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0038  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 = 'Namungo-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=122013 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=122013 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 73542
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=122013 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=483 AND type_rel = 3
0.0029  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 483 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025  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 (1038875,1010846,848847,766464,645541) ORDER BY n.cover_points DESC, update_date DESC
0.0026  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 = '122013' ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '122013' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '122013' 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 = 73542 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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=122013 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (73542,67320) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 73542 AND teamId = 122013
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 122013
0.0021  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 = '122013' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '122013' and rp.type = 4
0.0023  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 = '122013' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0035  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 = 73542 WHERE rp.league_id = 73542 AND rp.teamId = 122013 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.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 = 73542 WHERE rp.league_id = 73542 AND rp.teamId = 122013 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 73542 WHERE rp.league_id = 73542 AND rp.teamId = 122013 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 122013 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73542 AND t.round = 24 ORDER BY team.conference ASC,t.position 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 `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 = 68658 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.0028  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 = 64317 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.0026  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 = 58694 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 50032 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73542 ORDER BY nameShow LIMIT 100