PCP National Coordinator job at United Nations Industrial Development Organization (UNIDO)
166 Days Ago
Linkedid Twitter Share on facebook

Vacancy title:
PCP National Coordinator

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

Jobs at:

United Nations Industrial Development Organization (UNIDO)

Deadline of this Job:
Tuesday, November 19 2024 

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

Summary
Date Posted: Wednesday, October 30 2024, Base Salary: Not Disclosed

Similar Jobs in Zambia
Learn more about United Nations Industrial Development Organization (UNIDO)
United Nations Industrial Development Organization (UNIDO) jobs in Zambia

JOB DETAILS:
ORGANIZATIONAL CONTEXT
The United Nations Industrial Development Organization (UNIDO) is the specialized agency of the United Nations that promotes industrial development for poverty reduction, inclusive globalization and environmental sustainability. The mission of UNIDO, as described in the Lima Declaration adopted at the fifteenth session of the UNIDO General Conference in 2013 as well as the Abu Dhabi Declaration adopted at the eighteenth session of UNIDO General Conference in 2019, is to promote and accelerate inclusive and sustainable industrial development (ISID) in Member States. The relevance of ISID as an integrated approach to all three pillars of sustainable development is recognized by the 2030 Agenda for Sustainable Development and the related Sustainable Development Goals (SDGs), which will frame United Nations and country efforts towards sustainable development. UNIDO’s mandate is fully recognized in SDG-9, which calls to “Build resilient infrastructure, promote inclusive and sustainable industrialization and foster innovation”. The relevance of ISID, however, applies in greater or lesser extent to all SDGs. Accordingly, the Organization’s programmatic focus is structured in four strategic priorities: Creating shared prosperity; Advancing economic competitiveness; Safeguarding the environment; and Strengthening knowledge and institutions.

Each of these programmatic fields of activity contains a number of individual programmes, which are implemented in a holistic manner to achieve effective outcomes and impacts through UNIDO’s four enabling functions: (i) technical cooperation; (ii) analytical and research functions and policy advisory services; (iii) normative functions and standards and quality-related activities; and (iv) convening and partnerships for knowledge transfer, networking and industrial cooperation. Such core functions are carried out in Divisions/Offices in its Headquarters, Regional Offices and Hubs and Country Offices.

The Directorate of Global Partnerships and External Relations (GLO)act as the central organizational entity of UNIDO to manage relations with UNIDO’s Member States, donors and external partners and thereby ensure close internal coordination with the other Directorates. It will lead the development of UNIDO’s regional, sub-regional, and country-specific strategies. The Directorate houses the Divisions of Policymaking Organs (PMO), Regional Bureaus and Field Offices (RFO), Field and Liaison Strategy (FLS), Member States and Funding Relations (MSR), Special Operations (SOP), and Investment and Technology Promotion Offices and Institutional Partnerships (ITP).

It plays a central role for interaction and collaboration with traditional and non-traditional donors; oversees the regional bureaus as well as the network of established field offices, liaison offices and Investment and Technology Promotion Offices; and supports the implementation of particularly complex projects, programmes and special assignments, thus also fulfilling an important role in safeguarding their quality and the reputation of the Organization.

Core functions include:
Support the allocation and appropriate management and administration of human and financial resources of the field and liaison office network in close cooperation with COR/HRM and COR/FIN;
Upon requests and in line with regional strategies, ensure the development of country programmes (including PCPs) on sustainable industrial development through field offices and regional bureaus (if no field office is in place);
Within the context of regional strategies and country programmes, ensure field offices develop and report on results-oriented yearly implementation plans specifying resource use, engagement of UNIDO staff from HQ and in the field, fundraising targets, sequencing of activities across time, engagement with stakeholder and the implementation of projects;
Ensure implementation of recommendations made by oversight bodies and external/internal auditors.
The Division of Regional Bureaus and Field Offices (GLO/RFO) coordinates the field representation and interventions of UNIDO in Member States and regions. Within this context, the Division is responsible for determining programmatic priorities for UNIDO’s services and ensuring that UNIDO responds to the specific needs and requirements of Member States and development partners at the country and regional levels.

UNIDO’s role in a PCP is to:
Facilitate the convening of partners and the overall coordination of the PCP;
Design and develop a holistic Programme aimed at scaling up development results and building synergies with partner interventions in the country;
Provide normative, policy and advisory services to the Government on industry-related issues;
Deliver integrated and multidisciplinary technical assistance;
Support the Government in mobilizing large-scale industrial investments from public and private partners.
The PCP is currently in the implementation phase, led by the Ministry of Commerce, Trade and Industry. The major milestones ahead include:
• Establishment of the PCP National Coordination Body (NCB), in cooperation with MCTI
• Operationalize the NCB Secretariat, with duties stipulated in the NCB Terms of Reference.
• Coordination and partner engagement
• Execution to ensure design, finance and implement mutually reinforcing interventions in line with the programme’s results framework and in synergy with national and partner interventions, including UNSDCF.
• Monitoring and reporting progress in line with the PCP 2024 annual work plan.

FUNCTIONAL RESPONSIBILITIES
Under guidance and supervision of the Chief for the GLO/RFO/AFR and working with other colleagues within the Regional Bureau, Sub-Saharan Africa region, the Regional Office in South Africa and relevant project teams, the incumbent is responsible for the following tasks:
• Support the PCP Programme Manager and UNIDO Representative in Building National Partnerships
• Assist in developing and nurturing strategic national partnerships by collaborating with key stakeholders to align resources and priorities with the Programme for Country Partnership (PCP).
• Identify and Engage Strategic Partners: Proactively identify and engage partners from government, development organizations, the private sector, and academia to leverage diverse resources, expertise, and networks for maximum impact and sustainability of UNIDO’s initiatives in Zambia.
• Map Financial and Technical Partners: Conduct comprehensive mapping of potential financial and technical partners to support the PCP. Maintain a detailed database capturing essential information on partner and donor requirements, priority areas, and resources to enhance targeted engagement.
• Coordinate Stakeholder Dialogue: Establish and sustain constructive communication with key national and regional stakeholders, including government representatives and development partners, ensuring alignment with the PCP’s objectives and national priorities while promoting cross-sector collaboration.
• Ensure UN Representation: Collaborate with the PCP Programme Manager and UR, with support from the Regional Bureau for Africa, to ensure UNIDO’s active participation in the UN Country Team (UNCT) Zambia. This includes contributions to the UN Sustainable Development Cooperation Framework (UNSDCF) Results Groups and participation in Programme Management Team (PMT) meetings.
• Key Deliverables: Provide regular updates on partnership opportunities, maintain an overview of ongoing and pipeline projects, and continuously update the PCP partner-mapping tool to optimize engagement and resource allocation.
• Support Resource Mobilization
• Assist the PCP Programme Manager and UR in coordinating meetings, roundtables, and events aimed at mobilizing national and international financial resources for the successful implementation of the PCP.
• Key Deliverables: Mobilize and secure national and international financial resources for the PCP. Organize and execute the PCP Zambia Donor Round Table, engaging stakeholders to ensure strong financial backing. Maintain documentation of commitments made during engagements to support sustainable funding and long-term partnerships.
• Provide Secretariat Support to the National Coordination Body (NCB)
• Deliver secretariat assistance to the NCB, ensuring alignment with the Terms of Reference (ToR) agreed upon with national counterparts, thereby enhancing efficiency.
• Conduct a Midterm Review of the PCP: Perform a thorough review to assess alignment with Zambia’s Eighth National Development Plan (NDP8), evaluating progress and identifying areas for adjustment.
• Review and Refine NCB Structure: Assess the NCB’s current structure, gather feedback from key stakeholders, and facilitate the endorsement of annual PCP work plans.
• Key Deliverables: Follow up on the revised NCB structure for strategic alignment, organize the first NCB meeting under the updated structure, maintain detailed records on PCP operations, ensure timely follow-up on NCB decisions, and provide comprehensive reports to UNIDO on NCB activities.
• Foster Communication and Coordination: Maintain continuous communication with NCB members and partner organizations, ensuring stakeholders are informed of PCP developments and promoting collaboration to avoid duplication of efforts.
• Assist in Project Development
• Provide comprehensive support during key phases of project and sub-programme development, including identification, formulation, resource mobilization, and implementation.
• Project Identification and Formulation: Assist in identifying potential projects aligning with PCP objectives and national priorities, ensuring they are well-structured with clear goals and resource needs.
• Resource Mobilization: Actively contribute to mobilizing necessary financial, technical, and in-kind resources, engaging national and international partners and donors.
• Project Implementation: Support the execution of PCP projects, ensuring adherence to timelines and expected outcomes, including monitoring and reporting to maximize impact.
• Follow Up on IDDA III Activities: Manage feedback on IDDA III Champion invitations and ensure timely communication with stakeholders to promote engagement in IDDA III initiatives.
• Coordinate and Arrange Events: Organize and manage PCP-related events, ensuring smooth execution through effective logistics planning and materials preparation.
• Support the Implementation of the PCP Communication Strategy
• Assist in rolling out a comprehensive communication strategy for the PCP at the country level, ensuring alignment with UNIDO’s communication goals.
• Promote Individual Initiatives: Ensure effective promotion of all Technical Cooperation (TC) projects within the PCP framework, highlighting their contributions to national development goals.
• Contribute to Communication Materials: Create and enhance communication materials such as articles, reports, and success stories for UNIDO’s website and social media, ensuring clarity and alignment with key messages.
• Liaise with Local Media and UNIC Zambia: Maintain regular communication with local media and the United Nations Information Centre (UNIC) in Zambia to disseminate information on PCP activities and enhance UNIDO’s visibility.
• Prepare and Deliver Periodic Reports
• Compile and present detailed reports to the PCP Programme Manager, UNIDO Representative, and the National Coordination Body (NCB).
• Facilitate the Finalization of the PCP Zambia 2024 Annual Report: Contribute to data gathering, synthesizing stakeholder information, and ensuring accurate reflection of achievements, challenges, and lessons learned.
• Ensure Stakeholder Feedback: Incorporate feedback from stakeholders to refine the report and facilitate discussions on key messages to communicate the PCP’s impact effectively.
• Disseminate the Final Report: Coordinate the distribution of the PCP Zambia 2024 Annual Report to relevant stakeholders to promote transparency and continued engagement.
• Prepare and Submit a Timely End-of-Assignment Report
• Compile and deliver a comprehensive end-of-assignment report detailing key activities, achievements, challenges, and lessons learned.
• Outline Objectives and Outcomes: Clearly delineate original objectives and assess their fulfillment, supporting evaluations with quantitative and qualitative data.
• Highlight Key Activities and Achievements: Detail significant activities undertaken, emphasizing contributions to PCP objectives and overall impact, including innovative approaches or best practices.
• Identify Challenges and Lessons Learned: Reflect on encountered challenges and employed strategies, documenting lessons learned for future projects.
• Provide Recommendations for Future Action: Offer actionable recommendations based on findings to address improvements, sustain successes, and consider future assignments.
• Ensure Timely Submission: Adhere to report submission timelines, completing necessary reviews and approvals while collaborating with stakeholders for prompt finalization.

