Q&A about the site for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment
select top 30 count(*) as dups, RelatedPostId as [target], iif(max(q.ClosedDate) is not null, '*', '') as Closed, iif(max(q.DeletionDate) is not null, '*', '') as Deleted from PostLinks join PostsWithDeleted q on q.Id=RelatedPostId where LinkTypeId=3 group by RelatedPostId order by count(*) desc