Low views, Low votes and unanswered

0

Please login or register to vote for this query.

(click on this box to dismiss)

A list of old questions that are unanswered and low quality

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

-- Low views, high votes yet unanswered
-- A list of questions with a high score and low view count

select top 500 Id as [Post Link], Score, ViewCount, CreationDate from Posts 
where Id NOT IN
(
     SELECT ParentId
     FROM Posts AS P, posthistory, Users AS U
     WHERE PostHistoryTypeId = 10
     AND U.LastAccessDate <= '2010-09-01'
)
AND Score < 2 and ViewCount < 350 and ParentId is null and AcceptedAnswerId is null
and AnswerCount = 0
order by CreationDate asc

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results