SRO-SA Consultant – Consultancy assignment for the production of a “Policy manual on enhanced Domestic Resource Mobilization in Zambia post-COVID tender at United Nations Economic Commission for Africa (UNECA)
613 Days Ago
Linkedid Twitter Share on facebook

Result of Service

The overall objective is to produce quality data and information, and other relevant inputs required for the production a well-informed “Policy Manual on enhanced Domestic Resource Mobilization in Zambia post-COVID” aimed at providing the Zambian Government with policy guidelines and procedures for decisions, actions and principles to enhance Domestic Resource Mobilization in Zambia in the post-COVID era.

Work Location

Remote

Expected duration

6 Months

Duties and Responsibilities

 

PROJECT BACKGROUND:

Similar Jobs in Zambia
Learn more about United Nations Economic Commission for Africa (UNECA)
United Nations Economic Commission for Africa (UNECA) jobs in Zambia

The ECA Subregional Office for Southern Africa, along with other implementing partners, including the United Nations Conference on Trade and Development(UNCTAD) is implementing a Development Account project on Integrated National Financing Framework in Zambia funded. The project is funded by United Nations Department for Economic and Social Affairs (UNDESA) and focuses on activities related to enhancing economic governance, domestic resource mobilization, leveraging innovative sources of finance and strengthening SDG-based reporting tools.
2. ECA (2022) emphasized the significance of exploring new financing avenues to address the effects of the COVID-19 pandemic and enhance Domestic Resource Mobilization capacity.. As part of the project, a handbook titled “Innovative Finance for Industrialization and Private Sector Development in Zambia” will be developed as a complementary deliverable. This handbook will focus on financial instruments involving the private sector, allowing the existing Policy Manual to concentrate on fiscal policy, which primarily falls within the purview of the public sector.
3. The challenge of financing is particularly striking in Zambia. In November 2020, the country opted to skip a $42.5 million eurobond repayment, becoming the first African nation to default on its debt in the COVID-19 era. According to World Bank data, the debt-to-GDP ratio for Zambia almost doubled from 2019 to 2020, moving up from 61.9% in 2019 to 103.7% in 2020. According to the Zambian Ministry of Finance, the budgetary deficit in Zambia was recorded at 7.8 percent of GDP in 2017 and rose to a peak of 14.4 percent in 2020. These figures indicate an increasingly pressing need to strengthen the capacity to effectively mobilize resources necessary for tackling numerous and significant challenges faced by the country.

4. Domestic Resource Mobilization is a key component of the Integrated National Financing Framework. The 8th NDP refers to Domestic Resource Mobilization as a significant conventional source of finance for generating the required resources to implement the plan he NDP specifically highlights several measures, including streamlining the tax system, creating a stable and predictable tax environment, leveraging on ICT platforms to curb revenue leakages, increasing compliance and enhancing non-tax revenue collections. Moreover, the plan sets a target of mobilizing K671.2 billion in domestic resources throughout the Plan period.

 

5. Against this background, the present Policy Manual on “Enhanced domestic resource mobilization in Zambia post-COVID” is meant to provide the policymakers with specific tools that may remedy the Domestic Resource Mobilization challenges specific for Zambia, focusing particularly on support for fiscal policy. The policy manual will review theoretical knowledge and practical experience on Domestic Resource Mobilization measures, and review the specific challenges applicable to Zambia. The specific scope of the Policy Manual should be worked out in close collaboration with the relevant Government entities, notably the Ministry of Finance and National Planning of Zambia and the Zambia Revenue Authority, to maximise the applicability of findings, notably to complement the recently adopted Domestic Resource Mobilization Action Plan, 2023-2025.

 
 

6. The Policy Manual will as address various topics, including broadening the tax base; taxation of the informal sector; combatting tax avoidance; easing the complexity of taxation; streamlining tax incentives; facilitating the use of ICT tools to strengthen tax collection capacity; strengthening the taxation of the mining sector and combatting illicit financial flows. Furthermore, the Manual will give specific attention to the impact of COVID-19, examining both opportunities like the renewed focus on digitalization and challenges such as the need for a larger resource envelope due to expenditures related to the pandemic.

