Fatal error: Uncaught Exception: Error: Unknown column 'weekdays' in 'where clause'<br />Error No: 1054<br />SELECT DISTINCT ps.product_id, (SELECT AVG(rating) FROM oc_review r1 WHERE r1.product_id = ps.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating FROM (
SELECT PS.product_id, PS.customer_group_id, PS.date_start, PS.date_end, PS.priority, PS.price
FROM oc_product_special PS
UNION
SELECT P.product_id, PGS.customer_group_id, PGS.date_start, PGS.date_end, PGS.priority, PGS.price
FROM oc_liveprice_global_special PGS, oc_product P
WHERE (P.manufacturer_id = PGS.manufacturer_id OR PGS.manufacturer_id = -1)
AND (P.product_id IN (SELECT PTC.product_id FROM oc_product_to_category PTC WHERE PTC.category_id = PGS.category_id ) OR PGS.category_id = -1)
AND (PGS.filter_id IN ( SELECT PF.filter_id FROM oc_product_filter PF WHERE PF.product_id=P.product_id ) OR PGS.filter_id = -1 )
) ps LEFT JOIN oc_product p ON (ps.product_id = p.product_id) LEFT JOIN oc_product_description pd ON ( in /var/www/www-root/data/www/royal-rolls.com/system/library/db/mysqli.php on line 40