Fatal error: Uncaught Exception: Error: Not unique table/alias: 'p2c'<br />Error No: 1066<br />
SELECT
p.product_id,
p.*,
pd.*,
cd.category_id as category_id,
cd.name as category_name,
shd.shop_id,
shd.name AS shop_name,
(
SELECT
AVG(rating) AS total
FROM 2cz11_review r1
WHERE r1.product_id = p.product_id
AND r1.status = '1'
GROUP BY r1.product_id
) AS rating,
(
SELECT
price
FROM 2cz11_product_discount pd2
WHERE pd2.product_id = p.product_id
AND pd2.customer_group_id = '1'
AND in /sites/cars-az.com/system/library/db/mysqli.php on line 48