Fatal error: Uncaught exception 'ErrorException' with message 'Error: Unknown column 'texture' in 'order clause'<br />Error No: 1054<br />SELECT COUNT(*) AS total FROM ( SELECT DISTINCT p.product_id FROM oc_product p LEFT JOIN ( SELECT op.product_id, SUM(op.quantity) AS sales_volume FROM oc_order_product op GROUP BY op.product_id) op ON (op.product_id = p.product_id) LEFT JOIN ( SELECT op.product_id, SUM(op.quantity) AS month_volume FROM oc_order_product op LEFT JOIN oc_order o ON o.`order_id`=op.`order_id` WHERE DATE(o.date_payment) >= '2019-05-27' GROUP BY op.product_id ) oop ON (oop.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN ( SELECT product_id,ROUND(AVG(rating)) AS rating,COUNT(review_id) AS review_num FROM o in /var/www/max/system/database/mysqli.php on line 41