One of the most publicized hacks we have seen is last December’s breach of Sony Pictures Entertainment by the Guardians of Peace. In addition to the hackers exposing Sony’s budget, plans for layoffs, and 3,800 SSNs, they leaked personal emails from company executives. This incident should make every business owner a little nervous.
When you think of viruses and malware, you think of attacks on a digital scale. An attack in the digital world can’t do anything in the physical world, right? It turns out that hacking can lead to bigger problems, like the recent meltdown of a blast furnace at a German steel mill.
Application 0.000 seconds (+0.000); 0.60 MB (+0.597) - afterLoadApplication 0.042 seconds (+0.042); 5.62 MB (+5.023) - afterInitialiseApplication 0.085 seconds (+0.042); 9.80 MB (+4.185) - afterRouteApplication 0.214 seconds (+0.130); 20.37 MB (+10.563) - afterDispatchApplication 0.222 seconds (+0.008); 20.66 MB (+0.292) - afterRender20.68 MB (21,680,736 Bytes)SELECT `data`
FROM `p3sae_session`
WHERE `session_id` = '86c77335cfa162292409096ac60648e5'SELECT `session_id`
FROM `p3sae_session`
WHERE `session_id` = '86c77335cfa162292409096ac60648e5'
LIMIT 0, 1INSERT INTO `p3sae_session`
(`session_id`, `client_id`, `time`)
VALUES
('86c77335cfa162292409096ac60648e5', 0, '1713867482')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` = '18.118.137.243'SELECT `source`,`keepurlparams`
FROM `p3sae_admintools_redirects`
WHERE ((`dest` = 'index.php/blog/tags/hacking') OR (`dest` = 'index.php/blog/tags/hacking?start=5') OR ('index.php/blog/tags/hacking?start=5' 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`='hacking' OR BINARY `alias`='hacking' )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-23 10:18:02'
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-23 10:18:02'
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-23 10:18:02' , 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-23 10:18:02', 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` = '158'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` = '158'
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 5,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` = '158'
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` = '158'
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` = '158'
and (a.`source_type` = 'easyblog.team')SELECT COUNT(1) as `voted`, `uid`
FROM `p3sae_easyblog_ratings`
WHERE `uid` IN (207,203)
AND `type`='entry'
AND `created_by`='0'
AND (`sessionid` = '86c77335cfa162292409096ac60648e5' OR `ip` = '18.118.137.243')
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(207,203)
AND `type`='entry'
GROUP BY `uid`
ORDER BY NULLSELECT a.*
FROM `p3sae_easyblog_comment` AS a
WHERE a.`post_id` IN(207,203)
AND a.`published`='1'SELECT a.`post_id`, COUNT(1) AS `count`
FROM `p3sae_easyblog_comment` AS a
WHERE a.`post_id` IN(207,203)
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 ( 207,203)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 ( 207,203)select a.*
from `p3sae_easyblog_revisions` as a
where a.`id` IN ( 316,371)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 IN (207,203)select *
from `p3sae_easyblog_meta`
where `content_id` in (207,203)
and `type` = 'post'SELECT *
FROM `p3sae_easyblog_featured`
WHERE `content_id` IN(207,203)
AND `type`='post'SELECT `group_id`
FROM `p3sae_easyblog_category_fields_groups`
WHERE `category_id`='12'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`='12'
AND a.`state`='1'
ORDER BY a.`created` DESCSELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '158'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-23 10:18:02')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-23 10:18:02')
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` = '19'SELECT *
FROM p3sae_easyblog_tag
WHERE `id` = '34'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` = '207'
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 `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 `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 *
FROM p3sae_easyblog_tag
WHERE `id` = '7'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` = '203'
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 `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:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzEzODY3NDgyO3M6NDoibGFzdCI7aToxNzEzODY3NDgyO3M6Mzoibm93IjtpOjE3MTM4Njc0ODI7fXM6NToidG9rZW4iO3M6MzI6IjFmMzM3NjQwNWE1OWM2NDM4OTY2NTljOGZiZTA0Njg5Ijt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fX1zOjEwOiJfX2Vhc3libG9nIjtPOjg6InN0ZENsYXNzIjoxOntzOjQ6InNpdGUiO086ODoic3RkQ2xhc3MiOjE6e3M6ODoibWVzc2FnZXMiO047fX19fQ==\";'
, `time` = '1713867482'
WHERE `session_id` = '86c77335cfa162292409096ac60648e5'32 × SELECT `template`
FROM `p3sae_template_styles`11 × SELECT id
FROM p3sae_assets5 × SELECT *
FROM p3sae_easyblog_tag4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM p3sae_extensions4 × SELECT r.*
FROM p3sae_rereplacer AS r2 × SELECT *
FROM `p3sae_easyblog_acl_group`2 × SELECT a.*
FROM `p3sae_easyblog_comment` a
INNER JOIN p3sae_users AS c
ON a.`created_by` = c.`id`1 × SELECT a.`post_id`, COUNT(1) AS `count`
FROM `p3sae_easyblog_comment` AS a1 × 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_comment` AS a1 × 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 AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid`
FROM `p3sae_easyblog_ratings` 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`
and b.`tag_id` = '158'1 × 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 a.*
from `p3sae_easyblog_revisions` as a1 × SELECT *
FROM `p3sae_users`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 `session_id`
FROM `p3sae_session`1 × 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 `group_id`
FROM `p3sae_easyblog_category_fields_groups`1 × SELECT *
FROM `p3sae_easyblog_featured`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 `g`.`id`,`g`.`title`
FROM `p3sae_usergroups` AS g
INNER JOIN `p3sae_user_usergroup_map` AS m
ON m.group_id = g.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 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 *
FROM p3sae_easyblog_meta1 × 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 *
FROM p3sae_easyblog_configs1 × SELECT *
FROM `p3sae_easyblog_tag`1 × SELECT *
FROM p3sae_languages1 × SELECT `source`,`keepurlparams`
FROM `p3sae_admintools_redirects`1 × SELECT *
FROM `p3sae_admintools_ipautoban`1 × SELECT id, rules
FROM `p3sae_viewlevels1 × 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 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 `id`
FROM `p3sae_easyblog_mailq`1 × SELECT a.rules
FROM p3sae_assets AS a1 × 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 b.id
FROM p3sae_usergroups AS a
LEFT JOIN p3sae_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT *
FROM `p3sae_easyblog_acl`1 × SELECT *
FROM `p3sae_menu`1 × SELECT *
FROM `p3sae_easyblog_post`1 × SELECT id, created_by
FROM`p3sae_easyblog_post`1 × SELECT *
FROM `p3sae_easyblog_uploader_tmp`1 × SELECT b.*
FROM `p3sae_easyblog_post_tag` AS a
INNER JOIN `p3sae_easyblog_post` AS b
ON a.post_id=b.id1 × SHOW FULL COLUMNS
FROM `p3sae_users1 × UPDATE `p3sae_session`
SET `data` = 'joomla|s:1392:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzEzODY3NDgyO3M6NDoibGFzdCI7aToxNzEzODY3NDgyO3M6Mzoibm93IjtpOjE3MTM4Njc0ODI7fXM6NToidG9rZW4iO3M6MzI6IjFmMzM3NjQwNWE1OWM2NDM4OTY2NTljOGZiZTA0Njg5Ijt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fX1zOjEwOiJfX2Vhc3libG9nIjtPOjg6InN0ZENsYXNzIjoxOntzOjQ6InNpdGUiO086ODoic3RkQ2xhc3MiOjE6e3M6ODoibWVzc2FnZXMiO047fX19fQ==\";' , `time` = '1713867482'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 ('86c77335cfa162292409096ac60648e5', 0, '1713867482'