Call for Lead Consultants and Risk Assessors for USAID LOCAL tender at IntraHealth International
Website :
357 Days Ago
Linkedid Twitter Share on facebook

Job Details

Description

Background

The USAID Leading Organizational Capacity and Localization Development (USAID LOCAL) Activity, managed by IntraHealth International, is a five-year United States Agency for International Development (USAID) funded project. The goal of USAID LOCAL is to strengthen organizational capacity of USAID/Zambia local implementing partners (LIPs) to manage, implement and monitor programs that effectively and efficiently deliver sustainable quality development outcomes and impact, and fully influence local development agendas.  Under Component 1, USAID/IntraHealth collaborates with local partners, including the government of Zambia, on risk identification and mitigation and supporting best practices in organizational management.

USAID LOCAL will be conducting a set of risk assessments for seven Local Authorities (LA) in Chililabobwe, Chisamba, Kawambwa, Mbala, Mpika, Mpongwe and Serenje districts and one District Education Board Secretary’s (DEBS) Office in Mpika. The purpose of the risk assessment is to identify, assess, rank, and propose measures to mitigate fiduciary risks of public finance management systems of the Ministry of Local Government and Rural Development’s LAs in the above-mentioned districts. Further, the assessment will identify risks and propose mitigation measures in the Mpika District Education Board Secretary (DEBS) office, District Education Resource Centre and a selected sample of Zonal schools within Mpika district.

The following four consultancies are sought to initiate work in late May or early June to finalize the design of the assignment. After completion of the field work, the core consultants will be responsible for reporting and responding to suggestions for finalization of the deliverables.

 

Scope of Work for Consultants

LARA Senior Team Advisor  (1)

The Local Authorities Risk Assessment (LARA) Senior Team Advisor (STA), based in Lusaka, is a short-term consultancy over a six-to-eight-month period. The STA is the lead country level technical expert responsible for providing leadership, oversight and direction on the LA and DEBS risk assessment assignment. The STA is responsible for the smooth delivery of the multi-site assessment on time at a high level of technical quality across all administrative areas.

The STA reports to the Chief of Party and will supervise the three LARA Team Leaders throughout the duration of the assignment.  In addition, the STA will propose the finalization of the sampling methodology in collaboration with the International G2G Risk Assessment Advisor and IntraHealth managers. The STA will review all the deliverables from the three teams conducting fieldwork which include completed questionnaires, preliminary findings, a heat map of risks identified, and proposals for remediation of the risks per site. The STA will lead review of the reports and collaborate with the International G2G Risk Assessment Advisor and editors to finalize the reports after a review by USAID, the primary client.

LARA Team Leaders (3)

The assessment team will include three LARA Team Leaders. The three teams will work in parallel over a 2 to 3-month period to generate the data for the eight risk assessments, and issue draft reports for each site. The LARA Team Leaders (TLs) will lead the performance of the assessments per the established schedule and methodology and serve as point of contact with the corresponding Local Authority and harmonious processes within their teams.  Each TL will lead a three-person team including two risk assessors (RAs), who are specialized consultants (see below), and assume overall responsibility for up to three sites in the LAs/DEBS field portion of the study. The TLs will ensure the quality of data collection, data review, accuracy of findings, and report quality of each site assessment according to the approved methodology and tools within the planned time frame (estimated at two to three weeks per site). Each TL will accompany the team to the field sites and manage the daily activities including the validation sessions with the Local Authority or DEBS Office. The TL will submit a team report for each site, according to specifications, including preliminary findings, a heat map of risk, and proposed mitigation measures. The team leaders will work under the technical direction of the LARA Senior Technical Advisor (STA) and overall supervision of the Chief of Party and International Senior G2G Advisor.  The TLs will respond to feedback and suggestions for follow up. Strong report writing and documentation skills are required

