0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited aug 16 19 anonymous

created jan 24 14 jon.doe6935