|
FRESH STUFF DAILY
Seacoast New Hampshire
& South Coast Maine
|
|
|
|
|
|
The Blog My List of Books about Portsmouth, NH
|
|
|
SEE ALL SIGNED BOOKS by J. Dennis Robinson click here
|
|
My List of Books about Portsmouth, NH |
Seacoast History Blog # 127 October 2, 2011
I finally did it. I sat down and put together a list of books about Portsmouth, New Hampshire. Mostly they are ones off my shelf, mostly history. Made myself stop at 150 title, but I hope to keep adding them. The super amazing part of all this is that you can see my list in seconds. I created it on WorldCat.org, the incredible database of every official book (those with ISBN numbers registered with the Library of Congress). I can update the list in seconds. You can search it, even print it in a variety of bibliographical styles on your printer. Now let me tell you why. (Continued below)
My wife Maryellen runs the Discover Portsmouth Center (DPC), a free welcome center and exhibit space situated in what was the Portsmouth Library at 10 Middle Street. The brick building dates to 1810. It’s two buildings, really, joined by a 20th century section, and one of the most interesting spaces in town. The DPC has one nice shelf of new books about Portsmouth including three or four of my own. When I moved to town in the 1970s there were half a dozen downtown book stores – including Bob’s, the Little Professor including, the used books shops at end of State Street. Now there’s one. Riverrun is great, but it can’t carry everything. Strawbery Banke has a nice shelf of local books as does the Tugboat Shop. Barnes & Noble is way over in the mall.
My favorite downtown activity used to be perusing the “Local Titles” section of the old shops. That’s really where I started this career -- sitting on a stool in a back room pouring over local history and lore, although I rarely had the cash to afford the costly vintage books.

So I got thinking – why not add a Vintage Books shelf to the Discover Center? And suddenly I’m on a volunteer committee of one to do just that. Since this is currently a Portsmouth orientation center, I want to stick to Portsmouth-area books, which includes at least New Castle, Kittery, and the Isles of Shoals. Since I have a budget of zero (this being a nonprofit agency) my goal is to get people to donate vintage books from the area. I easily found a dozen on my shelf that are duplicates I don’t need. (I have 34 different editions of Aldrich’s “Story of a Bad Boy” but I’m hanging on to those.) I figure history buffs like me will have half a dozen each. I’d like at least 100 volumes to get the store up and running.
But where to start? I turned to Worldcat.org because the site allows users to build their own LISTS from the zillions of books in the database. Bibliographies can take a long time to assemble, but here the details (author, title, publisher, date) are already available in an authoritative master list. It took only a single afternoon to click off 150 titles. I started mostly with books about Portsmouth, but included a few fiction books by local authors too. There’s no limit to the topics – travel, poetry, UFOs, etc – as long as the book contains material on Portsmouth.
SEE MY PORTSMOUTH BOOK LIST HERE
Since we only want books related to this area, WorldCat allowed me to create a master list of the books we are looking to put in the vintage store. And at the same time, it allows me to create a neat resource for you or anyone searching for Portsmouth books. I posted the list for public use (and have a few more lists I’m working on behind the scenes.) You can view it alphabetically by author or title or by publication date. You can see which books have been added recently. If you own the book that is missing a cover photo, you can scan your copy and add the image to the file. You can even add your own book reviews to the site.
There’s more. I hope to add metatags so you can find groups of related books (eg. fiction, or books about boats, or the 17th century) more easily in the future. And I can add NOTES to tell you why I picked a particular book for my list. And Worldcat allows you to search for a library near you that may carry any book you select. How awesome is that?
And you can even send me an email to suggest books I have missed.
But best of all – you can send or bring copies you no longer need to the DPC so they can sell them and pay the bills. The organization needs to locate $3 million to keep the lights on in the next few years. This fall and winter, through grants, loans, generous gifts, and donations from visitors – the DPC plans to do $800,000 worth of renovations to the antiquated HVAC system in the building – a building owned by the City of Portsmouth and managed by the Portsmouth Historical Society.
I have no plans, currently, to sell vintage books on commission. For the moment, it’s too much hassle. The best way to make money, it appears, is to take items generously donated and to sell them. If people donate and people buy, these wonderful books about my favorite town will change hands – and support the DPC.
It’s a work in progress. But you can see the list as it now stands simply by clicking here. I haven’t yet put in books from the Isles of Shoals, or just a few. There are lots of them, including more than a dozen items by Celia Thaxter herself. I have over 50 books about John Paul Jones alone here in my office, so he may need a list of his own. WorldCat includes some articles, and I may add those too, and maybe used DVDs. I’ve got expansive plans if this works. I hope to open the Vintage Bookshelf in May of 2011.
Check it out. Send me your notes and drop off your books. It’s a high tech way of getting used paper books back in the hands of those who love them.
Please visit these SeacoastNH.com ad partners.
News about Portsmouth from Fosters.com
|
|
|
| Monday, November 02, 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.014 seconds (+0.014); 3.22 MB (+2.894) - afterInitialise
Application 0.044 seconds (+0.030); 5.03 MB (+1.804) - afterRoute
Application 0.053 seconds (+0.009); 6.15 MB (+1.117) - afterDispatch
Application 0.054 seconds (+0.001); 6.33 MB (+0.188) - beforeRenderModule mod_custom (Footer)
Application 0.054 seconds (+0.000); 6.34 MB (+0.010) - afterRenderModule mod_custom (Footer)
Application 0.054 seconds (+0.000); 6.34 MB (-0.000) - beforeRenderModule mod_banners (Uncle Oscar)
Application 0.057 seconds (+0.002); 6.47 MB (+0.126) - afterRenderModule mod_banners (Uncle Oscar)
Application 0.057 seconds (+0.000); 6.48 MB (+0.016) - beforeRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)
Application 0.058 seconds (+0.001); 6.61 MB (+0.123) - afterRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)
Application 0.058 seconds (+0.000); 6.51 MB (-0.098) - beforeRenderModule mod_novarp (ISC/Star)
Application 0.059 seconds (+0.001); 6.61 MB (+0.102) - afterRenderModule mod_novarp (ISC/Star)
Application 0.059 seconds (+0.000); 6.49 MB (-0.121) - beforeRenderModule mod_banners (Music Hall)
Application 0.060 seconds (+0.001); 6.50 MB (+0.014) - afterRenderModule mod_banners (Music Hall)
Application 0.060 seconds (+0.000); 6.49 MB (-0.009) - beforeRenderModule mod_banners (Maren)
Application 0.061 seconds (+0.001); 6.51 MB (+0.014) - afterRenderModule mod_banners (Maren)
Application 0.061 seconds (+0.000); 6.50 MB (-0.009) - beforeRenderModule mod_banners (Smuttynose Murders)
Application 0.062 seconds (+0.001); 6.51 MB (+0.014) - afterRenderModule mod_banners (Smuttynose Murders)
Application 0.062 seconds (+0.000); 6.51 MB (-0.009) - beforeRenderModule mod_banners (Banner Maine Harbors)
Application 0.063 seconds (+0.001); 6.52 MB (+0.013) - afterRenderModule mod_banners (Banner Maine Harbors)
Application 0.063 seconds (+0.000); 6.51 MB (-0.009) - beforeRenderModule mod_banners (Banner Sanctuary Hair)
Application 0.063 seconds (+0.001); 6.52 MB (+0.013) - afterRenderModule mod_banners (Banner Sanctuary Hair)
Application 0.063 seconds (+0.000); 6.51 MB (-0.009) - beforeRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)
Application 0.064 seconds (+0.001); 6.52 MB (+0.011) - afterRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)
Application 0.064 seconds (+0.000); 6.54 MB (+0.020) - beforeRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)
Application 0.065 seconds (+0.001); 6.61 MB (+0.069) - afterRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)
Application 0.065 seconds (+0.000); 6.52 MB (-0.097) - beforeRenderModule mod_banners (Banner sheraton wedding)
Application 0.065 seconds (+0.001); 6.53 MB (+0.013) - afterRenderModule mod_banners (Banner sheraton wedding)
Application 0.065 seconds (+0.000); 6.53 MB (-0.004) - beforeRenderModule mod_banners (Banner Boating)
Application 0.066 seconds (+0.001); 6.53 MB (+0.008) - afterRenderModule mod_banners (Banner Boating)
Application 0.066 seconds (+0.000); 6.53 MB (-0.005) - beforeRenderModule mod_banners (Banner Harbour arts)
Application 0.066 seconds (+0.000); 6.54 MB (+0.008) - afterRenderModule mod_banners (Banner Harbour arts)
Application 0.066 seconds (+0.000); 6.53 MB (-0.007) - beforeRenderModule mod_custom (Google Ads)
Application 0.066 seconds (+0.000); 6.53 MB (+0.004) - afterRenderModule mod_custom (Google Ads)
Application 0.066 seconds (+0.000); 6.53 MB (-0.002) - beforeRenderModule mod_banners (Banner Newmarket heritage)
Application 0.067 seconds (+0.000); 6.54 MB (+0.008) - afterRenderModule mod_banners (Banner Newmarket heritage)
Application 0.067 seconds (+0.000); 6.54 MB (-0.004) - beforeRenderModule mod_banners (Shoals Marine Ad)
Application 0.068 seconds (+0.001); 6.55 MB (+0.011) - afterRenderModule mod_banners (Shoals Marine Ad)
Application 0.068 seconds (+0.000); 6.54 MB (-0.008) - beforeRenderModule mod_feed (News about Portsmouth from Fosters.com)
Application 0.158 seconds (+0.091); 6.97 MB (+0.427) - afterRenderModule mod_feed (News about Portsmouth from Fosters.com)
Application 0.159 seconds (+0.000); 6.97 MB (-0.001) - beforeRenderModule mod_banners (ad bottom right top)
Application 0.160 seconds (+0.002); 6.98 MB (+0.013) - afterRenderModule mod_banners (ad bottom right top)
Application 0.160 seconds (+0.000); 6.97 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right mid)
Application 0.162 seconds (+0.001); 6.98 MB (+0.014) - afterRenderModule mod_banners (ad bottom right mid)
Application 0.162 seconds (+0.000); 6.98 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right bottom)
Application 0.163 seconds (+0.001); 6.99 MB (+0.014) - afterRenderModule mod_banners (ad bottom right bottom)
Application 0.163 seconds (+0.000); 6.98 MB (-0.008) - beforeRenderModule mod_banners (ad bottom mid top)
Application 0.164 seconds (+0.001); 6.99 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid top)
Application 0.164 seconds (+0.000); 6.98 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid mid)
Application 0.165 seconds (+0.001); 7.00 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid mid)
Application 0.165 seconds (+0.000); 6.99 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid bottom)
Application 0.166 seconds (+0.001); 7.00 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid bottom)
Application 0.166 seconds (+0.000); 6.99 MB (-0.008) - beforeRenderModule mod_banners (ad bottom left top)
Application 0.167 seconds (+0.001); 7.01 MB (+0.014) - afterRenderModule mod_banners (ad bottom left top)
Application 0.167 seconds (+0.000); 7.00 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left mid)
Application 0.167 seconds (+0.001); 7.01 MB (+0.013) - afterRenderModule mod_banners (ad bottom left mid)
Application 0.168 seconds (+0.000); 7.00 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left bottom)
Application 0.168 seconds (+0.000); 7.02 MB (+0.011) - afterRenderModule mod_banners (ad bottom left bottom)
Application 0.168 seconds (+0.000); 7.01 MB (-0.006) - beforeRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)
Application 0.168 seconds (+0.000); 7.01 MB (+0.004) - afterRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)
Application 0.168 seconds (+0.000); 7.01 MB (-0.001) - beforeRenderModule mod_finder (smart_search)
Application 0.172 seconds (+0.004); 7.09 MB (+0.080) - afterRenderModule mod_finder (smart_search)
Application 0.172 seconds (+0.000); 7.09 MB (-0.006) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.173 seconds (+0.001); 7.10 MB (+0.014) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.173 seconds (+0.000); 7.10 MB (-0.005) - beforeRenderModule mod_menu (topmenu)
Application 0.173 seconds (+0.000); 7.11 MB (+0.016) - afterRenderModule mod_menu (topmenu)
Application 0.173 seconds (+0.000); 7.11 MB (-0.006) - beforeRenderModule mod_custom (feedback)
Application 0.173 seconds (+0.000); 7.11 MB (+0.004) - afterRenderModule mod_custom (feedback)
Application 0.174 seconds (+0.000); 7.11 MB (-0.003) - beforeRenderModule mod_custom (SeacoastNH Feedback)
Application 0.174 seconds (+0.000); 7.11 MB (+0.004) - afterRenderModule mod_custom (SeacoastNH Feedback)
Application 0.174 seconds (+0.000); 7.11 MB (-0.003) - beforeRenderModule mod_custom (MainHeader)
Application 0.174 seconds (+0.000); 7.11 MB (+0.004) - afterRenderModule mod_custom (MainHeader)
Application 0.174 seconds (+0.000); 7.11 MB (-0.002) - beforeRenderModule mod_custom (Facebook)
Application 0.174 seconds (+0.000); 7.12 MB (+0.004) - afterRenderModule mod_custom (Facebook)
Application 0.174 seconds (+0.000); 7.11 MB (-0.002) - beforeRenderModule mod_menu (Main Menu)
Application 0.178 seconds (+0.004); 7.18 MB (+0.070) - afterRenderModule mod_menu (Main Menu)
Application 0.178 seconds (+0.000); 7.18 MB (-0.007) - beforeRenderModule mod_custom (Donate to Our Site)
Application 0.178 seconds (+0.000); 7.18 MB (+0.004) - afterRenderModule mod_custom (Donate to Our Site)
Application 0.178 seconds (+0.000); 7.18 MB (-0.003) - beforeRenderModule mod_custom (Feedjit)
Application 0.178 seconds (+0.000); 7.18 MB (+0.004) - afterRenderModule mod_custom (Feedjit)
Application 0.178 seconds (+0.000); 7.18 MB (-0.003) - beforeRenderModule mod_custom (facebook lower logo)
Application 0.178 seconds (+0.000); 7.18 MB (+0.004) - afterRenderModule mod_custom (facebook lower logo)
Application 0.179 seconds (+0.000); 7.22 MB (+0.040) - afterRender
7.23 MB (7,579,264 Bytes)
209 Queries LoggedSELECT `data`
FROM `rabbul_session`
WHERE `session_id` = '9935faf23054d28ca493974a2c6a96ab'DELETE
FROM `rabbul_session`
WHERE `time` < '1793676955'SELECT `session_id`
FROM `rabbul_session`
WHERE `session_id` = '9935faf23054d28ca493974a2c6a96ab' LIMIT 0, 1INSERT INTO `rabbul_session`
(`session_id`, `client_id`, `time`) VALUES
('9935faf23054d28ca493974a2c6a96ab', 0, '1793677855')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 = 'my-list-of-books-about-portsmouth-nh/' AND published='1' LIMIT 1SELECT id FROM rabbul_menu WHERE alias='my-list-of-books-about-portsmouth-nh' AND published=1SELECT id
FROM rabbul_categories
WHERE path='my-list-of-books-about-portsmouth-nh' AND extension='com_content'SELECT id,catid
FROM rabbul_content
WHERE alias='my-list-of-books-about-portsmouth-nh' AND state>0SELECT id,catid
FROM rabbul_content
WHERE alias='my-list-of-books-about-portsmouth-nh' AND state>0SELECT id
FROM rabbul_menu
WHERE type='component' AND published='1' AND link LIKE 'index.php?option=com_content&view=article%&id=3162'
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 = 3162 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-03 03:50:55') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-03 03:50:55') 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 = 3162UPDATE rabbul_content SET hits = hits + 1 WHERE id = 3162SELECT 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 03:50:55') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-11-03 03:50:55') 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 03:50:55' >= `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 03'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=100 AND track_date='2026-11-03 03'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=100 AND track_date='2026-11-03 03'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 03:50:55' >= `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 03:50:55' >= `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 03'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=87 AND track_date='2026-11-03 03'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=87 AND track_date='2026-11-03 03'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 87SELECT *
FROM rabbul_banners
WHERE '2026-11-03 03:50:55' >= `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 03'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=84 AND track_date='2026-11-03 03'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=84 AND track_date='2026-11-03 03'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 84SELECT *
FROM rabbul_banners
WHERE '2026-11-03 03:50:55' >= `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 03:50:55' >= `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 03:50:55' >= `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 03:50:55' >= `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 03:50:55' >= `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 03:50:55' >= `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 03:50:55' >= `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 03:50:55' >= `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 03'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=95 AND track_date='2026-11-03 03'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=95 AND track_date='2026-11-03 03'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 95SELECT *
FROM rabbul_banners
WHERE '2026-11-03 03:50:55' >= `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 03:50:55' >= `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 03'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=30 AND track_date='2026-11-03 03'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=30 AND track_date='2026-11-03 03'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 30SELECT *
FROM rabbul_banners
WHERE '2026-11-03 03:50:55' >= `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 03'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=31 AND track_date='2026-11-03 03'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=31 AND track_date='2026-11-03 03'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 31SELECT *
FROM rabbul_banners
WHERE '2026-11-03 03:50:55' >= `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 03:50:55' >= `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 03:50:55' >= `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 03:50:55' >= `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 03'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=23 AND track_date='2026-11-03 03'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=23 AND track_date='2026-11-03 03'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 23SELECT *
FROM rabbul_banners
WHERE '2026-11-03 03:50:55' >= `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 03:50:55' >= `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:1793677855;s:18:\"session.timer.last\";i:1793677855;s:17:\"session.timer.now\";i:1793677855;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` = '1793677855'
WHERE `session_id` = '9935faf23054d28ca493974a2c6a96ab'
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_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:1793677855;s:18:\"session.timer.last\";i:1793677855;s:17:\"session.timer.now\";i:1793677855;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` = '1793677855'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 ('9935faf23054d28ca493974a2c6a96ab', 0, '1793677855'1 × SHOW FULL COLUMNS FROM `rabbul_sef_config1 × SHOW FULL COLUMNS FROM `rabbul_assets1 × DELETE FROM `rabbul_session`
|