UPDATE `oc_category` SET (min_price, max_price) = (
SELECT 
	path_id AS category_id,
	MIN(IFNULL(ps.price, p.price)) AS min_price, 
	MAX(IFNULL(ps.price, p.price)) AS max_price
FROM oc_product AS p 
LEFT JOIN oc_product_to_category AS ptc USING(product_id) 
LEFT JOIN oc_category_path USING(category_id)
LEFT JOIN oc_product_special AS ps USING(product_id) 
WHERE IFNULL(ps.price, p.price) > 0
AND path_id IS NOT NULL
AND p.quantity > 1 
AND p.date_available <= NOW() 
GROUP BY path_id)

`category_id` int(11) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `top` tinyint(1) NOT NULL,
  `column` int(3) NOT NULL,
  `sort_order` int(3) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL,
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `min_price` decimal(15,4) NOT NULL DEFAULT 0.0000,
  `max_price` decimal(15,4) NOT NULL DEFAULT 0.0000