Unanswered Inactive Questions for a Specific Tag

5

Please login or register to vote for this query.

(click on this box to dismiss)

Inactive questions with no answers for a specific tag (ViewCount ASC)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

-- Inactive Questions with No Answers for a Specific Tag
-- Inactive questions with no answers for a specific tag (ViewCount ASC)

SELECT TOP 100 
    Id AS [Post Link], 
    Tags,
    ViewCount,
    CreationDate
FROM 
    Posts 
WHERE 
    LastActivityDate < DATEADD(m, -##MonthsOld##, GETDATE()) AND
    ParentId IS NULL AND 
    AnswerCount = 0 AND
    Tags LIKE '<##Tag##>'

ORDER BY 
    ViewCount ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results