Duplicates that are missing the "Possible Duplicate" bit

0

Please login or register to vote for this query.

(click on this box to dismiss)

Engineering

Q&A for professionals and students of engineering

SELECT p.Score,
       p.Id          AS [Post Link],
       p.ViewCount,
       p.OwnerUserId AS [User Link],
       p.CreationDate
FROM   Posts p
       INNER JOIN PostHistory h
         ON h.PostId = p.Id
WHERE  p.ClosedDate IS NOT NULL
       AND p.ClosedDate = h.CreationDate
       AND h.PostHistoryTypeId = 10
       AND h.Comment = '1'
       AND p.Body NOT LIKE '%<strong>Possible Duplicate:</strong>%'
       AND p.Body NOT LIKE '%<strong>Possible Duplicates:</strong>%'
ORDER  BY p.CreationDate ASC

Enter Parameters

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