Courses for Policy, Projects & Programmes

Policy Evaluation

Overview

This two-day training course provides participants with a comprehensive understanding of policy evaluation and the various types of evidence used in the evaluation process. On Day One, participants will explore the concept of policy evaluation, its importance, and its role in evidence-based policy. They will delve into establishing a theory of change, understanding different types of evidence such as systematic reviews, surveys, qualitative methods, interrupted time series analysis, and more. Day Two focuses on additional types of evidence, including single group before and after designs, matched comparison designs, difference-in-difference analysis, regression discontinuity design, randomised controlled trials, implementation evaluation, and economic appraisal. The course also covers practical aspects of presenting evaluation evidence, including structuring reports, writing in non-technical language, and delivering key messages to policy makers. By the end of the training, participants will have a solid foundation in policy evaluation and be equipped with the knowledge and skills to conduct robust evaluations and effectively communicate their findings to stakeholders.

Learning Objectives

  1. Understand the importance and purpose of policy evaluation, including its role in evidence-based policy making and decision-making processes.

  2. Identify and differentiate between various types of evidence used in policy evaluation, such as systematic reviews, surveys, qualitative methods, interrupted time series analysis, matched comparison designs, regression discontinuity design, randomised controlled trials, implementation evaluation, and economic appraisal.

  3. Gain proficiency in establishing a theory of change and developing logical models that depict causal chains for policy interventions.

  4. Evaluate the strengths, limitations, and potential biases associated with different types of evidence used in policy evaluation, enabling informed decision-making regarding their suitability for specific evaluation contexts.

  5. Acquire practical knowledge and skills in data collection methods, including surveys, census data, administrative data, qualitative methods (e.g., interviews, focus groups), and observational techniques, for conducting policy evaluations.

  6. Develop effective communication strategies for presenting evaluation evidence to policy makers, including structuring reports, writing in non-technical language, and delivering key messages that address policy background, problem description, policy options, implementation issues, resource implications, and recommendations.

 



Course Agenda

Day One

Policy Evaluations – What Are They and Why Do We Need Them

  • What do participants understand by policy evaluation?
  • This two-day training course provides participants with a comprehensive understanding of policy evaluation and the various types of evidence used in the evaluation process. On Day One, participants will explore the concept of policy evaluation, its importance, and its role in evidence-based policy. They will delve into establishing a theory of change, understanding different types of evidence such as systematic reviews, surveys, qualitative methods, interrupted time series analysis, and more. Day Two focuses on additional types of evidence, including single group before and after designs, matched comparison designs, difference-in-difference analysis, regression discontinuity design, randomized controlled trials, implementation evaluation, and economic appraisal. The course also covers practical aspects of presenting evaluation evidence, including structuring reports, writing in non-technical language, and delivering key messages to policy makers. By the end of the training, participants will have a solid foundation in policy evaluation and be equipped with the knowledge and skills to conduct robust evaluations and effectively communicate their findings to stakeholders.
  • What is evaluation and why is it essential?
  • Policy evaluation and evidence-based policy
  • What factors affect how a policy should be evaluated?
  • Evaluation as part of the policy cycle
  • The Magenta Book

Types of Evidence - Establishing a Theory of Change

  • Activities, Outputs, Outcomes
  • Sequencing a logic model – building a causal chain
  • Data required for a theory of change
  • Case Study

Types of Evidence – Systematic Reviews and Meta-Analysis

  • Harnessing what is already known
  • Different types of research synthesis
  • The structure of a systematic review
  • Examples of Statistical Meta-Analysis for Policy Making
  • Sources of sound evidence from systematic reviews

Types of Evidence for Policy Evaluation – Surveys, Census Data and Administrative Data

  • Using existing survey data
  • Collecting survey data Using census data
  • The use of administrative data
  • Risk of bias with surveys, census data and administrative data

Types of Evidence for Policy Evaluation – Qualitative Methods and Data

  • In-Depth interviews
  • Group interviews and focus groups
  • Other consultative methods
  • Observational and Participant –Observation methods
  • Ethnography
  • Case Studies
  • Quality of Qualitative Evaluation
  • The contribution of qualitative data to policy making

Establishing a Strong Counterfactual

  • The importance of the counterfactual for policy making
  • Identifying policy options
  • Establishing the net effect of a policy

Types of Evidence for Policy Evaluation – Interrupted Time Series Analysis

  • The logic of Interrupted Time Series Analysis
  • Examples of Interrupted Time Series Analysis
  • Risk of bias with Interrupted Time Series Analysis
  • Examples of Interrupted Time Series Analysis in policy evaluation

Day Two

Types of Evidence for Policy Evaluation – Single Group Before and After Designs

  • The logic of a single group before and after design
  • Examples of a single group before and after design
  • Risk of bias with a single group before and after design

Types of Evidence for Policy Evaluation – Matched Comparison Designs

  • The principles of matching
  • Propensity Score Matching
  • Examples of Propensity Score Matching for policy making
  • Risk of bias with Propensity Score Matching

