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