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