Consultant – to Conduct a Mid-term Outcome Evaluation of the HIV/TB Technical Assistance (Ta) Award Program in Zambia’s Western Province Project job at ICAP registered as Centers for International Programs
Website :
614 Days Ago
Linkedid Twitter Share on facebook

Vacancy title:
Consultant – to Conduct a Mid-term Outcome Evaluation of the HIV/TB Technical Assistance (Ta) Award Program in Zambia’s Western Province Project

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

Jobs at:

ICAP registered as Centers for International Programs

Deadline of this Job:
Wednesday, May 24 2023 

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

Summary
Date Posted: Wednesday, May 17 2023, Base Salary: Not Disclosed

Similar Jobs in Zambia
Learn more about ICAP registered as Centers for International Programs
ICAP registered as Centers for International Programs jobs in Zambia

JOB DETAILS:
The mid-term evaluation will seek to provide documented evidence of changes brought about by the project and promising practices which can be adopted for future programming. It will serve as an important accountability for ICAP and its partners for the purpose of identifying the extent to which the project objectives were achieved. The mid-term evaluation will be based on the following evaluation criteria (Relevance, Effectiveness, Efficiency, Sustainability, Replicability, Quality, and Coherence).

3.0: OVERALL OBJECTIVE OF THE MID-TERM EVALUATION.
ICAP, in collaboration with CDC, shall conduct a mixed methods mid-term evaluation in FY2023 to assess its TA contributions to HIV/TB program achievements in Western province. The overall objective of the mid-term evaluation is to assess ICAP’s TA to Western province during FY21 and FY22.

Specific objectives include:
1) To assess the extent to which ICAP’s TA improved HIV Case identification.
2) To assess the extent to which ICAP’s TA improved VL coverage and VL suppression
3) To assess the extent to which ICAP’s TA improved retention in care.
4) To assess the extent to which ICAP’s TA improved HIV prevention services.
5) To assess the extent to which ICAP’s TA improved data quality, management, reporting, and utilization including EHR – SmartCare.
4.0: SCOPE OF WORK
1. Follow the documented design of the project including the prescribed methodology and approach. This will include the design or adoption of analytical approaches, survey locations, sample size, target groups, key informant groups, focus groups and relevant questionnaires to address the questions in project workplan.
2. Prepare and present the inception report with a timeline for the assignment detailing how the consultant will go about to execute the work.
3. Design enumerators’ terms of reference (ToR), identify and recruit enumerators with adequate research competencies to fulfill the respective ToR.
4. Finalize all outcome study enumerator training agendas and modules to be approved by ICAP. The research team will share the draft guidance for any contextualization needed and will complete the final technical review and approve for use.
5. Prepare all outcome study training and field data collection logistics in coordination with ICAP and WHO.
6. Train enumerators on how to utilize the outcome study tools based on the training agenda and the modules agreed upon with ICAP and WPHO. Training will also include piloting the data collection tools.
7. Identify and facilitate the enumerators’ quantitative data entry that is collected for the project using agreed-upon data entry forms determined in consultation with ICAP.
8. Identify and facilitate the enumerators’ entering and translating the qualitative data for the outcome study collected using interview and focus group guides approved by the IRB.
9. Maintain good data quality during the survey. ICAP and WPHO will work with the consultant to ensure that the consultant meets their deliverables.
10. 10 Clean qualitative and quantitative datasets entered for the evaluation.
11. Conduct preliminary analyses of qualitative and quantitative data for the outcome study as per agreement with ICAP and WPHO using the data analysis plan.
12. The consultant will draft the final report, including an executive summary, incorporating comments from ICAP and WPHO; and include a final PowerPoint presentation of 20-25 slides to summarize the report. The consultant will also prepare and present the report in a dissemination seminar.

5.0: PROPOSED PAYMENT PLAN
Deliverable /Percent
1. Inception Report 20%
2. Data Collection 20%
3. Preliminary data analysis and summary 10%
4. Draft Report 20%
5. Final Report 30%
6. Total 100%

