Cookie tracking notice
Are we allowed to crumble with cookies and anonymous tracking?

We use cookies on our website. Some of them are essential for the operation of the site (so called session cookies), while others help us to improve this site and the user experience (tracking cookies). We use the application Matomo and the external service etracker to analyze your behavior on our website anonymously. Because we value your privacy, we are here with asking your permission to use the following technologies. You can change your settings any time via this link or the menu item in footer menu. For more information visit our Data Policy

© Water for Women and iDE Cambodia / Tyler Kozole

Despite the proven impact and interrelationship between sanitation and climate change, sanitation is still not part of the climate conversation. It must be, not only to ensure the resilience of the infrastructure, communities and the ecosystems which we depend on in the face of a global climate emergency, but also to harness effective and under-utilised greenhouse gas mitigation possibilities. 

Article written by

The Climate Resilient Sanitation Coalition (CRSC), formed in 2022, launched a Sanitation Call to Action last year at CoP27. The CRSC is a growing coalition of international organisations, global research organisations and practitioners in the fields of water and sanitation. Among its members are UNICEF, the World Bank, World Health Organization, the Bill and Melinda Gates Foundation, iDE, and many other research institutions and funds.

Share this article on

Reading Time: 6 min.

This year marks the critical halfway point to the finish line of many of our current global development goals and 2030 agendas, including Sustainable Development Goal 6 (SDG6) ‘Water and Sanitation for All’. Concerningly, over the past seven years we have seen SDG6, and sanitation in particular, being neglected in global and national climate policy and practice, resulting in stagnating progress and lack of resources and attention to this ‘cornerstone’ SDG.

We will not achieve SDG6, nor any of the interrelated national and international goals that are intrinsically linked to water and sanitation for all, without getting sanitation firmly on the global agenda and back on track.

Sanitation is not only about toilets

Globally, two out of every five people still lack safely managed sanitation.[1] This is defined as sanitation facilities that are not shared with other households and where excreta are safely disposed of in situ or transported and treated off-site. However, sanitation is not only about toilets and safe disposal of excreta, even though these are sorely lacking in many communities and households. Critically, it is also about managing increasing levels of sanitation-related pollution in our waterways, which is magnified through ever-increasing climate-related hazards, such as flooding and sea-level rise.

  • The impact is not only limited to humans. Entire ecosystems and other species suffer as a result of our inadequate sanitation systems.
  • Wetland and coastal areas including coral reefs are particularly vulnerable to the impacts of poorly managed sanitation, affecting the communities and ecosystems on which they, and we all, depend. If our waterways do not thrive, we cannot thrive.
  • Unmanaged sanitation is not only a contributor to poor health outcomes and the spread of diseases such as cholera, it is a major contributor to the climate crisis. Wastewater treatment is estimated to contribute at least 5% of global methane emissions [2] and there is emerging evidence that this may be an underestimate. These emissions largely stem from anaerobic digestion in pit latrines and septic tanks that are not frequently emptied, and from wastewater treatment plants lacking methane capture. Actively and safely managed sanitation can reduce these emissions.

An evidence-based call to action

The Climate Resilient Sanitation Coalition (CRSC), formed in 2022, launched a Sanitation Call to Action last year at CoP27. The CRSC is a growing coalition of international organisations, global research organisations and practitioners in the fields of water and sanitation. Among its members are UNICEF, the World Bank, World Health Organization, the Bill and Melinda Gates Foundation and many other research institutions and funds.

The messages from the Coalition are evidence-based and clear, directed at influencing national and global policy, investment and planning relating to water and sanitation and climate-resilient development.

  • Climate-resilient sanitation must be integrated in global and national climate policy and practice, and equally, climate resilience must be integrated into all sanitation investment and infrastructure.
  • Sanitation’s contribution to emissions is much more important than previously thought. More than 60% of the water supply and sanitation sector’s emissions are attributed to sanitation [3]. And while wastewater emissions have been predicted to contribute to around 5% of global methane emissions, this is likely an under-representation, as a recent study [4] showed high emissions from on-site systems, which are used extensively in low- and middle-income countries. This study showed that for Kampala, sanitation produced 189 kt CO2 equivalent per year and may represent more than half of total city-level emissions.
  • In the face of climate breakdown, extreme weather events play havoc with (non-climate-resilient) sanitation systems. During flooding events, sewage is released into combined stormwater systems, pit latrines collapse, and faecal contamination spreads. During droughts, sewers block, and pour-flush toilets do not work.
  • Actively managed sanitation improves climate resilience, while also reducing greenhouse emissions. There is no ‘magic bullet’, but including active management of sanitation systems in policy and resourcing is an efficient and effective way of addressing both climate and resilience goals.

Sanitation can be a climate solution


