declare @tagid int set nocount on SELECT @tagid = Id f...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

-- X most recent answers tagged Y from user Z
-- Show the X most recent answers tagged Y from user Z

declare @tagid int

set nocount on

SELECT @tagid = Id from Tags where TagName = ##Tag:string##

SELECT p.Id as [Post Link], p.OwnerUserId as [User Link], p.CreationDate as [Answer Date]
FROM Posts p
INNER JOIN PostTags pt on p.ParentId = pt.PostId AND pt.TagId = @tagid 
INNER JOIN Posts question on p.ParentId = question.Id
WHERE p.PostTypeId = 2 -- 2 = Answer
AND p.OwnerUserId NOT IN (21576,30,9289,27627,1743) 
ORDER BY p.CreationDate DESC

Enter Parameters

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