To say 2020 has been challenging would be an understatement. In these unprecedented times, your health, safety, and welfare will always be my top priority. With your help, the City of Roswell staff has worked diligently to help slow the spread of COVID-19 in our community, and we are working with federal, state, and local officials to facilitate a successful come back in 2021.
Though everyone has been affected by the pandemic and its months of quarantining and mandatory shutdowns, our business community has been hit especially hard, which is why I created the Business Recovery Task Force made up of local business owners, Roswell Inc., and the Convention and Visitors Bureau. This group has been working to create business opportunities and make suggestions on how to do business differently to make it through these trying times.One of the initiatives created by the task force is the Come Back Safely Pledge Campaign. The pledge is a promise from businesses, residents, and visitors to assure their neighbors they will take necessary precautions like sanitizing hands, following physical-distancing guidelines, wearing masks, and staying home when feeling ill. These precautions will slow the spread of the virus, which will help build confidence in returning safely to Roswell's businesses. If you haven't taken the pledge yet, please do so at RoswellGov.com/comebacksafely. Your support will help Roswell businesses that are working hard to survive this pandemic.Another positive step was the collaborative effort among Fulton County mayors in securing more CARES Act funding. Together, we were able to increase funding for Fulton County cities from $2.4 million to $25 million. Roswell's share was increased from approximately $390,000 to more than $3.9 million. This effort helped strengthen the relationship among mayors in our county, encouraging us to work together on other initiatives for our citizens. Also, COVID-19 has not stopped the City from delivering the high-quality services residents enjoy, and projects begun before the virus hit have continued. Docs Cafe is one of those projects. Last year, I was at an event at Barrington Hall with Pastor Sabin Strickland, who told me that Doc's Cafe was the first Roswell restaurant to allow African American diners. The City is relocating this important piece of history to 726 Pleasant Hill Street and will eventually open it to the public. Southern Post Project UpdateThe developer has obtained a land disturbance permit for the Southern Post project on SR 9 (aka the Southern Skillet property), and has already removed existing buildings. Four building permits are in the review process, and the developer is waiting on approval before beginning excavations required for construction. As with many projects, the pandemic has slowed its start. Several retail and office space tenants have already signed leases, and the developer is in discussions with other future tenants. Construction is expected to begin sometime in the first quarter of 2021.Like all of you, I look forward to eventually returning to normal activities. I hope we will be able to do that in the coming year. As we look forward to the holiday season, I wish you and your family health, peace, and prosperity. Together, we will make 2021 a better, stronger year for the Roswell community.
{ "__default": { "session": { "counter": 1, "timer": { "start": 1713508149, "last": 1713508149, "now": 1713508149 }, "token": "pdvvNLruQxRfkYyZ4ExDMIXzXJE2lGfZ" }, "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 }, "b405e0e997269b1a894b8b53daccb7de": 1 }, "__easyblog": { "site": { "messages": null } } }
SELECT `data` FROM `trsst_session` WHERE `session_id` = X'3833333337366165633935356237663839363463363264623335353562656632'
SELECT `session_id` FROM `trsst_session` WHERE `session_id` = X'3833333337366165633935356237663839363463363264623335353562656632' LIMIT 1
INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3833333337366165633935356237663839363463363264623335353562656632', 1, 1713508149, 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` = '3.15.221.136'
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/canton/canton-note/roswell-s-positive-progress') OR (`dest` = 'magazines/canton/canton-note/roswell-s-positive-progress') OR ('magazines/canton/canton-note/roswell-s-positive-progress' 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/canton/canton-note/roswell-s-positive-progress' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( (CAST('/magazines/canton/canton-note/roswell-s-positive-progress' 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/canton/canton-note/roswell-s-positive-progress' 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/canton/canton-note/roswell-s-positive-progress' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/magazines/canton/canton-note/roswell-s-positive-progress' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/magazines/canton/canton-note/roswell-s-positive-progress' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://www.familylifemagazines.com/magazines/canton/canton-note/roswell-s-positive-progress' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://www.familylifemagazines.com/magazines/canton/canton-note/roswell-s-positive-progress' 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/canton/canton-note/roswell-s-positive-progress' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url<>0) ) OR ( (CAST('https://www.familylifemagazines.com/magazines/canton/canton-note/roswell-s-positive-progress' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url=0) ) OR ( ('https://www.familylifemagazines.com/magazines/canton/canton-note/roswell-s-positive-progress' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url<>0) ) OR ( ('https://www.familylifemagazines.com/magazines/canton/canton-note/roswell-s-positive-progress' 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` = 'roswell:s-positive-progress'
SELECT * FROM trsst_easyblog_category WHERE `alias` = 'roswell-s-positive-progress'
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\":\"b2617451cebb5bb439a56aa5335f1bd0\"}' 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`='roswell:s-positive-progress'
SELECT `id` FROM `trsst_easyblog_post` WHERE `permalink`='roswell-s-positive-progress'
SELECT * FROM trsst_easyblog_post WHERE `id` = '667'
SELECT * FROM trsst_easyblog_revisions WHERE `id` = '2153'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='667' AND `type`='post'
SELECT * FROM `trsst_easyblog_meta` WHERE `type`='post' AND `content_id`='667'
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-19 06:29:09' 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-19 06:29:09' 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-19 06:29:09' , 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-19 06:29:09', 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-19 06:29:09', 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` = '667' AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '833376aec955b7f8964c62db3555bef2' OR `ip` = '3.15.221.136') 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(667) 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(667) 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(667) 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 (667) 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 (667)
select a.* from `trsst_easyblog_revisions` as a where a.`id` IN ( 2153)
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` = 70
SHOW FULL COLUMNS FROM `trsst_users`
SELECT * FROM `trsst_users` WHERE `id` = 70
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` = 70
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` = '667' 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 (667) and `type` = 'post'
SELECT * FROM trsst_easyblog_meta WHERE `content_id` = '667' 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`='667' 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-19 06:29:09',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 (6,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`= 667
UPDATE trsst_easyblog_post SET `hits` = (`hits` + 1) WHERE `id` = '667'
SELECT `key`,`value` FROM `trsst_easyblog_post_assets` WHERE `post_id`='667'
SELECT COUNT(1) FROM `trsst_easyblog_feeds_history` WHERE `post_id`='667'
select `id` FROM `trsst_easyblog_adsense` where user_id = '70'
SELECT * FROM trsst_easyblog_adsense WHERE `id` = '23'
SELECT `id` FROM `trsst_menu` WHERE ( `link` LIKE 'index.php?option=com_easyblog&view=entry&id=667%' OR `link` LIKE 'index.php?option=com_easyblog&view=entry&id=667%' ) 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(667) AND a.`created` < '2020-11-19 02:24:47' 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(667) AND a.`created` > '2020-11-19 02:24:47' ORDER BY a.`created` ASC LIMIT 1
SELECT * FROM trsst_easyblog_post WHERE `id` = '666'
SELECT * FROM trsst_easyblog_revisions WHERE `id` = '2152'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='666' AND `type`='post'
SELECT * FROM `trsst_easyblog_meta` WHERE `type`='post' AND `content_id`='666'
SELECT * FROM trsst_easyblog_post WHERE `id` = '668'
SELECT * FROM trsst_easyblog_revisions WHERE `id` = '2154'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='668' AND `type`='post'
SELECT * FROM `trsst_easyblog_meta` WHERE `type`='post' AND `content_id`='668'
SELECT COUNT(1) as `voted`, `uid` FROM `trsst_easyblog_ratings` WHERE `uid` IN (666,668) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '833376aec955b7f8964c62db3555bef2' OR `ip` = '3.15.221.136') 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(666,668) 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(666,668) 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(666,668) 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 (666,668) 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 (666,668)
select a.* from `trsst_easyblog_revisions` as a where a.`id` IN ( 2152,2154)
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` IN (67,49)
SELECT * FROM `trsst_users` WHERE `id` = 49
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` = 49
SELECT * FROM `trsst_users` WHERE `id` = 67
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` = 67
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 (666,668) 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 (666,668) 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-19 06:29:09') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 06:29:09') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 816 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
SELECT `group_id` FROM `trsst_user_usergroup_map` WHERE `user_id` = '70'
SELECT * FROM `trsst_easyblog_acl_group` WHERE `content_id` IN (3) 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` = '70' 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 ('667') 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` = '70' 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 ('667')
SELECT COUNT(1) as `voted`, `uid` FROM `trsst_easyblog_ratings` WHERE `uid` IN (693,570,565) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '833376aec955b7f8964c62db3555bef2' OR `ip` = '3.15.221.136') 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(693,570,565) 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(693,570,565) 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(693,570,565) 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 (693,570,565) 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 (693,570,565)
select a.* from `trsst_easyblog_revisions` as a where a.`id` IN ( 2220,2012,2018)
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 (693,570,565) 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 (693,570,565) 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`='693' AND `type`='post'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='570' AND `type`='post'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='565' 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`='667'
SELECT * FROM `trsst_easyblog_composer_blocks`
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`=667
select * from trsst_ijseo_meta_pages where `link`='https://www.familylifemagazines.com/magazines/canton/canton-note/roswell-s-positive-progress'
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/canton/canton-note/roswell-s-positive-progress' 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 = '667' 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 * FROM `trsst_users`
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.* from `trsst_easyblog_revisions` as a
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 `g`.`id`,`g`.`title` FROM `trsst_usergroups` AS g INNER JOIN `trsst_user_usergroup_map` AS m ON m.group_id = g.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 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 count(1) from `trsst_easyblog_post` AS a
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 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 * FROM `trsst_easyblog_composer_blocks
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 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 `key`,`value` FROM `trsst_easyblog_post_assets`
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 COUNT(1) FROM `trsst_easyblog_feeds_history`
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 * FROM `trsst_admintools_wafexceptions`
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 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 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 * FROM trsst_languages
1 × SELECT `data` FROM `trsst_session`
1 × INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3833333337366165633935356237663839363463363264623335353562656632', 1, 1713508149, 0, '', 0
1 × UPDATE `trsst_extensions` SET `params` = '{\"mediaversion\":\"b2617451cebb5bb439a56aa5335f1bd0\"}'
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!