| 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/portsmouth-seal-shows-changed-city/
link ⇒ http://www.seacoastnh.com/a-simpler-north-end-halloween-1932/
link ⇒ http://www.seacoastnh.com/gilleys-still-my-favorite-portsmouth-eatery/
link ⇒ http://www.seacoastnh.com/l-8-was-first-portsmouth-submarine/
link ⇒ http://www.seacoastnh.com/before-the-gardens-grew-at-atlantic-heights/
link ⇒ http://www.seacoastnh.com/view-from-the-ceres-street-ferry/
link ⇒ http://www.seacoastnh.com/what-the-uss-ranger-looked-like/
link ⇒ http://www.seacoastnh.com/spanning-the-centuries/
link ⇒ http://www.seacoastnh.com/a-modest-proposal-for-parking-in-portsmouth/
link ⇒ http://www.seacoastnh.com/boats-crash-into-portsmouth-ferry-landing/
Application 0.000 seconds (+0.000); 0.33 MB (+0.330) - afterLoadApplication 0.016 seconds (+0.015); 3.22 MB (+2.894) - afterInitialiseApplication 0.023 seconds (+0.007); 5.03 MB (+1.803) - afterRouteApplication 0.152 seconds (+0.129); 11.23 MB (+6.206) - afterDispatchApplication 0.153 seconds (+0.001); 11.42 MB (+0.186) - beforeRenderModule mod_custom (Footer)Application 0.154 seconds (+0.001); 11.43 MB (+0.008) - afterRenderModule mod_custom (Footer)Application 0.154 seconds (+0.000); 11.43 MB (-0.000) - beforeRenderModule mod_banners (Uncle Oscar)Application 0.156 seconds (+0.002); 11.52 MB (+0.096) - afterRenderModule mod_banners (Uncle Oscar)Application 0.156 seconds (+0.000); 11.54 MB (+0.016) - beforeRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)Application 0.157 seconds (+0.001); 11.66 MB (+0.123) - afterRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)Application 0.157 seconds (+0.000); 11.56 MB (-0.098) - beforeRenderModule mod_novarp (ISC/Star)Application 0.159 seconds (+0.001); 11.66 MB (+0.101) - afterRenderModule mod_novarp (ISC/Star)Application 0.159 seconds (+0.000); 11.54 MB (-0.121) - beforeRenderModule mod_banners (Music Hall)Application 0.160 seconds (+0.001); 11.56 MB (+0.013) - afterRenderModule mod_banners (Music Hall)Application 0.160 seconds (+0.000); 11.55 MB (-0.009) - beforeRenderModule mod_banners (Maren)Application 0.160 seconds (+0.001); 11.56 MB (+0.014) - afterRenderModule mod_banners (Maren)Application 0.161 seconds (+0.000); 11.55 MB (-0.009) - beforeRenderModule mod_banners (Smuttynose Murders)Application 0.161 seconds (+0.001); 11.57 MB (+0.014) - afterRenderModule mod_banners (Smuttynose Murders)Application 0.161 seconds (+0.000); 11.56 MB (-0.009) - beforeRenderModule mod_banners (Banner Maine Harbors)Application 0.162 seconds (+0.001); 11.57 MB (+0.013) - afterRenderModule mod_banners (Banner Maine Harbors)Application 0.162 seconds (+0.000); 11.56 MB (-0.009) - beforeRenderModule mod_banners (Banner Sanctuary Hair)Application 0.163 seconds (+0.001); 11.58 MB (+0.015) - afterRenderModule mod_banners (Banner Sanctuary Hair)Application 0.163 seconds (+0.000); 11.57 MB (-0.009) - beforeRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)Application 0.164 seconds (+0.001); 11.58 MB (+0.011) - afterRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)Application 0.164 seconds (+0.000); 11.60 MB (+0.020) - beforeRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)Application 0.165 seconds (+0.001); 11.67 MB (+0.069) - afterRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)Application 0.165 seconds (+0.000); 11.57 MB (-0.097) - beforeRenderModule mod_banners (Banner sheraton wedding)Application 0.165 seconds (+0.001); 11.58 MB (+0.013) - afterRenderModule mod_banners (Banner sheraton wedding)Application 0.165 seconds (+0.000); 11.58 MB (-0.004) - beforeRenderModule mod_banners (Banner Boating)Application 0.166 seconds (+0.001); 11.59 MB (+0.008) - afterRenderModule mod_banners (Banner Boating)Application 0.166 seconds (+0.000); 11.58 MB (-0.005) - beforeRenderModule mod_banners (Banner Harbour arts)Application 0.166 seconds (+0.000); 11.59 MB (+0.008) - afterRenderModule mod_banners (Banner Harbour arts)Application 0.166 seconds (+0.000); 11.58 MB (-0.007) - beforeRenderModule mod_custom (Google Ads)Application 0.167 seconds (+0.000); 11.59 MB (+0.004) - afterRenderModule mod_custom (Google Ads)Application 0.167 seconds (+0.000); 11.59 MB (-0.002) - beforeRenderModule mod_banners (Banner Newmarket heritage)Application 0.167 seconds (+0.001); 11.59 MB (+0.008) - afterRenderModule mod_banners (Banner Newmarket heritage)Application 0.167 seconds (+0.000); 11.59 MB (-0.004) - beforeRenderModule mod_banners (Shoals Marine Ad)Application 0.168 seconds (+0.001); 11.60 MB (+0.010) - afterRenderModule mod_banners (Shoals Marine Ad)Application 0.168 seconds (+0.000); 11.59 MB (-0.008) - beforeRenderModule mod_feed (News about Portsmouth from Fosters.com)Application 0.234 seconds (+0.066); 12.02 MB (+0.427) - afterRenderModule mod_feed (News about Portsmouth from Fosters.com)Application 0.234 seconds (+0.000); 12.02 MB (-0.001) - beforeRenderModule mod_banners (ad bottom right top)Application 0.236 seconds (+0.002); 12.03 MB (+0.013) - afterRenderModule mod_banners (ad bottom right top)Application 0.236 seconds (+0.000); 12.02 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right mid)Application 0.237 seconds (+0.001); 12.04 MB (+0.014) - afterRenderModule mod_banners (ad bottom right mid)Application 0.237 seconds (+0.000); 12.03 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right bottom)Application 0.238 seconds (+0.001); 12.04 MB (+0.014) - afterRenderModule mod_banners (ad bottom right bottom)Application 0.238 seconds (+0.000); 12.03 MB (-0.008) - beforeRenderModule mod_banners (ad bottom mid top)Application 0.239 seconds (+0.001); 12.05 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid top)Application 0.239 seconds (+0.000); 12.04 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid mid)Application 0.240 seconds (+0.001); 12.05 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid mid)Application 0.240 seconds (+0.000); 12.04 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid bottom)Application 0.241 seconds (+0.001); 12.06 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid bottom)Application 0.241 seconds (+0.000); 12.05 MB (-0.008) - beforeRenderModule mod_banners (ad bottom left top)Application 0.242 seconds (+0.001); 12.06 MB (+0.014) - afterRenderModule mod_banners (ad bottom left top)Application 0.242 seconds (+0.000); 12.05 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left mid)Application 0.243 seconds (+0.001); 12.07 MB (+0.013) - afterRenderModule mod_banners (ad bottom left mid)Application 0.243 seconds (+0.000); 12.06 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left bottom)Application 0.243 seconds (+0.001); 12.07 MB (+0.011) - afterRenderModule mod_banners (ad bottom left bottom)Application 0.243 seconds (+0.000); 12.06 MB (-0.006) - beforeRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)Application 0.243 seconds (+0.000); 12.07 MB (+0.004) - afterRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)Application 0.244 seconds (+0.000); 12.07 MB (-0.001) - beforeRenderModule mod_finder (smart_search)Application 0.247 seconds (+0.004); 12.15 MB (+0.080) - afterRenderModule mod_finder (smart_search)Application 0.247 seconds (+0.000); 12.14 MB (-0.006) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)Application 0.248 seconds (+0.001); 12.15 MB (+0.013) - afterRenderModule mod_breadcrumbs (Breadcrumbs)Application 0.248 seconds (+0.000); 12.15 MB (-0.004) - beforeRenderModule mod_menu (topmenu)Application 0.249 seconds (+0.000); 12.17 MB (+0.016) - afterRenderModule mod_menu (topmenu)Application 0.249 seconds (+0.000); 12.16 MB (-0.006) - beforeRenderModule mod_custom (feedback)Application 0.249 seconds (+0.000); 12.16 MB (+0.004) - afterRenderModule mod_custom (feedback)Application 0.249 seconds (+0.000); 12.16 MB (-0.003) - beforeRenderModule mod_custom (SeacoastNH Feedback)Application 0.249 seconds (+0.000); 12.17 MB (+0.004) - afterRenderModule mod_custom (SeacoastNH Feedback)Application 0.249 seconds (+0.000); 12.16 MB (-0.003) - beforeRenderModule mod_custom (MainHeader)Application 0.249 seconds (+0.000); 12.17 MB (+0.004) - afterRenderModule mod_custom (MainHeader)Application 0.249 seconds (+0.000); 12.16 MB (-0.002) - beforeRenderModule mod_custom (Facebook)Application 0.249 seconds (+0.000); 12.17 MB (+0.004) - afterRenderModule mod_custom (Facebook)Application 0.249 seconds (+0.000); 12.17 MB (-0.002) - beforeRenderModule mod_menu (Main Menu)Application 0.255 seconds (+0.006); 12.26 MB (+0.093) - afterRenderModule mod_menu (Main Menu)Application 0.255 seconds (+0.000); 12.25 MB (-0.007) - beforeRenderModule mod_custom (Donate to Our Site)Application 0.255 seconds (+0.000); 12.26 MB (+0.004) - afterRenderModule mod_custom (Donate to Our Site)Application 0.255 seconds (+0.000); 12.25 MB (-0.003) - beforeRenderModule mod_custom (Feedjit)Application 0.256 seconds (+0.000); 12.26 MB (+0.004) - afterRenderModule mod_custom (Feedjit)Application 0.256 seconds (+0.000); 12.26 MB (-0.003) - beforeRenderModule mod_custom (facebook lower logo)Application 0.256 seconds (+0.000); 12.26 MB (+0.004) - afterRenderModule mod_custom (facebook lower logo)Application 0.256 seconds (+0.000); 12.39 MB (+0.134) - afterRender12.49 MB (13,094,944 Bytes)SELECT `data`
FROM `rabbul_session`
WHERE `session_id` = 'd5aa773ac59db65a9855aaa45b20ffc6'DELETE
FROM `rabbul_session`
WHERE `time` < '1792132847'SELECT `session_id`
FROM `rabbul_session`
WHERE `session_id` = 'd5aa773ac59db65a9855aaa45b20ffc6'
LIMIT 0, 1INSERT INTO `rabbul_session`
(`session_id`, `client_id`, `time`)
VALUES
('d5aa773ac59db65a9855aaa45b20ffc6', 0, '1792133747')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 *
FROM rabbul_sef_redirect
WHERE CONVERT(source USING latin1) COLLATE latin1_general_cs = 'Places-
and-Events/'
AND published='1'
LIMIT 1SELECT id
FROM rabbul_menu
WHERE alias='Places-
and-Events'
AND published=1SELECT id
FROM rabbul_categories
WHERE path='Places-
and-Events'
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=314'
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 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 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=314
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.314')
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 = 314 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 = 314))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-16 06:55:47')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-16 06:55:47')
ORDER BY a.created DESC , a.created
LIMIT 0, 110SELECT 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 = 314 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 = 314))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-16 06:55:47')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-16 06:55:47')
ORDER BY a.created DESC , a.createdSELECT path
FROM rabbul_categories
WHERE id = 314SELECT path
FROM rabbul_categories
WHERE id = 314SELECT 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 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=218
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 = 3771SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3771SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3771SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3736SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3736SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3736SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3704SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3704SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3704SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3698SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3698SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3698SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3664SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3664SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3664SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3657SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3657SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3657SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3656SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3656SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3656SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3652SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3652SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3652SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3645SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3645SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3645SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3639SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3639SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3639SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3635SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3632SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3624SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3619SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3615SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3608SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3604SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3598SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3592SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3587SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3584SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3578SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3570SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3568SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3564SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3560SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3537SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3532SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3530SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3525SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3522SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3518SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3509SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3505SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3503SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3496SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3492SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3485SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3475SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3462SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3454SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3438SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3427SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3420SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3416SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3410SELECT 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=167
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 = 3405SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3404SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3399SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3396SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3386SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3382SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3376SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3363SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3358SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3343SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3335SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3330SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3322SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3312SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3304SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3298SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3291SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3289SELECT 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=246
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 = 3281SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3278SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3272SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3266SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3260SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3251SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3248SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3242SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3238SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3233SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3222SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3215SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3211SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3205SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3197SELECT 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=164
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 = 3194SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3190SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3183SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3176SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3167SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3159SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3151SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3146SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3140SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3134SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3123SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3113SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3108SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3102SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3097SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3089SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3085SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3073SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3064SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3059SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3052SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3046SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3040SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3029SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3022SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3018SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3010SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3003SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 2996SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 2991SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 2985SELECT path
FROM rabbul_categories
WHERE id = 164SELECT 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=166
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 = 166SELECT path
FROM rabbul_categories
WHERE id = 167SELECT 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=168
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 = 168SELECT 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=169
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 = 169SELECT 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=170
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 = 170SELECT 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=171
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 = 171SELECT path
FROM rabbul_categories
WHERE id = 218SELECT path
FROM rabbul_categories
WHERE id = 246SELECT 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 06:55:47')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-16 06:55:47')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 160 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingSELECT *
FROM rabbul_banners
WHERE '2026-10-16 06:55:47' >= `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 06'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=100
AND track_date='2026-10-16 06'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=100
AND track_date='2026-10-16 06'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 06:55:47' >= `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 06:55:47' >= `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 06'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=87
AND track_date='2026-10-16 06'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=87
AND track_date='2026-10-16 06'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 87SELECT *
FROM rabbul_banners
WHERE '2026-10-16 06:55:47' >= `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 06'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=84
AND track_date='2026-10-16 06'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=84
AND track_date='2026-10-16 06'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 84SELECT *
FROM rabbul_banners
WHERE '2026-10-16 06:55:47' >= `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 06:55:47' >= `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 06:55:47' >= `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 06:55:47' >= `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 06:55:47' >= `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 06:55:47' >= `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 06:55:47' >= `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 06:55:47' >= `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 06'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=95
AND track_date='2026-10-16 06'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=95
AND track_date='2026-10-16 06'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 95SELECT *
FROM rabbul_banners
WHERE '2026-10-16 06:55:47' >= `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 06:55:47' >= `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 06'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=30
AND track_date='2026-10-16 06'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=30
AND track_date='2026-10-16 06'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 30SELECT *
FROM rabbul_banners
WHERE '2026-10-16 06:55:47' >= `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 06'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=31
AND track_date='2026-10-16 06'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=31
AND track_date='2026-10-16 06'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 31SELECT *
FROM rabbul_banners
WHERE '2026-10-16 06:55:47' >= `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 06:55:47' >= `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 06:55:47' >= `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 06:55:47' >= `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 06'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=23
AND track_date='2026-10-16 06'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=23
AND track_date='2026-10-16 06'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 23SELECT *
FROM rabbul_banners
WHERE '2026-10-16 06:55:47' >= `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 06:55:47' >= `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=160SELECT path
FROM rabbul_categories
WHERE id = 314SELECT 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=431SELECT path
FROM rabbul_categories
WHERE id = 164SELECT link
FROM rabbul_menu
WHERE id=432SELECT path
FROM rabbul_categories
WHERE id = 166SELECT link
FROM rabbul_menu
WHERE id=433SELECT path
FROM rabbul_categories
WHERE id = 167SELECT link
FROM rabbul_menu
WHERE id=434SELECT path
FROM rabbul_categories
WHERE id = 168SELECT link
FROM rabbul_menu
WHERE id=435SELECT path
FROM rabbul_categories
WHERE id = 169SELECT link
FROM rabbul_menu
WHERE id=436SELECT path
FROM rabbul_categories
WHERE id = 170SELECT link
FROM rabbul_menu
WHERE id=437SELECT path
FROM rabbul_categories
WHERE id = 171SELECT link
FROM rabbul_menu
WHERE id=438SELECT path
FROM rabbul_categories
WHERE id = 218SELECT link
FROM rabbul_menu
WHERE id=439SELECT path
FROM rabbul_categories
WHERE id = 246SELECT 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:1792133747;s:18:\"session.timer.last\";i:1792133747;s:17:\"session.timer.now\";i:1792133747;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:10:{s:40:\"aa3e814e30a6cc869885bb55b798dfa74e67077b\";O:8:\"stdClass\":2:{s:4:\"link\";s:61:\"http://www.seacoastnh.com/portsmouth-seal-shows-changed-city/\";s:6:\"expiry\";i:1792133747;}s:40:\"2e87259196c1a9e242cfe0d8d3ebe85353142d6a\";O:8:\"stdClass\":2:{s:4:\"link\";s:61:\"http://www.seacoastnh.com/a-simpler-north-end-halloween-1932/\";s:6:\"expiry\";i:1792133747;}s:40:\"398f2452ddc0d8cbc01dd9c0b5ea48bae147a3ae\";O:8:\"stdClass\":2:{s:4:\"link\";s:70:\"http://www.seacoastnh.com/gilleys-still-my-favorite-portsmouth-eatery/\";s:6:\"expiry\";i:1792133747;}s:40:\"4fc0b05570f31830f1a6510865cb03f9e60699ab\";O:8:\"stdClass\":2:{s:4:\"link\";s:61:\"http://www.seacoastnh.com/l-8-was-first-portsmouth-submarine/\";s:6:\"expiry\";i:1792133747;}s:40:\"e98f7ca6c97da8c418c5957de5cc5c3b8ecdce22\";O:8:\"stdClass\":2:{s:4:\"link\";s:70:\"http://www.seacoastnh.com/before-the-gardens-grew-at-atlantic-heights/\";s:6:\"expiry\";i:1792133747;}s:40:\"a70f779b3b0ad90268fda7e75710d6fd8425b2cc\";O:8:\"stdClass\":2:{s:4:\"link\";s:59:\"http://www.seacoastnh.com/view-
from-the-ceres-street-ferry/\";s:6:\"expiry\";i:1792133747;}s:40:\"f14017149ff00adb3c627429358750176cd35492\";O:8:\"stdClass\":2:{s:4:\"link\";s:58:\"http://www.seacoastnh.com/what-the-uss-ranger-looked-like/\";s:6:\"expiry\";i:1792133747;}s:40:\"63ec3013b6b9dddc375d31c4c61460e174de0ddc\";O:8:\"stdClass\":2:{s:4:\"link\";s:49:\"http://www.seacoastnh.com/spanning-the-centuries/\";s:6:\"expiry\";i:1792133747;}s:40:\"3963da1363c747040c28fa9799823859ff89a1f9\";O:8:\"stdClass\":2:{s:4:\"link\";s:70:\"http://www.seacoastnh.com/a-modest-proposal-for-parking-in-portsmouth/\";s:6:\"expiry\";i:1792133747;}s:40:\"e5e59e73144e88b33ec635e0aaf4d39c0c2f69d6\";O:8:\"stdClass\":2:{s:4:\"link\";s:68:\"http://www.seacoastnh.com/boats-crash-into-portsmouth-ferry-landing/\";s:6:\"expiry\";i:1792133747;}}}'
, `time` = '1792133747'
WHERE `session_id` = 'd5aa773ac59db65a9855aaa45b20ffc6'132 × 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.id27 × SELECT path
FROM rabbul_categories21 × SELECT *
FROM rabbul_banners20 × SELECT link
FROM rabbul_menu18 × SELECT b.alias AS banner
FROM rabbul_banners AS b16 × SELECT id
FROM rabbul_assets14 × SELECT `count`
FROM rabbul_banner_tracks9 × 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_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 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 contact2 × SELECT rules
FROM rabbul_assets1 × 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 `path`
FROM rabbul_rsfirewall_ignored1 × SELECT `file`
FROM rabbul_rsfirewall_hashes1 × SELECT *
FROM rabbul_rsfirewall_configuratio1 × SELECT non_sef_url,alias
FROM rabbul_sef_alias1 × SELECT *
FROM rabbul_sef_config1 × SELECT `value`
FROM `rabbul_admintools_storage`1 × SELECT `query`
FROM `rabbul_admintools_wafexceptions`1 × SELECT `title`
FROM `rabbul_finder_taxonomy`1 × SELECT `session_id`
FROM `rabbul_session`1 × SELECT name
FROM `rabbul_extensions`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 folder AS type, element AS name, params
FROM rabbul_extensions1 × SELECT id, rules
FROM `rabbul_viewlevels1 × 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 a.rules
FROM rabbul_assets AS a1 × SELECT *
FROM rabbul_sef_redirect1 × SELECT `data`
FROM `rabbul_session`1 × SELECT id
FROM rabbul_menu1 × SELECT parent.id, parent.lft, parent.rgt
FROM rabbul_usergroups AS parent1 × SELECT id,link
FROM rabbul_menu1 × SELECT `id`
FROM `rabbul_usergroups1 × SELECT u.*
FROM rabbul_user_usergroup_map m RIGHT JOIN rabbul_users u
ON (u.id=m.user_id)1 × SELECT *
FROM rabbul_rsfirewall_hashes1 × 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 *
FROM rabbul_rsfirewall_exceptions1 × 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_snapshots1 × SELECT id
FROM rabbul_categories15 × 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:1792133747;s:18:\"session.timer.last\";i:1792133747;s:17:\"session.timer.now\";i:1792133747;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:10:{s:40:\"aa3e814e30a6cc869885bb55b798dfa74e67077b\";O:8:\"stdClass\":2:{s:4:\"link\";s:61:\"http://www.seacoastnh.com/portsmouth-seal-shows-changed-city/\";s:6:\"expiry\";i:1792133747;}s:40:\"2e87259196c1a9e242cfe0d8d3ebe85353142d6a\";O:8:\"stdClass\":2:{s:4:\"link\";s:61:\"http://www.seacoastnh.com/a-simpler-north-end-halloween-1932/\";s:6:\"expiry\";i:1792133747;}s:40:\"398f2452ddc0d8cbc01dd9c0b5ea48bae147a3ae\";O:8:\"stdClass\":2:{s:4:\"link\";s:70:\"http://www.seacoastnh.com/gilleys-still-my-favorite-portsmouth-eatery/\";s:6:\"expiry\";i:1792133747;}s:40:\"4fc0b05570f31830f1a6510865cb03f9e60699ab\";O:8:\"stdClass\":2:{s:4:\"link\";s:61:\"http://www.seacoastnh.com/l-8-was-first-portsmouth-submarine/\";s:6:\"expiry\";i:1792133747;}s:40:\"e98f7ca6c97da8c418c5957de5cc5c3b8ecdce22\";O:8:\"stdClass\":2:{s:4:\"link\";s:70:\"http://www.seacoastnh.com/before-the-gardens-grew-at-atlantic-heights/\";s:6:\"expiry\";i:1792133747;}s:40:\"a70f779b3b0ad90268fda7e75710d6fd8425b2cc\";O:8:\"stdClass\":2:{s:4:\"link\";s:59:\"http://www.seacoastnh.com/view-
from-the-ceres-street-ferry/\";s:6:\"expiry\";i:1792133747;}s:40:\"f14017149ff00adb3c627429358750176cd35492\";O:8:\"stdClass\":2:{s:4:\"link\";s:58:\"http://www.seacoastnh.com/what-the-uss-ranger-looked-like/\";s:6:\"expiry\";i:1792133747;}s:40:\"63ec3013b6b9dddc375d31c4c61460e174de0ddc\";O:8:\"stdClass\":2:{s:4:\"link\";s:49:\"http://www.seacoastnh.com/spanning-the-centuries/\";s:6:\"expiry\";i:1792133747;}s:40:\"3963da1363c747040c28fa9799823859ff89a1f9\";O:8:\"stdClass\":2:{s:4:\"link\";s:70:\"http://www.seacoastnh.com/a-modest-proposal-for-parking-in-portsmouth/\";s:6:\"expiry\";i:1792133747;}s:40:\"e5e59e73144e88b33ec635e0aaf4d39c0c2f69d6\";O:8:\"stdClass\":2:{s:4:\"link\";s:68:\"http://www.seacoastnh.com/boats-crash-into-portsmouth-ferry-landing/\";s:6:\"expiry\";i:1792133747;}}}' , `time` = '1792133747'1 × SHOW FULL COLUMNS
FROM `rabbul_rsfirewall_logs1 × INSERT INTO `rabbul_session` (`session_id`, `client_id`, `time`)
VALUES ('d5aa773ac59db65a9855aaa45b20ffc6', 0, '1792133747'1 × SHOW FULL COLUMNS
FROM `rabbul_sef_config1 × SHOW FULL COLUMNS
FROM `rabbul_assets1 × DELETE
FROM `rabbul_session`



SeacoastNH.com Presents
SeacoastNH.com Presents 
SeacoastNH.com Presents
SeacoastNH.com Presents
SeacoastNH.com Presents
SeacoastNH.com Presents
SeacoastNH.com Presents
SeacoastNH.com Presents
SeacoastNH.com Presents