|
FRESH STUFF DAILY
Seacoast New Hampshire
& South Coast Maine
|
|
|
|
|
|
The Blog In the Green Room with Anita Shreve
|
|
|
SEE ALL SIGNED BOOKS by J. Dennis Robinson click here
|
|
In the Green Room with Anita Shreve |
 Seacoast History Blog #12 November 21, 2008 Bestselling author Anita Shreve was signing books like a house afire. Seated behind a folding table in the rough hewn “green room” behind the stage at the Music Hall in Portsmouth, she talked as she signed box after box of her new novel “Testimony”. Half an hour later she spoke candidly with 800 loyal fans. There was barely a drop of testosterone in the crowd. (Continued)
The Weight of Water Never Dies Anita Shreve, it is apparent, writes for women. She writes dark fiction drawn from her love of New England. She is the Hawthorne of modern fiction where people do dangerous things for passionate reasons, and are frequently punished for their carnal sins.
VISIT our SMUTTYNOSE MURDER section
You can hear that whole interview with Laura Knoy on the NH Public Radio web site. It’s part of the incredibly successful Writers on the New England Stage program of which this web site is a media sponsor. As an author, I’m thrilled to discover that even in this digital day, that many people will drive, park, and pay to sit in an audience just to watch two people talk about books. But back to the Green Room where Anita had finished a take-out meal of what appeared to be fettuccini alfredo and was chatting with two friends as she autographed books as fast as the crew from Riverrun could flip open the covers. “How do you sign so quickly?” I asked “You just drift off at the end,” Anita said, completing another two-second signature with a flourish.

