0

Please login or register to vote for this query.

(click on this box to dismiss)

All non-CW questions with at least 1000 views ordered by votes ascending so that the least popular of the questions is on top

Q&A about the site for administrators, end users, developers and designers for Craft CMS

-- Most popular bad questions
-- All non-CW questions with at least 1000 views ordered by votes ascending so that the least popular of the questions is on top

Select TOP 1000
  question.Id as [Post Link],
  question.Score,
  question.AnswerCount as "Answer Count",
  question.ViewCount
from
  Posts as question
where  
  question.CommunityOwnedDate is null and
  question.PostTypeId=1 and
  question.ViewCount > 1000
order by question.Score asc, question.ViewCount desc

view current version

edited apr 19 11

created apr 19 11 scroberts