|
|
|
|||||||||||
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.browser ⇒ Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
password_clear ⇒
groups ⇒
com_rsfirewall.geoip ⇒
link ⇒ http://www.seacoastnh.com/portsmouth-aqueduct-company-piped-water-through-logs/
link ⇒ http://www.seacoastnh.com/warner-house-built-300-years-ago/
link ⇒ http://www.seacoastnh.com/living-with-the-ghost-of-ichabod-goodwin/
link ⇒ http://www.seacoastnh.com/walking-the-historic-streets-of-portsmouth-nh/
link ⇒ http://www.seacoastnh.com/the-science-of-the-historic-appledore-island-garden/
link ⇒ http://www.seacoastnh.com/a-quick-history-of-gulls-on-the-shoals/
link ⇒ http://www.seacoastnh.com/the-making-of-an-unprecedented-edmund-tarbell-art-exhibit/
link ⇒ http://www.seacoastnh.com/nh-born-publisher-enticed-charles-dickens-back-to-america-in-1867/
link ⇒ http://www.seacoastnh.com/three-lives-of-the-portsmouth-marine-society/
link ⇒ http://www.seacoastnh.com/ben-franklin-installed-new-hampshire-lightning-rod-in-1763/
link ⇒ http://www.seacoastnh.com/kittery-little-red-schoolhouse-on-life-support/
link ⇒ http://www.seacoastnh.com/the-man-who-dug-up-john-paul-jones/
link ⇒ http://www.seacoastnh.com/miss-nancy-underhill-swept-off-star-island-in-1848/
link ⇒ http://www.seacoastnh.com/us-wwii-ambassador-john-winant-gets-his-memorial-at-las/
link ⇒ http://www.seacoastnh.com/the-unexpected-portsmouth-art-gallery/
link ⇒ http://www.seacoastnh.com/inside-the-wondrous-woodman-museum/
link ⇒ http://www.seacoastnh.com/my-favorite-portsmouth-history-books-for-kids/
link ⇒ http://www.seacoastnh.com/main-street-south-berwick-over-200-years/
link ⇒ http://www.seacoastnh.com/lakes-region-legends-celebrated-in-new-book/
link ⇒ http://www.seacoastnh.com/the-truth-about-bricks-and-mortar/
Application 0.000 seconds (+0.000); 0.33 MB (+0.328) - afterLoad
Application 0.030 seconds (+0.030); 3.21 MB (+2.883) - afterInitialise
Application 0.046 seconds (+0.016); 4.76 MB (+1.547) - afterRoute
Application 0.486 seconds (+0.440); 7.85 MB (+3.092) - afterDispatch
Application 0.491 seconds (+0.005); 8.04 MB (+0.187) - beforeRenderModule mod_custom (Footer)
Application 0.493 seconds (+0.002); 8.05 MB (+0.010) - afterRenderModule mod_custom (Footer)
Application 0.493 seconds (+0.000); 8.05 MB (-0.000) - beforeRenderModule mod_banners (Uncle Oscar)
Application 0.504 seconds (+0.010); 8.15 MB (+0.107) - afterRenderModule mod_banners (Uncle Oscar)
Application 0.504 seconds (+0.000); 8.17 MB (+0.016) - beforeRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)
Application 0.509 seconds (+0.005); 8.29 MB (+0.123) - afterRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)
Application 0.510 seconds (+0.000); 8.20 MB (-0.098) - beforeRenderModule mod_novarp (ISC/Star)
Application 0.515 seconds (+0.005); 8.30 MB (+0.101) - afterRenderModule mod_novarp (ISC/Star)
Application 0.515 seconds (+0.000); 8.18 MB (-0.121) - beforeRenderModule mod_banners (Music Hall)
Application 0.526 seconds (+0.010); 8.19 MB (+0.013) - afterRenderModule mod_banners (Music Hall)
Application 0.526 seconds (+0.000); 8.18 MB (-0.009) - beforeRenderModule mod_banners (Maren)
Application 0.532 seconds (+0.007); 8.19 MB (+0.014) - afterRenderModule mod_banners (Maren)
Application 0.533 seconds (+0.000); 8.19 MB (-0.009) - beforeRenderModule mod_banners (Smuttynose Murders)
Application 0.540 seconds (+0.007); 8.20 MB (+0.014) - afterRenderModule mod_banners (Smuttynose Murders)
Application 0.540 seconds (+0.000); 8.19 MB (-0.009) - beforeRenderModule mod_banners (Banner Maine Harbors)
Application 0.545 seconds (+0.005); 8.20 MB (+0.013) - afterRenderModule mod_banners (Banner Maine Harbors)
Application 0.545 seconds (+0.000); 8.19 MB (-0.009) - beforeRenderModule mod_banners (Banner Sanctuary Hair)
Application 0.550 seconds (+0.005); 8.21 MB (+0.013) - afterRenderModule mod_banners (Banner Sanctuary Hair)
Application 0.550 seconds (+0.000); 8.20 MB (-0.009) - beforeRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)
Application 0.555 seconds (+0.004); 8.21 MB (+0.011) - afterRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)
Application 0.555 seconds (+0.000); 8.23 MB (+0.020) - beforeRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)
Application 0.558 seconds (+0.003); 8.30 MB (+0.069) - afterRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)
Application 0.559 seconds (+0.000); 8.20 MB (-0.097) - beforeRenderModule mod_banners (Banner sheraton wedding)
Application 0.562 seconds (+0.003); 8.21 MB (+0.013) - afterRenderModule mod_banners (Banner sheraton wedding)
Application 0.562 seconds (+0.000); 8.21 MB (-0.004) - beforeRenderModule mod_banners (Banner Boating)
Application 0.565 seconds (+0.003); 8.22 MB (+0.008) - afterRenderModule mod_banners (Banner Boating)
Application 0.565 seconds (+0.000); 8.21 MB (-0.005) - beforeRenderModule mod_banners (Banner Harbour arts)
Application 0.568 seconds (+0.003); 8.22 MB (+0.008) - afterRenderModule mod_banners (Banner Harbour arts)
Application 0.568 seconds (+0.000); 8.21 MB (-0.007) - beforeRenderModule mod_custom (Google Ads)
Application 0.569 seconds (+0.000); 8.22 MB (+0.004) - afterRenderModule mod_custom (Google Ads)
Application 0.569 seconds (+0.000); 8.22 MB (-0.002) - beforeRenderModule mod_banners (Banner Newmarket heritage)
Application 0.572 seconds (+0.003); 8.22 MB (+0.008) - afterRenderModule mod_banners (Banner Newmarket heritage)
Application 0.572 seconds (+0.000); 8.22 MB (-0.004) - beforeRenderModule mod_banners (Shoals Marine Ad)
Application 0.583 seconds (+0.011); 8.23 MB (+0.010) - afterRenderModule mod_banners (Shoals Marine Ad)
Application 0.583 seconds (+0.001); 8.22 MB (-0.008) - beforeRenderModule mod_feed (News about Portsmouth from Fosters.com)
Application 0.669 seconds (+0.086); 8.65 MB (+0.426) - afterRenderModule mod_feed (News about Portsmouth from Fosters.com)
Application 0.669 seconds (+0.000); 8.65 MB (-0.001) - beforeRenderModule mod_banners (ad bottom right top)
Application 0.678 seconds (+0.009); 8.66 MB (+0.013) - afterRenderModule mod_banners (ad bottom right top)
Application 0.678 seconds (+0.000); 8.65 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right mid)
Application 0.686 seconds (+0.008); 8.67 MB (+0.014) - afterRenderModule mod_banners (ad bottom right mid)
Application 0.686 seconds (+0.000); 8.66 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right bottom)
Application 0.720 seconds (+0.034); 8.67 MB (+0.014) - afterRenderModule mod_banners (ad bottom right bottom)
Application 0.720 seconds (+0.000); 8.66 MB (-0.008) - beforeRenderModule mod_banners (ad bottom mid top)
Application 0.730 seconds (+0.010); 8.68 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid top)
Application 0.730 seconds (+0.000); 8.67 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid mid)
Application 0.738 seconds (+0.007); 8.68 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid mid)
Application 0.738 seconds (+0.000); 8.67 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid bottom)
Application 0.746 seconds (+0.008); 8.68 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid bottom)
Application 0.746 seconds (+0.000); 8.68 MB (-0.008) - beforeRenderModule mod_banners (ad bottom left top)
Application 0.755 seconds (+0.009); 8.69 MB (+0.014) - afterRenderModule mod_banners (ad bottom left top)
Application 0.756 seconds (+0.000); 8.68 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left mid)
Application 0.773 seconds (+0.018); 8.70 MB (+0.013) - afterRenderModule mod_banners (ad bottom left mid)
Application 0.773 seconds (+0.000); 8.69 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left bottom)
Application 0.779 seconds (+0.006); 8.70 MB (+0.011) - afterRenderModule mod_banners (ad bottom left bottom)
Application 0.780 seconds (+0.000); 8.69 MB (-0.006) - beforeRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)
Application 0.780 seconds (+0.000); 8.70 MB (+0.004) - afterRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)
Application 0.780 seconds (+0.000); 8.70 MB (-0.001) - beforeRenderModule mod_finder (smart_search)
Application 0.794 seconds (+0.014); 8.77 MB (+0.080) - afterRenderModule mod_finder (smart_search)
Application 0.794 seconds (+0.000); 8.77 MB (-0.006) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.796 seconds (+0.002); 8.80 MB (+0.030) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.797 seconds (+0.000); 8.80 MB (-0.003) - beforeRenderModule mod_menu (topmenu)
Application 0.799 seconds (+0.003); 8.81 MB (+0.016) - afterRenderModule mod_menu (topmenu)
Application 0.799 seconds (+0.000); 8.81 MB (-0.006) - beforeRenderModule mod_custom (feedback)
Application 0.800 seconds (+0.000); 8.81 MB (+0.004) - afterRenderModule mod_custom (feedback)
Application 0.800 seconds (+0.000); 8.81 MB (-0.003) - beforeRenderModule mod_custom (SeacoastNH Feedback)
Application 0.800 seconds (+0.000); 8.81 MB (+0.004) - afterRenderModule mod_custom (SeacoastNH Feedback)
Application 0.800 seconds (+0.000); 8.81 MB (-0.003) - beforeRenderModule mod_custom (MainHeader)
Application 0.800 seconds (+0.000); 8.81 MB (+0.004) - afterRenderModule mod_custom (MainHeader)
Application 0.800 seconds (+0.000); 8.81 MB (-0.002) - beforeRenderModule mod_custom (Facebook)
Application 0.801 seconds (+0.000); 8.82 MB (+0.004) - afterRenderModule mod_custom (Facebook)
Application 0.801 seconds (+0.000); 8.81 MB (-0.002) - beforeRenderModule mod_menu (Main Menu)
Application 0.817 seconds (+0.016); 8.88 MB (+0.071) - afterRenderModule mod_menu (Main Menu)
Application 0.817 seconds (+0.000); 8.88 MB (-0.007) - beforeRenderModule mod_custom (Donate to Our Site)
Application 0.817 seconds (+0.001); 8.88 MB (+0.004) - afterRenderModule mod_custom (Donate to Our Site)
Application 0.817 seconds (+0.000); 8.88 MB (-0.003) - beforeRenderModule mod_custom (Feedjit)
Application 0.818 seconds (+0.000); 8.88 MB (+0.004) - afterRenderModule mod_custom (Feedjit)
Application 0.818 seconds (+0.000); 8.88 MB (-0.003) - beforeRenderModule mod_custom (facebook lower logo)
Application 0.818 seconds (+0.001); 8.88 MB (+0.004) - afterRenderModule mod_custom (facebook lower logo)
Application 0.819 seconds (+0.001); 9.08 MB (+0.201) - afterRender
9.24 MB (9,684,168 Bytes)
SELECT `data`
FROM `rabbul_session`
WHERE `session_id` = 'b6710739a73c2c8e94a4d6b19031139b'
DELETE
FROM `rabbul_session`
WHERE `time` < '1741673433'
SELECT `session_id`
FROM `rabbul_session`
WHERE `session_id` = 'b6710739a73c2c8e94a4d6b19031139b'
LIMIT 0, 1
INSERT INTO `rabbul_session`
(`session_id`, `client_id`, `time`)
VALUES
('b6710739a73c2c8e94a4d6b19031139b', 0, '1741674333')
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 = 1
SELECT 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 ordering
SELECT 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` ASC
SELECT `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_configuration
SHOW 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 id
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_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT `id`
FROM `rabbul_usergroups`
SELECT parent.id, parent.lft, parent.rgt
FROM rabbul_usergroups AS parent
ORDER BY parent.lft
SHOW FULL COLUMNS
FROM `rabbul_assets`
SELECT id
FROM rabbul_assets
WHERE parent_id = 0
SELECT 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.lft
SELECT id
FROM rabbul_assets
WHERE parent_id = 0
SELECT rules
FROM rabbul_assets
WHERE id = '1'
SELECT id
FROM rabbul_assets
WHERE parent_id = 0
SELECT id
FROM rabbul_assets
WHERE parent_id = 0
SELECT id
FROM rabbul_assets
WHERE parent_id = 0
SELECT id
FROM rabbul_assets
WHERE parent_id = 0
SELECT id
FROM rabbul_assets
WHERE parent_id = 0
SELECT id
FROM rabbul_assets
WHERE parent_id = 0
SELECT id
FROM rabbul_assets
WHERE parent_id = 0
SELECT id
FROM rabbul_assets
WHERE parent_id = 0
SELECT id
FROM rabbul_assets
WHERE parent_id = 0
SELECT id
FROM rabbul_assets
WHERE parent_id = 0
SELECT id
FROM rabbul_assets
WHERE parent_id = 0
SELECT id
FROM rabbul_assets
WHERE parent_id = 0
SELECT id
FROM rabbul_assets
WHERE parent_id = 0
SELECT 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 ASC
SHOW 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`='18.220.173.236' OR `ip` LIKE '%*%')
AND `type`='1'
AND `published`='1'
SELECT `ip`,`reason`
FROM rabbul_rsfirewall_lists
WHERE (`ip`='18.220.173.236' 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 ASC
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_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT a.rules
FROM rabbul_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT 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.lft
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 contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM rabbul_content AS a
LEFT JOIN rabbul_categories AS c
ON c.id = a.catid
LEFT JOIN rabbul_users AS ua
ON ua.id = a.created_by
LEFT JOIN rabbul_users AS uam
ON uam.id = a.modified_by
LEFT JOIN rabbul_categories as parent
ON parent.id = c.parent_id
LEFT JOIN rabbul_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM rabbul_categories AS cat JOIN rabbul_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
INNER JOIN rabbul_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-03-11 06:25:33')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-03-11 06:25:33')
ORDER BY a.created DESC , a.created DESC
LIMIT 0, 30
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 contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM rabbul_content AS a
LEFT JOIN rabbul_categories AS c
ON c.id = a.catid
LEFT JOIN rabbul_users AS ua
ON ua.id = a.created_by
LEFT JOIN rabbul_users AS uam
ON uam.id = a.modified_by
LEFT JOIN rabbul_categories as parent
ON parent.id = c.parent_id
LEFT JOIN rabbul_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM rabbul_categories AS cat JOIN rabbul_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
INNER JOIN rabbul_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-03-11 06:25:33')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-03-11 06:25:33')
ORDER BY a.created DESC , a.created DESC
SELECT alias,home
FROM rabbul_menu
WHERE id='100001'
SELECT alias,home
FROM rabbul_menu
WHERE id='100001'
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM rabbul_categories as c
LEFT JOIN rabbul_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM rabbul_categories AS cat JOIN rabbul_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=257
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3922
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3922
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3922
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3920
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3920
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3920
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3919
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3919
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3919
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3918
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3918
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3918
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3917
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3917
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3917
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3916
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3916
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3916
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3915
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3915
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3915
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3914
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3914
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3914
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3913
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3913
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3913
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3912
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3912
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3912
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3911
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3911
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3911
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3910
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3910
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3910
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3909
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3909
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3909
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3908
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3908
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3908
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3907
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3907
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3907
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3906
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3906
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3906
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3905
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3905
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3905
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=93
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3904
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3904
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3904
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=140
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3903
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3903
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3903
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3902
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3902
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3902
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3901
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3900
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3899
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3898
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3897
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3895
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3893
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3888
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=141
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3871
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3860
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_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-03-11 06:25:33')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-03-11 06:25:33')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 100001 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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.ordering
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.ordering
LIMIT 0, 1
UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 100
SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=100
AND track_date='2025-03-11 06'
SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=100
AND track_date='2025-03-11 06'
UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=100
AND track_date='2025-03-11 06'
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 100
SELECT *
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 3
UPDATE `rabbul_banners`
SET `impmade` = (`impmade` + 1)
WHERE `id` = 79
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 79
SELECT *
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 2
UPDATE `rabbul_banners`
SET `impmade` = (`impmade` + 1)
WHERE `id` = 45
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 45
UPDATE `rabbul_banners`
SET `impmade` = (`impmade` + 1)
WHERE `id` = 94
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 94
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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.ordering
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.ordering
LIMIT 0, 1
UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 91
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 91
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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.ordering
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.ordering
LIMIT 0, 1
UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 87
SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=87
AND track_date='2025-03-11 06'
SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=87
AND track_date='2025-03-11 06'
UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=87
AND track_date='2025-03-11 06'
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 87
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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.ordering
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.ordering
LIMIT 0, 1
UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 84
SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=84
AND track_date='2025-03-11 06'
SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=84
AND track_date='2025-03-11 06'
UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=84
AND track_date='2025-03-11 06'
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 84
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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.ordering
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.ordering
LIMIT 0, 3
UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 14
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 14
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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.ordering
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.ordering
LIMIT 0, 3
UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 19
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 19
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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, 3
SELECT *
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 2
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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, 1
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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.ordering
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.ordering
LIMIT 0, 3
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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.ordering
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.ordering
LIMIT 0, 3
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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, 1
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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, 1
UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 95
SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=95
AND track_date='2025-03-11 06'
SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=95
AND track_date='2025-03-11 06'
UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=95
AND track_date='2025-03-11 06'
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 95
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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, 4
UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 29
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 29
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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, 4
UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 30
SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=30
AND track_date='2025-03-11 06'
SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=30
AND track_date='2025-03-11 06'
UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=30
AND track_date='2025-03-11 06'
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 30
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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, 4
UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 31
SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=31
AND track_date='2025-03-11 06'
SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=31
AND track_date='2025-03-11 06'
UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=31
AND track_date='2025-03-11 06'
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 31
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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, 4
UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 26
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 26
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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, 4
UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 27
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 27
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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, 4
UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 28
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 28
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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, 4
UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 23
SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=23
AND track_date='2025-03-11 06'
SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1
AND banner_id=23
AND track_date='2025-03-11 06'
UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=23
AND track_date='2025-03-11 06'
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 23
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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, 1
UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 65
SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 65
SELECT *
FROM rabbul_banners
WHERE '2025-03-11 06:25:33' >= `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, 5
SELECT 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` = 1
SELECT `title`
FROM `rabbul_finder_taxonomy`
WHERE `parent_id` = 1
AND `state` = 1
AND `access` IN (1,1)
SELECT link
FROM rabbul_menu
WHERE id=100196
SELECT link
FROM rabbul_menu
WHERE id=100001
SELECT link
FROM rabbul_menu
WHERE id=269
SELECT path
FROM rabbul_categories
WHERE id = 307
SELECT link
FROM rabbul_menu
WHERE id=157
SELECT path
FROM rabbul_categories
WHERE id = 311
SELECT link
FROM rabbul_menu
WHERE id=158
SELECT path
FROM rabbul_categories
WHERE id = 312
SELECT link
FROM rabbul_menu
WHERE id=264
SELECT path
FROM rabbul_categories
WHERE id = 313
SELECT link
FROM rabbul_menu
WHERE id=160
SELECT path
FROM rabbul_categories
WHERE id = 314
SELECT link
FROM rabbul_menu
WHERE id=161
SELECT path
FROM rabbul_categories
WHERE id = 331
SELECT link
FROM rabbul_menu
WHERE id=123
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 48
SELECT link
FROM rabbul_menu
WHERE id=100014
SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3835
UPDATE `rabbul_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1741674333;s:18:\"session.timer.last\";i:1741674333;s:17:\"session.timer.now\";i:1741674333;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:20:\"com_rsfirewall.geoip\";s:0:\"\";s:16:\"com_mailto.links\";a:20:{s:40:\"090eb7e6d37b123ca7eff95fceab7fc4e0f3375f\";O:8:\"stdClass\":2:{s:4:\"link\";s:79:\"http://www.seacoastnh.com/portsmouth-aqueduct-company-piped-water-through-logs/\";s:6:\"expiry\";i:1741674333;}s:40:\"9128a0ee355433471bce877308df9ec271d6dab7\";O:8:\"stdClass\":2:{s:4:\"link\";s:59:\"http://www.seacoastnh.com/warner-house-built-300-years-ago/\";s:6:\"expiry\";i:1741674333;}s:40:\"2b6101b7f77c073d4ddcd9ca654e571298f6f38c\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://www.seacoastnh.com/living-with-the-ghost-of-ichabod-goodwin/\";s:6:\"expiry\";i:1741674333;}s:40:\"52cd5b6b7c6bf2004020ce09051858b07b20be81\";O:8:\"stdClass\":2:{s:4:\"link\";s:72:\"http://www.seacoastnh.com/walking-the-historic-streets-of-portsmouth-nh/\";s:6:\"expiry\";i:1741674333;}s:40:\"457852410d147044fdf5f1f8d74d7af80701a5c6\";O:8:\"stdClass\":2:{s:4:\"link\";s:78:\"http://www.seacoastnh.com/the-science-of-the-historic-appledore-island-garden/\";s:6:\"expiry\";i:1741674333;}s:40:\"958e15564a2878588a0681b4d9f3bab77d6c5455\";O:8:\"stdClass\":2:{s:4:\"link\";s:65:\"http://www.seacoastnh.com/a-quick-history-of-gulls-
on-the-shoals/\";s:6:\"expiry\";i:1741674333;}s:40:\"871467c2f59b9bebadbad68b07ee0d14ee0da8b9\";O:8:\"stdClass\":2:{s:4:\"link\";s:84:\"http://www.seacoastnh.com/the-making-of-an-unprecedented-edmund-tarbell-art-exhibit/\";s:6:\"expiry\";i:1741674333;}s:40:\"a7b2d6b19e10bb1b578039485245365bba6d2a93\";O:8:\"stdClass\":2:{s:4:\"link\";s:92:\"http://www.seacoastnh.com/nh-born-publisher-enticed-charles-dickens-back-to-america-in-1867/\";s:6:\"expiry\";i:1741674333;}s:40:\"02f09748c4fbce71e86c452d1244989822bdae80\";O:8:\"stdClass\":2:{s:4:\"link\";s:71:\"http://www.seacoastnh.com/three-lives-of-the-portsmouth-marine-society/\";s:6:\"expiry\";i:1741674333;}s:40:\"322ecc2480151ab25e2ba65f338c73c592e3609a\";O:8:\"stdClass\":2:{s:4:\"link\";s:85:\"http://www.seacoastnh.com/ben-franklin-installed-new-hampshire-lightning-rod-in-1763/\";s:6:\"expiry\";i:1741674333;}s:40:\"a4d82569b0cac5ae04f55b5e42a8620a5553d144\";O:8:\"stdClass\":2:{s:4:\"link\";s:73:\"http://www.seacoastnh.com/kittery-little-red-schoolhouse-
on-life-support/\";s:6:\"expiry\";i:1741674333;}s:40:\"e07ee172e4135ff683ab8d79d79b3b1d2f4515b5\";O:8:\"stdClass\":2:{s:4:\"link\";s:61:\"http://www.seacoastnh.com/the-man-who-dug-up-john-paul-jones/\";s:6:\"expiry\";i:1741674333;}s:40:\"6b41a9b7783fe5be813bdbed66211aa3e7a49bc8\";O:8:\"stdClass\":2:{s:4:\"link\";s:77:\"http://www.seacoastnh.com/miss-nancy-underhill-swept-off-star-island-in-1848/\";s:6:\"expiry\";i:1741674333;}s:40:\"296d013e0b8ca7cf338b68a25bd39fd1a4e9f561\";O:8:\"stdClass\":2:{s:4:\"link\";s:82:\"http://www.seacoastnh.com/us-wwii-ambassador-john-winant-gets-his-memorial-at-las/\";s:6:\"expiry\";i:1741674333;}s:40:\"296f1f783e43b33b4f47146d81420afb1c18c44a\";O:8:\"stdClass\":2:{s:4:\"link\";s:64:\"http://www.seacoastnh.com/the-unexpected-portsmouth-art-gallery/\";s:6:\"expiry\";i:1741674333;}s:40:\"b9255d8b918cfd151f48400b9e544cbc96e7cbef\";O:8:\"stdClass\":2:{s:4:\"link\";s:61:\"http://www.seacoastnh.com/inside-the-wondrous-woodman-museum/\";s:6:\"expiry\";i:1741674333;}s:40:\"aec7fcef9ebfccdad89dde84f6be859b74b48bbc\";O:8:\"stdClass\":2:{s:4:\"link\";s:72:\"http://www.seacoastnh.com/my-favorite-portsmouth-history-books-for-kids/\";s:6:\"expiry\";i:1741674333;}s:40:\"39a07ae374d622c3c0db9857abe9736dcf9e6005\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://www.seacoastnh.com/main-street-south-berwick-over-200-years/\";s:6:\"expiry\";i:1741674333;}s:40:\"b7cb9ccf9c9f7f39ee69bacb116e46e367020ef5\";O:8:\"stdClass\":2:{s:4:\"link\";s:70:\"http://www.seacoastnh.com/lakes-region-legends-celebrated-in-new-book/\";s:6:\"expiry\";i:1741674333;}s:40:\"c2c7ea497ac448265e205958874f8bb929782647\";O:8:\"stdClass\":2:{s:4:\"link\";s:60:\"http://www.seacoastnh.com/the-truth-about-bricks-
and-mortar/\";s:6:\"expiry\";i:1741674333;}}}'
, `time` = '1741674334'
WHERE `session_id` = 'b6710739a73c2c8e94a4d6b19031139b'
72 × SELECT a.alias AS article
FROM rabbul_content AS a
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.id
21 × SELECT *
FROM rabbul_banners
18 × SELECT b.alias AS banner
FROM rabbul_banners AS b
15 × SELECT id
FROM rabbul_assets
14 × SELECT `count`
FROM rabbul_banner_tracks
10 × SELECT link
FROM rabbul_menu
6 × SELECT path
FROM rabbul_categories
4 × 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
4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM rabbul_extensions
3 × SELECT *
FROM rabbul_banners
2 × SELECT alias,home
FROM rabbul_menu
2 × SELECT b.rules
FROM rabbul_assets AS a
LEFT JOIN rabbul_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
2 × 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
2 × SELECT `ip`,`reason`
FROM rabbul_rsfirewall_lists
2 × 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 contact
1 × SELECT *
FROM rabbul_languages
1 × 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_id
1 × SELECT a.rules
FROM rabbul_assets AS a
1 × 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_id
1 × SELECT `title`
FROM `rabbul_finder_taxonomy`
1 × SELECT name
FROM `rabbul_extensions`
1 × SELECT *
FROM rabbul_rsfirewall_exceptions
1 × SELECT *
FROM rabbul_rsfirewall_hashes
1 × SELECT `value`
FROM `rabbul_admintools_storage`
1 × SELECT `path`
FROM rabbul_rsfirewall_ignored
1 × SELECT `file`
FROM rabbul_rsfirewall_hashes
1 × SELECT `query`
FROM `rabbul_admintools_wafexceptions`
1 × SELECT folder AS type, element AS name, params
FROM rabbul_extensions
1 × SELECT `session_id`
FROM `rabbul_session`
1 × SELECT b.id
FROM rabbul_usergroups AS a
LEFT JOIN rabbul_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `rabbul_viewlevels
1 × SELECT *
FROM rabbul_rsfirewall_configuratio
1 × SELECT *
FROM rabbul_sef_config
1 × SELECT rules
FROM rabbul_assets
1 × SELECT u.*
FROM rabbul_user_usergroup_map m RIGHT JOIN rabbul_users u
ON (u.id=m.user_id)
1 × SELECT `data`
FROM `rabbul_session`
1 × SELECT parent.id, parent.lft, parent.rgt
FROM rabbul_usergroups AS parent
1 × SELECT `id`
FROM `rabbul_usergroups
1 × SELECT non_sef_url,alias
FROM rabbul_sef_alias
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_id
1 × SELECT *
FROM rabbul_rsfirewall_snapshots
15 × 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:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1741674333;s:18:\"session.timer.last\";i:1741674333;s:17:\"session.timer.now\";i:1741674333;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:20:\"com_rsfirewall.geoip\";s:0:\"\";s:16:\"com_mailto.links\";a:20:{s:40:\"090eb7e6d37b123ca7eff95fceab7fc4e0f3375f\";O:8:\"stdClass\":2:{s:4:\"link\";s:79:\"http://www.seacoastnh.com/portsmouth-aqueduct-company-piped-water-through-logs/\";s:6:\"expiry\";i:1741674333;}s:40:\"9128a0ee355433471bce877308df9ec271d6dab7\";O:8:\"stdClass\":2:{s:4:\"link\";s:59:\"http://www.seacoastnh.com/warner-house-built-300-years-ago/\";s:6:\"expiry\";i:1741674333;}s:40:\"2b6101b7f77c073d4ddcd9ca654e571298f6f38c\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://www.seacoastnh.com/living-with-the-ghost-of-ichabod-goodwin/\";s:6:\"expiry\";i:1741674333;}s:40:\"52cd5b6b7c6bf2004020ce09051858b07b20be81\";O:8:\"stdClass\":2:{s:4:\"link\";s:72:\"http://www.seacoastnh.com/walking-the-historic-streets-of-portsmouth-nh/\";s:6:\"expiry\";i:1741674333;}s:40:\"457852410d147044fdf5f1f8d74d7af80701a5c6\";O:8:\"stdClass\":2:{s:4:\"link\";s:78:\"http://www.seacoastnh.com/the-science-of-the-historic-appledore-island-garden/\";s:6:\"expiry\";i:1741674333;}s:40:\"958e15564a2878588a0681b4d9f3bab77d6c5455\";O:8:\"stdClass\":2:{s:4:\"link\";s:65:\"http://www.seacoastnh.com/a-quick-history-of-gulls-
on-the-shoals/\";s:6:\"expiry\";i:1741674333;}s:40:\"871467c2f59b9bebadbad68b07ee0d14ee0da8b9\";O:8:\"stdClass\":2:{s:4:\"link\";s:84:\"http://www.seacoastnh.com/the-making-of-an-unprecedented-edmund-tarbell-art-exhibit/\";s:6:\"expiry\";i:1741674333;}s:40:\"a7b2d6b19e10bb1b578039485245365bba6d2a93\";O:8:\"stdClass\":2:{s:4:\"link\";s:92:\"http://www.seacoastnh.com/nh-born-publisher-enticed-charles-dickens-back-to-america-in-1867/\";s:6:\"expiry\";i:1741674333;}s:40:\"02f09748c4fbce71e86c452d1244989822bdae80\";O:8:\"stdClass\":2:{s:4:\"link\";s:71:\"http://www.seacoastnh.com/three-lives-of-the-portsmouth-marine-society/\";s:6:\"expiry\";i:1741674333;}s:40:\"322ecc2480151ab25e2ba65f338c73c592e3609a\";O:8:\"stdClass\":2:{s:4:\"link\";s:85:\"http://www.seacoastnh.com/ben-franklin-installed-new-hampshire-lightning-rod-in-1763/\";s:6:\"expiry\";i:1741674333;}s:40:\"a4d82569b0cac5ae04f55b5e42a8620a5553d144\";O:8:\"stdClass\":2:{s:4:\"link\";s:73:\"http://www.seacoastnh.com/kittery-little-red-schoolhouse-
on-life-support/\";s:6:\"expiry\";i:1741674333;}s:40:\"e07ee172e4135ff683ab8d79d79b3b1d2f4515b5\";O:8:\"stdClass\":2:{s:4:\"link\";s:61:\"http://www.seacoastnh.com/the-man-who-dug-up-john-paul-jones/\";s:6:\"expiry\";i:1741674333;}s:40:\"6b41a9b7783fe5be813bdbed66211aa3e7a49bc8\";O:8:\"stdClass\":2:{s:4:\"link\";s:77:\"http://www.seacoastnh.com/miss-nancy-underhill-swept-off-star-island-in-1848/\";s:6:\"expiry\";i:1741674333;}s:40:\"296d013e0b8ca7cf338b68a25bd39fd1a4e9f561\";O:8:\"stdClass\":2:{s:4:\"link\";s:82:\"http://www.seacoastnh.com/us-wwii-ambassador-john-winant-gets-his-memorial-at-las/\";s:6:\"expiry\";i:1741674333;}s:40:\"296f1f783e43b33b4f47146d81420afb1c18c44a\";O:8:\"stdClass\":2:{s:4:\"link\";s:64:\"http://www.seacoastnh.com/the-unexpected-portsmouth-art-gallery/\";s:6:\"expiry\";i:1741674333;}s:40:\"b9255d8b918cfd151f48400b9e544cbc96e7cbef\";O:8:\"stdClass\":2:{s:4:\"link\";s:61:\"http://www.seacoastnh.com/inside-the-wondrous-woodman-museum/\";s:6:\"expiry\";i:1741674333;}s:40:\"aec7fcef9ebfccdad89dde84f6be859b74b48bbc\";O:8:\"stdClass\":2:{s:4:\"link\";s:72:\"http://www.seacoastnh.com/my-favorite-portsmouth-history-books-for-kids/\";s:6:\"expiry\";i:1741674333;}s:40:\"39a07ae374d622c3c0db9857abe9736dcf9e6005\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://www.seacoastnh.com/main-street-south-berwick-over-200-years/\";s:6:\"expiry\";i:1741674333;}s:40:\"b7cb9ccf9c9f7f39ee69bacb116e46e367020ef5\";O:8:\"stdClass\":2:{s:4:\"link\";s:70:\"http://www.seacoastnh.com/lakes-region-legends-celebrated-in-new-book/\";s:6:\"expiry\";i:1741674333;}s:40:\"c2c7ea497ac448265e205958874f8bb929782647\";O:8:\"stdClass\":2:{s:4:\"link\";s:60:\"http://www.seacoastnh.com/the-truth-about-bricks-
and-mortar/\";s:6:\"expiry\";i:1741674333;}}}' , `time` = '1741674334'
1 × SHOW FULL COLUMNS
FROM `rabbul_rsfirewall_logs
1 × INSERT INTO `rabbul_session` (`session_id`, `client_id`, `time`)
VALUES ('b6710739a73c2c8e94a4d6b19031139b', 0, '1741674333'
1 × SHOW FULL COLUMNS
FROM `rabbul_sef_config
1 × SHOW FULL COLUMNS
FROM `rabbul_assets
1 × DELETE
FROM `rabbul_session`