Sample, simple question query by tag

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
    q.Id AS [Post Link],
    q.LastActivityDate,
    q.Tags
FROM        Posts           q
INNER JOIN  PostTags        pt
ON          q.Id            = pt.PostId
INNER JOIN  Tags            t
ON          t.Id            = pt.TagId
WHERE       q.PostTypeId    = 1 -- questions
AND         t.TagName       IN ('inflation')
ORDER BY    q.LastActivityDate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results