2021-04-01 and '2021-06-30'

0

Please login or register to vote for this query.

(click on this box to dismiss)

Genealogy and Family History Meta

Q&A about the site for expert genealogists and people interested in genealogy or family history

DECLARE @StartDate DATE = '2021-04-01';
DECLARE @EndDate DATE = '2021-06-30';

SELECT id  FROM posts  WHERE PostTypeId = 1 AND score > 0  AND AnswerCount > 0 
AND (
      (
        CreationDate BETWEEN @StartDate AND @EndDate
        AND viewcount > 5000 
        AND LastActivityDate BETWEEN DATEADD(MONTH, -6, GETDATE()) AND GETDATE()
      )
      OR
      (
        CreationDate BETWEEN @StartDate AND @EndDate 
        AND viewcount > 10000 
        AND LastActivityDate BETWEEN DATEADD(MONTH, -12, GETDATE()) AND DATEADD(MONTH, -6, GETDATE())
      )
      OR
      (
        CreationDate BETWEEN @StartDate AND @EndDate
        AND viewcount >= 25000 AND viewcount <= 50000 
        AND LastActivityDate < DATEADD(MONTH, -12, GETDATE())
      )
      OR
      (
        CreationDate BETWEEN @StartDate AND @EndDate  
        AND viewcount > 50000  
      )
    )

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results