A Database Error Occurred

Error Number: 1052

Column 'product_id' in order clause is ambiguous

SELECT p.*, pd.*, pds.free_shipping, m.name as manufacturer, pv.product_variant_id as has_variants, p.price * ((100 - p.discount) / 100) AS discounted FROM `product` p JOIN `product_description` pd ON (p.product_id = pd.product_id AND pd.lang_id = 'sk') LEFT JOIN `product_discount` pds ON (p.product_id = pds.product_id) LEFT JOIN `manufacturer` m ON (p.manufacter_id = m.manufacturer_id) LEFT JOIN `product_variant` pv ON (pv.product_id = p.product_id) LEFT JOIN `product_category` pc ON (p.product_id = pc.product_id) WHERE p.product_id != 0 && pc.category_id = '322' && p.status > 0 GROUP BY p.product_id ORDER BY product_id ASC LIMIT 0, 20

Filename: models/Product_model.php

Line Number: 344