Consultancy- Localised Youth Employment and Entrepreneurship Opportunity Scan in Luwingu,Kasama, Chasefu, Lumezi,Nyimba,Solwezi,Kalumbila, Sibuyunji, Mphongwe,Kalomo and Livingstone tender at SNV
Website :
42 Days Ago
Linkedid Twitter Share on facebook

SNV Netherlands Development Organisation

SNV is a global development partner, deeply rooted in the countries where we operate. Driven by a vision of a better world where all people live with dignity and have equitable opportunities to thrive sustainably, SNV strengthens capacities and catalyses partnerships that transform agri-food, energy, and water systems. We help strengthen institutions and effective governance, reduce gender inequalities and barriers to social inclusion, and enable adaptation and mitigation to the climate and biodiversity crises. With 60 years of experience and a team of approximately 1,600 people, we support our partners in more than 20 countries in Africa and Asia, tailoring our approaches to different contexts to achieve large-scale impact and create more equitable lives for all.

Background:

SNV is implementing the second phase of the Scaling Up Youth Employment in Agriculture Initiative Opportunities for Youth Employment (YEE)+ project in Zambia. The four-year YEE+ Phase II project builds off successes, lessons learned and evaluations to date from the Phase I project in Zimbabwe and Zambia, other SNV youth employment projects and the YEE programme in Tanzania. The YEE+ Phase II program aims at fostering a strengthened approach to youth employment programming by addressing structural barriers, offering tailored support, and promoting collaboration among community, private sector, and government stakeholders to create dignified livelihoods for young people.

The key objectives of the project are to:

1. Increase access to employment and entrepreneurial skills development opportunities.
2. Match young people to economic opportunities in their communities, using market development and increased financial inclusion.
3. Contribute to and support an enabling environment via company partnerships, community engagement, and improved government coordination.

The project employs the Youth Employment and Entrepreneurship (YEE) Pull-Match-Pull-Enable framework approach that brings together partners from the private sector, service providers, and government to focus on employability, entrepreneurship, and business access for youth. In view of the above, a need has arisen for SNV to conduct a Localized Youth Employment and Entrepreneurship Opportunity Scan (Opportunity Scan) as a prelude to the implementation of the project. Opportunity identification lays the groundwork for implementing YEE activities, by directing interventions towards growth-oriented economic sectors that present viable youth employment and entrepreneurship. SNV intends to undertake a pragmatic exercise to inform a concrete project implementation strategy. To that end, the Opportunity Scan will be led by the SNV technical team with support from an independent consultant, ensuring that YEE+ Phase II activities are strategically aligned with promising economic opportunities. By leveraging the expertise of both teams, the exercise will comprehensively analyze and identify opportunities that are both viable, appealing to youth aspirations and “green” in nature which addresses current and futuristic localized challenges and ever-changing market dynamics. Additionally, the central involvement of the SNV technical team will foster ownership and sustainability, anchoring the identified opportunities within the YEE framework approaches.

Objective of the consultancy

The Localised Youth Employment and Entrepreneurship Opportunity Scan will be conducted in selected districts in the Northern, Southern, Eastern and Central provinces of Zambia, as part of the OYE+ Phase II program. The objectives are to identify youth employment opportunities, provide information on value chains, market opportunities and trade, actor profiling and provide detailed insights into youth aspirations and ambitions. The scan will inform the project’s implementation strategy by identifying potential areas of intervention and partnership.

Scope of work

The Localized YEE Opportunity Scan will be conducted in Lumezi, Chasefu and Nyimba in Eastern province, Kalomo and Livingstone in Southern province, Sibuyunji in Central province and Luwingu and Kasama in Northern province. Solwezi and Kalumbila in Northwestern province. The Consultant will work closely with the SNV implementation team throughout this assignment (from desk review to final reporting), ensuring GESI is well integrated in the study and their main role is to consolidate findings and delivery of high-quality outputs covering all below listed focus areas (including expected tasks).

# Focus area Key tasks (NB: Consultant will work together with SNV advisors on all tasks)

1 Participatory Desk Research  Review existing literature, reports, and data related to youth employment and entrepreneurship in Zambia in general and focus on the following districts: Luwingu, Kasama, Chasefu, Lumezi, Nyimba, Solwezi, Kalumbila, Sibuyunji, Mphongwe, Kalomo and Livingstone.

  • Identify relevant socio-economic trends, and challenges affecting youth in the target areas.

2 Stakeholder Engagement

  • Identify and hold key informant interviews with key stakeholders including the youth, local authorities, community leaders, government line ministries, private sector, local associations, TVETs and other relevant actors.
  • Facilitate focus group discussions to gather insights into youth aspirations, challenges, and existing opportunities.

3 Opportunity Mapping

  • Conduct localized mapping of employment and entrepreneurship opportunities, focusing on agriculture, Energy, and non-agricultural sectors.
  • Identify low-hanging opportunities suitable for youth engagement, considering factors such as market demand, feasibility, and scalability.

4 Value Chain Mapping

  • Together with the SNV team, identify viable value chains that offer opportunities for youth based on initial market opportunity scan and stakeholder input.
  • Conduct in-depth mapping of identified value chains, including identifying key actors, market dynamics, and potential value addition points.
  • Analyse value chain constraints and opportunities to inform strategic interventions aimed at enhancing youth participation and competitiveness.

5 Partner mapping

  • Identify Strong private sector partners with strong willingness to work with youth, youth entrepreneurs and localized collaborating partners relevant to the shortlisted opportunities.
  • Map out existing partnerships and networks within the target areas, including relevant local associations, cooperatives, and grassroots organizations.
  • Assess partnership potential and alignment with objectives of the YEE+ project considering factors such as capacity (experience, expertise, resources) and shared goals.
  • Compile partner profiles and contact information for further engagement and collaboration.

6 Gender Equality and Social Inclusion (GESI) Analysis

  • Conduct a comprehensive analysis of gender dynamics and social inclusion issues affecting youth employment and entrepreneurship.
  • Identify barriers and opportunities for marginalized groups, including persons with disabilities, and other vulnerable groups.
  • Develop recommendations for ensuring project activities will address GESI issues during implementation.
    7 Intervention Nodes
  • Based on the findings from opportunity mapping, value chain analysis, partner mapping, and GESI analysis, identify priority intervention areas or “nodes” for project implementation.
  • Define specific activities, target beneficiaries, and expected outcomes for each intervention node.

Deliverables

The consultant will deliver the following:

1. Inception report, based on preliminary desk review of available literature discussion with SNV. The inception report shall include:

i. The proposed methodology including research methodology, target areas, data collection tools, proposed respondents.
ii. Detailed workplan outlining timeframes and key deliverables and milestones.
iii. Outline of the final report

2. Draft report with preliminary findings of the study for review by SNV

3. Comprehensive final report of the study reviewed and approved by SNV. The final report should cover the study focus areas in detail. These are.

i. Document stakeholder feedback and suggestions to inform the opportunity scanning process.
ii. Opportunity mapping shortlist highlighting localized opportunities for youth employment and entrepreneurship.
iii. Value chain mapping identifying promising value chains and potential interventions.
iv. Partner mapping outlining private sector partners and potential local collaborating partners and service providers with entry points.
v. GESI analysis highlighting key findings and recommendations.
vi. Intervention nodes document identifying priority areas for project intervention.

4. Presentation (PowerPoint) of Findings and Recommendations: Aligned with SNV PPT Guidelines

Tentative Activities and Timeframe
Stage Who Time March Expected outcome
Consultant engagement Procurement 2 days Consultant engaged
Desk study SNV team and consultant 1 day Inception report, Pre-selection of districts, data collection tools
Provincial / district field visits SNV team and consultant 14 days KII, FGD,
Production of the Draft Report & PowerPoint Presentation and approval SNV team and consultant 3 days Draft Report validation meetings
Production of Localised Scan Final Report & PowerPoint Presentation Consultant 3 days Final Report (in Word & PDF formats)
PowerPoint Presentation

Qualifications and experience

The ideal consultant for carrying out this assignment must possess the following academic qualifications, technical expertise, and experience:

1. Must possess a minimum of a bachelor’s degree in a relevant field such as economics, agricultural economics, development studies, business administration, or a related discipline is essential. A higher qualification in a relevant field will be an advantage.
2. Experience (at least 5-7 years) working in the field of agriculture, youth employment, entrepreneurship, rural development, or value chain analysis with a strong understanding of the challenges and opportunities faced by youth in Zambia.
3. Demonstrated ability to conduct opportunity scans, market surveys and conduct research through desk review, key informant interviews and focus Group Discussions, data analysis, and synthesis of findings into actionable recommendations.
4. Proficiency in conducting value chain mapping and analysis, identifying key actors, market dynamics, and intervention points.
5. Strong writing skills with the ability to produce clear, concise, and well-structured reports.
6. Proficiency in English is required, while proficiency in local languages spoken in the target districts would be an asset for effective communication with stakeholders.
7. Self-motivated and able to work independently.

Documents to be submitted as part of the Consultants application:

1. Bidder Profile
1.1 Document summarizing the bidder’s background, qualifications and experience.
1.2 If a team of individuals/consultancy firm, all the CVs of the proposed individuals by the firm to work on the assignment.

The submission requirements
Interested consultants or firms should submit the documents specified below to zambiaprocurement@snv.org by close of business on 07-03-2025.
1. A detailed proposal outlining the approach, methodology and the timeline for the study
2. A budget breakdown including fees or any other costs
3. CVs of the key team members and relevant work experience
4. Examples of similar work previous conducted

2. Past Performance

2.1. Include three reference projects related to consulting, conceptualization, designing and/or managing projects in the area of youth employment/skills development/ market linkages/Agriculture/ private sector engagement in development projects within the past five years containing the following information (1-2 pages per project max):

2.1.1. Name of Client/Employer
2.1.2. Title of the Project, dates, and duration of the project
2.1.3. Scope of the Project, Requirements of the assignment, Proposed Solutions and Outcome
2.1.4. Reference/Contact person details for each assignment and contact information.
2.1.5. Attach evidence of performance for each of the three referenced projects listed in the candidate profile (e.g. reports)

3. Mandatory Requirements
3.1 For Zambian national individual consultants: copies of Tax Registration certificate and the most recent tax clearance certificate.
3.2 For a firm registration document: Business license/Certificate of Registration for all, Tax Registration, Current Tax Clearance Certificate, certificate of incorporation and VAT if applicable

Failure to provide a full package of documents listed above them will result in disqualification of the whole bid. Only Shortlisted Candidates will be contacted.

Detailed specifications and requirements are well stated in the RFP which can be found on this link.

Application Criteria:

Note: SNV Zambia may request for necessary and/or more information during the evaluation. SNV will only contact the successful bidder (s) within the period of 2 weeks from the closing date of submission

Job Info
Job Category: Tenders in Zambia
Job Type: Full-time
Deadline of this Job: Friday, February 28 2025
Duty Station: Lusaka
Posted: 20-02-2025
No of Jobs: 1
Start Publishing: 20-02-2025
Stop Publishing (Put date of 2030): 20-02-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
59.925MBMemory Usage428msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.28-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "1deb24708f7a51ca02b447b7f6862276" => "4cb7afec187b45a2346fd267440d27db" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 3 "timer" => array:3 [ "start" => 1743728407 "last" => 1743728411...
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) (19.62ms)
  • afterInitialise (11.13MB) (63.15ms)
  • afterRoute (5.04MB) (23.63ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (166μs)
  • afterRenderComponent com_jsjobs (3.15MB) (28.15ms)
  • Before Access::preloadComponents (all components) (247.64KB) (6.42ms)
  • After Access::preloadComponents (all components) (132.72KB) (1.06ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (22μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (342μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.53MB) (65.17ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (55.32ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (5μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (279μs)
  • afterDispatch (87.16KB) (96μs)
  • afterRender (13.8MB) (163ms)
  • 1 x afterRender (13.8MB) (38.19%)
    163.28ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.53MB) (15.24%)
    65.17ms
    1 x afterInitialise (11.13MB) (14.77%)
    63.15ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (12.94%)
    55.32ms
    1 x afterRenderComponent com_jsjobs (3.15MB) (6.58%)
    28.15ms
    1 x afterRoute (5.04MB) (5.53%)
    23.63ms
    1 x afterLoad (4.12MB) (4.59%)
    19.62ms
    1 x Before Access::preloadComponents (all components) (247.64KB) (1.5%)
    6.42ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.25%)
    1.06ms
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.08%)
    342μs
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.07%)
    279μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    166μs
    1 x afterDispatch (87.16KB) (0.02%)
    96μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0.01%)
    22μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    5μs
90 statements were executed, 23 of which were duplicates, 67 unique17.7ms272.23KB
  • SELECT @@SESSION.sql_mode;67μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?88μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 166μ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_id295μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`80μ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` = :guest121μ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`71μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'142μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config102μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'65μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'63μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'49μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'46μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Consultancy-Localised-Youth-Employment-and-Entrepreneurship-Opportunity-Scan-in-Luwingu%2CKasama%2C-Chasefu%2C-Lumezi%2CNyimba%2CSolwezi%2CKalumbila%2C-Sibuyunji%2C-Mphongwe%2CKalomo-and-Livingstone-tender-at-SNV-73053%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Consultancy-Localised-Youth-Employment-and-Entrepreneurship-Opportunity-Scan-in-Luwingu%2CKasama%2C-Chasefu%2C-Lumezi%2CNyimba%2CSolwezi%2CKalumbila%2C-Sibuyunji%2C-Mphongwe%2CKalomo-and-Livingstone-tender-at-SNV-73053%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Consultancy-Localised-Youth-Employment-and-Entrepreneurship-Opportunity-Scan-in-Luwingu%2CKasama%2C-Chasefu%2C-Lumezi%2CNyimba%2CSolwezi%2CKalumbila%2C-Sibuyunji%2C-Mphongwe%2CKalomo-and-Livingstone-tender-at-SNV-73053%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC187μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Consultancy-Localised-Youth-Employment-and-Entrepreneurship-Opportunity-Scan-in-Luwingu%2CKasama%2C-Chasefu%2C-Lumezi%2CNyimba%2CSolwezi%2CKalumbila%2C-Sibuyunji%2C-Mphongwe%2CKalomo-and-Livingstone-tender-at-SNV-73053%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Consultancy-Localised-Youth-Employment-and-Entrepreneurship-Opportunity-Scan-in-Luwingu%2CKasama%2C-Chasefu%2C-Lumezi%2CNyimba%2CSolwezi%2CKalumbila%2C-Sibuyunji%2C-Mphongwe%2CKalomo-and-Livingstone-tender-at-SNV-73053%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Consultancy-Localised-Youth-Employment-and-Entrepreneurship-Opportunity-Scan-in-Luwingu%2CKasama%2C-Chasefu%2C-Lumezi%2CNyimba%2CSolwezi%2CKalumbila%2C-Sibuyunji%2C-Mphongwe%2CKalomo-and-Livingstone-tender-at-SNV-73053%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC238μ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.id164μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'302μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'253μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'212μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'273μ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'83μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'59μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'226μ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 = 73053663μs68.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'253μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 73053376μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'249μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering272μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'212μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'212μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering254μs15.48KB/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 = 'listjob'230μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'61μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'49μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'183μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'279μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'60μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'59μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2142μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2123μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'558μ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'496μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2136μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2127μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2126μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'212μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'309μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'168μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering178μ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)650μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0126μs936B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2295μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2479μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2877μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38102μs17.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 39118μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40132μ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` = 0123μ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.lft417μ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.lft232μ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.lft485μ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-Consultancy-Localised-Youth-Employment-and-Entrepreneurship-Opportunity-Scan-in-Luwingu,Kasama,-Chasefu,-Lumezi,Nyimba,Solwezi,Kalumbila,-Sibuyunji,-Mphongwe,Kalomo-and-Livingstone-tender-at-SNV-73053' AND `published` = 1106μs9.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Consultancy-Localised-Youth-Employment-and-Entrepreneurship-Opportunity-Scan-in-Luwingu,Kasama,-Chasefu,-Lumezi,Nyimba,Solwezi,Kalumbila,-Sibuyunji,-Mphongwe,Kalomo-and-Livingstone-tender-at-SNV-73053'60μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration201μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'108μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field94μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'68μ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` = 1107μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'192μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`300μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'68μ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 desc139μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`312μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid113μ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` = :muserid135μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Consultancy-Localised-Youth-Employment-and-Entrepreneurship-Opportunity-Scan-in-Luwingu,Kasama,-Chasefu,-Lumezi,Nyimba,Solwezi,Kalumbila,-Sibuyunji,-Mphongwe,Kalomo-and-Livingstone-tender-at-SNV-73053'75μ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` = 170μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"229μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES902μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin91μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin76μ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`83μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'78μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'242μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 231362μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?71μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.31ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy