Legal jobs at AB InBev and Other Companies in Zambia

 
Deadline of this Job: 07 December 2022

Dreaming big is in our DNA. Brewing the world’s most loved beers and creating meaningful experiences is what inspires us. We are owners, empowered to lead real change, deliver on tough challenges, and take accountability for the results. We are looking for talent that shares these values, that is ambitious, bold & resilient. We want talent that is looking for fast career growth, cross-functional experiences, global exposure and robust training & development.
The key purpose of this role is to Drive and lead the Zambia Legal and Corporate Affairs agenda: government and stakeholder relations, regulatory affairs including protecting license to trade, corporate reputation and communications, media relations, communities support projects, legal projects, and compliance and governance priorities. Manage and lead Zambia Legal and Corporate Affairs team.

Key outputs and responsibilities:
• Managing and leading the Zambia Corporate Affairs and Legal agenda and strategy
• Strategy for Government and stakeholder relations, corporate reputation management and corporate brand communications
• Proactive leading on training/ compliance and risk management for the Zambia business
• Key advice and strategy across the business
• Manage relationships with key internal and external stakeholders
• Drive the agenda in protecting the business’ interest at a local level and ascertain adherence to business ethics as well as to existing policies
• Working together with the Zambia Legal Manager, coordinate any material court proceedings and litigation settlements
• Lead and manage key strategic projects and transactions
• Working together with the Zambia Legal Manager, exercise responsibility for marketing, advertising and sales promotion materials

Key Attributes and Competencies:
• Ability to interact with and influence senior stakeholders
• Ideally some International understanding/experience, given the nature of the global business
• Proficiency in English
• Highly-developed all round business and commercial sense
• Strong personality with strong communication and negotiating skills in a multi-cultural environment
• Ability to work autonomously, in a result-orientated and effective problem-solving way

Education
• Communications/Public Relations/Stakeholder Relations/Corporate Affairs/External Affairs/Legal background.
Experience
• Minimum of 5 years post qualification experience
• Board experience (Desirable)
• Strong academic background and experience
• FMCG experience (Desirable)
• Leading and Managing people experience

