ValeraK

 
public function filterCategory($ctype_name, $category, $is_recursive=false){
 
		$table_name = $this->table_prefix . $ctype_name . '_cats';
		$bind_table_name = $table_name . '_bind';
 
        if (!$is_recursive){
 
            $this->join($bind_table_name, 'b', "b.item_id = i.id AND b.category_id = '{$category['id']}'");
 
        } else {
 
            $this->join($bind_table_name, 'b', 'b.item_id = i.id');
            $this->join($table_name, 'c', "c.id = b.category_id AND c.ns_left >= '{$category['ns_left']}' AND c.ns_right <= '{$category['ns_right']}'");
 
        }
 
//		dump($this->getSQL());
 
        return $this;
 
    }