0

Please login or register to vote for this query.

(click on this box to dismiss)

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
WHERE q.PostTypeId = 1
AND q.Score<0
AND a.Score<0

ORDER BY q.CreationDate DESC

view current version

edited may 23 20

created may 23 20 jon.doe31697