|
Moving the 1789 Fire Society Treasure Trunk |
Seacoast History Blog #143
September 27, 2012
It was supposed to be a bigger affair. Plans to move the Federal Fire Society archive from the vault at Piscataqua Savings Bank across Market Square to the Portsmouth Athenaeum originally included an escort by fire department members. That plan was trimmed down to one, as Assistant Fire Chief Stephen Achilles helped carry the wooden trunk containing the records of the 1798 organization from the city’s oldest bank to the city’s ancient research library just a block away. It was, all the same, an historic event, and I was honored to be asked to tag along. Next year is the bicentennial of the Great Fire of 1813 that devastated the city and it was time for the treasures of the 1798 organization to finally see the light of day. You will get to see what’s in the trunk as part of an Athenaeum exhibit next year. But here’s a quick and exclusive peak inside. (See photos below)
READ MORE about the Portsmouth Federal Fire Society
The Federal Fire Society still exists, although its small hand-picked membership (no more than 35 members by club rules) no longer put out fires. But modern members are required to own two leather fire buckets similar to those used in the days of the “bucket brigades” that attempted to quell the fires that plagued Portsmouth and other old cities back in the days when tightly-packed wooden buildings could easily be destroyed. All it took was a spark from a fireplace or an upset oil lamp, or any of a dozen sources. Groups like the Federal Fire Society formed to protect the homes and property of its members. Despite their efforts, hundreds of buildings burned in a series of three downtown fires in 1802, 1806, and 1813. Modern members must also own a bag like those used to hold the valuables of those whose homes were engulfed by flame. Thieves were all around in the early days and FFS members were required to guard the valuables of other members. Putting out the fire was secondary to preserving possessions.
The fires sparked the Brick Act of 1814 that legislated the use of brick instead of wood in buildings downtown. Richard Candee, an expert on the topic, led a walking tour last week to point out how the Brick Act impacted the developing port city. Historian Joyce Volk is an expert on the three famous “Christmas fires” and she will be studying the contents of the FFS trunk at the Athenaeum. Stephen Achilles is a scholar of the history of the Portsmouth Fire Department that evolved out of the early fire societies. Steve has written a book on the topic and was instrumental in getting the 1870 pumper Kearsarge back in the city where it will be fully restored as a memento of the days of horse-drawn engines.
For decades now the Federal Fire Society has been a semi-secret club, staying out of the limelight. It existed mostly as a social club where members met annually for dinner and drinks to invoke the memory of their founders. The group’s treasures were kept in the barn of one of the members until about 15 years ago when they moved to the vault at the bank. The trunk that the FFS members carried through the street yesterday is only about 100 years old. But inside it are all the artifacts of the original 1798 organization and all the memorabilia gathered by FFS members since. I was allowed a quick peek inside the trunk (see photos below) before it was moved to the Athenaeum. The contents will be studied and catalogued in preparation for the exhibit at the Athenaeum next year.
It was a quiet event, but it truly is a big deal. Rarely dies a cache of artifacts like this find its way into public view. The FFS members have been good stewards of the past and now, finally, they are passing their treasures to the rest of us. The fact that the city has recovered the amazing Kearsarge pumper at the same time is a wonderful coincidence. All ancient cities have a memory of fire. In Portsmouth, the memory of fire is almost as important as our memory of the sea. Thanks to the FFS and the scholars like Candee, and Volk, and Achilles – that memory still shines a light on the city’s past. And the past, as many of us believe, is Portsmouth’s future.
© 2012 by J. Dennis Robinson. All rights reserved.
September 26, 2012
Photos and text (c) SeacoastNH.com.
Joomla! Debug Console
session.client.forwarded ⇒ 10.3.184.74
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/
6.23 MB (6,535,296 Bytes)
57 Queries Logged
SELECT `data`
FROM `rabbul_session`
WHERE `session_id` = '7d9ed3fcff48d33aad77ea01546b2566'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 = 'moving-the-1789-fire-society-treasure-trunk/?print=1&tmpl=component'
AND published='1'
LIMIT 1SELECT id
FROM rabbul_menu
WHERE alias='moving-the-1789-fire-society-treasure-trunk'
AND published=1SELECT id
FROM rabbul_categories
WHERE path='moving-the-1789-fire-society-treasure-trunk'
AND extension='com_content'SELECT id,catid
FROM rabbul_content
WHERE alias='moving-the-1789-fire-society-treasure-trunk'
AND state>0SELECT id,catid
FROM rabbul_content
WHERE alias='moving-the-1789-fire-society-treasure-trunk'
AND state>0SELECT id
FROM rabbul_menu
WHERE type='component'
AND published='1'
AND link LIKE 'index.php?option=com_content&view=article%&id=3460'
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 = 3460
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-02 08:09:02')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-02 08:09:02')
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 = 3460UPDATE rabbul_content
SET hits = hits + 1
WHERE id = 3460UPDATE `rabbul_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1793606941;s:18:\"session.timer.last\";i:1793606941;s:17:\"session.timer.now\";i:1793606942;s:24:\"session.client.forwarded\";s:11:\"10.3.184.74\";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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}}}'
, `time` = '1793606942'
WHERE `session_id` = '7d9ed3fcff48d33aad77ea01546b2566'
36 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_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1793606941;s:18:\"session.timer.last\";i:1793606941;s:17:\"session.timer.now\";i:1793606942;s:24:\"session.client.forwarded\";s:11:\"10.3.184.74\";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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}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:1793606942;}}}' , `time` = '1793606942'1 × UPDATE rabbul_content
SET hits = hits + 11 × SHOW FULL COLUMNS
FROM `rabbul_rsfirewall_logs1 × SHOW FULL COLUMNS
FROM `rabbul_assets1 × SHOW FULL COLUMNS
FROM `rabbul_sef_config