0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT Q.Id AS [Post Link], A.Id AS [Post Link], A.Score
FROM Posts AS Q INNER JOIN Posts AS A ON (Q.Id = A.ParentId)
WHERE Q.PostTypeId = 1 AND A.PostTypeId = 2
AND Q.Tags LIKE concat('%', ##Tag1:string##, '%')
AND Q.Tags LIKE concat('%', ##Tag2:string##, '%')
ORDER BY A.Score DESC;

fork query

edited dec 29 23

created dec 29 23 Bubbler