Terms of Reference for The Development of An Online tender at Oxfam
Website :
529 Days Ago
Linkedid Twitter Share on facebook

TERMS OF REFERENCE FOR THE DEVELOPMENT OF AN ONLINE OR MOBILE BASED CITIZENS’ FEEDBACK PLATFORM ON THE QUALITY OF PUBLIC SERVICE PROVISION AT DISTRICT LEVEL

1. INTRODUCTION

Oxfam is a global movement of people who are fighting inequality to end poverty and injustice. Across regions, from the local to the global, we work with people to bring change that lasts. Our work is grounded in the commitment to the universality of human rights. Driven by diversity and founding our asks in evidence and experience, we take sides against poverty and injustice everywhere. Feminist approaches guide all.

OXFAM is currently implementing a European Union funded project dubbed “Beyond the numbers: Making the national budget work for the people”. Collaborating with Zambia Council for Social Development (ZCSD) and the Non-Governmental Gender Organization Coordinating Council (NGOCC), this project aims to promote active citizen engagement and the involvement of non-state actors in the national planning and budgeting processes as well as promotion of accountability in the implementation of the national budget by building their capacity and facilitating opportunities for them.

2. BACKGROUND

Citizen feedback plays a pivotal role in the relationship between government, transparency, accountability, and the quality of public service delivery. It is a mechanism that empowers citizens to actively participate in the evaluation and improvement of government services. Citizen feedback enhances transparency by shedding light on inefficiencies or areas needing improvement within government agencies. When citizens express their opinions, concerns, or suggestions about public services, it prompts government institutions to provide greater transparency. Citizen feedback is one of the accountability measures and serves as a catalyst for increased openness and disclosure, which, in turn, empowers citizens to engage with a better-informed perspective. This transparency-driven feedback loop encourages accountability as citizens hold public servants and agencies accountable for their actions. Ultimately, this accountability promotes service quality, as public service providers are incentivized to take corrective actions and make improvements in response to the feedback. The result is a continuous cycle of service enhancement, better public service delivery, and increased citizen satisfaction, reinforcing the trust between citizens and their government.

The [Your Organization Name] is seeking proposals from qualified consultants or firms to design and develop an interactive mobile application or online platform that will enable citizens to provide feedback on the quality of  public service provision and the performance of the national budget at the district level. The platform will serve as a means for citizens to engage with government agencies and provide valuable input to enhance public service delivery and transparency.

OXFAM, therefore, wishes to engage a consultant to  Develop Of Citizens’ Feedback Platform On The Quality Of  Public Service Provision And National Budget Performance At District Level to support the work  of Oxfam and its partners on the beyond the numbers project.

3. OBJECTIVE OF THE CONSULTANCY

a. Overall Objective

The main objective of this consultancy is to develop an online or mobile based Citizens’ Feedback Platform that empowers citizens to provide feedback on the quality of public services like healthcareeducationagriculture and infrastructure  in their respective districts. The districts include Mpika, Monze, Rufunsa, Lusaka and Mufulira districts.

b. Specific Objectives

The specific objectives of the consultancy are as follows:

  • To design and develop an online and/or mobile based platform for citizens to provide feedback.
  • To create a user-friendly interface for citizens to easily submit feedback structured and/or unstructured feedback.
  • To establish a secure and confidential mechanism for citizens to share their feedback.
  • To periodically collect and analyze feedback data to assess the quality of public service provision.
  • To provide periodic reports to Oxfam and its partners based on feedback data to assess

4. SCOPE OF WORK

The consultancy will include, but not be limited to, the following tasks:

  1. Design and develop a user-friendly mobile application or online platform that allows citizens to submit feedback
  2. Conduct testing and Quality Assurance of the platform
  3. Provide training to community budget groups, interest groups, CSOs/CBOs/FBOs and other relevant citizens on how to use the platform.
  4. Assist in the launch and promotion of the platform
  5. Generate regular reports on citizen feedback and trends

5. DELIVERABLES

The consultant(s) will be responsible for delivering the following outputs:

  1. Detailed Platform concept Plan
  2. User-friendly app or web or mobile platform for citizen engagement
  3. User training materials or guide
  4. Launch and rollout plan.
  5. Regular reports on citizen feedback and platform usage.

6. DURATION AND TIMELINE

The consultancy is expected to be conducted over a period of 18 months. The detailed timeline for each task will be agreed upon during the inception phase.

7. ELIGIBILITY CRITERIA

The consultant or consultancy firm should possess the following:

  1. Proven experience in developing similar citizen engagement platforms.
  2. Expertise in app or web or mobile based platform development.
  3. Strong project management skills.
  4. Understanding of data security and privacy.
  5. Knowledge of public service delivery and government budget processes is an advantage.

8. Budget:

The total budget allocated for this consultancy is Euros 16,920.00. The consultant or consultancy firm should provide a detailed budget proposal which should be inclusive of all costs related to the development of the platformlaunch and promotion of the platform;  training to community budget groups interest groups, CSOs/CBOs/FBOs and other relevant citizensdata collection and generation of regular reports on citizen feedback and trends, analysis, and reporting. The budget should also consider any necessary travel expenses for field visits.

9. REPORTING AND COORDINATION

The consultant(s) will report directly to the Governance Programs Coordinator and Beyond the numbers Project Manager who will serve as the primary point of contact throughout the consultancy period.

10. INTELLECTUAL PROPERTY

  • All intellectual property rights, including the final report and any related materials, will be transferred to Oxfam in Southern Africa upon completion of the consultancy.

11. CONFIDENTIALITY

The consultant(s) shall maintain the confidentiality of all data, information, and discussions related to the consultancy and ensure the security of any data collected during the review.

12. ETHICS AND SAFEGUARDING

Oxfam has a zero-tolerance policy towards inaction against sexual harassment, exploitation, and abuse.  Oxfam’s ethics for safeguarding will be emphasized and remain mandatory throughout the process of the undertaking of the study. Engagements and support will aim to create and maintain safe, equitable, and inclusive culture where all those who work for and with Oxfam as well as those in the communities where Oxfam operates are treated with dignity and their rights and voices are heard and respected.

Selected consultants will be expected to read, sign, and adhere to the Oxfam Code of Conduct for no Oxfam staff and follow Oxfam’s Ethical Content Guidelines.

13. EVALUATION AND SELECTION

The selection of the consultant(s) will be based on their qualifications, relevant experience, proposed methodology, and budget.

14. SUBMISSION OF PROPOSALS

Interested academic consultant (s) should submit technical and financial proposal (not more than 20 pages excluding annexes-failure to adhere to this may lead to disqualification), detailing how they will undertake the assignment. Attach up-to-date CVs of the core team as annexes. Proposals should be submitted to the address below in electronic form ONLY and must be clearly indicated “ DEVELOPMENT OF AN ONLINE OR MOBILE BASED CITIZENS’ FEEDBACK PLATFORM ON THE QUALITY OF PUBLIC SERVICE PROVISION AT DISTRICT LEVEL” by 17:00 hours CAT time on 24th  November, 2023.

All correspondence for the consultancy should be addressed to the Logistics Unit through the email: ZambiaLogistics@oxfam.org.uk

Job Info
Job Category: Tenders in Zambia
Job Type: Full-time
Deadline of this Job: Monday, November 27 2023
Duty Station: Lusaka
Posted: 13-11-2023
No of Jobs: 1
Start Publishing: 13-11-2023
Stop Publishing (Put date of 2030): 13-11-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
59.962MBMemory Usage404msRequest 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" => "54dc2cf5723cebdcb61c3899573ed954" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1745597976 "last" => 1745597976...
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) (20.1ms)
  • afterInitialise (11.13MB) (73.12ms)
  • afterRoute (5.06MB) (22.95ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (152μs)
  • afterRenderComponent com_jsjobs (3.12MB) (31.07ms)
  • Before Access::preloadComponents (all components) (239.64KB) (4.38ms)
  • After Access::preloadComponents (all components) (132.72KB) (877μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (13μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (229μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.59MB) (60.75ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (52ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (5μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (273μs)
  • afterDispatch (79.48KB) (104μs)
  • afterRender (13.78MB) (138ms)
  • 1 x afterRender (13.78MB) (34.03%)
    137.61ms
    1 x afterInitialise (11.13MB) (18.08%)
    73.12ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.59MB) (15.02%)
    60.75ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (12.86%)
    52.00ms
    1 x afterRenderComponent com_jsjobs (3.12MB) (7.68%)
    31.07ms
    1 x afterRoute (5.06MB) (5.68%)
    22.95ms
    1 x afterLoad (4.12MB) (4.97%)
    20.10ms
    1 x Before Access::preloadComponents (all components) (239.64KB) (1.08%)
    4.38ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.22%)
    877μs
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.07%)
    273μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.06%)
    229μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    152μs
    1 x afterDispatch (79.48KB) (0.03%)
    104μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    13μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    5μs
90 statements were executed, 23 of which were duplicates, 67 unique21.99ms304.23KB
  • SELECT @@SESSION.sql_mode;40μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?81μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 193μ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_id81μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`107μ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` = :guest126μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'88μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`102μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'157μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config93μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'83μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'49μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'47μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'49μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-for-The-Development-of-An-Online-tender-at-Oxfam-52732%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-for-The-Development-of-An-Online-tender-at-Oxfam-52732%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-for-The-Development-of-An-Online-tender-at-Oxfam-52732%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC141μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-for-The-Development-of-An-Online-tender-at-Oxfam-52732%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-for-The-Development-of-An-Online-tender-at-Oxfam-52732%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-for-The-Development-of-An-Online-tender-at-Oxfam-52732%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC220μs4.25KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM icop0_template_styles AS s WHERE s.client_id = 0 AND s.template = 'jl_education_pro' ORDER BY s.id157μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'312μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'206μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'266μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'291μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'250μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'60μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'56μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'178μ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 = 52732575μs36.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'234μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 527326.03ms48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'290μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering323μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'209μ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 ordering196μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'230μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'273μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'96μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'53μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'304μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'233μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'56μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'47μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2138μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2120μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'463μ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'455μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2163μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2134μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2117μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • 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 = 'default'243μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'227μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering127μ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)622μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 084μs936B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2289μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2484μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2872μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38123μs81.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 39188μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40108μ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` = 0131μ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.lft393μ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.lft227μ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.lft478μ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-for-The-Development-of-An-Online-tender-at-Oxfam-52732' AND `published` = 1190μ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-for-The-Development-of-An-Online-tender-at-Oxfam-52732'59μ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'152μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field155μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'135μ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` = 1104μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'170μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`226μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'88μ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 desc179μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`261μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid132μ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` = :muserid165μ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-for-The-Development-of-An-Online-tender-at-Oxfam-52732'67μ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"210μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES713μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin72μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin73μ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`102μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'101μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'246μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 159570μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?105μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?157μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy