'SELECT DISTINCT cat.category_parent_id AS parent_id, cat.ordering as ordering, cat.category_id AS id, cat.`'.$this->lang->get('name').
'` AS name, cat.`'.$this->lang->get('short_description').'` AS short_desc
					FROM `#__jshopping_products` AS prod
					LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat USING (product_id)
					LEFT JOIN `#__jshopping_categories` AS cat USING (category_id)
					WHERE prod.product_publish = 1 AND prod.access IN ('.$this->groups.')
					AND cat.access IN ('.$this->groups.') AND cat.category_publish = 1
					AND pr_cat.category_id IN ('.implode(',',$this->subCategoryies).')
					ORDER BY name'