title: Ordering of grouped rows in mysql
body: <pre><code>SELECT t1.item_id, t1.item, t1.created, t1.owner, t1.type, t1.fld, t2.tag
  FROM items AS t1
  INNER JOIN tagged AS t2 ON t1.item_id = t2.item_id
  WHERE tag
  IN ('how', 'jkas', 'bodor', 'zimp', 'ctuo', 'sjex', 'kek'
  )
  GROUP BY item_id
  ORDER BY t1.created DESC 
  LIMIT 0 , 100
  </code></pre>
  
  <p>How to order items by how many matches they have with IN TAG? I went really deep in manual and I couldn't find the answer and I got lost in stuff I don't understand.</p>