Most viewed duplicates missing the "Possible Duplicate" bit

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bitcoin

Q&A for Bitcoin crypto-currency enthusiasts

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.ViewCount DESC

Enter Parameters

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