6.0: QUALIFICATIONS REQUIREMENTS
The prospective consultant can be an organization, or a consortium of consultants organized in one legal entity. In any of the cases, the consultant must meet the following minimum qualifications and experience:
1. Master’s degree in Public Health, Demography, Statistics, or social sciences with five (5) years’ experience in similar undertakings or bachelor’s degree with accompanying ten (10) years’ experience.
2. At least 10 years’ experience working in the health sector in Zambia and HIV/AIDS programs.
3. Must demonstrate national expertise and leadership.
4. Excellent communication in English and a local vernacular language.
5. Superb collaboration skills to work with a diverse set of partners, especially with Zambian stakeholders
6. Demonstrated qualitative and quantitative data collection work
7. Must be a national or resident of Zambia

Applicants must attach the following documents:

1. Company Profile
2. Company Registration Certificate
3. Valid 2023 General Tax Clearance Certificate
4. At least three (3) samples of reports for similar works conducted in the last five years.
5. Traceable referees.

7.0: TIMELINES
1. Submission of proposals – 15th – 19th May, 2023
2. Approximate Commencement Date – 12th June 2023
3. Assignment days – 40 working days.
4. Applicants must submit both technical and financial proposals.

8.0 DATA CONFIDENTIALITY
The consultant is expected to maintain the highest levels of confidentiality throughout the process and treat with utmost confidentiality all sources of information. The consultant will be expected to undergo human subject training provided by ICAP.
Accordingly, the consultant and/or employees are prohibited from sharing any project information intentionally or otherwise with any external party without the express authority from the client.


Work Hours: 8


Experience in Months: 120

Level of Education:
Postgraduate Degree

Job application procedure
To apply for this job email your details to az2771@cumc.columbia.edu 

All Jobs

QUICK ALERT SUBSCRIPTION

