Terms of Reference (ToR) for the Restoring Children’s and Young Peoples Lost Aspiration, Integrity and Mental well-being (ReCLAIM) Project Evaluation tender at Regional Psychosocial Support Initiative
91 Days Ago
Linkedid Twitter Share on facebook

Terms of Reference (ToR) for the Restoring Children’s and Young Peoples Lost Aspiration, Integrity and Mental well-being (ReCLAIM) Project Evaluation

1. Summary

Purpose:
A summative evaluation to assess the extent to which the ReCLAIM Project objectives were met. This will include assessing the project’s outputs and outcomes, exploring strengths, weaknesses, and providing recommendations for future programming.

2. Background

REPSSI (Regional Psychosocial Support Initiative) is a renowned pan-African organization that has been supporting governments and non-governmental organizations in providing holistic psychosocial care and support to children and their families in East and Southern Africa (ESA) for over 20 years. REPSSI’s programs aim to enhance the psychosocial and mental well-being of girls, boys, youth, their families, and communities, enabling them to respond to challenges such as HIV/AIDS, conflict, poverty, climate change, environmental disasters, and social strife. REPSSI also integrates psychosocial support (PSS) through opportunities in education, health services, and Sexual and Reproductive Health (SRH).

With funding from Comic Relief, REPSSI is currently implementing the ReCLAIM Project in Zambia, focusing on enhancing the capacity of community structures to be responsive and offer support to children and young people with or at risk of developing mental health issues.

2.1 Project Description

The ReCLAIM Project, launched in 2020 and funded by Comic Relief, aims to enhance community support for children and youth (ages 5–24) who are at risk of or already facing mental health challenges. The project is implemented in the following regions of Zambia: Chipata, Katete, Livingstone, and Kazungula, located in Zambia’s Eastern and Southern provinces.

2.2 Objectives of the Project

The main objectives of the ReCLAIM Project are:

  • To build the capacity of community structures to support mental health.
  • To strengthen the resilience of children and youth at risk.
  • To improve access to mental health services.
  • To enhance the policy environment for youth mental health.

2.3 Key Project Deliverables

  • Outcomes:
    • Enhanced knowledge and skills of beneficiaries.
    • Increased mental health awareness.
  • Outputs:
    • Service provider mapping and care pathways.
    • Development of training curricula, manuals, and IEC materials.
    • Sessions and home visits conducted.
    • Referrals and linkages established.
  • Activities:
    • Train core teams, peer educators, and parents.
    • Develop and distribute resource materials.
    • Conduct community sessions, home visits, and establish linkages.
    • Develop district-level referral systems.
    • Raise awareness among civic and traditional leaders.

3. Purpose and Objectives of the ReCLAIM Project Evaluation

The evaluation will assess the extent to which the ReCLAIM Project’s objectives were met. Key questions to explore include:

  • To what extent were the project objectives achieved?
  • Were the project activities appropriate for the context and beneficiary needs?
  • Did the project effectively address referral pathway gaps?
  • How aligned were the project interventions with Ministry of Health policies?
  • Were there any unintended results arising from the project activities?
  • What lessons can guide future programming in mental health?

4. Methodology for Evaluation

This is a summative evaluation, and consultants may propose methods such as qualitative techniques (document review, interviews, field observations) and any other suitable data collection, analysis, and reporting methods. The evaluation methodology should be comprehensive, detailed, and context-specific. A proposed methodology will be reviewed by REPSSI’s Evaluation Review Team (ERT).

5. Duration of Consultancy – 4 Weeks

The consultancy is expected to be completed within 24 calendar days from the date of contract signing.

6. Deliverables

The consultant will be responsible for delivering the following reports:

  • Inception Report (5 days): Detailed evaluation design, methodology, and tools.
  • Draft Report (15 days): Comprehensive evaluation report for stakeholder review.
  • Final Report (30–50 pages): Analytical report with findings, lessons, recommendations, and an executive summary.

7. Site Coverage

Evaluation activities will cover the following locations:

  • Chipata Correctional Facility (1) and Schools (3)
  • Katete Correctional Facility (1) and Schools (3)
  • Kazungula Correctional Facility (1) and Schools (2)
  • Livingstone Correctional Facility (1) and Schools (3)

8. Payment Schedule

The payment will be based on the following schedule:

  • 30%: Upon adoption of the Inception Report.
  • 30%: Upon submission of the Draft Report.
  • 40%: Upon approval of the Final Report.

The payment is a lump sum, inclusive of all expenses.

9. Reporting

The consultant(s) will report directly to the Programs Manager for all aspects of the assignment.

10. Expertise and Qualifications

The consultant(s) should have:

  • Master’s degree in public health, psychology, social work, or a related field.
  • At least 8 years’ experience in evaluating international donor-funded projects, especially in health, capacity-building, and mental health programs.
  • Expertise in program formulation, monitoring, and evaluation.
  • Proven ability to conduct qualitative evaluations, particularly in health and psychosocial support programs.
  • Fluency in English, with excellent writing and reporting skills.

11. How to Apply

Consultants meeting the above qualifications and experience should submit the following to zambia@repssi.org (addressed to the Country Director):

  • A cover letter explaining their suitability for the assignment.
  • A Curriculum Vitae (CV), including detailed work experience. If more than one consultant will be involved, clearly identify the overall lead consultant and responsible persons, along with their CVs.
  • A brief proposal, including methodology, timeline, and budget.

12. Submission Deadline

All applications must be received by 7th January 2025, 17:00hrs.

13. Selection Criteria

Evaluation of candidates will be based on the following criteria:

Selection Criteria

CriteriaWeightMax. Points
Academic Qualifications 10% Master’s degree in relevant fields.
Expertise in Monitoring and Evaluation (M&E) 20% Experience in mental health and capacity building programs.
Evaluation Methodology 40% Comprehensive, context-specific approach.
M&E Experience 20% Proven monitoring and evaluation experience.
International Experience 5% At least 5 years evaluating donor/organization projects/programs.
Language Proficiency and Reporting 5% Fluency in English; excellent report writing skills.

TOTAL | 100% | 100 Points

Job Info
Job Category: Tenders in Zambia
Job Type: Full-time
Deadline of this Job: Tuesday, January 07 2025
Duty Station: Lusaka
Posted: 02-01-2025
No of Jobs: 1
Start Publishing: 02-01-2025
Stop Publishing (Put date of 2030): 02-01-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
59.797MBMemory Usage491msRequest 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
array:1 [ "1deb24708f7a51ca02b447b7f6862276" => "4cb7afec187b45a2346fd267440d27db" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 3 "timer" => array:3 [ "start" => 1743728407 "last" => 1743728411...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
jsjobcur_usr
0
jsjobconfig_dft
array:171 [ "actk" => "0" "applybuttonredirecturl" => "http://www.greatzambiajobs.com/how-to-app...
JSItemid
"190"
  • afterLoad (4.12MB) (28.63ms)
  • afterInitialise (11.13MB) (78.15ms)
  • afterRoute (5.04MB) (26.28ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (207μs)
  • afterRenderComponent com_jsjobs (3.12MB) (31.65ms)
  • Before Access::preloadComponents (all components) (239.64KB) (5.54ms)
  • After Access::preloadComponents (all components) (132.72KB) (932μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (18μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (295μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.53MB) (60.29ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (82.27ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (8μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (360μs)
  • afterDispatch (79.16KB) (127μs)
  • afterRender (13.77MB) (175ms)
  • 1 x afterRender (13.77MB) (35.66%)
    175.12ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (16.75%)
    82.27ms
    1 x afterInitialise (11.13MB) (15.91%)
    78.15ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.53MB) (12.28%)
    60.29ms
    1 x afterRenderComponent com_jsjobs (3.12MB) (6.45%)
    31.65ms
    1 x afterLoad (4.12MB) (5.83%)
    28.63ms
    1 x afterRoute (5.04MB) (5.35%)
    26.28ms
    1 x Before Access::preloadComponents (all components) (239.64KB) (1.13%)
    5.54ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.19%)
    932μs
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.07%)
    360μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.06%)
    295μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    207μs
    1 x afterDispatch (79.16KB) (0.03%)
    127μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    18μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    8μs
90 statements were executed, 23 of which were duplicates, 67 unique15.98ms264.23KB
  • SELECT @@SESSION.sql_mode;46μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?90μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 1105μ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_id77μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`68μ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` = :guest97μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'75μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`62μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'141μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config117μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'62μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'52μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'46μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'42μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-ToR-for-the-Restoring-Children%25e2%2580%2599s-and-Young-Peoples-Lost-Aspiration%2C-Integrity-and-Mental-well-being-ReCLAIM-Project-Evaluation-tender-at-Regional-Psychosocial-Support-Initiative-70551%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-ToR-for-the-Restoring-Children%25e2%2580%2599s-and-Young-Peoples-Lost-Aspiration%2C-Integrity-and-Mental-well-being-ReCLAIM-Project-Evaluation-tender-at-Regional-Psychosocial-Support-Initiative-70551%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-ToR-for-the-Restoring-Children%25e2%2580%2599s-and-Young-Peoples-Lost-Aspiration%2C-Integrity-and-Mental-well-being-ReCLAIM-Project-Evaluation-tender-at-Regional-Psychosocial-Support-Initiative-70551%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC181μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-ToR-for-the-Restoring-Children%25e2%2580%2599s-and-Young-Peoples-Lost-Aspiration%2C-Integrity-and-Mental-well-being-ReCLAIM-Project-Evaluation-tender-at-Regional-Psychosocial-Support-Initiative-70551%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-ToR-for-the-Restoring-Children%25e2%2580%2599s-and-Young-Peoples-Lost-Aspiration%2C-Integrity-and-Mental-well-being-ReCLAIM-Project-Evaluation-tender-at-Regional-Psychosocial-Support-Initiative-70551%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-ToR-for-the-Restoring-Children%25e2%2580%2599s-and-Young-Peoples-Lost-Aspiration%2C-Integrity-and-Mental-well-being-ReCLAIM-Project-Evaluation-tender-at-Regional-Psychosocial-Support-Initiative-70551%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC203μ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.id154μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'311μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • 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 = 'social'202μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'280μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'201μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'59μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'60μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'231μ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 = 70551550μs60.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'250μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 70551424μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'250μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering285μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'236μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'203μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering236μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'233μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'222μ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'56μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'257μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'168μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'63μ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 = 2141μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2155μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'541μ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'504μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2145μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2125μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2127μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'215μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'263μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'236μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering200μ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)524μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0104μs936B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22123μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2489μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2880μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 3889μs17.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 39110μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40104μ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.lft260μ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.lft184μ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.lft418μ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-Terms-of-Reference-ToR-for-the-Restoring-Children’s-and-Young-Peoples-Lost-Aspiration,-Integrity-and-Mental-well-being-ReCLAIM-Project-Evaluation-tender-at-Regional-Psychosocial-Support-Initiative-70551' AND `published` = 1121μs9.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Terms-of-Reference-ToR-for-the-Restoring-Children’s-and-Young-Peoples-Lost-Aspiration,-Integrity-and-Mental-well-being-ReCLAIM-Project-Evaluation-tender-at-Regional-Psychosocial-Support-Initiative-70551'72μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration243μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'111μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field99μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'93μ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` = 195μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'149μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`264μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'69μ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 desc155μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`346μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid147μ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` = :muserid126μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Terms-of-Reference-ToR-for-the-Restoring-Children’s-and-Young-Peoples-Lost-Aspiration,-Integrity-and-Mental-well-being-ReCLAIM-Project-Evaluation-tender-at-Regional-Psychosocial-Support-Initiative-70551'70μ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` = 154μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"286μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES995μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin92μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin74μ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`87μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'75μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'235μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 452374μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?76μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?177μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy