As a historic mill town with great parks, restaurants, shopping, and access to the Etowah River, Canton offers City officials a unique opportunity to continue to develop this area as a destination for residents and visitors to live, work, and play. Canton is experiencing immense population growth, which has led to an increased demand for housing options. This trend is expected to continue, as it has for the past two decades.
{ "__default": { "session": { "counter": 1, "timer": { "start": 1713433188, "last": 1713433188, "now": 1713433188 }, "token": "DGGHCJWdUrbIdKRY0LSIPilubIe682RL" }, "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 }, "com_contactenhanced": { "isekeywords": { "referer": "https:\/\/www.familylifepublications.com\/magazines\/canton\/canton-note\/canton-a-place-for-everyone-to-call-home", "searchEngine": { "engine": "", "searchPhrase": false }, "all_keywords": [ "" ], "filter_keywords": [ "" ], "params": { "load-instructions": "0", "enable-highlight": "0", "integrate-ce": "1", "exclude": "a,e,i,o,u,an,the,for,is,in,are,was,and,from,of,on,with,this,that,or,these,those" }, "queryString": "", "excludes": [ "a", "e", "i", "o", "u", "an", "the", "for", "is", "in", "are", "was", "and", "from", "of", "on", "with", "this", "that", "or", "these", "those", "us", "be", "have", "not", "he", "as", "do", "you", "he", "she", "we", "me", "will", "my", "a", "e", "i", "o", "u", "an", "the", "for", "is", "in", "are", "was", "and", "from", "of", "on", "with", "this", "that", "or", "these", "those", " ", ".", ",", ";", "!", "?", "|", "\\", "\"", "\/", "<", ">", "^", "~", "`", "[", "]", "{", "}", "=", "+", "-", "_", "(", ")", "@", "#", "$", "%", "&", "*" ] } } }, "__easyblog": { "site": { "messages": null } } }
SELECT `data` FROM `trsst_session` WHERE `session_id` = X'3665353533663438393637663336653264643936363335306162633233333036'
SELECT `session_id` FROM `trsst_session` WHERE `session_id` = X'3665353533663438393637663336653264643936363335306162633233333036' LIMIT 1
INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3665353533663438393637663336653264643936363335306162633233333036', 1, 1713433188, 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.144.252.153'
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/canton-a-place-for-everyone-to-call-home') OR (`dest` = 'magazines/canton/canton-note/canton-a-place-for-everyone-to-call-home') OR ('magazines/canton/canton-note/canton-a-place-for-everyone-to-call-home' 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/canton-a-place-for-everyone-to-call-home' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( (CAST('/magazines/canton/canton-note/canton-a-place-for-everyone-to-call-home' 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/canton-a-place-for-everyone-to-call-home' 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/canton-a-place-for-everyone-to-call-home' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/magazines/canton/canton-note/canton-a-place-for-everyone-to-call-home' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/magazines/canton/canton-note/canton-a-place-for-everyone-to-call-home' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://www.familylifemagazines.com/magazines/canton/canton-note/canton-a-place-for-everyone-to-call-home' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://www.familylifemagazines.com/magazines/canton/canton-note/canton-a-place-for-everyone-to-call-home' 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/canton-a-place-for-everyone-to-call-home' 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/canton-a-place-for-everyone-to-call-home' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url=0) ) OR ( ('https://www.familylifemagazines.com/magazines/canton/canton-note/canton-a-place-for-everyone-to-call-home' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url<>0) ) OR ( ('https://www.familylifemagazines.com/magazines/canton/canton-note/canton-a-place-for-everyone-to-call-home' 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` = 'canton:a-place-for-everyone-to-call-home'
SELECT * FROM trsst_easyblog_category WHERE `alias` = 'canton-a-place-for-everyone-to-call-home'
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\":\"4f580e2ade40dcf824ccf7ec32fcb353\"}' 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`='canton:a-place-for-everyone-to-call-home'
SELECT `id` FROM `trsst_easyblog_post` WHERE `permalink`='canton-a-place-for-everyone-to-call-home'
SELECT * FROM trsst_easyblog_post WHERE `id` = '677'
SELECT * FROM trsst_easyblog_revisions WHERE `id` = '2176'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='677' AND `type`='post'
SELECT * FROM `trsst_easyblog_meta` WHERE `type`='post' AND `content_id`='677'
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 09:39:48' 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 09:39:48' 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 09:39:48' , 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 09:39:48', 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 09:39:48', 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` = '677' AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '6e553f48967f36e2dd966350abc23306' OR `ip` = '3.144.252.153') 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(677) 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(677) 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(677) 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 (677) 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 (677)
select a.* from `trsst_easyblog_revisions` as a where a.`id` IN ( 2176)
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` = 55
SHOW FULL COLUMNS FROM `trsst_users`
SELECT * FROM `trsst_users` WHERE `id` = 55
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` = 55
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` = '677' 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 (677) and `type` = 'post'
SELECT * FROM trsst_easyblog_meta WHERE `content_id` = '677' 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`='677' 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 09:39:48',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 (3,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`= 677
UPDATE trsst_easyblog_post SET `hits` = (`hits` + 1) WHERE `id` = '677'
SELECT `key`,`value` FROM `trsst_easyblog_post_assets` WHERE `post_id`='677'
SELECT COUNT(1) FROM `trsst_easyblog_feeds_history` WHERE `post_id`='677'
select `id` FROM `trsst_easyblog_adsense` where user_id = '55'
SELECT * FROM trsst_easyblog_adsense WHERE `id` = '8'
SELECT `id` FROM `trsst_menu` WHERE ( `link` LIKE 'index.php?option=com_easyblog&view=entry&id=677%' OR `link` LIKE 'index.php?option=com_easyblog&view=entry&id=677%' ) 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(677) AND a.`created` < '2020-12-22 01:04:20' 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(677) AND a.`created` > '2020-12-22 01:04:20' ORDER BY a.`created` ASC LIMIT 1
SELECT * FROM trsst_easyblog_post WHERE `id` = '676'
SELECT * FROM trsst_easyblog_revisions WHERE `id` = '2175'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='676' AND `type`='post'
SELECT * FROM `trsst_easyblog_meta` WHERE `type`='post' AND `content_id`='676'
SELECT * FROM trsst_easyblog_post WHERE `id` = '678'
SELECT * FROM trsst_easyblog_revisions WHERE `id` = '2177'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='678' AND `type`='post'
SELECT * FROM `trsst_easyblog_meta` WHERE `type`='post' AND `content_id`='678'
SELECT COUNT(1) as `voted`, `uid` FROM `trsst_easyblog_ratings` WHERE `uid` IN (676,678) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '6e553f48967f36e2dd966350abc23306' OR `ip` = '3.144.252.153') 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(676,678) 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(676,678) 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(676,678) 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 (676,678) 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 (676,678)
select a.* from `trsst_easyblog_revisions` as a where a.`id` IN ( 2175,2177)
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 (63,69)
SELECT * FROM `trsst_users` WHERE `id` = 63
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` = 63
SELECT * FROM `trsst_users` WHERE `id` = 69
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` = 69
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 (676,678) 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 (676,678) 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 09:39:48') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-18 09:39:48') 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` = '55'
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` = '55' 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 ('677') 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` = '55' 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 ('677')
SELECT COUNT(1) as `voted`, `uid` FROM `trsst_easyblog_ratings` WHERE `uid` IN (816,707,414) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '6e553f48967f36e2dd966350abc23306' OR `ip` = '3.144.252.153') 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(816,707,414) 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(816,707,414) 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(816,707,414) 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 (816,707,414) 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 (816,707,414)
select a.* from `trsst_easyblog_revisions` as a where a.`id` IN ( 2529,2264,2010)
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 (816,707,414) 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 (816,707,414) 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`='816' AND `type`='post'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='707' AND `type`='post'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='414' 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`='677'
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`=677
select * from trsst_ijseo_meta_pages where `link`='https://www.familylifemagazines.com/magazines/canton/canton-note/canton-a-place-for-everyone-to-call-home'
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/canton-a-place-for-everyone-to-call-home' 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 = '677' 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'3665353533663438393637663336653264643936363335306162633233333036', 1, 1713433188, 0, '', 0
1 × UPDATE `trsst_extensions` SET `params` = '{\"mediaversion\":\"4f580e2ade40dcf824ccf7ec32fcb353\"}'
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!