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

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

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

Print 'from ' + format(@From_Date, 'D') + ' to ' + format(@To_Date, 'D')

SELECT TOP 20 Posts.id
AS [Post Link],
users.id as [User Link],
Posts.CreationDate,
Posts.Score as [Question Score], 
max(Answer.Score) as [max Answer Score],
Posts.ViewCount, 
Posts.FavoriteCount
FROM Posts
inner join
users on
Posts.OwnerUserId = users.id
left join
Posts as Answer
on Answer.parentid = Posts.id and Answer.posttypeid = 2
WHERE Posts.ClosedDate is null
      and Posts.posttypeid = 1
      and Posts.CreationDate between @From_Date and @To_Date
group by Posts.Id,
users.id ,
Posts.CreationDate,
Posts.Score,
Posts.ViewCount, 
Posts.FavoriteCount   
ORDER BY Posts.score DESC

Enter Parameters

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