marketing jobs at CBMI Africa Limited, The AdBox and Syngenta


Deadline of this Job: 04 November 2022

JOB DETAILS:
Marketing Officer
Overview

CBMI Africa Ltd is a subsidiary of CBMI Construction Co., Ltd, a 60-year company for EPC Turnkey projects. CBMI’s businesses cover materials building, power generation, water works, environment protection, power transmission and transformation, energy saving transformation and other related fields. The projects undertook by CBMI are spread across different countries from Asia to Europe, the Middle East, Africa and Latin America. Here in Zambia, CBMI successfully constructed Lafarge cement plant, Sinoma cement plant and Cleanlime limestone plant.
CBMI Africa Ltd is seeking to recruit a qualified and experienced Marketing Officer to join our team.

Job Responsibilities
• To be in charge of business development and customer relationship management
• Manage and coordinate marketing activities to ensure we reach potential customers
• Plan and design marketing solutions that effectively promotes the company’s products and services
• Carry out market research to uncover new business opportunities
• Effectively gather market information and timely give feedback of relevant information to management
• Complete other tasks as assigned by management

Job Requirements
• Minimum of 5 years sales and marketing experience, having served some of those years in marketing of Roofing Materials in Zambia
• Should have a Bachelor’s degree/ Diploma in Marketing, Business Management or any related field
• Full Grade 12 certificate
• Must be proficient in Microsoft Word, Excel, PowerPoint and other related computer applications
• Must be a member of the Zambia Institute of Marketing
• Self-motivated with excellent verbal and communication skills
• Must be able to work under minimum supervision


Deadline of this Job: 31 October 2022

JOB DETAILS:
Digital Marketing Manager
Overview

If you live and breathe digital marketing, we want to talk to you. We are looking for a Digital Marketing Manager to develop, implement, track and optimize our client’s digital marketing campaigns across all digital channels.
You’ll be responsible for maintaining our client’s online presence and sales by working on various marketing campaigns. Your duties include researching, strategizing with other professionals and creating content (copy & visual) for successful campaigns. You should have a strong grasp of current marketing tools and strategies and be able to lead integrated digital marketing campaigns from concept to execution. Digital marketing managers will work with the marketing team, supporting teams, and vendors to launch campaigns on time and on budget.
Digital Marketing Manager responsibilities include:
• Planning digital marketing campaigns, including web, SEO/SEM, email, social media and display advertising
• Maintaining our client’s social media presence across all digital channels
• Measuring and reporting on the performance of all digital marketing campaigns
• Assisting with any other functions where the agency requires additional help
Responsibilities
• Plan and execute all digital marketing, including SEO/SEM, marketing database, email, social media and display advertising campaigns
• Design, build and maintain our social media presence
• Measure and report the performance of all digital marketing campaigns, and assess against goals (ROI and KPIs)
• Identify trends and insights, and optimize spend and performance based on the insights
• Brainstorm new and creative growth strategies
• Plan, execute, and measure experiments and conversion tests
• Collaborate with internal teams to create landing pages and optimize the user experience
• Utilize the strong analytical ability to evaluate end-to-end customer experience across multiple channels and customer touchpoints
• Instrument conversion points and optimizes user funnels
• Collaborate with clients
• Evaluate emerging technologies. Provide thought leadership and perspective for adoption where appropriate

Requirements and skills
• Proven working experience in digital marketing
• Demonstrable experience leading and managing SEO/SEM, marketing database, email, social media and/or display advertising campaigns
• Highly creative with experience in identifying target audiences and devising digital campaigns that engage, inform and motivate
• Experience in optimizing landing pages and user funnels
• Experience with A/B and multivariate experiments
• Solid knowledge of website analytics tools (e.g., Google Analytics, NetInsight, Omniture, WebTrends, SEM Rush, Lighthouse)
• Working knowledge of ad serving tools (e.g., DART, Atlas)
• Experience in setting up and optimizing Google Adwords campaigns
• Working knowledge of Web design development and constraints
• Strong analytical skills and data-driven thinking
• Up-to-date with the latest trends and best practices in online marketing and measurement
• Able to use creative tools such as Canva / Illustrator / Photoshop if required

Deadline of this Job: 21 November 2022

JOB DETAILS:
A&P Digital Marketing Coordinator
Company Description

As a world market leader in crop protection, we help farmers to counter these threats and ensure enough safe, nutritious, affordable food for all – while minimizing the use of land and other agricultural inputs.
Syngenta Crop Protection keeps plants safe from planting to harvesting. From the moment a seed is planted through to harvest, crops need to be protected from weeds, insects and diseases as well as droughts and floods, heat and cold.
Syngenta Crop Protection is headquartered in Switzerland.

Job Description
To develop, implement, track and optimize Syngenta Zambia digital marketing campaigns across all digital channels as well as supporting the SABA strategic goals.

Accountabilities
• Plan and execute all digital marketing, including Sales Force.Com (SFDC), marketing database, email, social media and display advertising campaigns, website database maintenance & update.
• Design, build and maintain our social media presence in all platforms.
• Measure and report performance of all digital marketing campaigns, and assess against goals (ROI and KPIs)
• Identify trends and insights, and optimize spend and performance based on the insights.
• Create and manage brand dashboard to track performance both for SE and CPs.
• Plan, execute, and measure experiments and conversion tests.
• Collaborate with internal/external teams to create landing pages and optimize user experience.
• Utilize strong analytical ability to evaluate end-to-end customer experience across multiple channels and customer touch points.
• Evaluate emerging technologies. Provide thought leadership and perspective for adoption where appropriate

Qualifications
Critical Knowledge:
• BSc/BA Commerce, Marketing, Business – Chartered Institute of Marketing or Equivalent , MBA added advantage.
• Solid knowledge of website analytics tools (e.g., Google Analytics, Net Insight)
• Working knowledge of consumer based research, insights and data analytics for brand positioning optimization.
Critical Skills:
• Strong analytical skills and data-driven thinking – excellent excel skills, ability to manipulate data and create models/simulations.
Critical Experience:
• Proven working 3 to 6 years’ experience in digital marketing/research insights/brand management.
• Demonstrable experience leading and managing SEO/SEM, marketing database, email, social media and/or display advertising campaigns.
• Highly creative with experience in identifying target audiences and devising digital campaigns that engage, inform and motivate.
• Experience in optimizing landing pages and user funnels.
• Proven experience with managing the brand and dash board creation.
Other behaviours critical for the role:
• Excellent team player
• Honest and Sober
• Hard working and Personally driven
Critical Success Factors
• Excellent MS and digital marketing tools awareness.
• Passion for working with data/figures.

60.568MBMemory Usage400msRequest 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 [ "1deb24708f7a51ca02b447b7f6862276" => "7f9e76dfb84ed775e3fb1c111d481d1a" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 3 "timer" => array:3 [ "start" => 1746533973 "last" => 1746533978...
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) (26.01ms)
  • afterInitialise (11.13MB) (65.68ms)
  • afterRoute (4.64MB) (27.41ms)
  • beforeRenderComponent com_content (29.19KB) (206μs)
  • Before Access::preloadComponents (all components) (371.13KB) (2.51ms)
  • After Access::preloadComponents (all components) (134.4KB) (1.04ms)
  • Before Access::preloadPermissions (com_content) (4.26KB) (13μs)
  • After Access::preloadPermissions (com_content) (1.16MB) (3.9ms)
  • Before Access::getAssetRules (id:1923 name:com_content.article.1328) (66.8KB) (52μs)
  • After Access::getAssetRules (id:1923 name:com_content.article.1328) (26.84KB) (250μs)
  • afterRenderComponent com_content (2.29MB) (25.12ms)
  • Before Access::getAssetRules (id:1 name:root.1) (1MB) (7.21ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.95KB) (33μs)
  • afterDispatch (1.7MB) (24.42ms)
  • afterRender (29.38MB) (216ms)
  • 1 x afterRender (29.38MB) (53.89%)
    215.66ms
    1 x afterInitialise (11.13MB) (16.41%)
    65.68ms
    1 x afterRoute (4.64MB) (6.85%)
    27.41ms
    1 x afterLoad (4.12MB) (6.5%)
    26.01ms
    1 x afterRenderComponent com_content (2.29MB) (6.28%)
    25.12ms
    1 x afterDispatch (1.7MB) (6.1%)
    24.42ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (1MB) (1.8%)
    7.21ms
    1 x After Access::preloadPermissions (com_content) (1.16MB) (0.97%)
    3.90ms
    1 x Before Access::preloadComponents (all components) (371.13KB) (0.63%)
    2.51ms
    1 x After Access::preloadComponents (all components) (134.4KB) (0.26%)
    1.04ms
    1 x After Access::getAssetRules (id:1923 name:com_content.article.1328) (26.84KB) (0.06%)
    250μs
    1 x beforeRenderComponent com_content (29.19KB) (0.05%)
    206μs
    1 x Before Access::getAssetRules (id:1923 name:com_content.article.1328) (66.8KB) (0.01%)
    52μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.95KB) (0.01%)
    33μs
    1 x Before Access::preloadPermissions (com_content) (4.26KB) (0%)
    13μs
64 statements were executed, 9 of which were duplicates, 55 unique19.84ms406.95KB
  • SELECT @@SESSION.sql_mode;50μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?155μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 190μ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_id348μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`114μ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` = :guest125μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'117μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`97μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'161μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config104μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'70μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'60μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'60μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'59μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1328-marketing-jobs-at-cbmi-africa-limited-the-adbox-and-syngenta%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Frelated-jobs%2F1328-marketing-jobs-at-cbmi-africa-limited-the-adbox-and-syngenta%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1328-marketing-jobs-at-cbmi-africa-limited-the-adbox-and-syngenta%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC230μ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`312μs5.11KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1328-marketing-jobs-at-cbmi-africa-limited-the-adbox-and-syngenta%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Frelated-jobs%2F1328-marketing-jobs-at-cbmi-africa-limited-the-adbox-and-syngenta%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1328-marketing-jobs-at-cbmi-africa-limited-the-adbox-and-syngenta%2F')=1) OR `list_var` LIKE '%com_content%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC229μ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.id151μ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)721μ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` = 01.95ms129.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `icop0_content`423μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `icop0_content` SET `hits` = (`hits` + 1) WHERE `id` = '1328'5.25ms48B/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)312μ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`245μ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)288μs5.27KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `alias` FROM `icop0_content` WHERE `id` = :id102μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `icop0_content` WHERE `id` = :id66μ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`314μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'233μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'209μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'156μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering173μs4.27KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 097μs11.9KB/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2295μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2494μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2891μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38121μs73.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 4091μ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` = 0120μ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.lft399μ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/1328-marketing-jobs-at-cbmi-africa-limited-the-adbox-and-syngenta' AND `published` = 1183μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/related-jobs/1328-marketing-jobs-at-cbmi-africa-limited-the-adbox-and-syngenta'64μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration249μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'150μ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'89μ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` = 1116μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'226μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`320μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'102μ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)408μ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`451μ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 ASC750μ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 desc177μ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 desc167μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/related-jobs/1328-marketing-jobs-at-cbmi-africa-limited-the-adbox-and-syngenta'90μ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` = 173μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"357μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.07ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin108μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin99μ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`106μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?111μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?171μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy