Query for use by OpenVino support team.
Capped at 100 result to avoid too many data pull.
Results beyond sixmonth are not included as they are considered abandoned.
Result are stored with
Added link to question using id.
Q&A about the site for serious players and enthusiasts of poker
SELECT TOP 100
Id AS [Post Link],
DateDiff(day,LastActivityDate,GETDATE()) as DaysRemaining,
AND AcceptedAnswerId is null
AND LastActivityDate > DATEADD(month, -6, GETDATE())
ORDER by AnswerCount ASC,LastActivityDate DESC