The tags where the oldest question with this tag was created by given user

0

Please login or register to vote for this query.

(click on this box to dismiss)

The tags where the oldest question with this tag was created by given user (retags not shown here)

Mathematics

Q&A for people studying math at any level and professionals in related fields

-- The tags where the oldest question with this tag was created by given user
-- The tags where the oldest question with this tag was created by given user (retags not shown here)

DECLARE @userid int = ##user##

select Tags.TagName, min(CreationDate) as OldestQuestionCreationDate, 
    min(Tags.Count) as TagQuestionCount


from Tags join PostTags on Tags.Id = PostTags.TagId 
    join Posts on Posts.Id = PostTags.PostId

where (select top 1 OwnerUserId
from Posts as p join PostTags as pt
    on p.Id = pt.PostId
where Tags.Id = pt.TagId
order by CreationDate) = @userid

group by Tags.Id, Tags.TagName

order by OldestQuestionCreationDate

Enter Parameters

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