Stack Exchange
log in help

Questions I have answered that have no accepted answer

0

Please login or register to vote for this query.

(click on this box to dismiss)

This query returns a list of questions that I have answered that have no accepted answer. When run you must provide your user ID as a parameter. I use this query to provide a list of questions I can review. For some of them I will manually add a reminder for the author to choose an answer (preferably mine). Please note that SEDE is not using live data. It is only updated every Sunday morning around 3:00 UTC as per this post https://meta.stackexchange.com/questions/280271/why-is-acceptedanswerid-null-for-a-question-that-has-an-accepted-answer Add a comment like this to encourage the user to accept an answer @Kings2407 It was a pleasure working on this with you. If this answer helped solve your question then please consider [accepting it](http://meta.stackexchange.com/a/5235) by clicking the check-mark. This indicates that you've found a solution and gives you some reputation.

Arqade

Q&A for passionate videogamers on all platforms

--Questions I have answered that have no accepted answer
SELECT q.id,
       q.title,
       q.AcceptedAnswerId,
       q.CreationDate,
       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 --No accepted answer since Sunday morning around 3:00 UTC
--AND q.AnswerCount=1 --no competition
AND q.ClosedDate IS NULL
ORDER BY q.CreationDate desc
fork query

Enter Parameters

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