Selected country
WAHL Global logo

Pet Grooming

Products

1 products match your search criteria

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

Sort By:

MIKE BOYLES TEST PRODUCT

333-333

MSRP: $3.00

Mike Boyles Test

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