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

Ask Ubuntu

Q&A for Ubuntu users and developers

-- 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 sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached