SELECT *
FROM jos_session
WHERE session_id = 'pkg5bhgiu0am5ko6pi46t0ncq4'
DELETE
FROM jos_session
WHERE ( time < '1730845860' )
SELECT *
FROM jos_session
WHERE session_id = 'pkg5bhgiu0am5ko6pi46t0ncq4'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'pkg5bhgiu0am5ko6pi46t0ncq4','1730935860','','0','1','0' )
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
CREATE TABLE IF NOT EXISTS `jos_ualog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`option` varchar(255) NOT NULL,
`task` varchar(255) NOT NULL,
`action_link` text NOT NULL,
`action_title` text NOT NULL,
`item_title` varchar(255) NOT NULL,
`cdate` int(11) NOT NULL,
PRIMARY KEY (`id`))
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 template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1
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 = 1 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, 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, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-06 23:31:00' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-06 23:31:00' )
ORDER BY a.created DESC
LIMIT 0, 53
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, 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, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-06 23:31:00' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-06 23:31:00' )
ORDER BY a.created DESC
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM jos_comprofiler_plugin
WHERE published = 1
AND access <= 0
AND type = 'user'
ORDER BY ordering
SELECT groups_id,groups_members
FROM jos_docman_groups
SELECT id, link, params
FROM jos_menu
WHERE link LIKE '%option=com_docman%'
AND type = 'component'
AND published = 1
SELECT s.*, sn.name AS socnet, sn.url AS socneturl, sg.name AS groupname
FROM jos_stalker AS s
LEFT JOIN jos_stalker_socnets AS sn
ON sn.id = s.socnetid
LEFT JOIN jos_stalker_groups AS sg
ON sg.id = s.groupid
WHERE groupid = 0
AND s.published = 1
ORDER BY ordering
SELECT a.*,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, 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, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
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-11-06 23:31:00' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-06 23:31:00' )
AND a.access <= 0
AND a.catid IN ("40","41")
ORDER BY a.created DESC
LIMIT 50
SELECT *
FROM jos_content
WHERE id = '724'
SELECT *
FROM jos_content
WHERE id = '723'
SELECT *
FROM jos_content
WHERE id = '722'
SELECT *
FROM jos_content
WHERE id = '721'
SELECT *
FROM jos_content
WHERE id = '720'
SELECT *
FROM jos_content
WHERE id = '719'
SELECT *
FROM jos_content
WHERE id = '705'
SELECT *
FROM jos_content
WHERE id = '704'
SELECT *
FROM jos_content
WHERE id = '703'
SELECT *
FROM jos_content
WHERE id = '702'
SELECT *
FROM jos_content
WHERE id = '701'
SELECT *
FROM jos_content
WHERE id = '602'
SELECT *
FROM jos_content
WHERE id = '601'
SELECT *
FROM jos_content
WHERE id = '410'
SELECT *
FROM jos_content
WHERE id = '179'
SELECT *
FROM jos_content
WHERE id = '178'
SELECT *
FROM jos_content
WHERE id = '177'
SELECT *
FROM jos_content
WHERE id = '176'
SELECT *
FROM jos_content
WHERE id = '175'
SELECT *
FROM jos_content
WHERE id = '119'
SELECT *
FROM jos_content
WHERE id = '118'
SELECT *
FROM jos_content
WHERE id = '117'
SELECT *
FROM jos_content
WHERE id = '116'
SELECT *
FROM jos_content
WHERE id = '113'
SELECT *
FROM jos_content
WHERE id = '112'
SELECT *
FROM jos_content
WHERE id = '110'
SELECT *
FROM jos_content
WHERE id = '109'
SELECT *
FROM jos_content
WHERE id = '107'
SELECT *
FROM jos_content
WHERE id = '106'
SELECT *
FROM jos_content
WHERE id = '105'
SELECT *
FROM jos_content
WHERE id = '104'
SELECT *
FROM jos_content
WHERE id = '103'
SELECT *
FROM jos_content
WHERE id = '102'
SELECT *
FROM jos_content
WHERE id = '101'
SELECT *
FROM jos_content
WHERE id = '100'
SELECT *
FROM jos_content
WHERE id = '99'
SELECT *
FROM jos_content
WHERE id = '98'
SELECT *
FROM jos_content
WHERE id = '97'
SELECT *
FROM jos_content
WHERE id = '96'
SELECT *
FROM jos_content
WHERE id = '95'
SELECT *
FROM jos_content
WHERE id = '94'
SELECT *
FROM jos_content
WHERE id = '93'
SELECT *
FROM jos_content
WHERE id = '92'
SELECT a.*,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, 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, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
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-11-06 23:31:00' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-06 23:31:00' )
AND a.access <= 0
AND cc.id IN(36)
ORDER BY a.created DESC
LIMIT 10