SELECT EdgeID, itKey, itVendorId, itRetailPrice, itCurrentPrice, PQty, itImage, itImage1, itImage2, itImage3, itImage4, itImage5, itImage6, itImage7, itImage8, itImage9, itImage10, itVideo, itVideo1, itVideo2, itVideo3, itVideo4, itStatus, itShortDesc, itDesc, catId, catName, catCategoryType, catGenDesc, CollectionTitle, itVendorName, itStyle, itMetalType, itMetalColor, itMetalFinish, itStoneShape, itStoneCount, itStoneType, itStoneSaturation, itStoneTone, itStoneClarity, itStoneLab, Width, Size, catGender, ProdFrom, CommonSKU FROM edgemaster WHERE EdgeID=7456 AND itKey='WDD642-W' AND itStatus='I' and itKey not in ('','Null') and itImage not in ('','Null')