title: How can I count the non-unique combinations of values in MySQL?
body: <p>I have a table with some legacy data that I suspect may be a little messed up. It is a many-to-many join table.</p>
  
  <pre><code>LIST_MEMBERSHIPS
  ----------------
  list_id
  address_id
  </code></pre>
  
  <p>I'd like to run a query that will count the occurrences of each <code>list_id</code>-<code>address_id</code> pair and show the occurrence count for each from highest to lowest number of occurrences.</p>
  
  <p>I know it's got to involve <code>COUNT()</code> and <code>GROUP BY</code>, right?</p>