Did you know that you can sort by a specific field value? I didn’t! If you want certain items that have a certain value in a field to show up first, this is what your order by clause should kind of look like:
ORDER BY field(name_of_field,'value1','value2') DESC
If you want an item with a specific value to show up last instead, replace ‘DESC’ with ‘ASC’.