0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for designers and implementers of computer programming languages

SELECT T.TagName, A.ParentId, A.CreationDate 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 ASC

fork query

edited jul 24 23

created jul 24 23 The Thonnu