title: MySQL: Select rows with more than one occurrence
body: <p>Here's my query. It selects a list of ids from two tables across two databases. The query works fine.</p>
  
  <pre><code>select en.id, fp.blogid
  from french.blog_pics fp, french.blog_news fn, english.blog_news en 
  where fp.blogid = fn.id 
  and en.title_fr = fn.title 
  and fp.title != '' 
  </code></pre>
  
  <p>I  only want to display rows where a <code>en.id</code> occurs more than once</p>
  
  <p>So for instance, if this was the current query result</p>
  
  <pre><code>en.id fp.blogid
  ---------------
    10     12
    12     8
    17     9
    12     8
  </code></pre>
  
  <p>I only want to query to show this instead</p>
  
  <pre><code> en.id fp.blogid occurrences
   -----------------------------
    12     8           2
  </code></pre>