Cultural astronomy

Archaeoastronomy is the study of beliefs and practices relating to the sky in the past, especially in prehistory, and the uses to which people’s knowledge of the skies was put.

       
Journals, present and past

Cultural astronomy is the combination of archaeoastronomy and ethnoastronomy, which relates to contemporary cultures.


Professional bodies

The 3-volume Springer Handbook contains 217 chapters on themes, issues, methods and practice, and case studies by authors from around the world.

You might also be interested in some of the materials to be found on cultural-astronomy.com.

Publications

         

The lists of my books and selected papers and articles contain links and downloadable copies where available.

A new book on Stonehenge

is now published!

“This beautifully illustrated book shines new light on this most famous of ancient monuments, and is the first in-depth study of this fascinating topic suitable both for specialists and for anyone with a general interest.”

Read more: A new book on Stonehenge

Preserving dark skies

A newly published IUCN report focuses on preserving natural darkness for nature protection, heritage conservation and night sky appreciation.

Read more: Preserving dark skies

Four new astronomically related properties were inscribed on the World Heritage List in 2023

Read more: Four new astronomical World Heritage Sites

About me

I am Emeritus Professor of Archaeoastronomy in the School of Archaeology and Ancient History at the University of Leicester, UK.

Read more: About me

Astronomical heritage

The UNESCO–IAU Portal to the Heritage of Astronomy contains a wide range of examples of different types of astronomical heritage together with information relevant to its protection, conservation, evaluation, management and promotion.

The two ICOMOS–IAU Thematic Studies on Astronomical Heritage address key issues on a global scale through thematic essays and case studies.

No. 1 (2010): See here for more information or click here to download a copy

No. 2 (2017): See here for more information or click here to download a copy

Astronomical World Heritage: Download a copy of an article published in A&G (Aug 2019)

Alice Ruggles Trust

If you are looking for things related to Alice and/or information about stalking, please visit the Alice Ruggles Trust website

J! InfoRequestSessionProfileQueries27
Settings17.499MBMemory Usage979msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.0
PHP Version8.2.27
Identityguest
Response200
Templatecassiopeia_cliveruggles_com
Database
Server
mysql
Version
10.11.11-MariaDB-log
Collation
utf8mb4_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:62 [ "PATH" => "C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1746130210 "last" => 1746130210...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.56MB) (90.31ms)
  • afterInitialise (7.13MB) (350ms)
  • afterRoute (139.48KB) (8.4ms)
  • beforeRenderComponent com_content (1020.98KB) (46.9ms)
  • Before Access::preloadComponents (all components) (973.52KB) (45.13ms)
  • After Access::preloadComponents (all components) (110.21KB) (1.41ms)
  • Before Access::getAssetRules (id:8 name:com_content) (56B) (21μs)
  • After Access::getAssetRules (id:8 name:com_content) (26.06KB) (1.71ms)
  • afterRenderComponent com_content (2.92MB) (349ms)
  • afterDispatch (4.52KB) (1ms)
  • beforeRenderRawModule mod_custom (Cultural astronomy) (571.44KB) (28.12ms)
  • afterRenderRawModule mod_custom (Cultural astronomy) (35.7KB) (9.18ms)
  • beforeRenderRawModule mod_custom (Publications) (720B) (102μs)
  • afterRenderRawModule mod_custom (Publications) (1.39KB) (959μs)
  • beforeRenderRawModule mod_custom (Astronomical heritage) (736B) (109μs)
  • afterRenderRawModule mod_custom (Astronomical heritage) (912B) (801μs)
  • beforeRenderRawModule mod_custom (Alice Ruggles Trust) (720B) (83μs)
  • afterRenderRawModule mod_custom (Alice Ruggles Trust) (2.02KB) (772μs)
  • beforeRenderRawModule mod_menu (Menu) (4.41KB) (1.42ms)
  • afterRenderRawModule mod_menu (Menu) (273.61KB) (12.13ms)
  • beforeRenderRawModule mod_custom (Footer) (1.09KB) (83μs)
  • afterRenderRawModule mod_custom (Footer) (944B) (329μs)
  • beforeRenderModule mod_custom (Footer) (2.4KB) (3.41ms)
  • afterRenderModule mod_custom (Footer) (15.28KB) (3.37ms)
  • beforeRenderModule mod_custom (Astronomical heritage) (488B) (62μs)
  • afterRenderModule mod_custom (Astronomical heritage) (7.95KB) (1.18ms)
  • beforeRenderModule mod_custom (Alice Ruggles Trust) (864B) (28μs)
  • afterRenderModule mod_custom (Alice Ruggles Trust) (3.06KB) (196μs)
  • beforeRenderModule mod_custom (Cultural astronomy) (NANB) (107μs)
  • afterRenderModule mod_custom (Cultural astronomy) (6.44KB) (189μs)
  • beforeRenderModule mod_custom (Publications) (864B) (23μs)
  • afterRenderModule mod_custom (Publications) (4.94KB) (183μs)
  • beforeRenderModule mod_menu (Menu) (2.8KB) (54μs)
  • afterRenderModule mod_menu (Menu) (5.67KB) (112μs)
  • afterRender (316.54KB) (18.37ms)
  • 1 x afterInitialise (7.13MB) (35.77%)
    350ms
    1 x afterRenderComponent com_content (2.92MB) (35.64%)
    349ms
    1 x afterLoad (3.56MB) (9.23%)
    90.31ms
    1 x beforeRenderComponent com_content (1020.98KB) (4.79%)
    46.90ms
    1 x Before Access::preloadComponents (all components) (973.52KB) (4.61%)
    45.13ms
    1 x beforeRenderRawModule mod_custom (Cultural astronomy) (571.44KB) (2.87%)
    28.12ms
    1 x afterRender (316.54KB) (1.88%)
    18.37ms
    1 x afterRenderRawModule mod_menu (Menu) (273.61KB) (1.24%)
    12.13ms
    1 x afterRenderRawModule mod_custom (Cultural astronomy) (35.7KB) (0.94%)
    9.18ms
    1 x afterRoute (139.48KB) (0.86%)
    8.40ms
    1 x beforeRenderModule mod_custom (Footer) (2.4KB) (0.35%)
    3.41ms
    1 x afterRenderModule mod_custom (Footer) (15.28KB) (0.34%)
    3.37ms
    1 x After Access::getAssetRules (id:8 name:com_content) (26.06KB) (0.17%)
    1.71ms
    1 x beforeRenderRawModule mod_menu (Menu) (4.41KB) (0.15%)
    1.42ms
    1 x After Access::preloadComponents (all components) (110.21KB) (0.14%)
    1.41ms
    1 x afterRenderModule mod_custom (Astronomical heritage) (7.95KB) (0.12%)
    1.18ms
    1 x afterDispatch (4.52KB) (0.1%)
    1.00ms
    1 x afterRenderRawModule mod_custom (Publications) (1.39KB) (0.1%)
    959μs
    1 x afterRenderRawModule mod_custom (Astronomical heritage) (912B) (0.08%)
    801μs
    1 x afterRenderRawModule mod_custom (Alice Ruggles Trust) (2.02KB) (0.08%)
    772μs
    1 x afterRenderRawModule mod_custom (Footer) (944B) (0.03%)
    329μs
    1 x afterRenderModule mod_custom (Alice Ruggles Trust) (3.06KB) (0.02%)
    196μs
    1 x afterRenderModule mod_custom (Cultural astronomy) (6.44KB) (0.02%)
    189μs
    1 x afterRenderModule mod_custom (Publications) (4.94KB) (0.02%)
    183μs
    1 x afterRenderModule mod_menu (Menu) (5.67KB) (0.01%)
    112μs
    1 x beforeRenderRawModule mod_custom (Astronomical heritage) (736B) (0.01%)
    109μs
    1 x beforeRenderModule mod_custom (Cultural astronomy) (NANB) (0.01%)
    107μs
    1 x beforeRenderRawModule mod_custom (Publications) (720B) (0.01%)
    102μs
    1 x beforeRenderRawModule mod_custom (Alice Ruggles Trust) (720B) (0.01%)
    83μs
    1 x beforeRenderRawModule mod_custom (Footer) (1.09KB) (0.01%)
    83μs
    1 x beforeRenderModule mod_custom (Astronomical heritage) (488B) (0.01%)
    62μs
    1 x beforeRenderModule mod_menu (Menu) (2.8KB) (0.01%)
    54μs
    1 x beforeRenderModule mod_custom (Alice Ruggles Trust) (864B) (0%)
    28μs
    1 x beforeRenderModule mod_custom (Publications) (864B) (0%)
    23μs
    1 x Before Access::getAssetRules (id:8 name:com_content) (56B) (0%)
    21μs
27 statements were executed, 6 of which were duplicates, 21 unique310ms162.41KB
UniquesDuplicates 1Duplicates 2Duplicates 3
  • SELECT @@SESSION.sql_mode;167μs968B\libraries\vendor\joomla\database\src\Mysqli\MysqliDriver.php:259Copy
  • SELECT `data` FROM `cms_session` WHERE `session_id` = ?318μs1008BParams\libraries\vendor\joomla\session\src\Handler\DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `cms_session` WHERE `session_id` = :session_id LIMIT 1305μs1.3KBParams\libraries\src\Session\MetadataManager.php:187Copy
  • INSERT INTO `cms_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)50.18ms944BParams\libraries\src\Session\MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `cms_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 118.94ms1.61KB\libraries\src\Component\ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `cms_viewlevels`273μs656B\libraries\src\Access\Access.php:955Copy
  • SELECT `b`.`id` FROM `cms_usergroups` AS `a` LEFT JOIN `cms_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest372μs1.33KBParams\libraries\src\Access\Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `cms_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`1.59ms3.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 `cms_menu` AS `m` LEFT JOIN `cms_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`967μs20.3KBParams\libraries\src\Menu\SiteMenu.php:166Copy
  • SELECT * FROM `cms_languages` WHERE `published` = 1 ORDER BY `ordering` ASC334μs1.59KB\libraries\src\Language\LanguageHelper.php:179Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `cms_template_styles` AS `s` LEFT JOIN `cms_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` = 1535μs848B\administrator\components\com_templates\src\Model\StyleModel.php:718Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `cms_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)797μs7.31KBParams\libraries\src\Access\Access.php:357Copy
  • 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`,`fp`.`ordering` FROM `cms_content` AS `a` LEFT JOIN `cms_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `cms_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `cms_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `cms_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` INNER JOIN `cms_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` WHERE (`fp`.`featured_up` IS NULL OR `fp`.`featured_up` <= :frontpageUp) AND (`fp`.`featured_down` IS NULL OR `fp`.`featured_down` >= :frontpageDown) AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition 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.featured DESC, fp.ordering, CASE WHEN a.publish_up IS NULL THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 1338.87ms39.03KBParams\libraries\src\MVC\Model\BaseDatabaseModel.php:164Copy
  • SELECT COUNT(*) FROM `cms_content` AS `a` LEFT JOIN `cms_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `cms_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `cms_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `cms_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` INNER JOIN `cms_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` WHERE (`fp`.`featured_up` IS NULL OR `fp`.`featured_up` <= :frontpageUp) AND (`fp`.`featured_down` IS NULL OR `fp`.`featured_down` >= :frontpageDown) AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)760μs5.59KBParams\libraries\src\MVC\Model\BaseDatabaseModel.php:197Copy
  • 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 `cms_categories` AS `s` INNER JOIN `cms_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`773μs3.92KBParams\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 cms_fields AS a LEFT JOIN `cms_languages` AS l ON l.lang_code = a.language LEFT JOIN cms_users AS uc ON uc.id=a.checked_out LEFT JOIN cms_viewlevels AS ag ON ag.id = a.access LEFT JOIN cms_users AS ua ON ua.id = a.created_user_id LEFT JOIN cms_fields_groups AS g ON g.id = a.group_id LEFT JOIN `cms_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)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) 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 ASC27.89ms4.81KBParams\libraries\src\MVC\Model\BaseDatabaseModel.php:164Copy
  • 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 `cms_categories` AS `s` INNER JOIN `cms_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`850μs5.16KBParams\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 cms_fields AS a LEFT JOIN `cms_languages` AS l ON l.lang_code = a.language LEFT JOIN cms_users AS uc ON uc.id=a.checked_out LEFT JOIN cms_viewlevels AS ag ON ag.id = a.access LEFT JOIN cms_users AS ua ON ua.id = a.created_user_id LEFT JOIN cms_fields_groups AS g ON g.id = a.group_id LEFT JOIN `cms_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 ASC32.03ms4.75KBParams\libraries\src\MVC\Model\BaseDatabaseModel.php:164Copy
  • 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 `cms_categories` AS `s` INNER JOIN `cms_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`896μ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 cms_fields AS a LEFT JOIN `cms_languages` AS l ON l.lang_code = a.language LEFT JOIN cms_users AS uc ON uc.id=a.checked_out LEFT JOIN cms_viewlevels AS ag ON ag.id = a.access LEFT JOIN cms_users AS ua ON ua.id = a.created_user_id LEFT JOIN cms_fields_groups AS g ON g.id = a.group_id LEFT JOIN `cms_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 ASC61.92ms4.75KBParams\libraries\src\MVC\Model\BaseDatabaseModel.php:164Copy
  • 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 `cms_categories` AS `s` INNER JOIN `cms_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`906μs3.92KBParams\libraries\src\Categories\Categories.php:375Copy
  • 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 `cms_categories` AS `s` INNER JOIN `cms_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`761μs3.91KBParams\libraries\src\Categories\Categories.php:375Copy
  • 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 `cms_categories` AS `s` INNER JOIN `cms_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`682μ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 `cms_modules` AS `m` LEFT JOIN `cms_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `cms_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`1.15ms34.06KBParams\libraries\src\Cache\Controller\CallbackController.php:51Copy
  • 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 `cms_scheduler_tasks` AS `a` WHERE `a`.`state` = 1397μs1.37KBParams\administrator\components\com_scheduler\src\Model\TasksModel.php:517Copy
  • SELECT `session_id` FROM `cms_session` WHERE `session_id` = ?380μs1KBParams\libraries\vendor\joomla\session\src\Handler\DatabaseHandler.php:277Copy
  • UPDATE `cms_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?67.29ms592BParams\libraries\vendor\joomla\session\src\Handler\DatabaseHandler.php:301Copy