|
Tearing Down the Hotel Porch |
Seacoast History Blog #143
September 4, 2012
People keep asking me if I’m sad that the history exhibit we spent so much time creating is coming down. The borrowed dugout and birchbark canoes went back to Maine. The replica hotel porch came down yesterday and today Nate Hamilton and his assistants are boxing up the artifacts. The stuffed birds, the ancient barrels, the old boats and tools, the signs and the 1873 murder ax are all going back from whence they came. On Saturday the Shoals Marine Lab held a celebratory dinner for 125 marine biologists in the middle of the exhibit at Discover Portsmouth that spilled out into the gift shop area. By the end of the week a whole new art show will replace my Isles of Shoals display. I’m told that 10,000 visitors saw the show this summer. But all things must pass. I’m less sad about the past than nervous about the future. What’s next? I do not know. (Continued below)
PHOTOS OF Farewell Party click here
But I took a bunch of photographs all the same. My job is essentially to document, to comment, and to march forward. One thing I learned this year is how isolated our many Isles of Shoals groups are from one another. There are those who love the island history, others who love the rocks, the scenery, the botany, the marine biology, the boating, the creative inspiration, and the family vacations. But those worlds rarely overlap. At the Shoals Marine Lab gathering last weekend all of the directors of the Cornell educational program begun in the 1960s gathered in one place for the first time. The group will soon celebrate its 50th year, yet I knew only one of the SML leaders. I met John Kingsbury, the University of New Hampshire founder of the AppledoreIsland program this weekend. How strange is that? Our worlds have been so close together, yet so far apart.
One major goal of this exhibit and the book was to begin to unite the fractional lovers of the Shoals who have been as separate from one another over the years as the layers in an archaeological dig. Not only are Shoalers separated by interest, but they are separated by deep waters. I spoke to people who, after decades at Apledore’s lab, had never been to Star or to Appledore or to White island. Each island is, well, an island unto itself. Past administrations on each island seemed to reinforce their separateness. Star used to dicourage non-conference visitors from coming ashore. Appledore is primarily for biology students. Smuttynose is inaccessible except to small boats. And a great many Seacoast residents have never even taken a tour out to the nine rocky islands visible from the mainland. I hope we helped to change that.
READ: What this exhibit taught us
In “Under the Isles of Shoals” I worked to combine history, scenery, marine biology, and anthropology into a flowing narrative for general readers. I knew from the get-go that archaeology is not everyone’s cup of tea. Even some historians have little interest in stuff dug out of the ground and prefer to dig their facts out of the written record. Biologists who study living things are sometimes only slightly curious about how those living things lived in years gone by. If the exhibit and the book got some cross-disciplinary discussions going, then it was certainly worth a year of my life. But what am I doing next year? The freelance writer is a bit like a hobo hopping from one train to another, destination unknown.
I didn’t actually build the replica of the Mid-Ocean House hotel porch that was one of the highlights of the show. I drew the plans, but didn’t wield a hammer. My neighbor Ed Valena and his crew (see How We Built the Shoals Exhibit) did the heavy lifting. The materials came from the Isles of Shoals and to prevent the wooden structure from falling down on summer tourists, the exhibit was built like a battleship. Ed swore he wasn’t going to get drawn into tearing it down. But the day after the show closed, there he was with his sledgehammer in hand.
SEE the actual hotel porch on Smuttynose circa 1870
My longtime friends Barry and Judy Pitchforth of Arundel, Maine also helped pull the porch apart. Tony Freeman and Dale Valena helped load the dismembered pieces into Karen Carpenter’s truck. But that’s not the end of the story. The pieces of the fake hotel, that used to be pieces of some other building, have a new task ahead of them. They will be refitted, Karen says, into an outhouse for a cabin in the woods of Vermont. What goes around comes around.
But what about me? How will this aging author be recycled? What destination will the history hobo take? Inquiring minds want to know.
© 2012 by J. Dennis Robinson. All rights reserved
Continued MORE PIX next page
Shoals Marine Lab Celebration
Discover Portsmouth, Septmeber 2012
(c) 2012 SeacoastNH.com
Joomla! Debug Console
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 ⇒ https://www.seacoastnh.com/portsmouth-aqueduct-company-piped-water-through-logs/
link ⇒ https://www.seacoastnh.com/warner-house-built-300-years-ago/
link ⇒ https://www.seacoastnh.com/living-with-the-ghost-of-ichabod-goodwin/
link ⇒ https://www.seacoastnh.com/walking-the-historic-streets-of-portsmouth-nh/
link ⇒ https://www.seacoastnh.com/the-science-of-the-historic-appledore-island-garden/
link ⇒ https://www.seacoastnh.com/a-quick-history-of-gulls-on-the-shoals/
link ⇒ https://www.seacoastnh.com/the-making-of-an-unprecedented-edmund-tarbell-art-exhibit/
link ⇒ https://www.seacoastnh.com/nh-born-publisher-enticed-charles-dickens-back-to-america-in-1867/
link ⇒ https://www.seacoastnh.com/three-lives-of-the-portsmouth-marine-society/
link ⇒ https://www.seacoastnh.com/ben-franklin-installed-new-hampshire-lightning-rod-in-1763/
link ⇒ https://www.seacoastnh.com/kittery-little-red-schoolhouse-on-life-support/
link ⇒ https://www.seacoastnh.com/the-man-who-dug-up-john-paul-jones/
link ⇒ https://www.seacoastnh.com/miss-nancy-underhill-swept-off-star-island-in-1848/
link ⇒ https://www.seacoastnh.com/us-wwii-ambassador-john-winant-gets-his-memorial-at-las/
link ⇒ https://www.seacoastnh.com/the-unexpected-portsmouth-art-gallery/
link ⇒ https://www.seacoastnh.com/inside-the-wondrous-woodman-museum/
link ⇒ https://www.seacoastnh.com/my-favorite-portsmouth-history-books-for-kids/
link ⇒ https://www.seacoastnh.com/main-street-south-berwick-over-200-years/
link ⇒ https://www.seacoastnh.com/lakes-region-legends-celebrated-in-new-book/
link ⇒ https://www.seacoastnh.com/the-truth-about-bricks-and-mortar/
session.client.forwarded ⇒ 10.3.184.74
6.24 MB (6,541,744 Bytes)
58 Queries Logged
SELECT `data`
FROM `rabbul_session`
WHERE `session_id` = 'a7dfa834352db2eaacc38c652b2c5638'DELETE
FROM `rabbul_session`
WHERE `time` < '1793612401'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 = 'tearing-down-the-hotel-porch/?print=1&tmpl=component'
AND published='1'
LIMIT 1SELECT id
FROM rabbul_menu
WHERE alias='tearing-down-the-hotel-porch'
AND published=1SELECT id
FROM rabbul_categories
WHERE path='tearing-down-the-hotel-porch'
AND extension='com_content'SELECT id,catid
FROM rabbul_content
WHERE alias='tearing-down-the-hotel-porch'
AND state>0SELECT id,catid
FROM rabbul_content
WHERE alias='tearing-down-the-hotel-porch'
AND state>0SELECT id
FROM rabbul_menu
WHERE type='component'
AND published='1'
AND link LIKE 'index.php?option=com_content&view=article%&id=3431'
ORDER BY idSELECT id
FROM rabbul_menu
WHERE type='component'
AND published='1'
AND link LIKE 'index.php?option=com_content&view=categor%&id=258'
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.3.184.74' OR `ip` LIKE '%*%')
AND `type`='1'
AND `published`='1'SELECT `ip`,`reason`
FROM rabbul_rsfirewall_lists
WHERE (`ip`='10.3.184.74' 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 = 3431
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-02 09:55:01')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-02 09:55:01')
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=258
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 = 3431UPDATE rabbul_content
SET hits = hits + 1
WHERE id = 3431UPDATE `rabbul_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1793613288;s:18:\"session.timer.last\";i:1793613299;s:17:\"session.timer.now\";i:1793613301;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:\"17b5fd6139e31f9ab60141b139c32beba2496ea5\";O:8:\"stdClass\":2:{s:4:\"link\";s:80:\"https://www.seacoastnh.com/portsmouth-aqueduct-company-piped-water-through-logs/\";s:6:\"expiry\";i:1793613300;}s:40:\"dcb5de8213c91dce6ccce409295be73fb6ed67e4\";O:8:\"stdClass\":2:{s:4:\"link\";s:60:\"https://www.seacoastnh.com/warner-house-built-300-years-ago/\";s:6:\"expiry\";i:1793613300;}s:40:\"6a61371e615cc0fd4cb9ebb8f04df9032cda85a4\";O:8:\"stdClass\":2:{s:4:\"link\";s:68:\"https://www.seacoastnh.com/living-with-the-ghost-of-ichabod-goodwin/\";s:6:\"expiry\";i:1793613300;}s:40:\"6612c67e9371c8289c8f07f4f1ac0f5ce3b0e380\";O:8:\"stdClass\":2:{s:4:\"link\";s:73:\"https://www.seacoastnh.com/walking-the-historic-streets-of-portsmouth-nh/\";s:6:\"expiry\";i:1793613300;}s:40:\"796cec1ba660aa46a08766b75d3d7d4190fe2595\";O:8:\"stdClass\":2:{s:4:\"link\";s:79:\"https://www.seacoastnh.com/the-science-of-the-historic-appledore-island-garden/\";s:6:\"expiry\";i:1793613300;}s:40:\"3f80e2188ebaa23717eb2907efd080256f93626f\";O:8:\"stdClass\":2:{s:4:\"link\";s:66:\"https://www.seacoastnh.com/a-quick-history-of-gulls-
on-the-shoals/\";s:6:\"expiry\";i:1793613300;}s:40:\"3b7255bca30035860e7401ae393dc4d0890cfd91\";O:8:\"stdClass\":2:{s:4:\"link\";s:85:\"https://www.seacoastnh.com/the-making-of-an-unprecedented-edmund-tarbell-art-exhibit/\";s:6:\"expiry\";i:1793613300;}s:40:\"09a898b238f31f38351174f69b03efdcd7e57023\";O:8:\"stdClass\":2:{s:4:\"link\";s:93:\"https://www.seacoastnh.com/nh-born-publisher-enticed-charles-dickens-back-to-america-in-1867/\";s:6:\"expiry\";i:1793613300;}s:40:\"59c072fc27cf510a575e15f145567edb3e726800\";O:8:\"stdClass\":2:{s:4:\"link\";s:72:\"https://www.seacoastnh.com/three-lives-of-the-portsmouth-marine-society/\";s:6:\"expiry\";i:1793613300;}s:40:\"71669e00f3cafc73ad2ea51d8e694e45c3dad86a\";O:8:\"stdClass\":2:{s:4:\"link\";s:86:\"https://www.seacoastnh.com/ben-franklin-installed-new-hampshire-lightning-rod-in-1763/\";s:6:\"expiry\";i:1793613300;}s:40:\"561fe3d193c8cf76097de9e1e1646d9a24047703\";O:8:\"stdClass\":2:{s:4:\"link\";s:74:\"https://www.seacoastnh.com/kittery-little-red-schoolhouse-
on-life-support/\";s:6:\"expiry\";i:1793613300;}s:40:\"95900dcbf681df0e2ffc28925af4e72f89e14723\";O:8:\"stdClass\":2:{s:4:\"link\";s:62:\"https://www.seacoastnh.com/the-man-who-dug-up-john-paul-jones/\";s:6:\"expiry\";i:1793613300;}s:40:\"2c129eb21315550fdbcb724330f9cb66dba5309b\";O:8:\"stdClass\":2:{s:4:\"link\";s:78:\"https://www.seacoastnh.com/miss-nancy-underhill-swept-off-star-island-in-1848/\";s:6:\"expiry\";i:1793613300;}s:40:\"549545430837ab8e9979c2c30979e988ba84099e\";O:8:\"stdClass\":2:{s:4:\"link\";s:83:\"https://www.seacoastnh.com/us-wwii-ambassador-john-winant-gets-his-memorial-at-las/\";s:6:\"expiry\";i:1793613300;}s:40:\"68c38363bc89b6974f1de462ea931066e07a5e08\";O:8:\"stdClass\":2:{s:4:\"link\";s:65:\"https://www.seacoastnh.com/the-unexpected-portsmouth-art-gallery/\";s:6:\"expiry\";i:1793613300;}s:40:\"8dd99c9e7785de3b5dff62ac2486f50ebd1f1f90\";O:8:\"stdClass\":2:{s:4:\"link\";s:62:\"https://www.seacoastnh.com/inside-the-wondrous-woodman-museum/\";s:6:\"expiry\";i:1793613300;}s:40:\"9eadd2fb61daa8cbbbed960824f00455257b462d\";O:8:\"stdClass\":2:{s:4:\"link\";s:73:\"https://www.seacoastnh.com/my-favorite-portsmouth-history-books-for-kids/\";s:6:\"expiry\";i:1793613300;}s:40:\"63185d6191a3f8a115a0525afd00d1780ff22bd2\";O:8:\"stdClass\":2:{s:4:\"link\";s:68:\"https://www.seacoastnh.com/main-street-south-berwick-over-200-years/\";s:6:\"expiry\";i:1793613300;}s:40:\"e0df74167a31574bb1002019ef2c389fb9ccc447\";O:8:\"stdClass\":2:{s:4:\"link\";s:71:\"https://www.seacoastnh.com/lakes-region-legends-celebrated-in-new-book/\";s:6:\"expiry\";i:1793613300;}s:40:\"2548aaff4c8ac21094ff9c5f3ffb06dcc77e9c3e\";O:8:\"stdClass\":2:{s:4:\"link\";s:61:\"https://www.seacoastnh.com/the-truth-about-bricks-
and-mortar/\";s:6:\"expiry\";i:1793613300;}}s:24:\"session.client.forwarded\";s:11:\"10.3.184.74\";}'
, `time` = '1793613301'
WHERE `session_id` = 'a7dfa834352db2eaacc38c652b2c5638'
37 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
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 parent
OTHER Tables:
1 × UPDATE rabbul_content
SET hits = hits + 11 × UPDATE `rabbul_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1793613288;s:18:\"session.timer.last\";i:1793613299;s:17:\"session.timer.now\";i:1793613301;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:\"17b5fd6139e31f9ab60141b139c32beba2496ea5\";O:8:\"stdClass\":2:{s:4:\"link\";s:80:\"https://www.seacoastnh.com/portsmouth-aqueduct-company-piped-water-through-logs/\";s:6:\"expiry\";i:1793613300;}s:40:\"dcb5de8213c91dce6ccce409295be73fb6ed67e4\";O:8:\"stdClass\":2:{s:4:\"link\";s:60:\"https://www.seacoastnh.com/warner-house-built-300-years-ago/\";s:6:\"expiry\";i:1793613300;}s:40:\"6a61371e615cc0fd4cb9ebb8f04df9032cda85a4\";O:8:\"stdClass\":2:{s:4:\"link\";s:68:\"https://www.seacoastnh.com/living-with-the-ghost-of-ichabod-goodwin/\";s:6:\"expiry\";i:1793613300;}s:40:\"6612c67e9371c8289c8f07f4f1ac0f5ce3b0e380\";O:8:\"stdClass\":2:{s:4:\"link\";s:73:\"https://www.seacoastnh.com/walking-the-historic-streets-of-portsmouth-nh/\";s:6:\"expiry\";i:1793613300;}s:40:\"796cec1ba660aa46a08766b75d3d7d4190fe2595\";O:8:\"stdClass\":2:{s:4:\"link\";s:79:\"https://www.seacoastnh.com/the-science-of-the-historic-appledore-island-garden/\";s:6:\"expiry\";i:1793613300;}s:40:\"3f80e2188ebaa23717eb2907efd080256f93626f\";O:8:\"stdClass\":2:{s:4:\"link\";s:66:\"https://www.seacoastnh.com/a-quick-history-of-gulls-
on-the-shoals/\";s:6:\"expiry\";i:1793613300;}s:40:\"3b7255bca30035860e7401ae393dc4d0890cfd91\";O:8:\"stdClass\":2:{s:4:\"link\";s:85:\"https://www.seacoastnh.com/the-making-of-an-unprecedented-edmund-tarbell-art-exhibit/\";s:6:\"expiry\";i:1793613300;}s:40:\"09a898b238f31f38351174f69b03efdcd7e57023\";O:8:\"stdClass\":2:{s:4:\"link\";s:93:\"https://www.seacoastnh.com/nh-born-publisher-enticed-charles-dickens-back-to-america-in-1867/\";s:6:\"expiry\";i:1793613300;}s:40:\"59c072fc27cf510a575e15f145567edb3e726800\";O:8:\"stdClass\":2:{s:4:\"link\";s:72:\"https://www.seacoastnh.com/three-lives-of-the-portsmouth-marine-society/\";s:6:\"expiry\";i:1793613300;}s:40:\"71669e00f3cafc73ad2ea51d8e694e45c3dad86a\";O:8:\"stdClass\":2:{s:4:\"link\";s:86:\"https://www.seacoastnh.com/ben-franklin-installed-new-hampshire-lightning-rod-in-1763/\";s:6:\"expiry\";i:1793613300;}s:40:\"561fe3d193c8cf76097de9e1e1646d9a24047703\";O:8:\"stdClass\":2:{s:4:\"link\";s:74:\"https://www.seacoastnh.com/kittery-little-red-schoolhouse-
on-life-support/\";s:6:\"expiry\";i:1793613300;}s:40:\"95900dcbf681df0e2ffc28925af4e72f89e14723\";O:8:\"stdClass\":2:{s:4:\"link\";s:62:\"https://www.seacoastnh.com/the-man-who-dug-up-john-paul-jones/\";s:6:\"expiry\";i:1793613300;}s:40:\"2c129eb21315550fdbcb724330f9cb66dba5309b\";O:8:\"stdClass\":2:{s:4:\"link\";s:78:\"https://www.seacoastnh.com/miss-nancy-underhill-swept-off-star-island-in-1848/\";s:6:\"expiry\";i:1793613300;}s:40:\"549545430837ab8e9979c2c30979e988ba84099e\";O:8:\"stdClass\":2:{s:4:\"link\";s:83:\"https://www.seacoastnh.com/us-wwii-ambassador-john-winant-gets-his-memorial-at-las/\";s:6:\"expiry\";i:1793613300;}s:40:\"68c38363bc89b6974f1de462ea931066e07a5e08\";O:8:\"stdClass\":2:{s:4:\"link\";s:65:\"https://www.seacoastnh.com/the-unexpected-portsmouth-art-gallery/\";s:6:\"expiry\";i:1793613300;}s:40:\"8dd99c9e7785de3b5dff62ac2486f50ebd1f1f90\";O:8:\"stdClass\":2:{s:4:\"link\";s:62:\"https://www.seacoastnh.com/inside-the-wondrous-woodman-museum/\";s:6:\"expiry\";i:1793613300;}s:40:\"9eadd2fb61daa8cbbbed960824f00455257b462d\";O:8:\"stdClass\":2:{s:4:\"link\";s:73:\"https://www.seacoastnh.com/my-favorite-portsmouth-history-books-for-kids/\";s:6:\"expiry\";i:1793613300;}s:40:\"63185d6191a3f8a115a0525afd00d1780ff22bd2\";O:8:\"stdClass\":2:{s:4:\"link\";s:68:\"https://www.seacoastnh.com/main-street-south-berwick-over-200-years/\";s:6:\"expiry\";i:1793613300;}s:40:\"e0df74167a31574bb1002019ef2c389fb9ccc447\";O:8:\"stdClass\":2:{s:4:\"link\";s:71:\"https://www.seacoastnh.com/lakes-region-legends-celebrated-in-new-book/\";s:6:\"expiry\";i:1793613300;}s:40:\"2548aaff4c8ac21094ff9c5f3ffb06dcc77e9c3e\";O:8:\"stdClass\":2:{s:4:\"link\";s:61:\"https://www.seacoastnh.com/the-truth-about-bricks-
and-mortar/\";s:6:\"expiry\";i:1793613300;}}s:24:\"session.client.forwarded\";s:11:\"10.3.184.74\";}' , `time` = '1793613301'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`