{ "__default": { "session": { "counter": 1, "timer": { "start": 1713461389, "last": 1713461389, "now": 1713461389 } }, "registry": { "current_theme": null, "current_direction": "ltr", "current_key_sufix": "__ltr", "com_categories": { "categories": { "filter": { "extension": "com_droppics" } } }, "list": { "limit": 10000 }, "com_droppics": { "categories": { "ordercol": null } } }, "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\/latest-issue-north-fulton\/north-fulton-family-life-october-2015", "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", " ", ".", ",", ";", "!", "?", "|", "\\", "\"", "\/", "<", ">", "^", "~", "`", "[", "]", "{", "}", "=", "+", "-", "_", "(", ")", "@", "#", "$", "%", "&", "*" ] } } } }
SELECT `data` FROM `trsst_session` WHERE `session_id` = X'3565313834323332653334613034636138366666386235623664393830323965'
SELECT `session_id` FROM `trsst_session` WHERE `session_id` = X'3565313834323332653334613034636138366666386235623664393830323965' LIMIT 1
INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3565313834323332653334613034636138366666386235623664393830323965', 1, 1713461389, 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.141.31.209'
SELECT `ip` FROM `trsst_admintools_ipblock`
SELECT * FROM `trsst_admintools_storage` WHERE `key` LIKE 'timestamp_%'
SELECT `source`,`keepurlparams` FROM `trsst_admintools_redirects` WHERE ((`dest` = 'latest-issue-north-fulton/north-fulton-family-life-october-2015') OR (`dest` = 'latest-issue-north-fulton/north-fulton-family-life-october-2015') OR ('latest-issue-north-fulton/north-fulton-family-life-october-2015' 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('/latest-issue-north-fulton/north-fulton-family-life-october-2015' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( (CAST('/latest-issue-north-fulton/north-fulton-family-life-october-2015' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only<>0) ) OR ( (CAST('https://www.familylifemagazines.com/latest-issue-north-fulton/north-fulton-family-life-october-2015' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only=0) ) OR ( (CAST('https://www.familylifemagazines.com/latest-issue-north-fulton/north-fulton-family-life-october-2015' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/latest-issue-north-fulton/north-fulton-family-life-october-2015' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/latest-issue-north-fulton/north-fulton-family-life-october-2015' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://www.familylifemagazines.com/latest-issue-north-fulton/north-fulton-family-life-october-2015' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://www.familylifemagazines.com/latest-issue-north-fulton/north-fulton-family-life-october-2015' 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/latest-issue-north-fulton/north-fulton-family-life-october-2015' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url<>0) ) OR ( (CAST('https://www.familylifemagazines.com/latest-issue-north-fulton/north-fulton-family-life-october-2015' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url=0) ) OR ( ('https://www.familylifemagazines.com/latest-issue-north-fulton/north-fulton-family-life-october-2015' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url<>0) ) OR ( ('https://www.familylifemagazines.com/latest-issue-north-fulton/north-fulton-family-life-october-2015' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url=0) )
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM `trsst_categories` AS `s` INNER JOIN `trsst_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.published = 1 AND s.id = 497 ORDER BY c.lft
SELECT `id` FROM `trsst_content` WHERE alias = 'north-fulton-family-life-october-2015' AND catid = '497'
SELECT * FROM `trsst_admintools_wafblacklists` WHERE `verb` IN('','GET') AND `option` IN('','com_content') AND `view` IN('','article') AND `task` IN('','article.') 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 `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `trsst_extensions` WHERE `type` = 'library' AND `element` = 'joomla'
UPDATE `trsst_extensions` SET `params` = '{\"mediaversion\":\"03219810740b990bc2a3c87901d701ea\"}' WHERE `type` = 'library' AND `element` = 'joomla'
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 `id`,`name`,`rules`,`parent_id` FROM `trsst_assets` WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
SHOW FULL COLUMNS FROM `trsst_content`
UPDATE trsst_content SET `hits` = (`hits` + 1) WHERE `id` = '928'
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM trsst_content AS a INNER JOIN trsst_categories AS c on c.id = a.catid LEFT JOIN trsst_users AS u on u.id = a.created_by LEFT JOIN trsst_categories as parent ON parent.id = c.parent_id LEFT JOIN trsst_content_rating AS v ON a.id = v.content_id WHERE a.id = 928 AND c.published > 0 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-18 17:29:49') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 17:29:49') AND (a.state = 1 OR a.state =2)
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM `trsst_categories` AS `s` INNER JOIN `trsst_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id = 497 ORDER BY c.lft
SELECT `m`.`tag_id`,`t`.* FROM `trsst_contentitem_tag_map` AS m INNER JOIN `trsst_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 928 AND `t`.`published` = 1 AND t.access IN (1,1,5)
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 17:29:49',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 = 'com_content.article' AND (fc.category_id IS NULL OR fc.category_id IN (497,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 `field_id`,`value` FROM `trsst_fields_values` WHERE `field_id` IN (1) AND `item_id` = '928'
SELECT * FROM `trsst_sppagebuilder` WHERE `extension` = 'com_content' AND `extension_view` = 'article' AND `view_id` = '928' AND `active` = 1
SELECT `metakey` FROM trsst_content where `id`= 928
select `menutype` from trsst_menu where 1=1 and link like '%option=com_content%' and link like '%view=article%' and link like '%id=928%' and link like '%layout=blog%' and `published`=1
select c.`attribs`, c.`metakey`, c.`metadesc`, m.`titletag` from trsst_content c left join trsst_ijseo_metags m on m.id=c.id and m.`mtype`='article' where c.`id`=928
select * from trsst_ijseo_meta_pages where `link`='https://www.familylifemagazines.com/latest-issue-north-fulton/north-fulton-family-life-october-2015'
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 17:29:49') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-18 17:29:49') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 896 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count FROM trsst_content AS a LEFT JOIN trsst_categories AS c ON c.id = a.catid LEFT JOIN trsst_users AS ua ON ua.id = a.created_by LEFT JOIN trsst_users AS uam ON uam.id = a.modified_by LEFT JOIN trsst_categories as parent ON parent.id = c.parent_id LEFT JOIN trsst_content_rating AS v ON a.id = v.content_id WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND c.published = 1 AND a.state = 1 AND a.catid IN (497) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-18 17:29:49') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 17:29:49') ORDER BY publish_up DESC LIMIT 5
SELECT * FROM `trsst_sppagebuilder` WHERE `extension` = 'mod_sppagebuilder' AND `extension_view` = 'module' AND `view_id` = '232'
SELECT enabled FROM `trsst_extensions` WHERE `name` = 'com_easystore'
SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id FROM ( SELECT id,title,level,published,parent_id,lft,rgt FROM trsst_tags WHERE `published` = '1') AS a LEFT JOIN `trsst_tags` AS b ON a.lft > b.lft AND a.rgt < b.rgt WHERE `a`.`level` != '0' ORDER BY a.lft ASC
SELECT a.enabled FROM `trsst_extensions` AS `a` WHERE `a`.`name` = 'com_k2'
SELECT a.enabled FROM `trsst_extensions` AS `a` WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')
SHOW FULL COLUMNS FROM `trsst_extensions`
SELECT * FROM trsst_extensions WHERE `extension_id` = '10134'
SELECT d.type, d.cloud_id, d.params, c.* FROM trsst_categories as c,trsst_dropfiles as d WHERE c.id=d.id AND c.extension='com_dropfiles' AND `d`.`type` IN ('default') ORDER BY c.lft ASC
SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language,l.title AS language_title,uc.name AS editor,d.theme AS theme, d.params,COUNT(p.id) as pictures FROM trsst_categories 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_droppics AS d ON d.id=a.id LEFT JOIN trsst_droppics_pictures AS p ON a.id = p.id_gallery WHERE a.extension = 'com_droppics' GROUP BY a.id ORDER BY a.lft ASC LIMIT 10000
SELECT e.manifest_cache,`e`.`manifest_cache` FROM `trsst_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'
SELECT `a`.`name`,`a`.`css_path` FROM `trsst_sppagebuilder_assets` AS `a` WHERE `a`.`published` = 1
SELECT * FROM trsst_easyblog_configs WHERE `name` = 'config'
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/latest-issue-north-fulton/north-fulton-family-life-october-2015' 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 = '928' AND i.include_in = 1 ) OR ( i.published =1 AND i.include_in = 0 )
10 × select `params` from trsst_ijseo_confi
6 × SELECT e.manifest_cache,`e`.`manifest_cache` FROM `trsst_extensions` AS `e`
4 × SELECT a.enabled FROM `trsst_extensions` AS `a`
3 × SELECT * FROM trsst_extensions
3 × SELECT `template` FROM `trsst_template_styles`
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 `id`,`name`,`rules`,`parent_id` FROM `trsst_assets`
2 × SELECT params FROM `trsst_ijseo_config
2 × select c.`canonical` from trsst_ijseo_canonical c
2 × select * from trsst_ijseo_meta_pages
2 × select c.`attribs`, c.`metakey`, c.`metadesc`, m.`titletag` from trsst_content c left join trsst_ijseo_metags m on m.id=c.id and m.`mtype`='article'
2 × select `menutype` from trsst_menu
2 × SELECT * FROM `trsst_sppagebuilder`
2 × select max(`checkdate`) from trsst_ijseo_keys limit 0,
2 × SELECT enabled FROM `trsst_extensions`
2 × select * from trsst_ijseo_keys as a
2 × SELECT `value` FROM `trsst_admintools_storage`
2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM `trsst_categories` AS `s` INNER JOIN `trsst_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt)
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `trsst_extensions`
1 × SELECT `id` FROM `trsst_content`
1 × SELECT * FROM trsst_easyblog_configs
1 × SELECT d.type, d.cloud_id, d.params, c.* FROM trsst_categories as c,trsst_dropfiles as d
1 × SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language,l.title AS language_title,uc.name AS editor,d.theme AS theme, d.params,COUNT(p.id) as pictures FROM trsst_categories 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_droppics AS d ON d.id=a.id LEFT JOIN trsst_droppics_pictures AS p ON a.id = p.id_gallery
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM trsst_extensions
1 × SELECT `a`.`name`,`a`.`css_path` FROM `trsst_sppagebuilder_assets` AS `a`
1 × SELECT `title` FROM `trsst_finder_taxonomy`
1 × SELECT `name`,`element` FROM `trsst_extensions`
1 × SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id FROM ( SELECT id,title,level,published,parent_id,lft,rgt FROM trsst_tags
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params FROM trsst_modules AS m
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 id, rules FROM `trsst_viewlevels
1 × SELECT manifest_cache FROM trsst_extensions
1 × SELECT `key` FROM trsst_baforms_api
1 × SELECT * FROM `trsst_admintools_wafexceptions`
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 a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count FROM trsst_content AS a LEFT JOIN trsst_categories AS c ON c.id = a.catid LEFT JOIN trsst_users AS ua ON ua.id = a.created_by LEFT JOIN trsst_users AS uam ON uam.id = a.modified_by LEFT JOIN trsst_categories as parent ON parent.id = c.parent_id LEFT JOIN trsst_content_rating AS v ON a.id = v.content_id
1 × SELECT * FROM trsst_rsform_confi
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_languages
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM trsst_content AS a INNER JOIN trsst_categories AS c on c.id = a.catid LEFT JOIN trsst_users AS u on u.id = a.created_by LEFT JOIN trsst_categories as parent ON parent.id = c.parent_id LEFT JOIN trsst_content_rating AS v ON a.id = v.content_id
1 × SELECT `m`.`tag_id`,`t`.* FROM `trsst_contentitem_tag_map` AS m INNER JOIN `trsst_tags` AS t ON `m`.`tag_id` = `t`.`id`
1 × SELECT * FROM ( SELECT * FROM trsst_redj_redirects
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 `session_id` FROM `trsst_session`
1 × SELECT * FROM `trsst_admintools_wafblacklists`
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 `field_id`,`value` FROM `trsst_fields_values`
1 × SELECT `source`,`keepurlparams` FROM `trsst_admintools_redirects`
1 × SELECT `metakey` FROM trsst_content
1 × SELECT * FROM `trsst_admintools_storage`
1 × SELECT `ip` FROM `trsst_admintools_ipblock
1 × SELECT * FROM `trsst_admintools_ipautoban`
1 × SELECT `data` FROM `trsst_session`
1 × INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3565313834323332653334613034636138366666386235623664393830323965', 1, 1713461389, 0, '', 0
1 × UPDATE `trsst_extensions` SET `params` = '{\"mediaversion\":\"03219810740b990bc2a3c87901d701ea\"}'
1 × SHOW FULL COLUMNS FROM `trsst_content
1 × UPDATE trsst_content SET `hits` = (`hits` + 1)
1 × SHOW FULL COLUMNS FROM `trsst_extensions
to your business!