My wife Maryellen and I met Anita on the Isles of Shoals in 1998 just after the publication of her novel Weight of Water (1997) that borrows heavily from the actual trial of Louis Wagner. Wagner murdered two Norwegian women on Smuttynose Island in March of 1873. Maryellen and I have been “stewards” on that island every summer since. Visitors who find their way there, we told Anita, inevitably ask us to recount the murder story, which we’ve done hundreds of times. Most of them, having read Weight of Water cannot parse the facts from fiction. We spend a goodly portion of our time “on island” trying to lay out the facts, but for most, it is too late. They cannot give up the fantasy that Maren Hontvet, the surviving woman, was the murderer. Anita may have moved on, we told her, through nine more novels (14 in all so far), but this region is still fixated on her treatment of the Smuttynose Murders. “Did you know?” we told her, “That the two highest grossing film presentations here at the Music Hall were for the movie version of “Weight of Water’? Anita did not know. She is still friendly, she says, with director Kathryn Bigelow, but the film, like the novel, has been pushed deep into the past. Despite the presence of Sean Penn and a nude Elizabeth Hurley, the movie tanked, choked in its cradle by nervous distributors who released it briefly in only a couple dozen theatres. Only here in this theatre was Weight of Water a box office smash. The 2002 TV-movie version of her novel Pilot’s Wife faired slightly better. Again the producer’s left the film in the can, fearful that the crash of a commercial airline could not be shown too soon after the tragedy of 9/11. Although most of her novels have been optioned for film, none are in production, Anita says. She does not write with the cinema in mind, but thinks Testimony would make a good film. “Hope springs eternal,” she says. Anita was on location during the cold and rainy filming of “Weight” in Nova Scotia. It was, she told us, “the least glamorous thing I’ve ever done.” There Bigelow faithfully reconstructed Smuttynose Island and the Hontvet house in 1873. The real one here, ravaged by Victorian souvenir hunters, burned down a century ago. The reconstructed building, Anita says, was purchased by a member of the film crew and is still standing. It seems not so long ago that the filmmaker’s research crew, discovering this web site, called for historical details while designing the costumes and sets. Having just been hired to do a little research for another Hollywood film, I attempted to get on the payroll. No one ever called back. Around here, as the movie languished on the producer’s shelf, we spent a couple of years nervously awaiting its release, fearful it would attract hordes of tourists to the private and fragile little island (no electricity, no water, no plumbing, no roads). The hordes never came, but the novel – still a book club favorite -- has had an indelible effect on this infamous local event. At each appearance in Portsmouth, Anita is required to explain that – although her fictional character stole some fictional documents from the Portsmouth Athenaeum, she did not. Anita’s next two novels, Pilot’s Wife (2001) and Fortune’s Rocks (2002) hovered around the Portsmouth area. Then she moved along her beloved New England coast and, with Testimony, has moved inland to a Vermont private school. Following a boost from Oprah, the female fiction fans have been kind to Anita Shreve, a former teacher, journalist, short story and nonfiction author. I couldn’t determine how many millions of books she has sold – or signed – but it’s plenty. Her Portsmouth gig was the last in a grueling two-month book tour. She is moving this week to a condo in Boston with valet parking after a lifetime of raising her children in the suburbs. We found her as gracious, energetic and endlessly curious as ever. Although Anita has rarely returned to historical fiction, her next novel, she says, is “historical, sort of”. The ghost of Maren Hontvet may never forgive Anita for transforming her from victim to murderer, but we do. © 2008 by J. Dennis Robinson. All rights reserved. on SeacoastNH.com
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.018 seconds (+0.017); 3.22 MB (+2.894) - afterInitialise
Application 0.054 seconds (+0.036); 5.03 MB (+1.804) - afterRoute
Application 0.063 seconds (+0.009); 6.14 MB (+1.116) - afterDispatch
Application 0.065 seconds (+0.002); 6.33 MB (+0.188) - beforeRenderModule mod_custom (Footer)
Application 0.065 seconds (+0.001); 6.34 MB (+0.010) - afterRenderModule mod_custom (Footer)
Application 0.066 seconds (+0.000); 6.34 MB (-0.000) - beforeRenderModule mod_banners (Uncle Oscar)
Application 0.068 seconds (+0.002); 6.47 MB (+0.126) - afterRenderModule mod_banners (Uncle Oscar)
Application 0.068 seconds (+0.000); 6.48 MB (+0.016) - beforeRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)
Application 0.069 seconds (+0.001); 6.61 MB (+0.123) - afterRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)
Application 0.069 seconds (+0.000); 6.51 MB (-0.098) - beforeRenderModule mod_novarp (ISC/Star)
Application 0.071 seconds (+0.001); 6.61 MB (+0.102) - afterRenderModule mod_novarp (ISC/Star)
Application 0.071 seconds (+0.000); 6.49 MB (-0.121) - beforeRenderModule mod_banners (Music Hall)
Application 0.072 seconds (+0.001); 6.50 MB (+0.014) - afterRenderModule mod_banners (Music Hall)
Application 0.072 seconds (+0.000); 6.49 MB (-0.009) - beforeRenderModule mod_banners (Maren)
Application 0.073 seconds (+0.001); 6.51 MB (+0.014) - afterRenderModule mod_banners (Maren)
Application 0.073 seconds (+0.000); 6.50 MB (-0.009) - beforeRenderModule mod_banners (Smuttynose Murders)
Application 0.074 seconds (+0.001); 6.51 MB (+0.014) - afterRenderModule mod_banners (Smuttynose Murders)
Application 0.074 seconds (+0.000); 6.50 MB (-0.009) - beforeRenderModule mod_banners (Banner Maine Harbors)
Application 0.074 seconds (+0.001); 6.52 MB (+0.013) - afterRenderModule mod_banners (Banner Maine Harbors)
Application 0.075 seconds (+0.000); 6.51 MB (-0.009) - beforeRenderModule mod_banners (Banner Sanctuary Hair)
Application 0.075 seconds (+0.001); 6.52 MB (+0.013) - afterRenderModule mod_banners (Banner Sanctuary Hair)
Application 0.075 seconds (+0.000); 6.51 MB (-0.009) - beforeRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)
Application 0.076 seconds (+0.001); 6.52 MB (+0.011) - afterRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)
Application 0.076 seconds (+0.000); 6.54 MB (+0.020) - beforeRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)
Application 0.077 seconds (+0.001); 6.61 MB (+0.069) - afterRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)
Application 0.077 seconds (+0.000); 6.51 MB (-0.097) - beforeRenderModule mod_banners (Banner sheraton wedding)
Application 0.078 seconds (+0.001); 6.53 MB (+0.013) - afterRenderModule mod_banners (Banner sheraton wedding)
Application 0.078 seconds (+0.000); 6.52 MB (-0.004) - beforeRenderModule mod_banners (Banner Boating)
Application 0.078 seconds (+0.001); 6.53 MB (+0.008) - afterRenderModule mod_banners (Banner Boating)
Application 0.078 seconds (+0.000); 6.53 MB (-0.005) - beforeRenderModule mod_banners (Banner Harbour arts)
Application 0.079 seconds (+0.000); 6.53 MB (+0.008) - afterRenderModule mod_banners (Banner Harbour arts)
Application 0.079 seconds (+0.000); 6.53 MB (-0.007) - beforeRenderModule mod_custom (Google Ads)
Application 0.079 seconds (+0.000); 6.53 MB (+0.004) - afterRenderModule mod_custom (Google Ads)
Application 0.079 seconds (+0.000); 6.53 MB (-0.002) - beforeRenderModule mod_banners (Banner Newmarket heritage)
Application 0.079 seconds (+0.001); 6.54 MB (+0.008) - afterRenderModule mod_banners (Banner Newmarket heritage)
Application 0.080 seconds (+0.000); 6.53 MB (-0.004) - beforeRenderModule mod_banners (Shoals Marine Ad)
Application 0.081 seconds (+0.001); 6.54 MB (+0.011) - afterRenderModule mod_banners (Shoals Marine Ad)
Application 0.081 seconds (+0.000); 6.54 MB (-0.008) - beforeRenderModule mod_feed (News about Portsmouth from Fosters.com)
Application 0.149 seconds (+0.068); 6.96 MB (+0.427) - afterRenderModule mod_feed (News about Portsmouth from Fosters.com)
Application 0.149 seconds (+0.000); 6.96 MB (-0.001) - beforeRenderModule mod_banners (ad bottom right top)
Application 0.151 seconds (+0.002); 6.98 MB (+0.013) - afterRenderModule mod_banners (ad bottom right top)
Application 0.151 seconds (+0.000); 6.97 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right mid)
Application 0.152 seconds (+0.001); 6.98 MB (+0.014) - afterRenderModule mod_banners (ad bottom right mid)
Application 0.152 seconds (+0.000); 6.97 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right bottom)
Application 0.154 seconds (+0.001); 6.99 MB (+0.014) - afterRenderModule mod_banners (ad bottom right bottom)
Application 0.154 seconds (+0.000); 6.98 MB (-0.008) - beforeRenderModule mod_banners (ad bottom mid top)
Application 0.155 seconds (+0.001); 6.99 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid top)
Application 0.155 seconds (+0.000); 6.98 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid mid)
Application 0.156 seconds (+0.001); 7.00 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid mid)
Application 0.156 seconds (+0.000); 6.99 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid bottom)
Application 0.157 seconds (+0.001); 7.00 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid bottom)
Application 0.157 seconds (+0.000); 6.99 MB (-0.008) - beforeRenderModule mod_banners (ad bottom left top)
Application 0.158 seconds (+0.001); 7.01 MB (+0.014) - afterRenderModule mod_banners (ad bottom left top)
Application 0.158 seconds (+0.000); 7.00 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left mid)
Application 0.159 seconds (+0.001); 7.01 MB (+0.013) - afterRenderModule mod_banners (ad bottom left mid)
Application 0.159 seconds (+0.000); 7.00 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left bottom)
Application 0.159 seconds (+0.001); 7.01 MB (+0.011) - afterRenderModule mod_banners (ad bottom left bottom)
Application 0.159 seconds (+0.000); 7.01 MB (-0.006) - beforeRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)
Application 0.160 seconds (+0.000); 7.01 MB (+0.004) - afterRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)
Application 0.160 seconds (+0.000); 7.01 MB (-0.001) - beforeRenderModule mod_finder (smart_search)
Application 0.164 seconds (+0.004); 7.09 MB (+0.080) - afterRenderModule mod_finder (smart_search)
Application 0.164 seconds (+0.000); 7.09 MB (-0.006) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.165 seconds (+0.001); 7.10 MB (+0.014) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.165 seconds (+0.000); 7.10 MB (-0.005) - beforeRenderModule mod_menu (topmenu)
Application 0.165 seconds (+0.000); 7.11 MB (+0.016) - afterRenderModule mod_menu (topmenu)
Application 0.165 seconds (+0.000); 7.11 MB (-0.006) - beforeRenderModule mod_custom (feedback)
Application 0.165 seconds (+0.000); 7.11 MB (+0.004) - afterRenderModule mod_custom (feedback)
Application 0.165 seconds (+0.000); 7.11 MB (-0.003) - beforeRenderModule mod_custom (SeacoastNH Feedback)
Application 0.165 seconds (+0.000); 7.11 MB (+0.004) - afterRenderModule mod_custom (SeacoastNH Feedback)
Application 0.165 seconds (+0.000); 7.11 MB (-0.003) - beforeRenderModule mod_custom (MainHeader)
Application 0.166 seconds (+0.000); 7.11 MB (+0.004) - afterRenderModule mod_custom (MainHeader)
Application 0.166 seconds (+0.000); 7.11 MB (-0.002) - beforeRenderModule mod_custom (Facebook)
Application 0.166 seconds (+0.000); 7.11 MB (+0.004) - afterRenderModule mod_custom (Facebook)
Application 0.166 seconds (+0.000); 7.11 MB (-0.002) - beforeRenderModule mod_menu (Main Menu)
Application 0.170 seconds (+0.004); 7.18 MB (+0.070) - afterRenderModule mod_menu (Main Menu)
Application 0.170 seconds (+0.000); 7.17 MB (-0.007) - beforeRenderModule mod_custom (Donate to Our Site)
Application 0.170 seconds (+0.000); 7.18 MB (+0.004) - afterRenderModule mod_custom (Donate to Our Site)
Application 0.170 seconds (+0.000); 7.18 MB (-0.003) - beforeRenderModule mod_custom (Feedjit)
Application 0.170 seconds (+0.000); 7.18 MB (+0.004) - afterRenderModule mod_custom (Feedjit)
Application 0.171 seconds (+0.000); 7.18 MB (-0.003) - beforeRenderModule mod_custom (facebook lower logo)
Application 0.171 seconds (+0.000); 7.18 MB (+0.004) - afterRenderModule mod_custom (facebook lower logo)
Application 0.171 seconds (+0.000); 7.22 MB (+0.040) - afterRender
7.23 MB (7,576,760 Bytes)
208 Queries LoggedSELECT `data`
FROM `rabbul_session`
WHERE `session_id` = '9d41f28eac4619beba9d8e4ccf02b13a'SELECT `session_id`
FROM `rabbul_session`
WHERE `session_id` = '9d41f28eac4619beba9d8e4ccf02b13a' LIMIT 0, 1INSERT INTO `rabbul_session`
(`session_id`, `client_id`, `time`) VALUES
('9d41f28eac4619beba9d8e4ccf02b13a', 0, '1793675892')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 = 'in-the-green-room-with-anita-shreve/' AND published='1' LIMIT 1SELECT id FROM rabbul_menu WHERE alias='in-the-green-room-with-anita-shreve' AND published=1SELECT id
FROM rabbul_categories
WHERE path='in-the-green-room-with-anita-shreve' AND extension='com_content'SELECT id,catid
FROM rabbul_content
WHERE alias='in-the-green-room-with-anita-shreve' AND state>0SELECT id,catid
FROM rabbul_content
WHERE alias='in-the-green-room-with-anita-shreve' AND state>0SELECT id
FROM rabbul_menu
WHERE type='component' AND published='1' AND link LIKE 'index.php?option=com_content&view=article%&id=2189'
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 = 2189 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-03 03:18:12') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-03 03:18:12') 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 = 2189UPDATE rabbul_content SET hits = hits + 1 WHERE id = 2189SELECT 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:18:12') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-11-03 03:18:12') 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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:18:12' >= `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:1793675892;s:18:\"session.timer.last\";i:1793675892;s:17:\"session.timer.now\";i:1793675892;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` = '1793675892'
WHERE `session_id` = '9d41f28eac4619beba9d8e4ccf02b13a'
54 Query Types Logged, Sorted by Occurrences.SELECT Tables:40 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROM rabbul_banners as a LEFT JOIN rabbul_banner_clients AS cl ON cl.id = a.cid LEFT JOIN rabbul_categories as cat ON a.catid = cat.id21 × SELECT * FROM rabbul_banners18 × SELECT b.alias AS banner FROM rabbul_banners AS b15 × SELECT id FROM rabbul_assets14 × SELECT `count` FROM rabbul_banner_tracks11 × SELECT link FROM rabbul_menu7 × SELECT path FROM rabbul_categories4 × SELECT extension_id AS id, element AS "option", params, enabled FROM rabbul_extensions3 × SELECT id FROM rabbul_menu3 × SELECT * FROM rabbul_banners3 × SELECT a.alias AS article FROM rabbul_content AS a2 × SELECT b.rules FROM rabbul_assets AS a LEFT JOIN rabbul_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt2 × SELECT id,catid FROM rabbul_content2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROM rabbul_banners as a LEFT JOIN rabbul_banner_clients AS cl ON cl.id = a.cid2 × SELECT `ip`,`reason` FROM rabbul_rsfirewall_lists1 × SELECT * FROM rabbul_languages1 × SELECT * FROM rabbul_rsfirewall_exceptions1 × SELECT id, home, template, s.params FROM rabbul_template_styles as s LEFT JOIN rabbul_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM rabbul_modules AS m LEFT JOIN rabbul_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN rabbul_extensions AS e ON e.element = m.module AND e.client_id = m.client_id1 × SELECT name FROM `rabbul_extensions`1 × SELECT `title` FROM `rabbul_finder_taxonomy`1 × SELECT * FROM rabbul_rsfirewall_snapshots1 × SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM rabbul_categories as c LEFT JOIN rabbul_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM rabbul_categories AS cat JOIN rabbul_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id FROM rabbul_contact_details AS contact1 × SELECT a.rules FROM rabbul_assets AS a1 × SELECT rules FROM rabbul_assets1 × SELECT `value` FROM `rabbul_admintools_storage`1 × SELECT `path` FROM rabbul_rsfirewall_ignored1 × SELECT `file` FROM rabbul_rsfirewall_hashes1 × SELECT `query` FROM `rabbul_admintools_wafexceptions`1 × SELECT folder AS type, element AS name, params FROM rabbul_extensions1 × SELECT `session_id` FROM `rabbul_session`1 × SELECT b.id FROM rabbul_usergroups AS a LEFT JOIN rabbul_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt1 × SELECT id, rules FROM `rabbul_viewlevels1 × SELECT * FROM rabbul_rsfirewall_configuratio1 × SELECT * FROM rabbul_sef_config1 × SELECT parent.id, parent.lft, parent.rgt FROM rabbul_usergroups AS parent1 × SELECT `data` FROM `rabbul_session`1 × SELECT u.* FROM rabbul_user_usergroup_map m RIGHT JOIN rabbul_users u ON (u.id=m.user_id)1 × SELECT `id` FROM `rabbul_usergroups1 × SELECT id FROM rabbul_categories1 × SELECT non_sef_url,alias FROM rabbul_sef_alias1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM rabbul_menu AS m LEFT JOIN rabbul_extensions AS e ON m.component_id = e.extension_id1 × SELECT * FROM rabbul_sef_redirect1 × SELECT * FROM rabbul_rsfirewall_hashes
OTHER Tables:15 × UPDATE rabbul_banners SET impmade = (impmade + 1)7 × UPDATE rabbul_banner_tracks SET `count` = (`count` + 1)3 × UPDATE `rabbul_banners` SET `impmade` = (`impmade` + 1)1 × UPDATE `rabbul_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1793675892;s:18:\"session.timer.last\";i:1793675892;s:17:\"session.timer.now\";i:1793675892;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` = '1793675892'1 × UPDATE rabbul_content SET hits = hits + 11 × SHOW FULL COLUMNS FROM `rabbul_sef_config1 × SHOW FULL COLUMNS FROM `rabbul_assets1 × SHOW FULL COLUMNS FROM `rabbul_rsfirewall_logs1 × INSERT INTO `rabbul_session` (`session_id`, `client_id`, `time`) VALUES ('9d41f28eac4619beba9d8e4ccf02b13a', 0, '1793675892'
|