Inactive questions with no answers for a specific tag (ViewCount ASC)
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