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 *, COUNT( a.id ) AS numlinks
FROM jos_categories AS cc
LEFT JOIN jos_contact_details AS a ON a.catid = cc.id
WHERE a.published = 1
AND cc.section = 'com_contact_details'
AND cc.published = 1
AND a.access <= 0
AND cc.access <= 0
GROUP BY cc.id
ORDER BY cc.ordering