I’m trying to get product collection of all products that has special_price and their special_to_date is less than today’s date, and they belong to a specific category. I tried the bellow code but it goes through a loop. $products = Mage::getModel('catalog/product') ->getCollection() ->joinField('category_id', 'catalog/category_product', 'category_id', 'product_id = entity_id', null) ->addFieldToFilter('category_id', […]