0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for programming puzzle enthusiasts and code golfers

SELECT T.TagName, A.ParentId, Q.CreationDate AS QuestionCreation, A.CreationDate AS AnswerCreation FROM Tags T
INNER JOIN Posts Q ON (Q.PostTypeId = 1) AND (Q.Tags LIKE CONCAT('%<', T.TagName, '>%')) AND (Q.AnswerCount > 0)
INNER JOIN Posts A ON (A.PostTypeId = 2) AND (A.ParentId = Q.Id)
ORDER BY A.ParentId DESC

fork query

edited jul 24 23

created jul 24 23 The Thonnu