SELECT * FROM product p INNER JOIN story s ON s.sku=p.skuLook WHERE s.productparent='y' AND productID=4746 AND priceINR != 0