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

Tyler Kozole, iDE Cambodia's WASH Program Director

As SIWI World Water Week 2024 kicks off in Stockholm this week, we are reminded of the profound importance of water and sanitation cooperation in fostering peace and security across the globe. This year's theme, "Bridging Borders: Water for a Peaceful and Sustainable Future," reminds us of the intricate interconnections between and across communities and nations and emphasizes the need for collaborative efforts to secure a better future for all. Ensuring that sanitation systems are robust and adaptable to climate challenges is not only essential for safeguarding public health but for promoting regional stability and sustainable development. The Climate Resilient Sanitation Coalition (CRSC) of more than 30 leading organizations that work at this intersection recognizes the significance of climate-resilient sanitation (CRS) in building a peaceful, secure, and sustainable future.

Article written by

Nasser is a Global WASH Manager at iDE working on ensuring iDE’s WASH programmes are inclusive, impactful and technically sound. He has over 12 years of multidisciplinary, multi-regional, and multilingual experiences in water and sanitation engineering research and innovation.

Over the past 15 years, Elise has worked in global health, from high-level advocacy to direct implementation; her focus lies at the intersection of health equity, gender, and climate, where she strives to influence programs and policies.  As Global WASH Director, she plays a pivotal role across iDE’s global portfolio by collaborating closely with colleagues to strengthen water, sanitation, and hygiene programming, research new approaches, and build partnerships to deepen impact and knowledge in the sector.

Share this article on

Reading Time: 5 min.

As climate change intensifies, traditional sanitation infrastructure is increasingly vulnerable to damage, disruption, and contamination as a result of extreme weather events, rising sea levels, and shifting precipitation patterns. Sanitation systems that not only endure these challenges but also contribute to climate mitigation efforts are critical for a climate-resilient future. CRS approaches are systems and practices designed to deliver safe and effective sanitation services that can withstand and adapt to the impacts of climate change. These approaches are vital for protecting public health, preserving environmental quality, and reducing greenhouse gas emissions.

Sanitation is closely linked to dignity and peace. Inadequate facilities can fuel conflict by intensifying competition for resources and triggering public health crises. We have seen this in India, where water contamination from poor sanitation has led to tensions and disputes between communities over access to clean water. Similarly, in refugee camps in Cox’s Bazar Bangladesh, where inadequate sanitation has caused disease outbreaks, worsening living conditions and heightening tensions among displaced populations and in conflicts such as Gaza where the destruction of water and sanitation systems allows once eradicated diseases such as Polio to resurface. Poor sanitation also undermines dignity and contributes to gender based violence, as seen throughout the world where women and sexual and gender minorities face risks of violence when accessing unsafe sanitation facilities. Conversely, CRS sanitation promotes health, dignity, well-being, and social and environmental stability, reducing the risk of conflict and fostering peaceful coexistence.

Climate-resilient sanitation offers significant benefits for peacebuilding — by reducing resource-based conflicts, stabilizing communities through improved public health, and empowering marginalized groups through better access. Ensuring that sanitation infrastructure can withstand climate impacts reduces the strain on water resources, thereby minimizing competition and potential conflicts over clean water access, especially in regions prone to droughts or flooding. Resilient sanitation systems promote good public health by preventing disease outbreaks and reducing the burden on healthcare systems, which fosters community stability. Resilient sanitation systems are key to empowering systemically marginalized groups, particularly women and children, by supporting their safety, dignity, well-being, and participation in community life, ultimately contributing to a more peaceful and inclusive society. Such approaches highlight the importance of broader systems thinking in CRS, where interconnected solutions address not just immediate needs but also long-term sustainability, social  inclusion and equity.

Climate resilient sanitation interventions play a demonstrably vital role in promoting peace. CRSC member iDE Global, supported the implementation of a Sky Latrine intervention in Cambodia to assist vulnerable communities around Lake Tonle Sap, who are severely affected by seasonal flooding. By providing elevated latrines as a safe and sustainable solution, the intervention has enhanced public health and reduced the risks of physical and sexual violence, especially for women and children who no longer have to leave the house to defecate outside at night. Social stigma and shame associated with not having access to a latrine has also been alleviated. This is one of many examples of climate and flood resistant toilets being designed to address both environmental challenges and social vulnerabilities. The lessons learned on peacebuilding through CRS infrastructure interventions need to be scaled up — lessons such as the value of community involvement, the need for adaptable designs and for systems approaches, and a core focus on equitable outcomes for all, particularly the most marginalized.

As climate change threatens global stability, stakeholders - governments, NGOs, funders, donors and communities must prioritize integration of CRS into global and national climate policies. By supporting national governments with tools, evidence, and expertise, we can embed CRS in government strategies,  plans and budgets. Elevating sanitation in climate discussions through active dissemination of evidence and real-world experiences is crucial, as is attracting finance to this sector to strengthen its role in stabilizing communities and reducing conflict. Building a robust evidence-base solidifies the case for CRS as a cornerstone of global peacebuilding and sustainability.

Now is the time for leadership and investment in climate resilient sanitation as a pathway to ensure a peaceful, sustainable and climate-resilient future for all. 

 


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.52MBMemory Usage46.85msRequest 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" => 1746976639 "last" => 1746976639...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (91.16KB) (709μs)
  • afterInitialise (1.1MB) (7.69ms)
  • afterRoute (100.35KB) (2.32ms)
  • beforeRenderComponent com_content (100.05KB) (1.18ms)
  • Before Access::preloadComponents (all components) (33.24KB) (269μs)
  • After Access::preloadComponents (all components) (113.12KB) (1.11ms)
  • Before Access::preloadPermissions (com_content) (1.57KB) (12μs)
  • After Access::preloadPermissions (com_content) (46.52KB) (426μs)
  • Before Access::getAssetRules (id:247 name:com_content.article.44) (1.15KB) (12μs)
  • After Access::getAssetRules (id:247 name:com_content.article.44) (8.57KB) (50μs)
  • afterRenderComponent com_content (712.2KB) (12.5ms)
  • afterDispatch (2.28KB) (55μs)
  • beforeRenderRawModule mod_tags_popular (Popular Topic Tags) (366.23KB) (2.01ms)
  • afterRenderRawModule mod_tags_popular (Popular Topic Tags) (112.02KB) (4.92ms)
  • beforeRenderRawModule mod_tags_popular (Popular Format Tags) (720B) (18μs)
  • afterRenderRawModule mod_tags_popular (Popular Format Tags) (33.15KB) (4.11ms)
  • beforeRenderRawModule mod_tags_popular (Popular Geographical Tags) (720B) (19μs)
  • afterRenderRawModule mod_tags_popular (Popular Geographical Tags) (33.82KB) (4.31ms)
  • beforeRenderRawModule mod_menu (Footer SuSanA Menu) (296B) (73μs)
  • afterRenderRawModule mod_menu (Footer SuSanA Menu) (50.4KB) (457μs)
  • beforeRenderModule mod_menu (Footer SuSanA Menu) (1.45KB) (102μs)
  • afterRenderModule mod_menu (Footer SuSanA Menu) (3.91KB) (90μs)
  • beforeRenderRawModule mod_custom (Prefooter - Publish hint) (1.7KB) (32μs)
  • afterRenderRawModule mod_custom (Prefooter - Publish hint) (3.83KB) (96μs)
  • beforeRenderModule mod_custom (Prefooter - Publish hint) (736B) (2μs)
  • afterRenderModule mod_custom (Prefooter - Publish hint) (3.17KB) (27μs)
  • beforeRenderModule mod_tags_popular (Popular Geographical Tags) (1.68KB) (22μs)
  • afterRenderModule mod_tags_popular (Popular Geographical Tags) (3.7KB) (15μs)
  • beforeRenderModule mod_tags_popular (Popular Format Tags) (472B) (16μs)
  • afterRenderModule mod_tags_popular (Popular Format Tags) (3.7KB) (14μs)
  • beforeRenderModule mod_tags_popular (Popular Topic Tags) (472B) (15μs)
  • afterRenderModule mod_tags_popular (Popular Topic Tags) (3.94KB) (12μs)
  • afterRender (214.59KB) (3.97ms)
  • 1 x afterRenderComponent com_content (712.2KB) (26.68%)
    12.50ms
    1 x afterInitialise (1.1MB) (16.41%)
    7.69ms
    1 x afterRenderRawModule mod_tags_popular (Popular Topic Tags) (112.02KB) (10.5%)
    4.92ms
    1 x afterRenderRawModule mod_tags_popular (Popular Geographical Tags) (33.82KB) (9.2%)
    4.31ms
    1 x afterRenderRawModule mod_tags_popular (Popular Format Tags) (33.15KB) (8.78%)
    4.11ms
    1 x afterRender (214.59KB) (8.48%)
    3.97ms
    1 x afterRoute (100.35KB) (4.96%)
    2.32ms
    1 x beforeRenderRawModule mod_tags_popular (Popular Topic Tags) (366.23KB) (4.29%)
    2.01ms
    1 x beforeRenderComponent com_content (100.05KB) (2.52%)
    1.18ms
    1 x After Access::preloadComponents (all components) (113.12KB) (2.36%)
    1.11ms
    1 x afterLoad (91.16KB) (1.51%)
    709μs
    1 x afterRenderRawModule mod_menu (Footer SuSanA Menu) (50.4KB) (0.98%)
    457μs
    1 x After Access::preloadPermissions (com_content) (46.52KB) (0.91%)
    426μs
    1 x Before Access::preloadComponents (all components) (33.24KB) (0.57%)
    269μs
    1 x beforeRenderModule mod_menu (Footer SuSanA Menu) (1.45KB) (0.22%)
    102μs
    1 x afterRenderRawModule mod_custom (Prefooter - Publish hint) (3.83KB) (0.21%)
    96μs
    1 x afterRenderModule mod_menu (Footer SuSanA Menu) (3.91KB) (0.19%)
    90μs
    1 x beforeRenderRawModule mod_menu (Footer SuSanA Menu) (296B) (0.16%)
    73μs
    1 x afterDispatch (2.28KB) (0.12%)
    55μs
    1 x After Access::getAssetRules (id:247 name:com_content.article.44) (8.57KB) (0.11%)
    50μs
    1 x beforeRenderRawModule mod_custom (Prefooter - Publish hint) (1.7KB) (0.07%)
    32μs
    1 x afterRenderModule mod_custom (Prefooter - Publish hint) (3.17KB) (0.06%)
    27μs
    1 x beforeRenderModule mod_tags_popular (Popular Geographical Tags) (1.68KB) (0.05%)
    22μs
    1 x beforeRenderRawModule mod_tags_popular (Popular Geographical Tags) (720B) (0.04%)
    19μs
    1 x beforeRenderRawModule mod_tags_popular (Popular Format Tags) (720B) (0.04%)
    18μs
    1 x beforeRenderModule mod_tags_popular (Popular Format Tags) (472B) (0.03%)
    16μs
    1 x afterRenderModule mod_tags_popular (Popular Geographical Tags) (3.7KB) (0.03%)
    15μ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%)
    14μs
    1 x afterRenderModule mod_tags_popular (Popular Topic Tags) (3.94KB) (0.03%)
    12μs
    1 x Before Access::preloadPermissions (com_content) (1.57KB) (0.03%)
    12μs
    1 x Before Access::getAssetRules (id:247 name:com_content.article.44) (1.15KB) (0.03%)
    12μs
    1 x beforeRenderModule mod_custom (Prefooter - Publish hint) (736B) (0%)
    2μs
42 statements were executed, 11 of which were duplicates, 31 unique20.18ms165.39KB
  • SELECT @@SESSION.sql_mode;75μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `ssblg_session` WHERE `session_id` = ?147μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `ssblg_session` WHERE `session_id` = :session_id LIMIT 1116μ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)145μ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` = 1212μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `ssblg_viewlevels`136μ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` = :guest139μ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`492μ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`282μ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`250μs3.86KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `ssblg_content` WHERE `alias` = :segment AND `catid` = :id168μs1.34KBParams/components/com_content/src/Service/Router.php:270Copy
  • SELECT * FROM `ssblg_languages` WHERE `published` = 1 ORDER BY `ordering` ASC126μ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` = 1178μ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)879μ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` = 0230μs3.23KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `ssblg_content`565μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `ssblg_content` SET `hits` = (`hits` + 1) WHERE `id` = '44'144μ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)314μ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`312μ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μs4.02KBParams/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`313μ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 ASC580μ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` = :itemid221μs3.88KBParams/administrator/components/com_fields/src/Model/FieldModel.php:739Copy
  • SELECT id AS value, name AS text FROM ssblg_contact_details ORDER BY name ASC154μ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 DESC388μ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`299μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `ssblg_contact_details` WHERE `id` = 34 ORDER BY `name` ASC151μs4.97KB/components/com_newsbox/src/Helper/SusanaHelper.php:107Copy
  • SELECT * FROM `ssblg_contact_details` WHERE `id` = 35 ORDER BY `name` ASC113μs4.97KB/components/com_newsbox/src/Helper/SusanaHelper.php:107Copy
  • SELECT `alias`,`catid` FROM ssblg_contact_details WHERE `id` = :key84μ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`250μ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`346μ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.06ms2.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.03ms5.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.78ms2.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.72ms2.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.88ms2.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.86ms2.55KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
  • SELECT * FROM `ssblg_schemaorg` WHERE `itemId` = :itemId AND `context` = :context126μ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)274μ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` = 1118μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `ssblg_session` WHERE `session_id` = ?115μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `ssblg_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?126μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy