Request for Proposal, Zambia Field Data Collectors at Bridges to Prosperity (B2P)
1057 Days Ago
Linkedid Twitter Share on facebook

Request for Proposal, Zambia Field Data Collectors at Bridges to Prosperity (B2P)

I) BACKGROUND

Bridges to Prosperity (B2P) is a non-profit organization focused on ending isolation-caused poverty through the support and implementation of rural transport infrastructure. While B2P is an implementer in many countries, we also strive to catalyze and enable the sector. In addition, B2P is working to develop digital tools to remotely assess barriers to services in rural communities to locate where rural trailbridges are needed.

This project aims to create the tools and aggregate the information most critical for government partners in Zambia to understand the scope of need, an estimated cost, a possible implementation plan, and the potential impact of a national rural trailbridge program. We will use satellite imagery and machine learning to develop a method to produce an estimate of the number and approximate locations of trailbridges needed by rural communities in Zambia. We aim to create a report that details the estimated number of trailbridges required in Zambia, including estimated geographic distribution, potential impact, and anticipated cost.

II) OBJECTIVE

The objective of the field data collection team is to validate potential trailbridge sites according to Bridges to Prosperity standard procedures.  Some sites will be identified by Bridges to Prosperity’s remote site identification tool, other sites will be identified by the field data collectors communicating with local government authorities in the same area as the ground-truthing.

SCOPE OF WORK

Ground Truth Remotely Identified Sites

The consultant is expected to have experience with collecting field data through mobile applications (smartphones and tablets) as well as an understanding of how to navigate government communication channels in order to inform the necessary parties of the needs assessment in order to identify potential bridge sites, as well as obtain necessary permissions and approval to conduct the field assessments. The level of field work will require multiple enumerators in the field simultaneously, and the responding firm or consultant should have the capacity to immediately deploy or hire qualified personnel (3-4) to work in the field.

Key tasks of the assessment include but are not limited to:

  • Obtain all the proper permissions and approval to conduct ground truthing and needs assessment work in the field.
  • Managing a team (3-4) of field data collectors employed by the consultant.
  • Provide regular updates to Bridges to Prosperity
  • Learn B2P’s standard practices and methodologies for field data collection (social and technical) and ensure field staff are adhering the B2P’s standards.
  • Conduct field level assessment to gather qualitative and quantitative data from primary sources.
  • Support field enumerators in traveling to potential bridge sites.

III)  SUMMARY OF TASKS AND DELIVERABLES

Objective

Activities

Outputs

Phase One: Local Government Engagement and Trailbridge Site Identification

Acquire permission for conducting the needs assessment

  • Engage with appropriate government officials to inform about the trailbridge needs assessment
  • Acquire permission from government for interviewing residents in rural areas as part of the needs assessment
  • Documentation from local government i.e. support letter, communication letter, etc.

Identify potential trailbridge sites

  • Collect trailbridge requests from local government in the areas of interest
  • Spreadsheet with a list of trailbridge requests identified by local leaders

Vett requested sites

  • Assessors will communicate with local residents by phone to gain additional information and verify whether a requested site should be visited and assessed
  • Spreadsheet with a list of trailbridge requests identified by local leaders

Phase Two: Conduct Trailbridge Needs Assessments and Groundtruth Remotely Identified Sites

Conduct project assessments at many river crossings

Using tablets and software provided by B2P assessors will:

  • record information about the river crossing and the impact it has on residents reaching essential destinations
  • take photos of the river crossing to inform B2P what type of bridge may be required
  • record technical information about the characteristics of the river in regards to flooding and blocking transportation access.
  • Assessment data and photos uploaded to B2P’s database by syncing tablets

Ground-truth remotely identified sites

  • Assessors will navigate to specific coordinates provided by B2P in order validate the presence of a river crossing in need of a bridge.
  • Assessment data and photos uploaded to B2P’s database by syncing tablets

Similar Jobs in Zambia

Learn more about Bridges to Prosperity (B2P)

