SELECT * FROM (SELECT
		MIN(
			COALESCE(src.price_override, p.price)
			* (1 + COALESCE(t.p_rate, 0) / 100)
			+ COALESCE(t.f_rate, 0)
		) AS p_min,
		MAX(
			COALESCE(src.price_override, p.price)
			* (1 + COALESCE(t.p_rate, 0) / 100)
			+ COALESCE(t.f_rate, 0)
		) AS p_max
		FROM oc_product AS p JOIN oc_product_to_category AS p2c ON p2c.product_id = p.product_id AND `p2c`.`category_id` IN(2036)
		LEFT JOIN (
			SELECT
			u.product_id,
			MIN(u.price) AS price_override
			FROM (
				SELECT product_id, price
					FROM oc_product_special
				 WHERE customer_group_id = 1
				) AS u
				GROUP BY u.product_id
			) AS src
			ON src.product_id = p.product_id

		LEFT JOIN (
			SELECT
			tr1.tax_class_id,
			MAX(CASE WHEN tr2.type = 'F' THEN tr2.rate ELSE 0 END) AS f_rate,
			MAX(CASE WHEN tr2.type = 'P' THEN tr2.rate ELSE 0 END) AS p_rate
			FROM oc_tax_rule   AS tr1
			JOIN oc_tax_rate   AS tr2
			ON tr1.tax_rate_id = tr2.tax_rate_id
			AND tr2.type        IN ('F','P')
			GROUP BY tr1.tax_class_id
		) AS t
		ON t.tax_class_id = p.tax_class_id
		 WHERE `p`.`status` = 1 AND `p`.`quantity` > 0) AS tmp