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

プログラマーとプログラミングに熱心な人々のための質問と回答

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

fork query

edited mar 5 12 anonymous

created jan 25 11 KronoS