4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del UPDF
TEMPORADA 2023/2024
LIGA UGANDA
Equipo PJ GF GC Puntos
1 Kitara Kitara 25 39 20 47
2 Vipers SC Vipers SC 24 38 17 46
3 BUL FC BUL FC 25 31 17 46
4 SC Villa SC Villa 24 31 16 45
5 NEC FC NEC FC 25 32 30 43
6 KCCA FC KCCA FC 24 46 31 39
7 Maroons FC Maroons FC 25 32 20 39
8 Uganda Revenue Authority Uganda 24 27 24 34
9 Express SC Express SC 25 32 30 32
10 Bright Stars FC Bright Stars 24 30 30 30
11 Mbarara City Mbarara City 24 20 22 29
12 Wakiso Giants Wakiso 24 20 34 26
13 Busoga United Busoga 24 20 44 21
14 Gaddafi Gaddafi 24 18 44 19
15 UPDF UPDF 24 19 35 18
16 Arua Hill Arua Hill 15 12 33 5
TEMPORADA 2022/2023
LIGA UGANDA
Equipo PJ GF GC Puntos
1 Vipers SC Vipers SC 28 40 13 53
2 KCCA FC KCCA FC 28 44 23 53
3 SC Villa SC Villa 28 29 20 52
4 Arua Hill Arua Hill 28 33 28 44
5 Uganda Revenue Authority Uganda 28 36 23 42
6 Maroons FC Maroons FC 28 28 29 41
7 BUL FC BUL FC 28 31 23 36
8 Wakiso Giants Wakiso 28 30 27 36
9 Bright Stars FC Bright Stars 28 23 30 35
10 Express SC Express SC 28 31 35 34
11 Gaddafi Gaddafi 28 22 29 31
12 Busoga United Busoga 28 21 40 28
13 UPDF UPDF 28 24 40 27
14 Blacks Power Blacks Power 28 21 41 26
15 Onduparaka Onduparaka 28 26 38 22
TEMPORADA 2021/2022
LIGA UGANDA
Equipo PJ GF GC Puntos
1 Vipers SC Vipers SC 30 69 19 74
2 KCCA FC KCCA FC 30 41 21 56
3 Uganda Revenue Authority Uganda 30 57 27 55
4 BUL FC BUL FC 30 54 32 52
5 Arua Hill Arua Hill 30 38 27 52
6 Express SC Express SC 30 31 25 46
7 Wakiso Giants Wakiso 30 38 47 39
8 Onduparaka Onduparaka 30 34 37 37
9 Gaddafi Gaddafi 30 33 36 37
10 UPDF UPDF 30 33 42 37
11 Bright Stars FC Bright Stars 30 26 34 36
12 SC Villa SC Villa 30 27 32 33
13 Busoga United Busoga 30 26 45 32
14 Uganda Police Uganda 30 32 46 28
15 Mbarara City Mbarara City 30 28 36 25
16 Tooro United Tooro United 30 20 81 10
TEMPORADA 2020/2021
LIGA UGANDA
Equipo PJ GF GC Puntos
1 Express SC Express SC 26 44 13 58
2 Uganda Revenue Authority Uganda 26 41 18 57
3 Vipers SC Vipers SC 26 56 21 56
4 KCCA FC KCCA FC 27 56 22 48
5 Bright Stars FC Bright Stars 27 40 27 42
6 Uganda Police Uganda 27 50 31 40
7 Mbarara City Mbarara City 27 30 34 38
8 UPDF UPDF 27 34 39 37
9 Wakiso Giants Wakiso 26 42 33 36
10 SC Villa SC Villa 27 29 30 36
11 BUL FC BUL FC 27 39 41 33
12 Onduparaka Onduparaka 26 25 45 28
13 Busoga United Busoga 26 21 44 26
14 Kyetume Kyetume 27 28 47 23
15 MYDA MYDA 27 32 77 14
16 Kitara Kitara 27 35 80 13
TEMPORADA 2017/2018
LIGA UGANDA
Equipo PJ GF GC Puntos
1 Vipers SC Vipers SC 29 46 19 62
2 KCCA FC KCCA FC 29 52 19 60
3 SC Villa SC Villa 29 30 11 55
4 Onduparaka Onduparaka 29 26 17 45
5 Busoga United Busoga 29 29 27 40
6 Bright Stars FC Bright Stars 29 24 24 38
7 Uganda Police Uganda 29 29 37 38
8 Maroons FC Maroons FC 29 18 20 36
9 Uganda Revenue Authority Uganda 29 24 27 34
10 BUL FC BUL FC 29 22 30 33
11 Mbarara City Mbarara City 29 17 23 32
12 UPDF UPDF 29 22 34 32
13 Tooro United Tooro United 29 19 35 31
14 Proline Proline 29 26 32 28
15 Express SC Express SC 29 24 31 28
16 Masavu Masavu 29 18 40 26

  USO DE MEMORIA  
5,276,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0840
Total Execution Time  0.0852
  CADENA URL  
/historico/Uganda-People-Defense-Force-Fc
  GET DATOS  
$_GET['/historico/Uganda-People-Defense-Force-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0026  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 = 'Uganda-People-Defense-Force-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.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=102868 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=102868 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=102868 AND type_rel = 2
0.0022  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 = '102868' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '102868' 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 = '102868' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=102868 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 (73650,71076) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73650 AND teamId = 102868
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71076 AND teamId = 102868
0.0022  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 = '102868' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '102868' and rp.type = 4
0.0020  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 = '102868' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031  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 = 73650 WHERE rp.league_id = 73650 AND rp.teamId = 102868 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.0027  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 = 73650 WHERE rp.league_id = 73650 AND rp.teamId = 102868 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 73650 WHERE rp.league_id = 73650 AND rp.teamId = 102868 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 = 102868 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 = 73650 AND t.round = 25 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 `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 = 69702 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 `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 = 65352 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 `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 = 60254 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 `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 = 39713 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC