Constellations: Boötes, Centaurus, Scorpius 
Asterism
:
Great Diamond/Diamond of Virgo, Spring Triangle, Teapot
Stars: 
Alnasi, Antares, Arcturus, Cor Caroli, Denebola, Deschuba (δ Scorpii), Graffias (β Scorpii), Kaus Borealis, Kaus Media, Menkant (θ Centaurus), Nunki, η Scorpii, Spica, Vindemiatrix
Messier Objects:
 
M7 (Ptolemy Cluster), M8 (Lagoon Nebula), M20 (Trifid Nebula), M21, M22
Planets: 
Mars, Venus
Moon:
Cleomedes, Gang of 4 (Langrenus, Vendelinus, Petavius, Furnerius), Geminus, Mare Crisium

Identified, not Observed :
Canis Venatici, Leo, Virgo

Location: Site 15 on Big Muise Island, Kejimkujik National Park, NS
Date: 2023-06-21
Time: 9:00 PM - 11:30 PM ADT
Equipment: Visual, 10x42 IS Binoculars
Transparency: not recorded
Seeing: not recorded

Time SQM Temp
10:45 PM 21.46 17° C

Dave and I were in our camp chairs with binoculars at one end of the beach while Jerry was at the other end setting up his camera gear. There was a light breeze - enough to keep the mosquitoes away!

Moon, Venus, Mars
Time: 9:19 PM
Equipment: Visual, Binoculars
The Moon and Venus were up fairly high in the skies. Visible were Mare Crisium, Gang of 4 (Langrenus, Vendelinus, Petavius, Furnerius), Cleomedes, and Geminus. Earthshine was evident on the lunar surface.

Venus was 8 o'clock to the lowest part of the crescent Moon. Marrs was at 10 o'clock to Venus and higher than the top of the crescent Moon.

Boötes
Time: 9:30 PM
Equipment: Visual
S&T Chart: 42, 44, 53, 55
Arcturus shone brightly and was easily spotted. I looked for and found the kite-shape of this constellation but did not identify the individual stars.

Scorpius, Centaurus
Time: 10:19 PM
Equipment: Visual
S&T Chart: 56, 58
The reddish Antares was twinkling  in the southern horizon. Could readily find Graffias (β Scorpii), Dschubba (δ Scorpii), and η Scorpii. At this point, I did not search for other stars within the constellation. It was at this point of the evening that Dave excitedly pointed out Menkant (θ Centauri) just above the horizon. Menkant is part of the shoulder of the Centaur. What surprised us is that Centaurus is considered a "southern" constellation so to see it here was a wonderful surprise.

Spring Triangle, Great Diamond/Diamond of Virgo
Time: 10:25 PM
Equipment: Visual
Dave pointed out two asterisms. Arcturus (α Boötis), Spica (α Virginis) and Denebola (β Leonis) comprise the Spring Triangle. Interestingly, Vindemiatrix (ε Virginis) is the central star in that triangle of constellations. Denebola (β Leonis), Arcturus (α Boötis), Spica (α Virginis) and Cor Caroli (α Canum Venaticorum) comprise the Great Diamond. Two asterisms in one part of our observable skies! Who knew?

10:45 PM - 11:30 PM
It was during this time that for some reason I stopped recording times of observations, so here's the list. 

Teapot
M22 / NGC 6566

M8 / NGC 6523 / Lagoon Nebula
M20 / NGC 6514 / Trifid Nebula
M21 / NGC 6531 / Webb's Cross
M7 / NGC 6475 / Ptolemy Cluster

Equipment: Visual, Binoculars
S&T Chart: 67, 69
The Teapot asterism was above the horizon about 10° and its base was almost perfectly parallel to the horizon. All 8 stars were easily seen. 

I used binoculars to find M22 by starting at Kaus Borealis (the Teapot lid star) and moving at bout a 45° angle to find a small group of stars that were Y-shaped, then moved a little further out to find the small grey fuzz of M22. 

