National Urban Policy Consultant job at UN-Habitat
1146 Days Ago
Linkedid Twitter Share on facebook

Vacancy title:
National Urban Policy Consultant

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

Jobs at:

UN-Habitat

Deadline of this Job:
15 April 2022  

Duty Station:
Within Kenya , Nairobi , East Africa

Summary
Date Posted: Thursday, April 07, 2022 , Base Salary: Not Disclosed

Similar Jobs in Kenya
Learn more about UN-Habitat
UN-Habitat jobs in Kenya

JOB DETAILS:
National Urban Policy Consultant
Duties and Responsibilities

Context and organizational framework
The United Nations Human Settlements Programme, UN-Habitat, is the agency for human settlements. It is mandated by the United Nations General Assembly to promote socially and environmentally sustainable cities, with the aim of providing adequate housing for all. UN-Habitat is the lead agency within the United Nations for the implementation of the New Urban Agenda. UN-Habitat supports Member States and development partners to transform cities into safer, more resilient and healthier places with better opportunities. She works with organizations at all levels, including all spheres of government, civil society and the private sector. The incumbent will be based in Conakry (Guinea).
The UN-Habitat Regional Office for Africa (ROAf) is working with the government of Guinea Conakry for the implementation of the SANITA program (Urban Development and Sanitation Program in Guinea). Within the framework of the National Indicative Program (NIP) of the 11th European Development Fund (EDF), urban sanitation is identified as a priority. The decision to improve the health situation encourages an integrated territorial approach while promoting inclusive and sustainable urban and territorial policies.
There was a first project implementing this sector, the Urban Development and Sanitation Program in Guinea (SANITA), signed in December 2017 for an amount of 42 million euros. The general objective of SANITA is to improve the sanitary environment and the quality of life of urban populations, particularly in Conakry and Kindia. This time, in this action entitled "Urban Development and Sanitation Program in Guinea (SANITA) - Sustainable Cities", it is a question of strengthening urban governance at the local and national level under the responsibility of UN-Habitat. This main objective can be broken down into two specific secondary objectives, which are:
• Improving in a participatory manner the legal, regulatory and institutional framework for urban development at the national level and in the city of Conakry in particular;
• Strengthen the institutional capacities and skills of stakeholders in the development and implementation of policy documents and urban and territorial planning through a participatory approach, taking into account the gender issue.
It is in this context that Guinea needs to adopt a new National Urban Policy (NUP). Indeed, since 1984, Guinea has not adopted a real urban policy to promote a coordinated and more coherent socio-spatial approach in public and citizen action in the urban space. Urban planning was done without a real common vision of what the different Guinean cities should be. Attempts that have been made so far have not always succeeded.
In fact, the approaches of the various Governments have more or less made it possible to lay the foundations for controlling the urbanization process without creating suitable conditions for structural transformation. The current appearance of cities in Guinea stems from a permanent interaction between stakeholders with very often divergent interests. Strong decision-makers have often influenced the dynamics of urbanization by developing tools and infrastructures that have made it possible to structure the urban fabric. This type of orientation, which is not backed by a sustainable institutional system, is very often ephemeral, thus giving way to the informal occupation of protected sites and the multiplication of urban disorders.
At the national level, the diagnosis produced by the Regional Office for Africa of UN-Habitat (ROAf) within the framework of this project confirms the macrocephaly of Conakry which continues and poses a risk for a balanced growth. This diagnosis also reveals that the aspects of urban planning that were considered in the National Housing Policy developed in 2012 remain relevant given the lack of a harmonious, consensual and participatory vision of this policy. It must be said that this document, far from being a real urban policy, was essentially only a letter of orientation for the activities of the Ministry of Urbanism, of Housing and Regional Planning (MUHAT).
Today, it is clear that the global and national perspectives, as presented in the diagnosis produced by ROAf, could facilitate the development and implementation of a NUP and its program of actions. This is why the Government of Guinea is committed to taking measures to augur a normalization of the situation and this through a reprogramming of the objectives and expected results of the SANITA Program. According to this diagnosis produced by ROAf, there are two central problems in Guinea: scarce and expensive decent housing and (ii) unharmonious and mortgaged urban development. This diagnosis also outlines a number of guidelines that should be considered if we intend to provide Guinea with a NUP, considered as "a coherent set of decisions based on a deliberate process led by the government". Its ambition should be to coordinate and rally the various actors around a common vision and objective oriented towards the promotion of a more transformative, more productive, more inclusive and more resilient urban development strategy in the long term. The association, participation and inclusion of the private sector, civil society and target populations in the design, implementation and financing of the various strategies and actions deserve particular attention.
In a non-exhaustive manner, eighteen (18) areas of strategic orientation are recommended in the diagnosis for the development of Guinea's NUP in order to address the situation of the sector. The main ones are: a) Strategic orientations related to the reorganization of the sector;
• Strategic directions related to land production and management;
• Strategic orientations specific to the cadastre;
• Strategic directions related to real estate production;
• Strategic directions related to building materials;
• Strategic directions related to urbanization;
• Strategic orientations related to the debate on the city;
• Strategic directions related to urban governance;
• Strategic orientations related to the financing of the sector;
• Strategic orientations related to the situation of women
• Strategic orientations related to urban-rural relations;
• Specific strategic directions related to COVID-19;
• Strategic directions related to capacity building;
• Methodological guidelines related to new global challenges.
It is in this context and, on the basis of all the above, that after the National Urban Forum of December 2019 which focused on the governance of institutions, sustainable urbanization and the opportunities for sustainable economic growth on the horizon 2040, and the series of forums organized in the eight (8) administrative regions of the country on the one hand, and the production of the diagnosis of urban development, the implementation of public policies and the challenges of sustainable urbanization on the n the other hand, UN-Habitat wishes to recruit a national consultant or a national consulting firm, for the preparation of the proposals for the national urban policy of Guinea, as well as its preliminary version.
Objective
The consultant's mission is to support the Government of Guinea and its partners in the formulation and implementation of mechanisms for the application of a national urban policy integrating the aspects relevant to the reorganization of the urban sector, to land production and management, cadastre, real estate production, building materials, urban and regional mobility, city-countryside relations, urban governance, capacity building, the debate on urbanization, legal instruments, financing, improvement of precarious housing, multi-stakeholder coordination, the situation of women, new global challenges (Agenda 2030 and New Agenda for Cities), COVID-19 and participation and sustainable urban development.
In general, the national consultant with the team that he will constitute will have to produce a report on an urban prospective and the options of political measures. It will produce Guinea's national urban policy document and its action plan.
Specifically, this consultation will have three deliverables: (1) a report on urban forecasts to guide options for future policy, (2) a national urban policy document (NUP) coupled with its implementation action plan ( draft version) and (3) the revised version of Guinea's NIP and its implementation action plan.
III. Methodology
For the mission, the consultant will use the diagnosis of urban development of the implementation of public policies and the challenges of sustainable urbanization in Guinea by UN-Habitat. He/She may call on other sources of documentation that he/she deems necessary. The various reports from the National Urban Forum of Guinea and forums across the country will be made available to him.
During this consultancy, he/she may continue to consult and/or seek certain insights from the stakeholders in the development of the NUP. He could do interviews. Desk research will be required to refine the quality of the reports. He/she will be called upon to analyze the data and especially to present reports to various national/local workshops. Thereafter, he/she will carry out analyzes and draft the various reports, in order to meet the requirements of this mission in its three specific objectives. With regard to the three objectives of the mandate of the national consultant, it will be necessary to: 1. Propose national urban policy options based on the analyzes of the urban forecasts and priority areas to guide the NUP identified during the National Urban Forum (NUF)
This mission will consist in analyzing the content and criticism of the priority themes (challenges) selected and the solutions proposed in order to identify at least three options for change including the advantages and disadvantages.
Urban forecasts will focus, among other things, on the problem of decent and available housing in Guinea, urban development, organizational strengthening and multi-sectoral coordination with a view to effective co-production of the city, good multi-stakeholder governance, rural and urban land, land use planning, the system of cities - transformation of the urban framework into an integrated and viable national economic space, industrialization and urban growth, major works and the rise of urban interaction -rural in different ecological areas.
The second part of this mission will also consist of:
• Analyze the regulatory and institutional planning tools and the implementation mechanisms to identify the political principles to be retained;
• Examine the geographic information systems (GIS) resulting from urban and territorial planning documents, in this case the National Housing Policy, the SNAT, the regional development and urban planning plans of eleven cities (regional capitals and secondary cities) and zoning plans in order to determine the models of construction of the systems of co-production and management of the urban framework,
• State, with local experts, the needs for capacity building and support advice to ensure the adoption and implementation of the NUP at the national, regional and local levels by the decentralized and decentralized services in partnership with the private sector and civil society actors.
• Production of the preliminary version of the national urban policy (NUP) of Guinea
• The preliminary report resulting from this reflection will be submitted to the network for opinion, then the project coordination team will consider the views of the reviewers with the aim of producing a second version of the report on policy options.
• During this phase, the consultant will have to meet with senior decision-makers from the private and public sectors. This will be under the leadership of the CTP and the DATU. At the end of this step, the preliminary version of the NUP should be produced. This will be the working document for the development of the final and definitive version of Guinea's NUP, which will be accompanied by the action plan for its implementation and the budget necessary for this purpose. The consultant is asked to propose with the policy document a plan for communication, monitoring and above all an evaluation mechanism for Guinea's NUP to be implemented.
• The final version of Guinea's NUP document including the implementation action plan (cost, communication plan, monitoring mechanisms).
• The consultant will be called upon to consolidate the draft document on the basis of comments from the validation workshop. He/she should be an important player in this workshop.
• Overall the tasks and responsibilities of the consultant are: a) Development of urban forecasts and urban policy options
• On the basis of the diagnosis already prepared by UN-Habitat and the NUF report, the consultant will have to highlight the prospects for the resolution of the difficulties that have arisen. It should consider the issues and challenges to be met in the context of improving the country's urban fabric. The different options of the NUP will therefore be consolidated in a document;
• Draft National Urban Policy of Guinea including a short, medium and long term action plan for implementation
• Once the NUP has been formulated, the consultant will have to propose common measures/actions to be adopted at national and local level for its implementation. Its measures will be deepened together with stakeholders through high-level political dialogues in order to develop an action plan that is realistic, executable and equipped with consensus-based performance indicators.
• The final version of Guinea's NUP
• This is the provisional document consolidated at the end of the validation workshop which will be sent to the Government for adoption.
• Supervision
The Consultant will work under the direct supervision of the Chief, Policy, Legislation and Governance section (PLGS) of UN-Habitat.

Qualifications/special skills
Competencies

Professionalism. Shows pride in work and in achievements; is conscientious and efficient in meeting commitments, observing deadlines and achieving results; shows persistence when faced with difficult problems or challenges and remains calm in stressful situations.
Communication. Speaks and writes clearly and effectively; listens to others, correctly interprets messages from others and responds appropriately; asks questions to clarify, and exhibits interest in having two-way communication; demonstrates openness in sharing information and keeping people informed, Excellent drafting ability and communications skills, both oral and written; proven ability to communicate complex concepts orally; ability to prepare written reports that are clear, concise and meaningful. Good command of French and good knowledge of English. English and French are the working languages of the United Nations. For the consultancy, excellent proficiency in French and English, both verbal and written, is required.
Teamwork. Works collaboratively with colleagues to achieve organizational goals; is willing to learn from others; places team agenda before personal agenda; supports and acts in accordance with final group decision, even when such decisions may not entirely reflect own position; shares credit for team accomplishments and accepts joint responsibility for team shortcomings.
Planning and organizing. Able to develop clear goals that are consistent with agreed strategies; identifies priority activities and assignments; identifies priority activities and assignments; allocates appropriate amount of time and resources for contingencies in planning; monitors and adjusts plans and actions as necessary; uses time efficiently.

Skills: Candidate Skills: The consultant must :
• Be of Guinean nationality preferably;
• Have an excellent command of institutional reform and intersectoral coordination;
• Have the ability to organize and facilitate participatory meetings with the ultimate goal of working towards building consensus for policy discourse;
• Have the ability to work independently with a high degree of responsibility, flexibly and sometimes under pressure;
• Have good communication skills;
• Be able to write technical and project documents, in particular strategic documents;
• Have good judgment and excellent analytical skills and above all, the ability to plan and organize workshops.

Academic Qualifications:
• University degree (at least Master preferred) in a discipline relevant to the mission development and analysis of public policies, urban planning, urban policy, urban geography, architecture, engineering, urban governance, policy development and analysis, social science, related field or any other equivalent diploma. A first level degree with an additional two years of qualifying experience may be accepted in lieu of the advanced degree.

Experience:
• Minimum of 7 years of professional experience in the field of urban planning, in particular on the development of public policies, on planning, urban management, on the economy of cities, regulations and legislation, services of base, urban governance, etc. is required;
• Have proven experience in the development of urban policies and institutional capacity building would be an asset;
• Have relevant work experience in developing countries and recognized work done previously for the United Nations is an advantage;
• Have relevant experience in public policy, decentralization, formulation of urban policies and have in-depth knowledge that can promote the combination of population growth and economic, social and environmental development is desirable.
Language: Language: English and French are the working languages of the United Nations. For the post advertised, fluency in spoken and written French is required. Knowledge of English will be an advantage.
Deadline:15 April 2022

Work Hours: 8


Experience in Months: 60

Level of Education:
Bachelor Degree

Job application procedure
Click here to Apply Now

All Jobs

QUICK ALERT SUBSCRIPTION

Job Info
Job Category: Consultant/ Contractual jobs in Kenya
Job Type: Full-time
Deadline of this Job: 15 April 2022
Duty Station: Nairobi
Posted: 08-04-2022
No of Jobs: 1
Start Publishing: 08-04-2022
Stop Publishing (Put date of 2030): 08-04-2065
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
58.75MBMemory Usage365msRequest 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:65 [ "USER" => "greatkenyanjobs" "HOME" => "/home/greatkenyanjobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1748435804 "last" => 1748435804...
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.greatkenyanjobs.com/how-to-app...
JSItemid
"190"
  • afterLoad (4.12MB) (20.14ms)
  • afterInitialise (11.17MB) (62.96ms)
  • afterRoute (5.06MB) (27.29ms)
  • beforeRenderComponent com_jsjobs (9.7KB) (169μs)
  • afterRenderComponent com_jsjobs (3.18MB) (27.99ms)
  • Before Access::preloadComponents (all components) (247.64KB) (4.79ms)
  • After Access::preloadComponents (all components) (130.74KB) (796μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.91KB) (14μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (236μs)
  • afterDispatch (494.2KB) (6.34ms)
  • afterRender (32.22MB) (213ms)
  • 1 x afterRender (32.22MB) (58.47%)
    213.33ms
    1 x afterInitialise (11.17MB) (17.26%)
    62.96ms
    1 x afterRenderComponent com_jsjobs (3.18MB) (7.67%)
    27.99ms
    1 x afterRoute (5.06MB) (7.48%)
    27.29ms
    1 x afterLoad (4.12MB) (5.52%)
    20.14ms
    1 x afterDispatch (494.2KB) (1.74%)
    6.34ms
    1 x Before Access::preloadComponents (all components) (247.64KB) (1.31%)
    4.79ms
    1 x After Access::preloadComponents (all components) (130.74KB) (0.22%)
    796μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.06%)
    236μs
    1 x beforeRenderComponent com_jsjobs (9.7KB) (0.05%)
    169μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.91KB) (0%)
    14μs
87 statements were executed, 23 of which were duplicates, 64 unique15.31ms278.13KB
  • SELECT @@SESSION.sql_mode;86μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?110μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 1106μ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)204μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`148μ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` = :guest106μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'131μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`121μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'130μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config100μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'75μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'92μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'45μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'56μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-National-Urban-Policy-Consultant-job-at-UN-Habitat-56136%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-National-Urban-Policy-Consultant-job-at-UN-Habitat-56136%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-National-Urban-Policy-Consultant-job-at-UN-Habitat-56136%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC234μs4.23KB/plugins/system/jlexblock/jlexblock.php:147Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-National-Urban-Policy-Consultant-job-at-UN-Habitat-56136%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-National-Urban-Policy-Consultant-job-at-UN-Habitat-56136%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-National-Urban-Policy-Consultant-job-at-UN-Habitat-56136%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC279μs4.25KB/plugins/system/jlexblock/jlexblock.php:147Copy
  • 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.id143μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'347μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'224μ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'304μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'226μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'85μ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'211μ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 = 56136517μs76.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'261μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 56136243μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'192μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering282μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'240μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'122μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering227μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'149μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'127μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'63μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'65μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'229μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'204μ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'60μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2158μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2150μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'329μ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'295μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2139μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2160μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2146μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'160μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'174μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'155μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering164μ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)451μs8.12KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 093μs888B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2288μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24100μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 3797μ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` = 094μ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.lft296μ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.lft215μ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.lft284μs2.3KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM icop0_jmap_metainfo WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/job-detail/job-National-Urban-Policy-Consultant-job-at-UN-Habitat-56136' AND `published` = 1185μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/job-detail/job-National-Urban-Policy-Consultant-job-at-UN-Habitat-56136'64μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration269μs24.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'123μs10.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field145μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'91μ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` = 1138μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'177μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`215μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'59μ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 desc177μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`266μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid126μ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` = :muserid121μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/job-detail/job-National-Urban-Policy-Consultant-job-at-UN-Habitat-56136'102μ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"293μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES844μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin138μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin69μ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`95μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'139μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'200μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 637164μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?164μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?361μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy