What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 130 Stack Exchange communities.

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?

share|improve this question

2 Answers 2

up vote 1 down vote accepted

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.

share|improve this answer

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

share|improve this answer

You must log in to answer this question.

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