Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.
For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email firstname.lastname@example.org.
Custom Module - Get all products with a specific attribute
Here’s what I’ve got working to select all products with a specific attribute with a specific value. In this case the attribute I’m looking for has an attribute_id of 503 and I want all the products that have that attribute with a value of 1