I have some rows that are ordered by a count DESC. That's fine, but I want to "pin" some specified fields to the top of the results. This field is empty for most results, but there are a few that have the date: first, second, third...
ORDER by FIELD (rating, 'first', 'second', 'third'), count DESC
This doesn't work! How can I get the results to show the 'first', 'second', 'third' first and then order the rest by count DESC?