The Ugliest Monument in New England (original) (raw)

session.client.browser ⇒ Deno/2.3.1

password_clear ⇒ groups ⇒

com_rsfirewall.geoip ⇒

link ⇒ http://www.seacoastnh.com/the-ugliest-monument-in-new-england/

Application 0.000 seconds (+0.000); 0.33 MB (+0.328) - afterLoad

Application 0.035 seconds (+0.035); 3.21 MB (+2.882) - afterInitialise

Application 0.155 seconds (+0.120); 5.01 MB (+1.803) - afterRoute

Application 0.192 seconds (+0.036); 6.24 MB (+1.224) - afterDispatch

Application 0.196 seconds (+0.004); 6.42 MB (+0.182) - beforeRenderModule mod_custom (Footer)

Application 0.197 seconds (+0.001); 6.43 MB (+0.010) - afterRenderModule mod_custom (Footer)

Application 0.197 seconds (+0.000); 6.43 MB (-0.000) - beforeRenderModule mod_banners (Uncle Oscar)

Application 0.202 seconds (+0.006); 6.55 MB (+0.125) - afterRenderModule mod_banners (Uncle Oscar)

Application 0.203 seconds (+0.000); 6.57 MB (+0.016) - beforeRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)

Application 0.206 seconds (+0.003); 6.69 MB (+0.123) - afterRenderModule mod_novarp (Piscataqua/Mark Wentworth/Portsmouth Parking)

Application 0.206 seconds (+0.000); 6.59 MB (-0.098) - beforeRenderModule mod_novarp (ISC/Star)

Application 0.209 seconds (+0.003); 6.70 MB (+0.102) - afterRenderModule mod_novarp (ISC/Star)

Application 0.209 seconds (+0.000); 6.57 MB (-0.121) - beforeRenderModule mod_banners (Music Hall)

Application 0.212 seconds (+0.003); 6.59 MB (+0.014) - afterRenderModule mod_banners (Music Hall)

Application 0.212 seconds (+0.000); 6.58 MB (-0.009) - beforeRenderModule mod_banners (Maren)

Application 0.215 seconds (+0.003); 6.59 MB (+0.014) - afterRenderModule mod_banners (Maren)

Application 0.215 seconds (+0.000); 6.58 MB (-0.009) - beforeRenderModule mod_banners (Smuttynose Murders)

Application 0.218 seconds (+0.003); 6.60 MB (+0.014) - afterRenderModule mod_banners (Smuttynose Murders)

Application 0.218 seconds (+0.000); 6.59 MB (-0.009) - beforeRenderModule mod_banners (Banner Maine Harbors)

Application 0.221 seconds (+0.003); 6.60 MB (+0.013) - afterRenderModule mod_banners (Banner Maine Harbors)

Application 0.221 seconds (+0.000); 6.59 MB (-0.009) - beforeRenderModule mod_banners (Banner Sanctuary Hair)

Application 0.224 seconds (+0.002); 6.61 MB (+0.013) - afterRenderModule mod_banners (Banner Sanctuary Hair)

Application 0.224 seconds (+0.000); 6.60 MB (-0.009) - beforeRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)

Application 0.226 seconds (+0.003); 6.61 MB (+0.011) - afterRenderModule mod_banners (Banner Coughlin Rainboth Murphy & Lown)

Application 0.227 seconds (+0.000); 6.63 MB (+0.020) - beforeRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)

Application 0.229 seconds (+0.002); 6.70 MB (+0.069) - afterRenderModule mod_novarp (Gundalow/Portsmouth Harbour Cruises)

Application 0.229 seconds (+0.000); 6.60 MB (-0.097) - beforeRenderModule mod_banners (Banner sheraton wedding)

Application 0.231 seconds (+0.002); 6.61 MB (+0.013) - afterRenderModule mod_banners (Banner sheraton wedding)

Application 0.231 seconds (+0.000); 6.61 MB (-0.004) - beforeRenderModule mod_banners (Banner Boating)

Application 0.233 seconds (+0.002); 6.62 MB (+0.008) - afterRenderModule mod_banners (Banner Boating)

Application 0.233 seconds (+0.000); 6.61 MB (-0.005) - beforeRenderModule mod_banners (Banner Harbour arts)

