title: findManyToManyRowset with Zend_Db_Table_Select
body: <p>I'm trying to use a select object to filter the results of a many to many rowset. This call works great:</p>
  
  <pre><code>$articles = $this-&gt;model-&gt;findArticlesViaArticlesUsers();
  </code></pre>
  
  <p>This however does not:</p>
  
  <pre><code>$articles = new Default_Model_Articles();
  $articleSelect = $articles-&gt;select();
  $articleSelect-&gt;where("status = 'published'")
                -&gt;order("date_published DESC")
                -&gt;limit(1);
  
  $articles = $this-&gt;model-&gt;findArticlesViaArticlesUsers($articleSelect);
  </code></pre>
  
  <p>That throws the following error:</p>
  
  <blockquote>
    <p>exception 'Zend_Db_Select_Exception'
    with message 'You cannot define a
    correlation name 'i' more than once'</p>
  </blockquote>
  
  <p>I can't figure out how to successfully get "articles that have the status of 'published'" using the magic many-to-many relationship (nor <code>findManyToManyRowset</code>). I'm at the end of my rope and thinking of just writing the sql manually. Any ideas?</p>