Fatal error: Uncaught Exception: Error: Column 'pd.product_id' in on clause is ambiguous<br />Error No: 1052<br />SELECT p.product_id, r.rating, pd.price, ps.price AS special, pd.name, p.model, p.sku, p.upc, p.ean, p.jan, p.isbn, p.mpn, p.quantity, p.weight, p.length, p.width, p.height, p.subtract, p.tax_class_id, p.date_available, p.status, p.date_added, p.date_modified, p.viewed, p.sort_order, p.image, p.manufacturer_id FROM `oc_product` p LEFT JOIN (SELECT product_id, AVG(rating) AS rating FROM `oc_review` WHERE status='1' GROUP BY product_id) r ON r.product_id = p.product_id LEFT JOIN (SELECT product_id, price FROM `oc_product_discount` WHERE customer_group_id = '1' AND ((date_start='0000-00-00' OR date_start < '2025-06-11') AND (date_end='0000-00-00' OR date_end > '2025-06-11')) ORDER BY priority ASC, price ASC) pd ON pd.product_id = p.product_id LEFT JOIN (SELECT product_id, price FROM `oc_product_special` WHERE customer_group_id = '1' AND ((date_start='0000-00-00' OR date_start < '2025-06-11') AND (date_end in /sites/tent-chehol.com/system/library/db/mysqli.php on line 43