Bridges to Prosperity (B2P) jobs in Zambia

IV) METHODOLOGY

After consulting with B2P to identify the districts most likely to have the highest need for trailbridges the consultant will identify and engage with the appropriate officials at the district level in order to inform them of B2P’s cable bridge technology and request permission and support to conduct a trailbridge needs assessment. The consultant will then engage with local leaders to collect trailbridge requests. These requests will be recorded in a spreadsheet along with additional information to guide assessors on which requests should be visited, if possible assessors will also request GPS coordinates be provided with requests.

As trailbridge requests are being submitted to assessors, the assessors will call the local contact associated with the request in order to vet sites and avoid visiting certain sites, for example a request for a vehicular bridge.

After trailbridge requests have been vetted, assessor will visit sites and conduct a project assessment using tablets and software provided by B2P. Assessors will talk to community members in a focus group setting to collect information about the river and it’s impact on accessibility to key destinations such as schools, healthcare facilities, markets, etc. Assessors will take multiple photos of the river crossing as well as use a range finder (provided by B2P) to estimate the width of the river during flooding. B2P will provide training to the assessment team on how to use the tools provided.

In addition to assessing requested sites, assessors will ground-truth results from B2P’s machine learning model which is being developed to identify river crossings remotely using satellite imagery. Assessors will navigate to provided coordinates and see if there is a barrier and pedestrian traffic near the given coordinates. If the site is valid, assessors will conduct a project assessment at the site.

V) TIME FRAME

The assessment is expected to be completed within 120 days.  B2P would like to start the project as early as Sept 1, 2022. The number of sites visited will depend largely on the number of sites identified by the remote model and local government authorities, as well as the geographic distribution of identified sites.

VI)  ROLES AND RESPONSIBILITIES

B2P will be responsible for the provision of the following:

  • Samsung Galaxy Tablets
  • Range finders
  • 1-week training in Lusaka, Zambia including accommodation, and field transportation. B2P will not cover transportation costs for assessors traveling to Lusaka
  • Guides and templates for conducting the assessments
  • Feedback after initial assessments
  • Production of support letter to Federal and Regions,
  • Initial contacts for Ministry of Transportation and Ethiopia Roads Authority

The consultant will be responsible for the following:

  • All logistical and transportation costs for conducting needs assessments, including hotels and per diems, excluding the 1-week training mentioned above.
  • Completion of all outlined deliverables in a quality and timely manner

VII) DATA DISCLOSURE

Primary data collected through this consultancy is owned by B2P and should not be used for other purposes by the consultant.

VIII) APPLICATION PROCEDURE

Prerequisites

  • The consultants shall have proven experiences in collecting field data in rural areas in Zambia.
  • The consultant shall have experience communicating with local government and the district and lower levels.
  • The consultant has experience managing and data collection team and experienced enumerators/data collectors on their team.
  • The desired qualification includes a bachelor’s degree in economics, engineering, development studies and/or management with substantial experiences in conducting exercises of this nature
  • Excellent writing and communication skills (in English).

Proposal Requirements

Qualified consultants or consultancy firms interested in the assignment are expected to submit the following documentation:

  • A technical proposal (max 3 pages): interpreting the Terms of Reference, elaborating the proposed methodology and design, including (1) draft work plan against proposed time frame justifying any proposed changes to the deliverable schedule or process (2) brief overview of the consultant/consultancy firm and the skills and experiences they would bring to the assignment (including CVs of any team members assigned to the assessment); (3) contact details of one referee from another organization that have contracted the consultant/consultancy firm to perform similar work.
  • A financial proposal: clarifying the following costs: (1) budget with professional fee per day, and other relevant costs including logistical costs
  • Sample of recent work completed for a similar program.

Submission of proposals

Job Info
Job Category: Tenders in Zambia
Job Type: Full-time
Deadline of this Job: 5 July 2022
Duty Station: Lusaka
Posted: 20-06-2022
No of Jobs: 1
Start Publishing: 20-06-2022
Stop Publishing (Put date of 2030): 20-06-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
60.255MBMemory Usage593msRequest 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
[]
$_SERVER
array:63 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1747037003 "last" => 1747037003...
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) (29.14ms)
  • afterInitialise (11.08MB) (105ms)
  • afterRoute (5.03MB) (36.66ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (233μs)
  • afterRenderComponent com_jsjobs (3.13MB) (38.36ms)
  • Before Access::preloadComponents (all components) (235.64KB) (6.75ms)
  • After Access::preloadComponents (all components) (132.72KB) (1.01ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (16μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (316μs)
  • afterDispatch (2.4MB) (106ms)
  • afterRender (31.47MB) (269ms)
  • 1 x afterRender (31.47MB) (45.25%)
    268.52ms
    1 x afterDispatch (2.4MB) (17.94%)
    106.42ms
    1 x afterInitialise (11.08MB) (17.7%)
    105.04ms
    1 x afterRenderComponent com_jsjobs (3.13MB) (6.46%)
    38.36ms
    1 x afterRoute (5.03MB) (6.18%)
    36.66ms
    1 x afterLoad (4.12MB) (4.91%)
    29.14ms
    1 x Before Access::preloadComponents (all components) (235.64KB) (1.14%)
    6.75ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.17%)
    1.01ms
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.05%)
    316μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    233μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    16μs
89 statements were executed, 23 of which were duplicates, 66 unique34.95ms278.22KB
  • SELECT @@SESSION.sql_mode;55μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?108μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 1110μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `icop0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)13.46ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`130μs1.59KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `icop0_usergroups` AS `a` LEFT JOIN `icop0_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest155μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'123μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`84μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'164μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config196μ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'74μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'79μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'83μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Request-for-Proposal%2C-Zambia-Field-Data-Collectors-at-Bridges-to-Prosperity-B2P-36003%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Request-for-Proposal%2C-Zambia-Field-Data-Collectors-at-Bridges-to-Prosperity-B2P-36003%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Request-for-Proposal%2C-Zambia-Field-Data-Collectors-at-Bridges-to-Prosperity-B2P-36003%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC237μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Request-for-Proposal%2C-Zambia-Field-Data-Collectors-at-Bridges-to-Prosperity-B2P-36003%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Request-for-Proposal%2C-Zambia-Field-Data-Collectors-at-Bridges-to-Prosperity-B2P-36003%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Request-for-Proposal%2C-Zambia-Field-Data-Collectors-at-Bridges-to-Prosperity-B2P-36003%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC354μ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.id298μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'281μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'285μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'257μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'291μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'239μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'78μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'100μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'264μ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 = 36003741μs20.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'296μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 360031.65ms48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'242μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering297μ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'205μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering268μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'218μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'233μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'69μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'66μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'297μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'269μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'103μ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 fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2183μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2187μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'632μ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'575μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2177μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2147μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2170μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'246μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'272μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'248μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering182μ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)648μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0134μs920B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22117μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24110μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2896μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38166μs73.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40113μ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` = 0159μ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.lft532μ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.lft269μ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.lft527μ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-Request-for-Proposal,-Zambia-Field-Data-Collectors-at-Bridges-to-Prosperity-B2P-36003' AND `published` = 1238μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Request-for-Proposal,-Zambia-Field-Data-Collectors-at-Bridges-to-Prosperity-B2P-36003'144μs8.94KB/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration339μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'192μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field148μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'166μ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` = 1165μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'254μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`339μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'113μ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 desc233μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`403μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid144μ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` = :muserid193μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Request-for-Proposal,-Zambia-Field-Data-Collectors-at-Bridges-to-Prosperity-B2P-36003'132μ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` = 193μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"387μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.1ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin114μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin98μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` FROM icop0_usergroups AS `groups`102μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'155μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'266μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 538190μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?121μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?450μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy