Accounting Finance Jobs at Population Media Center (PMC) and Barloworld Equipment Zambia Ltd


Deadline of this Job: 
12 December 2022

JOB DETAILS:
Population Media Center (PMC) is a nonprofit, international organization, which strives to improve the health and well-being of people around the world using entertainment-education strategies. Founded in 1998, PMC has 19 years of field experience in social behavior change communication, impacting more than 50 countries around the world.
PMC seeks applications from suitably qualified and experienced persons to fill the position of Finance and Admin Manager on part-time basis for a period of SIX MONTHS.

Responsibilities
The Finance and Admin Manager, under the supervision of PMC Country Director – Zambia, will be responsible for accounting and financial management of PMC’s program in Zambia.
1. Financial Accounting
The Finance and Admin Manager will maintain a general ledger of project cash, receipts, and disbursements utilizing QuickBooks or similar accounting software:
• Maintain established internal control procedures to ensure that all disbursements are properly approved, documented, and for the sole benefit of the project.
• Establish and maintain safeguards for all cash and non-cash assets and property.
• Post all transaction with proper accounting codes per the approved chart of accounts.
• Complete month-end bank account reconciliations and cash on hand physical count sheet.
2. Payroll and Human Resources
The Finance and Admin Manager will process payroll in compliance with staff employment contracts and local labor laws:
• Establish and maintain attendance records.
• Prepare and distribute monthly payroll.
• Remit payroll taxes related reports and according to local labor laws.
• Keep abreast of local labor laws relevant to PMC staff in-country (such as severance, benefits, taxes, social security), and all in-country contracts.
3. Contracting and Procurement
The Finance and Admin Manager provides assistance to Senior Management with executing contracts and purchasing or procuring goods and services needed to implement the project. Duties include:
• Assist the Country Director to develop financial management and procurement policies and procedures, based on PMC policies for field offices.
• Obtain estimates for any goods or services to be procured by the PMC program in country and assists the Country Director to select contractors based on defined parameters, according to PMC procurement policies for field offices.
• Assist the Country Director and team members to ensure the management of all in-country contracts, as necessary (e.g., research contracts, broadcasting contracts, office rental, etc.)
4. Financial Reporting and Budget Monitoring
The Finance and Admin Manager contributes to the fiscal responsibility of the project/s and by providing financial reports and monitoring project expenses. Duties include:
• Assist the Country Director to prepare and submit monthly, quarterly, and annual financial reports to PMC headquarters and to donor agencies, as required
• Monitor expenses against project budgets, and provide timely updates to the Country Director and team members
5. Project Team
As a member of the project team, the Finance and Admin Manager will oversee and maintain the efficient and professional operations of the office. The Finance and Admin Manager performs other duty as requested by the Senior Management.

QUALIFICATIONS and EXPERIENCE
• Degree in accounting, finance ACCA or CIMA , with a minimum of five years of experience
• Experience in managing and reporting on projects funded by USAID, DFID, UN, KFW, Global Fund or World Bank a must.
• Up-to-date knowledge of current financial and accounting computer applications (experience with QuickBooks preferred)
• Prior experience with non-governmental organizations strongly preferred
• Written and verbal communication skills in English
• Ability to produce high-quality work under pressure
• Ability to work effectively in a team –oriented and multi-cultural environment
• Effective time management skills
• Flexibility to work long hours
• Demonstrable commitment to reproductive health and related social and health goals
• Member of ZICA

Deadline of this Job: 17 December 2022

JOB DETAILS:
Barloworld Equipment Zambia Limited has a vacancy for a Tax Manager to successfully manage the total tax function.
Applicants suitably qualified based on the requirements stated below are invited to apply for the position.
Applicant should meet the following requirements:

KEY OUTPUTS AND ACCOUNTABILITIES
• Compilation and submission of all tax returns – Income, VAT, PAYE, WHT, Customs etc.
• Ensuring compliance with tax legislation and group policies
• Liaising with local regulatory bodies such as ZRA and NAPSA
• Reconciliation of all tax types with ZRA
• Preparation of monthly, interim and year-end tax and deferred tax calculation
• Manage the tax expense and effective tax rate
• Ensure Transfer Pricing documentation is in place
• Identify and mitigate tax risks
• Manage tax provision and tax compliance process
• Improve processes by developing or implementing best practices
• Manage and coordinate tax audits
• Maintain tax balances on general ledger
• Prepare all tax papers on a regular basis and handle all tax related information data requests

MINIMUM REQUIRED QUALIFICATION:
• Bachelor of Accountancy / ACCA/ CIMA/ CA Zambia or equivalent
• Internal or External Tax audit experience
• Minimum 5 years Accounting and Tax experience
• Knowledge of MS Excel
• Working knowledge of SAP an advantage
• Exposure to ZRA fiscalisation process will be an added advantage
• Grade 12 Certificate

MINIMUM REQUIRED COMPETENCIES:
• Attention to detail and high level of accuracy required
• Good oral and written communication skills are essential
• Analytical Teamwork
• Problem solving skills
• Building relationships
• Professional / technical competence
• Sound business and financial acumen
• Good planning skills and the ability to work under pressure
• The candidate must be able to liaise with the various stakeholders in the tax space, including finance employees at all levels and ZRA
• Must be able to work independently and be proactive
61.474MBMemory Usage307msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.31
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.27-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:63 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1737466544 "last" => 1737466544...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
JSItemid
"190"
  • afterLoad (4.12MB) (16.89ms)
  • afterInitialise (11.93MB) (59.25ms)
  • afterRoute (4.84MB) (22.15ms)
  • beforeRenderComponent com_content (29.15KB) (181μs)
  • Before Access::preloadComponents (all components) (371.45KB) (2.28ms)
  • After Access::preloadComponents (all components) (134.4KB) (767μs)
  • Before Access::preloadPermissions (com_content) (4.26KB) (10μs)
  • After Access::preloadPermissions (com_content) (1.15MB) (2.14ms)
  • Before Access::getAssetRules (id:2230 name:com_content.article.1538) (66.8KB) (48μs)
  • After Access::getAssetRules (id:2230 name:com_content.article.1538) (26.84KB) (233μs)
  • afterRenderComponent com_content (2.27MB) (19.39ms)
  • Before Access::getAssetRules (id:1 name:root.1) (1.06MB) (7.32ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.95KB) (22μs)
  • afterDispatch (1.58MB) (19.21ms)
  • afterRender (32.45MB) (156ms)
  • 1 x afterRender (32.45MB) (50.94%)
    156.22ms
    1 x afterInitialise (11.93MB) (19.32%)
    59.25ms
    1 x afterRoute (4.84MB) (7.22%)
    22.15ms
    1 x afterRenderComponent com_content (2.27MB) (6.32%)
    19.39ms
    1 x afterDispatch (1.58MB) (6.26%)
    19.21ms
    1 x afterLoad (4.12MB) (5.51%)
    16.89ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (1.06MB) (2.39%)
    7.32ms
    1 x Before Access::preloadComponents (all components) (371.45KB) (0.74%)
    2.28ms
    1 x After Access::preloadPermissions (com_content) (1.15MB) (0.7%)
    2.14ms
    1 x After Access::preloadComponents (all components) (134.4KB) (0.25%)
    767μs
    1 x After Access::getAssetRules (id:2230 name:com_content.article.1538) (26.84KB) (0.08%)
    233μs
    1 x beforeRenderComponent com_content (29.15KB) (0.06%)
    181μs
    1 x Before Access::getAssetRules (id:2230 name:com_content.article.1538) (66.8KB) (0.02%)
    48μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.95KB) (0.01%)
    22μs
    1 x Before Access::preloadPermissions (com_content) (4.26KB) (0%)
    10μs
65 statements were executed, 9 of which were duplicates, 56 unique11.94ms360.9KB
  • SELECT @@SESSION.sql_mode;117μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?86μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 194μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `icop0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)258μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`68μs1.59KB/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` = :guest120μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'106μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`62μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'135μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config135μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'66μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'50μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'51μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'40μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1538-accounting-finance-jobs-at-population-media-center-pmc-and-barloworld-equipment-zambia-ltd%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Frelated-jobs%2F1538-accounting-finance-jobs-at-population-media-center-pmc-and-barloworld-equipment-zambia-ltd%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1538-accounting-finance-jobs-at-population-media-center-pmc-and-barloworld-equipment-zambia-ltd%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC196μ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`269μs5.11KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1538-accounting-finance-jobs-at-population-media-center-pmc-and-barloworld-equipment-zambia-ltd%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Frelated-jobs%2F1538-accounting-finance-jobs-at-population-media-center-pmc-and-barloworld-equipment-zambia-ltd%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1538-accounting-finance-jobs-at-population-media-center-pmc-and-barloworld-equipment-zambia-ltd%2F')=1) OR `list_var` LIKE '%com_content%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC211μ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)433μ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` = 0914μs129.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `icop0_content`296μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `icop0_content` SET `hits` = (`hits` + 1) WHERE `id` = '1538'400μ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)255μ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`232μ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)311μs5.27KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `alias` FROM `icop0_content` WHERE `id` = :id118μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `icop0_content` WHERE `id` = :id105μ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`319μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'194μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'182μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'384μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering187μs4.27KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 072μs11.91KB/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22133μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2485μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2887μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 3888μs17.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 3964μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 4067μ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` = 0144μ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.lft256μ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/1538-accounting-finance-jobs-at-population-media-center-pmc-and-barloworld-equipment-zambia-ltd' AND `published` = 1177μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/related-jobs/1538-accounting-finance-jobs-at-population-media-center-pmc-and-barloworld-equipment-zambia-ltd'116μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration242μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'91μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field79μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'63μ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` = 1121μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'119μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`268μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'107μ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)238μ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`252μ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 ASC509μ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 desc120μ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 desc135μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/related-jobs/1538-accounting-finance-jobs-at-population-media-center-pmc-and-barloworld-equipment-zambia-ltd'108μ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` = 151μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"220μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES679μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin60μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin51μ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`109μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?121μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?337μs8.89KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy