SELECT ifnull(si.expdatecutoff,0)expdatecutoff,si.IsExpirable, si.HsnCode,sm.name itemgroup,si.itemid,typename,apolloitemcode,si.ManufactureID,   si.MachineID,si.MajorUnitId,si.MajorUnitName,si.Converter,si.MinorUnitId,si.MinorUnitName,smm.`LocationId`,   '198' panelid,  si.IssueMultiplier,si.PackSize,si.BarcodeOption,si.BarcodeGenrationOption,si.IssueInFIFO, si.MajorUnitInDecimal,si.MinorUnitInDecimal,  ifnull(qut.Rate,0)Rate,ifnull(qut.DiscountPer,0)DiscountPer,ifnull(qut.IGSTPer,0)IGSTPer,ifnull(qut.SGSTPer,0)SGSTPer,ifnull(qut.CGSTPer,0)CGSTPer, '' barcodeno   FROM st_itemmaster si      INNER JOIN st_subcategorymaster sm ON sm.SubCategoryID=si.SubCategoryID     INNER JOIN st_mappingitemmaster smm ON smm.`ItemId`=si.`ItemID`     and si.itemid='903'   AND smm.`LocationId`=24   left join (select Rate,DiscountPer,IGSTPer,SGSTPer,CGSTPer,itemid,ComparisonStatus,EntryDateFrom from st_vendorqutation where vendorid='178' and DeliveryLocationID='24'  and IsActive=1 and ApprovalStatus=2 and EntryDateTo>=date(now()) order by EntryDateFrom desc) qut on qut.itemid=si.itemid   AND si.isactive=1 AND si.approvalstatus=2  and  ifnull(qut.Rate,0)>0 ORDER BY qut.EntryDateFrom Desc