How to filter an EAV or a flat collection (product, category, sales, etc.) with the addAttributeToFilter() method?

category-collection, eav, filter, collection-filter, sales-collection, collection, eav-collection, db-collection, product-collection