0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for administrators, end users, developers and designers for Craft CMS

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 '%<windows>%' OR
    q.Tags LIKE '%<linux>%' OR
    q.Tags LIKE '%<hardware>%' OR
    q.Tags LIKE '%<software>%'

  )
ORDER BY
  q.CreationDate DESC;

fork query

edited mar 29

created mar 28 anonymous