Types of Evidence for Policy Evaluation – Difference-in-Difference Analysis

  • Single difference and double difference
  • Risk of bias with difference-in-difference analysis
  • Examples of difference-in-difference analysis in policy making

Types of Evidence for Policy Evaluation – Regression Discontinuity Design

  • The logic of regression discontinuity design
  • Examples of regression discontinuity design in policy making
  • Risk of bias with regression discontinuity design

Types of Evidence for Policy Evaluation - Randomised Controlled Trials

  • How RCTs establish a strong counterfactual
  • Risk of bias with RCTs
  • Examples of RCTs in policy making

Types of Evidence for Policy Evaluation – Implementation Evaluation

  • Delivery Trajectories
  • Developing a Delivery Plan
  • Undertaking a Priority Review

Types of Evidence for Policy Evaluation – Economic Appraisal

  • The Green Book
  • Cost-Benefit, Cost-Effectiveness and Cost-Utility Analysis
  • Monetising cost and benefits
  • Establishing New Present Value and Equivalent Annual Net Cost to Business

Presenting Evaluation Evidence

  • The 1:3:25 format
  • Writing clearly in non-technical language
  • The Title
  • Key messages for policy makers (one page)
  • Executive Summary (three pages)
  • Policy background and context
  • Problem description
  • Policy options
  • Implementation and delivery issues
  • Resource implications
  • Conclusions and recommendations

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

Contact Us

5MBMemory Usage166msRequest 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" => 1743209213 "last" => 1743209213...
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.6ms)
  • afterInitialise (882.16KB) (31.77ms)
  • afterRoute (380.72KB) (9.3ms)
  • beforeRenderComponent com_content (99.57KB) (6.34ms)
  • Before Access::preloadComponents (all components) (105.68KB) (3.67ms)
  • After Access::preloadComponents (all components) (115.83KB) (1.04ms)
  • Before Access::preloadPermissions (com_content) (2.76KB) (33μs)
  • After Access::preloadPermissions (com_content) (58.01KB) (605μs)
  • Before Access::getAssetRules (id:98 name:com_content.article.90) (6.8KB) (29μs)
  • After Access::getAssetRules (id:98 name:com_content.article.90) (8.47KB) (352μs)
  • Before Access::getAssetRules (id:8 name:com_content) (761.81KB) (49.39ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (23μs)
  • afterRenderComponent com_content (134.15KB) (5.3ms)
  • afterDispatch (2.28KB) (265μs)
  • beforeRenderRawModule mod_custom (Social Options) (443.59KB) (4.06ms)
  • afterRenderRawModule mod_custom (Social Options) (4.12KB) (1.32ms)
  • beforeRenderModule mod_custom (Social Options) (720B) (8μs)
  • afterRenderModule mod_custom (Social Options) (4.36KB) (270μs)
  • beforeRenderRawModule mod_custom (Footer) (360B) (58μs)
  • afterRenderRawModule mod_custom (Footer) (928B) (267μs)
  • beforeRenderModule mod_custom (Footer) (704B) (4μs)
  • afterRenderModule mod_custom (Footer) (3.16KB) (105μs)
  • beforeRenderRawModule mod_custom (Contact CTA) (328B) (33μs)
  • afterRenderRawModule mod_custom (Contact CTA) (960B) (231μs)
  • beforeRenderModule mod_custom (Contact CTA) (720B) (3μs)
  • afterRenderModule mod_custom (Contact CTA) (2.52KB) (100μs)
  • beforeRenderRawModule mod_djmegamenu (DJ-MegaMenu) (8.02KB) (59μs)
  • afterRenderRawModule mod_djmegamenu (DJ-MegaMenu) (608.04KB) (18.31ms)
  • beforeRenderModule mod_djmegamenu (DJ-MegaMenu) (720B) (26μs)
  • afterRenderModule mod_djmegamenu (DJ-MegaMenu) (22.3KB) (234μs)
  • beforeRenderRawModule mod_menu (All Page) (6.59KB) (49μs)
  • afterRenderRawModule mod_menu (All Page) (4.28KB) (962μs)
  • beforeRenderModule mod_menu (All Page) (704B) (10μs)
  • afterRenderModule mod_menu (All Page) (4.15KB) (117μs)
  • beforeRenderRawModule mod_search (Search our courses) (1.2KB) (79μs)
  • afterRenderRawModule mod_search (Search our courses) (14.23KB) (1.24ms)
  • beforeRenderModule mod_search (Search our courses) (720B) (8μs)
  • afterRenderModule mod_search (Search our courses) (3.05KB) (125μs)
  • afterRender (264.65KB) (9.99ms)
  • 1 x Before Access::getAssetRules (id:8 name:com_content) (761.81KB) (29.76%)
    49.39ms
    1 x afterInitialise (882.16KB) (19.14%)
    31.77ms
    1 x afterRenderRawModule mod_djmegamenu (DJ-MegaMenu) (608.04KB) (11.03%)
    18.31ms
    1 x afterRender (264.65KB) (6.02%)
    9.99ms
    1 x afterLoad (539.8KB) (5.79%)
    9.60ms
    1 x afterRoute (380.72KB) (5.6%)
    9.30ms
    1 x beforeRenderComponent com_content (99.57KB) (3.82%)
    6.34ms
    1 x afterRenderComponent com_content (134.15KB) (3.19%)
    5.30ms
    1 x beforeRenderRawModule mod_custom (Social Options) (443.59KB) (2.45%)
    4.06ms
    1 x Before Access::preloadComponents (all components) (105.68KB) (2.21%)
    3.67ms
    1 x afterRenderRawModule mod_custom (Social Options) (4.12KB) (0.8%)
    1.32ms
    1 x afterRenderRawModule mod_search (Search our courses) (14.23KB) (0.75%)
    1.24ms
    1 x After Access::preloadComponents (all components) (115.83KB) (0.63%)
    1.04ms
    1 x afterRenderRawModule mod_menu (All Page) (4.28KB) (0.58%)
    962μs
    1 x After Access::preloadPermissions (com_content) (58.01KB) (0.36%)
    605μs
    1 x After Access::getAssetRules (id:98 name:com_content.article.90) (8.47KB) (0.21%)
    352μs
    1 x afterRenderModule mod_custom (Social Options) (4.36KB) (0.16%)
    270μs
    1 x afterRenderRawModule mod_custom (Footer) (928B) (0.16%)
    267μs
    1 x afterDispatch (2.28KB) (0.16%)
    265μs
    1 x afterRenderModule mod_djmegamenu (DJ-MegaMenu) (22.3KB) (0.14%)
    234μs
    1 x afterRenderRawModule mod_custom (Contact CTA) (960B) (0.14%)
    231μs
    1 x afterRenderModule mod_search (Search our courses) (3.05KB) (0.08%)
    125μs
    1 x afterRenderModule mod_menu (All Page) (4.15KB) (0.07%)
    117μs
    1 x afterRenderModule mod_custom (Footer) (3.16KB) (0.06%)
    105μs
    1 x afterRenderModule mod_custom (Contact CTA) (2.52KB) (0.06%)
    100μs
    1 x beforeRenderRawModule mod_search (Search our courses) (1.2KB) (0.05%)
    79μs
    1 x beforeRenderRawModule mod_djmegamenu (DJ-MegaMenu) (8.02KB) (0.04%)
    59μs
    1 x beforeRenderRawModule mod_custom (Footer) (360B) (0.03%)
    58μs
    1 x beforeRenderRawModule mod_menu (All Page) (6.59KB) (0.03%)
    49μs
    1 x Before Access::preloadPermissions (com_content) (2.76KB) (0.02%)
    33μs
    1 x beforeRenderRawModule mod_custom (Contact CTA) (328B) (0.02%)
    33μs
    1 x Before Access::getAssetRules (id:98 name:com_content.article.90) (6.8KB) (0.02%)
    29μ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%)
    23μs
    1 x beforeRenderModule mod_menu (All Page) (704B) (0.01%)
    10μs
    1 x beforeRenderModule mod_search (Search our courses) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Social Options) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Footer) (704B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Contact CTA) (720B) (0%)
    3μs
45 statements were executed, 2 of which were duplicates, 43 unique19.99ms342.66KB
  • SELECT @@SESSION.sql_mode;151μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `ldoa_session` WHERE `session_id` = ?326μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `ldoa_session` WHERE `session_id` = :session_id LIMIT 1132μ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.2ms944BParams/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` = 1421μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `ldoa_viewlevels`111μ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` = :guest153μ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`677μ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.22ms136.3KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `ldoa_languages` WHERE `published` = 1 ORDER BY `ordering` ASC252μ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` = 1311μ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)527μ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` = 0276μs3.55KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `ldoa_content`479μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `ldoa_content` SET `hits` = (`hits` + 1) WHERE `id` = '90'213μ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)693μ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`573μ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)452μ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`642μ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.38ms6.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` = :itemid264μs1.92KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • 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 WHERE ( (`a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) ORDER BY a.ordering ASC1.53ms5.53KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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.29ms2.19KBParams/plugins/content/pagenavigation/pagenavigation.php:186Copy
  • select catid from ldoa_content where id=90108μs856B/templates/echo/html/com_content/article/default.php:13Copy
  • select title from ldoa_categories where id=26159μs856B/templates/echo/html/com_content/article/default.php:15Copy
  • SHOW FULL COLUMNS FROM `ldoa_categories`466μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `ldoa_categories` WHERE `id` = '26'294μ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)286μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT * FROM `ldoa_categories` WHERE `id` = '24'222μ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)224μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • 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 20915μs56.94KBParams/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,:preparedArray8,:preparedArray9) AND `t`.`access` IN (:preparedArray10,:preparedArray11)327μs6.09KBParams/libraries/src/Helper/TagsHelper.php:448Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id101μs12.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id87μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id70μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id65μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id64μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id73μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id63μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id72μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ldoa_content` WHERE `id` = :id68μ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`619μs2.25KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT manifest_cache FROM ldoa_extensions WHERE element='mod_djmegamenu' LIMIT 1364μ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` asc578μ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` asc492μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy