The AND command removes products from the Working Set that do not match the expression.
AND expression [ LIMIT expression ]
Examples:
WHERE ebay.active
AND #contains(store.title, 'Toy')
The WHERE command above adds products that are active on eBay to the Working Set. The AND command then removes any products that have titles that do not contain the word 'Toy.'