Query for use by Open Vino support team. Capped at 100 result to avoid too many data pull. Results beyond six month are not included as they are considered abandoned. Result are stored with Added link to question using id.
Q&A for teachers and students of the Esperanto language
SELECT TOP 100 Id, --DateDiff(day,LastActivityDate,GETDATE()) as DaysRemaining, Title, AnswerCount FROM POSTS WHERE Tags='<openvino>' AND AcceptedAnswerId is null AND LastActivityDate > DATEADD(month, -6, GETDATE()) ORDER by AnswerCount ,LastActivityDate