MINIMUM ORGANIZATIONAL REQUIREMENTS
• Education: Advanced university (master’s or equivalent) degree in economics, engineering, international relations or a similar degree is required

Technical and Functional Experience:
• At least 5 years of experience in project and programme coordination is required.Experience in regional economic integration and interacting with the COMESA Secretariat and EU Delegation is desirable.Familiarity with the private sector actors, relevant local capacities and existing initiatives in the country is required.Knowledge of UNIDO’s mandate, activities, and familiarity with financial and administrative policies, rules and procedures of the United Nations system is desirable.
• Languages: Fluency in written and spoken English is required. Knowledge of French is an asset.
• Understanding of the work and activities of developmental and international financial institutions, their mandates and their role in engaging the private sector actors in development initiatives is required.
• Knowledge of relevant national and international institutional, legal and procedural frameworks, particular the donor community (including their priorities and requirements) as well as the development actors and the UN system in Zambia is required.
• Familiarity with the local socio-economic situation and conditions, as well as trade competitiveness and market access related issues, particularly in the region where the UNIDO Programme has operational activities is required.

Languages:
• Fluency in written and spoken English is required. Knowledge of French is an asset.

Deliverables:
• Produced reports and strategic documents must be comprehensive, concise, of high quality and well written. The reports should be submitted in English, in electronic format, via e- mail. Neither entire reports/documents, nor parts of the reports/documents may be disseminated or presented in any form without the explicit permission of the UNIDO management.


Education Requirement: No Requirements

Job Experience: No Requirements

Work Hours: 8


Experience in Months:

Level of Education:

Job application procedure

Interested and qualified, Click here to apply.


All Jobs

QUICK ALERT SUBSCRIPTION

Job Info
Job Category: Management jobs in Zambia
Job Type: Full-time
Deadline of this Job: 19 November 2024
Duty Station: Lusaka
Posted: 30-10-2024
No of Jobs: 1
Start Publishing: 30-10-2024
Stop Publishing (Put date of 2030): 30-10-2068
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
59.913MBMemory Usage494msRequest 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" => "949a534701223161b74479033a1559aa" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 3 "timer" => array:3 [ "start" => 1744662842 "last" => 1744662847...
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) (25.14ms)
  • afterInitialise (11.13MB) (91.09ms)
  • afterRoute (5.06MB) (26.62ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (159μs)
  • afterRenderComponent com_jsjobs (3.15MB) (29.51ms)
  • Before Access::preloadComponents (all components) (247.64KB) (6.73ms)
  • After Access::preloadComponents (all components) (132.72KB) (783μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (17μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (325μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.51MB) (63.35ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (85.99ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (8μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (379μs)
  • afterDispatch (87.48KB) (131μs)
  • afterRender (13.8MB) (163ms)
  • 1 x afterRender (13.8MB) (33.05%)
    163.44ms
    1 x afterInitialise (11.13MB) (18.42%)
    91.09ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (17.39%)
    85.99ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.51MB) (12.81%)
    63.35ms
    1 x afterRenderComponent com_jsjobs (3.15MB) (5.97%)
    29.51ms
    1 x afterRoute (5.06MB) (5.38%)
    26.62ms
    1 x afterLoad (4.12MB) (5.08%)
    25.14ms
    1 x Before Access::preloadComponents (all components) (247.64KB) (1.36%)
    6.73ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.16%)
    783μs
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.08%)
    379μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.07%)
    325μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.03%)
    159μs
    1 x afterDispatch (87.48KB) (0.03%)
    131μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    17μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    8μs
90 statements were executed, 23 of which were duplicates, 67 unique20.83ms256.23KB
  • SELECT @@SESSION.sql_mode;59μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?146μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 197μ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_id1.13ms992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`74μ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` = :guest114μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'92μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`67μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'163μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config188μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'122μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'73μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'62μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'61μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-PCP-National-Coordinator-job-at-United-Nations-Industrial-Development-Organization-UNIDO-67683%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-PCP-National-Coordinator-job-at-United-Nations-Industrial-Development-Organization-UNIDO-67683%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-PCP-National-Coordinator-job-at-United-Nations-Industrial-Development-Organization-UNIDO-67683%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC214μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-PCP-National-Coordinator-job-at-United-Nations-Industrial-Development-Organization-UNIDO-67683%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-PCP-National-Coordinator-job-at-United-Nations-Industrial-Development-Organization-UNIDO-67683%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-PCP-National-Coordinator-job-at-United-Nations-Industrial-Development-Organization-UNIDO-67683%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC261μ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.id233μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'354μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'276μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'241μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'303μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'213μ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'64μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'315μ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 = 67683753μs68.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'277μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 67683493μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'285μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering363μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'254μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'206μ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'227μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'134μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'56μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'50μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'214μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'214μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'99μ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 = 2182μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2168μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'747μ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'712μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2113μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2125μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2134μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'232μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'243μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'131μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering145μ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)421μ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` = 22138μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24133μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 28121μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38114μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 39174μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40158μ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` = 0131μs1.19KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft406μs1.8KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'distribution-channels' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft197μ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.lft370μ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-PCP-National-Coordinator-job-at-United-Nations-Industrial-Development-Organization-UNIDO-67683' AND `published` = 1136μs9.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-PCP-National-Coordinator-job-at-United-Nations-Industrial-Development-Organization-UNIDO-67683'152μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration368μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'185μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field179μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'80μ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` = 1132μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'180μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`267μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'124μ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 desc162μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`374μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid101μ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` = :muserid182μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-PCP-National-Coordinator-job-at-United-Nations-Industrial-Development-Organization-UNIDO-67683'83μ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"476μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.08ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin127μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin86μ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`99μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'97μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'204μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 8105121μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?88μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.32ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy