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