SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 3 AND 12
GROUP BY g1.name
ORDER BY g1.lftSELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 13 AND 20
GROUP BY g1.name
ORDER BY g1.lft
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 = 29 AND ( a.state = 1 OR a.state = -1 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-20 14:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-20 14:15' )
AND a.access <= 0You are not authorised to view this resource. You need to login.