{ "__default": { "session": { "counter": 1, "timer": { "start": 1713433837, "last": 1713433837, "now": 1713433837 }, "token": "vGWknG0tt1n8SeQp87MNTJ4Uem0xzxHQ" }, "registry": { "com_monthlyarchive": { "archive": { "list": { "limit": 20, "start": 30, "ordering": null, "direction": null }, "limitstart": 30 } }, "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'3332373532323231303562666232326431653539653762343834653962366334'
SELECT `session_id` FROM `trsst_session` WHERE `session_id` = X'3332373532323231303562666232326431653539653762343834653962366334' LIMIT 1
INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3332373532323231303562666232326431653539653762343834653962366334', 1, 1713433837, 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.190.153.51'
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/issues-archive/2019/08') OR (`dest` = 'magazines/issues-archive/2019/08?start=30') OR ('magazines/issues-archive/2019/08?start=30' LIKE `dest`)) AND `published` = '1' ORDER BY `ordering` DESC LIMIT 1
SELECT * FROM trsst_rsform_config
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM trsst_menu AS m LEFT JOIN trsst_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
SELECT * FROM ( SELECT * FROM trsst_redj_redirects WHERE ( ( (CAST('/magazines/issues-archive/2019/08?start=30' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url<>0) AND (request_only<>0) ) OR ( (CAST('/magazines/issues-archive/2019/08?start=30' 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/issues-archive/2019/08?start=30' 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/issues-archive/2019/08?start=30' AS BINARY) REGEXP BINARY fromurl)>0 AND (case_sensitive<>0) AND (decode_url=0) AND (request_only=0) ) OR ( ('/magazines/issues-archive/2019/08?start=30' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only<>0) ) OR ( ('/magazines/issues-archive/2019/08?start=30' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url=0) AND (request_only<>0) ) OR ( ('https://www.familylifemagazines.com/magazines/issues-archive/2019/08?start=30' REGEXP fromurl)>0 AND (case_sensitive=0) AND (decode_url<>0) AND (request_only=0) ) OR ( ('https://www.familylifemagazines.com/magazines/issues-archive/2019/08?start=30' 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/issues-archive/2019/08?start=30' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url<>0) ) OR ( (CAST('https://www.familylifemagazines.com/magazines/issues-archive/2019/08?start=30' AS BINARY) REGEXP BINARY A.skip)=0 AND (case_sensitive<>0) AND (decode_url=0) ) OR ( ('https://www.familylifemagazines.com/magazines/issues-archive/2019/08?start=30' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url<>0) ) OR ( ('https://www.familylifemagazines.com/magazines/issues-archive/2019/08?start=30' REGEXP A.skip)=0 AND (case_sensitive=0) AND (decode_url=0) )
SELECT * FROM `trsst_admintools_wafblacklists` WHERE `verb` IN('','GET') AND `option` IN('','com_monthlyarchive') AND `view` IN('','archive') AND `task` IN('','archive.') 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\":\"5196ad0bc2e254782cfdf70e86e41656\"}' WHERE `type` = 'library' AND `element` = 'joomla'
SELECT * FROM trsst_languages WHERE published=1 ORDER BY ordering ASC
SET @@session.time_zone = '-04:00'
SELECT COUNT(*) FROM `trsst_content` AS c LEFT JOIN `trsst_categories` AS categories ON categories.id = c.catid LEFT JOIN trsst_users AS users ON users.id = c.created_by WHERE categories.published = 1 AND c.access IN (1,1,5) AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2024-04-18 09:50:37') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2024-04-18 09:50:37') AND YEAR(CONVERT_TZ(DATE_FORMAT(c.created, "%Y-%m-%d %H:%i:%s"), "+00:00", @@session.time_zone)) = 2019 AND MONTH(CONVERT_TZ(DATE_FORMAT(c.created, "%Y-%m-%d %H:%i:%s"), "+00:00", @@session.time_zone)) = 8 AND (c.state = 1) AND (c.catid IN (78,495,496,497,498,501,603,604,605,601,606,607,608,632,600,602,609,610,611,1708) OR (SELECT cats.parent_id FROM trsst_categories AS cats WHERE c.catid = cats.id) IN (78,495,496,497,498,501,603,604,605,601,606,607,608,632,600,602,609,610,611,1708))
SELECT DISTINCT c.id, c.id AS slug, c.state, c.title, c.alias, c.introtext, c.fulltext, c.images, c.hits, c.catid, c.created, c.publish_up, c.publish_down, c.created_by AS author, c.created_by, c.created_by_alias, c.language,categories.title AS category_title,categories.parent_id AS category_parent_id,users.name AS author_name, users.username AS author_username FROM `trsst_content` AS c LEFT JOIN `trsst_categories` AS categories ON categories.id = c.catid LEFT JOIN trsst_users AS users ON users.id = c.created_by WHERE categories.published = 1 AND c.access IN (1,1,5) AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2024-04-18 09:50:37') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2024-04-18 09:50:37') AND YEAR(CONVERT_TZ(DATE_FORMAT(c.created, "%Y-%m-%d %H:%i:%s"), "+00:00", @@session.time_zone)) = 2019 AND MONTH(CONVERT_TZ(DATE_FORMAT(c.created, "%Y-%m-%d %H:%i:%s"), "+00:00", @@session.time_zone)) = 8 AND (c.state = 1) AND (c.catid IN (78,495,496,497,498,501,603,604,605,601,606,607,608,632,600,602,609,610,611,1708) OR (SELECT cats.parent_id FROM trsst_categories AS cats WHERE c.catid = cats.id) IN (78,495,496,497,498,501,603,604,605,601,606,607,608,632,600,602,609,610,611,1708)) ORDER BY c.created DESC LIMIT 30, 30
SELECT enabled FROM `trsst_extensions` WHERE `element` = 'com_sppagebuilder' AND `type` = 'component'
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_monthlyarchive.archive.filter' 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 DISTINCT c.id, c.created, c.publish_up, c.publish_down,categories.title AS category_title,categories.parent_id AS category_parent_id,users.name AS author_name, users.username AS author_username FROM `trsst_content` AS c LEFT JOIN `trsst_categories` AS categories ON categories.id = c.catid LEFT JOIN trsst_users AS users ON users.id = c.created_by WHERE categories.published = 1 AND c.access IN (1,1,5) AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2024-04-18 09:50:37') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2024-04-18 09:50:37') AND (c.state = 1) AND (c.catid IN (78,495,496,497,498,501,603,604,605,601,606,607,608,632,600,602,609,610,611,1708) OR (SELECT cats.parent_id FROM trsst_categories AS cats WHERE c.catid = cats.id) IN (78,495,496,497,498,501,603,604,605,601,606,607,608,632,600,602,609,610,611,1708)) ORDER BY c.created DESC
SELECT u.id AS author_id, CONCAT(u.name, " (", COUNT(c.`id`), ")") AS author_name FROM trsst_users AS u LEFT JOIN `trsst_content` AS c ON u.id = c.created_by WHERE c.access IN (1,1,5) AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2024-04-18 09:50:37') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2024-04-18 09:50:37') AND YEAR(CONVERT_TZ(DATE_FORMAT(c.created, "%Y-%m-%d %H:%i:%s"), "+00:00", @@session.time_zone)) = 2019 AND MONTH(CONVERT_TZ(DATE_FORMAT(c.created, "%Y-%m-%d %H:%i:%s"), "+00:00", @@session.time_zone)) = 8 AND (c.state = 1) AND (c.catid IN (78,495,496,497,498,501,603,604,605,601,606,607,608,632,600,602,609,610,611,1708) OR (SELECT cats.parent_id FROM trsst_categories AS cats WHERE c.catid = cats.id) IN (78,495,496,497,498,501,603,604,605,601,606,607,608,632,600,602,609,610,611,1708)) GROUP BY u.id ORDER BY u.name ASC
SELECT cat.id AS category_id, CONCAT(IF(cat.level=2, ' -- ', ''), IF(cat.level=3, ' -- ', ''), cat.title, " (", COUNT(c.`id`), ")") AS category_name FROM `trsst_categories` AS cat LEFT JOIN `trsst_content` AS c ON cat.id = c.catid WHERE c.access IN (1,1,5) AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2024-04-18 09:50:37') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2024-04-18 09:50:37') AND YEAR(CONVERT_TZ(DATE_FORMAT(c.created, "%Y-%m-%d %H:%i:%s"), "+00:00", @@session.time_zone)) = 2019 AND MONTH(CONVERT_TZ(DATE_FORMAT(c.created, "%Y-%m-%d %H:%i:%s"), "+00:00", @@session.time_zone)) = 8 AND (c.state = 1) AND (c.catid IN (78,495,496,497,498,501,603,604,605,601,606,607,608,632,600,602,609,610,611,1708) OR (SELECT cats.parent_id FROM trsst_categories AS cats WHERE c.catid = cats.id) IN (78,495,496,497,498,501,603,604,605,601,606,607,608,632,600,602,609,610,611,1708)) GROUP BY cat.id ORDER BY cat.lft ASC
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:50:37',a.checkdate)) OR a.checkdate='0000-00-00 00:00:00' order by checkdate asc limit 0,10
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 `alias` FROM `trsst_content` WHERE id = '2921'
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 = 604 ORDER BY c.lft
SELECT `alias` FROM `trsst_content` WHERE id = '2920'
SELECT `alias` FROM `trsst_content` WHERE id = '2919'
SELECT `alias` FROM `trsst_content` WHERE id = '2918'
SELECT `alias` FROM `trsst_content` WHERE id = '2917'
SELECT `alias` FROM `trsst_content` WHERE id = '2916'
SELECT `alias` FROM `trsst_content` WHERE id = '2915'
SELECT `alias` FROM `trsst_content` WHERE id = '2914'
SELECT `alias` FROM `trsst_content` WHERE id = '2913'
select `menutype` from trsst_menu where 1=1 and link like '%option=com_monthlyarchive%' and link like '%view=archive%' and `published`=1
select `params` from trsst_menu where id=865
select * from trsst_ijseo_meta_pages where `link`='https://www.familylifemagazines.com/magazines/issues-archive/2019/08?start=30'
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:50:37') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-18 09:50:37') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 865 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
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/magazines/issues-archive/2019/08?start=30' 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 = '0' AND i.include_in = 1 ) OR ( i.published =1 AND i.include_in = 0 )
42 × select `params` from trsst_ijseo_confi
36 × select * from trsst_ijseo_keys as a
36 × select max(`checkdate`) from trsst_ijseo_keys limit 0,
18 × SELECT `alias` FROM `trsst_content`
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 c.`canonical` from trsst_ijseo_canonical c
2 × select * from trsst_ijseo_meta_pages
2 × select `params` from trsst_menu
2 × select `menutype` from trsst_menu
2 × SELECT * FROM trsst_wf_profiles
2 × SELECT `value` FROM `trsst_admintools_storage`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `trsst_extensions`
1 × SELECT `ip` FROM `trsst_admintools_ipblock
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 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 `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM trsst_extensions
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 `name`,`element` FROM `trsst_extensions`
1 × SELECT * FROM trsst_easyblog_configs
1 × SELECT * FROM `trsst_admintools_wafexceptions`
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 manifest_cache FROM trsst_extensions
1 × SELECT `key` FROM trsst_baforms_api
1 × SELECT params FROM `trsst_ijseo_config
1 × SELECT `id`,`name`,`rules`,`parent_id` FROM `trsst_assets`
1 × SELECT `template` FROM `trsst_template_styles`
1 × SELECT * FROM `trsst_admintools_storage`
1 × SELECT * FROM trsst_languages
1 × SELECT `source`,`keepurlparams` FROM `trsst_admintools_redirects`
1 × SELECT * FROM trsst_rsform_confi
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 ( SELECT * FROM trsst_redj_redirects
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 COUNT(*) FROM `trsst_content` AS c LEFT JOIN `trsst_categories` AS categories ON categories.id = c.catid LEFT JOIN trsst_users AS users ON users.id = c.created_by
1 × SELECT * FROM `trsst_admintools_ipautoban`
1 × SELECT DISTINCT c.id, c.id AS slug, c.state, c.title, c.alias, c.introtext, c.fulltext, c.images, c.hits, c.catid, c.created, c.publish_up, c.publish_down, c.created_by AS author, c.created_by, c.created_by_alias, c.language,categories.title AS category_title,categories.parent_id AS category_parent_id,users.name AS author_name, users.username AS author_username FROM `trsst_content` AS c LEFT JOIN `trsst_categories` AS categories ON categories.id = c.catid LEFT JOIN trsst_users AS users ON users.id = c.created_by
1 × SELECT enabled FROM `trsst_extensions`
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 `session_id` FROM `trsst_session`
1 × SELECT DISTINCT c.id, c.created, c.publish_up, c.publish_down,categories.title AS category_title,categories.parent_id AS category_parent_id,users.name AS author_name, users.username AS author_username FROM `trsst_content` AS c LEFT JOIN `trsst_categories` AS categories ON categories.id = c.catid LEFT JOIN trsst_users AS users ON users.id = c.created_by
1 × SELECT u.id AS author_id, CONCAT(u.name, " (", COUNT(c.`id`), ")") AS author_name FROM trsst_users AS u LEFT JOIN `trsst_content` AS c ON u.id = c.created_by
1 × SELECT cat.id AS category_id, CONCAT(IF(cat.level=2, ' -- ', ''), IF(cat.level=3, ' -- ', ''), cat.title, " (", COUNT(c.`id`), ")") AS category_name FROM `trsst_categories` AS cat LEFT JOIN `trsst_content` AS c ON cat.id = c.catid
1 × SELECT `data` FROM `trsst_session`
3 × SET @@session.time_zone = '-04:00
1 × INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3332373532323231303562666232326431653539653762343834653962366334', 1, 1713433837, 0, '', 0
1 × UPDATE `trsst_extensions` SET `params` = '{\"mediaversion\":\"5196ad0bc2e254782cfdf70e86e41656\"}'
to your business!