Q&A for aircraft pilots, mechanics, and enthusiasts
---the query looks at the first revisiont with the given tag ---mostly that could correspond to tag creator ---in some cases the post where the tag was created might have been deleted ; with tagshistory_cte AS ( SELECT Id AS phid, replace(value,'>','') TagName FROM PostHistory CROSS APPLY STRING_SPLIT(Text,'<') Where PostHistoryTypeId in (3,6,9) and len(value) > 0 ), tagsfirst_cte AS ( SELECT tagname, MIN(phid) AS firstid FROM tagshistory_cte GROUP BY tagname ) SELECT t.tagname, ph.UserDisplayName FROM tagsfirst_cte t INNER JOIN PostHistory ph ON ph.id=t.firstid --GROUP BY ph.UserId, ph.UserDisplayName