Possibly Open Bug Reports

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

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

-- 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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results