My dead weight answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Skeptics

Q&A for scientific skepticism

SELECT a.Id [Post Link], a.CreationDate, ph.PostHistoryTypeId
FROM Posts a
INNER JOIN Posts q ON q.Id = a.ParentId
LEFT JOIN Votes v ON v.PostId = a.Id
LEFT JOIN PostHistory ph ON ph.PostId = a.Id
WHERE a.PostTypeId = 2
AND q.PostTypeId = 1
AND a.OwnerUserId = ##UserId##
AND v.Id IS NULL
AND q.AnswerCount > 1
ORDER BY a.CreationDate ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results