|
|
|
||||||||||||||||
|
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/luck-and-mr-fields/
link ⇒ http://www.seacoastnh.com/light-into-darkness/
link ⇒ http://www.seacoastnh.com/august-2008-contest/
link ⇒ http://www.seacoastnh.com/disclaimer/
link ⇒ http://www.seacoastnh.com/spyware-ate-my-browser/
link ⇒ http://www.seacoastnh.com/august-2006-contest/
link ⇒ http://www.seacoastnh.com/meet-ken-mitchell/
Application 0.000 seconds (+0.000); 0.33 MB (+0.331) - afterLoadApplication 0.013 seconds (+0.013); 3.22 MB (+2.887) - afterInitialiseApplication 0.019 seconds (+0.006); 5.03 MB (+1.809) - afterRouteApplication 0.059 seconds (+0.039); 6.39 MB (+1.367) - afterDispatchApplication 0.060 seconds (+0.001); 6.58 MB (+0.187) - beforeRenderModule mod_custom (Footer)Application 0.060 seconds (+0.001); 6.59 MB (+0.010) - afterRenderModule mod_custom (Footer)Application 0.060 seconds (+0.000); 6.59 MB (-0.000) - beforeRenderModule mod_banners (Uncle Oscar)Application 0.062 seconds (+0.002); 6.68 MB (+0.096) - afterRenderModule mod_banners (Uncle Oscar)Application 0.062 seconds (+0.000); 6.70 MB (+0.016) - beforeRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)Application 0.063 seconds (+0.001); 6.82 MB (+0.123) - afterRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)Application 0.064 seconds (+0.000); 6.72 MB (-0.098) - beforeRenderModule mod_novarp (ISC/Star)Application 0.065 seconds (+0.001); 6.83 MB (+0.102) - afterRenderModule mod_novarp (ISC/Star)Application 0.065 seconds (+0.000); 6.71 MB (-0.121) - beforeRenderModule mod_banners (Music Hall)Application 0.066 seconds (+0.001); 6.72 MB (+0.013) - afterRenderModule mod_banners (Music Hall)Application 0.066 seconds (+0.000); 6.71 MB (-0.009) - beforeRenderModule mod_banners (Maren)Application 0.067 seconds (+0.001); 6.72 MB (+0.014) - afterRenderModule mod_banners (Maren)Application 0.067 seconds (+0.000); 6.71 MB (-0.009) - beforeRenderModule mod_banners (Smuttynose Murders)Application 0.067 seconds (+0.001); 6.73 MB (+0.014) - afterRenderModule mod_banners (Smuttynose Murders)Application 0.067 seconds (+0.000); 6.72 MB (-0.009) - beforeRenderModule mod_banners (Banner Maine Harbors)Application 0.068 seconds (+0.001); 6.73 MB (+0.013) - afterRenderModule mod_banners (Banner Maine Harbors)Application 0.068 seconds (+0.000); 6.72 MB (-0.009) - beforeRenderModule mod_banners (Banner Sanctuary Hair)Application 0.069 seconds (+0.001); 6.74 MB (+0.013) - afterRenderModule mod_banners (Banner Sanctuary Hair)Application 0.069 seconds (+0.000); 6.73 MB (-0.009) - beforeRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)Application 0.069 seconds (+0.001); 6.74 MB (+0.011) - afterRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)Application 0.070 seconds (+0.000); 6.76 MB (+0.021) - beforeRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)Application 0.070 seconds (+0.001); 6.83 MB (+0.069) - afterRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)Application 0.070 seconds (+0.000); 6.73 MB (-0.098) - beforeRenderModule mod_banners (Banner sheraton wedding)Application 0.071 seconds (+0.001); 6.74 MB (+0.013) - afterRenderModule mod_banners (Banner sheraton wedding)Application 0.071 seconds (+0.000); 6.74 MB (-0.004) - beforeRenderModule mod_banners (Banner Boating)Application 0.071 seconds (+0.001); 6.75 MB (+0.008) - afterRenderModule mod_banners (Banner Boating)Application 0.071 seconds (+0.000); 6.74 MB (-0.005) - beforeRenderModule mod_banners (Banner Harbour arts)Application 0.072 seconds (+0.001); 6.75 MB (+0.008) - afterRenderModule mod_banners (Banner Harbour arts)Application 0.072 seconds (+0.000); 6.74 MB (-0.007) - beforeRenderModule mod_custom (Google Ads)Application 0.072 seconds (+0.000); 6.75 MB (+0.004) - afterRenderModule mod_custom (Google Ads)Application 0.072 seconds (+0.000); 6.75 MB (-0.002) - beforeRenderModule mod_banners (Banner Newmarket heritage)Application 0.073 seconds (+0.001); 6.76 MB (+0.009) - afterRenderModule mod_banners (Banner Newmarket heritage)Application 0.073 seconds (+0.000); 6.75 MB (-0.004) - beforeRenderModule mod_banners (Shoals Marine Ad)Application 0.073 seconds (+0.001); 6.76 MB (+0.010) - afterRenderModule mod_banners (Shoals Marine Ad)Application 0.073 seconds (+0.000); 6.75 MB (-0.008) - beforeRenderModule mod_feed (News about Portsmouth from Fosters.com)Application 0.093 seconds (+0.019); 7.18 MB (+0.427) - afterRenderModule mod_feed (News about Portsmouth from Fosters.com)Application 0.093 seconds (+0.000); 7.18 MB (-0.001) - beforeRenderModule mod_banners (ad bottom right top)Application 0.094 seconds (+0.001); 7.19 MB (+0.013) - afterRenderModule mod_banners (ad bottom right top)Application 0.094 seconds (+0.000); 7.18 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right mid)Application 0.095 seconds (+0.001); 7.20 MB (+0.014) - afterRenderModule mod_banners (ad bottom right mid)Application 0.095 seconds (+0.000); 7.19 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right bottom)Application 0.096 seconds (+0.001); 7.20 MB (+0.014) - afterRenderModule mod_banners (ad bottom right bottom)Application 0.096 seconds (+0.000); 7.20 MB (-0.008) - beforeRenderModule mod_banners (ad bottom mid top)Application 0.097 seconds (+0.001); 7.21 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid top)Application 0.097 seconds (+0.000); 7.20 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid mid)Application 0.097 seconds (+0.001); 7.21 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid mid)Application 0.097 seconds (+0.000); 7.20 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid bottom)Application 0.098 seconds (+0.001); 7.22 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid bottom)Application 0.098 seconds (+0.000); 7.21 MB (-0.008) - beforeRenderModule mod_banners (ad bottom left top)Application 0.099 seconds (+0.001); 7.22 MB (+0.014) - afterRenderModule mod_banners (ad bottom left top)Application 0.099 seconds (+0.000); 7.21 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left mid)Application 0.100 seconds (+0.001); 7.23 MB (+0.013) - afterRenderModule mod_banners (ad bottom left mid)Application 0.100 seconds (+0.000); 7.22 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left bottom)Application 0.100 seconds (+0.000); 7.23 MB (+0.011) - afterRenderModule mod_banners (ad bottom left bottom)Application 0.101 seconds (+0.000); 7.22 MB (-0.006) - beforeRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)Application 0.101 seconds (+0.000); 7.23 MB (+0.004) - afterRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)Application 0.101 seconds (+0.000); 7.23 MB (-0.001) - beforeRenderModule mod_finder (smart_search)Application 0.104 seconds (+0.003); 7.31 MB (+0.080) - afterRenderModule mod_finder (smart_search)Application 0.104 seconds (+0.000); 7.30 MB (-0.006) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)Application 0.105 seconds (+0.001); 7.32 MB (+0.013) - afterRenderModule mod_breadcrumbs (Breadcrumbs)Application 0.105 seconds (+0.000); 7.31 MB (-0.005) - beforeRenderModule mod_menu (topmenu)Application 0.105 seconds (+0.000); 7.33 MB (+0.016) - afterRenderModule mod_menu (topmenu)Application 0.105 seconds (+0.000); 7.32 MB (-0.006) - beforeRenderModule mod_custom (feedback)Application 0.105 seconds (+0.000); 7.33 MB (+0.004) - afterRenderModule mod_custom (feedback)Application 0.105 seconds (+0.000); 7.32 MB (-0.003) - beforeRenderModule mod_custom (SeacoastNH Feedback)Application 0.105 seconds (+0.000); 7.33 MB (+0.004) - afterRenderModule mod_custom (SeacoastNH Feedback)Application 0.105 seconds (+0.000); 7.32 MB (-0.003) - beforeRenderModule mod_custom (MainHeader)Application 0.106 seconds (+0.000); 7.33 MB (+0.004) - afterRenderModule mod_custom (MainHeader)Application 0.106 seconds (+0.000); 7.33 MB (-0.002) - beforeRenderModule mod_custom (Facebook)Application 0.106 seconds (+0.000); 7.33 MB (+0.004) - afterRenderModule mod_custom (Facebook)Application 0.106 seconds (+0.000); 7.33 MB (-0.002) - beforeRenderModule mod_menu (Main Menu)Application 0.110 seconds (+0.004); 7.40 MB (+0.070) - afterRenderModule mod_menu (Main Menu)Application 0.110 seconds (+0.000); 7.39 MB (-0.007) - beforeRenderModule mod_custom (Donate to Our Site)Application 0.110 seconds (+0.000); 7.39 MB (+0.004) - afterRenderModule mod_custom (Donate to Our Site)Application 0.110 seconds (+0.000); 7.39 MB (-0.003) - beforeRenderModule mod_custom (Feedjit)Application 0.110 seconds (+0.000); 7.40 MB (+0.004) - afterRenderModule mod_custom (Feedjit)Application 0.110 seconds (+0.000); 7.39 MB (-0.003) - beforeRenderModule mod_custom (facebook lower logo)Application 0.110 seconds (+0.000); 7.40 MB (+0.004) - afterRenderModule mod_custom (facebook lower logo)Application 0.111 seconds (+0.000); 7.43 MB (+0.036) - afterRender7.45 MB (7,808,760 Bytes)SELECT `data`
FROM `rabbul_session`
WHERE `session_id` = '3a6c5d5585bd504b0eb07589c07ef349'DELETE
FROM `rabbul_session`
WHERE `time` < '1792147859'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 = 'Today/about-ken5/'
AND published='1'
LIMIT 1SELECT id
FROM rabbul_menu
WHERE alias='Today'
AND published=1SELECT id
FROM rabbul_categories
WHERE path='Today/about-ken5'
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=122'
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 = 122SELECT id
FROM rabbul_menu
WHERE type='component'
AND published='1'
AND link LIKE 'index.php?option=com_content&view=categor%&id=298'
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=122
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.122')
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 = 122 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 = 122))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-16 11:05:59')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-16 11:05:59')
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 = 122 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 = 122))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-16 11:05:59')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-16 11:05:59')
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=298
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 = 122SELECT path
FROM rabbul_categories
WHERE id = 122SELECT 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 = 74SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 74SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 74SELECT 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:05:59')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-16 11:05:59')
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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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:05:59' >= `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 = 298SELECT 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:8;s:19:\"session.timer.start\";i:1792148756;s:18:\"session.timer.last\";i:1792148759;s:17:\"session.timer.now\";i:1792148759;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:7:{s:40:\"9fa2727808075b6585b65d7775af70faa306ab3c\";O:8:\"stdClass\":2:{s:4:\"link\";s:45:\"http://www.seacoastnh.com/luck-
and-mr-fields/\";s:6:\"expiry\";i:1792148756;}s:40:\"0b4c00af2c9a2c560ea6e5741e23999b94b9ab55\";O:8:\"stdClass\":2:{s:4:\"link\";s:46:\"http://www.seacoastnh.com/light-into-darkness/\";s:6:\"expiry\";i:1792148756;}s:40:\"7524c3c28291d0619bcba64aa712976b0a1131b6\";O:8:\"stdClass\":2:{s:4:\"link\";s:46:\"http://www.seacoastnh.com/august-2008-contest/\";s:6:\"expiry\";i:1792148757;}s:40:\"ad7d567d49fdb5d7ed12dfadb047858d08d3fcc1\";O:8:\"stdClass\":2:{s:4:\"link\";s:37:\"http://www.seacoastnh.com/disclaimer/\";s:6:\"expiry\";i:1792148757;}s:40:\"cd3eaa754e5b2106ea1b1d917a4910717822e8e5\";O:8:\"stdClass\":2:{s:4:\"link\";s:49:\"http://www.seacoastnh.com/spyware-ate-my-browser/\";s:6:\"expiry\";i:1792148759;}s:40:\"e4b2fd1196251bdefdc8249c8ab7a26377145add\";O:8:\"stdClass\":2:{s:4:\"link\";s:46:\"http://www.seacoastnh.com/august-2006-contest/\";s:6:\"expiry\";i:1792148758;}s:40:\"b545a5076306f6a4154579247158ce825e49c03d\";O:8:\"stdClass\":2:{s:4:\"link\";s:44:\"http://www.seacoastnh.com/meet-ken-mitchell/\";s:6:\"expiry\";i:1792148759;}}}'
, `time` = '1792148759'
WHERE `session_id` = '3a6c5d5585bd504b0eb07589c07ef349'40 × 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_categories5 × SELECT a.alias AS article
FROM rabbul_content AS a4 × SELECT b.rules
FROM rabbul_assets AS a
LEFT JOIN rabbul_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM rabbul_extensions3 × 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:8;s:19:\"session.timer.start\";i:1792148756;s:18:\"session.timer.last\";i:1792148759;s:17:\"session.timer.now\";i:1792148759;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:7:{s:40:\"9fa2727808075b6585b65d7775af70faa306ab3c\";O:8:\"stdClass\":2:{s:4:\"link\";s:45:\"http://www.seacoastnh.com/luck-
and-mr-fields/\";s:6:\"expiry\";i:1792148756;}s:40:\"0b4c00af2c9a2c560ea6e5741e23999b94b9ab55\";O:8:\"stdClass\":2:{s:4:\"link\";s:46:\"http://www.seacoastnh.com/light-into-darkness/\";s:6:\"expiry\";i:1792148756;}s:40:\"7524c3c28291d0619bcba64aa712976b0a1131b6\";O:8:\"stdClass\":2:{s:4:\"link\";s:46:\"http://www.seacoastnh.com/august-2008-contest/\";s:6:\"expiry\";i:1792148757;}s:40:\"ad7d567d49fdb5d7ed12dfadb047858d08d3fcc1\";O:8:\"stdClass\":2:{s:4:\"link\";s:37:\"http://www.seacoastnh.com/disclaimer/\";s:6:\"expiry\";i:1792148757;}s:40:\"cd3eaa754e5b2106ea1b1d917a4910717822e8e5\";O:8:\"stdClass\":2:{s:4:\"link\";s:49:\"http://www.seacoastnh.com/spyware-ate-my-browser/\";s:6:\"expiry\";i:1792148759;}s:40:\"e4b2fd1196251bdefdc8249c8ab7a26377145add\";O:8:\"stdClass\":2:{s:4:\"link\";s:46:\"http://www.seacoastnh.com/august-2006-contest/\";s:6:\"expiry\";i:1792148758;}s:40:\"b545a5076306f6a4154579247158ce825e49c03d\";O:8:\"stdClass\":2:{s:4:\"link\";s:44:\"http://www.seacoastnh.com/meet-ken-mitchell/\";s:6:\"expiry\";i:1792148759;}}}' , `time` = '1792148759'1 × SHOW FULL COLUMNS
FROM `rabbul_rsfirewall_logs1 × SHOW FULL COLUMNS
FROM `rabbul_sef_config1 × SHOW FULL COLUMNS
FROM `rabbul_assets1 × DELETE
FROM `rabbul_session`



Ken Mitchell is a professional forecaster with a BS in Meteorology and over a decade of "go/no go" predictions for the US Air Force. While on duty, he worked as a forecatser at Pease AFB, and eventually was chosen to successfully manage a full-function weather station in the Midwest for over 4 years. He's been forecasting for SeacoastNH.com every morning non-stop since the summer of 1998. Hence, he has over 20 years of experience backing up his daily issues. Ken only misses a day here and there when on vacation, is otherwise pulled away from his keyboard, or when his computer raises an objection. After putting out the forecast, he heads off to his full-time job. His advice has been sought after and printed by local daily newspapers, and he has a very loyal corps of readers. He's been providing forecasts to SeacoastNH.com since 1998, and recently celebrated a speed-limit birthday (55).