I then used the stars forming the spout - Kaus Media (δ Sagittarii) and Alnasl (γ2 Sagittarii) - to find M8, M20 and M21. Just viewed them long enough to recognize the binocular-view shape and star composition. Did not sketch.

I then went to the base of the Teapot and used the line from Nunki (star in the Teapot handle) to Alnasl (star in the spout) to continue outward to find M7. I was not disappointed! The Ptolemy Cluster is a glorious open cluster - bright and many stars.

 

 

 

 

Similar Items

4.063MBMemory Usage73.8msRequest Duration
Joomla! Version5.2.3
PHP Version8.3.6
Identityguest
Response200
Templatelightning
Database
Server
mysql
Version
10.11.8-MariaDB-0ubuntu0.24.04.1
Collation
utf8mb4_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:42 [ "HTTPS" => "on" "SSL_TLS_SNI" => "sciencedowneast.com" "HTTP_HOST" => "sciencedowne...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1737572354 "last" => 1737572354...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (85.01KB) (4.53ms)
  • afterInitialise (1.37MB) (27.82ms)
  • afterRoute (234.75KB) (4.69ms)
  • beforeRenderComponent com_content (33.25KB) (1.55ms)
  • Before Access::preloadComponents (all components) (33.83KB) (519μs)
  • After Access::preloadComponents (all components) (118.79KB) (820μs)
  • Before Access::preloadPermissions (com_content) (1.63KB) (24μs)
  • After Access::preloadPermissions (com_content) (348.31KB) (1.1ms)
  • Before Access::getAssetRules (id:999 name:com_content.article.477) (18.65KB) (31μs)
  • After Access::getAssetRules (id:999 name:com_content.article.477) (8.3KB) (95μs)
  • Before Access::getAssetRules (id:1 name:root.1) (203.63KB) (6.28ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.48KB) (25μs)
  • afterRenderComponent com_content (309.69KB) (6.28ms)
  • afterDispatch (104B) (373μs)
  • beforeRenderRawModule mod_menu (Main Menu) (61.59KB) (895μs)
  • afterRenderRawModule mod_menu (Main Menu) (197.49KB) (1.3ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (4μs)
  • afterRenderModule mod_menu (Main Menu) (6.86KB) (140μs)
  • beforeRenderRawModule mod_finder (Search) (2KB) (53μs)
  • afterRenderRawModule mod_finder (Search) (355.47KB) (2.96ms)
  • beforeRenderModule mod_finder (Search) (704B) (5μs)
  • afterRenderModule mod_finder (Search) (3.28KB) (76μs)
  • beforeRenderRawModule mod_articles_archive (Archived Articles) (3.8KB) (267μs)
  • afterRenderRawModule mod_articles_archive (Archived Articles) (14.06KB) (545μs)
  • beforeRenderModule mod_articles_archive (Archived Articles) (720B) (3μs)
  • afterRenderModule mod_articles_archive (Archived Articles) (2.98KB) (62μs)
  • beforeRenderRawModule mod_syndicate (Syndication) (880B) (9μs)
  • afterRenderRawModule mod_syndicate (Syndication) (3.49KB) (81μs)
  • beforeRenderModule mod_syndicate (Syndication) (704B) (2μs)
  • afterRenderModule mod_syndicate (Syndication) (2.5KB) (25μs)
  • beforeRenderRawModule mod_tags_similar (Similar Items) (96B) (39μs)
  • afterRenderRawModule mod_tags_similar (Similar Items) (107.2KB) (6.55ms)
  • beforeRenderModule mod_tags_similar (Similar Items) (704B) (4μs)
  • afterRenderModule mod_tags_similar (Similar Items) (5.48KB) (101μs)
  • beforeRenderRawModule mod_footer (Footer) (504B) (36μs)
  • afterRenderRawModule mod_footer (Footer) (4.84KB) (196μs)
  • beforeRenderModule mod_footer (Footer) (704B) (2μs)
  • afterRenderModule mod_footer (Footer) (2.97KB) (43μs)
  • beforeRenderRawModule mod_menu (Bottom Menu) (592B) (11μs)
  • afterRenderRawModule mod_menu (Bottom Menu) (3.47KB) (75μs)
  • beforeRenderModule mod_menu (Bottom Menu) (720B) (2μs)
  • afterRenderModule mod_menu (Bottom Menu) (2.41KB) (25μs)
  • afterRender (194.26KB) (4.54ms)
  • 1 x afterInitialise (1.37MB) (37.7%)
    27.82ms
    1 x afterRenderRawModule mod_tags_similar (Similar Items) (107.2KB) (8.88%)
    6.55ms
    1 x afterRenderComponent com_content (309.69KB) (8.51%)
    6.28ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (203.63KB) (8.5%)
    6.28ms
    1 x afterRoute (234.75KB) (6.36%)
    4.69ms
    1 x afterRender (194.26KB) (6.15%)
    4.54ms
    1 x afterLoad (85.01KB) (6.14%)
    4.53ms
    1 x afterRenderRawModule mod_finder (Search) (355.47KB) (4.02%)
    2.96ms
    1 x beforeRenderComponent com_content (33.25KB) (2.11%)
    1.55ms
    1 x afterRenderRawModule mod_menu (Main Menu) (197.49KB) (1.76%)
    1.30ms
    1 x After Access::preloadPermissions (com_content) (348.31KB) (1.48%)
    1.10ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (61.59KB) (1.21%)
    895μs
    1 x After Access::preloadComponents (all components) (118.79KB) (1.11%)
    820μs
    1 x afterRenderRawModule mod_articles_archive (Archived Articles) (14.06KB) (0.74%)
    545μs
    1 x Before Access::preloadComponents (all components) (33.83KB) (0.7%)
    519μs
    1 x afterDispatch (104B) (0.51%)
    373μs
    1 x beforeRenderRawModule mod_articles_archive (Archived Articles) (3.8KB) (0.36%)
    267μs
    1 x afterRenderRawModule mod_footer (Footer) (4.84KB) (0.27%)
    196μs
    1 x afterRenderModule mod_menu (Main Menu) (6.86KB) (0.19%)
    140μs
    1 x afterRenderModule mod_tags_similar (Similar Items) (5.48KB) (0.14%)
    101μs
    1 x After Access::getAssetRules (id:999 name:com_content.article.477) (8.3KB) (0.13%)
    95μs
    1 x afterRenderRawModule mod_syndicate (Syndication) (3.49KB) (0.11%)
    81μs
    1 x afterRenderModule mod_finder (Search) (3.28KB) (0.1%)
    76μs
    1 x afterRenderRawModule mod_menu (Bottom Menu) (3.47KB) (0.1%)
    75μs
    1 x afterRenderModule mod_articles_archive (Archived Articles) (2.98KB) (0.08%)
    62μs
    1 x beforeRenderRawModule mod_finder (Search) (2KB) (0.07%)
    53μs
    1 x afterRenderModule mod_footer (Footer) (2.97KB) (0.06%)
    43μs
    1 x beforeRenderRawModule mod_tags_similar (Similar Items) (96B) (0.05%)
    39μs
    1 x beforeRenderRawModule mod_footer (Footer) (504B) (0.05%)
    36μs
    1 x Before Access::getAssetRules (id:999 name:com_content.article.477) (18.65KB) (0.04%)
    31μs
    1 x afterRenderModule mod_syndicate (Syndication) (2.5KB) (0.03%)
    25μs
    1 x afterRenderModule mod_menu (Bottom Menu) (2.41KB) (0.03%)
    25μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.48KB) (0.03%)
    25μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.03%)
    24μs
    1 x beforeRenderRawModule mod_menu (Bottom Menu) (592B) (0.01%)
    11μs
    1 x beforeRenderRawModule mod_syndicate (Syndication) (880B) (0.01%)
    9μs
    1 x beforeRenderModule mod_finder (Search) (704B) (0.01%)
    5μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0.01%)
    4μs
    1 x beforeRenderModule mod_tags_similar (Similar Items) (704B) (0.01%)
    4μs
    1 x beforeRenderModule mod_articles_archive (Archived Articles) (720B) (0%)
    3μs
    1 x beforeRenderModule mod_syndicate (Syndication) (704B) (0%)
    2μs
    1 x beforeRenderModule mod_footer (Footer) (704B) (0%)
    2μs
    1 x beforeRenderModule mod_menu (Bottom Menu) (720B) (0%)
    2μs
44 statements were executed, 5 of which were duplicates, 39 unique23.68ms825.15KB
  • SELECT `data` FROM `lb8l6_session` WHERE `session_id` = ?1.2ms17KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `lb8l6_session` WHERE `session_id` = :session_id LIMIT 1712μs16.98KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `lb8l6_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.79ms1.66KBParamsCopy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `lb8l6_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 11.08ms16.84KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `lb8l6_viewlevels`308μs16.44KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `lb8l6_usergroups` AS `a` LEFT JOIN `lb8l6_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest359μs17.03KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `lb8l6_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`918μs19.82KBParams/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 `lb8l6_menu` AS `m` LEFT JOIN `lb8l6_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`872μs50.91KBParams/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 `lb8l6_categories` AS `s` INNER JOIN `lb8l6_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`609μs19.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `lb8l6_content` WHERE `alias` = :segment AND `catid` = :id271μs17.1KBParams/components/com_content/src/Service/Router.php:263Copy
  • SELECT * FROM `lb8l6_languages` WHERE `published` = 1 ORDER BY `ordering` ASC238μs16.39KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `lb8l6_template_styles` AS `s` LEFT JOIN `lb8l6_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` = 1309μs16.19KB/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `lb8l6_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43)645μs26.08KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `lb8l6_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0683μs45.19KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `lb8l6_content`1.02ms16.85KB/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php:442Copy
  • UPDATE `lb8l6_content` SET `hits` = (`hits` + 1) WHERE `id` = '477'635μs56BCopy
  • 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 `lb8l6_content` AS `a` INNER JOIN `lb8l6_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `lb8l6_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `lb8l6_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `lb8l6_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `lb8l6_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)640μs37.55KBParams/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 `lb8l6_categories` AS `s` INNER JOIN `lb8l6_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`426μs18.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `lb8l6_contentitem_tag_map` AS `m` INNER JOIN `lb8l6_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)472μs18.3KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT r.* FROM lb8l6_rereplacer AS r WHERE r.published = 1 AND (r.area = 'articles') ORDER BY r.ordering, r.id203μs16.31KB/plugins/system/rereplacer/src/Items.php:95Copy
  • 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 `lb8l6_categories` AS `s` INNER JOIN `lb8l6_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`352μs18.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 lb8l6_fields AS a LEFT JOIN `lb8l6_languages` AS l ON l.lang_code = a.language LEFT JOIN lb8l6_users AS uc ON uc.id=a.checked_out LEFT JOIN lb8l6_viewlevels AS ag ON ag.id = a.access LEFT JOIN lb8l6_users AS ua ON ua.id = a.created_user_id LEFT JOIN lb8l6_fields_groups AS g ON g.id = a.group_id LEFT JOIN `lb8l6_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 ASC968μs20.3KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `field_id`,`value` FROM `lb8l6_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid191μs17.14KBParams/administrator/components/com_fields/src/Model/FieldModel.php:739Copy
  • 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 `lb8l6_categories` AS `s` INNER JOIN `lb8l6_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μs18.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT r.* FROM lb8l6_rereplacer AS r WHERE r.published = 1 AND (r.area = 'component') ORDER BY r.ordering, r.id160μs16.31KB/plugins/system/rereplacer/src/Items.php:95Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `lb8l6_modules` AS `m` LEFT JOIN `lb8l6_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `lb8l6_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`402μs18.44KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `lb8l6_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1271μs16.13KB/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `lb8l6_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)195μs16.15KB/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year FROM `lb8l6_content` AS `c` WHERE `c`.`state` = 2 GROUP BY YEAR(`c`.`created`), MONTH(`c`.`created`) ORDER BY YEAR(`c`.`created`) DESC, MONTH(`c`.`created`) DESC LIMIT 10267μs16.16KB/modules/mod_articles_archive/src/Helper/ArticlesArchiveHelper.php:69Copy
  • SELECT `t`.`id` FROM `lb8l6_tags` AS `t` INNER JOIN `lb8l6_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)313μs17.21KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `m`.`core_content_id`,`m`.`content_item_id`,`m`.`type_alias`,COUNT( `tag_id`) AS `count`,`ct`.`router`,`cc`.`core_title`,`cc`.`core_alias`,`cc`.`core_catid`,`cc`.`core_language`,`cc`.`core_params` FROM `lb8l6_contentitem_tag_map` AS `m` INNER JOIN `lb8l6_tags` AS `t` ON `m`.`tag_id` = `t`.`id` INNER JOIN `lb8l6_ucm_content` AS `cc` ON `m`.`core_content_id` = `cc`.`core_content_id` INNER JOIN `lb8l6_content_types` AS `ct` ON `m`.`type_alias` = `ct`.`type_alias` WHERE ( ( ( (`m`.`tag_id` IN (:preparedArray1,:preparedArray2) AND `t`.`access` IN (:preparedArray3,:preparedArray4) AND `cc`.`core_state` = 1) AND (`cc`.`core_access` IN (:preparedArray5,:preparedArray6) OR `cc`.`core_access` = 0)) AND (`m`.`content_item_id` <> :currentId OR `m`.`type_alias` <> :prefix)) AND (`cc`.`core_publish_up` IS NULL OR `cc`.`core_publish_up` = :nullDateUp OR `cc`.`core_publish_up` <= :nowDateUp)) AND (`cc`.`core_publish_down` IS NULL OR `cc`.`core_publish_down` = :nullDateDown OR `cc`.`core_publish_down` >= :nowDateDown) GROUP BY `m`.`core_content_id`,`m`.`content_item_id`,`m`.`type_alias`,`ct`.`router`,`cc`.`core_title`,`cc`.`core_alias`,`cc`.`core_catid`,`cc`.`core_language`,`cc`.`core_params` ORDER BY `count` DESC LIMIT 54.82ms19.91KBParams/modules/mod_tags_similar/src/Helper/TagsSimilarHelper.php:206Copy
  • SELECT `alias` FROM `lb8l6_content` WHERE `id` = :id153μs16.91KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `lb8l6_content` WHERE `id` = :id119μs19.41KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `lb8l6_content` WHERE `id` = :id103μs16.91KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `lb8l6_content` WHERE `id` = :id118μs16.91KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `lb8l6_content` WHERE `id` = :id114μs16.91KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT * FROM `lb8l6_schemaorg` WHERE `itemId` = :itemId AND `context` = :context138μs17.19KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403Copy
  • 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 `lb8l6_content` AS `a` INNER JOIN `lb8l6_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `lb8l6_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `lb8l6_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `lb8l6_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `lb8l6_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)345μs36.35KBParams/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 `lb8l6_scheduler_tasks` AS `a` WHERE `a`.`state` = 1173μs17.1KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
  • SELECT r.* FROM lb8l6_rereplacer AS r WHERE r.published = 1 AND (r.area = 'head') ORDER BY r.ordering, r.id150μs16.31KB/plugins/system/rereplacer/src/Items.php:95Copy
  • SELECT r.* FROM lb8l6_rereplacer AS r WHERE r.published = 1 AND (r.area = 'body') ORDER BY r.ordering, r.id140μs16.31KB/plugins/system/rereplacer/src/Items.php:95Copy
  • SELECT r.* FROM lb8l6_rereplacer AS r WHERE r.published = 1 AND (r.area = 'everywhere') ORDER BY r.ordering, r.id122μs16.31KB/plugins/system/rereplacer/src/Items.php:95Copy
  • SELECT `session_id` FROM `lb8l6_session` WHERE `session_id` = ?119μs16.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `lb8l6_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?256μs1.53KBParamsCopy