0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT 
p.Id AS [Question Id], 
p.Title AS [Question Title], 
p.Body AS [Question Body], 
p.CreationDate AS [Question Date], 
a.Id AS [Answer Id],
a.Body AS [Answer Body],
a.CreationDate AS [Answer Date]
FROM Posts p
JOIN PostTags pt ON p.Id = pt.PostId
JOIN Tags t ON pt.TagId = t.Id
JOIN Posts a ON p.AcceptedAnswerId = a.Id
WHERE (t.TagName = ##TagName:string##) AND 
(p.AcceptedAnswerId IS NOT NULL)
ORDER BY p.CreationDate ASC
-- TagName: Tag Name:
-- Date1: Start Date:
-- Date2: End Date:

fork query

edited dec 12

created dec 12 anonymous