Q&A about the site for professional linguists and others with an interest in linguistic research and theory
select TOP 100 *,
(select TOP 1 PostID from PostHistory
where PostHistoryTypeId IN (3, 6)
and text like N'%<'+TagName+'>%'
and creationdate > '20150301'
order by creationdate
) as "Post Link"
order by Count desc