"
Job Info
Job Category: Consultant/ Contractual jobs in Zambia
Job Type: Full-time
Deadline of this Job: May 24, 2023
Duty Station: Zambia
Posted: 17-05-2023
No of Jobs: 1
Start Publishing: 17-05-2023
Stop Publishing (Put date of 2030): 30-05-2055
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
63.972MBMemory Usage379msRequest Duration
Joomla! Version4.4.10
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
array:3 [ "1deb24708f7a51ca02b447b7f6862276" => "4e747c7ef64f6cc358382ba695b6aa0f" "_ga" => "GA1...
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 5 "timer" => array:3 [ "start" => 1737466848 "last" => 1737466866...
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) (22.34ms)
  • afterInitialise (11.98MB) (79.12ms)
  • afterRoute (5.26MB) (25.51ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (155μs)
  • afterRenderComponent com_jsjobs (3.12MB) (24.52ms)
  • Before Access::preloadComponents (all components) (243.64KB) (4.2ms)
  • After Access::preloadComponents (all components) (132.72KB) (800μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (13μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (226μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.5MB) (38.26ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.18MB) (51.65ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (5μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (261μs)
  • afterDispatch (79.16KB) (89μs)
  • afterRender (17MB) (131ms)
  • 1 x afterRender (17MB) (34.54%)
    130.75ms
    1 x afterInitialise (11.98MB) (20.9%)
    79.12ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.18MB) (13.64%)
    51.65ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.5MB) (10.11%)
    38.26ms
    1 x afterRoute (5.26MB) (6.74%)
    25.51ms
    1 x afterRenderComponent com_jsjobs (3.12MB) (6.48%)
    24.52ms
    1 x afterLoad (4.12MB) (5.9%)
    22.34ms
    1 x Before Access::preloadComponents (all components) (243.64KB) (1.11%)
    4.20ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.21%)
    800μ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%)
    226μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    155μs
    1 x afterDispatch (79.16KB) (0.02%)
    89μ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 unique15.11ms240.23KB
  • SELECT @@SESSION.sql_mode;87μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?154μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 163μ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_id302μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`94μ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` = :guest136μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'76μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`58μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'199μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config86μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'127μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'66μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'48μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'42μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Consultant-%25e2%2580%2593-to-Conduct-a-Mid-term-Outcome-Evaluation-of-the-HIVTB-Technical-Assistance-Ta-Award-Program-in-Zambia%25e2%2580%2599s-Western-Province-Project-job-at-ICAP-registered-as-Centers-for-International-Programs-45797%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Consultant-%25e2%2580%2593-to-Conduct-a-Mid-term-Outcome-Evaluation-of-the-HIVTB-Technical-Assistance-Ta-Award-Program-in-Zambia%25e2%2580%2599s-Western-Province-Project-job-at-ICAP-registered-as-Centers-for-International-Programs-45797%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Consultant-%25e2%2580%2593-to-Conduct-a-Mid-term-Outcome-Evaluation-of-the-HIVTB-Technical-Assistance-Ta-Award-Program-in-Zambia%25e2%2580%2599s-Western-Province-Project-job-at-ICAP-registered-as-Centers-for-International-Programs-45797%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC199μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Consultant-%25e2%2580%2593-to-Conduct-a-Mid-term-Outcome-Evaluation-of-the-HIVTB-Technical-Assistance-Ta-Award-Program-in-Zambia%25e2%2580%2599s-Western-Province-Project-job-at-ICAP-registered-as-Centers-for-International-Programs-45797%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Consultant-%25e2%2580%2593-to-Conduct-a-Mid-term-Outcome-Evaluation-of-the-HIVTB-Technical-Assistance-Ta-Award-Program-in-Zambia%25e2%2580%2599s-Western-Province-Project-job-at-ICAP-registered-as-Centers-for-International-Programs-45797%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Consultant-%25e2%2580%2593-to-Conduct-a-Mid-term-Outcome-Evaluation-of-the-HIVTB-Technical-Assistance-Ta-Award-Program-in-Zambia%25e2%2580%2599s-Western-Province-Project-job-at-ICAP-registered-as-Centers-for-International-Programs-45797%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC229μ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.id181μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'224μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'135μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'150μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'149μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'148μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'89μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'108μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'224μ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 = 45797473μs36.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'142μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 45797268μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'215μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering294μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'225μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'199μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering257μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'231μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'197μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'95μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'67μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'228μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'195μ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'44μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2131μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2111μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'535μ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'346μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 298μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 292μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 282μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'143μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'167μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'159μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering159μ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)553μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 099μs936B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22133μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2488μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2870μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38122μs17.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 39131μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40121μ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` = 0104μ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.lft304μ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.lft177μ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.lft295μ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-Conduct-a-Mid-term-Outcome-Evaluation-of-the-HIVTB-Technical-Assistance-Ta-Award-Program-in-Zambia’s-Western-Province-Project-job-at-ICAP-registered-as-Centers-for-International-Programs-45797' AND `published` = 1115μs9.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Consultant-–-to-Conduct-a-Mid-term-Outcome-Evaluation-of-the-HIVTB-Technical-Assistance-Ta-Award-Program-in-Zambia’s-Western-Province-Project-job-at-ICAP-registered-as-Centers-for-International-Programs-45797'97μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration288μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'126μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field70μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'71μ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` = 1112μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'150μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`232μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'52μ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 desc143μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`320μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid152μs4.41KBParams/libraries/src/Table/User.php:104Copy
  • SELECT `g`.`id`,`g`.`title` FROM `icop0_usergroups` AS `g` INNER JOIN `icop0_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid155μ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-Conduct-a-Mid-term-Outcome-Evaluation-of-the-HIVTB-Technical-Assistance-Ta-Award-Program-in-Zambia’s-Western-Province-Project-job-at-ICAP-registered-as-Centers-for-International-Programs-45797'82μ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` = 153μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"208μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES767μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin65μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin50μ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`66μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'90μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'182μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 160158μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?137μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?485μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy