Join the City of Woodstock’s efforts to continue its commitment to “go green” on Saturday, April 22nd. The day will begin with a recycling event at Woodstock Elementary School, 230 Rope Mill Road, from 9:00am-1:00pm. Drive through and City staff and volunteers will unload your recycling for you!
Electronics - Cell Phones - BatteriesAll equipment will be broken down and processed by Secure Recycling, so it can be re-used. This will lessen demands on local landfills and keep toxins from leaking into our soil and waterways! All collections will be done free-of-charge, with the exception of the following:
CRT TVs and CRT monitors — $10Projection Wood TVs — $25 LCD monitors with a broken screen — $5
Cell phones will be collected for the Cell Phones for Soldiers program. Each donated cell phone provides a soldier overseas with sixty minutes of prepaid calling service, so they may call their families back home.
Compact Fluorescent Light Bulbs - Hearing Aids - Eyeglasses - Magazines/NewspapersLight bulbs must be in a clear, plastic, sealed bag. We can no longer accept the long, tubular style of fluorescent light bulbs. Home Depot stores will accept compact fluorescent light bulbs all year long!
Clothing - Shoes - Belts - Hats - Bedding - Towels - Curtains - Purses - BackpacksWe have teamed up with USAgain to recycle textiles, which will reduce landfill waste, emission gases and save water.
Document DestructionGeorgia Document Destruction will be onsite to shred all your confidential documents. There will be a limit of five boxes per car. For business shredding service, please call Georgia Document Destruction at 770-516-6500.
The Great American Cleanup organizes millions of volunteers in activities that encourage individual stewardship for the environment and care for the community. In conjunction with Earth Week, residents are encouraged, city-wide, to hold yard sales! Join the Citywide Yard Sale, Saturday, April 22-Sunday, April 23. Sign up at WoodstockGa.gov, Department: Parks and Recreation, then click on Special Events to have your yard sale added to the list on our website, flyer, e-mail blast, CraigsList.com and newspaper ads at no charge. The deadline is April 12th.
During the week of April 17-21, there will be a special trash pick-up of used appliances, large items and scrap metal by Waste Management. These items will be picked up on your normal trash pickup day. No construction debris please, and this is for City of Woodstock residents only.
For questions, please contact Marybeth Stockdale at 770-592-6000, extension 1952.
{ "__default": { "session": { "counter": 1, "timer": { "start": 1713451435, "last": 1713451435, "now": 1713451435 }, "token": "BxXes09ROXapp1JmQv95mqJpAiqkBBdX" }, "registry": { "current_theme": null, "current_direction": "ltr", "current_key_sufix": "__ltr" }, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 } }, "__easyblog": { "site": { "messages": null } } }
SELECT `data` FROM `trsst_session` WHERE `session_id` = X'6133613831656639393933343966666164343661643866363137343764653336'
SELECT `session_id` FROM `trsst_session` WHERE `session_id` = X'6133613831656639393933343966666164343661643866363137343764653336' LIMIT 1
INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6133613831656639393933343966666164343661643866363137343764653336', 1, 1713451435, 0, '', 0)
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `trsst_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
SELECT id, rules FROM `trsst_viewlevels`
SELECT b.id FROM trsst_usergroups AS a LEFT JOIN trsst_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 14
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM trsst_extensions WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering
SELECT `value` FROM `trsst_admintools_storage` WHERE `key` = 'cparams'
SELECT * FROM `trsst_admintools_wafexceptions` WHERE NOT(`option` LIKE 'com_%')
SELECT `template` FROM `trsst_template_styles` WHERE `client_id` = 0 AND `home` = 1
SELECT * FROM `trsst_admintools_ipautoban` WHERE `ip` = '18.188.175.182'
SELECT `ip` FROM `trsst_admintools_ipblock`
SELECT * FROM `trsst_admintools_storage` WHERE `key` LIKE 'timestamp_%'
SELECT `source`,`keepurlparams` FROM `trsst_admintools_redirects` WHERE ((`dest` = 'magazines/woodstock/woodstock-note/greenstock-day') OR (`dest` = 'magazines/woodstock/woodstock-note/greenstock-day') OR ('magazines/woodstock/woodstock-note/greenstock-day' LIKE `dest`)) AND `published` = '1' ORDER BY `ordering` DESC LIMIT 1
SELECT * FROM trsst_rsform_config
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 trsst_menu AS m LEFT JOIN trsst_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 ( SELECT * FROM trsst_redj_redirects WHERE ( ( (CAST('/magazines/woodstock/woodstock-note/greenstock-day' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( (CAST('/magazines/woodstock/woodstock-note/greenstock-day' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only<>0) ) OR ( (CAST('https://www.familylifemagazines.com/magazines/woodstock/woodstock-note/greenstock-day' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only=0) ) OR ( (CAST('https://www.familylifemagazines.com/magazines/woodstock/woodstock-note/greenstock-day' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/magazines/woodstock/woodstock-note/greenstock-day' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/magazines/woodstock/woodstock-note/greenstock-day' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://www.familylifemagazines.com/magazines/woodstock/woodstock-note/greenstock-day' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://www.familylifemagazines.com/magazines/woodstock/woodstock-note/greenstock-day' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only=0) ) ) AND published=1 ORDER BY ordering ) AS A WHERE A.skip='' OR ( (CAST('https://www.familylifemagazines.com/magazines/woodstock/woodstock-note/greenstock-day' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url<>0) ) OR ( (CAST('https://www.familylifemagazines.com/magazines/woodstock/woodstock-note/greenstock-day' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url=0) ) OR ( ('https://www.familylifemagazines.com/magazines/woodstock/woodstock-note/greenstock-day' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url<>0) ) OR ( ('https://www.familylifemagazines.com/magazines/woodstock/woodstock-note/greenstock-day' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url=0) )
SELECT * FROM trsst_easyblog_configs WHERE `name` = 'config'
SELECT * FROM trsst_easyblog_category WHERE `alias` = 'greenstock:day'
SELECT * FROM trsst_easyblog_category WHERE `alias` = 'greenstock-day'
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `trsst_extensions` WHERE `type` = 'library' AND `element` = 'joomla'
UPDATE `trsst_extensions` SET `params` = '{\"mediaversion\":\"b93d40a52771c13401890f74ebeb8521\"}' WHERE `type` = 'library' AND `element` = 'joomla'
SELECT * FROM `trsst_easyblog_acl` WHERE `published`='1' ORDER BY `id` ASC
SELECT * FROM `trsst_easyblog_acl_group` WHERE `content_id` IN (1, 14) AND `type`=' group'
SELECT `id` FROM `trsst_easyblog_post` WHERE `permalink`='greenstock:day'
SELECT `id` FROM `trsst_easyblog_post` WHERE `permalink`='greenstock-day'
SELECT * FROM trsst_easyblog_post WHERE `id` = '442'
SELECT * FROM trsst_easyblog_revisions WHERE `id` = '1612'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='442' AND `type`='post'
SELECT * FROM `trsst_easyblog_meta` WHERE `type`='post' AND `content_id`='442'
SELECT * FROM `trsst_admintools_wafblacklists` WHERE `verb` IN('','GET') AND `option` IN('','com_easyblog') AND `view` IN('','entry') AND `task` IN('','entry.') AND `enabled` = '1' GROUP BY `query` ORDER BY `query` ASC
SELECT id, home, template, s.params FROM trsst_template_styles as s LEFT JOIN trsst_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 * FROM trsst_languages WHERE published=1 ORDER BY ordering ASC
SELECT `id`,`name`,`rules`,`parent_id` FROM `trsst_assets` WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_baforms','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_cjlib','com_communitysurveys','com_config','com_contact','com_contactenhanced','com_content','com_contenthistory','com_cpanel','com_dropfiles','com_droppics','com_easyblog','com_eventbooking','com_fields','com_finder','com_ijoomla_seo','com_installer','com_jaextmanager','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_monthlyarchive','com_mymaplocations','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_redj','com_rsform','com_search','com_smartslider3','com_sppagebuilder','com_tags','com_templates','com_testimonial_pro','com_users','com_vdata','com_watchfulli','com_weblinks','com_wrapper','com_zoo')
SELECT * FROM `trsst_easyblog_post` WHERE `publish_up`<='2024-04-18 14:43:55' AND `published`='2' AND `state`='0' ORDER BY `id` LIMIT 1
SELECT id, created_by FROM`trsst_easyblog_post` WHERE `publish_down` > `publish_up` AND `publish_down` <= '2024-04-18 14:43:55' AND `publish_down` != '0000-00-00 00:00:00' AND `published` = '1' AND `state` = '0'
SELECT * FROM `trsst_easyblog_uploader_tmp` WHERE `created` <= DATE_SUB('2024-04-18 14:43:55' , INTERVAL 120 MINUTE)
SELECT a.`id` FROM `trsst_easyblog_post` as a inner join `trsst_easyblog_revisions` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB('2024-04-18 14:43:55', INTERVAL 3 DAY)
DELETE a, b FROM `trsst_easyblog_post` as a inner join `trsst_easyblog_revisions` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB('2024-04-18 14:43:55', INTERVAL 3 DAY)
SELECT * FROM `trsst_menu` WHERE `published`='1' AND `link` LIKE 'index.php?option=com_easyblog%' AND `client_id` = '0' ORDER BY `id`
SELECT COUNT(1) as `voted`, `uid` FROM `trsst_easyblog_ratings` WHERE `uid` = '442' AND `type`='entry' AND `created_by`='0' AND (`sessionid` = 'a3a81ef999349ffad46ad8f61747de36' OR `ip` = '18.188.175.182') GROUP BY `uid` ORDER BY NULL
SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `trsst_easyblog_ratings` AS a WHERE a.`uid` IN(442) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
SELECT a.* FROM `trsst_easyblog_comment` AS a LEFT JOIN `trsst_users` AS uu ON a.`created_by` = uu.`id` WHERE a.`post_id` IN(442) AND a.`published`='1' AND (uu.`block` = 0 OR uu.`id` IS NULL)
SELECT a.`post_id`, COUNT(1) AS `count` FROM `trsst_easyblog_comment` AS a LEFT JOIN `trsst_users` AS uu ON a.`created_by` = uu.`id` WHERE a.`post_id` IN(442) AND a.`published`='1' AND (uu.`block` = 0 OR uu.`id` IS NULL) GROUP BY a.`post_id`
select a.*, b.`post_id`, b.`primary` from `trsst_easyblog_category` as a inner join `trsst_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN (442) order by a.`lft` asc
select a.*, b.`post_id` from `trsst_easyblog_tag` as a inner join `trsst_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN (442)
select a.* from `trsst_easyblog_revisions` as a where a.`id` IN ( 1612)
select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css`, e.`ordering` from `trsst_users` as u left join `trsst_easyblog_users` as e ON u.`id` = e.`id` where u.`id` = 48
SHOW FULL COLUMNS FROM `trsst_users`
SELECT * FROM `trsst_users` WHERE `id` = 48
SELECT `g`.`id`,`g`.`title` FROM `trsst_usergroups` AS g INNER JOIN `trsst_user_usergroup_map` AS m ON m.group_id = g.id WHERE `m`.`user_id` = 48
select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `trsst_easyblog_category_fields_groups` as a inner join `trsst_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `trsst_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `trsst_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `trsst_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` LEFT JOIN `trsst_easyblog_fields_groups_acl` AS acl ON fg.`id` = acl.`group_id` where `p`.`post_id` = '442' AND ( acl.`acl_id` IN(14) AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )
select * from `trsst_easyblog_meta` where `content_id` in (442) and `type` = 'post'
SELECT * FROM trsst_easyblog_meta WHERE `content_id` = '442' AND `type` = 'post'
SELECT a.`id`, a.`title`, a.`alias` FROM `trsst_easyblog_tag` AS a LEFT JOIN `trsst_easyblog_post_tag` AS b ON a.`id`= b.`tag_id` WHERE b.`post_id`='442' AND b.`isrevision` IS NULL AND a.`published`='1' ORDER BY b.`id` ASC
SELECT enabled FROM `trsst_extensions` WHERE `element` = 'com_sppagebuilder' AND `type` = 'component'
select `params` from trsst_ijseo_config
select max(`checkdate`) from trsst_ijseo_keys limit 0,1
select * from trsst_ijseo_keys as a where 1<=(SELECT DATEDIFF('2024-04-18 14:43:55',a.checkdate)) OR a.checkdate='0000-00-00 00:00:00' order by checkdate asc limit 0,10
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM trsst_fields AS a LEFT JOIN `trsst_languages` AS l ON l.lang_code = a.language LEFT JOIN trsst_users AS uc ON uc.id=a.checked_out LEFT JOIN trsst_viewlevels AS ag ON ag.id = a.access LEFT JOIN trsst_users AS ua ON ua.id = a.created_user_id LEFT JOIN trsst_fields_groups AS g ON g.id = a.group_id LEFT JOIN `trsst_fields_categories` AS fc ON fc.field_id = a.id WHERE a.context = 'easyblog.blog' AND (fc.category_id IS NULL OR fc.category_id IN (10,0)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1) ORDER BY a.ordering ASC
SELECT `metakey` FROM trsst_content where `id`= 442
UPDATE trsst_easyblog_post SET `hits` = (`hits` + 1) WHERE `id` = '442'
SELECT `key`,`value` FROM `trsst_easyblog_post_assets` WHERE `post_id`='442'
SELECT COUNT(1) FROM `trsst_easyblog_feeds_history` WHERE `post_id`='442'
select `id` FROM `trsst_easyblog_adsense` where user_id = '48'
SELECT * FROM trsst_easyblog_adsense WHERE `id` = '5'
SELECT `id` FROM `trsst_menu` WHERE ( `link` LIKE 'index.php?option=com_easyblog&view=entry&id=442%' OR `link` LIKE 'index.php?option=com_easyblog&view=entry&id=442%' ) AND `published`='1' AND (`language`='en-GB' OR `language`='' OR `language`='*') LIMIT 1
SELECT a.`id`, a.`title` FROM `trsst_easyblog_post` AS `a` INNER JOIN `trsst_users` AS uu ON a.`created_by` = uu.`id` and uu.`block` = 0 WHERE a.`published` = '1' AND a.`state` = '0' AND a.`access`='0' AND ( NOT EXISTS ( select acp.post_id from `trsst_easyblog_post_category` as acp inner join `trsst_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 1 and (0 = 0) ) OR ( cat.`private` = 2 and (select count(1) from `trsst_easyblog_category_acl` as cacl where cacl.`category_id` = cat.`id` and cacl.`acl_id` = 1 and cacl.`content_id` IN (14)) = 0 ) ))) AND a.`source_type`='easyblog.sitewide' AND a.`id` NOT IN(442) AND a.`created` < '2017-03-23 19:10:34' ORDER BY a.`created` DESC LIMIT 1
SELECT a.`id`, a.`title` FROM `trsst_easyblog_post` AS `a` INNER JOIN `trsst_users` AS uu ON a.`created_by` = uu.`id` and uu.`block` = 0 WHERE a.`published` = '1' AND a.`state` = '0' AND a.`access`='0' AND ( NOT EXISTS ( select acp.post_id from `trsst_easyblog_post_category` as acp inner join `trsst_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 1 and (0 = 0) ) OR ( cat.`private` = 2 and (select count(1) from `trsst_easyblog_category_acl` as cacl where cacl.`category_id` = cat.`id` and cacl.`acl_id` = 1 and cacl.`content_id` IN (14)) = 0 ) ))) AND a.`source_type`='easyblog.sitewide' AND a.`id` NOT IN(442) AND a.`created` > '2017-03-23 19:10:34' ORDER BY a.`created` ASC LIMIT 1
SELECT * FROM trsst_easyblog_post WHERE `id` = '286'
SELECT * FROM trsst_easyblog_revisions WHERE `id` = '1628'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='286' AND `type`='post'
SELECT * FROM `trsst_easyblog_meta` WHERE `type`='post' AND `content_id`='286'
SELECT * FROM trsst_easyblog_post WHERE `id` = '164'
SELECT * FROM trsst_easyblog_revisions WHERE `id` = '1629'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='164' AND `type`='post'
SELECT * FROM `trsst_easyblog_meta` WHERE `type`='post' AND `content_id`='164'
SELECT COUNT(1) as `voted`, `uid` FROM `trsst_easyblog_ratings` WHERE `uid` IN (286,164) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = 'a3a81ef999349ffad46ad8f61747de36' OR `ip` = '18.188.175.182') GROUP BY `uid` ORDER BY NULL
SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `trsst_easyblog_ratings` AS a WHERE a.`uid` IN(286,164) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
SELECT a.* FROM `trsst_easyblog_comment` AS a LEFT JOIN `trsst_users` AS uu ON a.`created_by` = uu.`id` WHERE a.`post_id` IN(286,164) AND a.`published`='1' AND (uu.`block` = 0 OR uu.`id` IS NULL)
SELECT a.`post_id`, COUNT(1) AS `count` FROM `trsst_easyblog_comment` AS a LEFT JOIN `trsst_users` AS uu ON a.`created_by` = uu.`id` WHERE a.`post_id` IN(286,164) AND a.`published`='1' AND (uu.`block` = 0 OR uu.`id` IS NULL) GROUP BY a.`post_id`
select a.*, b.`post_id`, b.`primary` from `trsst_easyblog_category` as a inner join `trsst_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN (286,164) order by a.`lft` asc
select a.*, b.`post_id` from `trsst_easyblog_tag` as a inner join `trsst_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN (286,164)
select a.* from `trsst_easyblog_revisions` as a where a.`id` IN ( 1628,1629)
select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css`, e.`ordering` from `trsst_users` as u left join `trsst_easyblog_users` as e ON u.`id` = e.`id` where u.`id` = 52
SELECT * FROM `trsst_users` WHERE `id` = 52
SELECT `g`.`id`,`g`.`title` FROM `trsst_usergroups` AS g INNER JOIN `trsst_user_usergroup_map` AS m ON m.group_id = g.id WHERE `m`.`user_id` = 52
select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `trsst_easyblog_category_fields_groups` as a inner join `trsst_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `trsst_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `trsst_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `trsst_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` LEFT JOIN `trsst_easyblog_fields_groups_acl` AS acl ON fg.`id` = acl.`group_id` where p.post_id IN (286,164) AND ( acl.`acl_id` IN(14) AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )
select * from `trsst_easyblog_meta` where `content_id` in (286,164) and `type` = 'post'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM trsst_modules AS m LEFT JOIN trsst_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN trsst_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 <= '2024-04-18 14:43:55') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-18 14:43:55') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 817 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
SELECT `group_id` FROM `trsst_user_usergroup_map` WHERE `user_id` = '48'
SELECT * FROM `trsst_easyblog_acl_group` WHERE `content_id` IN (2, 3, 4, 5, 6, 13) AND `type`=' group'
SELECT a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `trsst_easyblog_post` AS a INNER JOIN `trsst_users` AS uu ON a.`created_by` = uu.`id` and uu.`block` = 0 LEFT JOIN `trsst_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`='1' AND a.`state`='0' AND a.`access` = '0' AND a.`created_by` = '48' AND (a.`author_alias` IS NULL OR a.`author_alias` = '') AND ( NOT EXISTS ( select acp.post_id from `trsst_easyblog_post_category` as acp inner join `trsst_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 1 and (0 = 0) ) OR ( cat.`private` = 2 and (select count(1) from `trsst_easyblog_category_acl` as cacl where cacl.`category_id` = cat.`id` and cacl.`acl_id` = 1 and cacl.`content_id` IN (14)) = 0 ) ))) AND ((a.`source_type` = 'easyblog.sitewide') OR ( a.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `trsst_easyblog_team` as srcteam where srcteam.`id` = a.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `trsst_easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (14) ) > 0))))) AND a.`id` NOT IN ('442') ORDER BY a.`created` desc LIMIT 0,3
select count(1) from `trsst_easyblog_post` AS a WHERE a.`published`='1' AND a.`state`='0' AND a.`access` = '0' AND a.`created_by` = '48' AND (a.`author_alias` IS NULL OR a.`author_alias` = '') AND ( NOT EXISTS ( select acp.post_id from `trsst_easyblog_post_category` as acp inner join `trsst_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 1 and (0 = 0) ) OR ( cat.`private` = 2 and (select count(1) from `trsst_easyblog_category_acl` as cacl where cacl.`category_id` = cat.`id` and cacl.`acl_id` = 1 and cacl.`content_id` IN (14)) = 0 ) ))) AND ((a.`source_type` = 'easyblog.sitewide') OR ( a.`source_type` = 'easyblog.team' and 1 <= (select count(1) from `trsst_easyblog_team` as srcteam where srcteam.`id` = a.`source_id` and srcteam.`published` = 1 and ( (srcteam.`access` = 3) OR (srcteam.`access` = 2 and (select count(1) from `trsst_easyblog_team_groups` as srcteamgrp where srcteamgrp.`team_id` = srcteam.`id` and srcteamgrp.`group_id` IN (14) ) > 0))))) AND a.`id` NOT IN ('442')
SELECT COUNT(1) as `voted`, `uid` FROM `trsst_easyblog_ratings` WHERE `uid` IN (460,181,545) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = 'a3a81ef999349ffad46ad8f61747de36' OR `ip` = '18.188.175.182') GROUP BY `uid` ORDER BY NULL
SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `trsst_easyblog_ratings` AS a WHERE a.`uid` IN(460,181,545) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
SELECT a.* FROM `trsst_easyblog_comment` AS a LEFT JOIN `trsst_users` AS uu ON a.`created_by` = uu.`id` WHERE a.`post_id` IN(460,181,545) AND a.`published`='1' AND (uu.`block` = 0 OR uu.`id` IS NULL)
SELECT a.`post_id`, COUNT(1) AS `count` FROM `trsst_easyblog_comment` AS a LEFT JOIN `trsst_users` AS uu ON a.`created_by` = uu.`id` WHERE a.`post_id` IN(460,181,545) AND a.`published`='1' AND (uu.`block` = 0 OR uu.`id` IS NULL) GROUP BY a.`post_id`
select a.*, b.`post_id`, b.`primary` from `trsst_easyblog_category` as a inner join `trsst_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN (460,181,545) order by a.`lft` asc
select a.*, b.`post_id` from `trsst_easyblog_tag` as a inner join `trsst_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN (460,181,545)
select a.* from `trsst_easyblog_revisions` as a where a.`id` IN ( 1762,1759,1758)
select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `trsst_easyblog_category_fields_groups` as a inner join `trsst_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `trsst_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `trsst_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `trsst_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` LEFT JOIN `trsst_easyblog_fields_groups_acl` AS acl ON fg.`id` = acl.`group_id` where p.post_id IN (460,181,545) AND ( acl.`acl_id` IN(14) AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )
select * from `trsst_easyblog_meta` where `content_id` in (460,181,545) and `type` = 'post'
SELECT `template` FROM `trsst_template_styles` WHERE `home`!='0' AND `client_id`='0'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='460' AND `type`='post'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='181' AND `type`='post'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='545' AND `type`='post'
SELECT `tag_id` FROM `trsst_easyblog_post_tag` AS pt inner join `trsst_easyblog_tag` AS t ON pt.`tag_id` = t.`id` WHERE `post_id`='442'
SELECT c.`description`, c.`keywords`, m.`titletag` FROM trsst_easyblog_meta c LEFT JOIN trsst_ijseo_metags m on m.`id`=c.`content_id` and m.`mtype` = 'easyblog-item' WHERE c.`type` = 'post' and c.`content_id`=442
select * from trsst_ijseo_meta_pages where `link`='https://www.familylifemagazines.com/magazines/woodstock/woodstock-note/greenstock-day'
SELECT `name`,`element` FROM `trsst_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1
SELECT `title` FROM `trsst_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,1,5)
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params FROM trsst_modules AS m WHERE m.id = 207 AND m.published = 1 AND m.access IN (1,1,5)
select c.`canonical` from trsst_ijseo_canonical c where c.`id` = (select `parent_id` from trsst_ijseo_canonical where `link`='https://www.familylifemagazines.com/magazines/woodstock/woodstock-note/greenstock-day' and `parent_id` <> 0 limit 0,1) and c.`state`=1
SELECT `value` FROM `trsst_admintools_storage` WHERE `key` = 'criticalfiles'
SELECT params FROM `trsst_ijseo_config`
SELECT i.* FROM trsst_ijseo_ilinks AS i LEFT JOIN trsst_ijseo_ilinks_articles AS ia ON i.id = ia.ilink_id WHERE ( i.published =1 AND ia.article_id = '' AND i.include_in = 1 ) OR ( i.published =1 AND i.include_in = 0 )
SELECT manifest_cache FROM trsst_extensions WHERE type='component' AND element='com_baforms'
SELECT `key` FROM trsst_baforms_api WHERE service = 'balbooa_activation'
SELECT i.* FROM trsst_ijseo_ilinks AS i LEFT JOIN trsst_ijseo_ilinks_articles AS ia ON i.id = ia.ilink_id WHERE ( i.published =1 AND ia.article_id = '442' AND i.include_in = 1 ) OR ( i.published =1 AND i.include_in = 0 )
16 × select `params` from trsst_ijseo_confi
6 × SELECT COUNT(1) FROM `trsst_easyblog_featured`
4 × SELECT * FROM `trsst_easyblog_meta`
4 × SELECT * FROM trsst_easyblog_revisions
4 × SELECT * FROM trsst_easyblog_post
4 × select * from trsst_ijseo_keys as a
4 × select max(`checkdate`) from trsst_ijseo_keys limit 0,
3 × select a.* from `trsst_easyblog_revisions` as a
3 × SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `trsst_easyblog_ratings` AS a
3 × SELECT a.* FROM `trsst_easyblog_comment` AS a LEFT JOIN `trsst_users` AS uu ON a.`created_by` = uu.`id`
3 × SELECT a.`post_id`, COUNT(1) AS `count` FROM `trsst_easyblog_comment` AS a LEFT JOIN `trsst_users` AS uu ON a.`created_by` = uu.`id`
3 × select a.*, b.`post_id` from `trsst_easyblog_tag` as a inner join `trsst_easyblog_post_tag` as b on a.`id` = b.`tag_id`
3 × select a.*, b.`post_id`, b.`primary` from `trsst_easyblog_category` as a inner join `trsst_easyblog_post_category` as b on a.`id` = b.`category_id`
3 × SELECT COUNT(1) as `voted`, `uid` FROM `trsst_easyblog_ratings`
3 × select * from `trsst_easyblog_meta`
3 × select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `trsst_easyblog_category_fields_groups` as a inner join `trsst_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `trsst_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `trsst_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `trsst_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` LEFT JOIN `trsst_easyblog_fields_groups_acl` AS acl ON fg.`id` = acl.`group_id`
2 × SELECT `g`.`id`,`g`.`title` FROM `trsst_usergroups` AS g INNER JOIN `trsst_user_usergroup_map` AS m ON m.group_id = g.id
2 × SELECT * FROM `trsst_users`
2 × select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css`, e.`ordering` from `trsst_users` as u left join `trsst_easyblog_users` as e ON u.`id` = e.`id`
2 × SELECT `metakey` FROM trsst_content
2 × SELECT a.`id`, a.`title` FROM `trsst_easyblog_post` AS `a` INNER JOIN `trsst_users` AS uu ON a.`created_by` = uu.`id` and uu.`block` = 0
2 × select * from trsst_ijseo_meta_pages
2 × select c.`canonical` from trsst_ijseo_canonical c
2 × SELECT params FROM `trsst_ijseo_config
2 × SELECT i.* FROM trsst_ijseo_ilinks AS i LEFT JOIN trsst_ijseo_ilinks_articles AS ia ON i.id = ia.ilink_id
2 × SELECT `template` FROM `trsst_template_styles`
2 × SELECT `id` FROM `trsst_easyblog_post`
2 × SELECT `value` FROM `trsst_admintools_storage`
2 × SELECT * FROM `trsst_easyblog_acl_group`
2 × SELECT * FROM trsst_easyblog_category
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `trsst_extensions`
1 × SELECT id, rules FROM `trsst_viewlevels
1 × SELECT a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `trsst_easyblog_post` AS a INNER JOIN `trsst_users` AS uu ON a.`created_by` = uu.`id` and uu.`block` = 0 LEFT JOIN `trsst_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post'
1 × SELECT COUNT(1) FROM `trsst_easyblog_feeds_history`
1 × select `id` FROM `trsst_easyblog_adsense`
1 × SELECT * FROM trsst_easyblog_adsense
1 × SELECT `id` FROM `trsst_menu`
1 × SELECT `key` FROM trsst_baforms_api
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM trsst_modules AS m LEFT JOIN trsst_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN trsst_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT `group_id` FROM `trsst_user_usergroup_map`
1 × SELECT `tag_id` FROM `trsst_easyblog_post_tag` AS pt inner join `trsst_easyblog_tag` AS t ON pt.`tag_id` = t.`id`
1 × select count(1) from `trsst_easyblog_post` AS a
1 × SELECT b.id FROM trsst_usergroups AS a LEFT JOIN trsst_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT c.`description`, c.`keywords`, m.`titletag` FROM trsst_easyblog_meta c LEFT JOIN trsst_ijseo_metags m on m.`id`=c.`content_id` and m.`mtype` = 'easyblog-item'
1 × SELECT * FROM `trsst_admintools_wafexceptions`
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM trsst_extensions
1 × SELECT `name`,`element` FROM `trsst_extensions`
1 × SELECT manifest_cache FROM trsst_extensions
1 × SELECT `title` FROM `trsst_finder_taxonomy`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params FROM trsst_modules AS m
1 × SELECT `key`,`value` FROM `trsst_easyblog_post_assets`
1 × SELECT id, home, template, s.params FROM trsst_template_styles as s LEFT JOIN trsst_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM trsst_fields AS a LEFT JOIN `trsst_languages` AS l ON l.lang_code = a.language LEFT JOIN trsst_users AS uc ON uc.id=a.checked_out LEFT JOIN trsst_viewlevels AS ag ON ag.id = a.access LEFT JOIN trsst_users AS ua ON ua.id = a.created_user_id LEFT JOIN trsst_fields_groups AS g ON g.id = a.group_id LEFT JOIN `trsst_fields_categories` AS fc ON fc.field_id = a.id
1 × SELECT * FROM trsst_easyblog_configs
1 × SELECT `id`,`name`,`rules`,`parent_id` FROM `trsst_assets`
1 × SELECT * FROM `trsst_easyblog_post`
1 × SELECT id, created_by FROM`trsst_easyblog_post`
1 × SELECT * FROM `trsst_easyblog_uploader_tmp`
1 × SELECT a.`id` FROM `trsst_easyblog_post` as a inner join `trsst_easyblog_revisions` as b on a.`id` = b.`post_id`
1 × SELECT * FROM `trsst_menu`
1 × SELECT * FROM `trsst_admintools_wafblacklists`
1 × SELECT * FROM `trsst_easyblog_acl`
1 × SELECT `session_id` FROM `trsst_session`
1 × SELECT * FROM ( SELECT * FROM trsst_redj_redirects
1 × SELECT * FROM trsst_languages
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 trsst_menu AS m LEFT JOIN trsst_extensions AS e ON m.component_id = e.extension_id
1 × SELECT * FROM trsst_rsform_confi
1 × SELECT `source`,`keepurlparams` FROM `trsst_admintools_redirects`
1 × SELECT * FROM `trsst_admintools_storage`
1 × SELECT * FROM trsst_easyblog_meta
1 × SELECT a.`id`, a.`title`, a.`alias` FROM `trsst_easyblog_tag` AS a LEFT JOIN `trsst_easyblog_post_tag` AS b ON a.`id`= b.`tag_id`
1 × SELECT enabled FROM `trsst_extensions`
1 × SELECT `ip` FROM `trsst_admintools_ipblock
1 × SELECT * FROM `trsst_admintools_ipautoban`
1 × SELECT `data` FROM `trsst_session`
1 × INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6133613831656639393933343966666164343661643866363137343764653336', 1, 1713451435, 0, '', 0
1 × UPDATE `trsst_extensions` SET `params` = '{\"mediaversion\":\"b93d40a52771c13401890f74ebeb8521\"}'
1 × DELETE a, b FROM `trsst_easyblog_post` as a inner join `trsst_easyblog_revisions` as b on a.`id` = b.`post_id`
1 × SHOW FULL COLUMNS FROM `trsst_users
1 × UPDATE trsst_easyblog_post SET `hits` = (`hits` + 1)
to your business!