SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROMokr52_extensionsWHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5)
ORDERBY ordering

SELECT `id`,`name`,`rules`,`parent_id`
FROM `okr52_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_csvi','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_vpadvanceduser','com_wrapper')

SELECT `okr52_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id`, `okr52_virtuemart_shoppergroups`.`shopper_group_name`, `default` AS default_shopper_group FROM `okr52_virtuemart_shoppergroups` WHERE `okr52_virtuemart_shoppergroups`.`virtuemart_vendor_id`="1" AND `default`="2"