DUTIES AND RESPONSIBILITIES:
7. Under the overall supervision of the Chief of the Subregional Initiatives Section of the Sub-Regional Office for Southern Africa, and the direct supervision of the Associate Economic Affairs Officer of the Section, and in close collaboration with the lead/international consultant; the successful candidate shall:
1) Consult with the international consultant leading the conceptual development and drafting of the Policy Manual on Domestic Resource Mobilisation in Zambia post-COVID;
2) Prepare an inception report detailing among other things, the methodology, workplan and report outline as agreed with the international consultant;
3) Support in reviewing relevant past and current literature, key analytical frameworks, methodologies and other documents relevant to domestic resource mobilization, particularly the Domestic Resource Mobilisation Action Plan for 2023-2025, in agreement with the international consultant;
4) Carry out consultations with relevant institutions to collect relevant data and information on main challenges and opportunities for Domestic Resource Mobilisation in Zambia pos-COVID;
5) Implement the relevant data collection tools in close collaboration with the international consultant, including a survey questionnaire, a desk review, as well as compilation of data from databases to collect data and information relevant to the assignment, and carry out interviews and other necessary consultations as required;
6) Analyze data and information gathered from different sources to submit to the international consultant for his drafting of the report using appropriate methodologies and tools;
7) Present conclusions and action oriented recommendations on the basis of the analysis;
8) Engage on an ongoing basis with the international consultant, and the ECA-SRO-SA and the Ministry of Finance and National Planning of Zambia to provide other inputs as required;

Expected outcomes

9. The development of the Policy Manual is expected to deliver the following outcomes:
a) Improved understanding and awareness of the theories, concepts and principles relevant to domestic resource mobilization, as well as specific challenges and opportunities for Domestic Resource Mobilization in Zambia and their impact on the economy.
b) In-depth understanding of possible policies and procedures pursued globally to address the Domestic Resource Mobilization challenges;
c) Practical recommendations on policy strategies and procedures to enhance domestic resource mobilization;
d) Enhanced capacity of the government entities in applying policies for strengthening Domestic Resource Mobilization in Zambia.

Qualifications/special skills

Advanced university degree (at least a Masters Degree or equivalent) in economics, statistics or related discipline is required. A first degree with Two additional years of qualifying experience may be accepted in lieu of the Advanced Degree
A minimum of Three years of progressively responsible experience at the national and/or international level economic analysis, data collection and statistical analysis. Experience in research/analytical work on fiscal policy, development finance, including Domestic Resource Mobilization in Africa, either in the academia or in private, public or civil society organizations is an advantage. Knowledge of the relevant statistical package (Stata, R), is an advantage.

Languages

English and French are the working languages of the UN. For this consultancy ,fluency in English both written and spoken are required.

No Fee

THE UNITED NATIONS DOES NOT CHARGE A FEE AT ANY STAGE OF THE RECRUITMENT PROCESS (APPLICATION, INTERVIEW MEETING, PROCESSING, OR TRAINING). THE UNITED NATIONS DOES NOT CONCERN ITSELF WITH INFORMATION ON APPLICANTS’ BANK ACCOUNTS.

