title: Magento Incorrect Collection count with filters
body: <p>The below code I am trying to create a product collection and filter it, however, it is not giving me an accurate product count and I'm not sure why.</p>
  
  <pre><code>$collection = Mage::getModel('catalog/product')-&gt;getCollection();
  $collection-&gt;addAttributeToSelect('*')
          -&gt;joinField('category_id', 'catalog/category_product', 'category_id', 'product_id = entity_id', null, 'left')
          -&gt;addFieldToFilter(array(
                  array('attribute'=&gt;'distributor','in'=&gt;array(intval($distributor))),
  
          ))
          -&gt;addAttributeToFilter('category_id', array(
                  array('finset' =&gt; strval($cat-&gt;getId())),
          ));
  $count = $collection-&gt;getSize();
  </code></pre>
  
  <p>For example, I have a category with that distributor filter that has around 30 products but the count from the above code shows 20.  Same for another one that has 3 products but that count brings back 2.</p>
  
  <p>UPDATE : Fixed the issue myself using finset instead.  See my answer below</p>