Questions with best score created within 3 month range

0

Please login or register to vote for this query.

(click on this box to dismiss)

The top 200 questions with the most views

Skeptics

Q&A for scientific skepticism

-- Questions with most views
-- The top 20 questions with the most views
DECLARE @To_Date datetime = dateadd(mm,3, ##StartDate##) 
DECLARE @From_Date datetime = ##StartDate##

Print 'from ' + format(@From_Date, 'yyyy-mm-dd') 
--+ ' to ' + convert(@To_Date as string)

SELECT TOP 20 Posts.Id
AS [Post Link],
OwnerDisplayName,
ViewCount,
AnswerCount, 
FavoriteCount, 
Score
FROM Posts 

LEFT JOIN PostTags 
ON PostTags.PostId = Posts.ParentId
    
LEFT JOIN Tags
ON Tags.Id = PostTags.TagId

WHERE ClosedDate is null
      and CreationDate between @From_Date and @To_Date
ORDER BY ViewCount DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results