Товары подкатегорий в категории - JoomShopping

$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->escape($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;
 

addLinkToProducts($products, $category_id);

addLinkToProducts($products, $SubCat);

<?php defined('_JEXEC') or die(); ?>
<div class="main_cat">
<h1><?php print $this->category->name?></h1>
<?php print $this->category->description?>
<?php include(dirname(__FILE__)."/products.php");?>
</div>

<?php defined('_JEXEC') or die(); ?>
<?php if ($this->display_list_products){?>
<?php include(dirname(__FILE__)."/../".$this->template_block_form_filter);?>
 
<?php // start main category items?>
 <?php if (count($this->rows)){?>
 <div class="main_products"> 
 <?php foreach ($this->rows as $k=>$product){?>
 
 <?php if (($product->category_id) == ($this->category->category_id)) {?>
 
 <div class="product_item w<?php print $this->count_product_to_row?>" >
 <?php include(dirname(__FILE__)."/../list_products/".$product->template_block_product);?>
 <?php //include (JPATH_COMPONENT."/templates/".$this->category->category_template."/list_products/". $product->template_block_product);?>
 </div>
 
 <?php }?>
 
 <?php }?>
 </div>
 <?php } //end main items?>
 
 
<div class="jw_category">
 <?php if (count($this->categories)){ //start children categories?>
 <div class = "jw list_category">
 <?php foreach($this->categories as $k=>$category){?>
 
 <div class="jw_cat">
 <div class = "category">
 
 <?php if ($category->category_image) { //caterory image?> 
 <div class="image">
 <a href = "<?php print $category->category_link;?>"><img class="jshop_img" src="<?php print $this->image_category_path;?>/" alt="<?php print htmlspecialchars($category->name)?>" title="<?php print htmlspecialchars($category->name)?>" /></a>
 </div>
 <?php } //end cat image?>
 <div class="cat_link">
 <a class = "cat_title" href = "<?php print $category->category_link?>"><?php print $category->name?></a>
 <p class = "jw_cat_sdesc"><?php print $category->short_description?></p>
 </div>
 </div>
 
 <?php if (count($this->rows)){ // start children category items?>
 <div class="jw_products"> 
 <?php foreach ($this->rows as $k=>$product){?>
 
 <?php if (($product->category_id) == ($category->category_id)) {?>
 
 <div class="product_item w<?php print $this->count_product_to_row?>" >
 <?php include(dirname(__FILE__)."/../list_products/".$product->template_block_product);?>
 </div>
 
 <?php }?>
 
 <?php }?>
 </div>
 <?php } // end children category items?>
 <?php if ($this->display_pagination){
 include(dirname(__FILE__)."/../".$this->template_block_pagination);
 }?>
 
 </div> 
 <?php } ?>
 </div>
 <?php } // end children categories?>
</div> 
 
 
<?php }?>

<div class="jshop_list_product">    
<?php
    include(dirname(__FILE__)."/../".$this->template_block_form_filter);
    if (count($this->rows)){
        include(dirname(__FILE__)."/../".$this->template_block_list_product);
    }
    if ($this->display_pagination){
        include(dirname(__FILE__)."/../".$this->template_block_pagination);
    }
?>
</div>

<?php } // end children categories?>