Filter by price - manufacturer dropdown missing manufacturer

Code: Select all

					$query = $this->db->query("SELECT m.manufacturer_id, m.name, COUNT(p.product_id) AS products_total FROM " . DB_PREFIX . "product_to_category pc 
					LEFT JOIN " . DB_PREFIX . "product p ON (p.product_id = pc.product_id) 
					LEFT JOIN " . DB_PREFIX . "manufacturer m ON (m.manufacturer_id = p.manufacturer_id) 
					WHERE pc.category_id IN (".$category_ids.") AND p.status = 1 AND p.quantity > -1 
					GROUP BY m.manufacturer_id ORDER BY m.name ASC");

Code: Select all

					WHERE pc.category_id IN (".$category_ids.")  

Code: Select all

			$categoryids_with_childs = array();
			$categoryids_with_childs = $this->model_catalog_category->getCategories($category_id);
			array_push($categoryids_with_childs, $category_id);
			$manufacturers = $this->model_catalog_manufacturer->getManufacturersByCategories($categoryids_with_childs);