StackOverFlow - scrap questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

;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) - LEN(REPLACE(P.Tags, '<', '')) >= ##NumberOfTag##
  AND P.ViewCount >= ##ViewCount##
  AND P.FavoriteCount >= ##FavoriteCount##
  AND P.AnswerCount >= ##AnswerCount##
)

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

Enter Parameters

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