Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
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 where LinkTypeId=3 group by RelatedPostId,q.ClosedDate order by count(*) desc