I'm doing a site for a company that restore and sells classic Ford Mustangs. Posts about individual car are generally be in three categories; year, model, and whether is is For Sale, Sold, Project, or Restoration.
65, coupe, sold
67, fastback, for sale
68, convertible, restoration
They want For Sale and Sold cars posts to come first in any category so if you click on, say, fastback, the For Sale fastbacks come first followed by Sold fastbacks, then everything else.
Is there a way to do this elegantly? (I could kludge it by changing date published of Sold cars to more recent than other posts, but obviously this would be a pain.)