SELECT `id`,`name`,`rules`,`parent_id`
FROM `vhewr_assets`
WHERE `name` IN ('com_admin','com_ajax','com_associations','com_banners','com_bjimageslider','com_cache','com_categories','com_checkin','com_cincopa','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djcatalog2','com_djmediatools','com_fields','com_finder','com_installer','com_jce','com_joomgallery','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_rsform','com_search','com_sigpro','com_stpagebuilder','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap') OR `parent_id` = 0

SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROMvhewr_djc2_categories as i
INNERJOINvhewr_djc2_images as img on img.id=(select id from vhewr_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)

SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROMvhewr_djc2_categories as i
INNERJOINvhewr_djc2_images as img on img.id=(select id from vhewr_djc2_images where type='category' and item_id=i.id order by ordering asc limit 1)

2 × SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath FROMvhewr_djc2_categories as i INNERJOINvhewr_djc2_images as img on img.id=(select id from vhewr_djc2_images

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `vhewr_extensions`