Most duplicated questions

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

select top 30 count(*) as dups,
concat('http://stackoverflow.com/q/', RelatedPostId) as Q,
max(Title),
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
-- and Title like '%floating%'
group by RelatedPostId
order by count(*) desc