3

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 professional and enthusiast programmers

-- Possible open bug report questions
-- Find Possible bug report questions on the site via Comments

SELECT P.Id as [Post Link], P.Score, Text
FROM Comments AS C, Posts AS P
WHERE Text LIKE '%bug report%'
AND P.Id = C.PostID AND P.PostTypeID = 1
AND P.Id NOT IN (SELECT sP.ParentId FROM Posts AS sP WHERE Score > 0 AND sP.ParentId = P.Id)
AND P.AcceptedAnswerId IS NULL
AND P.ClosedDate IS NULL

fork query

edited oct 16 12

created nov 18 11 Marco Ceppi