|
FRESH STUFF DAILY
Seacoast New Hampshire
& South Coast Maine
|
|
|
|
|
|
|
|
SEE ALL SIGNED BOOKS by J. Dennis Robinson click here
|
|
Maine Author Writes 145 Books |
Seacoast History Blog #60 August 11, 2009
Here we go again. Writing history is looking more and more like that ringing gag in the film "Caddyshack" where Bill Murray tries every trick possible to catch an underground gopher. I went down another gopher hole today while researching Chapter 4 of my next book on privateering. Before that I was covering a lot of ground, digging up details on Captain Thomas Boyd, one of the most successful and gutsy privateersman during the War of 1812. Sailing the Baltimore schooner Chasseur, he took more prizes in a single day than anyone before or since. Then he faced a British warship head on, despite falling into a surprise attack, won the day, and retired rich and happy. (Continued below)
The Chauseur was the fastest and most beautiful sailing chip of its era, so beautiful, one contemporary critic wrote, that it looked like it could lift up out of the sea and fly. Marylanders called it ‘The Pride of Baltimore" and in 1975 Melbourne Smith reproduced that ship in Baltimore. He also built the privateer Lynx, which is what I’m writing about now and we’ve been corresponding for months.
Privateer hero Thomas Boyle
Captain Boyle is a totally cool character who lived in Fells Point. MD which I visited not long ago. It’s like Portsmouth with an historic port, lots of federal brick houses, and a funky gentrified tourism industry based on retelling tales of its seafaring past.
Anyway, Boyle has never really gotten his due. He captured fifty-something British merchant ships and faced off against two warships all while part of his own private navy. But it’s hard to find out much detail on Boyle’s private life and personality, other than the details of battles he fought and the prizes he captured. So I was glad to discover a book called "The Cruise of the Comet" by James Otis published around 1895. Before he captained the Chasseur, Boyle conducted at least three hair-raising voyages aboard the privateer Comet, also built at Fells Point, by the same guy who built the original Lynx and Chasseur. The Privateer Lynx, you will remember, is what my next book is about.
Discovering James Otis Kaler (1848-1912)
I know about Otis from his book about John Paul Jones. It comes up a lot in research which means there are a lot of copies of his JPJ book still floating around. But it is just a secondary source, a book for kids really, so I have never read it through. "The Cruise of the Comet" too, from what I could see online, looked like another adventure book for boys. But curiously, Otis says in the subtitle, that the book is based on the letters of a former Comet crewman named Stephan, who wrote a series of letters to his cousin – get this – in Portsmouth, NH.
This got me curious about Otis, and this is where I went down the gopher hole. His full name, it turns out is James Otis Kaler. There is a James Otis Kaler Elementary School in nearby South Portland, Maine. That’s because the author was also superintendent of schools there in the early 20th century.
Born in Winterport, ME, Kaler (aka Otis) worked as a journalist for the Boston Journal and then the New York Sun. Then in 1890 he got an editorial job with Frank Leslie’s Boys and Girls, a publishing company. This explains why, when I looked up his books, there were dozens of them – mostly adventure tales for boys aged 10-14. Otis wrote about the sea, the prairie, about spies and pirates, about the first airships, newsies, early settlers cowboys soldiers, stowaways and mine workers.
This age group is still a large marketplace for publishers today. The weird thing is, I’ve been writing juvenile history too. I penned two small history adventure books for middle schoolers a few years back and just finished another one this summer. And to make it even weirder, Kaler, writing as James Otis, wrote a book on every topic I touched, and scores more. According to his December 12, 1912 obituary in the New York Times, James Otis penned no less than 145 books.
As someone who struggles to complete a book a year, that number boggles me, especially since Otis (aka Kaler) wrote 145 books while working other jobs during a period of about 30 years – and using a typewriter and carbon paper. And these are pretty weighty little books, with only a few pictures and lots of text. That averages out at almost five books per year from his first in 1880, nonstop until his death at age 64.
You’ve heard of his first book – Toby Tyler, or Ten Weeks with a Circus -- that was later made into a Disney movie for the Boomer generation. You probably have not heard of the other 144.
You could call his work "boy books" which the author certainly did. That is a topic I’ve done considerable study on since discovering "Story of a Bad Boy" by Portsmouth’s visiting author Thomas Bailey Aldrich. .
" The American boy of to-day doesn't want a hero of the ' goody- goody ' sort," James Otis told a reporter from THE WRITER in 1907.
Sounding a bit like Horatio Alger himself, Otis noted that he wrote books that boys wanted to buy with limited cash. They want to read stories of great success, he told THE WRITER, because they have little cash in their own pockets. And they don’t want stories of love or girls. Boys want stories about boys, he says, about adventure, friendship, loyalty, imagination, and personal success.
"I believe that the American boy of to-day expects his ideal book-boy to have a great deal of snap and plenty of backbone," Otis said.
But enough of that. I am climbing out of the gopher hole now and heading back to the War of 1812. Look for my book on the Privateer Lynx on the shelves in 2012.
Copyright © 2009 by J. Dennis Robinson. All rights reserved.
Please visit these SeacoastNH.com ad partners.
News about Portsmouth from Fosters.com
|
|
|
| Tuesday, November 03, 2026 |
|
|
|
Site maintained by ad-cetera graphics
|
Joomla! Debug Console- Error loading feed data
| Call stack | | # | Function | Location |
|---|
| 1 | JSite->render() | JROOT/index.php:48 | | 2 | JDocumentHTML->render() | JROOT/includes/application.php:268 | | 3 | JDocumentHTML->_renderTemplate() | JROOT/libraries/joomla/document/html/html.php:433 | | 4 | JDocumentHTML->getBuffer() | JROOT/libraries/joomla/document/html/html.php:652 | | 5 | JDocumentRendererModules->render() | JROOT/libraries/joomla/document/html/html.php:371 | | 6 | JDocumentRendererModule->render() | JROOT/libraries/joomla/document/html/renderer/modules.php:39 | | 7 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/html/renderer/module.php:107 | | 8 | include() | JROOT/libraries/joomla/application/module/helper.php:173 | | 9 | modFeedHelper::getFeed() | JROOT/modules/mod_feed/mod_feed.php:27 | | 10 | JFactory::getFeedParser() | JROOT/modules/mod_feed/helper.php:33 | | 11 | JError::raiseWarning() | JROOT/libraries/joomla/factory.php:371 | | 12 | JError::raise() | JROOT/libraries/joomla/error/error.php:276 |
session.client.forwarded ⇒ 10.3.184.74
session.client.browser ⇒ Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
password_clear ⇒
groups ⇒
com_rsfirewall.geoip ⇒
Application 0.000 seconds (+0.000); 0.33 MB (+0.330) - afterLoad
Application 0.014 seconds (+0.014); 3.22 MB (+2.894) - afterInitialise
Application 0.046 seconds (+0.032); 5.03 MB (+1.804) - afterRoute
Application 0.055 seconds (+0.009); 6.14 MB (+1.112) - afterDispatch
Application 0.056 seconds (+0.001); 6.33 MB (+0.188) - beforeRenderModule mod_custom (Footer)
Application 0.057 seconds (+0.001); 6.34 MB (+0.010) - afterRenderModule mod_custom (Footer)
Application 0.057 seconds (+0.000); 6.34 MB (-0.000) - beforeRenderModule mod_banners (Uncle Oscar)
Application 0.059 seconds (+0.002); 6.46 MB (+0.126) - afterRenderModule mod_banners (Uncle Oscar)
Application 0.059 seconds (+0.000); 6.48 MB (+0.016) - beforeRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)
Application 0.060 seconds (+0.001); 6.60 MB (+0.123) - afterRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)
Application 0.060 seconds (+0.000); 6.50 MB (-0.098) - beforeRenderModule mod_novarp (ISC/Star)
Application 0.062 seconds (+0.001); 6.61 MB (+0.101) - afterRenderModule mod_novarp (ISC/Star)
Application 0.062 seconds (+0.000); 6.48 MB (-0.121) - beforeRenderModule mod_banners (Music Hall)
Application 0.063 seconds (+0.001); 6.50 MB (+0.013) - afterRenderModule mod_banners (Music Hall)
Application 0.063 seconds (+0.000); 6.49 MB (-0.009) - beforeRenderModule mod_banners (Maren)
Application 0.064 seconds (+0.001); 6.50 MB (+0.014) - afterRenderModule mod_banners (Maren)
Application 0.064 seconds (+0.000); 6.49 MB (-0.009) - beforeRenderModule mod_banners (Smuttynose Murders)
Application 0.065 seconds (+0.001); 6.51 MB (+0.014) - afterRenderModule mod_banners (Smuttynose Murders)
Application 0.065 seconds (+0.000); 6.50 MB (-0.009) - beforeRenderModule mod_banners (Banner Maine Harbors)
Application 0.066 seconds (+0.001); 6.51 MB (+0.013) - afterRenderModule mod_banners (Banner Maine Harbors)
Application 0.066 seconds (+0.000); 6.50 MB (-0.009) - beforeRenderModule mod_banners (Banner Sanctuary Hair)
Application 0.066 seconds (+0.001); 6.52 MB (+0.013) - afterRenderModule mod_banners (Banner Sanctuary Hair)
Application 0.066 seconds (+0.000); 6.51 MB (-0.009) - beforeRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)
Application 0.067 seconds (+0.001); 6.52 MB (+0.011) - afterRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)
Application 0.067 seconds (+0.000); 6.54 MB (+0.021) - beforeRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)
Application 0.068 seconds (+0.001); 6.61 MB (+0.069) - afterRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)
Application 0.068 seconds (+0.000); 6.51 MB (-0.097) - beforeRenderModule mod_banners (Banner sheraton wedding)
Application 0.068 seconds (+0.001); 6.52 MB (+0.013) - afterRenderModule mod_banners (Banner sheraton wedding)
Application 0.068 seconds (+0.000); 6.52 MB (-0.004) - beforeRenderModule mod_banners (Banner Boating)
Application 0.069 seconds (+0.001); 6.53 MB (+0.008) - afterRenderModule mod_banners (Banner Boating)
Application 0.069 seconds (+0.000); 6.52 MB (-0.005) - beforeRenderModule mod_banners (Banner Harbour arts)
Application 0.069 seconds (+0.001); 6.53 MB (+0.008) - afterRenderModule mod_banners (Banner Harbour arts)
Application 0.069 seconds (+0.000); 6.52 MB (-0.007) - beforeRenderModule mod_custom (Google Ads)
Application 0.070 seconds (+0.000); 6.53 MB (+0.004) - afterRenderModule mod_custom (Google Ads)
Application 0.070 seconds (+0.000); 6.53 MB (-0.002) - beforeRenderModule mod_banners (Banner Newmarket heritage)
Application 0.071 seconds (+0.001); 6.53 MB (+0.008) - afterRenderModule mod_banners (Banner Newmarket heritage)
Application 0.071 seconds (+0.000); 6.53 MB (-0.004) - beforeRenderModule mod_banners (Shoals Marine Ad)
Application 0.072 seconds (+0.002); 6.54 MB (+0.011) - afterRenderModule mod_banners (Shoals Marine Ad)
Application 0.072 seconds (+0.000); 6.53 MB (-0.008) - beforeRenderModule mod_feed (News about Portsmouth from Fosters.com)
Application 0.167 seconds (+0.095); 6.96 MB (+0.428) - afterRenderModule mod_feed (News about Portsmouth from Fosters.com)
Application 0.167 seconds (+0.000); 6.96 MB (-0.001) - beforeRenderModule mod_banners (ad bottom right top)
Application 0.169 seconds (+0.001); 6.97 MB (+0.013) - afterRenderModule mod_banners (ad bottom right top)
Application 0.169 seconds (+0.000); 6.96 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right mid)
Application 0.170 seconds (+0.001); 6.98 MB (+0.014) - afterRenderModule mod_banners (ad bottom right mid)
Application 0.170 seconds (+0.000); 6.97 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right bottom)
Application 0.171 seconds (+0.001); 6.98 MB (+0.014) - afterRenderModule mod_banners (ad bottom right bottom)
Application 0.171 seconds (+0.000); 6.98 MB (-0.008) - beforeRenderModule mod_banners (ad bottom mid top)
Application 0.172 seconds (+0.001); 6.99 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid top)
Application 0.172 seconds (+0.000); 6.98 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid mid)
Application 0.173 seconds (+0.001); 6.99 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid mid)
Application 0.173 seconds (+0.000); 6.98 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid bottom)
Application 0.173 seconds (+0.001); 7.00 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid bottom)
Application 0.173 seconds (+0.000); 6.99 MB (-0.008) - beforeRenderModule mod_banners (ad bottom left top)
Application 0.174 seconds (+0.001); 7.00 MB (+0.014) - afterRenderModule mod_banners (ad bottom left top)
Application 0.174 seconds (+0.000); 6.99 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left mid)
Application 0.175 seconds (+0.001); 7.01 MB (+0.013) - afterRenderModule mod_banners (ad bottom left mid)
Application 0.175 seconds (+0.000); 7.00 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left bottom)
Application 0.175 seconds (+0.000); 7.01 MB (+0.011) - afterRenderModule mod_banners (ad bottom left bottom)
Application 0.175 seconds (+0.000); 7.00 MB (-0.006) - beforeRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)
Application 0.176 seconds (+0.000); 7.01 MB (+0.004) - afterRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)
Application 0.176 seconds (+0.000); 7.01 MB (-0.001) - beforeRenderModule mod_finder (smart_search)
Application 0.179 seconds (+0.003); 7.09 MB (+0.080) - afterRenderModule mod_finder (smart_search)
Application 0.179 seconds (+0.000); 7.08 MB (-0.006) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.180 seconds (+0.001); 7.10 MB (+0.014) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.180 seconds (+0.000); 7.09 MB (-0.005) - beforeRenderModule mod_menu (topmenu)
Application 0.180 seconds (+0.000); 7.11 MB (+0.016) - afterRenderModule mod_menu (topmenu)
Application 0.180 seconds (+0.000); 7.10 MB (-0.006) - beforeRenderModule mod_custom (feedback)
Application 0.180 seconds (+0.000); 7.11 MB (+0.004) - afterRenderModule mod_custom (feedback)
Application 0.180 seconds (+0.000); 7.10 MB (-0.003) - beforeRenderModule mod_custom (SeacoastNH Feedback)
Application 0.180 seconds (+0.000); 7.11 MB (+0.004) - afterRenderModule mod_custom (SeacoastNH Feedback)
Application 0.180 seconds (+0.000); 7.10 MB (-0.003) - beforeRenderModule mod_custom (MainHeader)
Application 0.181 seconds (+0.000); 7.11 MB (+0.004) - afterRenderModule mod_custom (MainHeader)
Application 0.181 seconds (+0.000); 7.11 MB (-0.002) - beforeRenderModule mod_custom (Facebook)
Application 0.181 seconds (+0.000); 7.11 MB (+0.004) - afterRenderModule mod_custom (Facebook)
Application 0.181 seconds (+0.000); 7.11 MB (-0.002) - beforeRenderModule mod_menu (Main Menu)
Application 0.185 seconds (+0.004); 7.18 MB (+0.070) - afterRenderModule mod_menu (Main Menu)
Application 0.185 seconds (+0.000); 7.17 MB (-0.008) - beforeRenderModule mod_custom (Donate to Our Site)
Application 0.185 seconds (+0.000); 7.17 MB (+0.004) - afterRenderModule mod_custom (Donate to Our Site)
Application 0.185 seconds (+0.000); 7.17 MB (-0.003) - beforeRenderModule mod_custom (Feedjit)
Application 0.185 seconds (+0.000); 7.18 MB (+0.004) - afterRenderModule mod_custom (Feedjit)
Application 0.185 seconds (+0.000); 7.17 MB (-0.003) - beforeRenderModule mod_custom (facebook lower logo)
Application 0.185 seconds (+0.000); 7.18 MB (+0.004) - afterRenderModule mod_custom (facebook lower logo)
Application 0.185 seconds (+0.000); 7.22 MB (+0.039) - afterRender
7.22 MB (7,572,776 Bytes)
209 Queries LoggedSELECT `data`
FROM `rabbul_session`
WHERE `session_id` = 'c68c8eb6c6a1d673c808fe5d13d36b7d'DELETE
FROM `rabbul_session`
WHERE `time` < '1793706531'SELECT `session_id`
FROM `rabbul_session`
WHERE `session_id` = 'c68c8eb6c6a1d673c808fe5d13d36b7d' LIMIT 0, 1INSERT INTO `rabbul_session`
(`session_id`, `client_id`, `time`) VALUES
('c68c8eb6c6a1d673c808fe5d13d36b7d', 0, '1793707431')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 = 'maine-author-writes-145-books/' AND published='1' LIMIT 1SELECT id FROM rabbul_menu WHERE alias='maine-author-writes-145-books' AND published=1SELECT id
FROM rabbul_categories
WHERE path='maine-author-writes-145-books' AND extension='com_content'SELECT id,catid
FROM rabbul_content
WHERE alias='maine-author-writes-145-books' AND state>0SELECT id,catid
FROM rabbul_content
WHERE alias='maine-author-writes-145-books' AND state>0SELECT id
FROM rabbul_menu
WHERE type='component' AND published='1' AND link LIKE 'index.php?option=com_content&view=article%&id=2434'
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 = 2434 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-03 12:03:51') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-03 12:03:51') 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 = 2434UPDATE rabbul_content SET hits = hits + 1 WHERE id = 2434SELECT 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 12:03:51') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-11-03 12:03:51') 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 12:03:51' >= `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 12'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=100 AND track_date='2026-11-03 12'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=100 AND track_date='2026-11-03 12'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 12:03:51' >= `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 12:03:51' >= `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 12'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=87 AND track_date='2026-11-03 12'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=87 AND track_date='2026-11-03 12'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 87SELECT *
FROM rabbul_banners
WHERE '2026-11-03 12:03:51' >= `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 12'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=84 AND track_date='2026-11-03 12'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=84 AND track_date='2026-11-03 12'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 84SELECT *
FROM rabbul_banners
WHERE '2026-11-03 12:03:51' >= `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 12:03:51' >= `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 12:03:51' >= `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 12:03:51' >= `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 12:03:51' >= `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 12:03:51' >= `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 12:03:51' >= `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 12:03:51' >= `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 12'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=95 AND track_date='2026-11-03 12'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=95 AND track_date='2026-11-03 12'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 95SELECT *
FROM rabbul_banners
WHERE '2026-11-03 12:03:51' >= `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 12:03:51' >= `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 12'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=30 AND track_date='2026-11-03 12'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=30 AND track_date='2026-11-03 12'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 30SELECT *
FROM rabbul_banners
WHERE '2026-11-03 12:03:51' >= `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 12'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=31 AND track_date='2026-11-03 12'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=31 AND track_date='2026-11-03 12'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 31SELECT *
FROM rabbul_banners
WHERE '2026-11-03 12:03:51' >= `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 12:03:51' >= `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 12:03:51' >= `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 12:03:51' >= `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 12'SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=23 AND track_date='2026-11-03 12'UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=23 AND track_date='2026-11-03 12'SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 23SELECT *
FROM rabbul_banners
WHERE '2026-11-03 12:03:51' >= `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 12:03:51' >= `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:1793707431;s:18:\"session.timer.last\";i:1793707431;s:17:\"session.timer.now\";i:1793707431;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` = '1793707431'
WHERE `session_id` = 'c68c8eb6c6a1d673c808fe5d13d36b7d'
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:1793707431;s:18:\"session.timer.last\";i:1793707431;s:17:\"session.timer.now\";i:1793707431;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` = '1793707431'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 ('c68c8eb6c6a1d673c808fe5d13d36b7d', 0, '1793707431'1 × SHOW FULL COLUMNS FROM `rabbul_sef_config1 × SHOW FULL COLUMNS FROM `rabbul_assets1 × DELETE FROM `rabbul_session`
|