Stack Exchange
log in help

Duplicates of deleted questions

10

Please login or register to vote for this query.

(click on this box to dismiss)

This query lists questions that have been closed as duplicates of another question that has since been deleted. Such questions should be either deleted or, if they have good answers or are otherwise of decent quality, reopened. Note that non-locked questions with no answers and a negative score will be automatically deleted by the RemoveDeadQuestions script after 30 days, as indicated by the "Roombable?" column. By default, the results will be sorted with the most recently closed questions first. You can click the column headings to change the sort order. For example, questions with a high answer score may be good candidates for reopening (or for a historical lock), while questions with a high score but no answers may simply need a new dupe target (see http://meta.stackexchange.com/q/291824).

Computational Science

Q&A for scientists using computers to solve scientific problems

SELECT
  BrokenLink.PostId as [Post Link]
FROM
  PostLinks as BrokenLink
  JOIN
    Posts as SourcePost
  ON
    SourcePost.Id = BrokenLink.PostId
  LEFT JOIN
    Posts as TargetPost
  ON
    TargetPost.Id = BrokenLink.RelatedPostId
WHERE
  BrokenLink.LinkTypeId = 3
  AND
    TargetPost.Id IS NULL
  AND
    NOT EXISTS ( 
      SELECT 1 FROM
        PostLinks as OtherLink
        JOIN
          Posts as OtherTarget
        ON
          OtherTarget.Id = OtherLink.RelatedPostId
      WHERE
        OtherLink.LinkTypeId = 3
        AND
          OtherLink.PostId = BrokenLink.PostId
    )
GROUP BY BrokenLink.PostId
ORDER BY BrokenLink.PostId
view current version

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results