My questions in danger of auto-delete (after 30 days, not locked)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

---This includes simply the questions with score<=-1 and no answers 
SELECT TOP(##num?500##)
  q.Id AS [Post Link], 
  q.OwnerUserId AS [User Link],
  q.CreationDate, DATEDIFF(day, q.CreationDate, CAST(GETDATE() AS Date)) AS [Days],
  q.AnswerCount, q.CommentCount,
  q.Score, q.ViewCount, q.Tags
FROM Posts q
WHERE (q.OwnerUserId=##userid##) AND (q.Score<=-1) AND (q.AnswerCount=0) AND (q.PostTypeId=1) AND
---do not include locked questions
  (q.Id not IN 
    (SELECT ph1.PostId FROM PostHistory ph1 INNER JOIN Posts q ON ph1.PostId=q.Id WHERE (q.PostTypeId=1) AND (ph1.PostHistoryTypeId=14) AND 
      (q.Id NOT IN 
        (SELECT ph2.PostId FROM PostHistory ph2 WHERE ph2.PostHistoryTypeId=15)
      )
    )  
  )  
ORDER BY q.CreationDate ASC

Enter Parameters

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