SELECT distinct productTitle, Video1Thumb, Image1, MSRP, price, Paragraph, categoriesFilter, tryingToFilter, productTypeFilter, serialNumber, url, ProductDescriptionID, importance FROM WahlGlobalKentico.dbo.custom_ProductDescription inner join CMS_Document on custom_ProductDescription.productTitle = CMS_Document.DocumentName WHERE (DocumentPublishTo IS NULL OR DocumentPublishTo > GETDATE()) AND CMS_Document.DocumentCulture = 'en-US' AND categoriesFilter = 'petGrooming' AND ( productTypeFilter like '%clipperBlades%') ORDER BY importance DESC