I spent the earlier part of this evening (7:20 PM - 9:10 PM) exploring the Moon towards achieving the RASC Explore the Moon (Telescope) certificate.

Constellation: Boötes, Canes Venatici, Cassiopeia, Cygnus, Delphinus, Equuleus, Lyra, Ursa Major
Messier O
bjects: M31 (Andromeda Galaxy), M51 (Whirlpool Galaxy)
Asterism: Coathanger / Collinder 399 / Brocchi's Cluster, Square of Pegasus, Summer Triangle / DAVe
Stars: Deneb, Lyra ε1, Lyra ε2, Lyra δ1, Lyra δ2, Mizar/Alcor, Polaris, Vega
Planet: Saturn
Satellite:
 (2)
Meteor

Location: Home
Date: 2017-07-30
Time: 9:00 PM - 11:53 PM
Instrument: Visual + Binocular 10x30 IS + 10" Meade SCT (100 mm + 30 mm eyepieces)
Transparency: Good (3)
Seeing: Good (3)
Temperature: 19º C - 14º C

Clear skies. No wind; a small breeze mid-evening that was barely discernible. First Quarter Moon in the sky.

Saturn
Time: 9:15 PM
Instrument: Visual + 10" Meade SCT, 10 mm + 30 mm eyepiece
The planet was very bright in the night sky. Rings covered the bottom of the plant and I could just make out a broad band on the planet just above Saturn's equator. One of the Moons was quite distant (3-4 times the rings' diameter.

  

Ursa Major (UMa)
Time: 10:15 PM
Instrument: Visual + 10" Meade SCT with 30 mm eyepiece
S&T Chart Reference: 43, 32

All the stars were visible at 10:15 PM but it was 20 minutes later that Dubhe could be easily seen visually. Polaris could easily be found visually.

Using the telescope at 10:44 PM, I looked at Mizar and Alcor, Mizar being the brighter of the pair. 

Cassiopeia
Time: 10:35 PM
Instrument: Visual
S&T Chart Reference: 1, 3, 72

Had no problem identify the 5 bright stars in this constellation.

 

Satellite
Time: 10:46 PM
Instrument: Visual
Passed from Cygnus through the head of Draco, then disappeared.

Summer Triangle / DAVe
Time: not recorded
Instrument: Visual
Despite the Moon, I was able to locate Vega, Altair and Deneb, in that order as they became apparent in the darkening skies.

 M51 (Whirlpool Galaxy)
Time: 10:54 PM
Instrument: Binoculars 10x30 IS
S&T Chart Reference: 32, 43

Using the distance between Alkaid and Mizar, I looked below Alkaid just a little lesss than this distance and saw a faint, grey circular smudge. Not positive it was M51 but it was the only "smudge" in the vicinity. Next time look at the adjacent star patterns to ensure identification.

Cygnus
Time: 11:07 PM
Instrument: Binoculars 10x30 IS
S&T Chart Reference: 43, 32

The Moon obscured the dimmer stars visually. At this time, the constellation was overhead. The stars ζ, η and ι were not easily seen visually. Used Albireo as a way to locate the Coathanger.

Coathanger / Collinder 399 / Brocchi's Cluster
Time: 11:07 PM
Instrument: Binoculars 10x30 IS
S&T Chart Reference: 43, 32

Travelled down the stars of Cygnus to Albireo then found the Coathanger - all 10 stars were clearly identified.

 

Canes Venatici
Time: 11:11 PM
Instrument: Binoculars 10x30 IS
S&T Chart Reference: 43, 32

Decided to look for this constellation and one of the arms of Boötes because the sky in this direction was darker and not affected by the lights of Halifax.

Using my S&T Atlas, I found this constellation lay directly below Ursa Major's handle. Specifically, Cor Caroli (α)was directly below Alkaid; this was easily found visually and I also looked for Arcturus as another guide. With my binoculars, I was able to find Cor Caroli. Jubilation at also being able to find Chara (β) with binoculars! It wasn't until I looked on the internet and at my map more closely that I discovered α was a binary star. I will look more closely next time.

   

Boötes
Time: 11:15 PM
Instrument: Binoculars 10x30 IS
S&T Chart Reference: 42, 44, 53, 55

Saw most of the stars in Boötes except Seginus. Looking at the star Atlas made me want to look for an extension away from the "kite" that contained θ, κ and λ. I located Alkaid and looked one FOV above it and there it was. The 4 stars of the corner were very clear and were in 1 FOV of my binoculars. SkySafariPro helped me identify the names of the stars. I was thrilled to be able to find this group of stars using landmarks as guides.

   

Lyra
Time: 11:35 PM
Instrument: Binoculars 10x30 IS
S&T Chart Reference: 63

Searched for the Lyra stars in this constellation to confirm the two sets of double stars. Lyra εand Lyra ε2 were easily found in binoculars. Following through Lyra ζ, I was able to locate the red and yellow Lyra δ1 and Lyra δ2 respectively. Vega, Lyra ζ, Lyra δ1 and Lyra δ2  were in one FOV and I was able to centre them in the middle of the FOV.

 

   

Delphinus
Time: 11:42 PM
Instrument: Binoculars 10x30 IS
S&T Chart Reference: 64

The 5 stars of Delphinus were visible but were considerably fainter due to the First Quarter Moon.

Equuleus
Time: 11:42 PM
Instrument: Binoculars 10x30 IS
S&T Chart Reference: 43, 32

I looked to Delphinus and after several second found α, δ, and γ Equ. It took a while to find ε with the binoculars. In examining γ Equ, I could see two stars there - γ Equi + 6 Equ. At ε Equ, I could make out 4 Equ and 3 Equ. I didn't take the time to note the colour differentiation (if any) or brightness, Next time?

   

Satellite
Time: 11:49 PM
Instrument: Binoculars 10x30 IS
Satellite crossed my FOV while looking at M31. It travelled from Andromeda to Perseus before disappearing.

Meteor
Time: 11:49 PM
Instrument: Visual
Travelled through Hercules towards Libra but disappeared before leaving Hercules.

Pegasus
Time: 11:50 PM
Instrument: Visual
S&T Chart Reference: 74, 75
Had to go to the deck side of the house to find Cassiopeia and the Square of Pegasus. There were limitations to seeing not only due to the Moon but also due to street lights if I walked too close to the front of the house.

M31 / Andromeda Galaxy
Time: 11:50 PM
Instrument: Binoculars
S&T Chart Reference: 3, 72
I used Cassiopeia and the Square of Pegasus to locate M31 - a grey oval smudge - with my binoculars.

 

 

Similar Items

Settings4.128MBMemory Usage67.65msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.0-beta2
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" => 1742174770 "last" => 1742174770...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (85.01KB) (3.18ms)
  • afterInitialise (1.35MB) (26.33ms)
  • afterRoute (235.05KB) (4.43ms)
  • beforeRenderComponent com_content (33.5KB) (996μs)
  • Before Access::preloadComponents (all components) (33.52KB) (363μs)
  • After Access::preloadComponents (all components) (111.1KB) (1.25ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (13μs)
  • After Access::preloadPermissions (com_content) (356.31KB) (2.11ms)
  • Before Access::getAssetRules (id:619 name:com_content.article.258) (18.65KB) (34μs)
  • After Access::getAssetRules (id:619 name:com_content.article.258) (8.3KB) (72μs)
  • Before Access::getAssetRules (id:1 name:root.1) (219.25KB) (4.72ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.48KB) (24μs)
  • afterRenderComponent com_content (311.45KB) (6.23ms)
  • afterDispatch (104B) (303μs)
  • beforeRenderRawModule mod_menu (Main Menu) (61.59KB) (708μs)
  • afterRenderRawModule mod_menu (Main Menu) (197.49KB) (1.33ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (5μs)
  • afterRenderModule mod_menu (Main Menu) (6.86KB) (115μs)
  • beforeRenderRawModule mod_finder (Search) (2KB) (51μs)
  • afterRenderRawModule mod_finder (Search) (355.55KB) (2.8ms)
  • beforeRenderModule mod_finder (Search) (704B) (4μs)
  • afterRenderModule mod_finder (Search) (3.28KB) (63μs)
  • beforeRenderRawModule mod_articles_archive (Archived Articles) (3.8KB) (238μs)
  • afterRenderRawModule mod_articles_archive (Archived Articles) (14.06KB) (397μs)
  • beforeRenderModule mod_articles_archive (Archived Articles) (720B) (3μs)
  • afterRenderModule mod_articles_archive (Archived Articles) (2.98KB) (56μs)
  • beforeRenderRawModule mod_syndicate (Syndication) (880B) (10μs)
  • afterRenderRawModule mod_syndicate (Syndication) (3.49KB) (82μs)
  • beforeRenderModule mod_syndicate (Syndication) (704B) (2μs)
  • afterRenderModule mod_syndicate (Syndication) (2.5KB) (31μs)
  • beforeRenderRawModule mod_tags_similar (Similar Items) (96B) (43μs)
  • afterRenderRawModule mod_tags_similar (Similar Items) (107.03KB) (6.87ms)
  • beforeRenderModule mod_tags_similar (Similar Items) (704B) (5μs)
  • afterRenderModule mod_tags_similar (Similar Items) (5.48KB) (80μs)
  • beforeRenderRawModule mod_footer (Footer) (504B) (40μs)
  • afterRenderRawModule mod_footer (Footer) (4.84KB) (176μs)
  • beforeRenderModule mod_footer (Footer) (704B) (2μs)
  • afterRenderModule mod_footer (Footer) (2.97KB) (40μs)
  • beforeRenderRawModule mod_menu (Bottom Menu) (592B) (10μs)
  • afterRenderRawModule mod_menu (Bottom Menu) (3.47KB) (62μs)
  • beforeRenderModule mod_menu (Bottom Menu) (720B) (2μs)
  • afterRenderModule mod_menu (Bottom Menu) (2.41KB) (26μs)
  • afterRender (215.98KB) (3.72ms)
  • 1 x afterInitialise (1.35MB) (38.92%)
    26.33ms
    1 x afterRenderRawModule mod_tags_similar (Similar Items) (107.03KB) (10.16%)
    6.87ms
    1 x afterRenderComponent com_content (311.45KB) (9.21%)
    6.23ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (219.25KB) (6.98%)
    4.72ms
    1 x afterRoute (235.05KB) (6.55%)
    4.43ms
    1 x afterRender (215.98KB) (5.5%)
    3.72ms
    1 x afterLoad (85.01KB) (4.7%)
    3.18ms
    1 x afterRenderRawModule mod_finder (Search) (355.55KB) (4.13%)
    2.80ms
    1 x After Access::preloadPermissions (com_content) (356.31KB) (3.12%)
    2.11ms
    1 x afterRenderRawModule mod_menu (Main Menu) (197.49KB) (1.97%)
    1.33ms
    1 x After Access::preloadComponents (all components) (111.1KB) (1.84%)
    1.25ms
    1 x beforeRenderComponent com_content (33.5KB) (1.47%)
    996μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (61.59KB) (1.05%)
    708μs
    1 x afterRenderRawModule mod_articles_archive (Archived Articles) (14.06KB) (0.59%)
    397μs
    1 x Before Access::preloadComponents (all components) (33.52KB) (0.54%)
    363μs
    1 x afterDispatch (104B) (0.45%)
    303μs
    1 x beforeRenderRawModule mod_articles_archive (Archived Articles) (3.8KB) (0.35%)
    238μs
    1 x afterRenderRawModule mod_footer (Footer) (4.84KB) (0.26%)
    176μs
    1 x afterRenderModule mod_menu (Main Menu) (6.86KB) (0.17%)
    115μs
    1 x afterRenderRawModule mod_syndicate (Syndication) (3.49KB) (0.12%)
    82μs
    1 x afterRenderModule mod_tags_similar (Similar Items) (5.48KB) (0.12%)
    80μs
    1 x After Access::getAssetRules (id:619 name:com_content.article.258) (8.3KB) (0.11%)
    72μs
    1 x afterRenderModule mod_finder (Search) (3.28KB) (0.09%)
    63μs
    1 x afterRenderRawModule mod_menu (Bottom Menu) (3.47KB) (0.09%)
    62μs
    1 x afterRenderModule mod_articles_archive (Archived Articles) (2.98KB) (0.08%)
    56μs
    1 x beforeRenderRawModule mod_finder (Search) (2KB) (0.08%)
    51μs
    1 x beforeRenderRawModule mod_tags_similar (Similar Items) (96B) (0.06%)
    43μs
    1 x beforeRenderRawModule mod_footer (Footer) (504B) (0.06%)
    40μs
    1 x afterRenderModule mod_footer (Footer) (2.97KB) (0.06%)
    40μs
    1 x Before Access::getAssetRules (id:619 name:com_content.article.258) (18.65KB) (0.05%)
    34μs
    1 x afterRenderModule mod_syndicate (Syndication) (2.5KB) (0.05%)
    31μs
    1 x afterRenderModule mod_menu (Bottom Menu) (2.41KB) (0.04%)
    26μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.48KB) (0.04%)
    24μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.02%)
    13μs
    1 x beforeRenderRawModule mod_syndicate (Syndication) (880B) (0.01%)
    10μs
    1 x beforeRenderRawModule mod_menu (Bottom Menu) (592B) (0.01%)
    10μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0.01%)
    5μs
    1 x beforeRenderModule mod_tags_similar (Similar Items) (704B) (0.01%)
    5μs
    1 x beforeRenderModule mod_finder (Search) (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.26ms825.95KB
  • SELECT `data` FROM `lb8l6_session` WHERE `session_id` = ?809μs17KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `lb8l6_session` WHERE `session_id` = :session_id LIMIT 1144μ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.5ms1.66KBParamsCopy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `lb8l6_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 11.32ms16.84KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `lb8l6_viewlevels`570μ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` = :guest345μ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`1.88ms19.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`1.66ms50.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`359μs19.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `lb8l6_content` WHERE `alias` = :segment AND `catid` = :id930μs17.1KBParams/components/com_content/src/Service/Router.php:270Copy
  • SELECT * FROM `lb8l6_languages` WHERE `published` = 1 ORDER BY `ordering` ASC140μs16.39KB/libraries/src/Language/LanguageHelper.php:179Copy
  • 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` = 1212μ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)1.07ms26.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` = 0579μs45.19KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `lb8l6_content`651μs16.85KB/libraries/vendor/joomla/database/src/Mysql/MysqlDriver.php:442Copy
  • UPDATE `lb8l6_content` SET `hits` = (`hits` + 1) WHERE `id` = '258'314μ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)469μ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`281μ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)348μs18.36KBParams/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.id165μ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`289μ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 ASC963μ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` = :itemid107μ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`270μ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.id107μ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`300μs18.44KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `lb8l6_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1257μ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)114μ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 10139μ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)186μs17.27KBParams/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,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6) AND `t`.`access` IN (:preparedArray7,:preparedArray8) AND `cc`.`core_state` = 1) AND (`cc`.`core_access` IN (:preparedArray9,:preparedArray10) 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 55.51ms20.38KBParams/modules/mod_tags_similar/src/Helper/TagsSimilarHelper.php:206Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key80μs16.95KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key52μs19.45KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key68μs16.95KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key56μs16.95KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `alias`,`catid` FROM lb8l6_content WHERE `id` = :key50μs16.95KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT * FROM `lb8l6_schemaorg` WHERE `itemId` = :itemId AND `context` = :context79μs17.19KBParams/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 `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)249μ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` = 195μs17.1KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT r.* FROM lb8l6_rereplacer AS r WHERE r.published = 1 AND (r.area = 'head') ORDER BY r.ordering, r.id91μ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.id58μ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.id53μs16.31KB/plugins/system/rereplacer/src/Items.php:95Copy
  • SELECT `session_id` FROM `lb8l6_session` WHERE `session_id` = ?89μs16.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `lb8l6_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?257μs1.53KBParamsCopy