0

Please login or register to vote for this query.

(click on this box to dismiss)

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;

fork query

edited mar 30

created mar 28 anonymous