0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam

SELECT 
    q.Id AS [Post Link],
    q.CreationDate AS [Question Creation Date],
    q.Score AS [Question Score],
    q.ViewCount AS [Question View Count],
    q.Title AS [Question Title],
    a.Id AS [Answer Link],
    a.CreationDate AS [Answer Creation Date],
    a.Score AS [Answer Score]
FROM Posts q
INNER JOIN Posts a ON q.Id = a.ParentId
WHERE
    q.Tags LIKE '%python%' AND
    q.CreationDate > DATEADD(year, -1, GETDATE()) AND
    a.PostTypeId = 2 -- 2 is the post type id for answers
ORDER BY q.Score DESC

fork query

edited mar 28

created mar 28 anonymous