title: mysql query to sort alphabetically group by item with count >1 and count = 1 separately on same list
body: <p>I have a list of listings with</p>
  
  <ol>
  <li>Texas with count 5</li>
  <li>New york with count 6</li>
  <li>Alabama with count 4</li>
  <li>LA with 1</li>
  <li>Boston with 1</li>
  <li>Washington with 1</li>
  </ol>
  
  <p>I want to order to</p>
  
  <ol>
  <li>Alabama</li>
  <li>Newyork</li>
  <li>Texas</li>
  <li>Boston</li>
  <li>LA</li>
  <li>Washington</li>
  </ol>
  
  <p>So anything with count(<em>)>1 should be arrange alphabetically to top of list and anything with count(</em>)1 should be arrange alphabetically at bottom of list.</p>
  
  <p>Currently i have used</p>
  
  <pre><code> $orderby = 'counter DESC, display_value ASC';
  </code></pre>
  
  <p>but its giving me </p>
  
  <ol>
  <li>New york</li>
  <li>Texas</li>
  <li>Alabama</li>
  <li>Boston</li>
  <li>LA</li>
  <li>Washington</li>
  </ol>