|
FRESH STUFF DAILY
Seacoast New Hampshire
& South Coast Maine
|
|
|
|
|
|
The Blog Local Daily Wants You to Pay for News Online
|
|
|
SEE ALL SIGNED BOOKS by J. Dennis Robinson click here
|
|
Local Daily Wants You to Pay for News Online |
Seacoast History Blog #99 November 7, 2010
As the guy with one of the “alternative” Portsmouth Web sites, I’ve been getting an earful from people about the Portsmouth Herald’s decision to begin charging for access to their Web site this month. There’s no real comparison. My site is run by a staff of one and posts a single article per day. The Herald is the local newspaper of record, a multi-million dollar operation with dozens of employees, and a spanking new facility out at Pease Tradeport. The only connections are that we both focus on this region, we’ve both been online for about 15 years, and until now, our Web sites have both been free. I write a history column for the Herald, but I hope that doesn’t color my opinion. And my opinion is this – I think it’s about time they started charging a fee. So raise the flag and fire off the cannon, because for once, Rupert Murdoch and I agree on something. (Continued below)
(NOTE: After ir appeared here, the Seacoast Media Group, owners of the Portsmouth Herald, asked permission to run the following commentary on the front page of their Sunday newspaper. Permission was granted, and it also aooears on their Web site that has now moved to a paywall format.)
I burned up considerable calories discussing this topic this week. It is a big deal. As we all know, most newspapers give away their paper content online and it’s killing them. As paper subscribers decline and costs rise, these companies are being forced to give away their content. Forced by whom? Forced by the sudden and powerful conventions of the evolving Internet media where a new generation of consumers wants everything free, fast, and perfect. I fell into this trap in 1996 and have been trying to dig myself out of it ever since. Before the dot-com bubble burst, we all thought advertisers were going to rush to the Internet. They did, but they built their own Web sites. Unless you have millions of visitors a day, it’s hard to make money online. Even YouTube is still trying to figure it out.
I got in for a penny, posting a little bit a day with a few loyal sponsors for a few thousand daily readers. The Herald was in for a pound, or a ton, with tens of thousands of page views. The paper supported the Web site, at first, which was simply another way of disseminating the news. Then along came the Internet generation, laptops, hand held wireless devices, ebooks, iPhones – you know the song. And with that came the decline in newspaper subscribers, reductions in journalists and support staff, and the rise of cable media, blogs, alternative news outlets, and on and on. A few tough publications like the Wall Street Journal managed to charge for their online content. Others, like the Christian Science Monitor, folded up their paper editions and went strictly digital.
The rest of us continued to give it away. I stayed alive by staying small and focused. The newspaper built a bigger and bigger online site and searched for ways to “monetize” the increasing flow of content. The bigger and better the content got, the more people started turning to it daily. Now Seacoast Media Group wants to charge a modest fee (about $60 a year, compared to nearly $200 for the paper version) for its online content. That seems immensely fair to me – a little more than a dollar a week for roughly the same content delivered to wherever in the world you want to read it, without the paper.
From the comments I’ve been getting, the reaction seems to be split 50-50. But the reaction is strong. People either like the idea or hate it. I’ve spoken to those who believe they have some sort of constitutional right to get free news. Those people need to wake up and smell the printer’s ink. Sure there have been free weeklies around here for decades. I used to write for the Rockingham Gazette, Portsmouth Magazine (the newspaper), the NH Gazette, and more. The Wire is great. We have a healthy cluster of glossy specialized publications. But these publications do not have the staff or the content to cover daily news 365-days a year. These are supplemental publications. They exist because the daily paper is there – there to expand on, criticize, and feed off. We, and I include myself, are the sucker fish, the remora of the media, and we owe our niche markets to the big fish. Real newspapers – the kind with news – haven’t been free in these parts since Daniel Fowle moved his printing press to Portsmouth in 1756.
Continue PORTSMOUTH HERALD MOVES TO PAY WEB SITE
SeacoastOnline.com Moves to Pay Model (Continued)
On the other side of the coin are the rational types who understand that newspapers are a business. Reporters like to eat too. They want to raise babies and drive cars and live in houses. It isn’t easy. Journalism jobs pay poorly. The rate for freelancers hasn’t gone up since I started in this business in the 1970s. Name me another career (besides being a musician) that has not gone up a nickel in 30-40 years. And worse, newspapers are still tossing out sandbags and cutting off staff in an effort to stay profitable, even as we, the free niche media, eat their lunch.
So half of the critics I know agree that it’s about time that the local daily started charging for its online edition. Maybe it will get better, hire more reporters, do more investigative journalism – okay, let’s not get carried away. But maybe they will stay alive and keep reporting the news.
I am absolutely fascinated to see what will happen. My guess is that most people who get the paper-paper will continue to do so. They will curse and complain, but they are hooked on the daily news and the likeable new layout. They are a dying breed, however. Older people tend to want paper. Younger readers are happy with the online site. My guess is that they will balk. The responsible ones will step-up and pay the online fee – those who run businesses, or have civic pride, or are raising kids. Some younger readers may be okay with the online payment system that allows them to pay painlessly online, but the “everything online should be free” crowd are the dangerous ones here. If they don’t opt-in, then online viewership will drop and advertising will suffer. The one good thing about free sites is that they generate millions of page views, and that pleases advertisers who are willing to pay particles of a penny for each viewing of their online ads.
The important people are the many out-of-towners who have an affiliation with Portsmouth or a love and want to check in regularly. All those people I’ve spoken to mention the obituaries. They check almost daily, they say, to see who’s newly dead. This implies an older audience, and oldsters are the ones most likely to pay a few bucks to keep in touch. By charging for its online content, SMG will shake out those who really care about the Seacoast from the merely curious. This will be the ultimate test. Who will ante up, support their city newspaper, and stay connected? Who will gripe and grumble and slink around online for alternative information?
I don’t know. I can’t wait to see. My guess is that there are a thousand, maybe a few thousand readers willing to pay the piper. I’m not privy to the stats. I don’t get invited to editorial pow-wows, but I assume that if the print circulation holds steady, and the online advertising does too, then a few thousand paying Internet readers will plug the leaking newspaper industry for a few years to come. By then it will be a brave new world. At worst, the pay site will discourage existing subscribers from jumping ship in a tight economy. Those who want to stay informed, will stay because there really is no option. The Boston media doesn’t do our region justice, nor does our statewide media.
Most Web sites get the lion’s share of their visitors, not from regular subscribers, but from Internet searches. At least that’s true for me. People searching for specific topics on Google particularly will still be able to see a few pages of the Portsmouth Herald. It’s only when they hit four pages that they will be told that this is a subscription site and the rest of the content will be blocked. At that point, as I understand it, they can register and see up to 10 pages a month. This feature may force the obituary/headline freaks to check in weekly instead of daily, but that can’t be a very satisfying experience. At any moment the freebie-reader may get shut off like a drunk at a bar. And that’s the whole point, Just as you start getting happy, you’re cut out – or you break down and buy an online subscription – first a single week, then more and more. I don’t know if that model will work, but it’s worth a try.
This will play havoc with those of us who routinely refer readers to the SMG Web site. In my case, for example, I post about 20 links per day that connect my readers to the daily news. That won’t work with a pay site.
The big flaw in the new pay model is the current plan to charge existing paper subscribers a surcharge to get full access as an online user. That is a mistake, and 100% of the people I talked to said the same. I say that as a paper subscriber who also uses the Web version SeacoastOnline.com. Sometimes my wife takes the paper to work before I get up. Sometimes I forget to take it off the front steps. Sometimes I’m in one place and my paper is in another, or I want to send a copy of an article to my friends and family. Or I want to look for breaking news (which will be a great bonus for online subscribers) or I want to check a fact from an archived article. Paper subscribers will expect to get more for their higher rate, not less. But I assume that bug will shake itself out in time.
We live in an era of crabby people who get more and more and appreciate it less and less. Almost everything, from my view, is better than it used to be – healthcare, cars, safety, security, technology, TV, food – you name it, I like it. But as Lincoln almost said, you can’t please most of the people most of the time.
If most of the people want free news, then they will get what they pay for. And yes TMZ, I’m talking about you.
Copyright © 2010 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.1.7.109
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.332) - afterLoad
Application 0.014 seconds (+0.014); 3.23 MB (+2.895) - afterInitialise
Application 0.046 seconds (+0.032); 5.03 MB (+1.804) - afterRoute
Application 0.056 seconds (+0.010); 6.18 MB (+1.149) - afterDispatch
Application 0.058 seconds (+0.001); 6.36 MB (+0.185) - beforeRenderModule mod_custom (Footer)
Application 0.058 seconds (+0.001); 6.37 MB (+0.010) - afterRenderModule mod_custom (Footer)
Application 0.058 seconds (+0.000); 6.37 MB (-0.000) - beforeRenderModule mod_banners (Uncle Oscar)
Application 0.060 seconds (+0.002); 6.50 MB (+0.126) - afterRenderModule mod_banners (Uncle Oscar)
Application 0.060 seconds (+0.000); 6.51 MB (+0.016) - beforeRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)
Application 0.062 seconds (+0.001); 6.64 MB (+0.123) - afterRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)
Application 0.062 seconds (+0.000); 6.54 MB (-0.098) - beforeRenderModule mod_novarp (ISC/Star)
Application 0.063 seconds (+0.001); 6.64 MB (+0.102) - afterRenderModule mod_novarp (ISC/Star)
Application 0.063 seconds (+0.000); 6.52 MB (-0.121) - beforeRenderModule mod_banners (Music Hall)
Application 0.064 seconds (+0.001); 6.53 MB (+0.013) - afterRenderModule mod_banners (Music Hall)
Application 0.064 seconds (+0.000); 6.52 MB (-0.009) - beforeRenderModule mod_banners (Maren)
Application 0.065 seconds (+0.001); 6.54 MB (+0.014) - afterRenderModule mod_banners (Maren)
Application 0.065 seconds (+0.000); 6.53 MB (-0.009) - beforeRenderModule mod_banners (Smuttynose Murders)
Application 0.066 seconds (+0.001); 6.54 MB (+0.014) - afterRenderModule mod_banners (Smuttynose Murders)
Application 0.066 seconds (+0.000); 6.53 MB (-0.009) - beforeRenderModule mod_banners (Banner Maine Harbors)
Application 0.067 seconds (+0.001); 6.55 MB (+0.013) - afterRenderModule mod_banners (Banner Maine Harbors)
Application 0.067 seconds (+0.000); 6.54 MB (-0.009) - beforeRenderModule mod_banners (Banner Sanctuary Hair)
Application 0.067 seconds (+0.001); 6.55 MB (+0.013) - afterRenderModule mod_banners (Banner Sanctuary Hair)
Application 0.067 seconds (+0.000); 6.54 MB (-0.009) - beforeRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)
Application 0.068 seconds (+0.001); 6.55 MB (+0.011) - afterRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)
Application 0.068 seconds (+0.000); 6.57 MB (+0.020) - beforeRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)
Application 0.069 seconds (+0.001); 6.64 MB (+0.069) - afterRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)
Application 0.069 seconds (+0.000); 6.55 MB (-0.097) - beforeRenderModule mod_banners (Banner sheraton wedding)
Application 0.069 seconds (+0.001); 6.56 MB (+0.013) - afterRenderModule mod_banners (Banner sheraton wedding)
Application 0.069 seconds (+0.000); 6.55 MB (-0.004) - beforeRenderModule mod_banners (Banner Boating)
Application 0.070 seconds (+0.000); 6.56 MB (+0.008) - afterRenderModule mod_banners (Banner Boating)
Application 0.070 seconds (+0.000); 6.56 MB (-0.005) - beforeRenderModule mod_banners (Banner Harbour arts)
Application 0.070 seconds (+0.000); 6.57 MB (+0.008) - afterRenderModule mod_banners (Banner Harbour arts)
Application 0.070 seconds (+0.000); 6.56 MB (-0.007) - beforeRenderModule mod_custom (Google Ads)
Application 0.070 seconds (+0.000); 6.56 MB (+0.004) - afterRenderModule mod_custom (Google Ads)
Application 0.070 seconds (+0.000); 6.56 MB (-0.002) - beforeRenderModule mod_banners (Banner Newmarket heritage)
Application 0.071 seconds (+0.000); 6.57 MB (+0.008) - afterRenderModule mod_banners (Banner Newmarket heritage)
Application 0.071 seconds (+0.000); 6.56 MB (-0.004) - beforeRenderModule mod_banners (Shoals Marine Ad)
Application 0.072 seconds (+0.001); 6.58 MB (+0.011) - afterRenderModule mod_banners (Shoals Marine Ad)
Application 0.072 seconds (+0.000); 6.57 MB (-0.008) - beforeRenderModule mod_feed (News about Portsmouth from Fosters.com)
Application 0.177 seconds (+0.106); 7.00 MB (+0.427) - afterRenderModule mod_feed (News about Portsmouth from Fosters.com)
Application 0.178 seconds (+0.000); 6.99 MB (-0.001) - beforeRenderModule mod_banners (ad bottom right top)
Application 0.180 seconds (+0.002); 7.01 MB (+0.013) - afterRenderModule mod_banners (ad bottom right top)
Application 0.180 seconds (+0.000); 7.00 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right mid)
Application 0.181 seconds (+0.001); 7.01 MB (+0.014) - afterRenderModule mod_banners (ad bottom right mid)
Application 0.181 seconds (+0.000); 7.00 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right bottom)
Application 0.182 seconds (+0.001); 7.02 MB (+0.014) - afterRenderModule mod_banners (ad bottom right bottom)
Application 0.182 seconds (+0.000); 7.01 MB (-0.008) - beforeRenderModule mod_banners (ad bottom mid top)
Application 0.183 seconds (+0.001); 7.02 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid top)
Application 0.183 seconds (+0.000); 7.01 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid mid)
Application 0.184 seconds (+0.001); 7.03 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid mid)
Application 0.184 seconds (+0.000); 7.02 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid bottom)
Application 0.185 seconds (+0.001); 7.03 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid bottom)
Application 0.185 seconds (+0.000); 7.02 MB (-0.008) - beforeRenderModule mod_banners (ad bottom left top)
Application 0.186 seconds (+0.001); 7.04 MB (+0.014) - afterRenderModule mod_banners (ad bottom left top)
Application 0.186 seconds (+0.000); 7.03 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left mid)
Application 0.186 seconds (+0.001); 7.04 MB (+0.013) - afterRenderModule mod_banners (ad bottom left mid)
Application 0.187 seconds (+0.000); 7.03 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left bottom)
Application 0.187 seconds (+0.000); 7.04 MB (+0.011) - afterRenderModule mod_banners (ad bottom left bottom)
Application 0.187 seconds (+0.000); 7.04 MB (-0.006) - beforeRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)
Application 0.187 seconds (+0.000); 7.04 MB (+0.004) - afterRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)
Application 0.187 seconds (+0.000); 7.04 MB (-0.001) - beforeRenderModule mod_finder (smart_search)
Application 0.191 seconds (+0.004); 7.12 MB (+0.081) - afterRenderModule mod_finder (smart_search)
Application 0.191 seconds (+0.000); 7.12 MB (-0.006) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.192 seconds (+0.001); 7.13 MB (+0.014) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.192 seconds (+0.000); 7.13 MB (-0.005) - beforeRenderModule mod_menu (topmenu)
Application 0.192 seconds (+0.000); 7.14 MB (+0.016) - afterRenderModule mod_menu (topmenu)
Application 0.192 seconds (+0.000); 7.14 MB (-0.006) - beforeRenderModule mod_custom (feedback)
Application 0.192 seconds (+0.000); 7.14 MB (+0.004) - afterRenderModule mod_custom (feedback)
Application 0.192 seconds (+0.000); 7.14 MB (-0.003) - beforeRenderModule mod_custom (SeacoastNH Feedback)
Application 0.192 seconds (+0.000); 7.14 MB (+0.004) - afterRenderModule mod_custom (SeacoastNH Feedback)
Application 0.193 seconds (+0.000); 7.14 MB (-0.003) - beforeRenderModule mod_custom (MainHeader)
Application 0.193 seconds (+0.000); 7.14 MB (+0.004) - afterRenderModule mod_custom (MainHeader)
Application 0.193 seconds (+0.000); 7.14 MB (-0.002) - beforeRenderModule mod_custom (Facebook)
Application 0.193 seconds (+0.000); 7.15 MB (+0.004) - afterRenderModule mod_custom (Facebook)
Application 0.193 seconds (+0.000); 7.14 MB (-0.002) - beforeRenderModule mod_menu (Main Menu)
Application 0.197 seconds (+0.004); 7.21 MB (+0.070) - afterRenderModule mod_menu (Main Menu)
Application 0.197 seconds (+0.000); 7.21 MB (-0.007) - beforeRenderModule mod_custom (Donate to Our Site)
Application 0.197 seconds (+0.000); 7.21 MB (+0.004) - afterRenderModule mod_custom (Donate to Our Site)
Application 0.197 seconds (+0.000); 7.21 MB (-0.003) - beforeRenderModule mod_custom (Feedjit)
Application 0.197 seconds (+0.000); 7.21 MB (+0.004) - afterRenderModule mod_custom (Feedjit)
Application 0.197 seconds (+0.000); 7.21 MB (-0.003) - beforeRenderModule mod_custom (facebook lower logo)
Application 0.198 seconds (+0.000); 7.21 MB (+0.004) - afterRenderModule mod_custom (facebook lower logo)
Application 0.198 seconds (+0.000); 7.26 MB (+0.045) - afterRender
7.26 MB (7,615,480 Bytes)
212 Queries LoggedSELECT `data`
FROM `rabbul_session`
WHERE `session_id` = 'ff5fc32eb105e990f9a9db0ef15bbd1a'DELETE
FROM `rabbul_session`
WHERE `time` < '1793748369'SELECT `session_id`
FROM `rabbul_session`
WHERE `session_id` = 'ff5fc32eb105e990f9a9db0ef15bbd1a' LIMIT 0, 1INSERT INTO `rabbul_session`
(`session_id`, `client_id`, `time`) VALUES
('ff5fc32eb105e990f9a9db0ef15bbd1a', 0, '1793749269')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 = 'local-daily-wants-you-to-pay-for-news-online/?showall=1' AND published='1' LIMIT 1SELECT id FROM rabbul_menu WHERE alias='local-daily-wants-you-to-pay-for-news-online' AND published=1SELECT id
FROM rabbul_categories
WHERE path='local-daily-wants-you-to-pay-for-news-online' AND extension='com_content'SELECT id,catid
FROM rabbul_content
WHERE alias='local-daily-wants-you-to-pay-for-news-online' AND state>0SELECT id,catid
FROM rabbul_content
WHERE alias='local-daily-wants-you-to-pay-for-news-online' AND state>0SELECT id
FROM rabbul_menu
WHERE type='component' AND published='1' AND link LIKE 'index.php?option=com_content&view=article%&id=2866'
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.1.7.109' OR `ip` LIKE '%*%') AND `type`='1' AND `published`='1'SELECT `ip`,`reason`
FROM rabbul_rsfirewall_lists
WHERE (`ip`='10.1.7.109' 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 = 2866 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-03 23:41:09') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-03 23:41:09') 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 = 2866SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 2866SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 2866SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 2866UPDATE rabbul_content SET hits = hits + 1 WHERE id = 2866SELECT 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 23:41:09') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-11-03 23:41:09') 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 23:41:09' >= `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 23'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=100 AND track_date='2026-11-03 23'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=100 AND track_date='2026-11-03 23'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 23:41:09' >= `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 23:41:09' >= `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 23'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=87 AND track_date='2026-11-03 23'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=87 AND track_date='2026-11-03 23'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 87SELECT *
FROM rabbul_banners
WHERE '2026-11-03 23:41:09' >= `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 23'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=84 AND track_date='2026-11-03 23'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=84 AND track_date='2026-11-03 23'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 84SELECT *
FROM rabbul_banners
WHERE '2026-11-03 23:41:09' >= `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 23:41:09' >= `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 23:41:09' >= `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 23:41:09' >= `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 23:41:09' >= `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 23:41:09' >= `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 23:41:09' >= `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 23:41:09' >= `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 23'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=95 AND track_date='2026-11-03 23'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=95 AND track_date='2026-11-03 23'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 95SELECT *
FROM rabbul_banners
WHERE '2026-11-03 23:41:09' >= `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 23:41:09' >= `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 23'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=30 AND track_date='2026-11-03 23'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=30 AND track_date='2026-11-03 23'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 30SELECT *
FROM rabbul_banners
WHERE '2026-11-03 23:41:09' >= `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 23'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=31 AND track_date='2026-11-03 23'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=31 AND track_date='2026-11-03 23'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 31SELECT *
FROM rabbul_banners
WHERE '2026-11-03 23:41:09' >= `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 23:41:09' >= `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 23:41:09' >= `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 23:41:09' >= `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 23'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=23 AND track_date='2026-11-03 23'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=23 AND track_date='2026-11-03 23'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 23SELECT *
FROM rabbul_banners
WHERE '2026-11-03 23:41:09' >= `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 23:41:09' >= `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:1793749269;s:18:\"session.timer.last\";i:1793749269;s:17:\"session.timer.now\";i:1793749269;s:24:\"session.client.forwarded\";s:10:\"10.1.7.109\";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` = '1793749269'
WHERE `session_id` = 'ff5fc32eb105e990f9a9db0ef15bbd1a'
55 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_categories6 × SELECT a.alias AS article FROM rabbul_content AS a4 × SELECT extension_id AS id, element AS "option", params, enabled FROM rabbul_extensions3 × SELECT id FROM rabbul_menu3 × SELECT * FROM rabbul_banners2 × 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 `ip`,`reason` FROM rabbul_rsfirewall_lists2 × 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 id,catid FROM rabbul_content1 × SELECT * FROM rabbul_rsfirewall_exceptions1 × SELECT * FROM rabbul_languages1 × SELECT id, home, template, s.params FROM rabbul_template_styles as s LEFT JOIN rabbul_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id1 × SELECT 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:1793749269;s:18:\"session.timer.last\";i:1793749269;s:17:\"session.timer.now\";i:1793749269;s:24:\"session.client.forwarded\";s:10:\"10.1.7.109\";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` = '1793749269'1 × UPDATE rabbul_content SET hits = hits + 11 × SHOW FULL COLUMNS FROM `rabbul_rsfirewall_logs1 × INSERT INTO `rabbul_session` (`session_id`, `client_id`, `time`) VALUES ('ff5fc32eb105e990f9a9db0ef15bbd1a', 0, '1793749269'1 × SHOW FULL COLUMNS FROM `rabbul_sef_config1 × SHOW FULL COLUMNS FROM `rabbul_assets1 × DELETE FROM `rabbul_session`
|