SELECT top 1000 a.CreationDate, a.Id, b.Id as [Post Link]...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT top 1000 a.CreationDate, a.Id, b.Id as [Post Link], b.Title, b.Body as Question, a.Body as Answer FROM Posts a
INNER JOIN Posts b
ON a.ParentId=b.Id
WHERE a.OwnerUserId IS NULL
ORDER BY a.CreationDate DESC

Enter Parameters

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