The most upvoted questions posted recently (adjust time period as desired)
Q&A for Drupal developers and administrators
-- Recent popular questions -- The most upvoted questions posted recently (adjust time period as desired) SELECT top 100 id as [Post Link], score from posts where posttypeid = 1 and creationdate > DATEADD(MONTH, -1, GETDATE()) order by score desc