Crap Question Cleanup

0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions with at least one delete vote already, and no answers.

Anime and Manga

Q&A for anime and manga fans

-- No Answer, Closed, 1+ Delete Vote Questions
-- Questions with at least one delete vote already, probable need to be finished.

SELECT p.ID as [Post Link], p.Score, p.Title
   FROM Posts p
   INNER JOIN PostHistory ph ON ph.PostId = p.Id
   INNER JOIN PostFeedback pf on pf.PostId = p.Id
   WHERE ph.PostHistoryTypeId = 10
      AND p.AnswerCount = 0
      AND pf.VoteTypeID = 1

Enter Parameters

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