Duplicate "Duplicate" post notices (Thanks to Samuel Liew for a good basis)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

SELECT TOP 1000
         p.CreationDate,
         p.Id AS [Post Link],
         p.Score,
         p.ViewCount,
         p.AnswerCount
    FROM Posts p
   WHERE p.PostTypeId = 1
     AND p.ClosedDate IS NOT NULL
     AND p.DeletionDate IS NULL
     AND p.Body LIKE '%Possible Duplicate:%'
ORDER BY p.ViewCount DESC

Enter Parameters

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