instruction: person's comments on foreign posts.
response: SELECT comment.Id AS "comment_link", commenter.DisplayName AS commenter, CASE WHEN pop.DisplayName IS NULL THEN NULL ELSE op.DisplayName END AS answerer, CASE WHEN pop.DisplayName IS NULL THEN op.DisplayName ELSE pop.DisplayName END AS asker FROM Comments AS comment JOIN Users AS commenter ON commenter.Id = comment.UserId JOIN (Posts AS opPost JOIN Users AS op ON op.Id = opPost.OwnerUserId) ON opPost.Id = comment.PostId LEFT JOIN (Posts AS popPost JOIN Users AS pop ON pop.Id = popPost.OwnerUserId) ON popPost.Id = opPost.ParentId WHERE commenter.Id = '##UserID##' AND op.Id != '##UserID##' AND (pop.Id != '##UserID##' OR pop.Id IS NULL) ORDER BY comment.Id DESC