|
|
|
|||||||||||
|
Copyright ® 1996-2020 SeacoastNH.com. All rights reserved. Privacy Statement Site maintained by ad-cetera graphics |
|||||||||||||
| Call stack | ||
| # | Function | Location |
|---|---|---|
| 1 | JSite->render() | JROOT/index.php:48 |
| 2 | JDocumentHTML->render() | JROOT/includes/application.php:268 |
| 3 | JDocumentHTML->_renderTemplate() | JROOT/libraries/joomla/document/html/html.php:433 |
| 4 | JDocumentHTML->getBuffer() | JROOT/libraries/joomla/document/html/html.php:652 |
| 5 | JDocumentRendererModules->render() | JROOT/libraries/joomla/document/html/html.php:371 |
| 6 | JDocumentRendererModule->render() | JROOT/libraries/joomla/document/html/renderer/modules.php:39 |
| 7 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/html/renderer/module.php:107 |
| 8 | include() | JROOT/libraries/joomla/application/module/helper.php:173 |
| 9 | modFeedHelper::getFeed() | JROOT/modules/mod_feed/mod_feed.php:27 |
| 10 | JFactory::getFeedParser() | JROOT/modules/mod_feed/helper.php:33 |
| 11 | JError::raiseWarning() | JROOT/libraries/joomla/factory.php:371 |
| 12 | JError::raise() | JROOT/libraries/joomla/error/error.php:276 |
session.client.forwarded ⇒ 10.10.94.9
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/
Application 0.000 seconds (+0.000); 0.33 MB (+0.330) - afterLoadApplication 0.015 seconds (+0.015); 3.22 MB (+2.894) - afterInitialiseApplication 0.021 seconds (+0.006); 4.77 MB (+1.548) - afterRouteApplication 0.198 seconds (+0.178); 7.86 MB (+3.090) - afterDispatchApplication 0.200 seconds (+0.002); 8.05 MB (+0.187) - beforeRenderModule mod_custom (Footer)Application 0.201 seconds (+0.001); 8.06 MB (+0.010) - afterRenderModule mod_custom (Footer)Application 0.201 seconds (+0.000); 8.06 MB (-0.000) - beforeRenderModule mod_banners (Uncle Oscar)Application 0.203 seconds (+0.003); 8.17 MB (+0.108) - afterRenderModule mod_banners (Uncle Oscar)Application 0.203 seconds (+0.000); 8.18 MB (+0.016) - beforeRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)Application 0.205 seconds (+0.002); 8.30 MB (+0.123) - afterRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)Application 0.205 seconds (+0.000); 8.21 MB (-0.098) - beforeRenderModule mod_novarp (ISC/Star)Application 0.207 seconds (+0.002); 8.31 MB (+0.101) - afterRenderModule mod_novarp (ISC/Star)Application 0.207 seconds (+0.000); 8.19 MB (-0.121) - beforeRenderModule mod_banners (Music Hall)Application 0.208 seconds (+0.001); 8.20 MB (+0.013) - afterRenderModule mod_banners (Music Hall)Application 0.208 seconds (+0.000); 8.19 MB (-0.009) - beforeRenderModule mod_banners (Maren)Application 0.210 seconds (+0.001); 8.21 MB (+0.014) - afterRenderModule mod_banners (Maren)Application 0.210 seconds (+0.000); 8.20 MB (-0.009) - beforeRenderModule mod_banners (Smuttynose Murders)Application 0.211 seconds (+0.001); 8.21 MB (+0.014) - afterRenderModule mod_banners (Smuttynose Murders)Application 0.211 seconds (+0.000); 8.20 MB (-0.009) - beforeRenderModule mod_banners (Banner Maine Harbors)Application 0.212 seconds (+0.001); 8.22 MB (+0.013) - afterRenderModule mod_banners (Banner Maine Harbors)Application 0.212 seconds (+0.000); 8.21 MB (-0.009) - beforeRenderModule mod_banners (Banner Sanctuary Hair)Application 0.213 seconds (+0.001); 8.22 MB (+0.013) - afterRenderModule mod_banners (Banner Sanctuary Hair)Application 0.213 seconds (+0.000); 8.21 MB (-0.009) - beforeRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)Application 0.214 seconds (+0.001); 8.22 MB (+0.011) - afterRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)Application 0.214 seconds (+0.000); 8.24 MB (+0.020) - beforeRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)Application 0.215 seconds (+0.001); 8.31 MB (+0.069) - afterRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)Application 0.215 seconds (+0.000); 8.21 MB (-0.097) - beforeRenderModule mod_banners (Banner sheraton wedding)Application 0.215 seconds (+0.001); 8.23 MB (+0.013) - afterRenderModule mod_banners (Banner sheraton wedding)Application 0.215 seconds (+0.000); 8.22 MB (-0.004) - beforeRenderModule mod_banners (Banner Boating)Application 0.216 seconds (+0.001); 8.23 MB (+0.008) - afterRenderModule mod_banners (Banner Boating)Application 0.216 seconds (+0.000); 8.23 MB (-0.005) - beforeRenderModule mod_banners (Banner Harbour arts)Application 0.217 seconds (+0.001); 8.23 MB (+0.008) - afterRenderModule mod_banners (Banner Harbour arts)Application 0.217 seconds (+0.000); 8.23 MB (-0.007) - beforeRenderModule mod_custom (Google Ads)Application 0.217 seconds (+0.000); 8.23 MB (+0.004) - afterRenderModule mod_custom (Google Ads)Application 0.217 seconds (+0.000); 8.23 MB (-0.002) - beforeRenderModule mod_banners (Banner Newmarket heritage)Application 0.218 seconds (+0.001); 8.24 MB (+0.008) - afterRenderModule mod_banners (Banner Newmarket heritage)Application 0.218 seconds (+0.000); 8.23 MB (-0.004) - beforeRenderModule mod_banners (Shoals Marine Ad)Application 0.219 seconds (+0.001); 8.24 MB (+0.010) - afterRenderModule mod_banners (Shoals Marine Ad)Application 0.219 seconds (+0.000); 8.23 MB (-0.008) - beforeRenderModule mod_feed (News about Portsmouth from Fosters.com)Application 0.288 seconds (+0.069); 8.66 MB (+0.427) - afterRenderModule mod_feed (News about Portsmouth from Fosters.com)Application 0.288 seconds (+0.000); 8.66 MB (-0.001) - beforeRenderModule mod_banners (ad bottom right top)Application 0.290 seconds (+0.003); 8.67 MB (+0.013) - afterRenderModule mod_banners (ad bottom right top)Application 0.290 seconds (+0.000); 8.67 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right mid)Application 0.292 seconds (+0.002); 8.68 MB (+0.014) - afterRenderModule mod_banners (ad bottom right mid)Application 0.292 seconds (+0.000); 8.67 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right bottom)Application 0.294 seconds (+0.002); 8.68 MB (+0.014) - afterRenderModule mod_banners (ad bottom right bottom)Application 0.294 seconds (+0.000); 8.68 MB (-0.008) - beforeRenderModule mod_banners (ad bottom mid top)Application 0.296 seconds (+0.002); 8.69 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid top)Application 0.296 seconds (+0.000); 8.68 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid mid)Application 0.298 seconds (+0.002); 8.69 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid mid)Application 0.298 seconds (+0.000); 8.69 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid bottom)Application 0.299 seconds (+0.002); 8.70 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid bottom)Application 0.299 seconds (+0.000); 8.69 MB (-0.008) - beforeRenderModule mod_banners (ad bottom left top)Application 0.301 seconds (+0.002); 8.70 MB (+0.014) - afterRenderModule mod_banners (ad bottom left top)Application 0.301 seconds (+0.000); 8.70 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left mid)Application 0.303 seconds (+0.002); 8.71 MB (+0.013) - afterRenderModule mod_banners (ad bottom left mid)Application 0.303 seconds (+0.000); 8.70 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left bottom)Application 0.304 seconds (+0.001); 8.71 MB (+0.011) - afterRenderModule mod_banners (ad bottom left bottom)Application 0.304 seconds (+0.000); 8.71 MB (-0.006) - beforeRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)Application 0.304 seconds (+0.000); 8.71 MB (+0.004) - afterRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)Application 0.304 seconds (+0.000); 8.71 MB (-0.001) - beforeRenderModule mod_finder (smart_search)Application 0.310 seconds (+0.006); 8.79 MB (+0.081) - afterRenderModule mod_finder (smart_search)Application 0.310 seconds (+0.000); 8.78 MB (-0.006) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)Application 0.311 seconds (+0.001); 8.81 MB (+0.031) - afterRenderModule mod_breadcrumbs (Breadcrumbs)Application 0.311 seconds (+0.000); 8.81 MB (-0.003) - beforeRenderModule mod_menu (topmenu)Application 0.311 seconds (+0.001); 8.83 MB (+0.016) - afterRenderModule mod_menu (topmenu)Application 0.311 seconds (+0.000); 8.82 MB (-0.006) - beforeRenderModule mod_custom (feedback)Application 0.311 seconds (+0.000); 8.83 MB (+0.004) - afterRenderModule mod_custom (feedback)Application 0.312 seconds (+0.000); 8.82 MB (-0.003) - beforeRenderModule mod_custom (SeacoastNH Feedback)Application 0.312 seconds (+0.000); 8.83 MB (+0.004) - afterRenderModule mod_custom (SeacoastNH Feedback)Application 0.312 seconds (+0.000); 8.82 MB (-0.003) - beforeRenderModule mod_custom (MainHeader)Application 0.312 seconds (+0.000); 8.83 MB (+0.004) - afterRenderModule mod_custom (MainHeader)Application 0.312 seconds (+0.000); 8.83 MB (-0.002) - beforeRenderModule mod_custom (Facebook)Application 0.312 seconds (+0.000); 8.83 MB (+0.004) - afterRenderModule mod_custom (Facebook)Application 0.312 seconds (+0.000); 8.83 MB (-0.002) - beforeRenderModule mod_menu (Main Menu)Application 0.319 seconds (+0.006); 8.90 MB (+0.071) - afterRenderModule mod_menu (Main Menu)Application 0.319 seconds (+0.000); 8.89 MB (-0.007) - beforeRenderModule mod_custom (Donate to Our Site)Application 0.319 seconds (+0.000); 8.90 MB (+0.004) - afterRenderModule mod_custom (Donate to Our Site)Application 0.319 seconds (+0.000); 8.89 MB (-0.003) - beforeRenderModule mod_custom (Feedjit)Application 0.319 seconds (+0.000); 8.90 MB (+0.004) - afterRenderModule mod_custom (Feedjit)Application 0.319 seconds (+0.000); 8.89 MB (-0.003) - beforeRenderModule mod_custom (facebook lower logo)Application 0.319 seconds (+0.000); 8.90 MB (+0.004) - afterRenderModule mod_custom (facebook lower logo)Application 0.320 seconds (+0.000); 9.10 MB (+0.202) - afterRender9.25 MB (9,699,624 Bytes)SELECT `data`
FROM `rabbul_session`
WHERE `session_id` = 'a26cb0b7b813866b0c2f500e7a64fdeb'DELETE
FROM `rabbul_session`
WHERE `time` < '1792185801'SELECT `session_id`
FROM `rabbul_session`
WHERE `session_id` = 'a26cb0b7b813866b0c2f500e7a64fdeb'
LIMIT 0, 1INSERT INTO `rabbul_session`
(`session_id`, `client_id`, `time`)
VALUES
('a26cb0b7b813866b0c2f500e7a64fdeb', 0, '1792186701')SELECT 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 id, rules
FROM `rabbul_viewlevels`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 `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.10.94.9' OR `ip` LIKE '%*%')
AND `type`='1'
AND `published`='1'SELECT `ip`,`reason`
FROM rabbul_rsfirewall_lists
WHERE (`ip`='10.10.94.9' 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 a.rules
FROM rabbul_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftSELECT 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 a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
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,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM rabbul_content AS a
LEFT JOIN rabbul_categories AS c
ON c.id = a.catid
LEFT JOIN rabbul_users AS ua
ON ua.id = a.created_by
LEFT JOIN rabbul_users AS uam
ON uam.id = a.modified_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 != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
INNER JOIN rabbul_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-16 21:38:21')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-16 21:38:21')
ORDER BY a.created DESC , a.created DESC
LIMIT 0, 30SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
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,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM rabbul_content AS a
LEFT JOIN rabbul_categories AS c
ON c.id = a.catid
LEFT JOIN rabbul_users AS ua
ON ua.id = a.created_by
LEFT JOIN rabbul_users AS uam
ON uam.id = a.modified_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 != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
INNER JOIN rabbul_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-16 21:38:21')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-16 21:38:21')
ORDER BY a.created DESC , a.created DESCSELECT alias,home
FROM rabbul_menu
WHERE id='100001'SELECT alias,home
FROM rabbul_menu
WHERE id='100001'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=257
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 = 3922SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3922SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3922SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3920SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3920SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3920SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3919SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3919SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3919SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3918SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3918SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3918SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3917SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3917SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3917SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3916SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3916SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3916SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3915SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3915SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3915SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3914SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3914SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3914SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3913SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3913SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3913SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3912SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3912SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3912SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3911SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3911SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3911SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3910SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3910SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3910SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3909SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3909SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3909SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3908SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3908SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3908SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3907SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3907SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3907SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3906SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3906SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3906SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3905SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3905SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3905SELECT 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 = 3904SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3904SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3904SELECT 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=140
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 = 3903SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3903SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3903SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3902SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3902SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3902SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3901SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3900SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3899SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3898SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3897SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3895SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3893SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3888SELECT 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=141
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 = 3871SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3860SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM rabbul_modules AS m
LEFT JOIN rabbul_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN rabbul_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.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-10-16 21:38:21')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-16 21:38:21')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 100001 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingSELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 46
AND cl.state = 1
AND a.catid IN (263)
ORDER BY a.sticky DESC,a.orderingSELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 46
AND cl.state = 1
AND a.catid IN (263)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 1UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 100SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=100
AND track_date='2026-10-16 21'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=100
AND track_date='2026-10-16 21'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=100
AND track_date='2026-10-16 21'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 100SELECT *
FROM rabbul_banners
WHERE state=1
AND ((NOW( ) BETWEEN `publish_up`
AND `publish_down` ) OR (`publish_down` = '0000-00-00 00:00:00'))
AND catid IN ( 290 )
ORDER BY ordering
LIMIT 3UPDATE `rabbul_banners`
SET `impmade` = (`impmade` + 1)
WHERE `id` = 79SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 79SELECT *
FROM rabbul_banners
WHERE state=1
AND ((NOW( ) BETWEEN `publish_up`
AND `publish_down` ) OR (`publish_down` = '0000-00-00 00:00:00'))
AND catid IN ( 295 )
ORDER BY ordering
LIMIT 2UPDATE `rabbul_banners`
SET `impmade` = (`impmade` + 1)
WHERE `id` = 45SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 45UPDATE `rabbul_banners`
SET `impmade` = (`impmade` + 1)
WHERE `id` = 94SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 94SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 9
AND cl.state = 1
AND a.catid IN (329)
ORDER BY a.sticky DESC,a.orderingSELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 9
AND cl.state = 1
AND a.catid IN (329)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 1UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 91SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 91SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 36
AND cl.state = 1
AND a.catid IN (261)
ORDER BY a.sticky DESC,a.orderingSELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 36
AND cl.state = 1
AND a.catid IN (261)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 1UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 87SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=87
AND track_date='2026-10-16 21'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=87
AND track_date='2026-10-16 21'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=87
AND track_date='2026-10-16 21'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 87SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 36
AND cl.state = 1
AND a.catid IN (267)
ORDER BY a.sticky DESC,a.orderingSELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 36
AND cl.state = 1
AND a.catid IN (267)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 1UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 84SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=84
AND track_date='2026-10-16 21'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=84
AND track_date='2026-10-16 21'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=84
AND track_date='2026-10-16 21'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 84SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 13
AND cl.state = 1
ORDER BY a.sticky DESC,a.orderingSELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 13
AND cl.state = 1
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 3UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 14SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 14SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 12
AND cl.state = 1
ORDER BY a.sticky DESC,a.orderingSELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 12
AND cl.state = 1
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 3UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 19SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 19SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 2
AND cl.state = 1
AND a.catid = 271
ORDER BY a.sticky DESC,RAND()SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 2
AND cl.state = 1
AND a.catid = 271
ORDER BY a.sticky DESC,RAND()
LIMIT 0, 3SELECT *
FROM rabbul_banners
WHERE state=1
AND ((NOW( ) BETWEEN `publish_up`
AND `publish_down` ) OR (`publish_down` = '0000-00-00 00:00:00'))
AND catid IN ( 265 )
ORDER BY ordering
LIMIT 2SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 6
AND cl.state = 1
AND a.catid = 273
ORDER BY a.sticky DESC,RAND()SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 6
AND cl.state = 1
AND a.catid = 273
ORDER BY a.sticky DESC,RAND()
LIMIT 0, 1SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 22
AND cl.state = 1
ORDER BY a.sticky DESC,a.orderingSELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 22
AND cl.state = 1
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 3SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 21
AND cl.state = 1
ORDER BY a.sticky DESC,a.orderingSELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 21
AND cl.state = 1
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 3SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 20
AND cl.state = 1
AND a.catid = 259
ORDER BY a.sticky DESC,RAND()SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 20
AND cl.state = 1
AND a.catid = 259
ORDER BY a.sticky DESC,RAND()
LIMIT 0, 1SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 18
AND cl.state = 1
AND a.catid = 259
ORDER BY a.sticky DESC,RAND()SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 18
AND cl.state = 1
AND a.catid = 259
ORDER BY a.sticky DESC,RAND()
LIMIT 0, 1UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 95SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=95
AND track_date='2026-10-16 21'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=95
AND track_date='2026-10-16 21'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=95
AND track_date='2026-10-16 21'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 95SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 19
AND cl.state = 1
AND a.catid IN (282)
ORDER BY a.sticky DESC,RAND()SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 19
AND cl.state = 1
AND a.catid IN (282)
ORDER BY a.sticky DESC,RAND()
LIMIT 0, 4UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 29SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 29SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 5
AND cl.state = 1
AND a.catid IN (283)
ORDER BY a.sticky DESC,RAND()SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 5
AND cl.state = 1
AND a.catid IN (283)
ORDER BY a.sticky DESC,RAND()
LIMIT 0, 4UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 30SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=30
AND track_date='2026-10-16 21'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=30
AND track_date='2026-10-16 21'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=30
AND track_date='2026-10-16 21'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 30SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 9
AND cl.state = 1
AND a.catid IN (284)
ORDER BY a.sticky DESC,RAND()SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 9
AND cl.state = 1
AND a.catid IN (284)
ORDER BY a.sticky DESC,RAND()
LIMIT 0, 4UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 31SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=31
AND track_date='2026-10-16 21'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=31
AND track_date='2026-10-16 21'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=31
AND track_date='2026-10-16 21'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 31SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (279)
ORDER BY a.sticky DESC,RAND()SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (279)
ORDER BY a.sticky DESC,RAND()
LIMIT 0, 4UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 26SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 26SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 2
AND cl.state = 1
AND a.catid IN (280)
ORDER BY a.sticky DESC,RAND()SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 2
AND cl.state = 1
AND a.catid IN (280)
ORDER BY a.sticky DESC,RAND()
LIMIT 0, 4UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 27SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 27SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 6
AND cl.state = 1
AND a.catid IN (281)
ORDER BY a.sticky DESC,RAND()SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 6
AND cl.state = 1
AND a.catid IN (281)
ORDER BY a.sticky DESC,RAND()
LIMIT 0, 4UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 28SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 28SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 15
AND cl.state = 1
AND a.catid IN (276)
ORDER BY a.sticky DESC,RAND()SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 15
AND cl.state = 1
AND a.catid IN (276)
ORDER BY a.sticky DESC,RAND()
LIMIT 0, 4UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 23SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=23
AND track_date='2026-10-16 21'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=23
AND track_date='2026-10-16 21'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=23
AND track_date='2026-10-16 21'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 23SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 30
AND cl.state = 1
AND a.catid IN (277)
ORDER BY a.sticky DESC,RAND()SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 30
AND cl.state = 1
AND a.catid IN (277)
ORDER BY a.sticky DESC,RAND()
LIMIT 0, 1UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 65SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 65SELECT *
FROM rabbul_banners
WHERE '2026-10-16 21:38:21' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 43
AND cl.state = 1
AND a.catid IN (278)
ORDER BY a.sticky DESC,RAND()SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 43
AND cl.state = 1
AND a.catid IN (278)
ORDER BY a.sticky DESC,RAND()
LIMIT 0, 5SELECT extension_id AS id, element AS "option", params, enabled
FROM rabbul_extensions
WHERE `type` = 'component'
AND `element` = 'com_finder'SELECT name
FROM `rabbul_extensions`
WHERE `type` = 'plugin'
AND `folder` = 'finder'
AND `enabled` = 1SELECT `title`
FROM `rabbul_finder_taxonomy`
WHERE `parent_id` = 1
AND `state` = 1
AND `access` IN (1,1)SELECT link
FROM rabbul_menu
WHERE id=100196SELECT link
FROM rabbul_menu
WHERE id=100001SELECT link
FROM rabbul_menu
WHERE id=269SELECT path
FROM rabbul_categories
WHERE id = 307SELECT link
FROM rabbul_menu
WHERE id=157SELECT path
FROM rabbul_categories
WHERE id = 311SELECT link
FROM rabbul_menu
WHERE id=158SELECT path
FROM rabbul_categories
WHERE id = 312SELECT link
FROM rabbul_menu
WHERE id=264SELECT path
FROM rabbul_categories
WHERE id = 313SELECT link
FROM rabbul_menu
WHERE id=160SELECT path
FROM rabbul_categories
WHERE id = 314SELECT link
FROM rabbul_menu
WHERE id=161SELECT path
FROM rabbul_categories
WHERE id = 331SELECT link
FROM rabbul_menu
WHERE id=123SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 48SELECT link
FROM rabbul_menu
WHERE id=100014SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3835UPDATE `rabbul_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1792186701;s:18:\"session.timer.last\";i:1792186701;s:17:\"session.timer.now\";i:1792186701;s:24:\"session.client.forwarded\";s:10:\"10.10.94.9\";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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}}}'
, `time` = '1792186701'
WHERE `session_id` = 'a26cb0b7b813866b0c2f500e7a64fdeb'72 × SELECT a.alias AS article
FROM rabbul_content AS a40 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat
ON a.catid = cat.id21 × SELECT *
FROM rabbul_banners18 × SELECT b.alias AS banner
FROM rabbul_banners AS b15 × SELECT id
FROM rabbul_assets14 × SELECT `count`
FROM rabbul_banner_tracks10 × SELECT link
FROM rabbul_menu6 × SELECT path
FROM rabbul_categories4 × 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.rgt4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM rabbul_extensions3 × SELECT *
FROM rabbul_banners2 × SELECT alias,home
FROM rabbul_menu2 × SELECT b.rules
FROM rabbul_assets AS a
LEFT JOIN rabbul_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl
ON cl.id = a.cid2 × SELECT `ip`,`reason`
FROM rabbul_rsfirewall_lists2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
FROM rabbul_contact_details AS contact1 × SELECT *
FROM rabbul_languages1 × 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 a.rules
FROM rabbul_assets AS a1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM rabbul_modules AS m
LEFT JOIN rabbul_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN rabbul_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `title`
FROM `rabbul_finder_taxonomy`1 × SELECT name
FROM `rabbul_extensions`1 × SELECT *
FROM rabbul_rsfirewall_exceptions1 × SELECT *
FROM rabbul_rsfirewall_hashes1 × SELECT `value`
FROM `rabbul_admintools_storage`1 × SELECT `path`
FROM rabbul_rsfirewall_ignored1 × SELECT `file`
FROM rabbul_rsfirewall_hashes1 × SELECT `query`
FROM `rabbul_admintools_wafexceptions`1 × SELECT folder AS type, element AS name, params
FROM rabbul_extensions1 × SELECT `session_id`
FROM `rabbul_session`1 × 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, rules
FROM `rabbul_viewlevels1 × SELECT *
FROM rabbul_rsfirewall_configuratio1 × SELECT *
FROM rabbul_sef_config1 × SELECT rules
FROM rabbul_assets1 × SELECT u.*
FROM rabbul_user_usergroup_map m RIGHT JOIN rabbul_users u
ON (u.id=m.user_id)1 × SELECT `data`
FROM `rabbul_session`1 × SELECT parent.id, parent.lft, parent.rgt
FROM rabbul_usergroups AS parent1 × SELECT `id`
FROM `rabbul_usergroups1 × SELECT non_sef_url,alias
FROM rabbul_sef_alias1 × 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 *
FROM rabbul_rsfirewall_snapshots15 × UPDATE rabbul_banners
SET impmade = (impmade + 1)7 × UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)3 × UPDATE `rabbul_banners`
SET `impmade` = (`impmade` + 1)1 × UPDATE `rabbul_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1792186701;s:18:\"session.timer.last\";i:1792186701;s:17:\"session.timer.now\";i:1792186701;s:24:\"session.client.forwarded\";s:10:\"10.10.94.9\";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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}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:1792186701;}}}' , `time` = '1792186701'1 × SHOW FULL COLUMNS
FROM `rabbul_rsfirewall_logs1 × INSERT INTO `rabbul_session` (`session_id`, `client_id`, `time`)
VALUES ('a26cb0b7b813866b0c2f500e7a64fdeb', 0, '1792186701'1 × SHOW FULL COLUMNS
FROM `rabbul_sef_config1 × SHOW FULL COLUMNS
FROM `rabbul_assets1 × DELETE
FROM `rabbul_session`

HISTORY MATTERS
HISTORY MATTERS
HISTORY MATTERS
HISTORY MATTERS
HISTORY MATTERS
HISTORY MATTERS
HISTORY MATTERS
HISTORY MATTERS
HISTORY MATTERS
HISTORY MATTERS
HISTORY MATTERS
HISTORY MATTERS
HISTORY MATTERS
HISTORY MATTERS



Editor's Note: This is the second of a two-part interview with masonry consultant John Wastrom.