Call for Expressions of Interest (EOI) to Map the Water, Sanitation and Hygiene (WASH) Financing Landscape in Zambia tender at Wateraid Zambia
Website :
208 Days Ago
Linkedid Twitter Share on facebook

CALL FOR EXPRESSIONS OF INTEREST (EOI) TO MAP THE WATER, SANITATION AND HYGIENE (WASH) FINANCING LANDSCAPE IN ZAMBIA. 

WaterAid Zambia is an international Non-Governmental Organization dedicated to the provision of safe and clean water, decent sanitation, and good hygiene 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 map the Water, Sanitation, and Hygiene (WASH) financing landscape in Zambia. Consultants are encouraged 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 its Terms of Reference. The letter should be addressed to

The Head People & 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     The subject line of your email should read “Application – WASH Financing Landscape Mapping.”
  • The deadline for submission of both technical and financial proposals is Thursday 31st October 2024

TERMS OF REFERENCE

Consultancy to Map the Water, Sanitation and Hygiene (WASH) financing landscape in Zambia.

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. 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). 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. In Zambia, there have been considerable attempts to improve WASH services. The Vision 2030 and the 8NDP identify universal access to water and sanitation as a critical developmental goal. Yet, access to improved water and sanitation services remains one of the nation’s most pressing challenges both in rural and particularly in the densely populated Peri Urban Areas (PUAs). Basic statistics on WASH show that only 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]

Our 2023-2028 strategic Plan is working to contribute to Improved health & well-being of communities especially women and girls by empowering them to demand access to resilient, inclusive, and sustainably financed WASH services by 2028. To attain this, for one, we are working to see increased investment in WASH. The WASH sector has been consistently and significantly underfunded and defunded, especially from the public sector with budget allocations as a share of the total budget on a downward trend over the last 5years dropping from 2.5% in 2020 to 1.1% in 2025. Additionally, Budget performance for the sector remains poor averaging 37% when we compare approved allocations to disbursed funding. Further, the 2023 MOFNP development Finance assessment establishes that about 72% of the sector’s resources are donor financed. Our call: increased, sustained financing for sustainable and inclusive WASH services from diverse sources by 2028.

Given the multi-sectoral nature of water, sanitation and hygiene, different ministries implement various WASH interventions; School Health and Nutrition’s WASH pillar under Ministry of Education, Hygiene and WASH in HCFs under Ministry of Health, waste management and WASH projects under the Ministry of Local Government, WASH interventions under the Ministry of Green Economy and environment and policy direction as well as WASH interventions under Ministry of Water Development and Sanitation (MWDS). Additionally, various Cooperating Partners finance the sector. Most recently, climate mitigation and adaptation targeted sources will increasingly finance WASH.

WaterAid is therefore, seeking the services of a consultant or a firm to undertake a comprehensive mapping of the sources of WASH financing in Zambia’s public sector, establishing trends overtime, understanding the key enablers and challenges in the multisectoral implementation of WASH interventions, key gaps, and bottlenecks. The study will also need to adequately outline to the extent possible other non-public (domestic and international e.g. climate, philanthropy, private etc.) sources of WASH financing establishing the trends over the years.

2.    PURPOSE OF CONSULTANCY

The purpose of the consultancy is to

a) Scope and outline the policy, institutional and regulatory frameworks for the allocation, disbursement, and management of WASH finance in Zambia.

b) Conduct a comprehensive mapping of public sources of WASH financing, clearly identifying corresponding budget lines or the lack of/poor clarity therein.

c) Undertake a disaggregated trend analysis (by Ministries Provinces and Spending Agencies-MPSAs) of WASH financing and budget performance from 2013 to 2023.

d) Analyse factors influencing WASH related budget allocations and performance by sector detailing both challenges and opportunities in this regard.

e) Scope other financing streams for WASH from Cooperating Partners, climate finance among others highlighting key funding sources, trends (allocations and disbursements) where available, challenges and opportunities.

e) Propose actionable recommendations, and a roadmap for potentially game changing actions.

3.    SCOPE OF WORK

Specific Tasks will include:

Outlining key frameworks that govern the allocation, disbursement, and management of WASH finance in Zambia.

1. Analysis of WASH financing and budget lines by sector with a focus on budget credibility and adequacy of funding.

2. Outlining the comprehensiveness of reporting and coordination across sectors

3. Scoping the donor and climate financing landscape detailing the profile of donors/funding sources supporting or with potential to fund the water sector, key noted bottlenecks in funding the sector and opportunities.

4. Documenting key successes and challenges on WASH financing across sectors including drawing lessons from comparable countries.

5. Outline key policy actions and stakeholder roles to ensure sustained investment and improved reporting on WASH investments across sectors.

This assessment will focus on comprehensively mapping the sources of WASH financing in Zambia focusing on public, donor and climate funds. The study will also seek to understand the key enablers and challenges in the multisectoral implementation of WASH interventions, key gaps, and bottlenecks. The report will need to adequately outline to the extent possible, the diverse sources of WASH financing. The study will largely be desk review but will need to be supplemented with Key Informant Interviews with selected critical WASH stakeholders such as the Ministry of Water Development and Sanitation (MWDS), Ministry of Finance and National Planning (MOFNP), Ministry of Health (MOH), Ministry of Education (MOE), Ministry of Local Government and Rural Development (MLGRD), Commercial Utilities (CUs), Civil Society Organisations (CSOs), Cooperating Partners (CPs) and any other stakeholder deemed relevant to draw insights on key bottlenecks and challenges with regards WASH financing.

4. DELIVERABLES

1. Inception Report

2. A Mapping report on WASH financing in Zambia

3. A Summary Policy Brief and infographic.

4. Power point presentation on summary issues identified & recommendation for key stakeholders working on WASH financing.

5. Ethics and risks

I. The consultant is expected to comply with WaterAid’s safeguarding standards, policies, and procedures at all times. WaterAid will undertake safeguarding training for all external consultants, facilitators and research fellows that will be engaged throughout this study.

II. The consultant must adhere to government regulations and WaterAid local security protocols.

III.  The Consultant will work in liaison with Policy Team Lead to identify and obtain approvals required to conduct this work, or to engage key informants.

IV. The consultant will be bound by the General Data Protection Regulations upheld by WaterAid.

6. Outputs and timeline

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

Proposed Schedule

S/N
Task
Duration

  1. Inception meeting and safeguarding briefing – 2 days
  2. Design of KII tools & briefing and review of WaterAid Safeguarding protocol – 2 days
  3. Feedback and input to the existing tool – 1 day
  4. Report Consolidation – 11 days
  5. Review Submitted report – 3 days
  6. Incorporation of inputs – 5 day
  7. 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 primary interviews, search the following sources:

  • Internet search, identifying any published and grey literature relating to WASH financing in Zambia
  • Sector documents provided by WaterAid, partners and any SharePoint sites used by sector partners.
  • Review official reports from the Zambia government, particularly from the MWDS, MOFNP,
  • Review research articles/papers, reports, and publications on WASH financing in Zambia.
  • Conduct Key Informant Interviews (KIIs) and in-depth Interviews (IDIs) with national and international stakeholders.

8.0. Stakeholders’ involvement

Key stakeholders’ involvement will comprise of WASH-focussed/related ministries, development partners and INGOs, Local Authorities school and health administrations, CSOs, WASH service providers, the WASH Legislative Caucus, and any other resource parties deemed relevant.

9.0. Roles and responsibilities 

The role of the consultant is to:

  • Ensure the analysis covers cross-cutting issues such as gender, equity, and social inclusion to address specific needs and vulnerabilities
  • Undertake identification and analysis of relevant external documents.
  • Validate and triangulate the data obtained from the dissimilar 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.

The role of WaterAid is to:

  • Lead on the WASH financing landscape study, making all strategic choices.
  • Oversee and support the consultant in their work, providing clear direction and availing available WaterAid research documents.
  • Agree with the consultant the methodology and tools for this study.
  • 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 of the Consultant

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
  • 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.
  • Experience in developing data collection and analysis tools and interpreting and simplifying research data.
  • Demonstrated experience of conducting similar data analysis or work, to inform policy decision-making and advocacy and planning in the last five years.
  • Knowledge and experience in using statistical packages for the analysis of data.
  • Strong analytical skills of both quantitative and qualitative information
  • Demonstrated Knowledge of public, donor, and climate finance in Zambia (t by team members with the said expertise. Specifics tied to WASH financing will be an added advantage
  • 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 at the field level and overall 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.
  • A public finance expert with demonstratable experience in undertaking tracking and analysis of various public budgets including WASH.
  • A WASH expert with an appreciation of the intricacies of the sector
  • A Climate finance expert with extensive knowledge/experience in Climate financing for WASH.

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.307MBMemory Usage553msRequest 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
[]
$_SERVER
array:63 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1747164718 "last" => 1747164718...
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) (21.83ms)
  • afterInitialise (11.09MB) (96.9ms)
  • afterRoute (5.06MB) (35.83ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (219μs)
  • afterRenderComponent com_jsjobs (3.18MB) (33.21ms)
  • Before Access::preloadComponents (all components) (251.64KB) (4.79ms)
  • After Access::preloadComponents (all components) (132.72KB) (938μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (12μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (237μs)
  • afterDispatch (2.35MB) (106ms)
  • afterRender (31.53MB) (253ms)
  • 1 x afterRender (31.53MB) (45.69%)
    252.72ms
    1 x afterDispatch (2.35MB) (19.08%)
    105.53ms
    1 x afterInitialise (11.09MB) (17.52%)
    96.90ms
    1 x afterRoute (5.06MB) (6.48%)
    35.83ms
    1 x afterRenderComponent com_jsjobs (3.18MB) (6%)
    33.21ms
    1 x afterLoad (4.12MB) (3.95%)
    21.83ms
    1 x Before Access::preloadComponents (all components) (251.64KB) (0.87%)
    4.79ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.17%)
    938μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.04%)
    237μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    219μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    12μs
89 statements were executed, 23 of which were duplicates, 66 unique24.92ms334.22KB
  • SELECT @@SESSION.sql_mode;43μ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 196μ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)4.37ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`90μ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` = :guest123μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'122μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`92μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'141μ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'88μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'83μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'282μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'160μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Call-for-Expressions-of-Interest-EOI-to-Map-the-Water%2C-Sanitation-and-Hygiene-WASH-Financing-Landscape-in-Zambia-tender-at-Wateraid-Zambia-67214%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-EOI-to-Map-the-Water%2C-Sanitation-and-Hygiene-WASH-Financing-Landscape-in-Zambia-tender-at-Wateraid-Zambia-67214%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Call-for-Expressions-of-Interest-EOI-to-Map-the-Water%2C-Sanitation-and-Hygiene-WASH-Financing-Landscape-in-Zambia-tender-at-Wateraid-Zambia-67214%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC313μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Call-for-Expressions-of-Interest-EOI-to-Map-the-Water%2C-Sanitation-and-Hygiene-WASH-Financing-Landscape-in-Zambia-tender-at-Wateraid-Zambia-67214%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-EOI-to-Map-the-Water%2C-Sanitation-and-Hygiene-WASH-Financing-Landscape-in-Zambia-tender-at-Wateraid-Zambia-67214%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Call-for-Expressions-of-Interest-EOI-to-Map-the-Water%2C-Sanitation-and-Hygiene-WASH-Financing-Landscape-in-Zambia-tender-at-Wateraid-Zambia-67214%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC272μ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.id148μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'401μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'216μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'130μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'248μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'282μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'63μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'69μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'276μ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 = 67214817μs76.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'286μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 67214308μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'256μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering278μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'277μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'235μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering200μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'245μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'209μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'64μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'79μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'251μs1.38KB/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 configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'67μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'60μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2190μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 289μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'382μ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'397μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2157μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2123μ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'245μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'310μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'204μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering188μ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)645μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 092μ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` = 24168μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 28135μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38157μs73.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40126μ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` = 0106μ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.lft461μ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.lft283μ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.lft498μ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-EOI-to-Map-the-Water,-Sanitation-and-Hygiene-WASH-Financing-Landscape-in-Zambia-tender-at-Wateraid-Zambia-67214' AND `published` = 1231μ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-EOI-to-Map-the-Water,-Sanitation-and-Hygiene-WASH-Financing-Landscape-in-Zambia-tender-at-Wateraid-Zambia-67214'96μs8.94KB/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration325μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'136μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field136μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'108μ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` = 1141μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'219μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`310μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'96μ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 desc205μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`406μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid164μ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` = :muserid153μ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-EOI-to-Map-the-Water,-Sanitation-and-Hygiene-WASH-Financing-Landscape-in-Zambia-tender-at-Wateraid-Zambia-67214'102μ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` = 178μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"352μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.08ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin111μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin83μ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`150μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'90μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'195μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 213987μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?105μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.38ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy