0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

SELECT
    q.Id AS QuestionId,
    q.Title AS QuestionTitle,
    q.CreationDate AS CreationDate,
    q.Body AS QuestionBody
FROM
    Posts AS q
JOIN
    PostTags AS pt ON q.Id = pt.PostId
JOIN
    Tags AS t ON pt.TagId = t.Id
WHERE
    t.TagName = 'excel'
    AND q.PostTypeId = 1  -- 1 represents questions
ORDER BY
    q.CreationDate DESC

fork query

created aug 30 anonymous