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)

Q&A about the site for serious players and enthusiasts of chess

-- 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

fork query

created jul 13 10 Pwninstein