I am trying to create a category with custom SQL that brings up items from a particular category (or categories) that are from a particular Product Manufacturer. So, I get ProductManufacturer = 'Nike' but narrowing it down to a particular category or categories doesn't seem to work:

ProductManufacturer = 'Nike' AND ProductCategory = '3169'

obviously there is some syntax I'm screwing up. I know category can be ProductCategory or CategoryIDs, but nothing I try works. any ideas?