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.Score AS [QScore],
  q.Id AS [Post Link],
  q.Title,
  q.Tags,
  q.Body AS [Question Body],
  q.OwnerUserId AS [Questioner],
  a.Score AS [AScore],
  a.Body AS [Answer Body],
  a.CreationDate AS [AnswerDate],
  CASE 
    WHEN q.AcceptedAnswerId = a.Id THEN 1
    ELSE 0
  END AS [IsAcceptedAnswer]
FROM
  Posts AS q
    JOIN Posts AS a
      ON a.ParentId = q.Id
WHERE
  q.Body LIKE '%visa%' OR
  q.Body LIKE '%immigration%' OR
  q.Body LIKE '%citizenship%' OR
  q.Body LIKE '%green card%' OR
  q.Body LIKE '%passport%';

fork query

edited nov 28 anonymous

created oct 23 jon.doe46100