Find questions that are marked as duplicate but not closed

0

Please login or register to vote for this query.

(click on this box to dismiss)

Philosophy Meta

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

SELECT p.Id AS [Post Link], p.Score AS 'Score',
(SELECT COUNT(pp.Id) from Posts as pp
WHERE pp.ParentId = p.Id)
AS 'answers',
  p.CreationDate AS 'Created',
  p.ClosedDate AS 'Closed',
  c.Id AS [Comment Link],
  c.Score AS 'Votes'
FROM Comments AS c
  LEFT JOIN Posts AS p
    ON c.PostId = p.Id
WHERE c.Text COLLATE SQL_Latin1_General_CP1_CI_AS 
               LIKE 'Possible duplicate of%'
    OR c.Text COLLATE SQL_Latin1_General_CP1_CI_AS 
               LIKE 'Does this answer your question%'
    AND p.PostTypeId = 1
  ORDER BY c.Score DESC

Enter Parameters

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