Q&A for professional and enthusiast programmers
select LinkTypeId, count(*) from PostLinks where postId not in (select Id from Posts) group by LinkTypeId