Fatal error: Uncaught Exception: Error: Unknown column 'special' in 'order clause'<br />Error No: 1054<br />SELECT DISTINCT p.product_id, m.manufacturer_id, p.price FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_attribute pa ON (p.product_id = pa.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (m.manufacturer_id = p.manufacturer_id)
JOIN oc_product_option_value pov1 ON (p.product_id = pov1.product_id AND pov1.option_value_id IN( 210))
WHERE pd.language_id = '2'
AND p.status = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0'
GROUP BY p.product_id ORDER BY
(CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE p.price END) in /home/zarring/public_html/system/library/db/mysqli.php:40
Stack trace:
#0 /home/zarring/public_html/system/library/db.php(45): DB\MySQLi->query('SELECT DISTINCT...')
#1 /home/zarrin in /home/zarring/public_html/system/library/db/mysqli.php on line 40