Is it possible to have "ORDER BY (put this the record where this='this' first, then the rest in order)" ?
Sort of an order by BUT do this first..
You could try using the HAVING function.