Most popular questions from last 30 days

1

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

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

select top 50
    'http://stackoverflow.com/questions/' + cast(Posts.Id as varchar(50)) [link], 
    Title,
    AnswerCount + CommentCount + FavoriteCount as score,
    ViewCount,
    Tags [Tags],
    CreationDate
FROM Posts    
WHERE    
CreationDate > DATEADD(DAY, -30, GETDATE())
and tags like '%<' + ##tag:string?java## + '>%'
and ClosedDate is null
and PostTypeId = 1
and AnswerCount + CommentCount + FavoriteCount > 0

Order By [ViewCount] Desc

Enter Parameters

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