Q&A for professional and enthusiast programmers
select top 30 concat('**',replace(str(count(*),3),' ', ' '),'**') as dups, concat(' http://stackoverflow.com/q/', RelatedPostId) as Q, case when q.ClosedDate is not null then '*' else '' end as Closed from PostLinks join Posts q on q.Id=RelatedPostId join PostTags p on p.PostId=q.Id join Tags t on p.TagId=t.id where LinkTypeId=3 and t.TagName='bash' group by RelatedPostId,q.ClosedDate order by count(*) desc