| Behind the Scenes Music Hall Tours |
SUMMER 2011 TOURS
The Music Hall has announced its schedule for Summer 2011 historical tours. The behind-the-scenes tour of the theatre, designated an American Treasure, will run on alternate Wednesdays at 5:30pm, June through September. (Continued below)
The 75 minutes tour includes visits to the backstage area where 1901 Vaudeville era “technology” is still in use, the antique front of house dating to 1878, and the enchanting lobby renovated with great flair in 2008.
Arranged and guided by Music Hall Historian Zhana Morris, also the theater’s production manager, the historical tour paints a full picture of the history of the treasured theater, including the tales of sailors who rigged the theater in the late 19th Century, its flashy and famous owners, and stars across three centuries. Its performers have ranged from Mark Twain to Wynton Marsalis and David Crosby; vaudeville acts with animals to RENT the musical and violinist Joshua Bell. Visitors will see the passage of time through the building’s award-winning restorations and renovations which have brought back details dating back to 1878 and 1901, the hall’s periods of architectural significance.
First stop is the Beaux Arts lobby which has been heralded in the regional and national press as “jaw-dropping” and “a one-of-a-kind surprise…. a world class space.” The 2,600 sq. ft space, including the box office, lower lobby, restrooms, elevator and coat check, reflects the Beaux Arts beauty of the theater above and showcases the theater’s history in a bold and theatrical way while offering striking 21st century amenities. Since the Lobby opened in September 2008, it has be compared to the work of Louis Comfort Tiffany, the design of ships that once filled Portsmouth’s harbor, the lushness of turn-of-the-century Colorado gold rush hotels, and the Eiffel Tower in Paris.

The tour continues into the theater’s auditorium and up to its magnificent horseshoe balcony. There the main attractions are the restored decorative paintings on the ceiling dome and the proscenium arch adorned with cherubs – award-winning restorations unveiled to the public in September 2007 and 2006. The extraordinary decorative artistry had been covered over and forgotten for decades, the work of original owners of The Music Hall and artisans from 1878 to 1901. Visitors gain insight into the paintings’ history and their one-of-a-kind discovery in Winter 2007 – a find architectural conservators called “so dramatic, it takes your breath away.”
Finally, visitors are invited backstage to view antique riggings still operating today. Merging a colorful past and present, the tour provides tour-goers with unique perspectives on yesterday, today, and the future of the oldest operating theater in northern
Said Morris, “The artists who come here today are amazed, first, at how beautiful the theater is and, second, how we operate simultaneously in the old world and the new world in terms of technology and architecture. When they see the packed audiences and hear the acoustically perfect sound that comes with our 1878 design, they are even more aware of what a gem The Music Hall is, the ‘beating cultural heart of the New Hampshire Seacoast region.’ Our guest book is full of quotes worthy of framing, from my perspective. All of them encourage us to keep up with our work restoring the theater.”
To Purchase Tickets: Historical
session.client.forwarded ⇒ 10.1.157.218
session.client.browser ⇒ Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
password_clear ⇒
groups ⇒
com_rsfirewall.geoip ⇒
link ⇒ http://www.seacoastnh.com/portsmouth-aqueduct-company-piped-water-through-logs/
link ⇒ http://www.seacoastnh.com/warner-house-built-300-years-ago/
link ⇒ http://www.seacoastnh.com/living-with-the-ghost-of-ichabod-goodwin/
link ⇒ http://www.seacoastnh.com/walking-the-historic-streets-of-portsmouth-nh/
link ⇒ http://www.seacoastnh.com/the-science-of-the-historic-appledore-island-garden/
link ⇒ http://www.seacoastnh.com/a-quick-history-of-gulls-on-the-shoals/
link ⇒ http://www.seacoastnh.com/the-making-of-an-unprecedented-edmund-tarbell-art-exhibit/
link ⇒ http://www.seacoastnh.com/nh-born-publisher-enticed-charles-dickens-back-to-america-in-1867/
link ⇒ http://www.seacoastnh.com/three-lives-of-the-portsmouth-marine-society/
link ⇒ http://www.seacoastnh.com/ben-franklin-installed-new-hampshire-lightning-rod-in-1763/
link ⇒ http://www.seacoastnh.com/kittery-little-red-schoolhouse-on-life-support/
link ⇒ http://www.seacoastnh.com/the-man-who-dug-up-john-paul-jones/
link ⇒ http://www.seacoastnh.com/miss-nancy-underhill-swept-off-star-island-in-1848/
link ⇒ http://www.seacoastnh.com/us-wwii-ambassador-john-winant-gets-his-memorial-at-las/
link ⇒ http://www.seacoastnh.com/the-unexpected-portsmouth-art-gallery/
link ⇒ http://www.seacoastnh.com/inside-the-wondrous-woodman-museum/
link ⇒ http://www.seacoastnh.com/my-favorite-portsmouth-history-books-for-kids/
link ⇒ http://www.seacoastnh.com/main-street-south-berwick-over-200-years/
link ⇒ http://www.seacoastnh.com/lakes-region-legends-celebrated-in-new-book/
link ⇒ http://www.seacoastnh.com/the-truth-about-bricks-and-mortar/
session.token ⇒ 861308293b5c40a363d3f713343dd204
Application 0.000 seconds (+0.000); 0.33 MB (+0.333) - afterLoadApplication 0.013 seconds (+0.013); 3.23 MB (+2.901) - afterInitialiseApplication 0.045 seconds (+0.032); 5.05 MB (+1.811) - afterRouteApplication 0.055 seconds (+0.010); 6.16 MB (+1.112) - afterDispatchApplication 0.056 seconds (+0.000); 6.20 MB (+0.045) - afterRender6.22 MB (6,520,960 Bytes)SELECT `data`
FROM `rabbul_session`
WHERE `session_id` = '4d09c01d3ae5d1f894cb42354e70fe41'DELETE
FROM `rabbul_session`
WHERE `time` < '1792174149'SELECT folder AS type, element AS name, params
FROM rabbul_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY orderingSELECT extension_id AS id, element AS "option", params, enabled
FROM rabbul_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'SELECT `query`
FROM `rabbul_admintools_wafexceptions`
WHERE (`option` IS NULL OR `option` = '')
AND (`view` IS NULL OR `view` = '')
GROUP BY `query`
ORDER BY `query` ASCSELECT `value`
FROM `rabbul_admintools_storage`
WHERE `key` = 'cparams'SELECT `path`
FROM rabbul_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'SELECT `file`
FROM rabbul_rsfirewall_hashes
WHERE `type`='protect'SELECT *
FROM rabbul_rsfirewall_configurationSHOW FULL COLUMNS
FROM `rabbul_sef_config`SELECT *
FROM rabbul_sef_config
WHERE `id` = '1'SELECT non_sef_url,alias
FROM rabbul_sef_alias
WHERE published='1'
ORDER BY idSELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, 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,e.element as component
FROM rabbul_menu AS m
LEFT JOIN rabbul_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftSELECT *
FROM rabbul_sef_redirect
WHERE CONVERT(source USING latin1) COLLATE latin1_general_cs = 'behind-the-scenes-music-hall-tours/?print=1&tmpl=component'
AND published='1'
LIMIT 1SELECT id
FROM rabbul_menu
WHERE alias='behind-the-scenes-music-hall-tours'
AND published=1SELECT id
FROM rabbul_categories
WHERE path='behind-the-scenes-music-hall-tours'
AND extension='com_content'SELECT id,catid
FROM rabbul_content
WHERE alias='behind-the-scenes-music-hall-tours'
AND state>0SELECT id,catid
FROM rabbul_content
WHERE alias='behind-the-scenes-music-hall-tours'
AND state>0SELECT id
FROM rabbul_menu
WHERE type='component'
AND published='1'
AND link LIKE 'index.php?option=com_content&view=article%&id=3041'
ORDER BY idSELECT id
FROM rabbul_menu
WHERE type='component'
AND published='1'
AND link LIKE 'index.php?option=com_content&view=categor%&id=93'
ORDER BY idSELECT `id`
FROM `rabbul_usergroups`SELECT parent.id, parent.lft, parent.rgt
FROM rabbul_usergroups AS parent
ORDER BY parent.lftSHOW FULL COLUMNS
FROM `rabbul_assets`SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT b.rules
FROM rabbul_assets AS a
LEFT JOIN rabbul_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = '')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT rules
FROM rabbul_assets
WHERE id = '1'SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT u.*
FROM rabbul_user_usergroup_map m
RIGHT JOIN rabbul_users u
ON (u.id=m.user_id)
WHERE m.group_id IN (6,7,8)
GROUP BY u.id
ORDER BY u.username ASCSHOW FULL COLUMNS
FROM `rabbul_rsfirewall_logs`SELECT *
FROM rabbul_rsfirewall_hashes
WHERE (`type`='2.5.28' OR `type`='protect')
AND `flag`!='C'SELECT *
FROM rabbul_rsfirewall_snapshots
WHERE `type`='protect'SELECT `ip`,`reason`
FROM rabbul_rsfirewall_lists
WHERE (`ip`='10.1.157.218' OR `ip` LIKE '%*%')
AND `type`='1'
AND `published`='1'SELECT `ip`,`reason`
FROM rabbul_rsfirewall_lists
WHERE (`ip`='10.1.157.218' OR `ip` LIKE '%*%')
AND `type`='0'
AND `published`='1'SELECT *
FROM rabbul_rsfirewall_exceptions
WHERE `published`='1'SELECT extension_id AS id, element AS "option", params, enabled
FROM rabbul_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'SELECT *
FROM rabbul_languages
WHERE published=1
ORDER BY ordering ASCSELECT id, home, template, s.params
FROM rabbul_template_styles as s
LEFT JOIN rabbul_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 = 1SELECT b.rules
FROM rabbul_assets AS a
LEFT JOIN rabbul_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT extension_id AS id, element AS "option", params, enabled
FROM rabbul_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT b.id
FROM rabbul_usergroups AS a
LEFT JOIN rabbul_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as 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.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
SELECT MAX(contact.id) AS id
FROM rabbul_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM rabbul_content AS a
LEFT JOIN rabbul_categories AS c
on c.id = a.catid
LEFT JOIN rabbul_users AS u
on u.id = a.created_by
LEFT JOIN rabbul_categories as parent
ON parent.id = c.parent_id
LEFT JOIN rabbul_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM rabbul_categories AS cat JOIN rabbul_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 3041
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-16 18:24:09')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-16 18:24:09')
AND (a.state = 1 OR a.state =2)SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM rabbul_categories as c
LEFT JOIN rabbul_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM rabbul_categories AS cat JOIN rabbul_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=93
AND badcats.id is null
GROUP BY 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
ORDER BY c.lftSELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3041UPDATE rabbul_content
SET hits = hits + 1
WHERE id = 3041UPDATE `rabbul_session`
SET `data` = '__default|a:12:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1792175047;s:18:\"session.timer.last\";i:1792175049;s:17:\"session.timer.now\";i:1792175049;s:24:\"session.client.forwarded\";s:12:\"10.1.157.218\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:20:\"com_rsfirewall.geoip\";s:0:\"\";s:16:\"com_mailto.links\";a:20:{s:40:\"090eb7e6d37b123ca7eff95fceab7fc4e0f3375f\";O:8:\"stdClass\":2:{s:4:\"link\";s:79:\"http://www.seacoastnh.com/portsmouth-aqueduct-company-piped-water-through-logs/\";s:6:\"expiry\";i:1792175048;}s:40:\"9128a0ee355433471bce877308df9ec271d6dab7\";O:8:\"stdClass\":2:{s:4:\"link\";s:59:\"http://www.seacoastnh.com/warner-house-built-300-years-ago/\";s:6:\"expiry\";i:1792175048;}s:40:\"2b6101b7f77c073d4ddcd9ca654e571298f6f38c\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://www.seacoastnh.com/living-with-the-ghost-of-ichabod-goodwin/\";s:6:\"expiry\";i:1792175048;}s:40:\"52cd5b6b7c6bf2004020ce09051858b07b20be81\";O:8:\"stdClass\":2:{s:4:\"link\";s:72:\"http://www.seacoastnh.com/walking-the-historic-streets-of-portsmouth-nh/\";s:6:\"expiry\";i:1792175048;}s:40:\"457852410d147044fdf5f1f8d74d7af80701a5c6\";O:8:\"stdClass\":2:{s:4:\"link\";s:78:\"http://www.seacoastnh.com/the-science-of-the-historic-appledore-island-garden/\";s:6:\"expiry\";i:1792175048;}s:40:\"958e15564a2878588a0681b4d9f3bab77d6c5455\";O:8:\"stdClass\":2:{s:4:\"link\";s:65:\"http://www.seacoastnh.com/a-quick-history-of-gulls-
on-the-shoals/\";s:6:\"expiry\";i:1792175048;}s:40:\"871467c2f59b9bebadbad68b07ee0d14ee0da8b9\";O:8:\"stdClass\":2:{s:4:\"link\";s:84:\"http://www.seacoastnh.com/the-making-of-an-unprecedented-edmund-tarbell-art-exhibit/\";s:6:\"expiry\";i:1792175048;}s:40:\"a7b2d6b19e10bb1b578039485245365bba6d2a93\";O:8:\"stdClass\":2:{s:4:\"link\";s:92:\"http://www.seacoastnh.com/nh-born-publisher-enticed-charles-dickens-back-to-america-in-1867/\";s:6:\"expiry\";i:1792175048;}s:40:\"02f09748c4fbce71e86c452d1244989822bdae80\";O:8:\"stdClass\":2:{s:4:\"link\";s:71:\"http://www.seacoastnh.com/three-lives-of-the-portsmouth-marine-society/\";s:6:\"expiry\";i:1792175048;}s:40:\"322ecc2480151ab25e2ba65f338c73c592e3609a\";O:8:\"stdClass\":2:{s:4:\"link\";s:85:\"http://www.seacoastnh.com/ben-franklin-installed-new-hampshire-lightning-rod-in-1763/\";s:6:\"expiry\";i:1792175048;}s:40:\"a4d82569b0cac5ae04f55b5e42a8620a5553d144\";O:8:\"stdClass\":2:{s:4:\"link\";s:73:\"http://www.seacoastnh.com/kittery-little-red-schoolhouse-
on-life-support/\";s:6:\"expiry\";i:1792175048;}s:40:\"e07ee172e4135ff683ab8d79d79b3b1d2f4515b5\";O:8:\"stdClass\":2:{s:4:\"link\";s:61:\"http://www.seacoastnh.com/the-man-who-dug-up-john-paul-jones/\";s:6:\"expiry\";i:1792175048;}s:40:\"6b41a9b7783fe5be813bdbed66211aa3e7a49bc8\";O:8:\"stdClass\":2:{s:4:\"link\";s:77:\"http://www.seacoastnh.com/miss-nancy-underhill-swept-off-star-island-in-1848/\";s:6:\"expiry\";i:1792175048;}s:40:\"296d013e0b8ca7cf338b68a25bd39fd1a4e9f561\";O:8:\"stdClass\":2:{s:4:\"link\";s:82:\"http://www.seacoastnh.com/us-wwii-ambassador-john-winant-gets-his-memorial-at-las/\";s:6:\"expiry\";i:1792175048;}s:40:\"296f1f783e43b33b4f47146d81420afb1c18c44a\";O:8:\"stdClass\":2:{s:4:\"link\";s:64:\"http://www.seacoastnh.com/the-unexpected-portsmouth-art-gallery/\";s:6:\"expiry\";i:1792175048;}s:40:\"b9255d8b918cfd151f48400b9e544cbc96e7cbef\";O:8:\"stdClass\":2:{s:4:\"link\";s:61:\"http://www.seacoastnh.com/inside-the-wondrous-woodman-museum/\";s:6:\"expiry\";i:1792175048;}s:40:\"aec7fcef9ebfccdad89dde84f6be859b74b48bbc\";O:8:\"stdClass\":2:{s:4:\"link\";s:72:\"http://www.seacoastnh.com/my-favorite-portsmouth-history-books-for-kids/\";s:6:\"expiry\";i:1792175048;}s:40:\"39a07ae374d622c3c0db9857abe9736dcf9e6005\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://www.seacoastnh.com/main-street-south-berwick-over-200-years/\";s:6:\"expiry\";i:1792175048;}s:40:\"b7cb9ccf9c9f7f39ee69bacb116e46e367020ef5\";O:8:\"stdClass\":2:{s:4:\"link\";s:70:\"http://www.seacoastnh.com/lakes-region-legends-celebrated-in-new-book/\";s:6:\"expiry\";i:1792175048;}s:40:\"c2c7ea497ac448265e205958874f8bb929782647\";O:8:\"stdClass\":2:{s:4:\"link\";s:60:\"http://www.seacoastnh.com/the-truth-about-bricks-
and-mortar/\";s:6:\"expiry\";i:1792175048;}}s:19:\"com_mailto.formtime\";i:1792175049;s:13:\"session.token\";s:32:\"861308293b5c40a363d3f713343dd204\";}'
, `time` = '1792175049'
WHERE `session_id` = '4d09c01d3ae5d1f894cb42354e70fe41'15 × SELECT id
FROM rabbul_assets3 × SELECT extension_id AS id, element AS "option", params, enabled
FROM rabbul_extensions3 × SELECT id
FROM rabbul_menu2 × SELECT `ip`,`reason`
FROM rabbul_rsfirewall_lists2 × SELECT id,catid
FROM rabbul_content2 × SELECT b.rules
FROM rabbul_assets AS a
LEFT JOIN rabbul_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT rules
FROM rabbul_assets1 × SELECT *
FROM rabbul_rsfirewall_hashes1 × SELECT *
FROM rabbul_rsfirewall_snapshots1 × SELECT u.*
FROM rabbul_user_usergroup_map m RIGHT JOIN rabbul_users u
ON (u.id=m.user_id)1 × SELECT *
FROM rabbul_rsfirewall_exceptions1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM rabbul_categories as c
LEFT JOIN rabbul_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM rabbul_categories AS cat JOIN rabbul_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT a.alias AS article
FROM rabbul_content AS a1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as 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.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id
FROM rabbul_contact_details AS contact1 × SELECT b.id
FROM rabbul_usergroups AS a
LEFT JOIN rabbul_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, home, template, s.params
FROM rabbul_template_styles as s
LEFT JOIN rabbul_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM rabbul_languages1 × SELECT `id`
FROM `rabbul_usergroups1 × SELECT `path`
FROM rabbul_rsfirewall_ignored1 × SELECT `file`
FROM rabbul_rsfirewall_hashes1 × SELECT `value`
FROM `rabbul_admintools_storage`1 × SELECT `query`
FROM `rabbul_admintools_wafexceptions`1 × SELECT folder AS type, element AS name, params
FROM rabbul_extensions1 × SELECT *
FROM rabbul_rsfirewall_configuratio1 × SELECT *
FROM rabbul_sef_config1 × SELECT id
FROM rabbul_categories1 × SELECT `data`
FROM `rabbul_session`1 × SELECT *
FROM rabbul_sef_redirect1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, 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,e.element as component
FROM rabbul_menu AS m
LEFT JOIN rabbul_extensions AS e
ON m.component_id = e.extension_id1 × SELECT non_sef_url,alias
FROM rabbul_sef_alias1 × SELECT parent.id, parent.lft, parent.rgt
FROM rabbul_usergroups AS parent1 × UPDATE rabbul_content
SET hits = hits + 11 × UPDATE `rabbul_session`
SET `data` = '__default|a:12:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1792175047;s:18:\"session.timer.last\";i:1792175049;s:17:\"session.timer.now\";i:1792175049;s:24:\"session.client.forwarded\";s:12:\"10.1.157.218\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:20:\"com_rsfirewall.geoip\";s:0:\"\";s:16:\"com_mailto.links\";a:20:{s:40:\"090eb7e6d37b123ca7eff95fceab7fc4e0f3375f\";O:8:\"stdClass\":2:{s:4:\"link\";s:79:\"http://www.seacoastnh.com/portsmouth-aqueduct-company-piped-water-through-logs/\";s:6:\"expiry\";i:1792175048;}s:40:\"9128a0ee355433471bce877308df9ec271d6dab7\";O:8:\"stdClass\":2:{s:4:\"link\";s:59:\"http://www.seacoastnh.com/warner-house-built-300-years-ago/\";s:6:\"expiry\";i:1792175048;}s:40:\"2b6101b7f77c073d4ddcd9ca654e571298f6f38c\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://www.seacoastnh.com/living-with-the-ghost-of-ichabod-goodwin/\";s:6:\"expiry\";i:1792175048;}s:40:\"52cd5b6b7c6bf2004020ce09051858b07b20be81\";O:8:\"stdClass\":2:{s:4:\"link\";s:72:\"http://www.seacoastnh.com/walking-the-historic-streets-of-portsmouth-nh/\";s:6:\"expiry\";i:1792175048;}s:40:\"457852410d147044fdf5f1f8d74d7af80701a5c6\";O:8:\"stdClass\":2:{s:4:\"link\";s:78:\"http://www.seacoastnh.com/the-science-of-the-historic-appledore-island-garden/\";s:6:\"expiry\";i:1792175048;}s:40:\"958e15564a2878588a0681b4d9f3bab77d6c5455\";O:8:\"stdClass\":2:{s:4:\"link\";s:65:\"http://www.seacoastnh.com/a-quick-history-of-gulls-
on-the-shoals/\";s:6:\"expiry\";i:1792175048;}s:40:\"871467c2f59b9bebadbad68b07ee0d14ee0da8b9\";O:8:\"stdClass\":2:{s:4:\"link\";s:84:\"http://www.seacoastnh.com/the-making-of-an-unprecedented-edmund-tarbell-art-exhibit/\";s:6:\"expiry\";i:1792175048;}s:40:\"a7b2d6b19e10bb1b578039485245365bba6d2a93\";O:8:\"stdClass\":2:{s:4:\"link\";s:92:\"http://www.seacoastnh.com/nh-born-publisher-enticed-charles-dickens-back-to-america-in-1867/\";s:6:\"expiry\";i:1792175048;}s:40:\"02f09748c4fbce71e86c452d1244989822bdae80\";O:8:\"stdClass\":2:{s:4:\"link\";s:71:\"http://www.seacoastnh.com/three-lives-of-the-portsmouth-marine-society/\";s:6:\"expiry\";i:1792175048;}s:40:\"322ecc2480151ab25e2ba65f338c73c592e3609a\";O:8:\"stdClass\":2:{s:4:\"link\";s:85:\"http://www.seacoastnh.com/ben-franklin-installed-new-hampshire-lightning-rod-in-1763/\";s:6:\"expiry\";i:1792175048;}s:40:\"a4d82569b0cac5ae04f55b5e42a8620a5553d144\";O:8:\"stdClass\":2:{s:4:\"link\";s:73:\"http://www.seacoastnh.com/kittery-little-red-schoolhouse-
on-life-support/\";s:6:\"expiry\";i:1792175048;}s:40:\"e07ee172e4135ff683ab8d79d79b3b1d2f4515b5\";O:8:\"stdClass\":2:{s:4:\"link\";s:61:\"http://www.seacoastnh.com/the-man-who-dug-up-john-paul-jones/\";s:6:\"expiry\";i:1792175048;}s:40:\"6b41a9b7783fe5be813bdbed66211aa3e7a49bc8\";O:8:\"stdClass\":2:{s:4:\"link\";s:77:\"http://www.seacoastnh.com/miss-nancy-underhill-swept-off-star-island-in-1848/\";s:6:\"expiry\";i:1792175048;}s:40:\"296d013e0b8ca7cf338b68a25bd39fd1a4e9f561\";O:8:\"stdClass\":2:{s:4:\"link\";s:82:\"http://www.seacoastnh.com/us-wwii-ambassador-john-winant-gets-his-memorial-at-las/\";s:6:\"expiry\";i:1792175048;}s:40:\"296f1f783e43b33b4f47146d81420afb1c18c44a\";O:8:\"stdClass\":2:{s:4:\"link\";s:64:\"http://www.seacoastnh.com/the-unexpected-portsmouth-art-gallery/\";s:6:\"expiry\";i:1792175048;}s:40:\"b9255d8b918cfd151f48400b9e544cbc96e7cbef\";O:8:\"stdClass\":2:{s:4:\"link\";s:61:\"http://www.seacoastnh.com/inside-the-wondrous-woodman-museum/\";s:6:\"expiry\";i:1792175048;}s:40:\"aec7fcef9ebfccdad89dde84f6be859b74b48bbc\";O:8:\"stdClass\":2:{s:4:\"link\";s:72:\"http://www.seacoastnh.com/my-favorite-portsmouth-history-books-for-kids/\";s:6:\"expiry\";i:1792175048;}s:40:\"39a07ae374d622c3c0db9857abe9736dcf9e6005\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://www.seacoastnh.com/main-street-south-berwick-over-200-years/\";s:6:\"expiry\";i:1792175048;}s:40:\"b7cb9ccf9c9f7f39ee69bacb116e46e367020ef5\";O:8:\"stdClass\":2:{s:4:\"link\";s:70:\"http://www.seacoastnh.com/lakes-region-legends-celebrated-in-new-book/\";s:6:\"expiry\";i:1792175048;}s:40:\"c2c7ea497ac448265e205958874f8bb929782647\";O:8:\"stdClass\":2:{s:4:\"link\";s:60:\"http://www.seacoastnh.com/the-truth-about-bricks-
and-mortar/\";s:6:\"expiry\";i:1792175048;}}s:19:\"com_mailto.formtime\";i:1792175049;s:13:\"session.token\";s:32:\"861308293b5c40a363d3f713343dd204\";}' , `time` = '1792175049'1 × SHOW FULL COLUMNS
FROM `rabbul_rsfirewall_logs1 × SHOW FULL COLUMNS
FROM `rabbul_assets1 × SHOW FULL COLUMNS
FROM `rabbul_sef_config1 × DELETE
FROM `rabbul_session`