title: mysql fulltext search sort best results then sort again by other item
body: <pre><code>"SELECT *, 
      MATCH(md.keywords) AGAINST('$meta[keywords]') AS score
      FROM 
          meta_data AS md 
      INNER JOIN
          sites AS si ON md.domain = si.domain
      WHERE
          MATCH(md.keywords) AGAINST('$meta[keywords]')
      ORDER BY score DESC
      LIMIT 25"
  </code></pre>
  
  <p>I generated this query to find best matching results with fulltext keyword search. Now I want to sort these results again by most viewed entries. The views are also stored inside the mysql database in sites (si.views).</p>
  
  <p>How can I first sort my results by best matching score and then sort these 25 best results by views? I think this will be done somehow with Grouping but I don't know how to get this working. Help would be appreciated. Thanks,</p>