SELECT *
FROM jos_session
WHERE session_id = 'i9hbjlnnuviac87bdbrlqf4jf2'
DELETE
FROM jos_session
WHERE ( TIME < '1716125517' )
SELECT *
FROM jos_session
WHERE session_id = 'i9hbjlnnuviac87bdbrlqf4jf2'
UPDATE `jos_session`
SET `time`='1716126417',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='joomla|s:4308:\"Tzo5OiJKUmVnaXN0cnkiOjM6e3M6MTc6Il9kZWZhdWx0TmFtZVNwYWNlIjtzOjc6ImRlZmF1bHQiO3M6OToiX3JlZ2lzdHJ5IjthOjI6e3M6NzoiZGVmYXVsdCI7YToxOntzOjQ6ImRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czo5OiJfX2RlZmF1bHQiO2E6MTp7czo0OiJkYXRhIjtPOjg6InN0ZENsYXNzIjozNTp7czo3OiJzZXNzaW9uIjtPOjg6InN0ZENsYXNzIjoyOntzOjc6ImNvdW50ZXIiO2k6MTtzOjU6InRpbWVyIjtPOjg6InN0ZENsYXNzIjozOntzOjU6InN0YXJ0IjtpOjE3MTYxMjY0MTY7czo0OiJsYXN0IjtpOjE3MTYxMjY0MTY7czozOiJub3ciO2k6MTcxNjEyNjQxNjt9fXM6ODoicmVnaXN0cnkiO086OToiSlJlZ2lzdHJ5IjozOntzOjE3OiJfZGVmYXVsdE5hbWVTcGFjZSI7czo3OiJzZXNzaW9uIjtzOjk6Il9yZWdpc3RyeSI7YToxOntzOjc6InNlc3Npb24iO2E6MTp7czo0OiJkYXRhIjtPOjg6InN0ZENsYXNzIjowOnt9fX1zOjc6Il9lcnJvcnMiO2E6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjE5OntzOjI6ImlkIjtpOjA7czo0OiJuYW1lIjtOO3M6ODoidXNlcm5hbWUiO047czo1OiJlbWFpbCI7TjtzOjg6InBhc3N3b3JkIjtOO3M6MTQ6InBhc3N3b3JkX2NsZWFyIjtzOjA6IiI7czo4OiJ1c2VydHlwZSI7TjtzOjU6ImJsb2NrIjtOO3M6OToic2VuZEVtYWlsIjtpOjA7czozOiJnaWQiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6MzoiYWlkIjtpOjA7czo1OiJndWVzdCI7aToxO3M6NzoiX3BhcmFtcyI7TzoxMDoiSlBhcmFtZXRlciI6Nzp7czo0OiJfcmF3IjtzOjA6IiI7czo0OiJfeG1sIjtOO3M6OToiX2VsZW1lbnRzIjthOjA6e31zOjEyOiJfZWxlbWVudFBhdGgiO2E6MTp7aTowO3M6OTA6Ii9ob21lL2djaXNuZXQvZG9tYWlucy9nY2lzbmV0LmNvbS9wdWJsaWNfaHRtbC9tYWluL2xpYnJhcmllcy9qb29tbGEvaHRtbC9wYXJhbWV0ZXIvZWxlbWVudCI7fXM6MTc6Il9kZWZhdWx0TmFtZVNwYWNlIjtzOjg6Il9kZWZhdWx0IjtzOjk6Il9yZWdpc3RyeSI7YToxOntzOjg6Il9kZWZhdWx0IjthOjE6e3M6NDoiZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX19czo3OiJfZXJyb3JzIjthOjA6e319czo5OiJfZXJyb3JNc2ciO047czo3OiJfZXJyb3JzIjthOjA6e319czoyMzoiZ2FudHJ5LWN1cnJlbnQtdGVtcGxhdGUiO3M6MTM6InJ0X2NhbWJlcl9qMTUiO3M6NDk6ImNhbWJlci0zMWQ5ZDc1NGJjYjY5NTUxMTA1NWMwNzMyZjhkYzM0My1kaXJlY3Rpb24iO047czo1NToiY2FtYmVyLTMxZDlkNzU0YmNiNjk1NTExMDU1YzA3MzJmOGRjMzQzLW1haW4tYmFja2dyb3VuZCI7TjtzOjUyOiJjYW1iZXItMzFkOWQ3NTRiY2I2OTU1MTEwNTVjMDczMmY4ZGMzNDMtbWFpbi1vdmVybGF5IjtOO3M6NTI6ImNhbWJlci0zMWQ5ZDc1NGJjYjY5NTUxMTA1NWMwNzMyZjhkYzM0My1tYWluLXBhdHRlcm4iO047czo0OToiY2FtYmVyLTMxZDlkNzU0YmNiNjk1NTExMDU1YzA3MzJmOGRjMzQzLW1haW4tdGV4dCI7TjtzOjQ5OiJjYW1iZXItMzFkOWQ3NTRiY2I2OTU1MTEwNTVjMDczMmY4ZGMzNDMtbWFpbi1saW5rIjtOO3M6NTE6ImNhbWJlci0zMWQ5ZDc1NGJjYjY5NTUxMTA1NWMwNzMyZjhkYzM0My1tYWluLWFjY2VudCI7TjtzOjU5OiJjYW1iZXItMzFkOWQ3NTRiY2I2OTU1MTEwNTVjMDczMmY4ZGMzNDMtdG9wYmxvY2stYmFja2dyb3VuZCI7TjtzOjU2OiJjYW1iZXItMzFkOWQ3NTRiY2I2OTU1MTEwNTVjMDczMmY4ZGMzNDMtdG9wYmxvY2stb3ZlcmxheSI7TjtzOjU0OiJjYW1iZXItMzFkOWQ3NTRiY2I2OTU1MTEwNTVjMDczMmY4ZGMzNDMtdG9wYmxvY2std2lkdGgiO047czo1MzoiY2FtYmVyLTMxZDlkNzU0YmNiNjk1NTExMDU1YzA3MzJmOGRjMzQzLXRvcGJsb2NrLXRleHQiO047czo1MzoiY2FtYmVyLTMxZDlkNzU0YmNiNjk1NTExMDU1YzA3MzJmOGRjMzQzLXRvcGJsb2NrLWxpbmsiO047czo1NToiY2FtYmVyLTMxZDlkNzU0YmNiNjk1NTExMDU1YzA3MzJmOGRjMzQzLXRvcGJsb2NrLWFjY2VudCI7TjtzOjU1OiJjYW1iZXItMzFkOWQ3NTRiY2I2OTU1MTEwNTVjMDczMmY4ZGMzNDMtYm9keS1iYWNrZ3JvdW5kIjtOO3M6NTA6ImNhbWJlci0zMWQ5ZDc1NGJjYjY5NTUxMTA1NWMwNzMyZjhkYzM0My1ib2R5LXdpZHRoIjtOO3M6NDk6ImNhbWJlci0zMWQ5ZDc1NGJjYjY5NTUxMTA1NWMwNzMyZjhkYzM0My1ib2R5LXRleHQiO047czo0OToiY2FtYmVyLTMxZDlkNzU0YmNiNjk1NTExMDU1YzA3MzJmOGRjMzQzLWJvZHktbGluayI7TjtzOjUxOiJjYW1iZXItMzFkOWQ3NTRiY2I2OTU1MTEwNTVjMDczMmY4ZGMzNDMtYm9keS1hY2NlbnQiO047czo2MjoiY2FtYmVyLTMxZDlkNzU0YmNiNjk1NTExMDU1YzA3MzJmOGRjMzQzLWZvb3RlcmJsb2NrLWJhY2tncm91bmQiO047czo1OToiY2FtYmVyLTMxZDlkNzU0YmNiNjk1NTExMDU1YzA3MzJmOGRjMzQzLWZvb3RlcmJsb2NrLW92ZXJsYXkiO047czo1NzoiY2FtYmVyLTMxZDlkNzU0YmNiNjk1NTExMDU1YzA3MzJmOGRjMzQzLWZvb3RlcmJsb2NrLXdpZHRoIjtOO3M6NTY6ImNhbWJlci0zMWQ5ZDc1NGJjYjY5NTUxMTA1NWMwNzMyZjhkYzM0My1mb290ZXJibG9jay10ZXh0IjtOO3M6NTY6ImNhbWJlci0zMWQ5ZDc1NGJjYjY5NTUxMTA1NWMwNzMyZjhkYzM0My1mb290ZXJibG9jay1saW5rIjtOO3M6NTg6ImNhbWJlci0zMWQ5ZDc1NGJjYjY5NTUxMTA1NWMwNzMyZjhkYzM0My1mb290ZXJibG9jay1hY2NlbnQiO047czo1MToiY2FtYmVyLTMxZDlkNzU0YmNiNjk1NTExMDU1YzA3MzJmOGRjMzQzLXJlYWRvbnN0eWxlIjtOO3M6NTE6ImNhbWJlci0zMWQ5ZDc1NGJjYjY5NTUxMTA1NWMwNzMyZjhkYzM0My1mb250LWZhbWlseSI7TjtzOjUyOiJjYW1iZXItMzFkOWQ3NTRiY2I2OTU1MTEwNTVjMDczMmY4ZGMzNDMtZm9udC1zaXplLWlzIjtOO3M6NTA6ImNhbWJlci0zMWQ5ZDc1NGJjYjY5NTUxMTA1NWMwNzMyZjhkYzM0My1sb2dvLXN0eWxlIjtOO3M6NTI6ImNhbWJlci0zMWQ5ZDc1NGJjYjY5NTUxMTA1NWMwNzMyZjhkYzM0My1sb2dvLXBhdHRlcm4iO047czo0OToiY2FtYmVyLTMxZDlkNzU0YmNiNjk1NTExMDU1YzA3MzJmOGRjMzQzLW1lbnUtdHlwZSI7TjtzOjU2OiJjYW1iZXItMzFkOWQ3NTRiY2I2OTU1MTEwNTVjMDczMmY4ZGMzNDMtdHlwb2dyYXBoeS1zdHlsZSI7Tjt9fX1zOjc6Il9lcnJvcnMiO2E6MDp7fX0=\";'
WHERE session_id='i9hbjlnnuviac87bdbrlqf4jf2'
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT *
FROM jos_rokcandy
WHERE published=1
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 2)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = cc.SECTION
AND s.scope = "content"
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE a.id = 14
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-19 13:46:57' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-19 13:46:57' ) ) OR ( a.state = -1 ) )
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='14'
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 2 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT a.*, cr.rating_sum/cr.rating_count AS rating, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f
ON f.content_id = a.id
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_content_rating AS cr
ON a.id = cr.content_id
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-19 13:46:57' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-19 13:46:57' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (cc.id=7)
AND (s.id=1)
AND f.content_id IS NULL
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 3
SELECT *
FROM jos_users
WHERE id = '63'
SELECT COUNT(a.id)
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f
ON f.content_id = a.id
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-19 13:46:57' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-19 13:46:57' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (cc.id=7)
AND (s.id=1)
AND f.content_id IS NULL
AND s.published = 1
AND cc.published = 1