Accepted answers having question and answer score <0

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT q.Id as [Post Link],
q.Tags,
q.Score,
a.Score,
q.CreationDate,
q.ViewCount,
q.OwnerUserId

FROM Posts q
LEFT JOIN Posts a ON a.Id=q.AcceptedAnswerId AND a.PostTypeId=2
LEFT JOIN Posts u ON u.ParentId=q.Id AND u.Score>0
WHERE q.PostTypeId = 1
AND q.Score<0
AND a.Score<0
AND u.Id IS NULL

Enter Parameters

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