Позиции (дочерние товары) в расширенном поиске - [VM1] Управление товарами, атрибутами, типами, ценами

$join_array[] = "LEFT JOIN `#__{vm}_product_type_$product_type_id` ON `#__{vm}_product`.`product_id` = `#__{vm}_product_type_$product_type_id`.`product_id` ";

$join_array[] = "LEFT JOIN `#__{vm}_product_type_$product_type_id` ON `#__{vm}_product`.`product_id` = `#__{vm}_product_type_$product_type_id`.`product_relative_id` ";

		if($category_id && !chpconf::option('custom_ptid')){ // becuase we use custom PTI in some category - we don't want wrong category_id to be added
			$tables="`#__vm_product_type_{$this->ptid()}` as pt";
			$joins="LEFT JOIN `#__vm_product_category_xref` as pcx ON pt.`product_id`=pcx.`product_id` ".$joins;
			$where="pcx.`category_id`=$category_id ".$where;
			// uncomment this, comment above 1 line--for search with Child Products
			//$where="(pcx.`category_id`=$category_id OR `product_parent_id`<>0) ".$where;
		}else{
			$tables="`#__vm_product_type_{$this->ptid()}` as pt, `#__vm_product_category_xref` as pcx";
			$where="pt.`product_id`=pcx.`product_id` ".$where;
			// uncomment this, comment above 2 lines--for search with Child Products
			//$tables="`#__vm_product_type_{$this->ptid()}` as pt";
			//$where="1 ".$where;
		}

		if($category_id && !chpconf::option('custom_ptid')){ // becuase we use custom PTI in some category - we don't want wrong category_id to be added
			$tables="`#__vm_product_type_{$this->ptid()}` as pt";
			$joins="LEFT JOIN `#__vm_product_category_xref` as pcx ON pt.`product_id`=pcx.`product_id` ".$joins;
			//$where="pcx.`category_id`=$category_id ".$where;
			// uncomment this, comment above 1 line--for search with Child Products
			$where="(pcx.`category_id`=$category_id OR `product_parent_id`<>0) ".$where;
		}else{
			//$tables="`#__vm_product_type_{$this->ptid()}` as pt, `#__vm_product_category_xref` as pcx";
			//$where="pt.`product_id`=pcx.`product_id` ".$where;
			// uncomment this, comment above 2 lines--for search with Child Products
			$tables="`#__vm_product_type_{$this->ptid()}` as pt";
			$where="1 ".$where;
		}