Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more
SELECT q.Id as [Post Link],
FROM Posts q
LEFT JOIN Posts a ON a.Id=q.AcceptedAnswerId AND a.PostTypeId=2
WHERE q.PostTypeId = 1
AND q.Tags LIKE '%##TagName1##%'
ORDER BY q.CreationDate DESC