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?

2 Answers 2


We do not index the number of close votes on a question (nor would how we store them trigger a re-index), so no...sorting by this isn't possible. You would need to use Stack Exchange Data Explorer or our public data dump to perform such a query.


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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .