|
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
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.1.77.32
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/november-2007-seacoast-mail/
link ⇒ http://www.seacoastnh.com/read-our-mail-june-2004/
link ⇒ http://www.seacoastnh.com/read-our-mail-may-2004/
link ⇒ http://www.seacoastnh.com/read-our-mail-april-2004/
link ⇒ http://www.seacoastnh.com/read-our-mail-march-2004/
link ⇒ http://www.seacoastnh.com/read-our-mail-february-2004/
link ⇒ http://www.seacoastnh.com/read-our-mail-january-2004/
link ⇒ http://www.seacoastnh.com/june-2008-seacoast-mail/
link ⇒ http://www.seacoastnh.com/may-2008-seacoast-mail/
link ⇒ http://www.seacoastnh.com/april-2008-reader-letters/
link ⇒ http://www.seacoastnh.com/letters-march-2008/
link ⇒ http://www.seacoastnh.com/letters-february-2008/
link ⇒ http://www.seacoastnh.com/letters-january-2008/
link ⇒ http://www.seacoastnh.com/letters-december-2007/
link ⇒ http://www.seacoastnh.com/letters-october-2007/
link ⇒ http://www.seacoastnh.com/letters-september-2007/
link ⇒ http://www.seacoastnh.com/august-2007-letters/
link ⇒ http://www.seacoastnh.com/july-2007-letters/
link ⇒ http://www.seacoastnh.com/july-2009-reader-mail/
link ⇒ http://www.seacoastnh.com/june-2009-reader-mail/
link ⇒ http://www.seacoastnh.com/april-2009-seacoast-mail/
link ⇒ http://www.seacoastnh.com/march-2009-seacoast-letters/
link ⇒ http://www.seacoastnh.com/february-2009-reader-letters/
link ⇒ http://www.seacoastnh.com/january-2009-reader-mail/
link ⇒ http://www.seacoastnh.com/letters-december-2008/
link ⇒ http://www.seacoastnh.com/november-2008-reader-mail/
link ⇒ http://www.seacoastnh.com/october-2008-reader-mail/
link ⇒ http://www.seacoastnh.com/september-2008-letters/
link ⇒ http://www.seacoastnh.com/august-2008-seacoast-mail/
link ⇒ http://www.seacoastnh.com/july-2008-seacoast-mail/
link ⇒ http://www.seacoastnh.com/beckys-diner/
link ⇒ http://www.seacoastnh.com/moodys-diner/
link ⇒ http://www.seacoastnh.com/fogartys/
link ⇒ http://www.seacoastnh.com/gilleys/
link ⇒ http://www.seacoastnh.com/carmens-diner/
link ⇒ http://www.seacoastnh.com/the-ice-house/
link ⇒ http://www.seacoastnh.com/wheelies/
link ⇒ http://www.seacoastnh.com/loco-cocos-tacos/
link ⇒ http://www.seacoastnh.com/tam-vietnamese-restaurant/
link ⇒ http://www.seacoastnh.com/savarios/
link ⇒ http://www.seacoastnh.com/emilios/
link ⇒ http://www.seacoastnh.com/rye-harborside/
link ⇒ http://www.seacoastnh.com/bobs-clam-hut/
link ⇒ http://www.seacoastnh.com/penny-gourmet/
Application 0.000 seconds (+0.000); 0.33 MB (+0.331) - afterLoadApplication 0.014 seconds (+0.014); 3.24 MB (+2.908) - afterInitialiseApplication 0.022 seconds (+0.008); 5.05 MB (+1.809) - afterRouteApplication 0.077 seconds (+0.056); 7.11 MB (+2.066) - afterDispatchApplication 0.079 seconds (+0.001); 7.30 MB (+0.187) - beforeRenderModule mod_custom (Footer)Application 0.079 seconds (+0.001); 7.31 MB (+0.010) - afterRenderModule mod_custom (Footer)Application 0.079 seconds (+0.000); 7.31 MB (-0.000) - beforeRenderModule mod_banners (Uncle Oscar)Application 0.081 seconds (+0.002); 7.40 MB (+0.095) - afterRenderModule mod_banners (Uncle Oscar)Application 0.081 seconds (+0.000); 7.42 MB (+0.016) - beforeRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)Application 0.082 seconds (+0.001); 7.54 MB (+0.123) - afterRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)Application 0.082 seconds (+0.000); 7.45 MB (-0.098) - beforeRenderModule mod_novarp (ISC/Star)Application 0.083 seconds (+0.001); 7.55 MB (+0.101) - afterRenderModule mod_novarp (ISC/Star)Application 0.083 seconds (+0.000); 7.43 MB (-0.121) - beforeRenderModule mod_banners (Music Hall)Application 0.084 seconds (+0.001); 7.44 MB (+0.013) - afterRenderModule mod_banners (Music Hall)Application 0.084 seconds (+0.000); 7.43 MB (-0.009) - beforeRenderModule mod_banners (Maren)Application 0.085 seconds (+0.001); 7.45 MB (+0.015) - afterRenderModule mod_banners (Maren)Application 0.085 seconds (+0.000); 7.44 MB (-0.009) - beforeRenderModule mod_banners (Smuttynose Murders)Application 0.086 seconds (+0.001); 7.45 MB (+0.014) - afterRenderModule mod_banners (Smuttynose Murders)Application 0.086 seconds (+0.000); 7.44 MB (-0.009) - beforeRenderModule mod_banners (Banner Maine Harbors)Application 0.087 seconds (+0.001); 7.45 MB (+0.013) - afterRenderModule mod_banners (Banner Maine Harbors)Application 0.087 seconds (+0.000); 7.45 MB (-0.009) - beforeRenderModule mod_banners (Banner Sanctuary Hair)Application 0.088 seconds (+0.001); 7.46 MB (+0.013) - afterRenderModule mod_banners (Banner Sanctuary Hair)Application 0.088 seconds (+0.000); 7.45 MB (-0.009) - beforeRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)Application 0.088 seconds (+0.001); 7.46 MB (+0.011) - afterRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)Application 0.088 seconds (+0.000); 7.48 MB (+0.020) - beforeRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)Application 0.089 seconds (+0.001); 7.55 MB (+0.069) - afterRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)Application 0.089 seconds (+0.000); 7.45 MB (-0.097) - beforeRenderModule mod_banners (Banner sheraton wedding)Application 0.090 seconds (+0.001); 7.47 MB (+0.013) - afterRenderModule mod_banners (Banner sheraton wedding)Application 0.090 seconds (+0.000); 7.46 MB (-0.004) - beforeRenderModule mod_banners (Banner Boating)Application 0.090 seconds (+0.001); 7.47 MB (+0.008) - afterRenderModule mod_banners (Banner Boating)Application 0.090 seconds (+0.000); 7.47 MB (-0.005) - beforeRenderModule mod_banners (Banner Harbour arts)Application 0.091 seconds (+0.000); 7.47 MB (+0.008) - afterRenderModule mod_banners (Banner Harbour arts)Application 0.091 seconds (+0.000); 7.47 MB (-0.007) - beforeRenderModule mod_custom (Google Ads)Application 0.091 seconds (+0.000); 7.47 MB (+0.004) - afterRenderModule mod_custom (Google Ads)Application 0.091 seconds (+0.000); 7.47 MB (-0.002) - beforeRenderModule mod_banners (Banner Newmarket heritage)Application 0.091 seconds (+0.000); 7.48 MB (+0.008) - afterRenderModule mod_banners (Banner Newmarket heritage)Application 0.091 seconds (+0.000); 7.47 MB (-0.004) - beforeRenderModule mod_banners (Shoals Marine Ad)Application 0.092 seconds (+0.001); 7.48 MB (+0.010) - afterRenderModule mod_banners (Shoals Marine Ad)Application 0.092 seconds (+0.000); 7.47 MB (-0.008) - beforeRenderModule mod_feed (News about Portsmouth from Fosters.com)Application 0.113 seconds (+0.021); 7.90 MB (+0.427) - afterRenderModule mod_feed (News about Portsmouth from Fosters.com)Application 0.113 seconds (+0.000); 7.90 MB (-0.001) - beforeRenderModule mod_banners (ad bottom right top)Application 0.115 seconds (+0.001); 7.91 MB (+0.013) - afterRenderModule mod_banners (ad bottom right top)Application 0.115 seconds (+0.000); 7.91 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right mid)Application 0.116 seconds (+0.001); 7.92 MB (+0.014) - afterRenderModule mod_banners (ad bottom right mid)Application 0.116 seconds (+0.000); 7.91 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right bottom)Application 0.117 seconds (+0.001); 7.92 MB (+0.014) - afterRenderModule mod_banners (ad bottom right bottom)Application 0.117 seconds (+0.000); 7.92 MB (-0.008) - beforeRenderModule mod_banners (ad bottom mid top)Application 0.118 seconds (+0.001); 7.93 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid top)Application 0.118 seconds (+0.000); 7.92 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid mid)Application 0.119 seconds (+0.001); 7.93 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid mid)Application 0.119 seconds (+0.000); 7.93 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid bottom)Application 0.119 seconds (+0.001); 7.94 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid bottom)Application 0.119 seconds (+0.000); 7.93 MB (-0.008) - beforeRenderModule mod_banners (ad bottom left top)Application 0.121 seconds (+0.001); 7.94 MB (+0.014) - afterRenderModule mod_banners (ad bottom left top)Application 0.121 seconds (+0.000); 7.94 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left mid)Application 0.121 seconds (+0.001); 7.95 MB (+0.013) - afterRenderModule mod_banners (ad bottom left mid)Application 0.121 seconds (+0.000); 7.94 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left bottom)Application 0.122 seconds (+0.001); 7.95 MB (+0.011) - afterRenderModule mod_banners (ad bottom left bottom)Application 0.122 seconds (+0.000); 7.95 MB (-0.006) - beforeRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)Application 0.122 seconds (+0.000); 7.95 MB (+0.004) - afterRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)Application 0.122 seconds (+0.000); 7.95 MB (-0.001) - beforeRenderModule mod_finder (smart_search)Application 0.126 seconds (+0.003); 8.03 MB (+0.080) - afterRenderModule mod_finder (smart_search)Application 0.126 seconds (+0.000); 8.02 MB (-0.006) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)Application 0.126 seconds (+0.001); 8.04 MB (+0.013) - afterRenderModule mod_breadcrumbs (Breadcrumbs)Application 0.126 seconds (+0.000); 8.03 MB (-0.005) - beforeRenderModule mod_menu (topmenu)Application 0.127 seconds (+0.000); 8.05 MB (+0.016) - afterRenderModule mod_menu (topmenu)Application 0.127 seconds (+0.000); 8.04 MB (-0.006) - beforeRenderModule mod_custom (feedback)Application 0.127 seconds (+0.000); 8.05 MB (+0.004) - afterRenderModule mod_custom (feedback)Application 0.127 seconds (+0.000); 8.04 MB (-0.003) - beforeRenderModule mod_custom (SeacoastNH Feedback)Application 0.127 seconds (+0.000); 8.05 MB (+0.004) - afterRenderModule mod_custom (SeacoastNH Feedback)Application 0.127 seconds (+0.000); 8.04 MB (-0.003) - beforeRenderModule mod_custom (MainHeader)Application 0.127 seconds (+0.000); 8.05 MB (+0.004) - afterRenderModule mod_custom (MainHeader)Application 0.127 seconds (+0.000); 8.05 MB (-0.002) - beforeRenderModule mod_custom (Facebook)Application 0.127 seconds (+0.000); 8.05 MB (+0.004) - afterRenderModule mod_custom (Facebook)Application 0.127 seconds (+0.000); 8.05 MB (-0.002) - beforeRenderModule mod_menu (Main Menu)Application 0.131 seconds (+0.004); 8.12 MB (+0.070) - afterRenderModule mod_menu (Main Menu)Application 0.132 seconds (+0.000); 8.11 MB (-0.007) - beforeRenderModule mod_custom (Donate to Our Site)Application 0.132 seconds (+0.000); 8.12 MB (+0.004) - afterRenderModule mod_custom (Donate to Our Site)Application 0.132 seconds (+0.000); 8.11 MB (-0.003) - beforeRenderModule mod_custom (Feedjit)Application 0.132 seconds (+0.000); 8.12 MB (+0.004) - afterRenderModule mod_custom (Feedjit)Application 0.132 seconds (+0.000); 8.11 MB (-0.003) - beforeRenderModule mod_custom (facebook lower logo)Application 0.132 seconds (+0.000); 8.12 MB (+0.004) - afterRenderModule mod_custom (facebook lower logo)Application 0.132 seconds (+0.000); 8.26 MB (+0.147) - afterRender8.42 MB (8,830,744 Bytes)SELECT `data`
FROM `rabbul_session`
WHERE `session_id` = '51677edb009457bf72ea8844cc25a3a3'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 = 'Food/Penny-Gourmet/'
AND published='1'
LIMIT 1SELECT id
FROM rabbul_menu
WHERE alias='Food'
AND published=1SELECT id
FROM rabbul_categories
WHERE path='Food/Penny-Gourmet'
AND extension='com_content'SELECT id,link
FROM rabbul_menu
WHERE type='component'
AND published='1'
AND link LIKE 'index.php?option=com_content&view=categor%&id=184'
ORDER BY idSELECT parent.id AS id
FROM rabbul_categories AS node
JOIN rabbul_categories AS parent
ON node.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND node.id = 184SELECT id
FROM rabbul_menu
WHERE type='component'
AND published='1'
AND link LIKE 'index.php?option=com_content&view=categor%&id=184'
ORDER BY idSELECT `id`
FROM `rabbul_usergroups`SELECT parent.id, parent.lft, parent.rgt
FROM rabbul_usergroups AS parent
ORDER BY parent.lftSHOW FULL COLUMNS
FROM `rabbul_assets`SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT b.rules
FROM rabbul_assets AS a
LEFT JOIN rabbul_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = '')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT rules
FROM rabbul_assets
WHERE id = '1'SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT id
FROM rabbul_assets
WHERE parent_id = 0SELECT u.*
FROM rabbul_user_usergroup_map m
RIGHT JOIN rabbul_users u
ON (u.id=m.user_id)
WHERE m.group_id IN (6,7,8)
GROUP BY u.id
ORDER BY u.username ASCSHOW FULL COLUMNS
FROM `rabbul_rsfirewall_logs`SELECT *
FROM rabbul_rsfirewall_hashes
WHERE (`type`='2.5.28' OR `type`='protect')
AND `flag`!='C'SELECT *
FROM rabbul_rsfirewall_snapshots
WHERE `type`='protect'SELECT `ip`,`reason`
FROM rabbul_rsfirewall_lists
WHERE (`ip`='10.1.77.32' OR `ip` LIKE '%*%')
AND `type`='1'
AND `published`='1'SELECT `ip`,`reason`
FROM rabbul_rsfirewall_lists
WHERE (`ip`='10.1.77.32' 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 c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
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
LEFT JOIN `rabbul_content` AS i
ON i.`catid` = c.id
AND i.state = 1
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=184
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 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.category.184')
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_content_frontpage AS fp
ON fp.content_id = a.id
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
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.catid = 184 OR a.catid IN (
SELECT sub.id
FROM rabbul_categories as sub
INNER JOIN rabbul_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 184))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-16 11:19:44')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-16 11:19:44')
ORDER BY a.created DESC , a.created
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_content_frontpage AS fp
ON fp.content_id = a.id
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
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.catid = 184 OR a.catid IN (
SELECT sub.id
FROM rabbul_categories as sub
INNER JOIN rabbul_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 184))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-16 11:19:44')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-16 11:19:44')
ORDER BY a.created DESC , a.createdSELECT 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=304
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 path
FROM rabbul_categories
WHERE id = 184SELECT path
FROM rabbul_categories
WHERE id = 184SELECT 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 = 'edit')
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 a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 1074SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 1074SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 1074SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 847SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 847SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 847SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 804SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 804SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 804SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 797SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 797SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 797SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 755SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 755SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 755SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 662SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 662SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 662SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 549SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 549SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 549SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 542SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 542SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 542SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 517SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 517SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 517SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 394SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 394SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 394SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 197SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 197SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 197SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 183SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 183SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 183SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 170SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 170SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 170SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 110SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 110SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 110SELECT 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 11:19:44')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-16 11:19:44')
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 11:19:44' >= `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 11'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=100
AND track_date='2026-10-16 11'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=100
AND track_date='2026-10-16 11'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 11:19:44' >= `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 11:19:44' >= `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 11'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=87
AND track_date='2026-10-16 11'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=87
AND track_date='2026-10-16 11'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 87SELECT *
FROM rabbul_banners
WHERE '2026-10-16 11:19:44' >= `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 11'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=84
AND track_date='2026-10-16 11'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=84
AND track_date='2026-10-16 11'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 84SELECT *
FROM rabbul_banners
WHERE '2026-10-16 11:19:44' >= `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 11:19:44' >= `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 11:19:44' >= `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 11:19:44' >= `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 11:19:44' >= `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 11:19:44' >= `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 11:19:44' >= `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 11:19:44' >= `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 11'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=95
AND track_date='2026-10-16 11'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=95
AND track_date='2026-10-16 11'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 95SELECT *
FROM rabbul_banners
WHERE '2026-10-16 11:19:44' >= `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 11:19:44' >= `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 11'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=30
AND track_date='2026-10-16 11'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=30
AND track_date='2026-10-16 11'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 30SELECT *
FROM rabbul_banners
WHERE '2026-10-16 11:19:44' >= `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 11'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=31
AND track_date='2026-10-16 11'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=31
AND track_date='2026-10-16 11'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 31SELECT *
FROM rabbul_banners
WHERE '2026-10-16 11:19:44' >= `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 11:19:44' >= `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 11:19:44' >= `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 11:19:44' >= `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 11'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=23
AND track_date='2026-10-16 11'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=23
AND track_date='2026-10-16 11'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 23SELECT *
FROM rabbul_banners
WHERE '2026-10-16 11:19:44' >= `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 11:19:44' >= `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 path
FROM rabbul_categories
WHERE id = 304SELECT 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:6;s:19:\"session.timer.start\";i:1792149583;s:18:\"session.timer.last\";i:1792149584;s:17:\"session.timer.now\";i:1792149584;s:24:\"session.client.forwarded\";s:10:\"10.1.77.32\";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:44:{s:40:\"15775dbb0d61031a71e0c0fab09d44e7a88e574e\";O:8:\"stdClass\":2:{s:4:\"link\";s:54:\"http://www.seacoastnh.com/november-2007-seacoast-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"5e1fd7fa220ef1cf208631c54b4c89e7ae543e8a\";O:8:\"stdClass\":2:{s:4:\"link\";s:50:\"http://www.seacoastnh.com/read-our-mail-june-2004/\";s:6:\"expiry\";i:1792149584;}s:40:\"41cb6610ced0bcb9716331a538e78a40d54c5f31\";O:8:\"stdClass\":2:{s:4:\"link\";s:49:\"http://www.seacoastnh.com/read-our-mail-may-2004/\";s:6:\"expiry\";i:1792149584;}s:40:\"c22659230f260761adcef54e7c69cc780c95ad61\";O:8:\"stdClass\":2:{s:4:\"link\";s:51:\"http://www.seacoastnh.com/read-our-mail-april-2004/\";s:6:\"expiry\";i:1792149584;}s:40:\"d4e3cd683b7f91f906441cbb270a8318bf6d70b5\";O:8:\"stdClass\":2:{s:4:\"link\";s:51:\"http://www.seacoastnh.com/read-our-mail-march-2004/\";s:6:\"expiry\";i:1792149584;}s:40:\"69dbf21ceabe5142f4a26b1d937250992c13d3ed\";O:8:\"stdClass\":2:{s:4:\"link\";s:54:\"http://www.seacoastnh.com/read-our-mail-february-2004/\";s:6:\"expiry\";i:1792149584;}s:40:\"217e76c603ced8471747a2aa0e85f356dd962e98\";O:8:\"stdClass\":2:{s:4:\"link\";s:53:\"http://www.seacoastnh.com/read-our-mail-january-2004/\";s:6:\"expiry\";i:1792149584;}s:40:\"fc23a329bfa0789bee92bc10c3f0ea7e88ab8e8f\";O:8:\"stdClass\":2:{s:4:\"link\";s:50:\"http://www.seacoastnh.com/june-2008-seacoast-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"54f3d980a6595dd44259aff0c78bda4f8da72cad\";O:8:\"stdClass\":2:{s:4:\"link\";s:49:\"http://www.seacoastnh.com/may-2008-seacoast-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"a51933c46839e0a4deb956d1bc63d2ae0e4cdf49\";O:8:\"stdClass\":2:{s:4:\"link\";s:52:\"http://www.seacoastnh.com/april-2008-reader-letters/\";s:6:\"expiry\";i:1792149584;}s:40:\"5421e51ecc82937433a3dae1ca754e46bdecdf9e\";O:8:\"stdClass\":2:{s:4:\"link\";s:45:\"http://www.seacoastnh.com/letters-march-2008/\";s:6:\"expiry\";i:1792149584;}s:40:\"07aa9f1c39a7da72bad0d6ebd03984007e7e8184\";O:8:\"stdClass\":2:{s:4:\"link\";s:48:\"http://www.seacoastnh.com/letters-february-2008/\";s:6:\"expiry\";i:1792149584;}s:40:\"d9e3df84491c88c1ed49462d72f839f3e4f10057\";O:8:\"stdClass\":2:{s:4:\"link\";s:47:\"http://www.seacoastnh.com/letters-january-2008/\";s:6:\"expiry\";i:1792149584;}s:40:\"6acc9ef7887697a5f89a9c0f4368bfe4523981db\";O:8:\"stdClass\":2:{s:4:\"link\";s:48:\"http://www.seacoastnh.com/letters-december-2007/\";s:6:\"expiry\";i:1792149584;}s:40:\"cf416cc8dea4eb783f9bdc8ac89c9582ced6226a\";O:8:\"stdClass\":2:{s:4:\"link\";s:47:\"http://www.seacoastnh.com/letters-october-2007/\";s:6:\"expiry\";i:1792149584;}s:40:\"6c8e288bd77602be3ce1eba7bd5c18f47aad1bd8\";O:8:\"stdClass\":2:{s:4:\"link\";s:49:\"http://www.seacoastnh.com/letters-september-2007/\";s:6:\"expiry\";i:1792149584;}s:40:\"0550e60ac94332df6121815fd8f61207ee600e27\";O:8:\"stdClass\":2:{s:4:\"link\";s:46:\"http://www.seacoastnh.com/august-2007-letters/\";s:6:\"expiry\";i:1792149584;}s:40:\"1100a84d4a492726f16464cddf7082cefd436750\";O:8:\"stdClass\":2:{s:4:\"link\";s:44:\"http://www.seacoastnh.com/july-2007-letters/\";s:6:\"expiry\";i:1792149584;}s:40:\"72f9d23f3101242a1571c47626c79e0d35e7ccc5\";O:8:\"stdClass\":2:{s:4:\"link\";s:48:\"http://www.seacoastnh.com/july-2009-reader-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"c61cad2b7eab1ba2e7aa5870b7154074982651d0\";O:8:\"stdClass\":2:{s:4:\"link\";s:48:\"http://www.seacoastnh.com/june-2009-reader-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"d3b49ded93fbe25af04f4e8f8d64ee49b8fd766d\";O:8:\"stdClass\":2:{s:4:\"link\";s:51:\"http://www.seacoastnh.com/april-2009-seacoast-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"2b610ce225ec0fdce909a2f4bdd958fbc456abb0\";O:8:\"stdClass\":2:{s:4:\"link\";s:54:\"http://www.seacoastnh.com/march-2009-seacoast-letters/\";s:6:\"expiry\";i:1792149584;}s:40:\"a2c71a5f6b4ddf99f195b8f0288f2df6386ed6a4\";O:8:\"stdClass\":2:{s:4:\"link\";s:55:\"http://www.seacoastnh.com/february-2009-reader-letters/\";s:6:\"expiry\";i:1792149584;}s:40:\"fb2c0c1e96d2282b95e3cad64c518509873d367a\";O:8:\"stdClass\":2:{s:4:\"link\";s:51:\"http://www.seacoastnh.com/january-2009-reader-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"534a8afbcfb6c607775a90b517885826ca84b8cc\";O:8:\"stdClass\":2:{s:4:\"link\";s:48:\"http://www.seacoastnh.com/letters-december-2008/\";s:6:\"expiry\";i:1792149584;}s:40:\"cfa4b00579fd7af6b7459525ff0199f3e47f929d\";O:8:\"stdClass\":2:{s:4:\"link\";s:52:\"http://www.seacoastnh.com/november-2008-reader-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"ec79e7afa70e6520a1ddd27c1ac1edb9eed330b0\";O:8:\"stdClass\":2:{s:4:\"link\";s:51:\"http://www.seacoastnh.com/october-2008-reader-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"591945d15a2365408db6d28a785c5e2ad8fbe12f\";O:8:\"stdClass\":2:{s:4:\"link\";s:49:\"http://www.seacoastnh.com/september-2008-letters/\";s:6:\"expiry\";i:1792149584;}s:40:\"3a8fd56c1535a18eaa7a37f1d55c9bcda0e8f0ac\";O:8:\"stdClass\":2:{s:4:\"link\";s:52:\"http://www.seacoastnh.com/august-2008-seacoast-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"4ffd68c6e6e930b257f4eaa6f815cfd981ac077f\";O:8:\"stdClass\":2:{s:4:\"link\";s:50:\"http://www.seacoastnh.com/july-2008-seacoast-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"d78aacc05c57d9fba9fb0143db83c8b21fcb33eb\";O:8:\"stdClass\":2:{s:4:\"link\";s:39:\"http://www.seacoastnh.com/beckys-diner/\";s:6:\"expiry\";i:1792149584;}s:40:\"3573cdc83a49411f870ad7eb6771c6c8a3bc4473\";O:8:\"stdClass\":2:{s:4:\"link\";s:39:\"http://www.seacoastnh.com/moodys-diner/\";s:6:\"expiry\";i:1792149584;}s:40:\"b138129934b4ee07c308c0c07e29c3f060367c49\";O:8:\"stdClass\":2:{s:4:\"link\";s:35:\"http://www.seacoastnh.com/fogartys/\";s:6:\"expiry\";i:1792149584;}s:40:\"b8413cc131dddbc1853fca48e8fe87147f063b73\";O:8:\"stdClass\":2:{s:4:\"link\";s:34:\"http://www.seacoastnh.com/gilleys/\";s:6:\"expiry\";i:1792149584;}s:40:\"6aea3d775b1273ddf69cac680fc92ac72e96b5d8\";O:8:\"stdClass\":2:{s:4:\"link\";s:40:\"http://www.seacoastnh.com/carmens-diner/\";s:6:\"expiry\";i:1792149584;}s:40:\"57a48b37e78223e510e185c66d515f6c33053056\";O:8:\"stdClass\":2:{s:4:\"link\";s:40:\"http://www.seacoastnh.com/the-ice-house/\";s:6:\"expiry\";i:1792149584;}s:40:\"0e1197b301b7ebe95e386c10b6decd2e5b3a845c\";O:8:\"stdClass\":2:{s:4:\"link\";s:35:\"http://www.seacoastnh.com/wheelies/\";s:6:\"expiry\";i:1792149584;}s:40:\"db4b30006cc655d20cb6ffb43756ba5d0f5d9365\";O:8:\"stdClass\":2:{s:4:\"link\";s:43:\"http://www.seacoastnh.com/loco-cocos-tacos/\";s:6:\"expiry\";i:1792149584;}s:40:\"079b352adc9ef58e2d5b3ee55d1647531a36418b\";O:8:\"stdClass\":2:{s:4:\"link\";s:52:\"http://www.seacoastnh.com/tam-vietnamese-restaurant/\";s:6:\"expiry\";i:1792149584;}s:40:\"708cfedee2441a1f8db0adadc38b1b47bd6a0c1c\";O:8:\"stdClass\":2:{s:4:\"link\";s:35:\"http://www.seacoastnh.com/savarios/\";s:6:\"expiry\";i:1792149584;}s:40:\"1fb60f2cbd998627401554c1ab90268cce06444f\";O:8:\"stdClass\":2:{s:4:\"link\";s:34:\"http://www.seacoastnh.com/emilios/\";s:6:\"expiry\";i:1792149584;}s:40:\"721357e67e1e40feb55973fe541977d648aa61c5\";O:8:\"stdClass\":2:{s:4:\"link\";s:41:\"http://www.seacoastnh.com/rye-harborside/\";s:6:\"expiry\";i:1792149584;}s:40:\"1c0ba188abd4aeaa44a5a9045fb1fbf668251799\";O:8:\"stdClass\":2:{s:4:\"link\";s:40:\"http://www.seacoastnh.com/bobs-clam-hut/\";s:6:\"expiry\";i:1792149584;}s:40:\"732c6359cc641f4db613ccf70cb4a214417e25d2\";O:8:\"stdClass\":2:{s:4:\"link\";s:40:\"http://www.seacoastnh.com/penny-gourmet/\";s:6:\"expiry\";i:1792149584;}}}'
, `time` = '1792149584'
WHERE `session_id` = '51677edb009457bf72ea8844cc25a3a3'44 × 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 b16 × SELECT id
FROM rabbul_assets14 × SELECT `count`
FROM rabbul_banner_tracks10 × SELECT link
FROM rabbul_menu9 × SELECT path
FROM rabbul_categories4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM rabbul_extensions4 × SELECT b.rules
FROM rabbul_assets AS a
LEFT JOIN rabbul_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt3 × SELECT *
FROM rabbul_banners2 × 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 contact2 × SELECT rules
FROM rabbul_assets2 × SELECT id
FROM rabbul_menu2 × 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.cid1 × 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 `title`
FROM `rabbul_finder_taxonomy`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 name
FROM `rabbul_extensions`1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
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 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 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 *
FROM rabbul_rsfirewall_exceptions1 × SELECT u.*
FROM rabbul_user_usergroup_map m RIGHT JOIN rabbul_users u
ON (u.id=m.user_id)1 × SELECT *
FROM rabbul_rsfirewall_configuratio1 × SELECT *
FROM rabbul_sef_config1 × SELECT non_sef_url,alias
FROM rabbul_sef_alias1 × SELECT `file`
FROM rabbul_rsfirewall_hashes1 × SELECT `path`
FROM rabbul_rsfirewall_ignored1 × SELECT folder AS type, element AS name, params
FROM rabbul_extensions1 × SELECT `query`
FROM `rabbul_admintools_wafexceptions`1 × SELECT `value`
FROM `rabbul_admintools_storage`1 × 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_sef_redirect1 × SELECT parent.id, parent.lft, parent.rgt
FROM rabbul_usergroups AS parent1 × SELECT `data`
FROM `rabbul_session`1 × SELECT *
FROM rabbul_rsfirewall_hashes1 × SELECT `id`
FROM `rabbul_usergroups1 × SELECT parent.id AS id
FROM rabbul_categories AS node JOIN rabbul_categories AS parent
ON node.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT id
FROM rabbul_categories1 × SELECT id,link
FROM rabbul_menu1 × 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:6;s:19:\"session.timer.start\";i:1792149583;s:18:\"session.timer.last\";i:1792149584;s:17:\"session.timer.now\";i:1792149584;s:24:\"session.client.forwarded\";s:10:\"10.1.77.32\";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:44:{s:40:\"15775dbb0d61031a71e0c0fab09d44e7a88e574e\";O:8:\"stdClass\":2:{s:4:\"link\";s:54:\"http://www.seacoastnh.com/november-2007-seacoast-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"5e1fd7fa220ef1cf208631c54b4c89e7ae543e8a\";O:8:\"stdClass\":2:{s:4:\"link\";s:50:\"http://www.seacoastnh.com/read-our-mail-june-2004/\";s:6:\"expiry\";i:1792149584;}s:40:\"41cb6610ced0bcb9716331a538e78a40d54c5f31\";O:8:\"stdClass\":2:{s:4:\"link\";s:49:\"http://www.seacoastnh.com/read-our-mail-may-2004/\";s:6:\"expiry\";i:1792149584;}s:40:\"c22659230f260761adcef54e7c69cc780c95ad61\";O:8:\"stdClass\":2:{s:4:\"link\";s:51:\"http://www.seacoastnh.com/read-our-mail-april-2004/\";s:6:\"expiry\";i:1792149584;}s:40:\"d4e3cd683b7f91f906441cbb270a8318bf6d70b5\";O:8:\"stdClass\":2:{s:4:\"link\";s:51:\"http://www.seacoastnh.com/read-our-mail-march-2004/\";s:6:\"expiry\";i:1792149584;}s:40:\"69dbf21ceabe5142f4a26b1d937250992c13d3ed\";O:8:\"stdClass\":2:{s:4:\"link\";s:54:\"http://www.seacoastnh.com/read-our-mail-february-2004/\";s:6:\"expiry\";i:1792149584;}s:40:\"217e76c603ced8471747a2aa0e85f356dd962e98\";O:8:\"stdClass\":2:{s:4:\"link\";s:53:\"http://www.seacoastnh.com/read-our-mail-january-2004/\";s:6:\"expiry\";i:1792149584;}s:40:\"fc23a329bfa0789bee92bc10c3f0ea7e88ab8e8f\";O:8:\"stdClass\":2:{s:4:\"link\";s:50:\"http://www.seacoastnh.com/june-2008-seacoast-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"54f3d980a6595dd44259aff0c78bda4f8da72cad\";O:8:\"stdClass\":2:{s:4:\"link\";s:49:\"http://www.seacoastnh.com/may-2008-seacoast-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"a51933c46839e0a4deb956d1bc63d2ae0e4cdf49\";O:8:\"stdClass\":2:{s:4:\"link\";s:52:\"http://www.seacoastnh.com/april-2008-reader-letters/\";s:6:\"expiry\";i:1792149584;}s:40:\"5421e51ecc82937433a3dae1ca754e46bdecdf9e\";O:8:\"stdClass\":2:{s:4:\"link\";s:45:\"http://www.seacoastnh.com/letters-march-2008/\";s:6:\"expiry\";i:1792149584;}s:40:\"07aa9f1c39a7da72bad0d6ebd03984007e7e8184\";O:8:\"stdClass\":2:{s:4:\"link\";s:48:\"http://www.seacoastnh.com/letters-february-2008/\";s:6:\"expiry\";i:1792149584;}s:40:\"d9e3df84491c88c1ed49462d72f839f3e4f10057\";O:8:\"stdClass\":2:{s:4:\"link\";s:47:\"http://www.seacoastnh.com/letters-january-2008/\";s:6:\"expiry\";i:1792149584;}s:40:\"6acc9ef7887697a5f89a9c0f4368bfe4523981db\";O:8:\"stdClass\":2:{s:4:\"link\";s:48:\"http://www.seacoastnh.com/letters-december-2007/\";s:6:\"expiry\";i:1792149584;}s:40:\"cf416cc8dea4eb783f9bdc8ac89c9582ced6226a\";O:8:\"stdClass\":2:{s:4:\"link\";s:47:\"http://www.seacoastnh.com/letters-october-2007/\";s:6:\"expiry\";i:1792149584;}s:40:\"6c8e288bd77602be3ce1eba7bd5c18f47aad1bd8\";O:8:\"stdClass\":2:{s:4:\"link\";s:49:\"http://www.seacoastnh.com/letters-september-2007/\";s:6:\"expiry\";i:1792149584;}s:40:\"0550e60ac94332df6121815fd8f61207ee600e27\";O:8:\"stdClass\":2:{s:4:\"link\";s:46:\"http://www.seacoastnh.com/august-2007-letters/\";s:6:\"expiry\";i:1792149584;}s:40:\"1100a84d4a492726f16464cddf7082cefd436750\";O:8:\"stdClass\":2:{s:4:\"link\";s:44:\"http://www.seacoastnh.com/july-2007-letters/\";s:6:\"expiry\";i:1792149584;}s:40:\"72f9d23f3101242a1571c47626c79e0d35e7ccc5\";O:8:\"stdClass\":2:{s:4:\"link\";s:48:\"http://www.seacoastnh.com/july-2009-reader-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"c61cad2b7eab1ba2e7aa5870b7154074982651d0\";O:8:\"stdClass\":2:{s:4:\"link\";s:48:\"http://www.seacoastnh.com/june-2009-reader-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"d3b49ded93fbe25af04f4e8f8d64ee49b8fd766d\";O:8:\"stdClass\":2:{s:4:\"link\";s:51:\"http://www.seacoastnh.com/april-2009-seacoast-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"2b610ce225ec0fdce909a2f4bdd958fbc456abb0\";O:8:\"stdClass\":2:{s:4:\"link\";s:54:\"http://www.seacoastnh.com/march-2009-seacoast-letters/\";s:6:\"expiry\";i:1792149584;}s:40:\"a2c71a5f6b4ddf99f195b8f0288f2df6386ed6a4\";O:8:\"stdClass\":2:{s:4:\"link\";s:55:\"http://www.seacoastnh.com/february-2009-reader-letters/\";s:6:\"expiry\";i:1792149584;}s:40:\"fb2c0c1e96d2282b95e3cad64c518509873d367a\";O:8:\"stdClass\":2:{s:4:\"link\";s:51:\"http://www.seacoastnh.com/january-2009-reader-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"534a8afbcfb6c607775a90b517885826ca84b8cc\";O:8:\"stdClass\":2:{s:4:\"link\";s:48:\"http://www.seacoastnh.com/letters-december-2008/\";s:6:\"expiry\";i:1792149584;}s:40:\"cfa4b00579fd7af6b7459525ff0199f3e47f929d\";O:8:\"stdClass\":2:{s:4:\"link\";s:52:\"http://www.seacoastnh.com/november-2008-reader-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"ec79e7afa70e6520a1ddd27c1ac1edb9eed330b0\";O:8:\"stdClass\":2:{s:4:\"link\";s:51:\"http://www.seacoastnh.com/october-2008-reader-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"591945d15a2365408db6d28a785c5e2ad8fbe12f\";O:8:\"stdClass\":2:{s:4:\"link\";s:49:\"http://www.seacoastnh.com/september-2008-letters/\";s:6:\"expiry\";i:1792149584;}s:40:\"3a8fd56c1535a18eaa7a37f1d55c9bcda0e8f0ac\";O:8:\"stdClass\":2:{s:4:\"link\";s:52:\"http://www.seacoastnh.com/august-2008-seacoast-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"4ffd68c6e6e930b257f4eaa6f815cfd981ac077f\";O:8:\"stdClass\":2:{s:4:\"link\";s:50:\"http://www.seacoastnh.com/july-2008-seacoast-mail/\";s:6:\"expiry\";i:1792149584;}s:40:\"d78aacc05c57d9fba9fb0143db83c8b21fcb33eb\";O:8:\"stdClass\":2:{s:4:\"link\";s:39:\"http://www.seacoastnh.com/beckys-diner/\";s:6:\"expiry\";i:1792149584;}s:40:\"3573cdc83a49411f870ad7eb6771c6c8a3bc4473\";O:8:\"stdClass\":2:{s:4:\"link\";s:39:\"http://www.seacoastnh.com/moodys-diner/\";s:6:\"expiry\";i:1792149584;}s:40:\"b138129934b4ee07c308c0c07e29c3f060367c49\";O:8:\"stdClass\":2:{s:4:\"link\";s:35:\"http://www.seacoastnh.com/fogartys/\";s:6:\"expiry\";i:1792149584;}s:40:\"b8413cc131dddbc1853fca48e8fe87147f063b73\";O:8:\"stdClass\":2:{s:4:\"link\";s:34:\"http://www.seacoastnh.com/gilleys/\";s:6:\"expiry\";i:1792149584;}s:40:\"6aea3d775b1273ddf69cac680fc92ac72e96b5d8\";O:8:\"stdClass\":2:{s:4:\"link\";s:40:\"http://www.seacoastnh.com/carmens-diner/\";s:6:\"expiry\";i:1792149584;}s:40:\"57a48b37e78223e510e185c66d515f6c33053056\";O:8:\"stdClass\":2:{s:4:\"link\";s:40:\"http://www.seacoastnh.com/the-ice-house/\";s:6:\"expiry\";i:1792149584;}s:40:\"0e1197b301b7ebe95e386c10b6decd2e5b3a845c\";O:8:\"stdClass\":2:{s:4:\"link\";s:35:\"http://www.seacoastnh.com/wheelies/\";s:6:\"expiry\";i:1792149584;}s:40:\"db4b30006cc655d20cb6ffb43756ba5d0f5d9365\";O:8:\"stdClass\":2:{s:4:\"link\";s:43:\"http://www.seacoastnh.com/loco-cocos-tacos/\";s:6:\"expiry\";i:1792149584;}s:40:\"079b352adc9ef58e2d5b3ee55d1647531a36418b\";O:8:\"stdClass\":2:{s:4:\"link\";s:52:\"http://www.seacoastnh.com/tam-vietnamese-restaurant/\";s:6:\"expiry\";i:1792149584;}s:40:\"708cfedee2441a1f8db0adadc38b1b47bd6a0c1c\";O:8:\"stdClass\":2:{s:4:\"link\";s:35:\"http://www.seacoastnh.com/savarios/\";s:6:\"expiry\";i:1792149584;}s:40:\"1fb60f2cbd998627401554c1ab90268cce06444f\";O:8:\"stdClass\":2:{s:4:\"link\";s:34:\"http://www.seacoastnh.com/emilios/\";s:6:\"expiry\";i:1792149584;}s:40:\"721357e67e1e40feb55973fe541977d648aa61c5\";O:8:\"stdClass\":2:{s:4:\"link\";s:41:\"http://www.seacoastnh.com/rye-harborside/\";s:6:\"expiry\";i:1792149584;}s:40:\"1c0ba188abd4aeaa44a5a9045fb1fbf668251799\";O:8:\"stdClass\":2:{s:4:\"link\";s:40:\"http://www.seacoastnh.com/bobs-clam-hut/\";s:6:\"expiry\";i:1792149584;}s:40:\"732c6359cc641f4db613ccf70cb4a214417e25d2\";O:8:\"stdClass\":2:{s:4:\"link\";s:40:\"http://www.seacoastnh.com/penny-gourmet/\";s:6:\"expiry\";i:1792149584;}}}' , `time` = '1792149584'1 × SHOW FULL COLUMNS
FROM `rabbul_sef_config1 × SHOW FULL COLUMNS
FROM `rabbul_rsfirewall_logs1 × SHOW FULL COLUMNS
FROM `rabbul_assets





PENNY GOURMET
Frank Savario Catalino introduced his pizza shop
in one of Portsmouth's tiniest buildings in 1990.
Open just three hours a day, the shop is a family affair.
Frank's real Italian pizza is one of city's trade secrets.
His calzones are gigantic, stuffed full.
Size isn’t everything. In a world of corporate-designed fast food mega-chains,
it’s nice to find a one-shot spot you can almost get your arms around. This one
is a true hide-away and, if it’s open when you arrive, you can afford lunch for
the whole family.
WHERE THE LOCALS CLAM UP