The Climate-Resilient Sanitation Coalition calls for a narrative shift; instead of seeing sanitation as a climate problem, we must all see increased and sustained investment in climate-resilient sanitation as a climate solution - because it is! It is a solution that has the power to both reduce emissions and increase the health, well-being and resilience of communities and the ecosystems on which we all depend.

How can you take action?

  • Read our Sanitation Call to Action.
  • Include climate resilience in sanitation policies, plans, budgets and services and increase political commitments, particularly to the poorest and most climate-affected communities.
  • Incorporate climate-resilient sanitation into National Adaptation Plans, National Biodiversity Strategies and Action Plans, and Nationally Determined Contributions and strengthen the climate rationale for investment.
  • Strengthen government systems and capacities to provide climate-resilient sanitation services.
  • Invest in and improve the evidence base for effective adaptation and emissions reduction in climate-resilient sanitation.
  • Develop and implement affordable, innovative, climate-resilient sanitation technologies and service models.

Sign up here for updates and resources from the CRSC. 


Tags

Share this page on

Share your experience in an own blog article

Do you have valuable insights or a unique perspective on WASH? We welcome article submissions from experts, researchers, practitioners, and anyone passionate about the field.

Make an impact and reach our global audience by contributing your article. Whether it's an innovative project, best practices, or personal stories, we value diverse perspectives. Join us in advancing the conversation and driving positive change in sustainable sanitation.

To submit your article or learn more about the process, contact us at info@susana.org

Settings3.498MBMemory Usage50.49msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.0
PHP Version8.3.14
Identityguest
Response200
Templatesusanablog
Database
Server
mysql
Version
8.0.41-32
Collation
utf8mb4_general_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:65 [ "MAGICK_C0DER_MODULE_PATH" => "/usr/local/php/lib64/ImageMagick-7.1.1/modules-Q16HDRI/c...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1748414722 "last" => 1748414722...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (91.27KB) (681μs)
  • afterInitialise (1.1MB) (8.3ms)
  • afterRoute (99.98KB) (2.34ms)
  • beforeRenderComponent com_content (100.54KB) (1.44ms)
  • Before Access::preloadComponents (all components) (33.16KB) (414μs)
  • After Access::preloadComponents (all components) (113.12KB) (589μs)
  • Before Access::preloadPermissions (com_content) (1.57KB) (12μs)
  • After Access::preloadPermissions (com_content) (47KB) (531μs)
  • Before Access::getAssetRules (id:231 name:com_content.article.28) (1.15KB) (13μs)
  • After Access::getAssetRules (id:231 name:com_content.article.28) (8.57KB) (50μs)
  • afterRenderComponent com_content (696.78KB) (13.53ms)
  • afterDispatch (2.28KB) (71μs)
  • beforeRenderRawModule mod_tags_popular (Popular Topic Tags) (363.54KB) (2.12ms)
  • afterRenderRawModule mod_tags_popular (Popular Topic Tags) (107.8KB) (5.3ms)
  • beforeRenderRawModule mod_tags_popular (Popular Format Tags) (720B) (25μs)
  • afterRenderRawModule mod_tags_popular (Popular Format Tags) (37.68KB) (4.52ms)
  • beforeRenderRawModule mod_tags_popular (Popular Geographical Tags) (720B) (25μs)
  • afterRenderRawModule mod_tags_popular (Popular Geographical Tags) (33.98KB) (4.55ms)
  • beforeRenderRawModule mod_menu (Footer SuSanA Menu) (296B) (79μs)
  • afterRenderRawModule mod_menu (Footer SuSanA Menu) (50.4KB) (492μs)
  • beforeRenderModule mod_menu (Footer SuSanA Menu) (88B) (117μs)
  • afterRenderModule mod_menu (Footer SuSanA Menu) (3.88KB) (112μs)
  • beforeRenderRawModule mod_custom (Prefooter - Publish hint) (1.7KB) (35μs)
  • afterRenderRawModule mod_custom (Prefooter - Publish hint) (3.83KB) (108μs)
  • beforeRenderModule mod_custom (Prefooter - Publish hint) (736B) (2μs)
  • afterRenderModule mod_custom (Prefooter - Publish hint) (3.17KB) (28μs)
  • beforeRenderModule mod_tags_popular (Popular Geographical Tags) (1.68KB) (22μs)
  • afterRenderModule mod_tags_popular (Popular Geographical Tags) (3.7KB) (16μs)
  • beforeRenderModule mod_tags_popular (Popular Format Tags) (472B) (16μs)
  • afterRenderModule mod_tags_popular (Popular Format Tags) (3.7KB) (13μs)
  • beforeRenderModule mod_tags_popular (Popular Topic Tags) (472B) (15μs)
  • afterRenderModule mod_tags_popular (Popular Topic Tags) (3.94KB) (12μs)
  • afterRender (214.66KB) (4.56ms)
  • 1 x afterRenderComponent com_content (696.78KB) (26.81%)
    13.53ms
    1 x afterInitialise (1.1MB) (16.45%)
    8.30ms
    1 x afterRenderRawModule mod_tags_popular (Popular Topic Tags) (107.8KB) (10.49%)
    5.30ms
    1 x afterRender (214.66KB) (9.04%)
    4.56ms
    1 x afterRenderRawModule mod_tags_popular (Popular Geographical Tags) (33.98KB) (9.01%)
    4.55ms
    1 x afterRenderRawModule mod_tags_popular (Popular Format Tags) (37.68KB) (8.96%)
    4.52ms
    1 x afterRoute (99.98KB) (4.64%)
    2.34ms
    1 x beforeRenderRawModule mod_tags_popular (Popular Topic Tags) (363.54KB) (4.2%)
    2.12ms
    1 x beforeRenderComponent com_content (100.54KB) (2.85%)
    1.44ms
    1 x afterLoad (91.27KB) (1.35%)
    681μs
    1 x After Access::preloadComponents (all components) (113.12KB) (1.17%)
    589μs
    1 x After Access::preloadPermissions (com_content) (47KB) (1.05%)
    531μs
    1 x afterRenderRawModule mod_menu (Footer SuSanA Menu) (50.4KB) (0.97%)
    492μs
    1 x Before Access::preloadComponents (all components) (33.16KB) (0.82%)
    414μs
    1 x beforeRenderModule mod_menu (Footer SuSanA Menu) (88B) (0.23%)
    117μs
    1 x afterRenderModule mod_menu (Footer SuSanA Menu) (3.88KB) (0.22%)
    112μs
    1 x afterRenderRawModule mod_custom (Prefooter - Publish hint) (3.83KB) (0.21%)
    108μs
    1 x beforeRenderRawModule mod_menu (Footer SuSanA Menu) (296B) (0.16%)
    79μs
    1 x afterDispatch (2.28KB) (0.14%)
    71μs
    1 x After Access::getAssetRules (id:231 name:com_content.article.28) (8.57KB) (0.1%)
    50μs
    1 x beforeRenderRawModule mod_custom (Prefooter - Publish hint) (1.7KB) (0.07%)
    35μs
    1 x afterRenderModule mod_custom (Prefooter - Publish hint) (3.17KB) (0.06%)
    28μs
    1 x beforeRenderRawModule mod_tags_popular (Popular Format Tags) (720B) (0.05%)
    25μs
    1 x beforeRenderRawModule mod_tags_popular (Popular Geographical Tags) (720B) (0.05%)
    25μs
    1 x beforeRenderModule mod_tags_popular (Popular Geographical Tags) (1.68KB) (0.04%)
    22μs
    1 x afterRenderModule mod_tags_popular (Popular Geographical Tags) (3.7KB) (0.03%)
    16μs
    1 x beforeRenderModule mod_tags_popular (Popular Format Tags) (472B) (0.03%)
    16μs
    1 x beforeRenderModule mod_tags_popular (Popular Topic Tags) (472B) (0.03%)
    15μs
    1 x afterRenderModule mod_tags_popular (Popular Format Tags) (3.7KB) (0.03%)
    13μs
    1 x Before Access::getAssetRules (id:231 name:com_content.article.28) (1.15KB) (0.03%)
    13μs
    1 x Before Access::preloadPermissions (com_content) (1.57KB) (0.02%)
    12μs
    1 x afterRenderModule mod_tags_popular (Popular Topic Tags) (3.94KB) (0.02%)
    12μs
    1 x beforeRenderModule mod_custom (Prefooter - Publish hint) (736B) (0%)
    2μs
41 statements were executed, 11 of which were duplicates, 30 unique20.95ms160.64KB
  • SELECT @@SESSION.sql_mode;77μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `ssblg_session` WHERE `session_id` = ?143μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `ssblg_session` WHERE `session_id` = :session_id LIMIT 1101μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `ssblg_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (:session_id, :guest, :time, :user_id, :username)147μs912BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `ssblg_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1230μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `ssblg_viewlevels`89μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `ssblg_usergroups` AS `a` LEFT JOIN `ssblg_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest184μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `ssblg_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`507μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • 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 `ssblg_menu` AS `m` LEFT JOIN `ssblg_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`305μs4.17KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • 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 `ssblg_categories` AS `s` INNER JOIN `ssblg_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`251μs3.86KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `ssblg_content` WHERE `alias` = :segment AND `catid` = :id169μs1.34KBParams/components/com_content/src/Service/Router.php:270Copy
  • SELECT * FROM `ssblg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC136μs1.59KB/libraries/src/Language/LanguageHelper.php:179Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `ssblg_template_styles` AS `s` LEFT JOIN `ssblg_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` = 1271μs848B/administrator/components/com_templates/src/Model/StyleModel.php:718Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `ssblg_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)317μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `ssblg_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0287μs3.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `ssblg_content`604μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `ssblg_content` SET `hits` = (`hits` + 1) WHERE `id` = '28'138μs1.3KB/libraries/src/Table/Table.php:1348Copy
  • 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 `ssblg_content` AS `a` INNER JOIN `ssblg_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `ssblg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `ssblg_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `ssblg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `ssblg_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)369μs22.13KBParams/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 `ssblg_categories` AS `s` INNER JOIN `ssblg_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`395μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `ssblg_contentitem_tag_map` AS `m` INNER JOIN `ssblg_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)271μs4KBParams/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 `ssblg_categories` AS `s` INNER JOIN `ssblg_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`315μs3.91KBParams/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 ssblg_fields AS a LEFT JOIN `ssblg_languages` AS l ON l.lang_code = a.language LEFT JOIN ssblg_users AS uc ON uc.id=a.checked_out LEFT JOIN ssblg_viewlevels AS ag ON ag.id = a.access LEFT JOIN ssblg_users AS ua ON ua.id = a.created_user_id LEFT JOIN ssblg_fields_groups AS g ON g.id = a.group_id LEFT JOIN `ssblg_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)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) 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 ASC583μs21.19KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `field_id`,`value` FROM `ssblg_fields_values` WHERE `field_id` 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) AND `item_id` = :itemid227μs3.86KBParams/administrator/components/com_fields/src/Model/FieldModel.php:739Copy
  • SELECT id AS value, name AS text FROM ssblg_contact_details ORDER BY name ASC162μs1.31KB/plugins/fields/sql/tmpl/sql.php:38Copy
  • 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 `ssblg_content` AS `a` LEFT JOIN `ssblg_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 DESC374μs2.34KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:205Copy
  • 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 `ssblg_categories` AS `s` INNER JOIN `ssblg_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`315μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `ssblg_contact_details` WHERE `id` = 15 ORDER BY `name` ASC207μs4.97KB/components/com_newsbox/src/Helper/SusanaHelper.php:107Copy
  • SELECT `alias`,`catid` FROM ssblg_contact_details WHERE `id` = :key130μs1.35KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • 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 `ssblg_categories` AS `s` INNER JOIN `ssblg_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`315μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `ssblg_modules` AS `m` LEFT JOIN `ssblg_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `ssblg_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`405μs1.97KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `ssblg_contentitem_tag_map` AS `m` INNER JOIN `ssblg_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `ssblg_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `ssblg_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `ssblg_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `t`.`parent_id` IN (:preparedArray3) AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray4,:preparedArray5) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 52.18ms2.55KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `ssblg_contentitem_tag_map` AS `m` INNER JOIN `ssblg_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `ssblg_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `ssblg_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `ssblg_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `t`.`parent_id` IN (:preparedArray3) AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray4,:preparedArray5) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 52.16ms2.55KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `ssblg_contentitem_tag_map` AS `m` INNER JOIN `ssblg_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `ssblg_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `ssblg_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `ssblg_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `t`.`parent_id` IN (:preparedArray3) AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray4,:preparedArray5) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 51.95ms5.05KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `ssblg_contentitem_tag_map` AS `m` INNER JOIN `ssblg_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `ssblg_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `ssblg_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `ssblg_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `t`.`parent_id` IN (:preparedArray3) AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray4,:preparedArray5) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 51.83ms2.55KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `ssblg_contentitem_tag_map` AS `m` INNER JOIN `ssblg_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `ssblg_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `ssblg_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `ssblg_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `t`.`parent_id` IN (:preparedArray3) AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray4,:preparedArray5) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 51.94ms2.55KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `ssblg_contentitem_tag_map` AS `m` INNER JOIN `ssblg_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `ssblg_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `ssblg_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `ssblg_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `t`.`parent_id` IN (:preparedArray3) AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray4,:preparedArray5) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 51.96ms2.55KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
  • SELECT * FROM `ssblg_schemaorg` WHERE `itemId` = :itemId AND `context` = :context141μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:406Copy
  • 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 `ssblg_content` AS `a` INNER JOIN `ssblg_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `ssblg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `ssblg_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `ssblg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `ssblg_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)332μs22.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `ssblg_scheduler_tasks` AS `a` WHERE `a`.`state` = 1172μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `ssblg_session` WHERE `session_id` = ?111μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `ssblg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?145μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy