Low views, Low votes and unanswered


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



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

Switch to meta site
loading Hold tight while we fetch your results