0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

--Questions I have answered that have no accepted answer
SELECT q.id,q.title,q.AcceptedAnswerId,q.CreationDate,q.ClosedDate, q.DeletionDate, q.score, q.AnswerCount
FROM POSTS a
INNER JOIN POSTS q ON q.id=a.parentid
WHERE a.OwnerUserID=   ##OwnerUserID##  --3389219
AND a.PostTypeId=2 --Answer
AND q.AcceptedAnswerId IS NULL
--AND q.AnswerCount>2
AND q.ClosedDate IS NULL
ORDER BY q.CreationDate desc

fork query

edited dec 13

created dec 13 anonymous