Unanswered questions with high page views

1

Please login or register to vote for this query.

(click on this box to dismiss)

Lists unanswered questions with a high number of page views that are still open with no answers

Engineering

Q&A for professionals and students of engineering

SELECT TOP 50 P.Id, P.Title, P.ViewCount, P.Score
FROM  Posts AS P
WHERE P.AnswerCount = 0
  AND P.PostTypeId = 1
  AND P.ClosedDate IS NULL
  AND P.CommunityOwnedDate IS NULL
  AND NOT EXISTS (SELECT 1
                  FROM PostHistory AS H
                  WHERE H.PostId = P.Id
                  AND H.PostHistoryTypeId NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 24, 25))
ORDER BY ViewCount DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results