Fatal error: Uncaught Exception: Error: Unknown column 'special' in 'order clause'<br />Error No: 1054<br />SELECT p.product_id, MIN(ps.price) AS special_price FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_special ps ON (p.product_id = ps.product_id AND ps.customer_group_id = '1' AND ((ps.date_start <= NOW() OR ps.date_start = '0000-00-00 00:00:00') AND (ps.date_end > NOW() OR ps.date_end = '0000-00-00 00:00:00'))) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2c.category_id = '8' 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) DESC, LCASE(pd.name) DESC LIMIT 0,15 in /home/itcdnqaw/public_html/pixo/vqmod/vqcache/vq2-system_library_db_mysqli.php:51 Stack trace: #0 /home/itcdnqaw/public_html/pixo/system/library/db.php(16): DB\MySQLi->query('SELECT p.produc...', Array) #1 /home/itcdnqa in /home/itcdnqaw/public_html/pixo/vqmod/vqcache/vq2-system_library_db_mysqli.php on line 51