Q&A about the site for administrators, end users, developers and designers for Craft CMS
DECLARE @StartDate DATE = '2018-1-01'; DECLARE @EndDate DATE = '2018-3-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 ) )