SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups,
s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access,
s.id AS sec_id, cc.id as cat_id
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 = 2 AND ( a.state = 1 OR a.state = -1 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-08 12:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-08 12:15' )
AND a.access <= 0You are not authorised to view this resource.
You need to login.