I'm trying to help with the effort in Close all the typo questions. Is there a way that order the results of a search to have oldest-close-votes (those nearest to expiring) at the top of the results? Or is there a way to add number of close votes to the search critera?
To show oldest results first use Order By in Query. Like...
select a.Id as [Post Link], a.Body from Posts q inner join Posts a on a.Id = q.AcceptedAnswerId -- only check accepted answers where len(a.Body) < 200 -- posts less than 200 chars can be a giveaway and q.ClosedDate IS NULL -- only search open questions and ( lower(a.Body) like '%typo%' or lower(a.Body) like '%spelled wrong%' or lower(a.Body) like '%spelled incorrectly%' -- add more... ) Order By a.ID Desc
See the last line Order By a.ID Desc