{ "__default": { "session": { "counter": 1, "timer": { "start": 1713433003, "last": 1713433003, "now": 1713433003 }, "token": "ifvb9JzVQgip6fWpOfKDFESEOEgGMmjm" }, "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 } } }
SELECT `data` FROM `trsst_session` WHERE `session_id` = X'3565393230653438313538393131303534663335323430326336626463323864'
SELECT `session_id` FROM `trsst_session` WHERE `session_id` = X'3565393230653438313538393131303534663335323430326336626463323864' LIMIT 1
INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3565393230653438313538393131303534663335323430326336626463323864', 1, 1713433003, 0, '', 0)
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `trsst_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
SELECT id, rules FROM `trsst_viewlevels`
SELECT b.id FROM trsst_usergroups AS a LEFT JOIN trsst_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 14
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM trsst_extensions WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering
SELECT `value` FROM `trsst_admintools_storage` WHERE `key` = 'cparams'
SELECT * FROM `trsst_admintools_wafexceptions` WHERE NOT(`option` LIKE 'com_%')
SELECT `template` FROM `trsst_template_styles` WHERE `client_id` = 0 AND `home` = 1
SELECT * FROM `trsst_admintools_ipautoban` WHERE `ip` = '18.220.106.241'
SELECT `ip` FROM `trsst_admintools_ipblock`
SELECT * FROM `trsst_admintools_storage` WHERE `key` LIKE 'timestamp_%'
SELECT `source`,`keepurlparams` FROM `trsst_admintools_redirects` WHERE ((`dest` = 'our-advertisers/1524-landscape-lawn-care/329-grassroots-tree-turf-care') OR (`dest` = 'our-advertisers/1524-landscape-lawn-care/329-grassroots-tree-turf-care') OR ('our-advertisers/1524-landscape-lawn-care/329-grassroots-tree-turf-care' 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('/our-advertisers/1524-landscape-lawn-care/329-grassroots-tree-turf-care' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( (CAST('/our-advertisers/1524-landscape-lawn-care/329-grassroots-tree-turf-care' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only<>0) ) OR ( (CAST('https://www.familylifemagazines.com/our-advertisers/1524-landscape-lawn-care/329-grassroots-tree-turf-care' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only=0) ) OR ( (CAST('https://www.familylifemagazines.com/our-advertisers/1524-landscape-lawn-care/329-grassroots-tree-turf-care' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/our-advertisers/1524-landscape-lawn-care/329-grassroots-tree-turf-care' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/our-advertisers/1524-landscape-lawn-care/329-grassroots-tree-turf-care' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://www.familylifemagazines.com/our-advertisers/1524-landscape-lawn-care/329-grassroots-tree-turf-care' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://www.familylifemagazines.com/our-advertisers/1524-landscape-lawn-care/329-grassroots-tree-turf-care' 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/our-advertisers/1524-landscape-lawn-care/329-grassroots-tree-turf-care' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url<>0) ) OR ( (CAST('https://www.familylifemagazines.com/our-advertisers/1524-landscape-lawn-care/329-grassroots-tree-turf-care' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url=0) ) OR ( ('https://www.familylifemagazines.com/our-advertisers/1524-landscape-lawn-care/329-grassroots-tree-turf-care' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url<>0) ) OR ( ('https://www.familylifemagazines.com/our-advertisers/1524-landscape-lawn-care/329-grassroots-tree-turf-care' 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_contactenhanced' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id = 1510 ORDER BY c.lft
SELECT * FROM `trsst_admintools_wafblacklists` WHERE `verb` IN('','GET') AND `option` IN('','com_contactenhanced') AND `view` IN('','contact') AND `task` IN('','contact.') 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\":\"b6dc9f114831bd4dd8264c8540e2d178\"}' 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 a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.params as cat_params,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias FROM trsst_ce_details AS a LEFT JOIN trsst_categories AS c on c.id = a.catid LEFT JOIN trsst_categories as parent ON parent.id = c.parent_id WHERE a.id = 329 AND (a.published = 1 OR a.published =2)
SELECT `t`.`id` FROM `trsst_tags` AS t INNER JOIN `trsst_contentitem_tag_map` AS m ON `m`.`tag_id` = `t`.`id` AND `m`.`type_alias` = 'com_contactenhanced.contact' AND `m`.`content_item_id` IN ( 329)
SELECT a.*, cc.access as category_access, cc.title as category_name, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug FROM trsst_ce_details AS a INNER JOIN trsst_categories AS cc on cc.id = a.catid WHERE a.id = 329 AND a.published IN (1,2) AND cc.published IN (1,2)
SELECT a.id,a.title,a.state,a.access,a.catid,a.created,a.language, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug FROM trsst_content as a LEFT JOIN trsst_categories as c on a.catid=c.id WHERE a.created_by = 0 AND a.state IN (1,2) ORDER BY a.state DESC, a.created DESC LIMIT 10
SHOW FULL COLUMNS FROM `trsst_users`
SELECT * FROM trsst_easyblog_configs WHERE `name` = 'config'
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 WHERE a.context = 'com_users.user' 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 * FROM trsst_wf_profiles WHERE published = 1 ORDER BY ordering ASC
SELECT cf.* FROM trsst_ce_cf AS cf WHERE cf.access IN (1,1,5) AND (cf.catid = '1524' OR cf.catid = 0) AND (cf.published > 0 OR (cf.published = 0 AND cf.iscore = 1) ) AND cf.language IN ('en-GB','*') ORDER BY cf.catid, cf.ordering ASC
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,( SELECT COUNT(i.`id`) FROM `trsst_ce_details` AS `i` WHERE i.`catid` = c.id AND i.published = 1) AS numitems 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_contactenhanced' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id = 1524 ORDER BY c.lft
SELECT a.id, a.name, a.alias, a.name AS title, a.alias AS title_alias, a.params, a.user_id,a.checked_out, a.checked_out_time, a.birthdate, a.department,a.misc, a.con_position, a.address, a.suburb, a.state , a.country, a.postcode, a.telephone, a.fax, a.mobile, a.skype, a.twitter, a.facebook, a.linkedin, a.google_plus, a.webpage, a.image,a.category_image, a.extra_field_1, a.extra_field_2, a.extra_field_3, a.extra_field_4, a.extra_field_5, a.extra_field_6, a.extra_field_7, a.extra_field_8, a.extra_field_9, a.extra_field_10,a.lat, a.lng, a.email_to,a.catid, a.created, a.created_by, a.created_by_alias, a.published AS published_state, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.metadata, a.metakey, a.metadesc, a.access, a.xreference, a.featured , CASE WHEN badcats.id is not null THEN 0 ELSE a.published END AS published,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, 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,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM trsst_ce_details 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 OUTER JOIN (SELECT cat.id as id FROM trsst_categories AS cat JOIN trsst_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_contactenhanced' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE CASE WHEN badcats.id is null THEN a.published ELSE 0 END = 1 AND a.catid = 1524 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-18 09:36:43') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 09:36:43') ORDER BY a.sortname1 ASC,a.sortname2 ASC,a.sortname3 ASC,a.name ASC LIMIT 100
SELECT COUNT(*) FROM trsst_ce_details 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 OUTER JOIN (SELECT cat.id as id FROM trsst_categories AS cat JOIN trsst_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_contactenhanced' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE CASE WHEN badcats.id is null THEN a.published ELSE 0 END = 1 AND a.catid = 1524 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-18 09:36:43') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 09:36:43')
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:36:43',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_contactenhanced.contact' AND (fc.category_id IS NULL OR fc.category_id IN (1524,0,1510)) 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 `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_contactenhanced.contact' AND `m`.`content_item_id` = 329 AND `t`.`published` = 1 AND t.access IN (1,1,5)
SELECT `id`,`name`,`rules`,`parent_id` FROM `trsst_assets` WHERE `name` LIKE 'com_contactenhanced.%' OR `name` = 'com_contactenhanced' OR `parent_id` = 0
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:36:43') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-18 09:36:43') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 859 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
select `menutype` from trsst_menu where 1=1 and link like '%option=com_contactenhanced%' and link like '%view=contact%' and link like '%id=329%' and `published`=1
select * from trsst_ijseo_meta_pages where `link`='https://www.familylifemagazines.com/our-advertisers/1524-landscape-lawn-care/329-grassroots-tree-turf-care'
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/our-advertisers/1524-landscape-lawn-care/329-grassroots-tree-turf-care' and `parent_id` <> 0 limit 0,1) and c.`state`=1
SELECT `value` FROM `trsst_admintools_storage` WHERE `key` = 'criticalfiles'
SELECT manifest_cache FROM trsst_extensions WHERE type='component' AND element='com_baforms'
SELECT `key` FROM trsst_baforms_api WHERE service = 'balbooa_activation'
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 = '329:grassroots-tree-turf-care' AND i.include_in = 1 ) OR ( i.published =1 AND i.include_in = 0 )
6 × select `params` from trsst_ijseo_confi
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 * from trsst_ijseo_meta_pages
2 × SELECT `id`,`name`,`rules`,`parent_id` FROM `trsst_assets`
2 × select max(`checkdate`) from trsst_ijseo_keys limit 0,
2 × select * from trsst_ijseo_keys as a
2 × select `menutype` from trsst_menu
2 × select c.`canonical` from trsst_ijseo_canonical c
2 × SELECT `value` FROM `trsst_admintools_storage`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `trsst_extensions`
1 × SELECT `key` FROM trsst_baforms_api
1 × 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,( SELECT COUNT(i.`id`) FROM `trsst_ce_details` AS `i`
1 × SELECT a.id, a.name, a.alias, a.name AS title, a.alias AS title_alias, a.params, a.user_id,a.checked_out, a.checked_out_time, a.birthdate, a.department,a.misc, a.con_position, a.address, a.suburb, a.state , a.country, a.postcode, a.telephone, a.fax, a.mobile, a.skype, a.twitter, a.facebook, a.linkedin, a.google_plus, a.webpage, a.image,a.category_image, a.extra_field_1, a.extra_field_2, a.extra_field_3, a.extra_field_4, a.extra_field_5, a.extra_field_6, a.extra_field_7, a.extra_field_8, a.extra_field_9, a.extra_field_10,a.lat, a.lng, a.email_to,a.catid, a.created, a.created_by, a.created_by_alias, a.published AS published_state, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.metadata, a.metakey, a.metadesc, a.access, a.xreference, a.featured , CASE WHEN badcats.id is not null THEN 0 ELSE a.published END AS published,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, 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,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM trsst_ce_details 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 OUTER JOIN (SELECT cat.id as id FROM trsst_categories AS cat JOIN trsst_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT COUNT(*) FROM trsst_ce_details 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 OUTER JOIN (SELECT cat.id as id FROM trsst_categories AS cat JOIN trsst_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT enabled FROM `trsst_extensions`
1 × SELECT params FROM `trsst_ijseo_config
1 × SELECT manifest_cache FROM trsst_extensions
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params FROM trsst_modules AS m
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`.`tag_id`,`t`.* FROM `trsst_contentitem_tag_map` AS m INNER JOIN `trsst_tags` AS t ON `m`.`tag_id` = `t`.`id`
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 * FROM trsst_wf_profiles
1 × SELECT `name`,`element` FROM `trsst_extensions`
1 × SELECT `title` FROM `trsst_finder_taxonomy`
1 × SELECT cf.* FROM trsst_ce_cf AS cf
1 × SELECT `data` FROM `trsst_session`
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
1 × SELECT * FROM trsst_rsform_confi
1 × SELECT id, rules FROM `trsst_viewlevels
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 `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM trsst_extensions
1 × SELECT * FROM `trsst_admintools_wafexceptions`
1 × SELECT `template` FROM `trsst_template_styles`
1 × SELECT * FROM `trsst_admintools_ipautoban`
1 × SELECT `ip` FROM `trsst_admintools_ipblock
1 × SELECT * FROM `trsst_admintools_storage`
1 × SELECT `source`,`keepurlparams` FROM `trsst_admintools_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 * FROM trsst_easyblog_configs
1 × SELECT * FROM ( SELECT * FROM trsst_redj_redirects
1 × 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)
1 × SELECT * FROM `trsst_admintools_wafblacklists`
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.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.params as cat_params,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias FROM trsst_ce_details AS a LEFT JOIN trsst_categories AS c on c.id = a.catid LEFT JOIN trsst_categories as parent ON parent.id = c.parent_id
1 × SELECT `t`.`id` FROM `trsst_tags` AS t INNER JOIN `trsst_contentitem_tag_map` AS m ON `m`.`tag_id` = `t`.`id` AND `m`.`type_alias` = 'com_contactenhanced.contact' AND `m`.`content_item_id` IN ( 329
1 × SELECT a.*, cc.access as category_access, cc.title as category_name, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug FROM trsst_ce_details AS a INNER JOIN trsst_categories AS cc on cc.id = a.catid
1 × SELECT `session_id` FROM `trsst_session`
1 × SELECT a.id,a.title,a.state,a.access,a.catid,a.created,a.language, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug FROM trsst_content as a LEFT JOIN trsst_categories as c on a.catid=c.id
1 × INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3565393230653438313538393131303534663335323430326336626463323864', 1, 1713433003, 0, '', 0
1 × UPDATE `trsst_extensions` SET `params` = '{\"mediaversion\":\"b6dc9f114831bd4dd8264c8540e2d178\"}'
1 × SHOW FULL COLUMNS FROM `trsst_users
to your business!