Communications Public Relations Jobs at Judicial Service Commission, Tetra Tech, Windle Trust Kenya, and United Nations Environment Programme (UNEP)


Deadline of this Job: 20 December 2022
JOB DETAILS:

The incumbent will perform the following functions:
Provides Kiswahili language website services such as:
• Updates content on UNEP Kiswahili website and all UNEP campaign sites;
• Ensures relevant content is translated from English to Kiswahili and posted in a timely manner;
• Proofreads all content posted on the Kiswahili language website.
• Coordinates review of existing Kiswahili -language sections of UNEP website to determine need for revisions.

Provides Kiswahili language social media services such as:
• Develops social media strategy and execution plans for Kiswahili-speaking audiences;
• Coordinates creation of Kiswahili-language digital boards for campaigns;
• Translates content from English to Kiswahili for posting on social media channels;
• Maintains UNEP Kiswahili language social media channels;
• Posts relevant and timely content on social media channels;
• Engages with Kiswahili -speaking audience on social media channels;
• Translates different types of content such as press releases, infographics, select publication, stories, campaign related content, etc from English to Kiswahili and makes these available on various channels;
• Promotes UNEP's work and messages to Kiswahili-language stakeholders via support to communications and outreach activities;
• Reviews statistics and analytics and adjusts/adapts content strategy to maximize reach;
• Participates in other Communication Division activities (training, meetings, workshops);

Qualifications/special skills
• Bachelor's degree in Journalism, Communication, linguistic studies, translation or related field is required.
• A minimum of two years of progressively responsible experience in translating English/ Kiswahili.

Languages
• English and French are the working languages of the United Nations Secretariat. For this position fluency in English and Kiswahili is required.


Deadline of this Job: 22 December 2022
JOB DETAILS:

KNOWLEDGE, COMPETENCIES, EXPERIENCE AND QUALIFICATIONS
• Years of Experience: At least five years in a senior fundraising, marketing or communications role with evidence of having brought in multi-year donor partnerships, particularly in the humanitarian field
• Income Generation: Proven experience and a successful track record securing grants from trusts, foundations, key institutional funders, legacies among others.
• Strategies: Experience in designing, developing and delivering organization-wide fundraising strategies and tactical plans with a proven track record of managing fundraising targets and having reached or exceeded them
• Leadership & Capacity Building: Proven experience of building colleagues’ capacity on fundraising to respond to donor with tangible outcomes.
• Coordination: Demonstrated ability to work remotely, effectively and efficiently with teams in different countries.
• Marketing: A track record of leading, developing and delivering successful marketing and communication strategies for an organization, which grew organisation profile, reach and engagement
• IT: A good understanding and experience of working with databases, Microsoft Office, PowerPoint, websites and Knowledge /use of funder portals and software.
• Relationship Building: Proven experience of networking and building working partnerships with donors, NGOs and other stakeholders and representing your organization on external platforms.
• Proposal and Report Writing: Experience of producing high quality proposals and reports, delivering quantitative and qualitative information in both formal and informal styles. Understanding of Log frames and M&E frameworks.
• Budgeting: Experience of producing budgets and reports for funders; experience of negotiating budgets, value for money, etc.
• Monitoring: Experience of establishing systems for monitoring and evaluating communications and fundraising and measuring long term impact
• Education: Bachelor’s degree in Public Relations, Communications, Journalism, Marketing, business administration or related field required

Personal Attributes
• Demonstrable commitment to refugees and communities affected by conflict and marginalization
• Confident, honest and dependable
• Proactive, self-motivated and innovative, capable of working on their own and as part of a team.
• A commitment to WI’s mission and values, including the protection of children and survivors of human rights abuses.


Deadline of this Job: 22 December 2022  
JOB DETAILS:
JOB REFERENCE NUMBER: V/No. 40/2022
Key Duties and Responsibilities:

• Identifying and packaging Commission’s events for dissemination to the media and public;
• Manage corporate publications, articles and newsletters;
• Review the Corporate Communication strategy to align with emerging issues and trends;
• Draft speeches for commission functions;
• Manage media relations and press releases including talk shows;
• Initiate public forums for propagation and promotion of commission policies, programs and projects;
• Collect information on Commission programmes, activities, significant events and disseminate the same to media and public;
• Coordinate corporate branding including website management;
• Develop appropriate strategies to address possible negative publicity against the Commission;
• Providing clients and stakeholders with information about the commission’s activities through brochures, flyers and website updates including customer satisfactions surveys;
• Develop and nurture relations with diverse publics.

Job Requirements:
Academic and Professional Qualifications:
For appointment to this position, the applicant must have: -

• A Bachelors Degree in either Communications Studies, Mass Communications, Journalism, Public Relations, Media Studies, Corporate Communications, or any equivalent qualification from a university recognized in Kenya;
• A relevant Diploma from a recognised institution will be an added advantage;
• Be a member of a relevant professional body in good standing; and
• Must meet the requirements of Chapter six (6) of the Constitution.

Work Experience:
• Minimum of ten (10) years of relevant work experience
• At least three (3) years at Senior Management level;
• A Masters Degree in either Communications Studies, Mass Communications, Journalism, Public Relations, Media Studies, Corporate Communications, or any equivalent qualification from a university recognized in Kenya ( is an added advantage).


Deadline of this Job: 22 December 2022
JOB DETAILS:

Position Summary:
The Communications Specialist will participate in the full scope of strategic communication support tasks including the development and production of information products and publications, event coverage, field work, photography, social media management, strategy development, videography and writing with an emphasis on digital and social media platforms. This position will report to the Deputy Chief of Party and work full-time at MSI’s office in Nairobi.

Responsibilities:
• Maintain a clear understanding of the Mission’s bilateral and regional portfolio and structure, as well as Mission and Agency communications objectives.
• Develop a social media strategy that articulates the role of social media in achieving the mission’s communications strategy and outlines how platforms are managed for USAID.
• Assign to staff and follow up on content development, ensuring appropriate tone and relevance of messages to programmatic priorities, and managing partner-generated content.
• Coordinate closely with the client, MSI teams, and implementing partners (IPs).
• Develop, plan, and conduct social media campaigns on a quarterly basis
• Draft original social media messaging and toolkits with proposed text, corresponding links, and appropriate images on a daily basis.
• Develop and maintain a list of e-newsletters, websites, blogs, and other reputable sources of content for use by colleagues.
• Lead the automation and optimization of social media performance measurement and optimize content based on algorithms and insights, leveraging SEO, hashtags, acronyms, emojis, etc. to drive further visibility and engagement.
• Set KPIs for campaigns and develop monthly, quarterly, and annual analytics for all managed platforms.
• Work with the Data Scientist to develop an automated system of culling analytics into real-time dashboard.
• Develop and deliver general and advanced social media training for IPs and comms staff on advertising, content development, analytics, etc.
• Set up social media advertisements and buys within the budget and provide a return on investment for ad spend.
• Contribute to the professional presentation and execution of communications products and services and contribute to systems to track metrics/indicators.
• Produce compelling, relevant content that adheres to USAID branding and style guidelines.
• Interpret and tailor complex, technical content and make it understandable for different audiences.
• Participate in and contribute to presentations, strategy, and performance review meetings.
• Be a part of the editorial and creative process, bringing new and creative ideas to the table based on expertise and research.
• Conduct interviews, take photos, videos, and otherwise support field work.
• Work with other photographers and videographers to capture human interest stories.
• Review relevant reports, news articles, social media handles, and other online information in preparation for tasks or to provide feedback to client.

Qualifications:
• Bachelor’s degree in a relevant field is required.
• Social media or digital marketing certifications are preferred.
• Minimum five years of relevant professional experience in journalism or public relations, including demonstrated experience in digital technologies such as Meta Ads, Twitter Ads, Brandwatch or others is required.
• Knowledge of digital (websites, social networking, email and blogging), photography and videography to seamlessly apply to multiple scenarios is required.
• Experience working and traveling in Kenya and in-depth understanding of Kenyan culture, geography and development issues is required.
• Experience working with non-governmental organizations, donors and/or agency or mass media is preferred.
• Experience in building the capacity of others on how to develop content for social media is preferred.
• Experience with managing influencers and user-generated content is preferred.
• Strong written and verbal fluency in English and Kiswahili is required.
60.401MBMemory Usage301msRequest 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" => 1747858197 "last" => 1747858197...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
JSItemid
"190"
  • afterLoad (4.12MB) (19.7ms)
  • afterInitialise (11.17MB) (82.93ms)
  • afterRoute (4.63MB) (23.68ms)
  • beforeRenderComponent com_content (28.73KB) (195μs)
  • Before Access::preloadComponents (all components) (307.4KB) (2.82ms)
  • After Access::preloadComponents (all components) (132.42KB) (881μs)
  • Before Access::preloadPermissions (com_content) (4.23KB) (15μs)
  • After Access::preloadPermissions (com_content) (1.8MB) (3.67ms)
  • Before Access::getAssetRules (id:3362 name:com_content.article.2170) (130.8KB) (69μs)
  • After Access::getAssetRules (id:3362 name:com_content.article.2170) (90.84KB) (248μs)
  • afterRenderComponent com_content (2.34MB) (21.73ms)
  • Before Access::getAssetRules (id:1 name:root.1) (1MB) (6.27ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.95KB) (21μs)
  • afterDispatch (592.39KB) (5.66ms)
  • afterRender (29.98MB) (133ms)
  • 1 x afterRender (29.98MB) (44.14%)
    133.02ms
    1 x afterInitialise (11.17MB) (27.52%)
    82.93ms
    1 x afterRoute (4.63MB) (7.86%)
    23.68ms
    1 x afterRenderComponent com_content (2.34MB) (7.21%)
    21.73ms
    1 x afterLoad (4.12MB) (6.54%)
    19.70ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (1MB) (2.08%)
    6.27ms
    1 x afterDispatch (592.39KB) (1.88%)
    5.66ms
    1 x After Access::preloadPermissions (com_content) (1.8MB) (1.22%)
    3.67ms
    1 x Before Access::preloadComponents (all components) (307.4KB) (0.93%)
    2.82ms
    1 x After Access::preloadComponents (all components) (132.42KB) (0.29%)
    881μs
    1 x After Access::getAssetRules (id:3362 name:com_content.article.2170) (90.84KB) (0.08%)
    248μs
    1 x beforeRenderComponent com_content (28.73KB) (0.06%)
    195μs
    1 x Before Access::getAssetRules (id:3362 name:com_content.article.2170) (130.8KB) (0.02%)
    69μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.95KB) (0.01%)
    21μs
    1 x Before Access::preloadPermissions (com_content) (4.23KB) (0%)
    15μs
62 statements were executed, 9 of which were duplicates, 53 unique13.09ms458.88KB
  • SELECT @@SESSION.sql_mode;82μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?132μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 183μ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)328μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`109μ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` = :guest142μ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`88μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'174μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config73μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'64μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'72μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'44μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'41μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F2170-communications-public-relations-jobs-at-judicial-service-commission-tetra-tech-windle-trust-kenya-and-united-nations-environment-programme-unep%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Frelated-jobs%2F2170-communications-public-relations-jobs-at-judicial-service-commission-tetra-tech-windle-trust-kenya-and-united-nations-environment-programme-unep%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F2170-communications-public-relations-jobs-at-judicial-service-commission-tetra-tech-windle-trust-kenya-and-united-nations-environment-programme-unep%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC180μs4.23KB/plugins/system/jlexblock/jlexblock.php:147Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `icop0_categories` AS `s` INNER JOIN `icop0_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`297μs21.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F2170-communications-public-relations-jobs-at-judicial-service-commission-tetra-tech-windle-trust-kenya-and-united-nations-environment-programme-unep%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Frelated-jobs%2F2170-communications-public-relations-jobs-at-judicial-service-commission-tetra-tech-windle-trust-kenya-and-united-nations-environment-programme-unep%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F2170-communications-public-relations-jobs-at-judicial-service-commission-tetra-tech-windle-trust-kenya-and-united-nations-environment-programme-unep%2F')=1) OR `list_var` LIKE '%com_content%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC237μs6.8KB/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.id156μs1.2KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • 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)608μs8.12KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `icop0_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.96ms173.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `icop0_content`301μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `icop0_content` SET `hits` = (`hits` + 1) WHERE `id` = '2170'259μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `icop0_content` AS `a` INNER JOIN `icop0_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `icop0_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `icop0_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `icop0_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `icop0_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)260μs24.63KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `icop0_categories` AS `s` INNER JOIN `icop0_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`317μs21.2KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `icop0_contentitem_tag_map` AS `m` INNER JOIN `icop0_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3)564μs5.27KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `alias` FROM `icop0_content` WHERE `id` = :id148μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `icop0_content` WHERE `id` = :id75μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `icop0_categories` AS `s` INNER JOIN `icop0_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`322μs21.2KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'189μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'246μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'158μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering121μs4.27KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0134μs11.87KB/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2268μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24132μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 3771μ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` = 0116μ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.lft275μs1.8KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM icop0_jmap_metainfo WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/related-jobs/2170-communications-public-relations-jobs-at-judicial-service-commission-tetra-tech-windle-trust-kenya-and-united-nations-environment-programme-unep' AND `published` = 1175μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/related-jobs/2170-communications-public-relations-jobs-at-judicial-service-commission-tetra-tech-windle-trust-kenya-and-united-nations-environment-programme-unep'49μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration241μs24.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'113μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field105μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'67μ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` = 190μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'155μ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'133μs912B/libraries/src/Table/Table.php:755Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `icop0_content` AS `a` INNER JOIN `icop0_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `icop0_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `icop0_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `icop0_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `icop0_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)284μs24.63KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `icop0_categories` AS `s` INNER JOIN `icop0_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`244μs21.2KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM icop0_fields AS a LEFT JOIN `icop0_languages` AS l ON l.lang_code = a.language LEFT JOIN icop0_users AS uc ON uc.id=a.checked_out LEFT JOIN icop0_viewlevels AS ag ON ag.id = a.access LEFT JOIN icop0_users AS ua ON ua.id = a.created_user_id LEFT JOIN icop0_fields_groups AS g ON g.id = a.group_id LEFT JOIN `icop0_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7,:preparedArray8)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC514μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT a.* FROM icop0_gsd a WHERE a.state = 1 AND a.plugin = 'content' AND a.appview IN ('article','*') ORDER BY a.id desc165μs2.05KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT a.* FROM icop0_gsd a WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*') ORDER BY a.id desc129μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/related-jobs/2170-communications-public-relations-jobs-at-judicial-service-commission-tetra-tech-windle-trust-kenya-and-united-nations-environment-programme-unep'103μ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` = 153μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"201μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES690μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin65μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin106μ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`119μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?119μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?255μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy