Accounting finance Jobs at Whence Financial Services, Nathan Associates Inc, Airtel Zambia, Dr. Agarwal's Eye Hospital and other companies


Deadline of this Job: 02 September 2022
JOB DETAILS:
The following will be your key responsibilities.
• Scout, market, engage potential clients.
• Build own clientele.
• Perform initial appraisals and evaluation of loan applicants by thoroughly examining their applications.
• Assess creditworthiness through background checks and vetting loan applicants to establish
• eligibility to get credit facilities.
• Cultivate trustworthy referral networks with existing clients.
• Suggest alternate channels to sell Whence Services.
• Forge trust based relationships and enhance customer satisfaction.
• Work within established regulations and adhere to all legal requirements at all times.

• Full grade 12 Certificate with credits or above in both English and Mathematics.
• Tertiary education with a minimum of a certificate in any given field.
• A good grasp of Microsoft packages i.e. Microsoft Word and Microsoft Excel.
• Excellent communication and interpersonal skills.
• Ability to work under minimum supervision.
• Must have the mettle to meet tight deadlines and exhibit calmness and composure under pressure.
• Experience in any industry is an added advantage.
• Must be at least twenty (20) years or above.

Applicants Are Required To Write An Essay About Any One Of The Following;
• Away from academics, what have you personally or professionally achieved against the odds that makes you proud of yourself?
• Write about a time you personally intervened in a situation, either at group, family, institution or organizational level to avert making serious losses, damage or a major adverse outcome.
• Write about a moment you needed to show resilience of character to overcome a major huddle or achieve your objectives by sticking to your position and achieved the required results.
• Write about a transformational product, service or proposal you made at your workplace, or business that completely transformed your organisation.


Deadline of this Job: 02 September 2022.
JOB DETAILS:
Tasks:
Nathan is seeking a short-term Health Care Financing (HCF) Advisor to conduct the tasks described below. The HCF Advisor will work with staff from R4G and the MOH to model the impact of various financing options on revenue generation, health promotion and utilization. Specific tasks to be performed are as follows.
1. In addition to the identified revenue generation strategies (i.e. taxes on tobacco, alcohol, sugar-sweetened beverages, fuel levy, medical levy, and a motor vehicle accident fund), suggest other potential mechanisms for financing health care in Zambia.
2. Identify and acquire necessary data needed to conduct a robust forecast of potential revenue that can be expected (in the short, medium, and long term) if each of the specified financing options were to be introduced in Zambia.
3. Using an established forecasting methodology, perform a forecasting exercise detailing the steps and assumptions made to quantify the amount of tax revenue that would be generated from each financing option.
4. Describe the strengths and limitations of the various financing options and their implications for revenue generation and health promotion and utilization.
5. Design and deliver a short training on revenue forecasting methodologies and implementation to R4G and MOH staff.
6. Produce and submit a final report to R4G and a detailed research report not exceeding 30 pages (excluding appendices). The report should include a brief introduction, a clear description of the forecast methods used and detailed results.
7. Produce a PowerPoint presentation to present the main findings, conclusions and recommendations of the research report that can be used in a public discussion.
All tasks will be conducted remotely unless otherwise agreed. This activity is projected to start in mid- to late August 2022 and run for an initial period of up to 21 work days. The timing and payment of the deliverables will be agreed with the candidate selected for this position. The HCF Advisor will report to R4G’s staff MoH Advisor. This position is open to Zambian and non-Zambian residents.

Qualifications & Skills:
The HCF Advisor is expected to possess the following qualifications and skills:
• A Master’s Degree (or higher) in Public Health, Economics, Health Economics, Mathematics, Public Finance, Public Policy, Computer science or related field. A Doctorate (PhD) in one of these subjects will be an added advantage.
• At least 8 years of work experience in economic modeling and related work. Prior experience with revenue forecasting models is desirable.
• Ability to conceptualize, develop and implement a mathematical model using Microsoft Excel or any other suitable forecasting software.
• Good understanding of the health-care sector in Low and Middle Income Countries (LMICs).
• Excellent research skills and ability to analyze and utilize findings.
• Excellent English verbal and written communication skills.
• Strong orientation to teamwork and ability to meet deadlines.


Deadline of this Job: 26 August 2022
JOB DETAILS:
• To formulate and ensure implementation of effective and efficient business intelligence (BI) and revenue planning strategies and reporting for the Zambia OpCo to enhance the leadership position in customer and revenue market share.

Core Responsibilities Are:
• Analyze Revenue and Marketing data to help the businesses achieve the targeted revenue and target Revenue Market Share.
• Lead the Annual Operating Plan exercise.
• Drive weekly cross functional Revenue Review.
• Validate all Circle Price Propositions, which are planned to be launched, as a neutral Vertical, to ensure that the Proposition meets the overall business objective.
• Analyze Customer & Business impact of all new Propositions launched, so that a corrective action / learning can be taken for future.
• Track Competition Strategy, Plans & Products and provide insights to management.
• 100% compliance to New Site Rollout through PCN approval.
• Post rollout location launch and tracking.
• Ensure compliance of Marketing Processes.
• Overall Business Intelligence Responsibility and supporting all marketing verticals for data mining.

Requirements
Educational Qualifications & Functional / Technical Skills:
• Bachelor’s Degree in Geomatic Engineering, Engineering, Marketing, Economics, ACCA or other related courses.
• Certifications in Finance and Engineering are required.
• Understanding of Telecom Network infrastructure is a must.
• Proficient in Analytics, Research Methods, and SQL Data Mining.

Relevant Experience:
• The person should have at least 5 years of marketing experience (with focus on product management or data mining) in Telecoms. Cross functional exposure in other Business areas like Finance is a plus.
• Project Management.
• Consumer Insights understanding.
• Overall experience 7-10 years.

Competencies Required For The Post
• Strong Commercial Acumen.
• Strong Analytical skills.
• Achieving Business Success.
• Building Collaborative relationships.
• Empowering & Developing.
• Design thinking.
• Telecom Network appreciation.
• Must be a member of the Zambia Institute of Marketing.


Deadline of this Job: 31 August 2022
JOB DETAILS:
Job Summary
• Assistant credit controller is charged with the responsibility of supporting the Credit Controller in the activities of the credit control office. He/she will complete many administrative, organization and analysis tasks to monitor the financial health of the business.

Duties and Responsibilities
• Assist the Credit controller in overseeing activities of the Department.
• To assist in the raising of Credit and Debit notes and other bill adjustments
• Ensure all corporate letters of guarantee and extensions are received on time.
• Participate in all team efforts as departmental needs arise.
• Perform any other tasks as may be requested by management from time to time
• Maintain strong relationships with all clients to ensure invoices are clear for payment
• Negotiate repayment plans when necessary
• Resolve all issues raised internally and externally around outstanding invoices
• Post and allocate daily receipts to accounting systems; run reports for centre head.
• Provide account information to internal departments

Requirements and Qualifications
• Diploma or better in Accounting, Finance, Business administration or ZICA
• Ability to establish and maintain good client relationships, both internally and externally at all levels
• Competence in Microsoft Office products, and accounting software programs
• Prior experience with financial systems or Accounting packages.
• Ability to hold personal client information in the strictest confidentiality
• Skills in Credit & Debt Collection Management and Financial counselling
• At least 2 years of experience in a similar role in a busy Credit Control setting preferably in a Hospital set-up
• A team player with a positive attitude towards work and other members of the team
• Excellent interpersonal and communication skills including telephone handling skills
• Ability to work under pressure
• Ability to work long hours with minimal supervision, has initiative and is proactive
• Good grooming and self-presentation

Other Jobs
Deadline of this Job: 31 August 2022

Deadline of this Job: 27 August 2022

Deadline of this Job: 26 August 2022

Deadline of this Job: 31 August 2022

Deadline of this Job: 26 August 2022

Deadline of this Job: 26 August 2022

Deadline of this Job: 26 August 2022

Deadline of this Job: 22 August 2022

Deadline of this Job: 26 August 2022

Deadline of this Job: 26 August 2022

Deadline of this Job: 22 August 2022

Deadline of this Job: 17 October 2022

Deadline of this Job: 02 September 2022

Deadline of this Job: 02 September 2022c

Deadline of this Job: 02 September 2022
60.615MBMemory Usage418msRequest 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
array:1 [ "1deb24708f7a51ca02b447b7f6862276" => "edda6e73e61329ae6266c812679f7788" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1747157847 "last" => 1747157847...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
jsjobcur_usr
0
jsjobconfig_dft
array:171 [ "actk" => "0" "applybuttonredirecturl" => "http://www.greatzambiajobs.com/how-to-app...
JSItemid
"190"
  • afterLoad (4.12MB) (28.49ms)
  • afterInitialise (11.13MB) (80.42ms)
  • afterRoute (4.64MB) (32.87ms)
  • beforeRenderComponent com_content (29.19KB) (333μs)
  • Before Access::preloadComponents (all components) (371.13KB) (3.97ms)
  • After Access::preloadComponents (all components) (134.4KB) (1.02ms)
  • Before Access::preloadPermissions (com_content) (4.26KB) (19μs)
  • After Access::preloadPermissions (com_content) (1.16MB) (4.33ms)
  • Before Access::getAssetRules (id:1457 name:com_content.article.1020) (66.8KB) (88μs)
  • After Access::getAssetRules (id:1457 name:com_content.article.1020) (26.84KB) (344μs)
  • afterRenderComponent com_content (2.33MB) (30.76ms)
  • Before Access::getAssetRules (id:1 name:root.1) (1MB) (9.49ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.95KB) (31μs)
  • afterDispatch (1.7MB) (24.75ms)
  • afterRender (29.41MB) (200ms)
  • 1 x afterRender (29.41MB) (47.93%)
    200.28ms
    1 x afterInitialise (11.13MB) (19.25%)
    80.42ms
    1 x afterRoute (4.64MB) (7.87%)
    32.87ms
    1 x afterRenderComponent com_content (2.33MB) (7.36%)
    30.76ms
    1 x afterLoad (4.12MB) (6.82%)
    28.49ms
    1 x afterDispatch (1.7MB) (5.92%)
    24.75ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (1MB) (2.27%)
    9.49ms
    1 x After Access::preloadPermissions (com_content) (1.16MB) (1.04%)
    4.33ms
    1 x Before Access::preloadComponents (all components) (371.13KB) (0.95%)
    3.97ms
    1 x After Access::preloadComponents (all components) (134.4KB) (0.24%)
    1.02ms
    1 x After Access::getAssetRules (id:1457 name:com_content.article.1020) (26.84KB) (0.08%)
    344μs
    1 x beforeRenderComponent com_content (29.19KB) (0.08%)
    333μs
    1 x Before Access::getAssetRules (id:1457 name:com_content.article.1020) (66.8KB) (0.02%)
    88μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.95KB) (0.01%)
    31μs
    1 x Before Access::preloadPermissions (com_content) (4.26KB) (0%)
    19μs
64 statements were executed, 9 of which were duplicates, 55 unique17.14ms470.95KB
  • SELECT @@SESSION.sql_mode;83μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?94μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 186μ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_id87μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`80μs1.55KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `icop0_usergroups` AS `a` LEFT JOIN `icop0_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest116μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'82μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`74μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'159μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config120μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'71μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'62μ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'51μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1020-accounting-finance-jobs-at-whence-financial-services-nathan-associates-inc-airtel-zambia-dr-agarwals-eye-hospital-and-other-companies%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Frelated-jobs%2F1020-accounting-finance-jobs-at-whence-financial-services-nathan-associates-inc-airtel-zambia-dr-agarwals-eye-hospital-and-other-companies%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1020-accounting-finance-jobs-at-whence-financial-services-nathan-associates-inc-airtel-zambia-dr-agarwals-eye-hospital-and-other-companies%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC249μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • 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`447μs5.11KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1020-accounting-finance-jobs-at-whence-financial-services-nathan-associates-inc-airtel-zambia-dr-agarwals-eye-hospital-and-other-companies%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Frelated-jobs%2F1020-accounting-finance-jobs-at-whence-financial-services-nathan-associates-inc-airtel-zambia-dr-agarwals-eye-hospital-and-other-companies%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1020-accounting-finance-jobs-at-whence-financial-services-nathan-associates-inc-airtel-zambia-dr-agarwals-eye-hospital-and-other-companies%2F')=1) OR `list_var` LIKE '%com_content%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC226μs6.8KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM icop0_template_styles AS s WHERE s.client_id = 0 AND s.template = 'jl_education_pro' ORDER BY s.id166μ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,:preparedArray50)620μ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.02ms129.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `icop0_content`340μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `icop0_content` SET `hits` = (`hits` + 1) WHERE `id` = '1020'3.26ms48B/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)330μs56.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`325μs5.19KBParams/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)397μs5.27KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `alias` FROM `icop0_content` WHERE `id` = :id83μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `icop0_content` WHERE `id` = :id93μ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`321μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'237μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'290μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'198μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering157μs4.27KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 091μs11.9KB/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2291μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24109μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2899μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38119μs73.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40105μ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` = 0161μ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.lft390μs1.8KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM icop0_jmap_metainfo WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/related-jobs/1020-accounting-finance-jobs-at-whence-financial-services-nathan-associates-inc-airtel-zambia-dr-agarwals-eye-hospital-and-other-companies' AND `published` = 1102μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/related-jobs/1020-accounting-finance-jobs-at-whence-financial-services-nathan-associates-inc-airtel-zambia-dr-agarwals-eye-hospital-and-other-companies'51μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration241μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'81μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field141μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'114μ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` = 1114μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'154μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`226μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'71μ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)314μs56.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`282μs5.19KBParams/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 ASC574μ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 desc139μ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 desc182μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/related-jobs/1020-accounting-finance-jobs-at-whence-financial-services-nathan-associates-inc-airtel-zambia-dr-agarwals-eye-hospital-and-other-companies'99μ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` = 186μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"350μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.09ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin92μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin90μ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`110μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?107μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?179μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy