Fatal error: Uncaught Exception: Error: Unknown column 'ptc.sort_order' in 'field list'<br />Error No: 1054<br />SELECT p.product_id,
pd.name,
p.model,
p.price,
(SELECT AVG(rating) FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1'
GROUP BY r1.product_id) AS rating,
(SELECT COUNT(*) FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1'
GROUP BY r2.product_id) AS reviews,
(SELECT price FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id
AND pd2.customer_group_id = '1'
AND pd2.quantity = 1
AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW())
AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
in /var/www/miniagro/miniagro.ua/system/library/db/mysqli.php on line 43