Call for Expressions of Interest to Undertake Constituency Development Fund Utilisation Assessment in Selected Provinces (Lusaka, Western and Southern Provinces in Zambia) tender at Wateraid Zambia
Website :
208 Days Ago
Linkedid Twitter Share on facebook

WaterAid Zambia is an international Non-Governmental Organization dedicated to the provision of safe domestic water, sanitation, and hygiene education to the world’s poorest. WaterAid Zambia currently operates in Six (06) districts; Lusaka, Monze, Sesheke, Mwandi, and Nkeyema districts.
WaterAid Zambia is now inviting Expressions of Interest from eligible Consultants to undertake a Constituency Development Fund Utilisation assessment with a focus on the utilisation of CDF for water, sanitation, and hygiene in selected constituencies in Zambia (2 in Lusaka, 1 in Nkeyema and 1 in Monze).

Consultants are urged to acquire data from relevant sources to inform their EOI.

Expressions of interest application process and submission

Interested candidates (individual consultants or firms) are required to submit the following documentation:

  • Cover letter detailing their suitability to undertake this assignment as per detailed Terms of Reference (TORs). The letter should be addressed to:

The People and Organizational Development
Water Aid Zambia
House No. 21A Middle Way, Kabulonga
Postnet No. 81 P/Bag E891
Lusaka, Zambia

  • Technical and financial proposals with specific focus addressing the purpose and objectives of the assignment, methodology to be used, key selection criteria and draft data collection tools and interview guides.
  • Initial work plan based on the methodology outlined.
  • Company or individual profile or CV including a minimum of 3 references.
  • Detailed budget breakdown.
  • The CVs of key support staff (in the case of a firm)
  • Full Technical and Financial Proposals together with all supporting documentation should be submitted to ZambiaCareers@wateraid.org and copy in EmilyChuunga@wateraid.org. The subject line of your email should read “Application – CDF Utilization Assessment.”
  • The deadline for submission of both technical and financial proposals is Thursday 31st October 2024.

TERMS OF REFERENCE

Short term consultancy to undertake an Assessment of the Utilisation of the Constituency Development Fund (CDF) for Water, Sanitation and Hygiene (WASH) in 3 districts in selected constituencies (2 in Lusaka, 1 in Nkeyema and 1 in Monze).

WaterAid is an international, not-for-profit organization established in Zambia in 1981. We work to change the lives of the poorest and most marginalized people by making clean water, decent toilets, and good hygiene normal for everyone, everywhere within a generation. Since inception, WaterAid Zambia has reached over 3 million people. We currently operate in Lusaka, Monze, Kazungula, Mwandi, Sesheke and Nkeyema Districts.

1. BACKGROUND
Access to water and sanitation is one of the United Nations’ Sustainable Development Goals (SDGs) goals. Targets 6.1, and 6.2 collectively aim to ensure universal access to safe and affordable drinking water and achieve adequate and equitable sanitation and hygiene for all by 2030. With only six years remaining before review of progress on achievement of the (Sustainable Development Goals (SDGs)) in 2030, access to improved water and sanitation services remains one of the nation’s most pressing challenges. Basic statistics on WASH show that 72.3% of Zambians have access to clean drinking water, while 54% have access to adequate sanitation and 24,7% have access to hygiene. [1]
Considerable efforts by government and other stakeholders towards changing the status of the Water Sanitation and Hygiene (WASH) sector in Zambia have however been noted. These include the nation’s Vision 2030 and the 8NDP that both identify universal access to water and sanitation as a critical developmental goal. Others include the Sanitation and Water for All (SWA 2010) commitment.

Zambia’s development agenda outlined in the Vision 2030 and the 8th National Development Plan (2022-2026) aims to increase access to clean water to 100 percent and access to sanitation facilities to 90 percent. Evidently, Zambia will need additional resourcing to meet its Vision 2030 targets of equitable distribution of water and sanitation services in the country especially in the rural and peri-urban areas.

In 2021, Government allocations to the Constituency Development Fund (CDF) in the 2022 national budget substantially increased in a bid to provide additional resources for implementing community-driven projects. The allocation to CDF has since been growing steadily. From an allocation of K1.6m in 2021, this allocation now stands at K36.6 million per constituency. Over 50 percent of these funds is earmarked to support various community level projects including water, sanitation, and hygiene. The total allocation to CDF for all constituencies is now pegged at K5.6 billion in 2025.

The expanded CDF is targeted to contribute to bridging the gap of investment required to increase access to basic services. With the huge funding gaps that WASH faces, CDF is seen as a key opportunity to enhance WASH outcomes at the district level. Particularly, the CDF is envisaged to support WASH at community level and in public facilities such as schools and Health Care Facilities (HCFs). The government has therefore been categorical on the need to prioritize utilization of CDF to improve access to WASH. Additionally, in its Medium-Term Budget Plan, the government requires that each district prioritizes water, sanitation, and hygiene and every HCF establishes WASH inclusive maternity annexes.

WaterAid Zambia is thus seeking the services of a consultant or a firm to undertake a utilisation assessment of the Constituency Development Fund. The assessment will focus on assessing to what extent the CDF has been utilized for WASH as per government directive to increase prioritization of WASH under the Fund.

2. PURPOSE OF CONSULTANCY

The purpose of the consultancy is to

a) Detail the policy, institutional and regulatory frameworks for CDF in Zambia
b) Compare and graphically present annual CDF budget allocations for 2022-2023 and the first half of 2024, disbursements (both from Ministry of Finance and al national Planning and Ministry of Local Government and Rural Development) as well as Local Authorities’ expenditure.
c) Establish the profile of community proposals detailing the type of community projects requested by communities.
d) Detail the profile of successful applicants of CDF funds by type of projects.
e) Establish main expenditure categories of the CDF community projects and disaster management and mitigation components making clear spend by sector and project type. Specifically illustrate percentage allocation to WASH overall and particularly CDF expenditure on WASH in schools, WASH in HCFs and WASH in communities.
f) Detail the scope of WASH interventions undertaken under the CDF and tabulate the corresponding budgets and incurred costs of such interventions.
g) Detail any CDF funds that are used as a match fund on other WASH projects.
h) Analyse and comment on the enablers, challenges and gaps faced by Local Authorities, CDF Committees, Ward Development Committees, and communities in the implementation of the government directive on increased prioritisation of WASH under the CDF
i) Produce Case Studies on the lived experiences of communities (both positive and negative) in accessing WASH services under the CDF informed by community members insights into the challenges and successes experienced.
j) Formulate recommendations, (can include interventions and mechanisms) to enhance the utilisation of CDF for WASH

3. SCOPE OF WORK

Specific Tasks will include:

1. Review of National and district level budgets, expenditure reports and other relevant documentation to establish and illustrate key financing and expenditure lines, successes, and constraints in the utilisation of CDF.
2. Analysis of the financing, disbursement and expenditure chain of the CDF detailing key procedures and requirements.
3. Review 8NDP Annual Progress reports and other key documents to document WASH interventions under the CDF.
4. Comprehensively illustrate CDF expenditures on WASH.
5. Outline key bottlenecks/challenges in the utilization of CDF for WASH.
6. Outline key policy actions and stakeholder roles needed to ensure increased utilization of the CDF for WASH. Make clear recommendations on practical ways government pronouncement on the prioritisation of WASH under the CDF can be actualised.

This assessment will focus on analyzing how CDF has performed in keeping with the government directive for the increased prioritization of WASH under the CDF, understanding both the enablers and barriers of this performance, notable gaps as well as bottlenecks to be addressed. The report will also need to highlight the role of CDF in supporting the agenda of increased investments in WASH. The study will have to balance between desk review and primary data with a focus on Key Informant Interviews with selected critical CDFstakeholders such as the Ministry of Local Government and Rural Development (MLGRD), Ministry of Finance and National Planning (MOFNP), Ministry of Water development and Sanitation (MWDS), Members of Parliament, Local Authorities, CDF Committees, Ward Development Committees, and communities, to draw needed insights.

4. DELIVERABLES

1. Inception report
2. Utilisation assessment report on CDF on WASH.
3. A summary Policy Brief and an Infographic
4. A power point presentation on summary issues identified & recommendation for key stakeholders working to advance increased utilisation of CDF for WASH.

5. Ethics and risks

I. The consultant is expected to comply with WaterAid’s safeguarding standards, policies and procedures at all times. WaterAid undertakes safeguarding training for all external consultants, facilitators and research fellows that will be engaged in this study.
II. The consultant is to adhere to government regulations and WaterAid local security protocols.
III. The Consultant will work in liaison with Policy Team Lead to identify any needed approvals required to conduct this work, or to engage key informants, including how the consultant will obtain the ethical approval.
IV. The consultant will be bound by the General Data Protection Regulation upheld by WaterAid.

6. Outputs and timeline
The Consultant will undertake this consultancy in Lusaka over a period of approximately 25 days from 18th November to 20th December 2024 (working days). This contract will be between WaterAid Zambia, and the Consultant selected for this work. WaterAid will do this at a fixed fee determined by agreement based on the number of consultancy days proposed. In entering a contract with WaterAid Zambia, the Consultant must ensure that they complete the entire scope of work within the available resources.

Schedule
S/N Task Duration

1 Inception meeting (Inception Reports and safeguarding briefing) 2 days
2 Design of data collection and KII tools 2 days
4 Feedback and input to the existing tool 1 day
6 Consolidation of the study report 11 days
8 Review of submitted report 3 days
9 Incorporation of inputs 5 days
10 Submission of final report 1 day
Total days 25

