Search for obsolete "please accept" comments on my answers


Please login or register to vote for this query.

(click on this box to dismiss)

Search your own comments for a string. Results show the comment, its score, the date, and a link to the post, newest comments first.

Stack Overflow

Q&A for professional and enthusiast programmers

DECLARE @MyUserID INT = ##UserID:int##

    Comments.Id AS [Comment Link],
    Comments.PostId AS [Post Link]
FROM Comments, Posts Answer
LEFT JOIN Posts Question ON Answer.ParentId =
    Comments.PostId in (Answer.Id, Question.Id) AND
    Answer.Id = Question.AcceptedAnswerId  AND
    Answer.PostTypeId = 2 AND
    Answer.OwnerUserId = @MyUserID AND
    Comments.UserId = ##UserID## AND
    Comments.Text LIKE '%/questions/5234/how-does-accepting-an-answer-work%'
ORDER BY Comments.CreationDate DESC

Enter Parameters

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