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

Q&A for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

--Active questions I have answered that have no accepted answer
--Bart McEndree 2024-DEC-13 
SELECT q.id,
       q.title,
       q.AcceptedAnswerId,
       q.CreationDate,
       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 --No accepted answer since Sunday morning around 3:00 UTC
--AND q.AnswerCount>2
AND q.ClosedDate IS NULL
ORDER BY q.CreationDate desc

/*
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.
*/

fork query

edited dec 13

created dec 13 anonymous