|
FRESH STUFF DAILY
Seacoast New Hampshire
& South Coast Maine
|
|
|
|
|
|
The Blog Ale Tycoon Frank Jones for Sale
|
|
|
SEE ALL SIGNED BOOKS by J. Dennis Robinson click here
|
|
Ale Tycoon Frank Jones for Sale |
Seacoast History Blog #39 March 22, 2009
Mark Chag of the Atlantic News sent me a head’s up that some guy is selling off a Frank Jones collection on eBay. (I assume no woman alive collects paraphernalia from Portsmouth’s 19th century ale tycoon.) Jones was a major player in my book on the Wentworth Hotel and is pretty hard to avoid in any history of this region, since he owned the whole town. One item in the collection, Mark points out, is especially intriguing to those of us who can’t get enough of the powerful Mr. Jones. (Continued below)
There are a number of nice items going on the block – over 100 in all. But based on the photo included, we’ve seen them all before – bottles, tin logo trays, a nice advertising sign, the usual metal pipe holder with the Frank Jones stamp. All of the items in the photo appear on eBay routinely and might be worth a few hundred bucks from what I’ve seen, but never bid on.
READ: Another Frank Jones item saved
The unique item, the one that drew Mark’s attention, is a small hammered metal nameplate. The plate, just a few inches across, has Frank Jones name on it and the address 61 Market Street. So unlike almost all other Frank Jones items, this one relates to the man, not the brewery he named after himself.

If memory serves (and you can look this up in Ray Brighton’s biography) Jones was running a stove shop when he lived on Market Street. This was at the very beginning of his rise from barefoot farmboy from Barrington to robber baron, Portsmouth mayor, congressman, and millionaire.
As I recall, Frank was in partnership with one of his brothers, and in competition with another brother who ran a similar shop across the street. We see instances of Jones entrepreneurial genius earlier when he goes around collecting old rags, stores them in a barn, and sells the lot of them for thousands of dollars. But it is in the stove shop, I believe, that Jones turns from clever to ruthless. Apparently he borrows a few thousand from his brother Hiram and, according to Brighton, never pays it back. Hiram, for reasons unknown, goes into the privy at their Barrington homestead and slits his own throat with a razor. Frank then marries Hiram’s widow.
As with so many Portsmouth stories, this one has TV mini-series written all over it – with one fatal flaw. There is no tragic ending. Frank Jones never gets his comeuppance. He goes on to be a greedy, self-serving, powerful and enormously wealthy tycoon. He apparently gets the power, the girls, the real estate, the racehorses, the mansions, the giant summer hotels – all free and clear.
I don’t know why I suspect that Frankie had something to do with Hiram’s death. We’re way into rumor territory here. Perhaps he was just being a good provider when he married his dead brother’s wife. It happened often back in the day.
Like so many wealthy figures of that era (and now) Frank Jones remains elusive. We have his portraits and a few photographs, but no real sense of the man. We have his gold tipped cane at the Portsmouth Historical Society and other relics. But this little nameplate is a rare item for it’s personal connection to Jones. It shows him announcing his importance if only in a small way. Look out Portsmouth, it seems to say, Frank Jones is coming!
The dealer selling the items is from North Berwick. I wrote to a few history types to see if anyone knows whose collection is going on the block. No one did. The dealer writes: "I am in the process of beginning to sell off one of the most extensive private collections of Frank Jones Brewery memorabilia I have ever seen."
I don’t know if anyone will pay the asking price of $1,200. I can’t, and our impoverished local museums don’t have that kind of cash. So it will likely go to another collector, if it goes at all.
"Makes me sad to see things like this go on the auction block," Mark wrote in his email. "It deserves to be on display at the Historical Society."
I agree. And perhaps that’s why I look at eBay less and less these days. It’s such a shame to see great collections built up, and then broken up and sold off. I’ve got half a dozen small collections going and it never occurs to me to sell these artifacts. I just assume they will be donated to whatever institution wants them. The idea of selling bits of history makes no sense to me. I watch "Antiques Roadshow" for the info, but find the pricing of the items sickening.
But giving artifacts away, especially minor items like this, may be difficult in the future. Small history museums are so strapped for space and funds that they are getting picky about what they can afford to accession. That’s because a free collection is not free. It takes time to conserve and document the stuff, and the archival storage boxes are incredibly expensive. There needs to be space to store and display the artifacts. And building an exhibit is also very costly, as is advertising it, then putting it back into storage – and then maintaining it forever.
Giving away a collection is like giving away a kid. Whoever gets the kid has to love it and support it for life. So museums are beginning to ask donors to also give some money that will support the cost of nurturing the gift.
That’s probably why no one has yet built a good Frank Jones exhibit. It is something we should definitely do since his brewery is among the few things for which this city was renowned. If it is ever going to happen, it will likely come from a collector, or in a perfect world, from the people who earn money brewing and selling beer in the Seacoast today.
So for now, maybe this collector should sell to another collector. Perhaps the next one will have the compassion and the cash to donate it to a public museum. With the economy on the skids, collectors will likely be dumping some great items this year. Perhaps a few will consider a tax deductible gift instead of greenbacks.
© 2009 by J. Dennis Robinson, All rights reserved.
Please visit these SeacoastNH.com ad partners.
News about Portsmouth from Fosters.com
|
|
|
| Tuesday, November 03, 2026 |
|
|
|
Site maintained by ad-cetera graphics
|
Joomla! Debug Console- Error loading feed data
| 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.3.184.74
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 ⇒
Application 0.000 seconds (+0.000); 0.33 MB (+0.330) - afterLoad
Application 0.015 seconds (+0.015); 3.22 MB (+2.894) - afterInitialise
Application 0.047 seconds (+0.032); 5.03 MB (+1.804) - afterRoute
Application 0.057 seconds (+0.010); 6.14 MB (+1.116) - afterDispatch
Application 0.059 seconds (+0.001); 6.33 MB (+0.188) - beforeRenderModule mod_custom (Footer)
Application 0.059 seconds (+0.001); 6.34 MB (+0.010) - afterRenderModule mod_custom (Footer)
Application 0.059 seconds (+0.000); 6.34 MB (-0.000) - beforeRenderModule mod_banners (Uncle Oscar)
Application 0.062 seconds (+0.002); 6.47 MB (+0.126) - afterRenderModule mod_banners (Uncle Oscar)
Application 0.062 seconds (+0.000); 6.48 MB (+0.016) - beforeRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)
Application 0.063 seconds (+0.001); 6.61 MB (+0.123) - afterRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)
Application 0.063 seconds (+0.000); 6.51 MB (-0.098) - beforeRenderModule mod_novarp (ISC/Star)
Application 0.065 seconds (+0.002); 6.61 MB (+0.102) - afterRenderModule mod_novarp (ISC/Star)
Application 0.065 seconds (+0.000); 6.49 MB (-0.121) - beforeRenderModule mod_banners (Music Hall)
Application 0.066 seconds (+0.001); 6.50 MB (+0.014) - afterRenderModule mod_banners (Music Hall)
Application 0.066 seconds (+0.000); 6.49 MB (-0.009) - beforeRenderModule mod_banners (Maren)
Application 0.067 seconds (+0.001); 6.51 MB (+0.014) - afterRenderModule mod_banners (Maren)
Application 0.067 seconds (+0.000); 6.50 MB (-0.009) - beforeRenderModule mod_banners (Smuttynose Murders)
Application 0.069 seconds (+0.001); 6.51 MB (+0.014) - afterRenderModule mod_banners (Smuttynose Murders)
Application 0.069 seconds (+0.000); 6.50 MB (-0.009) - beforeRenderModule mod_banners (Banner Maine Harbors)
Application 0.070 seconds (+0.001); 6.52 MB (+0.013) - afterRenderModule mod_banners (Banner Maine Harbors)
Application 0.070 seconds (+0.000); 6.51 MB (-0.009) - beforeRenderModule mod_banners (Banner Sanctuary Hair)
Application 0.071 seconds (+0.001); 6.52 MB (+0.013) - afterRenderModule mod_banners (Banner Sanctuary Hair)
Application 0.071 seconds (+0.000); 6.51 MB (-0.009) - beforeRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)
Application 0.072 seconds (+0.001); 6.52 MB (+0.011) - afterRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)
Application 0.072 seconds (+0.000); 6.54 MB (+0.021) - beforeRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)
Application 0.073 seconds (+0.001); 6.61 MB (+0.069) - afterRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)
Application 0.073 seconds (+0.000); 6.51 MB (-0.097) - beforeRenderModule mod_banners (Banner sheraton wedding)
Application 0.074 seconds (+0.001); 6.53 MB (+0.013) - afterRenderModule mod_banners (Banner sheraton wedding)
Application 0.074 seconds (+0.000); 6.52 MB (-0.004) - beforeRenderModule mod_banners (Banner Boating)
Application 0.075 seconds (+0.001); 6.53 MB (+0.008) - afterRenderModule mod_banners (Banner Boating)
Application 0.075 seconds (+0.000); 6.53 MB (-0.005) - beforeRenderModule mod_banners (Banner Harbour arts)
Application 0.076 seconds (+0.001); 6.53 MB (+0.008) - afterRenderModule mod_banners (Banner Harbour arts)
Application 0.076 seconds (+0.000); 6.53 MB (-0.007) - beforeRenderModule mod_custom (Google Ads)
Application 0.076 seconds (+0.000); 6.53 MB (+0.004) - afterRenderModule mod_custom (Google Ads)
Application 0.076 seconds (+0.000); 6.53 MB (-0.002) - beforeRenderModule mod_banners (Banner Newmarket heritage)
Application 0.078 seconds (+0.002); 6.54 MB (+0.008) - afterRenderModule mod_banners (Banner Newmarket heritage)
Application 0.078 seconds (+0.000); 6.53 MB (-0.004) - beforeRenderModule mod_banners (Shoals Marine Ad)
Application 0.079 seconds (+0.001); 6.54 MB (+0.011) - afterRenderModule mod_banners (Shoals Marine Ad)
Application 0.079 seconds (+0.000); 6.54 MB (-0.008) - beforeRenderModule mod_feed (News about Portsmouth from Fosters.com)
Application 0.140 seconds (+0.061); 6.96 MB (+0.427) - afterRenderModule mod_feed (News about Portsmouth from Fosters.com)
Application 0.141 seconds (+0.000); 6.96 MB (-0.001) - beforeRenderModule mod_banners (ad bottom right top)
Application 0.143 seconds (+0.003); 6.98 MB (+0.013) - afterRenderModule mod_banners (ad bottom right top)
Application 0.143 seconds (+0.000); 6.97 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right mid)
Application 0.145 seconds (+0.002); 6.98 MB (+0.014) - afterRenderModule mod_banners (ad bottom right mid)
Application 0.145 seconds (+0.000); 6.97 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right bottom)
Application 0.147 seconds (+0.002); 6.99 MB (+0.014) - afterRenderModule mod_banners (ad bottom right bottom)
Application 0.147 seconds (+0.000); 6.98 MB (-0.008) - beforeRenderModule mod_banners (ad bottom mid top)
Application 0.148 seconds (+0.001); 6.99 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid top)
Application 0.148 seconds (+0.000); 6.98 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid mid)
Application 0.149 seconds (+0.001); 7.00 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid mid)
Application 0.149 seconds (+0.000); 6.99 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid bottom)
Application 0.151 seconds (+0.001); 7.00 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid bottom)
Application 0.151 seconds (+0.000); 6.99 MB (-0.008) - beforeRenderModule mod_banners (ad bottom left top)
Application 0.152 seconds (+0.002); 7.01 MB (+0.014) - afterRenderModule mod_banners (ad bottom left top)
Application 0.152 seconds (+0.000); 7.00 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left mid)
Application 0.153 seconds (+0.001); 7.01 MB (+0.013) - afterRenderModule mod_banners (ad bottom left mid)
Application 0.153 seconds (+0.000); 7.00 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left bottom)
Application 0.154 seconds (+0.001); 7.01 MB (+0.011) - afterRenderModule mod_banners (ad bottom left bottom)
Application 0.154 seconds (+0.000); 7.01 MB (-0.006) - beforeRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)
Application 0.155 seconds (+0.000); 7.01 MB (+0.004) - afterRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)
Application 0.155 seconds (+0.000); 7.01 MB (-0.001) - beforeRenderModule mod_finder (smart_search)
Application 0.159 seconds (+0.005); 7.09 MB (+0.081) - afterRenderModule mod_finder (smart_search)
Application 0.159 seconds (+0.000); 7.09 MB (-0.006) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.161 seconds (+0.001); 7.10 MB (+0.014) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.161 seconds (+0.000); 7.09 MB (-0.005) - beforeRenderModule mod_menu (topmenu)
Application 0.161 seconds (+0.001); 7.11 MB (+0.016) - afterRenderModule mod_menu (topmenu)
Application 0.161 seconds (+0.000); 7.11 MB (-0.006) - beforeRenderModule mod_custom (feedback)
Application 0.161 seconds (+0.000); 7.11 MB (+0.004) - afterRenderModule mod_custom (feedback)
Application 0.161 seconds (+0.000); 7.11 MB (-0.003) - beforeRenderModule mod_custom (SeacoastNH Feedback)
Application 0.161 seconds (+0.000); 7.11 MB (+0.004) - afterRenderModule mod_custom (SeacoastNH Feedback)
Application 0.162 seconds (+0.000); 7.11 MB (-0.003) - beforeRenderModule mod_custom (MainHeader)
Application 0.162 seconds (+0.000); 7.11 MB (+0.004) - afterRenderModule mod_custom (MainHeader)
Application 0.162 seconds (+0.000); 7.11 MB (-0.002) - beforeRenderModule mod_custom (Facebook)
Application 0.162 seconds (+0.000); 7.11 MB (+0.004) - afterRenderModule mod_custom (Facebook)
Application 0.162 seconds (+0.000); 7.11 MB (-0.002) - beforeRenderModule mod_menu (Main Menu)
Application 0.166 seconds (+0.004); 7.18 MB (+0.070) - afterRenderModule mod_menu (Main Menu)
Application 0.166 seconds (+0.000); 7.17 MB (-0.007) - beforeRenderModule mod_custom (Donate to Our Site)
Application 0.167 seconds (+0.000); 7.18 MB (+0.004) - afterRenderModule mod_custom (Donate to Our Site)
Application 0.167 seconds (+0.000); 7.18 MB (-0.003) - beforeRenderModule mod_custom (Feedjit)
Application 0.167 seconds (+0.000); 7.18 MB (+0.004) - afterRenderModule mod_custom (Feedjit)
Application 0.167 seconds (+0.000); 7.18 MB (-0.003) - beforeRenderModule mod_custom (facebook lower logo)
Application 0.167 seconds (+0.000); 7.18 MB (+0.004) - afterRenderModule mod_custom (facebook lower logo)
Application 0.167 seconds (+0.000); 7.22 MB (+0.040) - afterRender
7.23 MB (7,576,400 Bytes)
208 Queries LoggedSELECT `data`
FROM `rabbul_session`
WHERE `session_id` = '2541f91aeb9b3d1c48ba6ca28ae0a83a'SELECT `session_id`
FROM `rabbul_session`
WHERE `session_id` = '2541f91aeb9b3d1c48ba6ca28ae0a83a' LIMIT 0, 1INSERT INTO `rabbul_session`
(`session_id`, `client_id`, `time`) VALUES
('2541f91aeb9b3d1c48ba6ca28ae0a83a', 0, '1793690942')SELECT extension_id AS id, element AS "option", params, enabled
FROM rabbul_extensions
WHERE `type` = 'component' AND `element` = 'com_users'SELECT b.id
FROM rabbul_usergroups AS a
LEFT JOIN rabbul_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 1SELECT id, rules
FROM `rabbul_viewlevels`SELECT folder AS type, element AS name, params
FROM rabbul_extensions
WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1)
ORDER BY orderingSELECT extension_id AS id, element AS "option", params, enabled
FROM rabbul_extensions
WHERE `type` = 'component' AND `element` = 'com_languages'SELECT `query`
FROM `rabbul_admintools_wafexceptions`
WHERE (`option` IS NULL OR `option` = '') AND (`view` IS NULL OR `view` = '')
GROUP BY `query`
ORDER BY `query` ASCSELECT `value`
FROM `rabbul_admintools_storage`
WHERE `key` = 'cparams'SELECT `path`
FROM rabbul_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'SELECT `file`
FROM rabbul_rsfirewall_hashes
WHERE `type`='protect'SELECT *
FROM rabbul_rsfirewall_configurationSHOW FULL COLUMNS FROM `rabbul_sef_config`SELECT *
FROM rabbul_sef_config
WHERE `id` = '1'SELECT non_sef_url,alias
FROM rabbul_sef_alias
WHERE published='1'
ORDER BY idSELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM rabbul_menu AS m
LEFT JOIN rabbul_extensions AS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDER BY m.lftSELECT * FROM rabbul_sef_redirect WHERE CONVERT(source USING latin1) COLLATE latin1_general_cs = 'ale-tycoon-frank-jones-for-sale/' AND published='1' LIMIT 1SELECT id FROM rabbul_menu WHERE alias='ale-tycoon-frank-jones-for-sale' AND published=1SELECT id
FROM rabbul_categories
WHERE path='ale-tycoon-frank-jones-for-sale' AND extension='com_content'SELECT id,catid
FROM rabbul_content
WHERE alias='ale-tycoon-frank-jones-for-sale' AND state>0SELECT id,catid
FROM rabbul_content
WHERE alias='ale-tycoon-frank-jones-for-sale' AND state>0SELECT id
FROM rabbul_menu
WHERE type='component' AND published='1' AND link LIKE 'index.php?option=com_content&view=article%&id=2294'
ORDER BY idSELECT id
FROM rabbul_menu
WHERE type='component' AND published='1' AND link LIKE 'index.php?option=com_content&view=categor%&id=258'
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.3.184.74' OR `ip` LIKE '%*%') AND `type`='1' AND `published`='1'SELECT `ip`,`reason`
FROM rabbul_rsfirewall_lists
WHERE (`ip`='10.3.184.74' OR `ip` LIKE '%*%') AND `type`='0' AND `published`='1'SELECT *
FROM rabbul_rsfirewall_exceptions
WHERE `published`='1'SELECT extension_id AS id, element AS "option", params, enabled
FROM rabbul_extensions
WHERE `type` = 'component' AND `element` = 'com_content'SELECT *
FROM rabbul_languages
WHERE published=1
ORDER BY ordering ASCSELECT id, home, template, s.params
FROM rabbul_template_styles as s
LEFT JOIN rabbul_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
WHERE s.client_id = 0 AND e.enabled = 1SELECT a.rules
FROM rabbul_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftSELECT b.rules
FROM rabbul_assets AS a
LEFT JOIN rabbul_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
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
FROM rabbul_content AS a
LEFT JOIN rabbul_categories AS c on c.id = a.catid
LEFT JOIN rabbul_users AS u on u.id = a.created_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 <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE a.id = 2294 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-03 07:29:02') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-03 07:29:02') AND (a.state = 1 OR a.state =2)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=258 AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 2294UPDATE rabbul_content SET hits = hits + 1 WHERE id = 2294SELECT 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-11-03 07:29:02') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-11-03 07:29:02') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 490 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingSELECT *
FROM rabbul_banners
WHERE '2026-11-03 07:29:02' >= `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-11-03 07'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=100 AND track_date='2026-11-03 07'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=100 AND track_date='2026-11-03 07'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-11-03 07:29:02' >= `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-11-03 07:29:02' >= `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-11-03 07'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=87 AND track_date='2026-11-03 07'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=87 AND track_date='2026-11-03 07'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 87SELECT *
FROM rabbul_banners
WHERE '2026-11-03 07:29:02' >= `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-11-03 07'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=84 AND track_date='2026-11-03 07'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=84 AND track_date='2026-11-03 07'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 84SELECT *
FROM rabbul_banners
WHERE '2026-11-03 07:29:02' >= `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-11-03 07:29:02' >= `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-11-03 07:29:02' >= `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-11-03 07:29:02' >= `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-11-03 07:29:02' >= `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-11-03 07:29:02' >= `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-11-03 07:29:02' >= `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-11-03 07:29:02' >= `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-11-03 07'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=95 AND track_date='2026-11-03 07'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=95 AND track_date='2026-11-03 07'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 95SELECT *
FROM rabbul_banners
WHERE '2026-11-03 07:29:02' >= `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-11-03 07:29:02' >= `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-11-03 07'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=30 AND track_date='2026-11-03 07'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=30 AND track_date='2026-11-03 07'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 30SELECT *
FROM rabbul_banners
WHERE '2026-11-03 07:29:02' >= `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-11-03 07'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=31 AND track_date='2026-11-03 07'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=31 AND track_date='2026-11-03 07'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 31SELECT *
FROM rabbul_banners
WHERE '2026-11-03 07:29:02' >= `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-11-03 07:29:02' >= `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-11-03 07:29:02' >= `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-11-03 07:29:02' >= `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-11-03 07'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=23 AND track_date='2026-11-03 07'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=23 AND track_date='2026-11-03 07'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 23SELECT *
FROM rabbul_banners
WHERE '2026-11-03 07:29:02' >= `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-11-03 07:29:02' >= `reset` AND `reset` != '0000-00-00 00:00:00' AND `reset`!=NULL AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat ON a.catid = cat.id
WHERE a.state=1 AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') AND (a.imptotal = 0 OR a.impmade <= a.imptotal) AND a.cid = 43 AND cl.state = 1 AND a.catid IN (278)
ORDER BY a.sticky DESC,RAND()SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM rabbul_banners as a
LEFT JOIN rabbul_banner_clients AS cl ON cl.id = a.cid
LEFT JOIN rabbul_categories as cat ON a.catid = cat.id
WHERE a.state=1 AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') AND (a.imptotal = 0 OR a.impmade <= a.imptotal) AND a.cid = 43 AND cl.state = 1 AND a.catid IN (278)
ORDER BY a.sticky DESC,RAND() LIMIT 0, 5SELECT extension_id AS id, element AS "option", params, enabled
FROM rabbul_extensions
WHERE `type` = 'component' AND `element` = 'com_finder'SELECT name
FROM `rabbul_extensions`
WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1SELECT `title`
FROM `rabbul_finder_taxonomy`
WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,1)SELECT link
FROM rabbul_menu
WHERE id=490SELECT path
FROM rabbul_categories
WHERE id = 258SELECT 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:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1793690942;s:18:\"session.timer.last\";i:1793690942;s:17:\"session.timer.now\";i:1793690942;s:24:\"session.client.forwarded\";s:11:\"10.3.184.74\";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:\"\";}'
, `time` = '1793690942'
WHERE `session_id` = '2541f91aeb9b3d1c48ba6ca28ae0a83a'
54 Query Types Logged, Sorted by Occurrences.SELECT Tables: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 b15 × SELECT id FROM rabbul_assets14 × SELECT `count` FROM rabbul_banner_tracks11 × SELECT link FROM rabbul_menu7 × SELECT path FROM rabbul_categories4 × SELECT extension_id AS id, element AS "option", params, enabled FROM rabbul_extensions3 × SELECT id FROM rabbul_menu3 × SELECT * FROM rabbul_banners3 × SELECT a.alias AS article FROM rabbul_content AS a2 × SELECT b.rules FROM rabbul_assets AS a LEFT JOIN rabbul_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt2 × SELECT id,catid FROM rabbul_content2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROM rabbul_banners as a LEFT JOIN rabbul_banner_clients AS cl ON cl.id = a.cid2 × SELECT `ip`,`reason` FROM rabbul_rsfirewall_lists1 × SELECT * FROM rabbul_languages1 × SELECT * FROM rabbul_rsfirewall_exceptions1 × 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 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 name FROM `rabbul_extensions`1 × SELECT `title` FROM `rabbul_finder_taxonomy`1 × SELECT * FROM rabbul_rsfirewall_snapshots1 × 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 a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id FROM rabbul_contact_details AS contact1 × SELECT a.rules FROM rabbul_assets AS a1 × SELECT rules FROM rabbul_assets1 × SELECT `value` FROM `rabbul_admintools_storage`1 × SELECT `path` FROM rabbul_rsfirewall_ignored1 × SELECT `file` FROM rabbul_rsfirewall_hashes1 × SELECT `query` FROM `rabbul_admintools_wafexceptions`1 × SELECT folder AS type, element AS name, params FROM rabbul_extensions1 × SELECT `session_id` FROM `rabbul_session`1 × SELECT b.id FROM rabbul_usergroups AS a LEFT JOIN rabbul_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt1 × SELECT id, rules FROM `rabbul_viewlevels1 × SELECT * FROM rabbul_rsfirewall_configuratio1 × SELECT * FROM rabbul_sef_config1 × SELECT parent.id, parent.lft, parent.rgt FROM rabbul_usergroups AS parent1 × SELECT `data` FROM `rabbul_session`1 × SELECT u.* FROM rabbul_user_usergroup_map m RIGHT JOIN rabbul_users u ON (u.id=m.user_id)1 × SELECT `id` FROM `rabbul_usergroups1 × SELECT id FROM rabbul_categories1 × SELECT non_sef_url,alias FROM rabbul_sef_alias1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM rabbul_menu AS m LEFT JOIN rabbul_extensions AS e ON m.component_id = e.extension_id1 × SELECT * FROM rabbul_sef_redirect1 × SELECT * FROM rabbul_rsfirewall_hashes
OTHER Tables: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:1793690942;s:18:\"session.timer.last\";i:1793690942;s:17:\"session.timer.now\";i:1793690942;s:24:\"session.client.forwarded\";s:11:\"10.3.184.74\";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:\"\";}' , `time` = '1793690942'1 × UPDATE rabbul_content SET hits = hits + 11 × SHOW FULL COLUMNS FROM `rabbul_sef_config1 × SHOW FULL COLUMNS FROM `rabbul_assets1 × SHOW FULL COLUMNS FROM `rabbul_rsfirewall_logs1 × INSERT INTO `rabbul_session` (`session_id`, `client_id`, `time`) VALUES ('2541f91aeb9b3d1c48ba6ca28ae0a83a', 0, '1793690942'
|