Inactive Questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

SELECT TOP ##Top:int?100## 
    Posts.Id AS [Post Link],
    Posts.LastActivityDate

FROM Posts
    INNER JOIN PostTags ON PostTags.PostId = Posts.Id
    INNER JOIN Tags ON Tags.Id = PostTags.TagId

WHERE Posts.PostTypeId = 1 AND
    Posts.CommunityOwnedDate IS NULL AND
    Posts.LastActivityDate < DateAdd(month, -##MonthsOfInactivity:int?12##, GETDATE()) AND
    Tags.TagName = '##Tag?android##'

ORDER BY Posts.LastActivityDate DESC

Enter Parameters

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