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 Muslims, experts in Islam, and those interested in learning more about Islam

-- 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 5000
  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

fork query

created apr 19 11 scroberts