Top posts between two dates

1

Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles Meta

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

SELECT TOP(##num?500##)
  Id AS [Post Link],
  Score, CreationDate,
  OwnerUserId AS [User Link], OwnerDisplayName,
  CASE PostTypeId
    WHEN 1 THEN 'Question'
    WHEN 2 THEN 'Answer'
  END
  ViewCount, AnswerCount, Tags, FavoriteCount
FROM Posts
WHERE (PostTypeId IN (##types?1,2##)) AND
  (CreationDate >= '##Date1?2021-01-01##') AND
  (CreationDate <= '##Date2?2022-01-01##') 
ORDER BY SCORE DESC

Enter Parameters

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