Вывод товаров из всех подкатегорий на странице категории - Дизайн и оформление

$query = "SELECT $adv_result FROM `#__jshopping_products` AS prod
                  LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat USING (product_id)
                  $adv_from
                  WHERE pr_cat.category_id = '".$this->_db->getEscaped($this->category_id)."' AND prod.product_publish = '1' ".$adv_query." ".$order_query;

//\
			$SubCat='';
			foreach ($this->getSubCategories($this->_db->getEscaped($this->category_id), 'name', 'asc', 1) as $SubC) {
				$SubCat.="'".$SubC->category_id."', ";
			}
			if ($SubCat!='') $SubCat=" IN (".$SubCat."'".$this->_db->getEscaped($this->category_id)."' ) ";
			else $SubCat=" = '".$this->_db->getEscaped($this->category_id)."' ";
			
        $query = "SELECT $adv_result FROM `#__jshopping_products` AS prod
                  LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat USING (product_id)
                  $adv_from
                  WHERE pr_cat.category_id ".$SubCat." AND prod.product_publish = '1' ".$adv_query." ".$order_query;
//\