Q&A about the site for expert genealogists and people interested in genealogy or family history
DECLARE @StartDate DATE = '2019-10-1'; DECLARE @EndDate DATE = '2019-12-31'; SELECT id FROM posts WHERE PostTypeId = 1 AND score > 0 AND AnswerCount > 0 AND ( ( CreationDate BETWEEN @StartDate AND @EndDate AND viewcount > 10000 AND LastActivityDate BETWEEN DATEADD(MONTH, -6, GETDATE()) AND GETDATE() ) OR ( CreationDate BETWEEN @StartDate AND @EndDate AND viewcount > 15000 AND LastActivityDate BETWEEN DATEADD(MONTH, -12, GETDATE()) AND DATEADD(MONTH, -6, GETDATE()) ) OR ( CreationDate BETWEEN @StartDate AND @EndDate AND viewcount >= 35000 AND viewcount <= 50000 AND LastActivityDate < DATEADD(MONTH, -12, GETDATE()) ) OR ( CreationDate BETWEEN @StartDate AND @EndDate AND viewcount > 50000 ) )