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.CreationDate as [Asked On], 
    a.CreationDate [Answered On],
    CONCAT(q.Title, ' ', q.Body) AS [Question],
    a.Id AS [Answer ID],
    a.Body AS [Answer], 
    q.Score as [Score],
    q.Tags as [Tags]
FROM
    Posts AS q
INNER JOIN
    Posts AS a ON q.Id = a.ParentId
WHERE
    q.PostTypeId = 1 -- 1 represents questions
    AND a.PostTypeId = 2 -- 2 represents answers
    AND (
      q.Tags LIKE '%servicenow%' -- Replace 'your-tag-here' with the desired tag
      -- OR q.
      )
    AND q.Score > 0 -- Only if you end up with more than 50k answers
ORDER BY
    q.CreationDate DESC; -- Order by the "Score" column in descending order

fork query

edited sep 25 anonymous

created sep 20 jon.doe42789