Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs
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