1052. Query Error 1052: Column 'price' in where clause is ambiguous
Query: SELECT p.*,p.id
FROM shop_product p
JOIN shop_product_skus ps1
ON ps1.product_id = p.id
JOIN shop_product_features pf1
ON p.id = pf1.product_id AND pf1.feature_id = 73
JOIN shop_category_products cp1
ON p.id = cp1.product_id
WHERE ps1.available > 0 AND ps1.status
AND pf1.feature_value_id IN (2907) AND (pf1.sku_id IS NULL OR pf1.sku_id = ps1.id)
AND p.status = 1
AND cp1.category_id = 1094
AND price IS NOT NULL AND price > 0.0 AND count IS NOT NULL AND count > 0.0
GROUP BY p.id
ORDER BY p.price ASC, p.id
LIMIT 3