Application 0.235 seconds (+0.002); 6.62 MB (+0.008) - afterRenderModule mod_banners (Banner Harbour arts)

Application 0.235 seconds (+0.000); 6.61 MB (-0.007) - beforeRenderModule mod_custom (Google Ads)

Application 0.236 seconds (+0.000); 6.62 MB (+0.004) - afterRenderModule mod_custom (Google Ads)

Application 0.236 seconds (+0.000); 6.62 MB (-0.002) - beforeRenderModule mod_banners (Banner Newmarket heritage)

Application 0.238 seconds (+0.002); 6.62 MB (+0.009) - afterRenderModule mod_banners (Banner Newmarket heritage)

Application 0.238 seconds (+0.000); 6.62 MB (-0.004) - beforeRenderModule mod_banners (Shoals Marine Ad)

Application 0.242 seconds (+0.004); 6.63 MB (+0.010) - afterRenderModule mod_banners (Shoals Marine Ad)

Application 0.243 seconds (+0.000); 6.62 MB (-0.008) - beforeRenderModule mod_feed (News about Portsmouth from Fosters.com)

Application 0.333 seconds (+0.090); 7.05 MB (+0.426) - afterRenderModule mod_feed (News about Portsmouth from Fosters.com)

Application 0.333 seconds (+0.000); 7.05 MB (-0.001) - beforeRenderModule mod_banners (ad bottom right top)

Application 0.338 seconds (+0.005); 7.06 MB (+0.013) - afterRenderModule mod_banners (ad bottom right top)

Application 0.338 seconds (+0.000); 7.05 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right mid)

Application 0.343 seconds (+0.005); 7.07 MB (+0.014) - afterRenderModule mod_banners (ad bottom right mid)

Application 0.343 seconds (+0.000); 7.06 MB (-0.009) - beforeRenderModule mod_banners (ad bottom right bottom)

Application 0.348 seconds (+0.005); 7.07 MB (+0.014) - afterRenderModule mod_banners (ad bottom right bottom)

Application 0.348 seconds (+0.000); 7.06 MB (-0.008) - beforeRenderModule mod_banners (ad bottom mid top)

Application 0.351 seconds (+0.003); 7.08 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid top)

Application 0.351 seconds (+0.000); 7.07 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid mid)

Application 0.355 seconds (+0.004); 7.08 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid mid)

Application 0.355 seconds (+0.000); 7.07 MB (-0.009) - beforeRenderModule mod_banners (ad bottom mid bottom)

Application 0.358 seconds (+0.003); 7.09 MB (+0.013) - afterRenderModule mod_banners (ad bottom mid bottom)

Application 0.359 seconds (+0.000); 7.08 MB (-0.008) - beforeRenderModule mod_banners (ad bottom left top)

Application 0.364 seconds (+0.005); 7.09 MB (+0.014) - afterRenderModule mod_banners (ad bottom left top)

Application 0.364 seconds (+0.000); 7.08 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left mid)

Application 0.367 seconds (+0.004); 7.10 MB (+0.013) - afterRenderModule mod_banners (ad bottom left mid)

Application 0.367 seconds (+0.000); 7.09 MB (-0.009) - beforeRenderModule mod_banners (ad bottom left bottom)

Application 0.370 seconds (+0.003); 7.10 MB (+0.011) - afterRenderModule mod_banners (ad bottom left bottom)

Application 0.370 seconds (+0.000); 7.09 MB (-0.006) - beforeRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)

Application 0.370 seconds (+0.000); 7.10 MB (+0.004) - afterRenderModule mod_custom (See All Signed Books by J. Dennis Robinson)

Application 0.370 seconds (+0.000); 7.10 MB (-0.001) - beforeRenderModule mod_finder (smart_search)

Application 0.382 seconds (+0.011); 7.17 MB (+0.079) - afterRenderModule mod_finder (smart_search)

Application 0.382 seconds (+0.000); 7.17 MB (-0.006) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Application 0.384 seconds (+0.002); 7.18 MB (+0.014) - afterRenderModule mod_breadcrumbs (Breadcrumbs)

Application 0.384 seconds (+0.000); 7.18 MB (-0.005) - beforeRenderModule mod_menu (topmenu)

Application 0.385 seconds (+0.001); 7.19 MB (+0.016) - afterRenderModule mod_menu (topmenu)

Application 0.385 seconds (+0.000); 7.19 MB (-0.006) - beforeRenderModule mod_custom (feedback)

Application 0.385 seconds (+0.000); 7.19 MB (+0.004) - afterRenderModule mod_custom (feedback)

Application 0.386 seconds (+0.000); 7.19 MB (-0.003) - beforeRenderModule mod_custom (SeacoastNH Feedback)

Application 0.386 seconds (+0.000); 7.19 MB (+0.004) - afterRenderModule mod_custom (SeacoastNH Feedback)

Application 0.386 seconds (+0.000); 7.19 MB (-0.003) - beforeRenderModule mod_custom (MainHeader)

Application 0.386 seconds (+0.000); 7.19 MB (+0.004) - afterRenderModule mod_custom (MainHeader)

Application 0.386 seconds (+0.000); 7.19 MB (-0.002) - beforeRenderModule mod_custom (Facebook)

Application 0.386 seconds (+0.000); 7.20 MB (+0.004) - afterRenderModule mod_custom (Facebook)

Application 0.387 seconds (+0.000); 7.19 MB (-0.002) - beforeRenderModule mod_menu (Main Menu)

Application 0.414 seconds (+0.027); 7.28 MB (+0.088) - afterRenderModule mod_menu (Main Menu)

Application 0.414 seconds (+0.000); 7.28 MB (-0.007) - beforeRenderModule mod_custom (Donate to Our Site)

Application 0.414 seconds (+0.000); 7.28 MB (+0.004) - afterRenderModule mod_custom (Donate to Our Site)

Application 0.414 seconds (+0.000); 7.28 MB (-0.003) - beforeRenderModule mod_custom (Feedjit)

Application 0.414 seconds (+0.000); 7.28 MB (+0.004) - afterRenderModule mod_custom (Feedjit)

Application 0.415 seconds (+0.000); 7.28 MB (-0.003) - beforeRenderModule mod_custom (facebook lower logo)

Application 0.415 seconds (+0.000); 7.28 MB (+0.004) - afterRenderModule mod_custom (facebook lower logo)

Application 0.415 seconds (+0.001); 7.32 MB (+0.043) - afterRender

228 Queries Logged

  1. SELECT `data` FROM `rabbul_session` WHERE `session_id` **=** '9422bde26cae5f06d6e3504559a09bcd'
  2. SELECT `session_id` FROM `rabbul_session` WHERE `session_id` **=** '9422bde26cae5f06d6e3504559a09bcd' LIMIT 0, 1
  3. INSERT INTO `rabbul_session` (`session_id`, `client_id`, `time`) VALUES('9422bde26cae5f06d6e3504559a09bcd', 0, '1749557966')
  4. SELECT extension_id AS id, element AS "option", params, enabled FROM rabbul_extensions WHERE `type` **=** 'component' AND `element` **=** 'com_users'
  5. 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
  6. SELECT id, rules FROM `rabbul_viewlevels`
  7. 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
  8. SELECT extension_id AS id, element AS "option", params, enabled FROM rabbul_extensions WHERE `type` **=** 'component' AND `element` **=** 'com_languages'
  9. 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
  10. SELECT `value` FROM `rabbul_admintools_storage` WHERE `key` **=** 'cparams'
  11. SELECT `path` FROM rabbul_rsfirewall_ignored WHERE `type`**=**'ignore_folder' OR `type`**=**'ignore_file'
  12. SELECT `file` FROM rabbul_rsfirewall_hashes WHERE `type`**=**'protect'
  13. SELECT ***** FROM rabbul_rsfirewall_configuration
  14. SHOW FULL COLUMNS FROM `rabbul_sef_config`
  15. SELECT ***** FROM rabbul_sef_config WHERE `id` **=** '1'
  16. SELECT non_sef_url,alias FROM rabbul_sef_alias WHERE published**=**'1' ORDER BY id
  17. 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
  18. SELECT ***** FROM rabbul_sef_redirect WHERE CONVERT(source USING latin1) COLLATE latin1_general_cs **=** 'Famous-People/Captain-John-Smith/The-Ugliest-Monument-in-New-England/' AND published**=**'1' LIMIT 1
  19. SELECT id FROM rabbul_menu WHERE alias**=**'Famous-People' AND published**=**1
  20. SELECT id FROM rabbul_categories WHERE path**=**'Famous-People/Captain-John-Smith/The-Ugliest-Monument-in-New-England' AND extension**=**'com_content'
  21. SELECT id,catid FROM rabbul_content WHERE alias**=**'the-ugliest-monument-in-new-england' AND state>0
  22. SELECT id,catid FROM rabbul_content WHERE alias**=**'the-ugliest-monument-in-new-england' AND state>0
  23. SELECT id FROM rabbul_menu WHERE type**=**'component' AND published**=**'1' AND link LIKE 'index.php?option**=**com_content&view**=**article%&id**=**998' ORDER BY id
  24. SELECT id FROM rabbul_menu WHERE type**=**'component' AND published**=**'1' AND link LIKE 'index.php?option**=**com_content&view**=**categor%&id**=**312' ORDER BY id
  25. SELECT `id` FROM `rabbul_usergroups`
  26. SELECT parent.id, parent.lft, parent.rgt FROM rabbul_usergroups AS parent ORDER BY parent.lft
  27. SHOW FULL COLUMNS FROM `rabbul_assets`
  28. SELECT id FROM rabbul_assets WHERE parent_id **=** 0
  29. 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
  30. SELECT id FROM rabbul_assets WHERE parent_id **=** 0
  31. SELECT rules FROM rabbul_assets WHERE id **=** '1'
  32. SELECT id FROM rabbul_assets WHERE parent_id **=** 0
  33. SELECT id FROM rabbul_assets WHERE parent_id **=** 0
  34. SELECT id FROM rabbul_assets WHERE parent_id **=** 0
  35. SELECT id FROM rabbul_assets WHERE parent_id **=** 0
  36. SELECT id FROM rabbul_assets WHERE parent_id **=** 0
  37. SELECT id FROM rabbul_assets WHERE parent_id **=** 0
  38. SELECT id FROM rabbul_assets WHERE parent_id **=** 0
  39. SELECT id FROM rabbul_assets WHERE parent_id **=** 0
  40. SELECT id FROM rabbul_assets WHERE parent_id **=** 0
  41. SELECT id FROM rabbul_assets WHERE parent_id **=** 0
  42. SELECT id FROM rabbul_assets WHERE parent_id **=** 0
  43. SELECT id FROM rabbul_assets WHERE parent_id **=** 0
  44. SELECT id FROM rabbul_assets WHERE parent_id **=** 0
  45. SELECT u.***** FROM rabbul_user_usergroup_map mRIGHT 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
  46. SHOW FULL COLUMNS FROM `rabbul_rsfirewall_logs`
  47. SELECT ***** FROM rabbul_rsfirewall_hashes WHERE (`type`**=**'2.5.28' OR `type`**=**'protect') AND `flag`!**=**'C'
  48. SELECT ***** FROM rabbul_rsfirewall_snapshots WHERE `type`**=**'protect'
  49. SELECT `ip`,`reason` FROM rabbul_rsfirewall_lists WHERE (`ip`**=**'35.236.236.171' OR `ip` LIKE '%*****%') AND `type`**=**'1' AND `published`**=**'1'
  50. SELECT `ip`,`reason` FROM rabbul_rsfirewall_lists WHERE (`ip`**=**'35.236.236.171' OR `ip` LIKE '%*****%') AND `type`**=**'0' AND `published`**=**'1'
  51. SELECT ***** FROM rabbul_rsfirewall_exceptions WHERE `published`**=**'1'
  52. SELECT extension_id AS id, element AS "option", params, enabled FROM rabbul_extensions WHERE `type` **=** 'component' AND `element` **=** 'com_content'
  53. SELECT ***** FROM rabbul_languages WHERE published**=**1 ORDER BY ordering ASC
  54. 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
  55. SELECT a.rules FROM rabbul_assets AS a WHERE (a.id **=** 1) GROUP BY a.id, a.rules, a.lft
  56. 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
  57. 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 **=** 998 AND (a.publish_up **=** '0000-00-00 00:00:00' OR a.publish_up <**=** '2025-06-10 12:19:26') AND (a.publish_down **=** '0000-00-00 00:00:00' OR a.publish_down >**=** '2025-06-10 12:19:26') AND (a.state **=** 1 OR a.state **=**2)
  58. 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**=**312 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
  59. SELECT a.alias AS article FROM rabbul_content AS a WHERE a.id **=** 998
  60. SELECT a.alias AS article FROM rabbul_content AS a WHERE a.id **=** 998
  61. SELECT a.alias AS article FROM rabbul_content AS a WHERE a.id **=** 998
  62. SELECT a.alias AS article FROM rabbul_content AS a WHERE a.id **=** 998
  63. SELECT a.alias AS article FROM rabbul_content AS a WHERE a.id **=** 998
  64. UPDATE rabbul_content SET hits **=** hits + 1 WHERE id **=** 998
  65. SELECT a.alias AS article FROM rabbul_content AS a WHERE a.id **=** 998
  66. SELECT a.alias AS article FROM rabbul_content AS a WHERE a.id **=** 998
  67. 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-06-10 12:19:26') AND (m.publish_down **=** '0000-00-00 00:00:00' OR m.publish_down >**=** '2025-06-10 12:19:26') AND m.access IN (1,1) AND m.client_id **=** 0 AND (mm.menuid **=** 158 OR mm.menuid <**=** 0) ORDER BY m.position, m.ordering
  68. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  69. 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
  70. 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
  71. UPDATE rabbul_banners SET impmade **=** (impmade + 1) WHERE id **=** 100
  72. SELECT `count` FROM rabbul_banner_tracks WHERE track_type**=**1 AND banner_id**=**100 AND track_date**=**'2025-06-10 12'
  73. SELECT `count` FROM rabbul_banner_tracks WHERE track_type**=**1 AND banner_id**=**100 AND track_date**=**'2025-06-10 12'
  74. UPDATE rabbul_banner_tracks SET `count` **=** (`count` + 1) WHERE track_type**=**1 AND banner_id**=**100 AND track_date**=**'2025-06-10 12'
  75. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 100
  76. 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
  77. UPDATE `rabbul_banners` SET `impmade` **=** (`impmade` + 1) WHERE `id` **=** 79
  78. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 79
  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
  80. UPDATE `rabbul_banners` SET `impmade` **=** (`impmade` + 1) WHERE `id` **=** 45
  81. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 45
  82. UPDATE `rabbul_banners` SET `impmade` **=** (`impmade` + 1) WHERE `id` **=** 94
  83. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 94
  84. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  85. 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
  86. 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
  87. UPDATE rabbul_banners SET impmade **=** (impmade + 1) WHERE id **=** 91
  88. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 91
  89. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  90. 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
  91. 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
  92. UPDATE rabbul_banners SET impmade **=** (impmade + 1) WHERE id **=** 87
  93. SELECT `count` FROM rabbul_banner_tracks WHERE track_type**=**1 AND banner_id**=**87 AND track_date**=**'2025-06-10 12'
  94. SELECT `count` FROM rabbul_banner_tracks WHERE track_type**=**1 AND banner_id**=**87 AND track_date**=**'2025-06-10 12'
  95. UPDATE rabbul_banner_tracks SET `count` **=** (`count` + 1) WHERE track_type**=**1 AND banner_id**=**87 AND track_date**=**'2025-06-10 12'
  96. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 87
  97. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  98. 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
  99. 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
  100. UPDATE rabbul_banners SET impmade **=** (impmade + 1) WHERE id **=** 84
  101. SELECT `count` FROM rabbul_banner_tracks WHERE track_type**=**1 AND banner_id**=**84 AND track_date**=**'2025-06-10 12'
  102. SELECT `count` FROM rabbul_banner_tracks WHERE track_type**=**1 AND banner_id**=**84 AND track_date**=**'2025-06-10 12'
  103. UPDATE rabbul_banner_tracks SET `count` **=** (`count` + 1) WHERE track_type**=**1 AND banner_id**=**84 AND track_date**=**'2025-06-10 12'
  104. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 84
  105. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  106. 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
  107. 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
  108. UPDATE rabbul_banners SET impmade **=** (impmade + 1) WHERE id **=** 14
  109. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 14
  110. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  111. 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
  112. 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
  113. UPDATE rabbul_banners SET impmade **=** (impmade + 1) WHERE id **=** 19
  114. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 19
  115. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  116. 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()
  117. 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
  118. 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
  119. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  120. 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()
  121. 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
  122. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  123. 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
  124. 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
  125. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  126. 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
  127. 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
  128. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  129. 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()
  130. 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
  131. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  132. 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()
  133. 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
  134. UPDATE rabbul_banners SET impmade **=** (impmade + 1) WHERE id **=** 95
  135. SELECT `count` FROM rabbul_banner_tracks WHERE track_type**=**1 AND banner_id**=**95 AND track_date**=**'2025-06-10 12'
  136. SELECT `count` FROM rabbul_banner_tracks WHERE track_type**=**1 AND banner_id**=**95 AND track_date**=**'2025-06-10 12'
  137. UPDATE rabbul_banner_tracks SET `count` **=** (`count` + 1) WHERE track_type**=**1 AND banner_id**=**95 AND track_date**=**'2025-06-10 12'
  138. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 95
  139. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  140. 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()
  141. 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
  142. UPDATE rabbul_banners SET impmade **=** (impmade + 1) WHERE id **=** 29
  143. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 29
  144. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  145. 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()
  146. 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
  147. UPDATE rabbul_banners SET impmade **=** (impmade + 1) WHERE id **=** 30
  148. SELECT `count` FROM rabbul_banner_tracks WHERE track_type**=**1 AND banner_id**=**30 AND track_date**=**'2025-06-10 12'
  149. SELECT `count` FROM rabbul_banner_tracks WHERE track_type**=**1 AND banner_id**=**30 AND track_date**=**'2025-06-10 12'
  150. UPDATE rabbul_banner_tracks SET `count` **=** (`count` + 1) WHERE track_type**=**1 AND banner_id**=**30 AND track_date**=**'2025-06-10 12'
  151. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 30
  152. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  153. 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()
  154. 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
  155. UPDATE rabbul_banners SET impmade **=** (impmade + 1) WHERE id **=** 31
  156. SELECT `count` FROM rabbul_banner_tracks WHERE track_type**=**1 AND banner_id**=**31 AND track_date**=**'2025-06-10 12'
  157. SELECT `count` FROM rabbul_banner_tracks WHERE track_type**=**1 AND banner_id**=**31 AND track_date**=**'2025-06-10 12'
  158. UPDATE rabbul_banner_tracks SET `count` **=** (`count` + 1) WHERE track_type**=**1 AND banner_id**=**31 AND track_date**=**'2025-06-10 12'
  159. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 31
  160. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  161. 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()
  162. 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
  163. UPDATE rabbul_banners SET impmade **=** (impmade + 1) WHERE id **=** 26
  164. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 26
  165. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  166. 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()
  167. 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
  168. UPDATE rabbul_banners SET impmade **=** (impmade + 1) WHERE id **=** 27
  169. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 27
  170. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  171. 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()
  172. 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
  173. UPDATE rabbul_banners SET impmade **=** (impmade + 1) WHERE id **=** 28
  174. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 28
  175. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  176. 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()
  177. 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
  178. UPDATE rabbul_banners SET impmade **=** (impmade + 1) WHERE id **=** 23
  179. SELECT `count` FROM rabbul_banner_tracks WHERE track_type**=**1 AND banner_id**=**23 AND track_date**=**'2025-06-10 12'
  180. SELECT `count` FROM rabbul_banner_tracks WHERE track_type**=**1 AND banner_id**=**23 AND track_date**=**'2025-06-10 12'
  181. UPDATE rabbul_banner_tracks SET `count` **=** (`count` + 1) WHERE track_type**=**1 AND banner_id**=**23 AND track_date**=**'2025-06-10 12'
  182. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 23
  183. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  184. 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()
  185. 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
  186. UPDATE rabbul_banners SET impmade **=** (impmade + 1) WHERE id **=** 65
  187. SELECT b.alias AS banner FROM rabbul_banners AS b WHERE b.id **=** 65
  188. SELECT ***** FROM rabbul_banners WHERE '2025-06-10 12:19:26' >**=** `reset` AND `reset` !**=** '0000-00-00 00:00:00' AND `reset`!**=**NULL AND (`checked_out` **=** 0 OR `checked_out` **=** 0)
  189. 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()
  190. 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
  191. SELECT extension_id AS id, element AS "option", params, enabled FROM rabbul_extensions WHERE `type` **=** 'component' AND `element` **=** 'com_finder'
  192. SELECT name FROM `rabbul_extensions` WHERE `type` **=** 'plugin' AND `folder` **=** 'finder' AND `enabled` **=** 1
  193. SELECT `title` FROM `rabbul_finder_taxonomy` WHERE `parent_id` **=** 1 AND `state` **=** 1 AND `access` IN (1,1)
  194. SELECT link FROM rabbul_menu WHERE id**=**158
  195. SELECT path FROM rabbul_categories WHERE id **=** 312
  196. SELECT link FROM rabbul_menu WHERE id**=**100196
  197. SELECT link FROM rabbul_menu WHERE id**=**100001
  198. SELECT link FROM rabbul_menu WHERE id**=**269
  199. SELECT path FROM rabbul_categories WHERE id **=** 307
  200. SELECT link FROM rabbul_menu WHERE id**=**157
  201. SELECT path FROM rabbul_categories WHERE id **=** 311
  202. SELECT link FROM rabbul_menu WHERE id**=**158
  203. SELECT path FROM rabbul_categories WHERE id **=** 312
  204. SELECT link FROM rabbul_menu WHERE id**=**424
  205. SELECT path FROM rabbul_categories WHERE id **=** 155
  206. SELECT link FROM rabbul_menu WHERE id**=**444
  207. SELECT path FROM rabbul_categories WHERE id **=** 152
  208. SELECT link FROM rabbul_menu WHERE id**=**426
  209. SELECT path FROM rabbul_categories WHERE id **=** 157
  210. SELECT link FROM rabbul_menu WHERE id**=**427
  211. SELECT a.alias AS article FROM rabbul_content AS a WHERE a.id **=** 67
  212. SELECT link FROM rabbul_menu WHERE id**=**428
  213. SELECT path FROM rabbul_categories WHERE id **=** 159
  214. SELECT link FROM rabbul_menu WHERE id**=**429
  215. SELECT path FROM rabbul_categories WHERE id **=** 160
  216. SELECT link FROM rabbul_menu WHERE id**=**430
  217. SELECT path FROM rabbul_categories WHERE id **=** 161
  218. SELECT link FROM rabbul_menu WHERE id**=**264
  219. SELECT path FROM rabbul_categories WHERE id **=** 313
  220. SELECT link FROM rabbul_menu WHERE id**=**160
  221. SELECT path FROM rabbul_categories WHERE id **=** 314
  222. SELECT link FROM rabbul_menu WHERE id**=**161
  223. SELECT path FROM rabbul_categories WHERE id **=** 331
  224. SELECT link FROM rabbul_menu WHERE id**=**123
  225. SELECT a.alias AS article FROM rabbul_content AS a WHERE a.id **=** 48
  226. SELECT link FROM rabbul_menu WHERE id**=**100014
  227. SELECT a.alias AS article FROM rabbul_content AS a WHERE a.id **=** 3835
  228. UPDATE `rabbul_session` SET `data` **=** '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1749557966;s🔞\"session.timer.last\";i:1749557966;s:17:\"session.timer.now\";i:1749557966;s:22:\"session.client.browser\";s:10:\"Deno/2.3.1\";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:\"\";s:16:\"com_mailto.links\";a:1:{s:40:\"8800da45b99bb3c630e668e78c76714656c168c8\";O:8:\"stdClass\":2:{s:4:\"link\";s:62:\"http://www.seacoastnh.com/the-ugliest-monument-in-new-england/\";s:6:\"expiry\";i:1749557966;}}}' , `time` **=** '1749557966' WHERE `session_id` **=** '9422bde26cae5f06d6e3504559a09bcd'

54 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 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
  2. 21 × SELECT ***** FROM rabbul_banners
  3. 18 × SELECT link FROM rabbul_menu
  4. 18 × SELECT b.alias AS banner FROM rabbul_banners AS b
  5. 15 × SELECT id FROM rabbul_assets
  6. 14 × SELECT `count` FROM rabbul_banner_tracks
  7. 13 × SELECT path FROM rabbul_categories
  8. 10 × SELECT a.alias AS article FROM rabbul_content AS a
  9. 4 × SELECT extension_id AS id, element AS "option", params, enabled FROM rabbul_extensions
  10. 3 × SELECT id FROM rabbul_menu
  11. 3 × SELECT ***** FROM rabbul_banners
  12. 2 × SELECT id,catid FROM rabbul_content
  13. 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
  14. 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
  15. 2 × SELECT `ip`,`reason` FROM rabbul_rsfirewall_lists
  16. 1 × SELECT ***** FROM rabbul_rsfirewall_exceptions
  17. 1 × SELECT ***** FROM rabbul_languages
  18. 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
  19. 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
  20. 1 × SELECT name FROM `rabbul_extensions`
  21. 1 × SELECT `title` FROM `rabbul_finder_taxonomy`
  22. 1 × SELECT ***** FROM rabbul_rsfirewall_snapshots
  23. 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
  24. 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
  25. 1 × SELECT a.rules FROM rabbul_assets AS a
  26. 1 × SELECT rules FROM rabbul_assets
  27. 1 × SELECT `value` FROM `rabbul_admintools_storage`
  28. 1 × SELECT `path` FROM rabbul_rsfirewall_ignored
  29. 1 × SELECT `file` FROM rabbul_rsfirewall_hashes
  30. 1 × SELECT `query` FROM `rabbul_admintools_wafexceptions`
  31. 1 × SELECT folder AS type, element AS name, params FROM rabbul_extensions
  32. 1 × SELECT `session_id` FROM `rabbul_session`
  33. 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
  34. 1 × SELECT id, rules FROM `rabbul_viewlevels
  35. 1 × SELECT ***** FROM rabbul_rsfirewall_configuratio
  36. 1 × SELECT ***** FROM rabbul_sef_config
  37. 1 × SELECT parent.id, parent.lft, parent.rgt FROM rabbul_usergroups AS parent
  38. 1 × SELECT `data` FROM `rabbul_session`
  39. 1 × SELECT u.***** FROM rabbul_user_usergroup_map m RIGHT JOIN rabbul_users u ON (u.id**=**m.user_id)
  40. 1 × SELECT `id` FROM `rabbul_usergroups
  41. 1 × SELECT id FROM rabbul_categories
  42. 1 × SELECT non_sef_url,alias FROM rabbul_sef_alias
  43. 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
  44. 1 × SELECT ***** FROM rabbul_sef_redirect
  45. 1 × SELECT ***** FROM rabbul_rsfirewall_hashes
OTHER Tables:
  1. 15 × UPDATE rabbul_banners SET impmade **=** (impmade + 1)
  2. 7 × UPDATE rabbul_banner_tracks SET `count` **=** (`count` + 1)
  3. 3 × UPDATE `rabbul_banners` SET `impmade` **=** (`impmade` + 1)
  4. 1 × UPDATE `rabbul_session` SET `data` **=** '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1749557966;s🔞\"session.timer.last\";i:1749557966;s:17:\"session.timer.now\";i:1749557966;s:22:\"session.client.browser\";s:10:\"Deno/2.3.1\";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:\"\";s:16:\"com_mailto.links\";a:1:{s:40:\"8800da45b99bb3c630e668e78c76714656c168c8\";O:8:\"stdClass\":2:{s:4:\"link\";s:62:\"http://www.seacoastnh.com/the-ugliest-monument-in-new-england/\";s:6:\"expiry\";i:1749557966;}}}' , `time` **=** '1749557966'
  5. 1 × UPDATE rabbul_content SET hits **=** hits + 1
  6. 1 × SHOW FULL COLUMNS FROM `rabbul_sef_config
  7. 1 × SHOW FULL COLUMNS FROM `rabbul_assets
  8. 1 × SHOW FULL COLUMNS FROM `rabbul_rsfirewall_logs
  9. 1 × INSERT INTO `rabbul_session` (`session_id`, `client_id`, `time`) VALUES ('9422bde26cae5f06d6e3504559a09bcd', 0, '1749557966'