Deliverables Summary

  1.  USAID G2G document review.
  2. Review and update Risk Assessment Tool from USAID/IntraHealth.
  3.  Detailed site assessment sampling methodology within 10 days after start.
  4.  Participate in first site visit (70 km from Lusaka) and/or after-action review workshop.
  5.  Complete field work at eight sites across all administrative areas (see below).
  6.  Coordinate and deliver technical assistance to ensure quality of the assessment.
  7.  Complete set of primary data (questionnaires and site testing results) per site (seven LAs and one DEBS/Resource Center).
  8. Prepare, review and finalize each (8) district level risk assessment report, including:
    • Heat map of risks identified per site.
    • Transaction testing information per site.
    • Summarize main findings/risk per site.
    • Propose risk mitigation measures for each material risk identified.
    • For the Mpika DEBS site, document all findings of the Mpika DEBS Office, District Resource Center and a sample of Zonal school assessments.
  9.  Finalize reports for each LA (7) or DEBS (1), responding to reviewer comments from USAID and IntraHealth.
  10. Develop final risk mitigation plans (RMP) for each assessed site (7 LA and 1 DEBS) responding to all comments from USAID and IntraHealth.

Qualifications

  • Minimum of master’s degree in a relevant field, such as public administration, public finance, management accounting/audit, international development and donor compliance, or business administration/technology.
  • 15 years’ experience required (STA) or 10 year’s experience required (TLs) in public sector audit and/or development cooperation projects and/or consultancies with increasing responsibilities and accountability.
  • Minimum of ten years’ experience (STA) or five years’ experience (TLs) in international development including both the public and NGO sector. Previous work experience with Zambian Local Authorities and experience conducting USAID G2G risk assessments or donor audits is an added advantage.
  • Very good communication and technical supervisory skills related to the subject matter (public administration, finance, procurement, logistics, audit, human resources, technology, ethics/integrity, and local governance).
  • Deep understanding of internal controls, and actual practice, in the Zambian public sector, standard operating procedures and USAID programming and compliance requirements desired.
  • Program management, process consulting and report writing skills with a client-facing orientation required.
  • Ability to multi-task and work under tight deadline requirements in a team setting, including home office and donor feedback.

Six to eight additional risk assessors will be incorporated once the core consultant team (one senior team advisor and three team leaders) is in place. Field work is expected to take two to three months.

LARA Risk Assessors (6-8)

The assessment team will include up to seven risk assessors (RAs) who are specialized consultants in areas such as finance, cash and banking, audit, procurement, human resources, information technology, and local governance for public administration in the Zambian Government.  The RAs will work with team leaders during the field work portion of the study, collect data, follow the study methodology and LARA tool (to be provided), and document findings. Each RA should have strong technical command of at least two to three of the sub-areas of the LARA tool (below). RAs should be thorough and ensure all findings are carefully documented and analyzed by the team.

The LARA tool includes specific questions, standards, control benchmarks that are appropriate for the Zambian local government public administration.  The sub-areas include:

  •  Budget (budget formulation and control, calendar, communications, variance analysis, validation of SOPs, budget transfers, donor funds),
  •  Cash & Treasury Management (cash management, cash flow, forecasting, bank accounts, governance, bank reconciliations)
  •  Accounting and Reporting (system, standards, SOPs, journal entry controls, financial reporting, reconciliation of ledgers, CoA, payment SOPs and controls, asset management and control);
  •  Procurement (functional control, documentation, staffing, planning, bidding SOPs, evaluation, advertisement, award SOPs, review/resolution of complaints, contract management, oversight, integrity);
  •  Human Resources & Payroll (policies, SOPs, hiring, training, payroll records, fraud controls, payments);
  •  Internal Control (codes of conduct, integrity policies, management commitment and ethics, enforcement, risk management, employee incentives and retention);
  •  Information Technology (policies, SOPs, IT audits, access, backup, IT security, incident management, threats).

One cross-cutting risk assessor in D&G is sought with strong thematic knowledge of and expertise in USAID D&G programs to evaluate high-level risks associated with democracy, governance, and the political economy of international development cooperation.

Requirements include advanced degree, practical experience conducting assessments with international partners, and strong documentation and communication (writing and speaking) skills.

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

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
60.294MBMemory Usage407msRequest 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" => "f40a4c135e737fbf0a28fc5a6dd90350" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 3 "timer" => array:3 [ "start" => 1747101561 "last" => 1747101563...
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) (24.57ms)
  • afterInitialise (11.13MB) (84.11ms)
  • afterRoute (5.03MB) (27.45ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (255μs)
  • afterRenderComponent com_jsjobs (3.12MB) (29.29ms)
  • Before Access::preloadComponents (all components) (239.64KB) (4.37ms)
  • After Access::preloadComponents (all components) (132.72KB) (622μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (13μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (235μs)
  • afterDispatch (2.39MB) (56.94ms)
  • afterRender (31.48MB) (179ms)
  • 1 x afterRender (31.48MB) (43.92%)
    178.95ms
    1 x afterInitialise (11.13MB) (20.64%)
    84.11ms
    1 x afterDispatch (2.39MB) (13.97%)
    56.94ms
    1 x afterRenderComponent com_jsjobs (3.12MB) (7.19%)
    29.29ms
    1 x afterRoute (5.03MB) (6.74%)
    27.45ms
    1 x afterLoad (4.12MB) (6.03%)
    24.57ms
    1 x Before Access::preloadComponents (all components) (239.64KB) (1.07%)
    4.37ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.15%)
    622μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.06%)
    255μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.06%)
    235μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    13μs
89 statements were executed, 23 of which were duplicates, 66 unique14.06ms294.25KB
  • SELECT @@SESSION.sql_mode;40μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?84μ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_id74μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`75μ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` = :guest98μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'75μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`64μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'138μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config110μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'119μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'86μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'60μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'55μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Call-for-Lead-Consultants-and-Risk-Assessors-for-USAID-LOCAL-tender-at-IntraHealth-International-60186%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Call-for-Lead-Consultants-and-Risk-Assessors-for-USAID-LOCAL-tender-at-IntraHealth-International-60186%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Call-for-Lead-Consultants-and-Risk-Assessors-for-USAID-LOCAL-tender-at-IntraHealth-International-60186%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC174μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Call-for-Lead-Consultants-and-Risk-Assessors-for-USAID-LOCAL-tender-at-IntraHealth-International-60186%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Call-for-Lead-Consultants-and-Risk-Assessors-for-USAID-LOCAL-tender-at-IntraHealth-International-60186%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Call-for-Lead-Consultants-and-Risk-Assessors-for-USAID-LOCAL-tender-at-IntraHealth-International-60186%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC201μ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.id139μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'220μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'273μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'225μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'209μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'192μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'98μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'61μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'276μ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 = 60186557μs36.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'230μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 60186265μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'129μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering211μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'153μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'209μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering243μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'122μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'223μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'93μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'46μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'191μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'116μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'42μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'55μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 294μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 279μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'278μ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'355μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 295μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 280μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 280μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'200μs1.02KB/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:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'166μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering112μ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)362μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 072μs920B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2262μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24100μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2865μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38131μs73.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40109μ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` = 0156μ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.lft370μ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.lft207μ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.lft319μ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-Call-for-Lead-Consultants-and-Risk-Assessors-for-USAID-LOCAL-tender-at-IntraHealth-International-60186' AND `published` = 1141μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Call-for-Lead-Consultants-and-Risk-Assessors-for-USAID-LOCAL-tender-at-IntraHealth-International-60186'73μs8.94KB/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration205μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'147μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field131μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'64μ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` = 192μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'140μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`220μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'111μ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 desc178μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`330μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid92μ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-Call-for-Lead-Consultants-and-Risk-Assessors-for-USAID-LOCAL-tender-at-IntraHealth-International-60186'107μ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` = 159μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"310μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES985μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin84μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin65μ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`67μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'114μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'154μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 181561μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?106μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?125μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy