Selected country
WAHL Global logo

Professional Animal Grooming

Products

0 products match your search criteria

Narrow Your Results
Categories
I'm trying to:
Product Type
Price

Sort By:

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 = 'proAnimalGrooming' AND ( productTypeFilter like '%clipperBlades%') ORDER BY importance DESC