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)

Korean Language

Q&A for linguists, teachers and students of the Korean language

-- 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 to meta site
loading Hold tight while we fetch your results