Comments to Answers to my Questions by specific user

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

WITH YourQuestions
     AS (SELECT Id
         FROM   Posts
         WHERE  OwnerUserId = ##UserId##
                AND PostTypeId = 1),
     AnswersToYourQuestions
     AS (SELECT *
         FROM   Posts
         WHERE  ParentId IN (SELECT Id
                             FROM   YourQuestions))
SELECT PostId AS [Post Link],
       CreationDate,
       Id     AS [Comment Link]
FROM   Comments
WHERE  UserId = ##CommenterUserId##
       AND PostId IN (SELECT Id
                      FROM   AnswersToYourQuestions)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results