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=7450 AND itKey='WDD627-W' AND itStatus='I' and itKey not in ('','Null') and itImage not in ('','Null')