Find Possible Duplicates on the site via Comments that are still open
Q&A about the site for people organizing, marketing or licensing open source development projects
-- 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