title: CakePHP conditional query with controller that 'hasAndBelongsToMany'
body: <p>I apologize for the horrible title, I couldn't think of how to explain my problem.</p>
  
  <p>In my database I have the following tables, <code>articles</code>, <code>tags</code>, and <code>articles_tags</code>. An article can have many tags.</p>
  
  <p>Currently I am able to grab all the articles, with all the tags, but I want to be able to find articles based upon it's tags.</p>
  
  <p>My select is simple:</p>
  
  <pre><code>$articles = $this-&gt;Article-&gt;find('all', array(
      // extra condition to check for tag, maybe?
      'conditions'    =&gt; array('Article.status' =&gt; 'active'), 
      'limit'         =&gt; $this-&gt;articles_per_page,
      'offset'        =&gt; ($page_num-1)*$this-&gt;articles_per_page
  ));
  </code></pre>
  
  <p>My return from the database is as follows:</p>
  
  <pre><code>Array
  (
  [0] =&gt; Array
      (
          [Article] =&gt; Array
              (
                  [id] =&gt; 1
              )
  
          [Tag] =&gt; Array
              (
                  [0] =&gt; Array
                      (
                          [id] =&gt; 1
                          [name] =&gt; Ruby
                          [slug] =&gt; ruby
                          [uses] =&gt; 1
                          [ArticlesTag] =&gt; Array
                              (
                                  [id] =&gt; 1
                                  [article_id] =&gt; 1
                                  [tag_id] =&gt; 1
                              )
  
                      )
  
              )
  
      )
  </code></pre>
  
  <p>What do I do if I only want to return the articles with a <code>Ruby</code> tag?</p>