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).

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

SELECT
  BrokenLink.PostId as [Post Link],
  SourcePost.ViewCount as Views,
  SourcePost.Score,
  SourcePost.AnswerCount as Answers,
  MAX(Answer.Score) as AScore,
  (CASE WHEN SourcePost.AcceptedAnswerId IS NULL THEN '' ELSE 'Accepted' END) as Accepted,
  SourcePost.ClosedDate as Closed,
  (CASE
    WHEN SourcePost.AnswerCount > 0 THEN 'No (' + Cast(SourcePost.AnswerCount as VARCHAR) + ' answers)'
    WHEN LockEventType.Name IS NOT NULL THEN 'No (' + LockEventType.Name + ')'
    WHEN SourcePost.Score >= 0 THEN 'If downvoted'
    ELSE 'Yes, on ' + Convert(VARCHAR(10), DateAdd(Day, 30, SourcePost.CreationDate), 126)
  END) as [Roombable?]
FROM
  PostLinks as BrokenLink
  JOIN Posts as SourcePost
    ON SourcePost.Id = BrokenLink.PostId
  LEFT JOIN Posts as TargetPost
    ON TargetPost.Id = BrokenLink.RelatedPostId
  LEFT JOIN Posts as Answer
    ON Answer.PostTypeId = 2
    AND Answer.ParentId = SourcePost.Id
  LEFT JOIN PostHistory as LockEvent
    ON LockEvent.PostHistoryTypeId IN (14, 18)
    AND LockEvent.PostId = BrokenLink.PostId
  LEFT JOIN PostHistoryTypes as LockEventType
    ON LockEventType.Id = LockEvent.PostHistoryTypeId
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,
  SourcePost.ViewCount,
  SourcePost.Score,
  SourcePost.AnswerCount,
  SourcePost.AcceptedAnswerId,
  SourcePost.ClosedDate,
  LockEventType.Name,
  SourcePost.CreationDate
ORDER BY
  SourcePost.ClosedDate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results