SELECT p.Title, p.Id, p.ClosedDate, p.Tags, p.Score, p.An...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts Meta

Q&A about the site for enthusiasts and power users of the Android operating system

SELECT p.Title, p.Id, p.ClosedDate, p.Tags, p.Score, p.AnswerCount, p.AcceptedAnswerId, u.DisplayName, u.Reputation, p.CreationDate, p.LastEditorUserId, p.body

FROM Posts p
JOIN Posts a ON p.AcceptedAnswerId = a.Id
JOIN Users u ON p.OwnerUserId = u.Id
WHERE p.PostTypeId = 1 AND p.CreationDate> '2019-7-23 00:00:00'

Enter Parameters

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