postes_2020-2021

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT TOP 10 p1.Body, p1.Title, p1.Tags, p2.Body as Answer, p1.CreationDate
FROM Posts p1
JOIN Posts p2 on p1.AcceptedAnswerId = p2.Id
WHERE (p1.CreationDate between '2020/10/01' and '2021/10/01')
     AND p1.Score>-1
     AND p1.PostTypeId=1 AND p1.AcceptedAnswerId IS NOT NULL
ORDER BY p1.CreationDate DESC

Enter Parameters

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