Job Info
Job Category: Tenders in Zambia
Job Type: Full-time
Deadline of this Job: Thursday, September 07 2023
Duty Station: Lusaka
Posted: 24-08-2023
No of Jobs: 1
Start Publishing: 24-08-2023
Stop Publishing (Put date of 2030): 24-08-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
59.959MBMemory Usage683msRequest 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
[]
$_SERVER
array:63 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1745863506 "last" => 1745863506...
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.23ms)
  • afterInitialise (11.09MB) (93.89ms)
  • afterRoute (5.03MB) (37.8ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (242μs)
  • afterRenderComponent com_jsjobs (3.14MB) (45.79ms)
  • Before Access::preloadComponents (all components) (239.64KB) (7.76ms)
  • After Access::preloadComponents (all components) (132.72KB) (1.49ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (21μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (371μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.62MB) (124ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (84.4ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (8μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (389μs)
  • afterDispatch (79.16KB) (153μs)
  • afterRender (13.79MB) (257ms)
  • 1 x afterRender (13.79MB) (37.67%)
    257.20ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.62MB) (18.17%)
    124.09ms
    1 x afterInitialise (11.09MB) (13.75%)
    93.89ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (12.36%)
    84.40ms
    1 x afterRenderComponent com_jsjobs (3.14MB) (6.71%)
    45.79ms
    1 x afterRoute (5.03MB) (5.54%)
    37.80ms
    1 x afterLoad (4.12MB) (4.13%)
    28.23ms
    1 x Before Access::preloadComponents (all components) (239.64KB) (1.14%)
    7.76ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.22%)
    1.49ms
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.06%)
    389μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.05%)
    371μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    242μs
    1 x afterDispatch (79.16KB) (0.02%)
    153μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    21μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    8μs
90 statements were executed, 23 of which were duplicates, 67 unique31.18ms304.2KB
  • SELECT @@SESSION.sql_mode;58μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?108μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 1100μ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)252μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`157μ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` = :guest132μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'99μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`93μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'129μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config133μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'90μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'81μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'73μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'81μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-SRO-SA-Consultant-%25e2%2580%2593-Consultancy-assignment-for-the-production-of-a-%25e2%2580%259cPolicy-manual-on-enhanced-Domestic-Resource-Mobilization-in-Zambia-post-COVID-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-49363%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-SRO-SA-Consultant-%25e2%2580%2593-Consultancy-assignment-for-the-production-of-a-%25e2%2580%259cPolicy-manual-on-enhanced-Domestic-Resource-Mobilization-in-Zambia-post-COVID-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-49363%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-SRO-SA-Consultant-%25e2%2580%2593-Consultancy-assignment-for-the-production-of-a-%25e2%2580%259cPolicy-manual-on-enhanced-Domestic-Resource-Mobilization-in-Zambia-post-COVID-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-49363%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC229μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-SRO-SA-Consultant-%25e2%2580%2593-Consultancy-assignment-for-the-production-of-a-%25e2%2580%259cPolicy-manual-on-enhanced-Domestic-Resource-Mobilization-in-Zambia-post-COVID-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-49363%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-SRO-SA-Consultant-%25e2%2580%2593-Consultancy-assignment-for-the-production-of-a-%25e2%2580%259cPolicy-manual-on-enhanced-Domestic-Resource-Mobilization-in-Zambia-post-COVID-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-49363%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-SRO-SA-Consultant-%25e2%2580%2593-Consultancy-assignment-for-the-production-of-a-%25e2%2580%259cPolicy-manual-on-enhanced-Domestic-Resource-Mobilization-in-Zambia-post-COVID-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-49363%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC342μs4.25KB/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.id186μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'386μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'258μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'214μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'331μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'296μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'93μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'78μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'289μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT job.params,job.id,job.title,job.city,job.metakeywords,job.metadescription,job.description,job.created,job.isgoldjob,job.isfeaturedjob,job.gender , job.jobcategory,job.duration,job.hidesalaryrange,job.zipcode,job.iseducationminimax,job.degreetitle,job.isexperienceminimax , job.startpublishing,job.requiredtravel,job.noofjobs,job.hits,job.stoppublishing,job.video,job.prefferdskills,job.qualifications,job.agreement,job.experiencetext,job.longitude,job.latitude , cat.cat_title, subcat.title as subcategory, company.name as companyname, jobtype.title AS jobtypetitle , jobstatus.title AS jobstatustitle, shift.title as shifttitle, company.url as companywebsite, company.contactname AS companycontactname, company.contactemail AS companycontactemail,company.since AS companysince,company.logofilename AS companylogo , department.name AS departmentname, company.id companyid,job.educationminimax,job.experienceminimax , salaryfrom.rangestart AS salaryfrom, salaryto.rangestart AS salaryto, salarytype.title AS salarytype , education.title AS educationtitle ,mineducation.title AS mineducationtitle, maxeducation.title AS maxeducationtitle , experience.title AS experiencetitle ,minexperience.title AS minexperiencetitle, maxexperience.title AS maxexperiencetitle , currency.symbol,CONCAT(job.alias,'-',job.id) AS jobaliasid, agefrom.title AS agefromtitle, ageto.title AS agetotitle ,company.isgoldcompany,company.isfeaturedcompany ,CONCAT(company.alias,'-',company.id) AS companyaliasid, workpermit.name as workpermitcountry ,company.endgolddate,company.endfeatureddate, job.jobapplylink,job.joblink, careerlevel.title AS careerleveltitle ,(SELECT COUNT(id) FROM `icop0_js_job_jobapply` WHERE jobid = job.id) AS totalapply FROM `icop0_js_job_jobs` AS job JOIN `icop0_js_job_categories` AS cat ON job.jobcategory = cat.id JOIN `icop0_js_job_companies` AS company ON job.companyid = company.id JOIN `icop0_js_job_jobtypes` AS jobtype ON job.jobtype = jobtype.id LEFT JOIN `icop0_js_job_ages` AS agefrom ON agefrom.id = job.agefrom LEFT JOIN `icop0_js_job_ages` AS ageto ON ageto.id = job.ageto LEFT JOIN `icop0_js_job_subcategories` AS subcat ON job.subcategoryid = subcat.id LEFT JOIN `icop0_js_job_jobstatus` AS jobstatus ON job.jobstatus = jobstatus.id LEFT JOIN `icop0_js_job_departments` AS department ON job.departmentid = department.id LEFT JOIN `icop0_js_job_salaryrange` AS salaryfrom ON job.salaryrangefrom = salaryfrom.id LEFT JOIN `icop0_js_job_salaryrange` AS salaryto ON job.salaryrangeto = salaryto.id LEFT JOIN `icop0_js_job_salaryrangetypes` AS salarytype ON job.salaryrangetype = salarytype.id LEFT JOIN `icop0_js_job_heighesteducation` AS education ON job.educationid = education.id LEFT JOIN `icop0_js_job_heighesteducation` AS mineducation ON job.mineducationrange = mineducation.id LEFT JOIN `icop0_js_job_heighesteducation` AS maxeducation ON job.maxeducationrange = maxeducation.id LEFT JOIN `icop0_js_job_experiences` AS experience ON job.experienceid = experience.id LEFT JOIN `icop0_js_job_experiences` AS minexperience ON job.minexperiencerange = minexperience.id LEFT JOIN `icop0_js_job_experiences` AS maxexperience ON job.maxexperiencerange = maxexperience.id LEFT JOIN `icop0_js_job_shifts` AS shift ON job.shift = shift.id LEFT JOIN `icop0_js_job_currencies` AS currency ON currency.id = job.currencyid LEFT JOIN `icop0_js_job_countries` AS workpermit ON workpermit.id = job.workpermit LEFT JOIN `icop0_js_job_careerlevels` AS careerlevel ON job.careerlevel = careerlevel.id WHERE job.id = 49363864μs36.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'159μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 493639.05ms48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'263μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering317μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'263μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'238μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering268μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'239μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'250μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'81μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'315μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'289μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'263μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'107μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'95μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2187μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2205μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'608μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield918' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'577μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2173μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2165μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2181μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'251μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'289μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'242μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering183μs4.27KB/components/com_jsjobs/models/customfields.php:59Copy
  • 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)1.07ms8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0152μs936B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22167μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24125μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 28705μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38122μs81.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 39120μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40113μ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` = 0181μ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.lft524μs1.8KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'distribution-channels' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft417μs1.17KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'categories-list' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft529μs2.3KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM icop0_jmap_metainfo WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-SRO-SA-Consultant-–-Consultancy-assignment-for-the-production-of-a-“Policy-manual-on-enhanced-Domestic-Resource-Mobilization-in-Zambia-post-COVID-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-49363' AND `published` = 1159μs9.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-SRO-SA-Consultant-–-Consultancy-assignment-for-the-production-of-a-“Policy-manual-on-enhanced-Domestic-Resource-Mobilization-in-Zambia-post-COVID-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-49363'135μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration330μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'189μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field195μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'123μ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` = 1174μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'212μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`337μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'93μs912B/libraries/src/Table/Table.php:755Copy
  • SELECT a.* FROM icop0_gsd a WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*') ORDER BY a.id desc316μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`426μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid176μs4.41KBParams/libraries/src/Table/User.php:104Copy
  • SELECT `g`.`id`,`g`.`title` FROM `icop0_usergroups` AS `g` INNER JOIN `icop0_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid211μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-SRO-SA-Consultant-–-Consultancy-assignment-for-the-production-of-a-“Policy-manual-on-enhanced-Domestic-Resource-Mobilization-in-Zambia-post-COVID-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-49363'150μ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` = 197μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"374μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.16ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin206μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin158μ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`182μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'198μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'306μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 5095121μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?106μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?416μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy