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

If (Is_Array($filters['labels']) && Count($filters['labels'])){
			$adv_query .= " AND prod.label_id in (".Implode(",",$filters['labels']).")";
		}

$label= JRequest::getString('label_id'); 
if($label){
	$filters['labels'] = array();
$filters['labels'] = explode(",", $label); 
}

			$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 prod.product_id, categ.category_id, prod.`".$lang->get('name')."` as name, prod.`".$lang->get('short_description')."` as short_description, prod.product_ean, prod.product_thumb_image, prod.product_full_image, prod.product_price, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.product_weight, prod.min_price, prod.product_quantity, prod.different_prices $adv_result
                  FROM `#__jshopping_products` AS prod
                  LEFT JOIN `#__jshopping_products_to_categories` AS categ USING (product_id)                  
                  $adv_from                  
                  WHERE categ.category_id ".$SubCat." AND prod.product_publish = '1' ".$adv_query;