My answers with non Delphi tag

1

Please login or register to vote for this query.

(click on this box to dismiss)

List all answer posts to questions without Delphi tag.

Stack Overflow

Q&A for programmers

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

SELECT
    Answer.Id AS [Post Link],
    Answer.Score AS [Score],
    Question.Tags,
    Answer.CreationDate AS [Creation Date]
FROM
    Posts Question
LEFT JOIN Posts Answer ON Question.ID = Answer.ParentId
WHERE
    Answer.PostTypeId = 2 AND
    Answer.OwnerUserId = @MyUserID AND
    Question.Tags NOT LIKE '%<delphi>%'
ORDER BY
    Question.CreationDate
ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results