60.544MBMemory Usage475msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.28-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "1deb24708f7a51ca02b447b7f6862276" => "529ae655ddb9a380cb69c445edade243" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 3 "timer" => array:3 [ "start" => 1743669378 "last" => 1743669384...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
jsjobcur_usr
0
jsjobconfig_dft
array:171 [ "actk" => "0" "applybuttonredirecturl" => "http://www.greatzambiajobs.com/how-to-app...
JSItemid
"190"
  • afterLoad (4.12MB) (28.19ms)
  • afterInitialise (11.13MB) (94.52ms)
  • afterRoute (4.6MB) (30.59ms)
  • beforeRenderComponent com_content (29.19KB) (205μs)
  • Before Access::preloadComponents (all components) (371.44KB) (2.63ms)
  • After Access::preloadComponents (all components) (134.4KB) (1.07ms)
  • Before Access::preloadPermissions (com_content) (4.26KB) (14μs)
  • After Access::preloadPermissions (com_content) (1.16MB) (3.22ms)
  • Before Access::getAssetRules (id:2227 name:com_content.article.1536) (66.8KB) (57μs)
  • After Access::getAssetRules (id:2227 name:com_content.article.1536) (26.84KB) (280μs)
  • afterRenderComponent com_content (2.25MB) (29.12ms)
  • Before Access::getAssetRules (id:1 name:root.1) (1MB) (11.14ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.95KB) (43μs)
  • afterDispatch (1.76MB) (28.16ms)
  • afterRender (29.36MB) (245ms)
  • 1 x afterRender (29.36MB) (51.58%)
    245.06ms
    1 x afterInitialise (11.13MB) (19.89%)
    94.52ms
    1 x afterRoute (4.6MB) (6.44%)
    30.59ms
    1 x afterRenderComponent com_content (2.25MB) (6.13%)
    29.12ms
    1 x afterLoad (4.12MB) (5.93%)
    28.19ms
    1 x afterDispatch (1.76MB) (5.93%)
    28.16ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (1MB) (2.34%)
    11.14ms
    1 x After Access::preloadPermissions (com_content) (1.16MB) (0.68%)
    3.22ms
    1 x Before Access::preloadComponents (all components) (371.44KB) (0.55%)
    2.63ms
    1 x After Access::preloadComponents (all components) (134.4KB) (0.23%)
    1.07ms
    1 x After Access::getAssetRules (id:2227 name:com_content.article.1536) (26.84KB) (0.06%)
    280μs
    1 x beforeRenderComponent com_content (29.19KB) (0.04%)
    205μs
    1 x Before Access::getAssetRules (id:2227 name:com_content.article.1536) (66.8KB) (0.01%)
    57μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.95KB) (0.01%)
    43μs
    1 x Before Access::preloadPermissions (com_content) (4.26KB) (0%)
    14μs
65 statements were executed, 9 of which were duplicates, 56 unique16.47ms360.93KB
  • SELECT @@SESSION.sql_mode;74μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?148μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 189μs1.63KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `icop0_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id106μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`109μs1.55KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `icop0_usergroups` AS `a` LEFT JOIN `icop0_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest118μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'140μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`90μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'178μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config138μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'100μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'98μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'99μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'93μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1536-legal-jobs-at-ab-inbev-and-other-companies-in-zambia%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Frelated-jobs%2F1536-legal-jobs-at-ab-inbev-and-other-companies-in-zambia%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1536-legal-jobs-at-ab-inbev-and-other-companies-in-zambia%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC249μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `icop0_categories` AS `s` INNER JOIN `icop0_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`348μs5.11KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1536-legal-jobs-at-ab-inbev-and-other-companies-in-zambia%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Frelated-jobs%2F1536-legal-jobs-at-ab-inbev-and-other-companies-in-zambia%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1536-legal-jobs-at-ab-inbev-and-other-companies-in-zambia%2F')=1) OR `list_var` LIKE '%com_content%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC234μs6.8KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM icop0_template_styles AS s WHERE s.client_id = 0 AND s.template = 'jl_education_pro' ORDER BY s.id178μs1.2KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `icop0_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49,:preparedArray50)579μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `icop0_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.74ms129.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `icop0_content`360μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `icop0_content` SET `hits` = (`hits` + 1) WHERE `id` = '1536'759μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `icop0_content` AS `a` INNER JOIN `icop0_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `icop0_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `icop0_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `icop0_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `icop0_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)352μs24.63KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `icop0_categories` AS `s` INNER JOIN `icop0_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`323μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `icop0_contentitem_tag_map` AS `m` INNER JOIN `icop0_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3)427μs5.27KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `alias` FROM `icop0_content` WHERE `id` = :id133μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `icop0_content` WHERE `id` = :id77μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `icop0_categories` AS `s` INNER JOIN `icop0_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`339μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'254μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'268μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'246μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering190μs4.27KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0110μs11.91KB/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22109μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24143μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 28100μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38123μs17.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 39104μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40110μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT `a`.`menutype`,`a`.`title` FROM `icop0_menu_types` AS `a` WHERE `a`.`client_id` = 0236μs1.19KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft560μs1.8KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM icop0_jmap_metainfo WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/related-jobs/1536-legal-jobs-at-ab-inbev-and-other-companies-in-zambia' AND `published` = 1121μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/related-jobs/1536-legal-jobs-at-ab-inbev-and-other-companies-in-zambia'68μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration279μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'166μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field140μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'112μs1.2KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `icop0_scheduler_tasks` AS `a` WHERE `a`.`state` = 1118μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'215μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`313μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'95μs912B/libraries/src/Table/Table.php:755Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `icop0_content` AS `a` INNER JOIN `icop0_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `icop0_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `icop0_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `icop0_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `icop0_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)366μs24.63KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `icop0_categories` AS `s` INNER JOIN `icop0_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`392μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM icop0_fields AS a LEFT JOIN `icop0_languages` AS l ON l.lang_code = a.language LEFT JOIN icop0_users AS uc ON uc.id=a.checked_out LEFT JOIN icop0_viewlevels AS ag ON ag.id = a.access LEFT JOIN icop0_users AS ua ON ua.id = a.created_user_id LEFT JOIN icop0_fields_groups AS g ON g.id = a.group_id LEFT JOIN `icop0_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7,:preparedArray8)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC751μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT a.* FROM icop0_gsd a WHERE a.state = 1 AND a.plugin = 'content' AND a.appview IN ('article','*') ORDER BY a.id desc207μs2.05KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT a.* FROM icop0_gsd a WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*') ORDER BY a.id desc176μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/related-jobs/1536-legal-jobs-at-ab-inbev-and-other-companies-in-zambia'110μs1.05KB/plugins/system/jmap/jmap.php:1135Copy
  • SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `icop0_jmap_text_replacements` WHERE `published` = 195μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"403μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.11ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin126μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin113μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` FROM icop0_usergroups AS `groups`110μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?107μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?551μs8.89KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy