Ball Ground, Georgia — what a great place to live, work, and play! Some like to call this beautiful town the next best thing to the fictional town of Mayberry.On September 27, 1883, the General Assembly of the State of Georgia signed Law No. 401 to incorporate the town of Ball Ground in Cherokee County, which stated, “From and after the passage of this Act, the corporate limits of the town of Ball Ground, Cherokee County, Georgia, shall extend one-half mile in every direction from the present railroad crossing on Gilmer Ferry Road; that it shall be known and distinguished as the town of Ball Ground.”
The Law continued on to convey that, “The government of said town shall be vested in a mayor and five councilmen, to be elected twenty days after the passage of this Act, after giving ten days’ notice in as many as three public places in said town; said mayor and councilmen to be elected annually thereafter on the first Saturday in January; said election to be held and managed by one justice of the peace and two freeholders, and the persons receiving the highest number of votes shall be declared duly elected. The managers of said election shall give certificates of such election to the persons receiving the highest number of votes, which shall be their authority to act.”
So, in January 1884, Captain Patterson H. Lyon was elected mayor. Dr. A.M.F. Hawkins, W.A. Hayes, R.J. Boling, and J. H. Kirby were elected to serve as councilmen, and J. N. Purcell was elected marshal.
Because some years ago many permanent records of the city were destroyed, it would be difficult to discover who or how many mayors or council members have served Ball Ground since Law No. 401 was passed. The earliest book of recorded minutes is dated January 6, 1913 through December 7, 1924. The minutes of 1925 and 1926 are missing as well as 1935-1959.
Ball Ground has certainly come a long way in the past 135 years. If you have visited recently, you know that the corporate limits now extend more than the one-half mile in every direction from the present railroad crossing on Gilmer Ferry Road. Today, the City of Ball Ground covers over six square miles. We have a mayor and five council members who are second to none. A. R. (Rick) Roberts, III has served a total of 27 years as mayor of the City of Ball Ground. According to available records, he is Ball Ground’s longest serving mayor. Under his leadership and the fine group of men and women who have served as council members, Ball Ground has flourished and is certainly “The Place to Be!”
The Ball Ground Historical Society under the leadership of President Nancy Sosebee Madden will be planning a special event later this year to commemorate the City’s 135th Birthday! The Historical Society meets at 7:00pm on the fourth Tuesday of each month at Ball Ground City Hall. You’re invited to join the Society in honoring, protecting, and encouraging the preservation of Ball Ground’s history and heritage.
{ "__default": { "session": { "counter": 1, "timer": { "start": 1713470667, "last": 1713470667, "now": 1713470667 }, "token": "gk7SONvzhHoxlDz3X9497TD0Wzi3aSC7" }, "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'3732303262363362383263633164636330643562386337303935353432346631'
SELECT `session_id` FROM `trsst_session` WHERE `session_id` = X'3732303262363362383263633164636330643562386337303935353432346631' LIMIT 1
INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3732303262363362383263633164636330643562386337303935353432346631', 1, 1713470667, 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.17.150.163'
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/happy-135-birthday-ball-ground') OR (`dest` = 'magazines/canton/canton-note/happy-135-birthday-ball-ground') OR ('magazines/canton/canton-note/happy-135-birthday-ball-ground' LIKE `dest`)) AND `published` = '1' ORDER BY `ordering` DESC LIMIT 1
SELECT * FROM trsst_rsform_config
UPDATE trsst_rsform_config SET `SettingValue`='1713470667' WHERE `SettingName`='deleteafter.last_run'
SELECT `FormId`,`DeleteSubmissionsAfter` FROM `trsst_rsform_forms` WHERE `DeleteSubmissionsAfter` > '0'
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/happy-135-birthday-ball-ground' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( (CAST('/magazines/canton/canton-note/happy-135-birthday-ball-ground' 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/happy-135-birthday-ball-ground' 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/happy-135-birthday-ball-ground' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/magazines/canton/canton-note/happy-135-birthday-ball-ground' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/magazines/canton/canton-note/happy-135-birthday-ball-ground' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://www.familylifemagazines.com/magazines/canton/canton-note/happy-135-birthday-ball-ground' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://www.familylifemagazines.com/magazines/canton/canton-note/happy-135-birthday-ball-ground' 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/happy-135-birthday-ball-ground' 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/happy-135-birthday-ball-ground' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url=0) ) OR ( ('https://www.familylifemagazines.com/magazines/canton/canton-note/happy-135-birthday-ball-ground' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url<>0) ) OR ( ('https://www.familylifemagazines.com/magazines/canton/canton-note/happy-135-birthday-ball-ground' 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` = 'happy:135-birthday-ball-ground'
SELECT * FROM trsst_easyblog_category WHERE `alias` = 'happy-135-birthday-ball-ground'
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\":\"d253bb21d4acf5f353ed678f3800fc8f\"}' 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`='happy:135-birthday-ball-ground'
SELECT `id` FROM `trsst_easyblog_post` WHERE `permalink`='happy-135-birthday-ball-ground'
SELECT * FROM trsst_easyblog_post WHERE `id` = '375'
SELECT * FROM trsst_easyblog_revisions WHERE `id` = '1971'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='375' AND `type`='post'
SELECT * FROM `trsst_easyblog_meta` WHERE `type`='post' AND `content_id`='375'
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 20:04:27' 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 20:04:27' 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 20:04:27' , 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 20:04:27', 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 20:04:27', 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` = '375' AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '7202b63b82cc1dcc0d5b8c70955424f1' OR `ip` = '3.17.150.163') 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(375) 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(375) 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(375) 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 (375) 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 (375)
select a.* from `trsst_easyblog_revisions` as a where a.`id` IN ( 1971)
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` = 63
SHOW FULL COLUMNS FROM `trsst_users`
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 `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` = '375' 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 (375) and `type` = 'post'
SELECT * FROM trsst_easyblog_meta WHERE `content_id` = '375' 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`='375' 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 20:04:27',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`= 375
UPDATE trsst_easyblog_post SET `hits` = (`hits` + 1) WHERE `id` = '375'
SELECT `key`,`value` FROM `trsst_easyblog_post_assets` WHERE `post_id`='375'
SELECT COUNT(1) FROM `trsst_easyblog_feeds_history` WHERE `post_id`='375'
select `id` FROM `trsst_easyblog_adsense` where user_id = '63'
SELECT * FROM trsst_easyblog_adsense WHERE `id` = '16'
SELECT `id` FROM `trsst_menu` WHERE ( `link` LIKE 'index.php?option=com_easyblog&view=entry&id=375%' OR `link` LIKE 'index.php?option=com_easyblog&view=entry&id=375%' ) 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(375) AND a.`created` < '2018-03-26 12:36:39' 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(375) AND a.`created` > '2018-03-26 12:36:39' ORDER BY a.`created` ASC LIMIT 1
SELECT * FROM trsst_easyblog_post WHERE `id` = '454'
SELECT * FROM trsst_easyblog_revisions WHERE `id` = '1713'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='454' AND `type`='post'
SELECT * FROM `trsst_easyblog_meta` WHERE `type`='post' AND `content_id`='454'
SELECT * FROM trsst_easyblog_post WHERE `id` = '604'
SELECT * FROM trsst_easyblog_revisions WHERE `id` = '1715'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='604' AND `type`='post'
SELECT * FROM `trsst_easyblog_meta` WHERE `type`='post' AND `content_id`='604'
SELECT COUNT(1) as `voted`, `uid` FROM `trsst_easyblog_ratings` WHERE `uid` IN (454,604) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '7202b63b82cc1dcc0d5b8c70955424f1' OR `ip` = '3.17.150.163') 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(454,604) 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(454,604) 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(454,604) 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 (454,604) 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 (454,604)
select a.* from `trsst_easyblog_revisions` as a where a.`id` IN ( 1713,1715)
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 (51,46)
SELECT * FROM `trsst_users` WHERE `id` = 46
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` = 46
SELECT * FROM `trsst_users` WHERE `id` = 51
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` = 51
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 (454,604) 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 (454,604) 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 20:04:27') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-18 20:04:27') 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` = '63'
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` = '63' 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 ('375') 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` = '63' 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 ('375')
SELECT COUNT(1) as `voted`, `uid` FROM `trsst_easyblog_ratings` WHERE `uid` IN (855,826,815) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '7202b63b82cc1dcc0d5b8c70955424f1' OR `ip` = '3.17.150.163') 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(855,826,815) 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(855,826,815) 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(855,826,815) 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 (855,826,815) 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 (855,826,815)
select a.* from `trsst_easyblog_revisions` as a where a.`id` IN ( 2659,2557,2528)
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 (855,826,815) 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 (855,826,815) 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`='855' AND `type`='post'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='826' AND `type`='post'
SELECT COUNT(1) FROM `trsst_easyblog_featured` WHERE `content_id`='815' 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`='375'
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`=375
select * from trsst_ijseo_meta_pages where `link`='https://www.familylifemagazines.com/magazines/canton/canton-note/happy-135-birthday-ball-ground'
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/happy-135-birthday-ball-ground' 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 = '375' 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_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,
4 × SELECT * FROM `trsst_easyblog_meta`
3 × select a.* from `trsst_easyblog_revisions` as a
3 × SELECT COUNT(1) as `voted`, `uid` FROM `trsst_easyblog_ratings`
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.*, 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 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.`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 * FROM `trsst_users`
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 * 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 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 `key`,`value` FROM `trsst_easyblog_post_assets`
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 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 `tag_id` FROM `trsst_easyblog_post_tag` AS pt inner join `trsst_easyblog_tag` AS t ON pt.`tag_id` = t.`id`
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 * FROM `trsst_admintools_wafblacklists`
1 × SELECT * FROM `trsst_admintools_ipautoban`
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 * FROM trsst_languages
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_easyblog_acl`
1 × SELECT `session_id` FROM `trsst_session`
1 × SELECT * FROM ( SELECT * FROM trsst_redj_redirects
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 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 `FormId`,`DeleteSubmissionsAfter` FROM `trsst_rsform_forms`
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 `data` FROM `trsst_session`
1 × INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3732303262363362383263633164636330643562386337303935353432346631', 1, 1713470667, 0, '', 0
1 × UPDATE trsst_rsform_config SET `SettingValue`='1713470667'
1 × UPDATE `trsst_extensions` SET `params` = '{\"mediaversion\":\"d253bb21d4acf5f353ed678f3800fc8f\"}'
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!