Businesses that work with medical data are in a tricky situation, as the slightest issue with security could place considerable risk on storing this data. If you’re not careful, you could be putting your business at risk. With the compliance issues that have to be regarded, the security of any medical data you store on your infrastructure has to be made a priority. How can you minimize the risk of storing this data without compromising your business’ effectiveness?
Application 0.000 seconds (+0.000); 0.60 MB (+0.596) - afterLoadApplication 0.047 seconds (+0.047); 5.62 MB (+5.022) - afterInitialiseApplication 0.089 seconds (+0.042); 9.80 MB (+4.184) - afterRouteApplication 0.218 seconds (+0.129); 20.70 MB (+10.901) - afterDispatchApplication 0.225 seconds (+0.007); 20.99 MB (+0.286) - afterRender21 MB (22,021,056 Bytes)SELECT `data`
FROM `p3sae_session`
WHERE `session_id` = 'c66135532abab33740becbcc4b14b186'SELECT `session_id`
FROM `p3sae_session`
WHERE `session_id` = 'c66135532abab33740becbcc4b14b186'
LIMIT 0, 1INSERT INTO `p3sae_session`
(`session_id`, `client_id`, `time`)
VALUES
('c66135532abab33740becbcc4b14b186', 0, '1713544638')SELECT extension_id AS id, element AS "option", params, enabled
FROM p3sae_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT b.id
FROM p3sae_usergroups AS a
LEFT JOIN p3sae_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1SELECT id, rules
FROM `p3sae_viewlevels`SELECT folder AS type, element AS name, params
FROM p3sae_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY orderingSELECT extension_id AS id, element AS "option", params, enabled
FROM p3sae_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'SELECT `query`
FROM `p3sae_admintools_wafexceptions`
WHERE (`option` IS NULL OR `option` = '')
AND (`view` IS NULL OR `view` = '')
GROUP BY `query`
ORDER BY `query` ASCSELECT `value`
FROM `p3sae_admintools_storage`
WHERE `key` = 'cparams'SELECT *
FROM `p3sae_admintools_ipautoban`
WHERE `ip` = '3.146.221.52'SELECT `source`,`keepurlparams`
FROM `p3sae_admintools_redirects`
WHERE ((`dest` = 'index.php/blog/tags/electronic-medical-records') OR (`dest` = 'index.php/blog/tags/electronic-medical-records') OR ('index.php/blog/tags/electronic-medical-records' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 0, 1SELECT 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 p3sae_menu AS m
LEFT JOIN p3sae_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.lftSELECT *
FROM p3sae_easyblog_configs
WHERE `name` = 'config'SELECT *
FROM `p3sae_easyblog_tag`
WHERE ( BINARY `title`='electronic-medical-records' OR BINARY `alias`='electronic-medical-records' )SELECT extension_id AS id, element AS "option", params, enabled
FROM p3sae_extensions
WHERE `type` = 'component'
AND `element` = 'com_rereplacer'SELECT extension_id AS id, element AS "option", params, enabled
FROM p3sae_extensions
WHERE `type` = 'component'
AND `element` = 'com_easyblog'SELECT *
FROM p3sae_languages
WHERE published=1
ORDER BY ordering ASCSELECT id, home, template, s.params
FROM p3sae_template_styles as s
LEFT JOIN p3sae_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 = 1DELETE
FROM `p3sae_easyblog_mailq`
WHERE `status`='1'
AND DATEDIFF(NOW(), `created`) >='7'SELECT `id`
FROM `p3sae_easyblog_mailq`
WHERE `status`='0'
ORDER BY `created` ASC
LIMIT 5SELECT *
FROM `p3sae_easyblog_post`
WHERE `publish_up`<='2024-04-19 16:37:18'
AND `published`='2'
AND `state`='0'
ORDER BY `id`
LIMIT 5SELECT id, created_by
FROM`p3sae_easyblog_post`
WHERE `publish_down` > `publish_up`
AND `publish_down` <= '2024-04-19 16:37:18'
AND `publish_down` != '0000-00-00 00:00:00'
AND `published` = '1'
AND `state` = '0'SELECT *
FROM `p3sae_easyblog_uploader_tmp`
WHERE `created` <= DATE_SUB('2024-04-19 16:37:18' , INTERVAL 120 MINUTE)delete a, b
from `p3sae_easyblog_post` as a
inner join `p3sae_easyblog_revisions` as b
on a.`id` = b.`post_id`
where a.`published` = '9'
and a.`created` <= DATE_SUB('2024-04-19 16:37:18', INTERVAL 3 DAY)SELECT *
FROM `p3sae_menu`
WHERE `published`='1'
AND `link` LIKE 'index.php?option=com_easyblog%'SELECT *
FROM `p3sae_easyblog_acl`
WHERE `published`='1'
ORDER BY `id` ASCSELECT *
FROM `p3sae_easyblog_acl_group`
WHERE `content_id`='1'
AND `type`='
group'SELECT a.rules
FROM p3sae_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftSHOW FULL COLUMNS
FROM `p3sae_assets`SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT b.rules
FROM p3sae_assets AS a
LEFT JOIN p3sae_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '295'SELECT *
FROM p3sae_easyblog_meta
WHERE `content_id` = '3'
AND `type` = 'view'SELECT b.*
FROM `p3sae_easyblog_post_tag` AS a
INNER JOIN `p3sae_easyblog_post` AS b
ON a.post_id=b.id
WHERE a.`tag_id` = '295'
AND b.`published` = '1'
AND b.`state`='0'
AND ( (b.`source_type` = 'easyblog.sitewide') )
AND b.`access` = '0'
AND (1 <= (select count(1)
from `p3sae_easyblog_post_category` AS acp
INNER JOIN `p3sae_easyblog_category` as cat
on acp.`category_id` = cat.`id`
where acp.`post_id` = b.`id`
and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1)
and (0 > 0) ) OR ( (cat.`private` = 2)
and ( (select count(1)
from `p3sae_easyblog_category_acl` as cacl
where cacl.`category_id` = cat.id
and cacl.`acl_id` = 1
and cacl.`content_id` in (1)) > 0 ) ) ) ))
ORDER BY b.`created` desc
LIMIT 0,5SELECT COUNT(1)
FROM (SELECT b.*
FROM `p3sae_easyblog_post_tag` AS a
INNER JOIN `p3sae_easyblog_post` AS b
ON a.post_id=b.id
WHERE a.`tag_id` = '295'
AND b.`published` = '1'
AND b.`state`='0'
AND ( (b.`source_type` = 'easyblog.sitewide') )
AND b.`access` = '0'
AND (1 <= (select count(1)
from `p3sae_easyblog_post_category` AS acp
INNER JOIN `p3sae_easyblog_category` as cat
on acp.`category_id` = cat.`id`
where acp.`post_id` = b.`id`
and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1)
and (0 > 0) ) OR ( (cat.`private` = 2)
and ( (select count(1)
from `p3sae_easyblog_category_acl` as cacl
where cacl.`category_id` = cat.id
and cacl.`acl_id` = 1
and cacl.`content_id` in (1)) > 0 ) ) ) ))
ORDER BY b.`created` desc) as xselect count(1)
from `p3sae_easyblog_post` as a
inner join `p3sae_easyblog_post_tag` as b
on a.`id` = b.`post_id`
and b.`tag_id` = '295'
where a.`access` = '1'
AND (1 <= (select count(1)
from `p3sae_easyblog_post_category` AS acp
INNER JOIN `p3sae_easyblog_category` as cat
on acp.`category_id` = cat.`id`
where acp.`post_id` = a.`id`
and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1)
and (0 > 0) ) OR ( (cat.`private` = 2)
and ( (select count(1)
from `p3sae_easyblog_category_acl` as cacl
where cacl.`category_id` = cat.id
and cacl.`acl_id` = 1
and cacl.`content_id` in (1)) > 0 ) ) ) ))select count(1)
from `p3sae_easyblog_post` as a
inner join `p3sae_easyblog_post_tag` as b
on a.`id` = b.`post_id`
where b.`tag_id` = '295'
and (a.`source_type` = 'easyblog.team')SELECT COUNT(1) as `voted`, `uid`
FROM `p3sae_easyblog_ratings`
WHERE `uid` = '843'
AND `type`='entry'
AND `created_by`='0'
AND (`sessionid` = 'c66135532abab33740becbcc4b14b186' OR `ip` = '3.146.221.52')
GROUP BY `uid`
ORDER BY NULLSELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid`
FROM `p3sae_easyblog_ratings` AS a
WHERE a.`uid` IN(843)
AND `type`='entry'
GROUP BY `uid`
ORDER BY NULLSELECT a.*
FROM `p3sae_easyblog_comment` AS a
WHERE a.`post_id` IN(843)
AND a.`published`='1'SELECT a.`post_id`, COUNT(1) AS `count`
FROM `p3sae_easyblog_comment` AS a
WHERE a.`post_id` IN(843)
AND a.`published`='1'
GROUP BY a.`post_id`select a.*, b.`post_id`, b.`primary`
from `p3sae_easyblog_category` as a
inner join `p3sae_easyblog_post_category` as b
on a.`id` = b.`category_id`
where b.`post_id` IN ( 843)select a.*, b.`post_id`
from `p3sae_easyblog_tag` as a
inner join `p3sae_easyblog_post_tag` as b
on a.`id` = b.`tag_id`
where b.`post_id` IN ( 843)select a.*
from `p3sae_easyblog_revisions` as a
where a.`id` IN ( 7962)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`
from `p3sae_users` as u
left join `p3sae_easyblog_users` as e
ON u.`id` = e.`id`
where u.`id` = 295SHOW FULL COLUMNS
FROM `p3sae_users`SELECT *
FROM `p3sae_users`
WHERE `id` = 295SELECT `g`.`id`,`g`.`title`
FROM `p3sae_usergroups` AS g
INNER JOIN `p3sae_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 295select `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`, `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 `p3sae_easyblog_category_fields_groups` as a
inner join `p3sae_easyblog_post_category` as p
on `a`.`category_id` = `p`.`category_id`
inner join `p3sae_easyblog_fields_groups` as fg
on `a`.`group_id` = `fg`.`id`
inner join `p3sae_easyblog_fields` as f
on `fg`.`id` = `f`.`group_id`
left join `p3sae_easyblog_fields_values` as fv
on `fv`.`field_id` = `f`.`id`
and `fv`.`post_id` = `p`.`post_id`
where `p`.`post_id` = '843'select *
from `p3sae_easyblog_meta`
where `content_id` in (843)
and `type` = 'post'SELECT *
FROM `p3sae_easyblog_featured`
WHERE `content_id` IN(843)
AND `type`='post'SELECT `group_id`
FROM `p3sae_easyblog_category_fields_groups`
WHERE `category_id`='2'SELECT a.*
FROM `p3sae_easyblog_fields` AS a
INNER JOIN `p3sae_easyblog_category_fields_groups` AS b
ON a.`group_id`= b.`group_id`
WHERE b.`category_id`='2'
AND a.`state`='1'
ORDER BY a.`created` DESCSELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '295'SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM p3sae_modules AS m
LEFT JOIN p3sae_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN p3sae_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-19 16:37:18')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 16:37:18')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 155 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingSELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `group_id`
FROM `p3sae_user_usergroup_map`
WHERE `user_id` = '295'SELECT *
FROM `p3sae_easyblog_acl_group`
WHERE `content_id` IN (2, 3)
AND `type`='
group'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT r.*
FROM p3sae_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'articles')
ORDER BY r.ordering, r.idSELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '134'SELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '280'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT a.*
FROM `p3sae_easyblog_comment` a
INNER JOIN p3sae_users AS c
ON a.`created_by` = c.`id`
WHERE a.`post_id` = '843'
AND a.`published` = 1
ORDER BY a.`lft` asc
LIMIT 3SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT id
FROM p3sae_assets
WHERE parent_id = 0SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT `template`
FROM `p3sae_template_styles`
WHERE `home`='1'
AND `client_id`='0'SELECT r.*
FROM p3sae_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'component')
ORDER BY r.ordering, r.idSELECT r.*
FROM p3sae_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'body')
ORDER BY r.ordering, r.idSELECT r.*
FROM p3sae_rereplacer AS r
WHERE r.published = 1
AND (r.area = 'everywhere')
ORDER BY r.ordering, r.idUPDATE `p3sae_session`
SET `data` = 'joomla|s:1392:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzEzNTQ0NjM4O3M6NDoibGFzdCI7aToxNzEzNTQ0NjM4O3M6Mzoibm93IjtpOjE3MTM1NDQ2Mzg7fXM6NToidG9rZW4iO3M6MzI6IjllMmE5MTg0YTU2YmIxYTljODUxODM2ZDMyM2NlMWE2Ijt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fX1zOjEwOiJfX2Vhc3libG9nIjtPOjg6InN0ZENsYXNzIjoxOntzOjQ6InNpdGUiO086ODoic3RkQ2xhc3MiOjE6e3M6ODoibWVzc2FnZXMiO047fX19fQ==\";'
, `time` = '1713544639'
WHERE `session_id` = 'c66135532abab33740becbcc4b14b186'20 × SELECT `template`
FROM `p3sae_template_styles`8 × SELECT id
FROM p3sae_assets4 × SELECT r.*
FROM p3sae_rereplacer AS r4 × SELECT *
FROM p3sae_easyblog_tag4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM p3sae_extensions2 × SELECT *
FROM `p3sae_easyblog_acl_group`1 × select a.*, b.`post_id`, b.`primary`
from `p3sae_easyblog_category` as a
inner join `p3sae_easyblog_post_category` as b
on a.`id` = b.`category_id`1 × select a.*, b.`post_id`
from `p3sae_easyblog_tag` as a
inner join `p3sae_easyblog_post_tag` as b
on a.`id` = b.`tag_id`1 × select a.*
from `p3sae_easyblog_revisions` as a1 × SELECT a.`post_id`, COUNT(1) AS `count`
FROM `p3sae_easyblog_comment` AS a1 × SELECT a.*
FROM `p3sae_easyblog_comment` AS a1 × select count(1)
from `p3sae_easyblog_post` as a
inner join `p3sae_easyblog_post_tag` as b
on a.`id` = b.`post_id`1 × SELECT COUNT(1) as `voted`, `uid`
FROM `p3sae_easyblog_ratings`1 × SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid`
FROM `p3sae_easyblog_ratings` AS a1 × 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`
from `p3sae_users` as u
left join `p3sae_easyblog_users` as e
ON u.`id` = e.`id`1 × select count(1)
from `p3sae_easyblog_post` as a
inner join `p3sae_easyblog_post_tag` as b
on a.`id` = b.`post_id`
and b.`tag_id` = '295'1 × SELECT `g`.`id`,`g`.`title`
FROM `p3sae_usergroups` AS g
INNER JOIN `p3sae_user_usergroup_map` AS m
ON m.group_id = g.id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM p3sae_modules AS m
LEFT JOIN p3sae_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN p3sae_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `group_id`
FROM `p3sae_user_usergroup_map`1 × SELECT `session_id`
FROM `p3sae_session`1 × SELECT a.*
FROM `p3sae_easyblog_comment` a
INNER JOIN p3sae_users AS c
ON a.`created_by` = c.`id`1 × SELECT a.*
FROM `p3sae_easyblog_fields` AS a
INNER JOIN `p3sae_easyblog_category_fields_groups` AS b
ON a.`group_id`= b.`group_id`1 × SELECT `group_id`
FROM `p3sae_easyblog_category_fields_groups`1 × SELECT COUNT(1)
FROM (SELECT b.*
FROM `p3sae_easyblog_post_tag` AS a
INNER JOIN `p3sae_easyblog_post` AS b
ON a.post_id=b.id1 × 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`, `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 `p3sae_easyblog_category_fields_groups` as a
inner join `p3sae_easyblog_post_category` as p
on `a`.`category_id` = `p`.`category_id`
inner join `p3sae_easyblog_fields_groups` as fg
on `a`.`group_id` = `fg`.`id`
inner join `p3sae_easyblog_fields` as f
on `fg`.`id` = `f`.`group_id`
left join `p3sae_easyblog_fields_values` as fv
on `fv`.`field_id` = `f`.`id`
and `fv`.`post_id` = `p`.`post_id`1 × select *
from `p3sae_easyblog_meta`1 × SELECT *
FROM `p3sae_easyblog_featured`1 × SELECT *
FROM `p3sae_users`1 × SELECT b.*
FROM `p3sae_easyblog_post_tag` AS a
INNER JOIN `p3sae_easyblog_post` AS b
ON a.post_id=b.id1 × SELECT *
FROM p3sae_easyblog_configs1 × SELECT *
FROM `p3sae_easyblog_tag`1 × SELECT *
FROM p3sae_languages1 × SELECT id, home, template, s.params
FROM p3sae_template_styles as s
LEFT JOIN p3sae_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × 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 p3sae_menu AS m
LEFT JOIN p3sae_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `source`,`keepurlparams`
FROM `p3sae_admintools_redirects`1 × SELECT folder AS type, element AS name, params
FROM p3sae_extensions1 × SELECT `query`
FROM `p3sae_admintools_wafexceptions`1 × SELECT `value`
FROM `p3sae_admintools_storage`1 × SELECT *
FROM `p3sae_admintools_ipautoban`1 × SELECT `id`
FROM `p3sae_easyblog_mailq`1 × SELECT *
FROM `p3sae_easyblog_post`1 × SELECT b.id
FROM p3sae_usergroups AS a
LEFT JOIN p3sae_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT b.rules
FROM p3sae_assets AS a
LEFT JOIN p3sae_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `data`
FROM `p3sae_session`1 × SELECT *
FROM p3sae_easyblog_meta1 × SELECT a.rules
FROM p3sae_assets AS a1 × SELECT *
FROM `p3sae_easyblog_acl`1 × SELECT id, created_by
FROM`p3sae_easyblog_post`1 × SELECT *
FROM `p3sae_easyblog_uploader_tmp`1 × SELECT *
FROM `p3sae_menu`1 × SELECT id, rules
FROM `p3sae_viewlevels1 × SHOW FULL COLUMNS
FROM `p3sae_users1 × UPDATE `p3sae_session`
SET `data` = 'joomla|s:1392:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzEzNTQ0NjM4O3M6NDoibGFzdCI7aToxNzEzNTQ0NjM4O3M6Mzoibm93IjtpOjE3MTM1NDQ2Mzg7fXM6NToidG9rZW4iO3M6MzI6IjllMmE5MTg0YTU2YmIxYTljODUxODM2ZDMyM2NlMWE2Ijt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fX1zOjEwOiJfX2Vhc3libG9nIjtPOjg6InN0ZENsYXNzIjoxOntzOjQ6InNpdGUiO086ODoic3RkQ2xhc3MiOjE6e3M6ODoibWVzc2FnZXMiO047fX19fQ==\";' , `time` = '1713544639'1 × SHOW FULL COLUMNS
FROM `p3sae_assets1 × delete a, b
from `p3sae_easyblog_post` as a
inner join `p3sae_easyblog_revisions` as b
on a.`id` = b.`post_id`1 × DELETE
FROM `p3sae_easyblog_mailq`1 × INSERT INTO `p3sae_session` (`session_id`, `client_id`, `time`)
VALUES ('c66135532abab33740becbcc4b14b186', 0, '1713544638'