7.0. Methodology and sampling
This is a mixed method study involving qualitative and quantitative approaches.
The consultant will in addition to earmarked primary interviews, search the following sources:

  • Internet search, identifying any published and grey literature relating to WASH and CDF in Zambia
  • Sector documents provided by WaterAid, and other sector partners including CDF study reports, CDF guidelines etc.
  • Review official reports from the Zambian government, particularly from the MLGRD, MWDS, MOFNP, etc.
  • Review reports and any other publications from organizations such as think tanks, research institutions, Local Government Association of Zambia etc. on WASH and CDF.

8.0. Stakeholders’ involvement
Key stakeholders’ involvement will comprise of WASH-focussed/related government ministries, Local agencies and commissions of the government, development partners and INGOs, Local Authorities community leaders and members, CSOs and service providers, the WASH Legislative Caucus, and any other resource parties deemed relevant.

9.0. Roles and responsibilities
The role of the consultant is:

  • Conduct analysis and synthesis of various internal documentation.
  • Ensure the analysis covers cross-cutting issues such as gender, equity, and social inclusion to address the specific needs and vulnerabilities of the affected population.
  • Undertake identification and analysis of relevant external documents.
  • Validate and triangulate the data obtained from the diverse sources, including interviews, documents among others to ensure accuracy and consistency of the information.
  • Conduct interviews with WaterAid staff, government officials, INGOs, UN agencies, partners, CSOs and any other relevant stakeholders.
  • Participate in follow up stakeholder engagements as need arises.
  • Develop the earmarked research outputs.

The role of WaterAid is to:

  • Lead on this study, making all strategic choices.
  • Oversee and support the consultant in their work, providing clear direction and availing available WaterAid research documents on CDF.
  • Agree with the consultant the methodology and tools for this work.
  • Facilitate contact between the consultant and relevant WaterAid staff.
  • Facilitate contact between the consultant and relevant government departments, partner organisations and other external stakeholders.
  • Sign off on the consultant’s work.
  • Provide overall quality assurance of the process.

10. Profile
WaterAid is looking for a lead consultant who meets the following requirements:

  • Postgraduate qualifications in any of the following: Economics, Development Studies, Engineering, Social work, or any relevant discipline.
  • At least 10 years of relevant leadership experience, including serving as team leader.
  • Demonstrated training and senior- level experience in conducting qualitative and quantitative research.
  • Demonstrated experience of conducting similar data analysis or work, including performance assessment, formative research, and assessment to inform policy decision-making and advocacy, and planning in the last five years.
  • Experience in developing data collection and analysis tools and interpreting and simplifying research data.
  • Knowledge and experience in using statistical packages for the analysis of data.
  • Strong analytical skills of both quantitative and qualitative information.
  • Knowledge of CDF and public finance in Zambia.
  • Experience in undertaking desk review and collating key information or anything similar.
  • Experience in conducting interviews with diverse types of Key Informants including government officials, CSOs, among others.
  • Excellent and demonstratable communication, report writing and presentation skills, especially in English.
  • Basic knowledge of WASH issues particularly financing for WASH
  • Timely delivery of expected outputs from the assessment
  • Relevant general management or technical education and background.
  • Practical working experience in the management and administration of research projects and administration.
  • Demonstrated ability to work closely and effectively with relevant partner organizations.
  • Extensive in-country experience in undertaking research.

Additional Expertise and Inputs

The Consultant will provide, for the duration of the proposed project, the full human resource complement to ensure effective completion of this assignment. The consultants are expected to commence their services as per the agreed work plan. It is expected at the very least that the consultancy team will constitute the following credentials.

1. A public finance expert with demonstratable experience in undertaking tracking and analysis of various public budgets including the CDF.
2. A WASH expert with an appreciation of the intricacies of the sector

13.0. Proposed budget
The consulting firm or individual consultant will provide an estimated, realistic, and itemized budget to produce the expected outputs. The budget should separate consultancy fees and any earmarked reimbursable expenses.

