Country Counsel and Corporate Secretary Job at Citibank - Career Opportunity in Zambia
Website :
1976 Days Ago
Linkedid Twitter Share on facebook

Vacancy title:
Country Counsel and Corporate Secretary

[ Type: FULL TIME , Industry: Banking , Category: Banking ]

 

Jobs at:

Citibank

Deadline of this Job:
25th August 2019  

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

Summary
Date Posted: Friday, August 09, 2019 , Base Salary: Not Disclosed


JOB DETAILS:
The Country Counsel II provides full leadership and supervisory responsibility. Provides operational/service leadership and direction to team(s). Applies in-depth disciplinary knowledge through provision of value-added perspectives or advisory services. May contribute to the development of new techniques, models and plans within area of expertise. Excellent communication and diplomacy skills are required. Generally has responsibility for volume, quality, timeliness of end results and shared responsibility for planning and budgets. Work affects an entire area, which eventually affects the overall performance and effectiveness of the sub-function/job family. Full supervisory responsibility, ensuring motivation and development of team through professional leadership to include duties such as performance evaluation, compensation, hiring, disciplinary and terminations as well as direction of daily tasks and responsibilities. .

Responsibilities:
• Manages and supports the Legal function providing support and guidance to the local businesses and to all Citi functions on all aspects of local and Citigroup Legal related matters
• Ensures full compliance of all local Citigroup products and structures with local Law, as in force, and where applicable with international standards
• Ensure continuity and management of legal operations of Citigroup in the region as it pertains to local licenses and all other types of Corporate Governance, including company secretarial roles, as well as compliance with local regulatory requirements Advises the CCO on business and Franchise Legal issues
• Interface with Regulators
• Ensures consistency of Citigroup policies with local legal requirements
• Escalates to designated Division Counsel all issues that are of importance within the role
• Participate in the local Management committees
• Management and coordination of the provision of external legal services
• Liaise with Compliance in the development, updating and presentation of training materials related to local laws and regulations
• Assist overseas colleagues engaged in projects and deals involving local laws and regulations
• Manages and organize the handling of litigation cases in which Citigroup entities are involved as defendants or claimants
• Manages the functioning of the Legal Department.
• Draft and implement local legal policies and procedures
• Draft, amend and approve the list of external legal counsels used by Citigroup locally
• Manage relationship with said legal counsels
• Review customer complaints that could develop into legal actions or have Regulatory implications
• Provide solution-oriented legal support and assistance to the local businesses in accordance with strategic business needs and applicable regulatory and legal requirements
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm’s reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency, as well as effectively supervise the activity of others and create accountability with those who fail to maintain these standards.

Job Skills: Not Specified


Qualifications:
• 5-8 years of experience
• Excellent leadership, interpersonal skills, relationship management skills
• Excellent written, verbal, problem solving and analytical skills
• Excellent negotiation skills and ability to maintain effective relationship
Education:
• Bachelors/University degree or equivalent experience

Job Education Requirements: Not Specified


Job Experience Requirements: 5-8 years

 

{module 312}

Job application procedure
Click here to apply https://jobs.citi.com/job/-/-/287/12524696  

All Jobs

QUICK ALERT SUBSCRIPTION

 

Job Info
Job Category: Banking/ Finance jobs in Zambia
Job Type: Full-time
Deadline of this Job: 25th Aug 2019
Duty Station: Lusaka
Posted: 09-08-2019
No of Jobs: 1
Start Publishing: 09-08-2019
Stop Publishing (Put date of 2030): 09-08-2065
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
66.395MBMemory Usage402msRequest Duration
Joomla! Version4.4.9
PHP Version8.1.31
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.27-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:63 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1736144921 "last" => 1736144921...
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) (21.04ms)
  • afterInitialise (11.9MB) (82.2ms)
  • afterRoute (10.33MB) (49.99ms)
  • beforeRenderComponent com_jsjobs (10.08KB) (151μs)
  • afterRenderComponent com_jsjobs (2.84MB) (22.33ms)
  • Before Access::preloadComponents (all components) (239.6KB) (3.96ms)
  • After Access::preloadComponents (all components) (132.72KB) (594μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (12μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (217μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (3.66MB) (33.93ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (51.14ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (6μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (261μs)
  • afterDispatch (75.48KB) (87μs)
  • afterRender (10.98MB) (135ms)
  • 1 x afterRender (10.98MB) (33.64%)
    135.15ms
    1 x afterInitialise (11.9MB) (20.46%)
    82.20ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (12.73%)
    51.14ms
    1 x afterRoute (10.33MB) (12.44%)
    49.99ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (3.66MB) (8.44%)
    33.93ms
    1 x afterRenderComponent com_jsjobs (2.84MB) (5.56%)
    22.33ms
    1 x afterLoad (4.12MB) (5.24%)
    21.04ms
    1 x Before Access::preloadComponents (all components) (239.6KB) (0.99%)
    3.96ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.15%)
    594μs
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.06%)
    261μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.05%)
    217μs
    1 x beforeRenderComponent com_jsjobs (10.08KB) (0.04%)
    151μs
    1 x afterDispatch (75.48KB) (0.02%)
    87μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    12μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    6μs
125 statements were executed, 23 of which were duplicates, 102 unique21.37ms287.65KB
  • SELECT @@SESSION.sql_mode;83μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?109μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 189μ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)280μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`96μ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` = :guest89μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'72μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`59μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'122μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config156μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'65μs856B/plugins/system/acymtriggers/acymtriggers.php:516Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'50μs856B/plugins/system/acymtriggers/acymtriggers.php:516Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'50μs856B/plugins/system/acymtriggers/acymtriggers.php:516Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'38μs856B/plugins/system/acymtriggers/acymtriggers.php:516Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Country-Counsel-and-Corporate-Secretary-Job-at-Citibank-Career-Opportunity-in-Zambia-12573%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Country-Counsel-and-Corporate-Secretary-Job-at-Citibank-Career-Opportunity-in-Zambia-12573%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Country-Counsel-and-Corporate-Secretary-Job-at-Citibank-Career-Opportunity-in-Zambia-12573%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC126μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SHOW TABLES727μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_configuration207μs7.38KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM icop0_acym_plugin121μs2.13KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'acychecker' LIMIT 173μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'acymailer' LIMIT 169μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'amazon' LIMIT 184μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'article' LIMIT 169μs2.09KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'birthday' LIMIT 170μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'brevo' LIMIT 166μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'createuser' LIMIT 167μs2.09KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` FROM icop0_usergroups AS `groups`57μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'elasticemail' LIMIT 191μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'forward' LIMIT 163μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'mailgun' LIMIT 161μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'module' LIMIT 176μs2.09KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'online' LIMIT 174μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'override' LIMIT 165μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'phpmail' LIMIT 174μs13.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'postmark' LIMIT 161μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'qmail' LIMIT 159μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'segment' LIMIT 159μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'sendgrid' LIMIT 158μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'sendinblue' LIMIT 160μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luecredentials' LIMIT 195μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'lueintegration' LIMIT 155μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luetransactional' LIMIT 163μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luelist' LIMIT 154μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'lueusers' LIMIT 154μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luesender' LIMIT 153μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luecampaign' LIMIT 165μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luewebhooks' LIMIT 155μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'sendmail' LIMIT 165μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'smtp' LIMIT 167μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'statistics' LIMIT 193μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'subscriber' LIMIT 187μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'subscription' LIMIT 190μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'time' LIMIT 189μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'user' LIMIT 160μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'managetext' LIMIT 161μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Country-Counsel-and-Corporate-Secretary-Job-at-Citibank-Career-Opportunity-in-Zambia-12573%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Country-Counsel-and-Corporate-Secretary-Job-at-Citibank-Career-Opportunity-in-Zambia-12573%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Country-Counsel-and-Corporate-Secretary-Job-at-Citibank-Career-Opportunity-in-Zambia-12573%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC177μs4.25KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM icop0_template_styles AS s WHERE s.client_id = 0 AND s.template = 'jl_education_pro' ORDER BY s.id142μs1.2KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'260μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'128μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'181μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'171μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'128μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'48μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'85μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'140μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT job.params,job.id,job.title,job.city,job.metakeywords,job.metadescription,job.description,job.created,job.isgoldjob,job.isfeaturedjob,job.gender , job.jobcategory,job.duration,job.hidesalaryrange,job.zipcode,job.iseducationminimax,job.degreetitle,job.isexperienceminimax , job.startpublishing,job.requiredtravel,job.noofjobs,job.hits,job.stoppublishing,job.video,job.prefferdskills,job.qualifications,job.agreement,job.experiencetext,job.longitude,job.latitude , cat.cat_title, subcat.title as subcategory, company.name as companyname, jobtype.title AS jobtypetitle , jobstatus.title AS jobstatustitle, shift.title as shifttitle, company.url as companywebsite, company.contactname AS companycontactname, company.contactemail AS companycontactemail,company.since AS companysince,company.logofilename AS companylogo , department.name AS departmentname, company.id companyid,job.educationminimax,job.experienceminimax , salaryfrom.rangestart AS salaryfrom, salaryto.rangestart AS salaryto, salarytype.title AS salarytype , education.title AS educationtitle ,mineducation.title AS mineducationtitle, maxeducation.title AS maxeducationtitle , experience.title AS experiencetitle ,minexperience.title AS minexperiencetitle, maxexperience.title AS maxexperiencetitle , currency.symbol,CONCAT(job.alias,'-',job.id) AS jobaliasid, agefrom.title AS agefromtitle, ageto.title AS agetotitle ,company.isgoldcompany,company.isfeaturedcompany ,CONCAT(company.alias,'-',company.id) AS companyaliasid, workpermit.name as workpermitcountry ,company.endgolddate,company.endfeatureddate, job.jobapplylink,job.joblink, careerlevel.title AS careerleveltitle ,(SELECT COUNT(id) FROM `icop0_js_job_jobapply` WHERE jobid = job.id) AS totalapply FROM `icop0_js_job_jobs` AS job JOIN `icop0_js_job_categories` AS cat ON job.jobcategory = cat.id JOIN `icop0_js_job_companies` AS company ON job.companyid = company.id JOIN `icop0_js_job_jobtypes` AS jobtype ON job.jobtype = jobtype.id LEFT JOIN `icop0_js_job_ages` AS agefrom ON agefrom.id = job.agefrom LEFT JOIN `icop0_js_job_ages` AS ageto ON ageto.id = job.ageto LEFT JOIN `icop0_js_job_subcategories` AS subcat ON job.subcategoryid = subcat.id LEFT JOIN `icop0_js_job_jobstatus` AS jobstatus ON job.jobstatus = jobstatus.id LEFT JOIN `icop0_js_job_departments` AS department ON job.departmentid = department.id LEFT JOIN `icop0_js_job_salaryrange` AS salaryfrom ON job.salaryrangefrom = salaryfrom.id LEFT JOIN `icop0_js_job_salaryrange` AS salaryto ON job.salaryrangeto = salaryto.id LEFT JOIN `icop0_js_job_salaryrangetypes` AS salarytype ON job.salaryrangetype = salarytype.id LEFT JOIN `icop0_js_job_heighesteducation` AS education ON job.educationid = education.id LEFT JOIN `icop0_js_job_heighesteducation` AS mineducation ON job.mineducationrange = mineducation.id LEFT JOIN `icop0_js_job_heighesteducation` AS maxeducation ON job.maxeducationrange = maxeducation.id LEFT JOIN `icop0_js_job_experiences` AS experience ON job.experienceid = experience.id LEFT JOIN `icop0_js_job_experiences` AS minexperience ON job.minexperiencerange = minexperience.id LEFT JOIN `icop0_js_job_experiences` AS maxexperience ON job.maxexperiencerange = maxexperience.id LEFT JOIN `icop0_js_job_shifts` AS shift ON job.shift = shift.id LEFT JOIN `icop0_js_job_currencies` AS currency ON currency.id = job.currencyid LEFT JOIN `icop0_js_job_countries` AS workpermit ON workpermit.id = job.workpermit LEFT JOIN `icop0_js_job_careerlevels` AS careerlevel ON job.careerlevel = careerlevel.id WHERE job.id = 12573439μs28.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'196μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 12573290μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'166μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering205μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'130μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'150μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering138μs4.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'116μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'116μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'79μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'45μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'124μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'117μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'55μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'51μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 293μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2112μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'270μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield918' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'289μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 288μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 281μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 283μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'132μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'150μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'115μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering104μs4.27KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `icop0_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49,:preparedArray50)364μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0131μs936B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2262μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2490μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2866μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 3889μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 3973μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 4078μ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` = 0133μ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.lft304μs1.8KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'distribution-channels' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft247μs1.17KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'categories-list' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft300μs2.3KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM icop0_jmap_metainfo WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Country-Counsel-and-Corporate-Secretary-Job-at-Citibank-Career-Opportunity-in-Zambia-12573' AND `published` = 1195μs1.2KB/plugins/system/jmap/jmap.php:762Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Country-Counsel-and-Corporate-Secretary-Job-at-Citibank-Career-Opportunity-in-Zambia-12573'107μs960B/plugins/system/jmap/jmap.php:864Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'143μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM icop0_acym_field93μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'81μs1.2KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • 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` = 1100μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'145μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`304μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'64μs912B/libraries/src/Table/Table.php:755Copy
  • SELECT a.* FROM icop0_gsd a WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*') ORDER BY a.id desc191μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`321μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid82μs4.41KBParams/libraries/src/Table/User.php:104Copy
  • SELECT `g`.`id`,`g`.`title` FROM `icop0_usergroups` AS `g` INNER JOIN `icop0_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid96μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Country-Counsel-and-Corporate-Secretary-Job-at-Citibank-Career-Opportunity-in-Zambia-12573'75μs1.05KB/plugins/system/jmap/jmap.php:1079Copy
  • SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `icop0_jmap_text_replacements` WHERE `published` = 1103μs1008B/plugins/system/jmap/jmap.php:465Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"183μs856B/plugins/system/acymtriggers/acymtriggers.php:218Copy
  • SHOW TABLES698μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'117μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'196μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 256998μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?120μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?5.52ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy