Final Evaluation Consultant for a Project in Zambia tender at Sign of Hope
Website :
193 Days Ago
Linkedid Twitter Share on facebook

Organisation

Hoffnungszeichen | Sign of Hope e.V.

www.hoffnungszeichen.dewww.sign-of-hope.org

Position

Final Evaluation Consultant

Type of Contract

Short-term consultancy

Location

Home-based with field mission travel to Kalumbila, Mwinilunga and Kasempa Districts, Zambia

Relevant Languages

English (required), Bemba (desirable)

Application Deadline

October 21st, 2024

Starting Date

November 11st, 2024

Project Title

Improving Water and Sanitation for Local Communities in Northwestern Zambia

Total Project Budget

392,415.00 EUR.

Hoffnungszeichen | Sign of Hope e.V. (SoH) is announcing an open tender procedure for consultancy services for a final evaluation in Zambia.

Background and Rationale

Hoffnungszeichen | Sign of Hope e.V. (SoH) is a Christian motivated organisation for Human Rights, Humanitarian Assistance and Development Cooperation. From its base in Constance, Germany, SoH is committed to helping those in distress and exploited people worldwide.

This final evaluation is commissioned under the German Federal Ministry for Economic Cooperation and Development (BMZ) budget for development projects run by private organisations.

 
 

SoH is the private German executing agency and the contracting party, with Development Aid from People to People – Zambia (DAPP)being the local implementing partner.

The focus of the project is to improve the health and drinking water supply for people in the North West Province of Zambia through sustainable access to safe water, sanitation and hygiene and capacity building on community and district level.

The target group includes 25,000 direct beneficiaries from 5,000 households living in estimated 180 villages in the districts Kalumbila, Kesamba and Mwinilunga, Zambia. 20,000 people will directly benefit rehabilitated water points (in households, schools and health facilities). 3,000 children from 10 community schools will have access to improved latrines. 22,500 people will benefit from hygiene promotion, saving clubs, access to latrine san-plates and pumps through social marketing. Women represent at least 50% of the targeted group. Over 300.000 indirect beneficiaries will reached by the project.

Purpose, Objectives and Use

The purpose of the evaluation is to provide SoH and DAPP Zambia with a comprehensive assessment of the project, conducted systematically and impartially, as well as analyse the implementation and results of the project, propose actions to ensure sustainability of the results, identify lessons learned and information for potential future projects. The study will provide concrete, credible and practical recommendations that will assist with the timely incorporation of the findings into the decision-making process and contribute to the organisational learning of both implementing organisations.

The study will support the project quality assurance measures implemented by SoH and meet the donor requirements towards the development projects implemented by German private organisations.

 
 

The evaluation will address evaluation questions based on the standard OECD/DAC evaluation criteria of relevance, coherence, effectiveness, efficiency, sustainability, and impact (please see http://www.oecd.org/development/evaluation/daccriteriaforevaluatingdevelopmentassistance.htm). The objectives of the evaluations are to:

  1. Assess the extent to which the project has sustainably achieved its objectives and results (see annexe 1), including the extent to which the lives of the project beneficiaries have been improved,
  2. Identify the strengths and weaknesses in terms of planning, management, implementation and monitoring of the project,
  3. Evaluate sustainability measures,
  4. Identify cross-cutting issues addressed through the project, including gender equality, human rights, marginalised groups, inclusion, and other issues,
  5. Determine the effects of Covid-19 on the project, its activities and implementing organisation,
  6. Document lessons learned that could contribute to the improvement of the design of future projects.

Duties and Responsibilities

The Evaluation Consultant will work in close cooperation with the responsible SoH Officer and the local implementing partner.

The duties and responsibilities of the Evaluation Consultant will include:

  • Develop a work plan outlining the proposed research methodology, geographical coverage and schedule to conduct the study,
  • Conduct a desk review of relevant documents,
  • Carry out a project site visit to a project location to conduct research, collect data and establish contact with the local implementing partner, project beneficiaries and relevant project stakeholders,
  • Review and evaluate available data and existing sources of information, including the project proposal, annual reports, conducted studies and other documents,
  • Examine institutional, technical, staffing and financial capacities of the implementing partner as well as its relationship with the target group and other relevant stakeholders.

Expected Deliverables

The study will produce the following deliverables:

  • an inception report, including the proposed research methodology and data collection tools, a table of content and timeline of research activities prior to the site visit to the project location,
  • a comprehensive report of a maximum of 30 pages with practical recommendations and relevant annexes (including raw data and documented records).

A template will be provided to serve as a guide and may be used to structure the final report.

Study Quality and Ethical Standards

The study team will take all reasonable steps to ensure that the study is designed and conducted to respect and protect the rights and welfare of the people and communities involved. Furthermore, the study should be aligned to the following standards and applicable practices:

  • Utility: the study must be useful and used.
  • Feasibility: the study must be realistic, diplomatic and managed in a sensible, cost-effective manner.
  • Ethics and Legality: the study must be conducted in an ethical and legal manner, with particular regard for the welfare of those involved in and affected by the Study.
  • Impartiality and Independence: the study should be impartial, providing a comprehensive and unbiased assessment that takes into account the views of all stakeholders.
  • Transparency: the study activities should reflect an attitude of openness and transparency.
  • Accuracy: the study should be technically accurate and credible, providing sufficient information about the data collection, analysis, and interpretation methods so that its worth or merit can be determined.
  • Participation: the Stakeholders should be consulted and meaningfully involved in the study process when feasible and appropriate.
  • Collaboration: Collaboration between key operating partners in the study process improves the legitimacy and utility of the study.

The study must be in line with the SoH guiding principles and Code of Conduct.

Process/Timeframe

The total duration of the assignment is up to 25 working days within the period from 11.11.2024 to 02.12.2024.

Planning meeting with SoH (remotely), handover of relevant documents 1 day

 
 

Initial document review and inception report preparation 4 days

Sharing inception report with SoH and DAPP Zambia 1 day

Finalisation of inception report 1 day

Data collection site visit to a project location 5-10 days

Data analysis, draft report with annexes 5-10 days

Incorporating received feedback and report finalisation 3-5 days

Qualifications and Experience

Essential:

  • Minimum of 5 years of project evaluation and/or implementation experience in the result-based management framework
  • Proven experience of conducting feasibility studies, evaluations and other research projects
  • Technical and methodological knowledge to conduct research projects and formulate conclusions based on a solid methodology, assessing projects for relevance, coherence, effectiveness, efficiency, impact and sustainability of projects
  • Experience working with non-governmental organisations (NGOs) and partnered projects
  • Fluency in written and spoken English

Desirable:

  • Experience in the relevant field/sector
  • Professional familiarity with the project country/region
  • Practical experience of working for and/or evaluating BMZ-funded projects
  • Fluency in written and spoken Bemba

Academic Background

An advanced level university degree (Masters’ degree or equivalent) in social sciences, public administration, international development studies, law, WASH or similar A first-level university degree in combination with additional years of qualifying experience may be accepted.

The Evaluation Consultant is to be independent and impartial with no liabilities to any other organisation or government entity regarding this evaluation.

How to apply

Application Process

Please submit the following documents as PDF files with the subject line “Final-Evaluation DC-ZMB22.01 in Ndola, Zambia” to procurement@sign-of-hope.org no later than October 21, 2024, 23:59 CEST:

  • A resumé indicating all relevant experience (max. 2 pages),
  • contacts of at least two professional referees,
  • a cover letter, including a brief description of the proposed research methodology (technical proposal max. 1 page) and a comprehensive breakdown of costs (financial proposal), including professional fees and all other relevant costs, including travel expenses (e.g. car hire, other transportation), daily allowances, accommodation, and food
  • a writing sample of the document of similar research value (e.g. a feasibility study, an evaluation report).

Note: The local implementing partner will not support the consultant with food, accommodation and transport.

Companies as well as independent consultants are invited for this tender. Female and differently abled candidates are strongly encouraged to apply.

Please note that due to a large number of applications we may limit establishing contact to shortlisted applicants.

Bids received after deadline will not be considered. If offers are incomplete, bidders may be able to hand in missing documents within a deadline upon request by SoH.

The selection of the consultant will be conducted jointly by DAPP Zambia and SoH. Interviews with shortlisted candidates will be held online in the week of October 21 to October 25, 2024.

The consultancy agreement will be set up by SoH and DAPP Zambia. Consultancy agreements set up by consultants won’t be accepted.

Criteria and weighting for the evaluation of the submitted proposals:

  1. Essential and desirable competencies, proposed methodology: 30 %
  2. Financial proposal (fee): 30 %
  3. Performance during interview: 20 %
  4. Writing samples: 10 %
  5. Minimum amount of years of relevant experience: 5 %
  6. Language skills: 5 %

Annexe 1: Impact Matrix
Annexe 2: Structure Evaluations

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

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
60.057MBMemory Usage560msRequest 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" => 1745674281 "last" => 1745674281...
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) (27.21ms)
  • afterInitialise (11.08MB) (71.48ms)
  • afterRoute (5.03MB) (32.38ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (236μs)
  • afterRenderComponent com_jsjobs (3.16MB) (29.68ms)
  • Before Access::preloadComponents (all components) (247.64KB) (6.81ms)
  • After Access::preloadComponents (all components) (132.72KB) (995μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (21μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (357μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.62MB) (114ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (89.49ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (8μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (397μs)
  • afterDispatch (87.48KB) (153μs)
  • afterRender (13.81MB) (186ms)
  • 1 x afterRender (13.81MB) (33.17%)
    185.67ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.62MB) (20.35%)
    113.92ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (15.99%)
    89.49ms
    1 x afterInitialise (11.08MB) (12.77%)
    71.48ms
    1 x afterRoute (5.03MB) (5.78%)
    32.38ms
    1 x afterRenderComponent com_jsjobs (3.16MB) (5.3%)
    29.68ms
    1 x afterLoad (4.12MB) (4.86%)
    27.21ms
    1 x Before Access::preloadComponents (all components) (247.64KB) (1.22%)
    6.81ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.18%)
    995μs
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.07%)
    397μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.06%)
    357μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    236μs
    1 x afterDispatch (87.48KB) (0.03%)
    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 unique18.01ms336.2KB
  • SELECT @@SESSION.sql_mode;77μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?88μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 168μ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)244μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`79μ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` = :guest113μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'67μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`60μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'122μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config146μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'81μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'55μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'54μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'58μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Final-Evaluation-Consultant-for-a-Project-in-Zambia-tender-at-Sign-of-Hope-67065%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Final-Evaluation-Consultant-for-a-Project-in-Zambia-tender-at-Sign-of-Hope-67065%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Final-Evaluation-Consultant-for-a-Project-in-Zambia-tender-at-Sign-of-Hope-67065%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC202μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Final-Evaluation-Consultant-for-a-Project-in-Zambia-tender-at-Sign-of-Hope-67065%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Final-Evaluation-Consultant-for-a-Project-in-Zambia-tender-at-Sign-of-Hope-67065%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Final-Evaluation-Consultant-for-a-Project-in-Zambia-tender-at-Sign-of-Hope-67065%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC228μ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.id140μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'219μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'169μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'206μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'232μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'259μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'67μ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'234μ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 = 67065626μs68.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'206μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 67065387μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'223μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering261μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'232μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'243μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering232μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'225μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'233μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'66μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'58μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'177μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'202μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'95μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'58μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2137μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 294μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'503μ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'480μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2144μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2131μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2126μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'225μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'271μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'206μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering168μ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)613μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0102μs936B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2297μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24101μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2896μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38130μs81.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 39103μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40119μ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` = 0101μ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.lft422μ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.lft262μ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.lft510μ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-Final-Evaluation-Consultant-for-a-Project-in-Zambia-tender-at-Sign-of-Hope-67065' AND `published` = 1165μs9.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Final-Evaluation-Consultant-for-a-Project-in-Zambia-tender-at-Sign-of-Hope-67065'83μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration266μ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_field143μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'124μ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` = 1136μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'166μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`327μ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 desc193μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`373μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid152μ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` = :muserid192μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Final-Evaluation-Consultant-for-a-Project-in-Zambia-tender-at-Sign-of-Hope-67065'131μ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` = 1100μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"379μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.02ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin118μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin94μ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`111μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'93μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'232μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 624871μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?92μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?970μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy