title: Filter Product collection by multiple price ranges
body: <p>I want to filter product collection by some attributes including diy_kit_price attribute (new attribute already added) as shown below.</p>
  
  <p>Price Ranges:</p>
  
  <ol>
  <li>0 - 5000</li>
  <li>10000 - 15000</li>
  </ol>
  
  <p>I tried several ways but no luck.</p>
  
  <p>Working Code: when i am filtering by one price range:</p>
  
  <pre><code>$products = Mage::getModel('catalog/product')-&gt;getCollection()
           -&gt;addAttributeToSelect('*')
           -&gt;addAttributeToFilter('type_id', 'configurable')
           -&gt;joinField('category_id', 'catalog/category_product', 'category_id', 'product_id = entity_id', null, 'left')
           -&gt;addAttributeToFilter('category_id', array(
               array('finset' =&gt; '37')
             ))                
           -&gt;addAttributeToSort('name', 'asc')
           -&gt;addAttributeToFilter('diy_kit_price', array('gt' =&gt; 0))
           -&gt;addAttributeToFilter('diy_kit_price', array('lt' =&gt; 5000));
  </code></pre>
  
  <p>Not Working Code: when i am filtering by one price range:</p>
  
  <pre><code>$products = Mage::getModel('catalog/product')-&gt;getCollection()
           -&gt;addAttributeToSelect('*')
           -&gt;addAttributeToFilter('type_id', 'configurable')
           -&gt;joinField('category_id', 'catalog/category_product', 'category_id', 'product_id = entity_id', null, 'left')
           -&gt;addAttributeToFilter('category_id', array(
               array('finset' =&gt; '37')
             ))                
           -&gt;addAttributeToSort('name', 'asc')
           -&gt;addAttributeToFilter('diy_kit_price', array('gt' =&gt; 0))
           -&gt;addAttributeToFilter('diy_kit_price', array('lt' =&gt; 5000))
           -&gt;addAttributeToFilter('diy_kit_price', array('gt' =&gt; 10000))
           -&gt;addAttributeToFilter('diy_kit_price', array('lt' =&gt; 15000));
  </code></pre>
  
  <p>Is there any other way to filter. Can we filter using plain SQL with multiple price ranges.</p>
  
  <p>Thanks in advance.</p>