Q&A about the site for information security professionals
SELECT q.Id AS question_id, q.Title AS question_title, q.Body AS question_body, a.Id AS answer_id, a.Body AS answer_body FROM Posts q JOIN Posts a ON q.AcceptedAnswerId = a.Id WHERE q.PostTypeId = 1 AND a.PostTypeId = 2 AND ( q.Tags LIKE '%<troubleshooting>%' ) ORDER BY q.CreationDate DESC;