FRESH STUFF DAILY
Seacoast New Hampshire
& South Coast Maine
|
|
|
|
The Blog With Apologies to General John Stark
|
|
|
SEE ALL SIGNED BOOKS by J. Dennis Robinson click here
|
Seacoast Blog #32 February 11, 2009
It only took me 40 years to find John Stark’s house. It’s right on Elm Street in Manchester, NH, although dwarfed by fancy Victorian homes and, yesterday, half-buried under a snow drift. My brother Brian was still in middle school back in the 1960s when he worked on the prehistoric Indian "dig" where the house once stood, closer to the Merrimack River near Canal Street. I saw the little red house then, but lost track of it. The house moved, and so did I. It found it’s way up toward Elm Street and I ended up in Portsmouth. But I was back in the Queen City yesterday, and at the invitation of the Daughters of the American Revolution, finally found my way inside. (Continued below) READ: More on John Stark This is the boyhood home of General Stark, built around 1736. He stayed here off and on while aligned with Roger’s Rangers, the famous "Indian fighters" of the French and Indian War. At one point the family cape looked over 800 acres. Stark and his wife Molly later moved up River Road where he kept a mill. John and Molly had 8 children when the Revolutionary War began. They had three more when it ended. Stark returned home between the opening initial battles of Lexington and Concord and Bunker Hill, Trenton, Bennington, Saratoga and others. An excellent leader, Stark is credited with the controversial state motto "Live Free or Die" and lived to age 94. 
I was there to speak briefly about John Paul Jones, courtesy of the NH Humanities Council. Jones was a temporary New Hampshire resident whose name has shown much more staying power than Stark’s. Jones is the subject of more than 100 biographies, while Stark has barely half a dozen, three of them published in 2007. I have all three of the latest Stark books and have corresponded with all three authors. My goal is still to include all three in a "dueling Starks" interview, once I read all three volumes – someday. Sorry John, It just hasn’t happened yet. The Molly Stark DAR, like its 3,000 sister organizations, still stands on ancient ceremonies. Meetings open with a prayer, then attendees are asked to recite a patriotic "creed" and sing the national anthem acapella. At least 50 people crowded into the narrow ell of the house yesterday, not bad for an early afternoon on a winter Monday. A 10-year old essay contest winner named Liam spoke first. His patriotic essay on Abraham Lincoln was perfectly constructed and well received. We posed together for photos afterwards and there followed a fancy tea with a home cooked banquet served on china. 
I desperately wanted to see the old house itself, but kept getting drawn into conversation. My digital camera could scarcely eke out the darkened rooms, blocked by the original Indian shutters in the setting sun. The exhibit portion is immaculate, set out in the Colonial Revival style popular early last century, with spinning wheels, open hearths, framed pictures, display cases and dressed manikins. But the Daughters have done a superb job in adding a comfortable basement library that looks like the ideal place to study. I’m still uncertain about "lineage" organizations. Limiting membership only to women who can trace their genealogy to "Americans" of the Revolutionary era seems strange these days. There is a rigidity of form and tradition, an obsession with white Anglo-Saxon blood lines, a religious fervor about the nostalgic perfection of the past, and an Onward Christian Soldiers-type patriotism that makes one nervous. Even George Washington was uncomfortable with the concept of lineage clubs when he refused to join the Society of the Cincinattis back in the late 18th century. But clearly the Stark homestead is in good hands. The house built by Archibald Stark, a Scotts-Irish immigrant farmer, is well cared for. Unfortunately, the house is only open on request. There are, as far as I know, no regular public hours. There is a rough-hewn web site with a very few details, but at yesterday’s meeting we were told there will be more data coming online. Hopefully, there will also be more open hours so the public can enjoy this carefully guarded historic house. John and Molly Stark are well-preserved, but are still largely suspended in time like mummies waiting to be unwrapped. They remain pale white patriotic figures, never yet "fleshed out" or made relevant to we citizens of the 21st century. I posted a single uninspired page about Gen. John Stark online over a decade ago, and that page is still among the Top 2 Google listings. Hopefully the Stark revival is just beginning. When it does, we can be sure, their homestead will be prayerfully preserved. © 2009 J. Dennis Robinson. All rights reserved. Please visit these SeacoastNH.com ad partners.
News about Portsmouth from Fosters.com
With Apologies to General John Stark |
|
|
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.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.046 seconds (+0.046); 3.20 MB (+2.870) - afterInitialise
Application 0.156 seconds (+0.110); 5.01 MB (+1.810) - afterRoute
Application 0.180 seconds (+0.024); 6.13 MB (+1.115) - afterDispatch
Application 0.184 seconds (+0.004); 6.31 MB (+0.188) - beforeRenderModule mod_custom (Footer)
Application 0.185 seconds (+0.001); 6.32 MB (+0.010) - afterRenderModule mod_custom (Footer)
Application 0.185 seconds (+0.000); 6.32 MB (-0.000) - beforeRenderModule mod_banners (Uncle Oscar)
Application 0.191 seconds (+0.006); 6.45 MB (+0.126) - afterRenderModule mod_banners (Uncle Oscar)
Application 0.191 seconds (+0.000); 6.46 MB (+0.016) - beforeRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)
Application 0.194 seconds (+0.003); 6.59 MB (+0.123) - afterRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)
Application 0.195 seconds (+0.000); 6.49 MB (-0.098) - beforeRenderModule mod_novarp (ISC/Star)
Application 0.199 seconds (+0.004); 6.59 MB (+0.102) - afterRenderModule mod_novarp (ISC/Star)
Application 0.199 seconds (+0.000); 6.47 MB (-0.121) - beforeRenderModule mod_banners (Music Hall)
Application 0.201 seconds (+0.002); 6.48 MB (+0.014) - afterRenderModule mod_banners (Music Hall)
Application 0.201 seconds (+0.000); 6.47 MB (-0.009) - beforeRenderModule mod_banners (Maren)
Application 0.204 seconds (+0.003); 6.49 MB (+0.014) - afterRenderModule mod_banners (Maren)
Application 0.205 seconds (+0.000); 6.48 MB (-0.009) - beforeRenderModule mod_banners (Smuttynose Murders)
Application 0.208 seconds (+0.003); 6.49 MB (+0.014) - afterRenderModule mod_banners (Smuttynose Murders)
Application 0.208 seconds (+0.000); 6.48 MB (-0.009) - beforeRenderModule mod_banners (Banner Maine Harbors)
Application 0.210 seconds (+0.002); 6.50 MB (+0.013) - afterRenderModule mod_banners (Banner Maine Harbors)
Application 0.210 seconds (+0.000); 6.49 MB (-0.009) - beforeRenderModule mod_banners (Banner Sanctuary Hair)
Application 0.212 seconds (+0.002); 6.50 MB (+0.013) - afterRenderModule mod_banners (Banner Sanctuary Hair)
Application 0.212 seconds (+0.000); 6.49 MB (-0.009) - beforeRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)
Application 0.214 seconds (+0.002); 6.50 MB (+0.011) - afterRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)
Application 0.214 seconds (+0.000); 6.52 MB (+0.021) - beforeRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)
Application 0.216 seconds (+0.002); 6.59 MB (+0.069) - afterRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)
Application 0.216 seconds (+0.000); 6.50 MB (-0.097) - beforeRenderModule mod_banners (Banner sheraton wedding)
Application 0.217 seconds (+0.002); 6.51 MB (+0.013) - afterRenderModule mod_banners (Banner sheraton wedding)
Application 0.217 seconds (+0.000); 6.50 MB (-0.004) - beforeRenderModule mod_banners (Banner Boating)
Application 0.219 seconds (+0.001); 6.51 MB (+0.008) - afterRenderModule mod_banners (Banner Boating)
Application 0.219 seconds (+0.000); 6.51 MB (-0.005) - beforeRenderModule mod_banners (Banner Harbour arts)
Application 0.220 seconds (+0.001); 6.52 MB (+0.008) - afterRenderModule mod_banners (Banner Harbour arts)
Application 0.220 seconds (+0.000); 6.51 MB (-0.007) - beforeRenderModule mod_custom (Google Ads)
Application 0.221 seconds (+0.000); 6.51 MB (+0.004) - afterRenderModule mod_custom (Google Ads)
Application 0.221 seconds (+0.000); 6.51 MB (-0.002) - beforeRenderModule mod_banners (Banner Newmarket heritage)
Application 0.222 seconds (+0.002); 6.52 MB (+0.008) - afterRenderModule mod_banners (Banner Newmarket heritage)
Application 0.222 seconds (+0.000); 6.51 MB (-0.004) - beforeRenderModule mod_banners (Shoals Marine Ad)
Application 0.227 seconds (+0.005); 6.53 MB (+0.011) - afterRenderModule mod_banners (Shoals Marine Ad)
Application 0.227 seconds (+0.000); 6.52 MB (-0.008) - beforeRenderModule mod_feed (News about Portsmouth from Fosters.com)
Application 0.644 seconds (+0.417); 6.94 MB (+0.425) - afterRenderModule mod_feed (News about Portsmouth from Fosters.com)
Application 0.644 seconds (+0.000); 6.94 MB (-0.001) - beforeRenderModule mod_banners (ad bottom right top)
Application 0.652 seconds (+0.008); 6.96 MB (+0.013) - afterRenderModule mod_banners (ad bottom right top)
Application 0.652 seconds (+0.000); 6.95 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right mid)
Application 0.658 seconds (+0.006); 6.96 MB (+0.014) - afterRenderModule mod_banners (ad bottom right mid)
Application 0.658 seconds (+0.000); 6.95 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right bottom)
Application 0.662 seconds (+0.005); 6.97 MB (+0.014) - afterRenderModule mod_banners (ad bottom right bottom)
Application 0.662 seconds (+0.000); 6.96 MB (-0.008) - beforeRenderModule mod_banners (ad bottom mid top)
Application 0.665 seconds (+0.003); 6.97 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid top)
Application 0.665 seconds (+0.000); 6.96 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid mid)
Application 0.668 seconds (+0.002); 6.98 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid mid)
Application 0.668 seconds (+0.000); 6.97 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid bottom)
Application 0.670 seconds (+0.003); 6.98 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid bottom)
Application 0.671 seconds (+0.000); 6.97 MB (-0.008) - beforeRenderModule mod_banners (ad bottom left top)
Application 0.675 seconds (+0.004); 6.99 MB (+0.014) - afterRenderModule mod_banners (ad bottom left top)
Application 0.675 seconds (+0.000); 6.98 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left mid)
Application 0.678 seconds (+0.003); 6.99 MB (+0.013) - afterRenderModule mod_banners (ad bottom left mid)
Application 0.678 seconds (+0.000); 6.98 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left bottom)
Application 0.680 seconds (+0.002); 6.99 MB (+0.011) - afterRenderModule mod_banners (ad bottom left bottom)
Application 0.681 seconds (+0.000); 6.99 MB (-0.006) - beforeRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)
Application 0.681 seconds (+0.000); 6.99 MB (+0.004) - afterRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)
Application 0.681 seconds (+0.000); 6.99 MB (-0.001) - beforeRenderModule mod_finder (smart_search)
Application 0.697 seconds (+0.016); 7.07 MB (+0.080) - afterRenderModule mod_finder (smart_search)
Application 0.697 seconds (+0.000); 7.06 MB (-0.006) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.700 seconds (+0.003); 7.08 MB (+0.014) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.700 seconds (+0.000); 7.07 MB (-0.005) - beforeRenderModule mod_menu (topmenu)
Application 0.701 seconds (+0.001); 7.09 MB (+0.016) - afterRenderModule mod_menu (topmenu)
Application 0.701 seconds (+0.000); 7.08 MB (-0.006) - beforeRenderModule mod_custom (feedback)
Application 0.702 seconds (+0.000); 7.09 MB (+0.004) - afterRenderModule mod_custom (feedback)
Application 0.702 seconds (+0.000); 7.09 MB (-0.003) - beforeRenderModule mod_custom (SeacoastNH Feedback)
Application 0.702 seconds (+0.000); 7.09 MB (+0.004) - afterRenderModule mod_custom (SeacoastNH Feedback)
Application 0.702 seconds (+0.000); 7.09 MB (-0.003) - beforeRenderModule mod_custom (MainHeader)
Application 0.702 seconds (+0.000); 7.09 MB (+0.004) - afterRenderModule mod_custom (MainHeader)
Application 0.702 seconds (+0.000); 7.09 MB (-0.002) - beforeRenderModule mod_custom (Facebook)
Application 0.703 seconds (+0.000); 7.09 MB (+0.004) - afterRenderModule mod_custom (Facebook)
Application 0.703 seconds (+0.000); 7.09 MB (-0.002) - beforeRenderModule mod_menu (Main Menu)
Application 0.723 seconds (+0.020); 7.16 MB (+0.070) - afterRenderModule mod_menu (Main Menu)
Application 0.723 seconds (+0.000); 7.15 MB (-0.007) - beforeRenderModule mod_custom (Donate to Our Site)
Application 0.724 seconds (+0.000); 7.16 MB (+0.004) - afterRenderModule mod_custom (Donate to Our Site)
Application 0.724 seconds (+0.000); 7.15 MB (-0.003) - beforeRenderModule mod_custom (Feedjit)
Application 0.724 seconds (+0.000); 7.16 MB (+0.004) - afterRenderModule mod_custom (Feedjit)
Application 0.724 seconds (+0.000); 7.16 MB (-0.003) - beforeRenderModule mod_custom (facebook lower logo)
Application 0.724 seconds (+0.000); 7.16 MB (+0.004) - afterRenderModule mod_custom (facebook lower logo)
Application 0.725 seconds (+0.001); 7.20 MB (+0.038) - afterRender
7.2 MB (7,553,096 Bytes)
206 Queries LoggedSELECT `data`
FROM `rabbul_session`
WHERE `session_id` = '452fa4eb715cd5098796533891079d31' DELETE
FROM `rabbul_session`
WHERE `time` < '1746950915' 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 ordering SELECT 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` ASC SELECT `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_configuration SHOW 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 id 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_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDER BY m.lft SELECT * FROM rabbul_sef_redirect WHERE CONVERT(source USING latin1) COLLATE latin1_general_cs = 'today/seacoast-history-blog/with-apologies-to-general-john-stark/' AND published='1' LIMIT 1 SELECT id FROM rabbul_menu WHERE alias='today' AND published=1 SELECT id
FROM rabbul_categories
WHERE path='today/seacoast-history-blog/with-apologies-to-general-john-stark' AND extension='com_content' SELECT id,catid
FROM rabbul_content
WHERE alias='with-apologies-to-general-john-stark' AND state>0 SELECT id,catid
FROM rabbul_content
WHERE alias='with-apologies-to-general-john-stark' AND state>0 SELECT id
FROM rabbul_menu
WHERE type='component' AND published='1' AND link LIKE 'index.php?option=com_content&view=article%&id=2260'
ORDER BY id SELECT id
FROM rabbul_menu
WHERE type='component' AND published='1' AND link LIKE 'index.php?option=com_content&view=categor%&id=258'
ORDER BY id SELECT `id`
FROM `rabbul_usergroups` SELECT parent.id, parent.lft, parent.rgt
FROM rabbul_usergroups AS parent
ORDER BY parent.lft SHOW FULL COLUMNS FROM `rabbul_assets` SELECT id
FROM rabbul_assets
WHERE parent_id = 0 SELECT 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.lft SELECT id
FROM rabbul_assets
WHERE parent_id = 0 SELECT rules
FROM rabbul_assets
WHERE id = '1' SELECT id
FROM rabbul_assets
WHERE parent_id = 0 SELECT id
FROM rabbul_assets
WHERE parent_id = 0 SELECT id
FROM rabbul_assets
WHERE parent_id = 0 SELECT id
FROM rabbul_assets
WHERE parent_id = 0 SELECT id
FROM rabbul_assets
WHERE parent_id = 0 SELECT id
FROM rabbul_assets
WHERE parent_id = 0 SELECT id
FROM rabbul_assets
WHERE parent_id = 0 SELECT id
FROM rabbul_assets
WHERE parent_id = 0 SELECT id
FROM rabbul_assets
WHERE parent_id = 0 SELECT id
FROM rabbul_assets
WHERE parent_id = 0 SELECT id
FROM rabbul_assets
WHERE parent_id = 0 SELECT id
FROM rabbul_assets
WHERE parent_id = 0 SELECT id
FROM rabbul_assets
WHERE parent_id = 0 SELECT 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 ASC SHOW 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`='13.58.115.236' OR `ip` LIKE '%*%') AND `type`='1' AND `published`='1' SELECT `ip`,`reason`
FROM rabbul_rsfirewall_lists
WHERE (`ip`='13.58.115.236' 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 ASC 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_id
WHERE s.client_id = 0 AND e.enabled = 1 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 = 1 SELECT a.rules
FROM rabbul_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft SELECT 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.lft 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 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 = 2260 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-05-11 08:23:35') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-05-11 08:23:35') 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.lft SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 2260 UPDATE rabbul_content SET hits = hits + 1 WHERE id = 2260 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_id
WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-05-11 08:23:35') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-05-11 08:23:35') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 490 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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.ordering 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.ordering LIMIT 0, 1 UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 100 SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=100 AND track_date='2025-05-11 08' SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=100 AND track_date='2025-05-11 08' UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=100 AND track_date='2025-05-11 08' SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 100 SELECT *
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 3 UPDATE `rabbul_banners` SET `impmade` = (`impmade` + 1) WHERE `id` = 79 SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 79 SELECT *
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 2 UPDATE `rabbul_banners` SET `impmade` = (`impmade` + 1) WHERE `id` = 45 SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 45 UPDATE `rabbul_banners` SET `impmade` = (`impmade` + 1) WHERE `id` = 94 SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 94 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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.ordering 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.ordering LIMIT 0, 1 UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 91 SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 91 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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.ordering 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.ordering LIMIT 0, 1 UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 87 SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=87 AND track_date='2025-05-11 08' SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=87 AND track_date='2025-05-11 08' UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=87 AND track_date='2025-05-11 08' SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 87 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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.ordering 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.ordering LIMIT 0, 1 UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 84 SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=84 AND track_date='2025-05-11 08' SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=84 AND track_date='2025-05-11 08' UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=84 AND track_date='2025-05-11 08' SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 84 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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.ordering 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.ordering LIMIT 0, 3 UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 14 SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 14 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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.ordering 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.ordering LIMIT 0, 3 UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 19 SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 19 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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, 3 SELECT *
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 2 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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, 1 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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.ordering 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.ordering LIMIT 0, 3 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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.ordering 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.ordering LIMIT 0, 3 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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, 1 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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, 1 UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 95 SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=95 AND track_date='2025-05-11 08' SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=95 AND track_date='2025-05-11 08' UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=95 AND track_date='2025-05-11 08' SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 95 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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, 4 UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 29 SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 29 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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, 4 UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 30 SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=30 AND track_date='2025-05-11 08' SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=30 AND track_date='2025-05-11 08' UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=30 AND track_date='2025-05-11 08' SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 30 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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, 4 UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 31 SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=31 AND track_date='2025-05-11 08' SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=31 AND track_date='2025-05-11 08' UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=31 AND track_date='2025-05-11 08' SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 31 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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, 4 UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 26 SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 26 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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, 4 UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 27 SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 27 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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, 4 UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 28 SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 28 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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, 4 UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 23 SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=23 AND track_date='2025-05-11 08' SELECT `count`
FROM rabbul_banner_tracks
WHERE track_type=1 AND banner_id=23 AND track_date='2025-05-11 08' UPDATE rabbul_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1 AND banner_id=23 AND track_date='2025-05-11 08' SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 23 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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, 1 UPDATE rabbul_banners
SET impmade = (impmade + 1)
WHERE id = 65 SELECT b.alias AS banner
FROM rabbul_banners AS b
WHERE b.id = 65 SELECT *
FROM rabbul_banners
WHERE '2025-05-11 08:23:35' >= `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, 5 SELECT 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` = 1 SELECT `title`
FROM `rabbul_finder_taxonomy`
WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,1) SELECT link
FROM rabbul_menu
WHERE id=490 SELECT path
FROM rabbul_categories
WHERE id = 258 SELECT link
FROM rabbul_menu
WHERE id=100196 SELECT link
FROM rabbul_menu
WHERE id=100001 SELECT link
FROM rabbul_menu
WHERE id=269 SELECT path
FROM rabbul_categories
WHERE id = 307 SELECT link
FROM rabbul_menu
WHERE id=157 SELECT path
FROM rabbul_categories
WHERE id = 311 SELECT link
FROM rabbul_menu
WHERE id=158 SELECT path
FROM rabbul_categories
WHERE id = 312 SELECT link
FROM rabbul_menu
WHERE id=264 SELECT path
FROM rabbul_categories
WHERE id = 313 SELECT link
FROM rabbul_menu
WHERE id=160 SELECT path
FROM rabbul_categories
WHERE id = 314 SELECT link
FROM rabbul_menu
WHERE id=161 SELECT path
FROM rabbul_categories
WHERE id = 331 SELECT link
FROM rabbul_menu
WHERE id=123 SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 48 SELECT link
FROM rabbul_menu
WHERE id=100014 SELECT a.alias AS article
FROM rabbul_content AS a
WHERE a.id = 3835 UPDATE `rabbul_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1746951815;s:18:\"session.timer.last\";i:1746951815;s:17:\"session.timer.now\";i:1746951815;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` = '1746951815'
WHERE `session_id` = '452fa4eb715cd5098796533891079d31'
52 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.id 21 × SELECT * FROM rabbul_banners 18 × SELECT b.alias AS banner FROM rabbul_banners AS b 15 × SELECT id FROM rabbul_assets 14 × SELECT `count` FROM rabbul_banner_tracks 11 × SELECT link FROM rabbul_menu 7 × SELECT path FROM rabbul_categories 4 × SELECT extension_id AS id, element AS "option", params, enabled FROM rabbul_extensions 3 × SELECT a.alias AS article FROM rabbul_content AS a 3 × SELECT id FROM rabbul_menu 3 × SELECT * FROM rabbul_banners 2 × SELECT b.rules FROM rabbul_assets AS a LEFT JOIN rabbul_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt 2 × SELECT id,catid FROM rabbul_content 2 × 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 2 × SELECT `ip`,`reason` FROM rabbul_rsfirewall_lists 1 × SELECT a.rules FROM rabbul_assets AS a 1 × SELECT b.id FROM rabbul_usergroups AS a LEFT JOIN rabbul_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt 1 × 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 contact 1 × 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_id 1 × 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 1 × SELECT * FROM rabbul_languages 1 × 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_id 1 × SELECT name FROM `rabbul_extensions` 1 × SELECT `title` FROM `rabbul_finder_taxonomy` 1 × SELECT * FROM rabbul_rsfirewall_hashes 1 × SELECT * FROM rabbul_rsfirewall_configuratio 1 × SELECT * FROM rabbul_sef_config 1 × SELECT non_sef_url,alias FROM rabbul_sef_alias 1 × SELECT `file` FROM rabbul_rsfirewall_hashes 1 × SELECT `path` FROM rabbul_rsfirewall_ignored 1 × SELECT folder AS type, element AS name, params FROM rabbul_extensions 1 × SELECT `query` FROM `rabbul_admintools_wafexceptions` 1 × SELECT `value` FROM `rabbul_admintools_storage` 1 × 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_id 1 × SELECT * FROM rabbul_sef_redirect 1 × SELECT u.* FROM rabbul_user_usergroup_map m RIGHT JOIN rabbul_users u ON (u.id=m.user_id) 1 × SELECT `data` FROM `rabbul_session` 1 × SELECT * FROM rabbul_rsfirewall_snapshots 1 × SELECT rules FROM rabbul_assets 1 × SELECT parent.id, parent.lft, parent.rgt FROM rabbul_usergroups AS parent 1 × SELECT id FROM rabbul_categories 1 × SELECT `id` FROM `rabbul_usergroups 1 × SELECT * FROM rabbul_rsfirewall_exceptions
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:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1746951815;s:18:\"session.timer.last\";i:1746951815;s:17:\"session.timer.now\";i:1746951815;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` = '1746951815' 1 × UPDATE rabbul_content SET hits = hits + 1 1 × SHOW FULL COLUMNS FROM `rabbul_sef_config 1 × SHOW FULL COLUMNS FROM `rabbul_assets 1 × SHOW FULL COLUMNS FROM `rabbul_rsfirewall_logs 1 × DELETE FROM `rabbul_session`
|