0

Please login or register to vote for this query.

(click on this box to dismiss)

Find Possible Duplicates on the site via Comments that are still open

Q&A for anime and manga fans

-- Possible Duplicates
-- Find Possible Duplicates on the site via Comments

SELECT P.Id as [Post Link], P.Score, Text
FROM Comments AS C, Posts AS P
WHERE Text LIKE '%dup%'
AND P.Id = C.PostID AND P.PostTypeID = 1
AND P.ClosedDate IS NULL
AND P.AnswerCount > 0

fork query

edited jan 26 12 jrg

created nov 18 11 Marco Ceppi