1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

;WITH QUERY AS
(
SELECT
  P.Title,
  P.Body,
  P.Tags,
  ROW_NUMBER() OVER(ORDER BY P.Id DESC) AS 'ROW'
FROM 
  Posts P
LEFT JOIN
  PostTypes PT ON P.PostTypeId = PT.Id
WHERE 
  P.CreationDate BETWEEN ##BeginningDate## AND ##EndDate## -- Dates : 'aaaa-mm-dd'
  AND PT.Name = 'Question'
  AND len(P.Tags) > 0
  -- Other filters available
)

SELECT
  *
FROM 
  QUERY
WHERE 
  ROW BETWEEN ##Offset1## AND ##Offset2##

fork query

edited feb 22 Emeric.D.

created feb 21 anonymous