Snippet: Magento - Using OR and LEFT JOIN in addAttributeToFilter

I'm still pretty new to Magento, and am learning more about it every day. I've been trying to learn all I can about internals such as managing collections & recently stumbled on trying to filter a collection by two attributes. I wanted to build a list of all products that…