Unloved Migrated Questions

Please login or register to vote for this query.

(click on this box to dismiss)

Migrated-In Questions with No Answers in the last 3 Months

Q&A for system administrators and IT professionals

-- Unloved Migrated Questions
-- Migrated-In Questions with No Answers in the last 3 Months

SELECT p.ID as [Post Link], p.Score, p.Title
   FROM Posts p
   INNER JOIN PostHistory ph ON ph.PostId = p.Id
   WHERE ph.PostHistoryTypeId = 17
      AND p.CreationDate > DATEADD(MONTH, -3, GETDATE())
      AND p.AnswerCount = 0

created nov 23 11