Job Info
Job Category: Tenders in Zambia
Job Type: Full-time
Deadline of this Job: Thursday, October 31 2024
Duty Station: Lusaka
Posted: 17-10-2024
No of Jobs: 1
Start Publishing: 17-10-2024
Stop Publishing (Put date of 2030): 17-10-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
60.336MBMemory Usage373msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.29-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "1deb24708f7a51ca02b447b7f6862276" => "ad2d7538e1a10c2dcbe9f1cf1027047b" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1747175032 "last" => 1747175032...
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) (17.42ms)
  • afterInitialise (11.13MB) (57.85ms)
  • afterRoute (5.06MB) (23.04ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (170μs)
  • afterRenderComponent com_jsjobs (3.16MB) (25.85ms)
  • Before Access::preloadComponents (all components) (251.64KB) (4.66ms)
  • After Access::preloadComponents (all components) (132.72KB) (900μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (13μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (233μs)
  • afterDispatch (2.36MB) (56.55ms)
  • afterRender (31.53MB) (186ms)
  • 1 x afterRender (31.53MB) (49.75%)
    185.53ms
    1 x afterInitialise (11.13MB) (15.51%)
    57.85ms
    1 x afterDispatch (2.36MB) (15.16%)
    56.55ms
    1 x afterRenderComponent com_jsjobs (3.16MB) (6.93%)
    25.85ms
    1 x afterRoute (5.06MB) (6.18%)
    23.04ms
    1 x afterLoad (4.12MB) (4.67%)
    17.42ms
    1 x Before Access::preloadComponents (all components) (251.64KB) (1.25%)
    4.66ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.24%)
    900μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.06%)
    233μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.05%)
    170μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    13μs
89 statements were executed, 23 of which were duplicates, 66 unique16.63ms334.25KB
  • SELECT @@SESSION.sql_mode;105μ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 195μ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_id234μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`83μ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` = :guest140μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'81μ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'142μ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'112μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'39μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'39μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'36μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Call-for-Expressions-of-Interest-to-Undertake-Constituency-Development-Fund-Utilisation-Assessment-in-Selected-Provinces-Lusaka%2C-Western-and-Southern-Provinces-in-Zambia-tender-at-Wateraid-Zambia-67215%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Call-for-Expressions-of-Interest-to-Undertake-Constituency-Development-Fund-Utilisation-Assessment-in-Selected-Provinces-Lusaka%2C-Western-and-Southern-Provinces-in-Zambia-tender-at-Wateraid-Zambia-67215%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Call-for-Expressions-of-Interest-to-Undertake-Constituency-Development-Fund-Utilisation-Assessment-in-Selected-Provinces-Lusaka%2C-Western-and-Southern-Provinces-in-Zambia-tender-at-Wateraid-Zambia-67215%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC140μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Call-for-Expressions-of-Interest-to-Undertake-Constituency-Development-Fund-Utilisation-Assessment-in-Selected-Provinces-Lusaka%2C-Western-and-Southern-Provinces-in-Zambia-tender-at-Wateraid-Zambia-67215%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Call-for-Expressions-of-Interest-to-Undertake-Constituency-Development-Fund-Utilisation-Assessment-in-Selected-Provinces-Lusaka%2C-Western-and-Southern-Provinces-in-Zambia-tender-at-Wateraid-Zambia-67215%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Call-for-Expressions-of-Interest-to-Undertake-Constituency-Development-Fund-Utilisation-Assessment-in-Selected-Provinces-Lusaka%2C-Western-and-Southern-Provinces-in-Zambia-tender-at-Wateraid-Zambia-67215%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC293μ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.id157μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'209μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • 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 = 'social'182μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'217μ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 configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'91μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'67μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'222μ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 = 67215642μs76.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'217μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 67215345μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'245μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering287μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'237μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'245μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering246μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'190μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'257μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'59μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'54μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'231μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'220μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'55μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'49μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2142μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2134μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'489μ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'511μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2171μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2122μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2116μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'276μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'303μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'241μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering165μ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)651μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 083μs920B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2286μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2486μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2875μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38147μs73.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40178μ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` = 0128μ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.lft316μ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.lft171μ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.lft329μ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-Call-for-Expressions-of-Interest-to-Undertake-Constituency-Development-Fund-Utilisation-Assessment-in-Selected-Provinces-Lusaka,-Western-and-Southern-Provinces-in-Zambia-tender-at-Wateraid-Zambia-67215' AND `published` = 1120μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Call-for-Expressions-of-Interest-to-Undertake-Constituency-Development-Fund-Utilisation-Assessment-in-Selected-Provinces-Lusaka,-Western-and-Southern-Provinces-in-Zambia-tender-at-Wateraid-Zambia-67215'87μs8.94KB/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration309μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'104μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field96μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'76μ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` = 1105μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'171μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`275μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'62μ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 desc154μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`252μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid100μ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` = :muserid140μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Call-for-Expressions-of-Interest-to-Undertake-Constituency-Development-Fund-Utilisation-Assessment-in-Selected-Provinces-Lusaka,-Western-and-Southern-Provinces-in-Zambia-tender-at-Wateraid-Zambia-67215'106μ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` = 169μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"347μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES991μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin84μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin70μ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`98μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'102μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'156μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 213970μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?102μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?328μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy