Courses for Core Skills

Managing Analytical & Research Projects

Courses Summary
  • Duration : Two Days
  • Price : £890 + VAT (*Discount available)
  • Start Dates : 11th June 2025
  • Location : Microsoft Teams
  • Info :

    *Discount available for Public Sector. Please get in touch for more info. 

Book Now
Details
Category: Core Skills
Published: Tuesday, 11 August 2020 12:33
Written by: Matt Pye - HWD

Overview

This workshop uses delegates' own projects and experience to introduce methods for managing analytical projects from end-to-end, using relevant tools along the way.  It also emphasises the people management aspects required to ensure stakeholders support and engage with analysts.  

Learning Objectives

  1. Understand the key concepts and context of analytical projects, including their role in addressing problems, implementing change, and fostering innovation.

  2. Differentiate between different types of analytical projects and assess the implications associated with each type.

  3. Learn project terminology, definitions, and the analytical project lifecycle stages, while recognising that projects may not always follow a linear path.

  4. Identify the roles and skills required for effective leadership and teamwork in analytical projects, including the role of project boards for governance.

  5. Develop a project definition that encompasses the needs and expectations of stakeholders, ensuring their support and engagement throughout the project.

  6. Gain proficiency in time and activity planning, including an overview of planning levels and tools, such as understanding activities, milestones, dependencies, and building a Bar/Gantt Chart.

  7. Enhance communication and influencing skills as an analyst, particularly in the context of stakeholder management and the stakeholder communication cycle.

  8. Learn effective techniques for day-to-day project management, including monitoring progress, identifying and handling issues, managing changes through change control, and obtaining sign-offs.

  9. Develop strategies for communicating with stakeholders and reporting project progress, utilising formal reporting and update reporting frameworks such as the ABCD framework.

  10. Acquire knowledge on reviewing and closing projects, including handing over deliverables to end-users, confirming benefits realisation, conducting project reviews, sharing learning points, and preparing close-out reports.



Topics include:

  • Analytical & Research Projects
    • Why A&R projects are “different”
    • Recognising what type of project you have
  • Programmes vs. projects
  • Project initiation
    • Setting up a project for success (objectives, scope)
    • Roles and responsibilities (Sponsor/PM etc.)
    • High-level planning - milestones and risks
  • Stakeholder management
    • Identifying and recognising different types of stakeholder
    • Engagement and relationship management strategies
    • Communications planning
  • Planning principles and tools
    • How to develop plans
    • Planning tools for Waterfall and Agile projects
  • Managing risks and issues
    • Identifying and assessing risks
    • Problem definition and approach to deal with issues
  • Making progress and keeping control
    • Project team meetings 
    • Monitoring and reporting progress
    • Dealing with changes
  • Identifying and managing benefits
    • Benefits mapping
    • Measurement and performance indicators
  • Lessons learnt
    • Why projects succeed or fail
    • Avoiding the pitfalls

How our virtual classrooms work

Our Virtual Classroom courses allows you to attend our classroom training without leaving your home or office. We use the ‘Microsoft Teams’ meeting software. Before you attend, please check that you meet the system requirements. If it doesn’t work, try adjusting your settings or contact your IT department to ask about permitting the website.

You are also welcome to use your personal laptop, tablet or even your smart phone. Please just forward our course invite to your personal email, or just copy and paste the link into your browser.

If you encounter any problems, please feel free to get in touch. We can set up a test meeting before the course.

Related Courses

For more information, to book or to register your interest in future course dates

Contact Us

J! InfoRequestSessionProfileQueries43
5MBMemory Usage162msRequest Duration
Joomla! Version4.3.1
PHP Version8.1.32
Identityguest
Response200
Templateecho
Database
Server
mysql
Version
10.4.34-MariaDB
Collation
utf8_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
[]
$_COOKIE
[]
$_SERVER
array:59 [ "USER" => "lsr-training" "HOME" => "/var/www/vhosts/lsr-training.co.uk" "SCRIPT_NAM...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743205370 "last" => 1743205370...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
PHPDEBUGBAR_STACK_DATA
[]
  • afterLoad (539.8KB) (9.66ms)
  • afterInitialise (882.22KB) (33.42ms)
  • afterRoute (380.72KB) (10.06ms)
  • beforeRenderComponent com_content (99.57KB) (7.21ms)
  • Before Access::preloadComponents (all components) (105.68KB) (3.86ms)
  • After Access::preloadComponents (all components) (115.83KB) (1.33ms)
  • Before Access::preloadPermissions (com_content) (2.76KB) (38μs)
  • After Access::preloadPermissions (com_content) (58.01KB) (959μs)
  • Before Access::getAssetRules (id:136 name:com_content.article.135) (6.8KB) (36μs)
  • After Access::getAssetRules (id:136 name:com_content.article.135) (8.47KB) (291μs)
  • Before Access::getAssetRules (id:8 name:com_content) (633.78KB) (42ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (21μs)
  • afterRenderComponent com_content (102.84KB) (5.85ms)
  • afterDispatch (2.28KB) (251μs)
  • beforeRenderRawModule mod_custom (Social Options) (427.55KB) (3.87ms)
  • afterRenderRawModule mod_custom (Social Options) (4.12KB) (1.3ms)
  • beforeRenderModule mod_custom (Social Options) (720B) (10μs)
  • afterRenderModule mod_custom (Social Options) (4.36KB) (274μs)
  • beforeRenderRawModule mod_custom (Footer) (360B) (48μs)
  • afterRenderRawModule mod_custom (Footer) (928B) (256μs)
  • beforeRenderModule mod_custom (Footer) (704B) (3μs)
  • afterRenderModule mod_custom (Footer) (3.16KB) (105μs)
  • beforeRenderRawModule mod_custom (Contact CTA) (328B) (30μs)
  • afterRenderRawModule mod_custom (Contact CTA) (960B) (258μs)
  • beforeRenderModule mod_custom (Contact CTA) (720B) (4μs)
  • afterRenderModule mod_custom (Contact CTA) (2.52KB) (136μs)
  • beforeRenderRawModule mod_djmegamenu (DJ-MegaMenu) (8.02KB) (63μs)
  • afterRenderRawModule mod_djmegamenu (DJ-MegaMenu) (624.04KB) (18.47ms)
  • beforeRenderModule mod_djmegamenu (DJ-MegaMenu) (720B) (26μs)
  • afterRenderModule mod_djmegamenu (DJ-MegaMenu) (22.3KB) (278μs)
  • beforeRenderRawModule mod_menu (All Page) (6.59KB) (52μs)
  • afterRenderRawModule mod_menu (All Page) (4.28KB) (899μs)
  • beforeRenderModule mod_menu (All Page) (704B) (8μs)
  • afterRenderModule mod_menu (All Page) (4.15KB) (111μs)
  • beforeRenderRawModule mod_search (Search our courses) (1.2KB) (99μs)
  • afterRenderRawModule mod_search (Search our courses) (13.63KB) (1.25ms)
  • beforeRenderModule mod_search (Search our courses) (720B) (7μs)
  • afterRenderModule mod_search (Search our courses) (3.05KB) (120μs)
  • afterRender (256.65KB) (9.18ms)
  • 1 x Before Access::getAssetRules (id:8 name:com_content) (633.78KB) (25.88%)
    42.00ms
    1 x afterInitialise (882.22KB) (20.59%)
    33.42ms
    1 x afterRenderRawModule mod_djmegamenu (DJ-MegaMenu) (624.04KB) (11.38%)
    18.47ms
    1 x afterRoute (380.72KB) (6.2%)
    10.06ms
    1 x afterLoad (539.8KB) (5.95%)
    9.66ms
    1 x afterRender (256.65KB) (5.66%)
    9.18ms
    1 x beforeRenderComponent com_content (99.57KB) (4.44%)
    7.21ms
    1 x afterRenderComponent com_content (102.84KB) (3.61%)
    5.85ms
    1 x beforeRenderRawModule mod_custom (Social Options) (427.55KB) (2.38%)
    3.87ms
    1 x Before Access::preloadComponents (all components) (105.68KB) (2.38%)
    3.86ms
    1 x After Access::preloadComponents (all components) (115.83KB) (0.82%)
    1.33ms
    1 x afterRenderRawModule mod_custom (Social Options) (4.12KB) (0.8%)
    1.30ms
    1 x afterRenderRawModule mod_search (Search our courses) (13.63KB) (0.77%)
    1.25ms
    1 x After Access::preloadPermissions (com_content) (58.01KB) (0.59%)
    959μs
    1 x afterRenderRawModule mod_menu (All Page) (4.28KB) (0.55%)
    899μs
    1 x After Access::getAssetRules (id:136 name:com_content.article.135) (8.47KB) (0.18%)
    291μs
    1 x afterRenderModule mod_djmegamenu (DJ-MegaMenu) (22.3KB) (0.17%)
    278μs
    1 x afterRenderModule mod_custom (Social Options) (4.36KB) (0.17%)
    274μs
    1 x afterRenderRawModule mod_custom (Contact CTA) (960B) (0.16%)
    258μs
    1 x afterRenderRawModule mod_custom (Footer) (928B) (0.16%)
    256μs
    1 x afterDispatch (2.28KB) (0.15%)
    251μs
    1 x afterRenderModule mod_custom (Contact CTA) (2.52KB) (0.08%)
    136μs
    1 x afterRenderModule mod_search (Search our courses) (3.05KB) (0.07%)
    120μs
    1 x afterRenderModule mod_menu (All Page) (4.15KB) (0.07%)
    111μs
    1 x afterRenderModule mod_custom (Footer) (3.16KB) (0.06%)
    105μs
    1 x beforeRenderRawModule mod_search (Search our courses) (1.2KB) (0.06%)
    99μs
    1 x beforeRenderRawModule mod_djmegamenu (DJ-MegaMenu) (8.02KB) (0.04%)
    63μs
    1 x beforeRenderRawModule mod_menu (All Page) (6.59KB) (0.03%)
    52μs
    1 x beforeRenderRawModule mod_custom (Footer) (360B) (0.03%)
    48μs
    1 x Before Access::preloadPermissions (com_content) (2.76KB) (0.02%)
    38μs
    1 x Before Access::getAssetRules (id:136 name:com_content.article.135) (6.8KB) (0.02%)
    36μs
    1 x beforeRenderRawModule mod_custom (Contact CTA) (328B) (0.02%)
    30μs
    1 x beforeRenderModule mod_djmegamenu (DJ-MegaMenu) (720B) (0.02%)
    26μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0.01%)
    21μs
    1 x beforeRenderModule mod_custom (Social Options) (720B) (0.01%)
    10μs
    1 x beforeRenderModule mod_menu (All Page) (704B) (0%)
    8μs
    1 x beforeRenderModule mod_search (Search our courses) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (Contact CTA) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Footer) (704B) (0%)
    3μs
43 statements were executed, 2 of which were duplicates, 41 unique20ms318.58KB
UniquesDuplicates 1
  • SELECT @@SESSION.sql_mode;159μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `ldoa_session` WHERE `session_id` = ?229μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `ldoa_session` WHERE `session_id` = :session_id LIMIT 1133μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `ldoa_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.34ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `ldoa_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1398μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `ldoa_viewlevels`161μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `ldoa_usergroups` AS `a` LEFT JOIN `ldoa_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest187μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `ldoa_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`777μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:283Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `ldoa_menu` AS `m` LEFT JOIN `ldoa_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`2.55ms136.3KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `ldoa_languages` WHERE `published` = 1 ORDER BY `ordering` ASC374μs2.22KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `ldoa_template_styles` AS `s` LEFT JOIN `ldoa_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1489μs1.14KB/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `ldoa_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)669μs7.75KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `ldoa_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0456μs3.55KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `ldoa_content`575μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `ldoa_content` SET `hits` = (`hits` + 1) WHERE `id` = '135'175μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `ldoa_content` AS `a` INNER JOIN `ldoa_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `ldoa_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `ldoa_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `ldoa_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `ldoa_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)635μ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 `ldoa_categories` AS `s` INNER JOIN `ldoa_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`571μs7.69KBParams/libraries/src/Categories/Categories.php:363Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `ldoa_contentitem_tag_map` AS `m` INNER JOIN `ldoa_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)361μs5.22KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • 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 `ldoa_categories` AS `s` INNER JOIN `ldoa_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`584μs5.19KBParams/libraries/src/Categories/Categories.php:363Copy
  • 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 ldoa_fields AS a LEFT JOIN `ldoa_languages` AS l ON l.lang_code = a.language LEFT JOIN ldoa_users AS uc ON uc.id=a.checked_out LEFT JOIN ldoa_viewlevels AS ag ON ag.id = a.access LEFT JOIN ldoa_users AS ua ON ua.id = a.created_user_id LEFT JOIN ldoa_fields_groups AS g ON g.id = a.group_id LEFT JOIN `ldoa_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,:preparedArray3,:preparedArray4)) AND `a`.`access` IN (:preparedArray5,:preparedArray6)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (: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 ASC1.45ms6.19KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `field_id`,`value` FROM `ldoa_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7) AND `item_id` = :itemid275μs1.91KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `ldoa_content` AS `a` LEFT JOIN `ldoa_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC1.43ms2.16KBParams/plugins/content/pagenavigation/pagenavigation.php:186Copy
  • select catid from ldoa_content where id=135161μs856B/templates/echo/html/com_content/article/default.php:13Copy
  • select title from ldoa_categories where id=34180μs856B/templates/echo/html/com_content/article/default.php:15Copy
  • SHOW FULL COLUMNS FROM `ldoa_categories`517μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `ldoa_categories` WHERE `id` = '34'259μs4.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ldoa_tags` AS `t` INNER JOIN `ldoa_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)251μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT * FROM `ldoa_categories` WHERE `id` = '31'226μs4.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ldoa_tags` AS `t` INNER JOIN `ldoa_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)203μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • select content from ldoa_modules where id=101153μs856B/templates/echo/html/com_content/article/default.php:242Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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` FROM `ldoa_content` AS `a` LEFT JOIN `ldoa_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `ldoa_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `ldoa_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `ldoa_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `ldoa_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` = :categoryId AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.ordering ASC LIMIT 201.11ms40.91KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.* FROM `ldoa_contentitem_tag_map` AS `m` INNER JOIN `ldoa_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7) AND `t`.`access` IN (:preparedArray8,:preparedArray9)315μs6.03KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id123μs12.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id105μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id126μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id108μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id112μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id110μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id123μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `ldoa_modules` AS `m` LEFT JOIN `ldoa_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `ldoa_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`624μs2.25KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT manifest_cache FROM ldoa_extensions WHERE element='mod_djmegamenu' LIMIT 1369μs856B/modules/mod_djmegamenu/helpers/helper.php:404Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `ldoa_scheduler_tasks` AS `a` LEFT JOIN `ldoa_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now ORDER BY `a`.`title` asc442μs4.45KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `ldoa_scheduler_tasks` AS `a` LEFT JOIN `ldoa_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL ORDER BY `a`.`title` asc396μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy