Probable tag creations for a specific user

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

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

SELECT p.Id AS [Post Link], t.TagName
FROM (
SELECT pt.TagId, MIN(p.CreationDate) AS CreationDate
  FROM PostTags AS pt
  INNER JOIN Posts AS p ON p.Id = pt.PostId
  GROUP BY pt.TagId
  ) AS temp
INNER JOIN PostTags AS pt ON pt.TagId = temp.TagId
INNER JOIN Posts AS p ON p.Id = pt.PostId
                     AND p.CreationDate = temp.CreationDate
INNER JOIN Tags AS t ON temp.TagId = t.Id
WHERE p.OwnerUserId = ##UserId:int##

Enter Parameters

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