Zambia Inclusive Education ‘Tusambilile Chapamo’ (Let’s Learn Together) End-Term Evaluation Consultancy tender at Sightsavers
Website :
171 Days Ago
Linkedid Twitter Share on facebook

Job description

Anticipated timeframe: Circa 60 to 70 person days between August 2024 and March 2025

Location: Chinsali District and Lusaka, Zambia

The Government of Zambia is committed to ensuring that learners with special education needs and disabilities (LSEND) access inclusive education. The government has signed and ratified the 2006 Convention on the Rights of Persons with Disabilities and also outlined a plan for the implementation of the 2030 Agenda for Sustainable Development.

Post education, young people with disabilities, particularly young women, find it particularly difficult to access formal employment, demonstrating a disconnect between the legislative and policy framework and the systems for their implementation. Therefore, Sightsavers and the Zambian Federation of Disability Organisations (ZAFOD) developed the Tusambilile Chapamo project to empower children and youth with disabilities in Zambia by increasing access to quality, equitable and inclusive education/skills training. By raising the inclusiveness of education provision in the centres, the project aims to benefit all students, both those with disabilities and those without disabilities.

The overall objective of the project is to empower children and youth with disabilities in Zambia by increasing their access to quality, equitable and inclusive education in Chinsali zone, Muchinga Province, and ensuring LSEND have access to a continuum of education of improved quality.

A mid-term review (MTR) was completed in November 2023 for this inclusive education project in Zambia, conducted by the Sightsavers’ MEL Team with support from an independent Zambian consultant. The purpose of the MTR was to explore the challenges, successes and learning for the project so far, and to make recommendations for any necessary adjustments in the remaining duration.

Sightsavers is now commissioning a consultant/consultancy to conduct a final end of term evaluation that considers the whole intervention

Purpose of Analysis

This ETE will assess the performance of the project and garner specific learnings that can be taken forward in future programme design and implementation. It will assess the effectiveness and replicability of the model of low-cost inclusive education piloted in this project and make recommendations pertaining to scalability and sustainability.

The findings, learnings and recommendations from the evaluation will be used by Sightsavers programme staff to inform the design and delivery of similar projects and programmes. This will include continuity work in Zambia (whether or not this is directly supported by Sightsavers), as well as inclusive education work in similar contexts. It is also intended that the evaluation will contribute evidence and/or insight towards some of Sightsavers’ thematic learning questions, as well as provide evidence to government that Inclusive Education is doable in Zambia, at a low cost.

The main users of this evaluation will be EU delegation in Zambia, Sightsavers, ZAFOD and government partners.

The evaluation criteria will cover:

  • Relevance, is the intervention doing the right things
  • Effectiveness, is it achieving the objectives
  • Impact, what difference does the intervention bring
  • Sustainability, will the benefits be ongoing
  • Scalability, which aspects of the intervention are suitable to replicate or scale-up
  • Equity and inclusion, how inclusive has the intervention been

Deliverables

  1. A draft Inception Report in English
  2. A final Inception Report in English (after at least one round of review/editing)
  3. A draft Evaluation Report in English
  4. A final Evaluation Report in English (after at least two rounds of internal review/editing and an external review by the European Commission)
  5. Policy brief
  6. Infographic to showcase the results of the evaluation and the recommendations.
  7. Anonymised data sets (Excel or Word files) for all collected data (quantitative and qualitative)

Consultant’s expertise

  • Extensive experience in monitoring and evaluation for international development project/programmes, with strong skills in both qualitative and quantitative approaches.
  • Thematic expertise in inclusive education with comprehensive understanding of preferred practices/policy issues at national and global levels.
  • Prior experience of Most Significant Change or Outcome Harvesting for programme evaluation purposes.
  • Prior experience working in Sub-Saharan Africa is essential, including primary data collection, preferably in Zambia.
  • Prior inclusive education work/evaluation experience, as well as knowledge and expertise of disability inclusion and gender mainstreaming.
  • Experience of carrying out evaluation and learning exercises of an appropriate scale.
  • Ability to source and manage additional support with relevant services such as data collection, translation, sign language interpretation, and transcription, in Zambia when necessary.
  • Ability to produce clear, concise, and analytical reports in English, with excellent attention to detail, and to meet agreed deadlines.
  • Experience of producing learning and summary documents to share findings and recommendations with diverse audiences in clear and engaging ways. Familiarity with accessible design principles would be advantageous.
  • First class communication skills in written and spoken English. Fluency in local languages in Zambia (primarily Bemba) is highly desirable.
  • The evaluation team will adhere to the contractual terms and conditions with Sightsavers, including clauses in relation to confidentiality, data protection and intellectual property rights. It is expected that the evaluation will fully follow ethical principles for evaluation, and that the team will adhere to Sightsavers’ guidelines on ethical considerations for evaluation, Safeguarding Policy, and Code of Conduct. It is also a requirement that all members of the evaluation team have completed a short online UNICEF ethics training course, or equivalent, before embarking on the evaluation.

Sightsavers welcomes expressions of interest from qualified independent evaluators or consultancy companies. An individual or team with members located in Zambia would be preferred.

Consultants with a proven track record in the above will be procured to undertake the project through an expression of interest process.

Value for money will be one of the proposal assessment criteria.

Payment Terms

To be agreed between Sightsavers and the consultant/consultancy at interview.

Full details of the project, Scope of Work, Outputs/ Deliverables and budgets can be found within the ToR.

How to express your interest:

Please read the complete ToR and complete our Expression of Interest (EoI), Planning Schedule and Budget Template which can be found via the application link. Please apply in English.

The EoI response should include roles and responsibilities of the consultants and number of days input, as well as a proposed workplan and indicative budget, including team members’ daily rates for the assignment and any other anticipated expenses. Interested bidders are also requested to include an example of previous similar work.

The deadline to submit your EoI is 23:59 British Summer Time, 26 July 2024

Interviews are likely to be held late July 2024

Please note due to the high volume of applications anticipated it is possible that only successful applicants will be contacted.

Selection Criteria:

Sightsavers is committed to running a fair and transparent tender process and ensuring that all bidders are treated and assessed equally during this process.

We will select consultants that offer the best value for money using an 80/20 weighting between technical skill and price.

To apply for this job please visit careers.sightsavers.org.

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

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
66.412MBMemory Usage387msRequest Duration
Joomla! Version4.4.9
PHP Version8.1.31
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.27-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" => 1735833859 "last" => 1735833859...
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) (26.95ms)
  • afterInitialise (11.9MB) (70.63ms)
  • afterRoute (10.33MB) (53.36ms)
  • beforeRenderComponent com_jsjobs (10.08KB) (153μs)
  • afterRenderComponent com_jsjobs (2.85MB) (28.7ms)
  • Before Access::preloadComponents (all components) (243.6KB) (4.42ms)
  • After Access::preloadComponents (all components) (132.72KB) (677μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (11μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (222μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (3.66MB) (36.82ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (59.99ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (6μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (261μs)
  • afterDispatch (79.35KB) (94μs)
  • afterRender (11.01MB) (104ms)
  • 1 x afterRender (11.01MB) (26.88%)
    104.02ms
    1 x afterInitialise (11.9MB) (18.25%)
    70.63ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (15.5%)
    59.99ms
    1 x afterRoute (10.33MB) (13.79%)
    53.36ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (3.66MB) (9.51%)
    36.82ms
    1 x afterRenderComponent com_jsjobs (2.85MB) (7.42%)
    28.70ms
    1 x afterLoad (4.12MB) (6.96%)
    26.95ms
    1 x Before Access::preloadComponents (all components) (243.6KB) (1.14%)
    4.42ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.17%)
    677μs
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.07%)
    261μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.06%)
    222μs
    1 x beforeRenderComponent com_jsjobs (10.08KB) (0.04%)
    153μs
    1 x afterDispatch (79.35KB) (0.02%)
    94μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    11μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    6μs
125 statements were executed, 23 of which were duplicates, 102 unique21.12ms303.65KB
  • SELECT @@SESSION.sql_mode;83μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?94μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 163μ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)265μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`88μ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` = :guest112μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'96μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`65μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'115μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config94μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'65μs856B/plugins/system/acymtriggers/acymtriggers.php:516Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'111μs856B/plugins/system/acymtriggers/acymtriggers.php:516Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'44μs856B/plugins/system/acymtriggers/acymtriggers.php:516Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'41μs856B/plugins/system/acymtriggers/acymtriggers.php:516Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Zambia-Inclusive-Education-%25e2%2580%2598Tusambilile-Chapamo%25e2%2580%2599-Let%25e2%2580%2599s-Learn-Together-End-Term-Evaluation-Consultancy-tender-at-Sightsavers-62636%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Zambia-Inclusive-Education-%25e2%2580%2598Tusambilile-Chapamo%25e2%2580%2599-Let%25e2%2580%2599s-Learn-Together-End-Term-Evaluation-Consultancy-tender-at-Sightsavers-62636%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Zambia-Inclusive-Education-%25e2%2580%2598Tusambilile-Chapamo%25e2%2580%2599-Let%25e2%2580%2599s-Learn-Together-End-Term-Evaluation-Consultancy-tender-at-Sightsavers-62636%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC130μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SHOW TABLES768μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_configuration181μs7.38KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM icop0_acym_plugin66μs2.13KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'acychecker' LIMIT 1104μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'acymailer' LIMIT 169μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'amazon' LIMIT 161μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'article' LIMIT 158μs2.09KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'birthday' LIMIT 171μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'brevo' LIMIT 160μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'createuser' LIMIT 191μs2.09KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` FROM icop0_usergroups AS `groups`56μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'elasticemail' LIMIT 174μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'forward' LIMIT 196μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'mailgun' LIMIT 166μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'module' LIMIT 164μs2.09KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'online' LIMIT 155μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'override' LIMIT 161μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'phpmail' LIMIT 175μs13.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'postmark' LIMIT 161μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'qmail' LIMIT 168μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'segment' LIMIT 166μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'sendgrid' LIMIT 166μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'sendinblue' LIMIT 175μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luecredentials' LIMIT 1106μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'lueintegration' LIMIT 161μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luetransactional' LIMIT 162μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luelist' LIMIT 164μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'lueusers' LIMIT 163μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luesender' LIMIT 167μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luecampaign' LIMIT 154μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luewebhooks' LIMIT 153μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'sendmail' LIMIT 153μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'smtp' LIMIT 155μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'statistics' LIMIT 170μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'subscriber' LIMIT 160μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'subscription' LIMIT 161μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'time' LIMIT 186μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'user' LIMIT 192μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'managetext' LIMIT 185μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Zambia-Inclusive-Education-%25e2%2580%2598Tusambilile-Chapamo%25e2%2580%2599-Let%25e2%2580%2599s-Learn-Together-End-Term-Evaluation-Consultancy-tender-at-Sightsavers-62636%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Zambia-Inclusive-Education-%25e2%2580%2598Tusambilile-Chapamo%25e2%2580%2599-Let%25e2%2580%2599s-Learn-Together-End-Term-Evaluation-Consultancy-tender-at-Sightsavers-62636%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Zambia-Inclusive-Education-%25e2%2580%2598Tusambilile-Chapamo%25e2%2580%2599-Let%25e2%2580%2599s-Learn-Together-End-Term-Evaluation-Consultancy-tender-at-Sightsavers-62636%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC175μ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.id153μs1.2KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'252μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'174μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'144μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'172μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'192μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'64μ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'242μ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 = 62636384μs44.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'140μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 626363.86ms48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'246μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering221μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'229μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'179μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering236μs4.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'226μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'152μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'60μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'57μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'238μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'228μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'62μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'57μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2133μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2145μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'478μ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'520μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2166μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2124μ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'243μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'217μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'157μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering118μ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)417μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0120μs936B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2270μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24104μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2876μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38114μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 3990μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 4078μ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` = 0141μ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.lft257μ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.lft201μ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.lft276μ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-Zambia-Inclusive-Education-‘Tusambilile-Chapamo’-Let’s-Learn-Together-End-Term-Evaluation-Consultancy-tender-at-Sightsavers-62636' AND `published` = 1164μs1.2KB/plugins/system/jmap/jmap.php:762Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Zambia-Inclusive-Education-‘Tusambilile-Chapamo’-Let’s-Learn-Together-End-Term-Evaluation-Consultancy-tender-at-Sightsavers-62636'51μs960B/plugins/system/jmap/jmap.php:864Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'112μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM icop0_acym_field71μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'68μs1.2KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • 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` = 174μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'134μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`219μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'100μ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 desc177μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`241μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid143μ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` = :muserid110μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Zambia-Inclusive-Education-‘Tusambilile-Chapamo’-Let’s-Learn-Together-End-Term-Evaluation-Consultancy-tender-at-Sightsavers-62636'85μs1.05KB/plugins/system/jmap/jmap.php:1079Copy
  • SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `icop0_jmap_text_replacements` WHERE `published` = 150μs1008B/plugins/system/jmap/jmap.php:465Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"186μs856B/plugins/system/acymtriggers/acymtriggers.php:218Copy
  • SHOW TABLES662μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'132μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'162μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 324657μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?111μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?456μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy