Consultant to Undertake a Market Assessment of the Affordable Housing Gap for Health Workers in Zambia Job at SolidarMed Zambia - Career Opportunity in Zambia
Website :
1387 Days Ago
Linkedid Twitter Share on facebook

Vacancy title:
Consultant to Undertake a Market Assessment of the Affordable Housing Gap for Health Workers in Zambia

[ Type: FULL TIME , Industry: Nonprofit, and NGO , Category: Management ]

Jobs at:

SolidarMed Zambia

Deadline of this Job:
06 August 2021  

Duty Station:
Within Zambia , Lusaka , South - Central Africa

Summary
Date Posted: Monday, July 26, 2021 , Base Salary: Not Disclosed


JOB DETAILS:
Job title: Consultant to Undertake a Market Assessment of the Affordable Housing Gap for Health Workers in Zambia

Background
SolidarMed is a Swiss non-profit organisation dedicated to improving healthcare in Africa. It is currently active in seven countries in eastern and southern Africa and reaches over 2.5 million people in Kenya, Lesotho, Mozambique, South Africa, Tanzania, Zambia and Zimbabwe with various health programmes developed in close cooperation with local hospitals, health centres, partner organisations and health authorities. It was registered in Zambia in 2010 under the Registrar of Societies and later as a Non-Governmental Organization in 2013 with registration number RNGO 101/0075/2013. SolidarMed shares the vision of the Ministry of Health of equitable access to cost-effective, quality health care for all Zambians and has a particular focus on the rural areas.
The goal of our country programme in Zambia is to improve the provision of human resources for health in rural areas. Health facilities in rural Zambia suffer from an acute shortage of health workers which is a major contributing factor towards weaker health outcomes in rural areas. To address this challenge, SolidarMed uses innovative ways to improve the quality and number of human resources for health in rural areas through training Medical Licentiates (non-physician clinicians), nurses and midwives, specifically for the rural areas, as well as improving working conditions for rural health staff through the key intervention of improved staff housing.
Sustainable Housing for Health project
A study by the Clinton Foundation revealed that 78.4% of health workers would take a rural job over an urban job if good quality housing were available. With this evidence in mind, SolidarMed took up the challenge of addressing poor retention of health workers in rural areas by providing superior housing for health workers at an affordable cost through an innovative housing project. It has developed a housing product that is not only cost effective but has improved environmental sustainability in both new build homes and the rehabilitation of existing housing units. These housing units are comprised of 2 to 4 bedroomed houses concentrated in 3 rural districts of Lusaka Province (Luangwa, Rufunsa and Chongwe) and a few in outlying areas which include the Muchinga and Eastern Provinces of Zambia. The houses are rented out at an affordable rent ranging from K600 to K1300, depending on the house size and the amenities and fixtures installed. Additionally, SolidarMed has developed a social enterprise called SolidarInvest to maintain these housing properties in good condition. With a working model, our goal is now to scale up.
Objective / Scope of Work
The housing need, particularly for affordable [1]housing solutions in the rural parts of Zambia is very high. However, few studies, if any, have quantified housing need/demand and how that demand may change considering increases in population and therefore the need for services, which will bring in its wake an increase in the number of healthcare workers. As the current phase of funding this programme draws to a close, an independent evaluation is required with an overall goal of contributing towards the knowledge on this subject as well as to provide valuable data for future funding applications where arguments about the housing gap may influence resource allocation.

Objectives:
This independent consultancy will have as its goal an assessment of the current and future size of rural housing for healthcare workers.
1. The specific objectives are:
1. To map the current housing infrastructure for health workers across all Districts and Provinces of Zambia. (disaggregated by the nature of the facility)[2],
2. To estimate the maintenance condition of the housing stock for health workers across all Districts and Provinces of Zambia.
3. To determine what the housing gap (demand/need) for affordable housing in health in rural Zambia is currently.
4. To explore where the housing gaps (demand/need) for affordable housing in health in rural Zambia are currently.
5. To investigate and document what the estimated projected housing gap will be over the next ten years in each location[3].
Duration
Up to 90 days are available to complete the consultancy and the final report is expected by the end of October 2021.

Deliverables
• Obtain ethical approval from National Health Research Authority before commencement of research.
• Stakeholder presentations (1 at start (introduction of approach and goals, with sign off of the detailed methodology; 1 just before report writing to outline key results and the structure of the report
• Final report following a pre-approved outline and including all raw and summarised data (quantitative and qualitative, in annex)
Technical and Financial Proposals

The technical proposal should outline:
• Relevant experience of the consultant(s) (Letter and CV must be attached with references)
• The proposed methodology including sources and a stakeholder list to be consulted.
• Processes and approaches to be used.
• A timeline for the work including key meetings to be held.
• Logistical and other support required.
• References for similar work.
• Examples of previously published work
The financial proposal should include:
• All administration costs including overheads, printing, copying, presentation and transport.
• Daily rate should take into account the deduction of Withholding Tax in Zambia (15% for resident and 20% for non-resident consultants).

Qualifications and Experience
Eligible Consultants should have the following qualifications and experience:
1. Strong Research background and familiarity and knowledge of the health institutions in Zambia.
2. Excellent communication and presentation skills with experience working with diverse stakeholders.
3. Strong track record of having led, carried out and participated in research and publications of this type.
4. Familiarity with conducting basic assessments of existing structures (household structures and living conditions).
5. Demonstrate exposure and experience in utilizing all research methods (qualitative, Observational, and quantitative) including transcribing.
6. A Degree and postgraduate qualification in Demography, Built Environment and Geography or relevant social sciences (research institutions including universities are welcome)

Work Hours: 8


Experience in Months: 24

Level of Education:
Bachelor Degree

 

{module 312}

Job application procedure
Eligible Consultant(s) should submit technical and financial proposals electronically to n.lubinda@solidarmed.ch. Proposals should be delivered not later than 17:00hrs on Friday 6th August, 2021.
• The principal focus here is patient facting healthcare providers, especially but not only medical officers, nurses, midwives, clinical officer and medical licentiates.
• All information under objective 1,2 and 3 should be tabulated as follows:
• First Level healthcare facilities disaggregated by Health Posts, Rural Health Centre and District Hospitals, including the new Mini-hospitals.
• Second Level healthcare facilities disaggregated by Provincial and General hospitals.
• No tertiary level health facilities will be considered since these are located in urban areas.
• Reflect on filled posts, funded but not filled posts, established but not yet funded or filled posts, as well as an estimate of future healthcare worker numbers to achieve government plans and/or WHO ratios

Foot Notes
• The principal focus here is patient facting healthcare providers, especially but not only medical officers, nurses, midwives, clinical officer and medical licentiates.
• All information under objective 1,2 and 3 should be tabulated as follows:
• First Level healthcare facilities disaggregated by Health Posts, Rural Health Centre and District Hospitals, including the new Mini-hospitals.
• Second Level healthcare facilities disaggregated by Provincial and General hospitals.
• No tertiary level health facilities will be considered since these are located in urban areas.
• Reflect on filled posts, funded but not filled posts, established but not yet funded or filled posts, as well as an estimate of future healthcare worker numbers to achieve government plans and/or WHO ratios


All Jobs

QUICK ALERT SUBSCRIPTION

{module 316}

Job Info
Job Category: Administrative jobs in Zambia
Job Type: Full-time
Deadline of this Job: 06 August 2021
Duty Station: Lusaka
Posted: 26-07-2021
No of Jobs: 1
Start Publishing: 26-07-2021
Stop Publishing (Put date of 2030): 26-07-2065
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
60.296MBMemory Usage574msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.29-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "1deb24708f7a51ca02b447b7f6862276" => "376f3d2dbf7b11225b07354adb80dcb6" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 4 "timer" => array:3 [ "start" => 1747170453 "last" => 1747170458...
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) (23.95ms)
  • afterInitialise (11.13MB) (70.62ms)
  • afterRoute (5.06MB) (47.46ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (289μs)
  • afterRenderComponent com_jsjobs (3.12MB) (42.95ms)
  • Before Access::preloadComponents (all components) (239.64KB) (8.36ms)
  • After Access::preloadComponents (all components) (132.72KB) (1.35ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (20μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (348μs)
  • afterDispatch (2.37MB) (106ms)
  • afterRender (31.49MB) (272ms)
  • 1 x afterRender (31.49MB) (47.35%)
    271.73ms
    1 x afterDispatch (2.37MB) (18.45%)
    105.89ms
    1 x afterInitialise (11.13MB) (12.31%)
    70.62ms
    1 x afterRoute (5.06MB) (8.27%)
    47.46ms
    1 x afterRenderComponent com_jsjobs (3.12MB) (7.48%)
    42.95ms
    1 x afterLoad (4.12MB) (4.17%)
    23.95ms
    1 x Before Access::preloadComponents (all components) (239.64KB) (1.46%)
    8.36ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.23%)
    1.35ms
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.06%)
    348μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.05%)
    289μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    20μs
89 statements were executed, 23 of which were duplicates, 66 unique22.46ms310.25KB
  • SELECT @@SESSION.sql_mode;103μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?152μ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`160μ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` = :guest135μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'84μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`86μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'129μ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'66μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'64μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'59μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'58μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Consultant-to-Undertake-a-Market-Assessment-of-the-Affordable-Housing-Gap-for-Health-Workers-in-Zambia-Job-at-SolidarMed-Zambia-Career-Opportunity-in-Zambia-25731%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Consultant-to-Undertake-a-Market-Assessment-of-the-Affordable-Housing-Gap-for-Health-Workers-in-Zambia-Job-at-SolidarMed-Zambia-Career-Opportunity-in-Zambia-25731%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Consultant-to-Undertake-a-Market-Assessment-of-the-Affordable-Housing-Gap-for-Health-Workers-in-Zambia-Job-at-SolidarMed-Zambia-Career-Opportunity-in-Zambia-25731%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC252μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Consultant-to-Undertake-a-Market-Assessment-of-the-Affordable-Housing-Gap-for-Health-Workers-in-Zambia-Job-at-SolidarMed-Zambia-Career-Opportunity-in-Zambia-25731%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Consultant-to-Undertake-a-Market-Assessment-of-the-Affordable-Housing-Gap-for-Health-Workers-in-Zambia-Job-at-SolidarMed-Zambia-Career-Opportunity-in-Zambia-25731%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Consultant-to-Undertake-a-Market-Assessment-of-the-Affordable-Housing-Gap-for-Health-Workers-in-Zambia-Job-at-SolidarMed-Zambia-Career-Opportunity-in-Zambia-25731%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC455μ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.id179μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'334μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'375μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'259μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'275μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'320μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'85μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'111μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'275μ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 = 25731629μs52.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'323μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 25731409μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'353μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering419μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'320μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'300μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering358μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'383μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'372μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'87μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'100μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'394μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'321μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'84μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'80μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2195μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2212μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'720μ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'1.81ms4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2241μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2288μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2181μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'408μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'395μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'217μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering235μ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)765μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0131μs920B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22109μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24300μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 28124μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38186μs73.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40119μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT `a`.`menutype`,`a`.`title` FROM `icop0_menu_types` AS `a` WHERE `a`.`client_id` = 0186μ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.lft406μ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.lft280μ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.lft512μ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-Consultant-to-Undertake-a-Market-Assessment-of-the-Affordable-Housing-Gap-for-Health-Workers-in-Zambia-Job-at-SolidarMed-Zambia-Career-Opportunity-in-Zambia-25731' AND `published` = 1163μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Consultant-to-Undertake-a-Market-Assessment-of-the-Affordable-Housing-Gap-for-Health-Workers-in-Zambia-Job-at-SolidarMed-Zambia-Career-Opportunity-in-Zambia-25731'102μs8.94KB/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration315μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'199μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field120μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'108μs1.2KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `icop0_scheduler_tasks` AS `a` WHERE `a`.`state` = 1146μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'198μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`320μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'98μ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 desc171μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`376μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid135μ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` = :muserid150μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Consultant-to-Undertake-a-Market-Assessment-of-the-Affordable-Housing-Gap-for-Health-Workers-in-Zambia-Job-at-SolidarMed-Zambia-Career-Opportunity-in-Zambia-25731'112μs1.05KB/plugins/system/jmap/jmap.php:1135Copy
  • SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `icop0_jmap_text_replacements` WHERE `published` = 178μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"340μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.07ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin120μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin103μ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`100μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'76μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'255μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 233371μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?93μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?204μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy