title: Mysql require relevancy then sort by date
body: <p>On a classfieds ads site, I have a query that looks like this:</p>
  
  <pre><code>SELECT * FROM ads WHERE MATCH (ad_title, ad_description) AGAINST ('VW gearbox')
  </code></pre>
  
  <p>That shows relevant results sorted nicely.
  But I want to keep relevancy while sorting by <code>ad_date</code>. If I directly sort these by date, then it might show results at the very end, and these results are least relevant.</p>
  
  <p>I need to adjust this query to limit the relevancy of results, and only then sort all by date.</p>
  
  <p>I found many similar questions but I must admit I have troubles understanding the sample queries in the other questions. </p>
  
  <p>I did try to append <code>as relevancy</code> but I got a MySQL error.</p>