CHIPS; NAMKEEN & SW

select iItemID, iItemBrandID, vName, vPic, fRate, fMRP, cStock, iQOH from os_item where cStatus="A" and iItemCatID=73 order by iItemID desc