[openvino] unanswered by last activity

0

Please login or register to vote for this query.

(click on this box to dismiss)

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.

Woodworking

Q&A for professional and amateur woodworkers

SELECT TOP 100 
Id AS [Post Link],
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 ASC,LastActivityDate DESC

Enter Parameters

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