0

Please login or register to vote for this query.

(click on this box to dismiss)

All questions without answers, not closed, but still locked. Most of these might be merge stubs which were forgot to be closed.

Q&A for anime and manga fans

-- Non-closed Locked questions without answers
-- All questions without answers, not closed, but still locked.
-- 
-- Most of these might be merge stubs which were forgot to be closed.

select p.Id as [Post Link] , ph.CreationDate AS LockingDate
from Posts p JOIN PostHistory ph ON p.Id = ph.PostID
where  ph.PostHistoryTypeID = 14 -- locked
  and p.PostTypeId = 1 -- question
  and  p.ClosedDate  is null -- not closed
  and p.AnswerCount = 0 -- no answers
order by LockingDate

fork query

created oct 8 11 PaulEbermann