1
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
 
GROUP BY g1.name
ORDER BY g1.lft2
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Backend'3
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 13 AND 20
GROUP BY g1.name
ORDER BY g1.lft4
SELECT *
 FROM jos_sefexts
 WHERE file = 'com_virtuemart.xml'5
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&category_id=1&page=shop.browse'6
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&category_id=82&page=shop.browse'7
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&category_id=115&page=shop.browse'8
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&category_id=136&page=shop.browse'9
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&category_id=852&page=shop.browse'10
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&category_id=853&page=shop.browse'11
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&category_id=1541&page=shop.browse'12
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&category_id=1577&page=shop.browse'13
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&category_id=2317&page=shop.browse'14
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&category_id=2330&page=shop.browse'15
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'16
SELECT m.id
 FROM jos_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 117
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access  022
SELECT name, id FROM jos_menu WHERE `link` LIKE 'index.php?option=com_virtuemart%' AND `published` > 023
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access  050
SELECT name, id FROM jos_menu WHERE `link` LIKE 'index.php?option=com_virtuemart%' AND `published` > 051
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&category_id=&keyword=&limitstart='52
SELECT name, id FROM jos_menu WHERE `id` = '1' AND `published` > 053
SELECT *
 FROM jos_sefexts
 WHERE file = 'com_registration.xml'54
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_registration&task=lostPassword' AND Itemid = '1'55
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_registration&task=lostPassword'56
SELECT oldurl FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&page=shop.registration'