Accounting/ Finance jobs at International Rescue Committee and Other companies in Kenya

 
Deadline of this Job: 11 January 2023

The Cash TA will spend at least 80% of their time delivering technical assistance in-person and remotely to program colleagues focused on programming, CVA program model development across sectors as well as general economic program design, implementation and learning support. This is a primarily programs-focused position with the central responsibility concentrated on program quality. It is expected that approximately 40% of the total time will be deployed to country programs under the TAs area of responsibility, to support program quality in person. This may also mean deployments in emergency response, where crisis occur in the TAs focal or backstop country programs and may be on short notice. The remaining 0-20% is spent on influence, advocacy, research, and internal strategic design related to cash program quality and operations, at the discretion of their supervisors. The Technical Advisors’ specific responsibilities are as follows:
• Ensure program quality:

Ensure That These Programs Are
Participate in the design, development, and implementation of high-quality ERD programs, including operational aspects of CVA activities within other sectors (health, education, protection, and governance).
• Aligned with organizational strategies, which includes supporting staff with contextualizing outcomes and theories of change, and selecting interventions based on the best available evidence, the local context analysis and the country program’s Strategic Action Plan.
• Responsive to clients’ needs and preferences, as well as incorporating a strong component of promoting equality, inclusion, and local partnership.
• Support assessments on basic needs, food security, livelihoods, labor markets, CVA feasibility, including financial services providers availability.
• Provide inputs on the design of theories of change, monitoring plans and log frames, including indicator selection.
• Aligned with IRC’s cash ambitions, including the use of digital payments, strong operational support systems, and alignment of CVA programs with social protection systems.
• Engaging in business development to add to high quality concept notes and proposals by:
• Review technical quality of ERD project proposals and other sectors proposals with CVA and/or livelihoods components.
• Input into go / no go decisions on proposals and on budgets required for project delivery.
• When necessary, write technical narratives of proposals and provide support on monitoring and evaluation aspects of ERD projects.
• Engage with donors, participate to donors’ meetings, and do outreach in support of country programs.
• Ensure sound analysis of context, capacity, and opportunities to input into country Strategy Action Plans (SAPs).
• Building resources for technical sharing to encourage cross-learning and innovation:
• Share cross-context learning globally and across the region, including on IRC organizational outcomes, theories of change, evidence base for interventions and standard indicators.
• Develop, review, and share program-specific tools, resources (internal and external); and work with Technical Unit specialists, coordinators, and other colleagues to contextualize and adapt global and country-specific materials or to assist with periodic review.
• Keep up to date with contextual analyses, crisis data, and other sector and country trends related to CVA within the assigned country portfolio.
• Support or lead cash strategic projects to improve IRC global cash programming implementation, including operations:
• Work closely with other cash team members on relevant strategic projects centered around improving the IRC’s ability to scale and implement high quality CVA programming.
• Cultivate relationships with the supply chain and finance departments in country program portfolio, to inform operational aspects of CVA such as contracting new financial service providers and troubleshooting procurement or payment issues.
• Support the rollout of IRC’s Global Payment Toolbox and pre-positioned data management platforms.
• Participate in ongoing training courses and share knowledge and skill sets within the unit.

Key Working Relationships
• Position Reports to: Deputy Director – Cash & Markets (located in London, UK)
• Position directly supervises: N/A

Other Internal And/or External Contacts
• Internal: Close, regular relationships with regional and country program coordinators, managers, and teams; as well as with colleagues in the ERD Technical Unit. Regular communication with education, violence prevention and response, health, governance, research, evaluation and learning, internal cash working group, and gender equality technical unit teams. Interacts with IRC internal departments, including business development, procurement, and finance, external relations, and advocacy departments.

Other Vacancies
Deadline of this Job: 16 January 2023

Deadline of this Job: 11 January 2023

Deadline of this Job: 06 January 2023
60.377MBMemory Usage448msRequest 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 [ "7f83efdecf3f65efa9b183f43b703ad3" => "a80729349dfe5c808f76a5d86ebe04b5" ]
$_SERVER
array:64 [ "USER" => "greatkenyanjobs" "HOME" => "/home/greatkenyanjobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1744278388 "last" => 1744278388...
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) (27.96ms)
  • afterInitialise (11.14MB) (90.9ms)
  • afterRoute (4.63MB) (34.87ms)
  • beforeRenderComponent com_content (28.51KB) (330μs)
  • Before Access::preloadComponents (all components) (307.4KB) (3.86ms)
  • After Access::preloadComponents (all components) (134.35KB) (1.07ms)
  • Before Access::preloadPermissions (com_content) (4.26KB) (18μs)
  • After Access::preloadPermissions (com_content) (1.79MB) (5.96ms)
  • Before Access::getAssetRules (id:3738 name:com_content.article.2397) (130.8KB) (129μs)
  • After Access::getAssetRules (id:3738 name:com_content.article.2397) (26.84KB) (390μs)
  • afterRenderComponent com_content (2.31MB) (28.7ms)
  • Before Access::getAssetRules (id:1 name:root.1) (1.06MB) (10.34ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.95KB) (32μs)
  • afterDispatch (640.83KB) (9.55ms)
  • afterRender (29.95MB) (234ms)
  • 1 x afterRender (29.95MB) (52.14%)
    233.68ms
    1 x afterInitialise (11.14MB) (20.28%)
    90.90ms
    1 x afterRoute (4.63MB) (7.78%)
    34.87ms
    1 x afterRenderComponent com_content (2.31MB) (6.4%)
    28.70ms
    1 x afterLoad (4.12MB) (6.24%)
    27.96ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (1.06MB) (2.31%)
    10.34ms
    1 x afterDispatch (640.83KB) (2.13%)
    9.55ms
    1 x After Access::preloadPermissions (com_content) (1.79MB) (1.33%)
    5.96ms
    1 x Before Access::preloadComponents (all components) (307.4KB) (0.86%)
    3.86ms
    1 x After Access::preloadComponents (all components) (134.35KB) (0.24%)
    1.07ms
    1 x After Access::getAssetRules (id:3738 name:com_content.article.2397) (26.84KB) (0.09%)
    390μs
    1 x beforeRenderComponent com_content (28.51KB) (0.07%)
    330μs
    1 x Before Access::getAssetRules (id:3738 name:com_content.article.2397) (130.8KB) (0.03%)
    129μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.95KB) (0.01%)
    32μs
    1 x Before Access::preloadPermissions (com_content) (4.26KB) (0%)
    18μs
62 statements were executed, 9 of which were duplicates, 53 unique17.71ms456.79KB
  • SELECT @@SESSION.sql_mode;56μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?196μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 1143μ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_id296μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`142μ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` = :guest162μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'106μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`90μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'187μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config152μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'105μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'61μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'56μ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 `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`330μs21.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F2397-accounting-finance-jobs-at-international-rescue-committee-and-other-companies-in-kenya%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Frelated-jobs%2F2397-accounting-finance-jobs-at-international-rescue-committee-and-other-companies-in-kenya%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F2397-accounting-finance-jobs-at-international-rescue-committee-and-other-companies-in-kenya%2F')=1) OR `list_var` LIKE '%com_content%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC309μs4.3KB/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.id201μs3.7KB/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,:preparedArray50)676μs8.25KBParams/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` = 02.73ms173.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `icop0_content`450μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `icop0_content` SET `hits` = (`hits` + 1) WHERE `id` = '2397'324μ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)334μ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`343μ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)545μs5.27KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `alias` FROM `icop0_content` WHERE `id` = :id126μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `icop0_content` WHERE `id` = :id111μ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`392μs21.2KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'275μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'307μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'245μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering210μs4.27KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0109μs904B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22113μs12.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24211μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 36164μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 37161μ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` = 0118μ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.lft529μ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/2397-accounting-finance-jobs-at-international-rescue-committee-and-other-companies-in-kenya' AND `published` = 1186μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/related-jobs/2397-accounting-finance-jobs-at-international-rescue-committee-and-other-companies-in-kenya'90μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration412μs24.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'144μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field124μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'99μ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` = 1142μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'195μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`319μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'100μ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)335μ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`538μ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 ASC725μ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 desc171μ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 desc204μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/related-jobs/2397-accounting-finance-jobs-at-international-rescue-committee-and-other-companies-in-kenya'130μ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` = 180μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"468μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.07ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin144μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin104μ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`155μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?103μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?543μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy