Questions created in Q2 - 2015

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

DECLARE @StartDate Date = '2015-04-01', @EndDate Date = '2015-06-30';

SELECT
  Posts.Title,
  Posts.CreationDate AS [Date Created],
  Users.DisplayName AS [Created By],
  Posts.ViewCount AS Views,
  Posts.Score,
  Posts.FavoriteCount AS [Favorite Count],
  'http://scifi.stackexchange.com/q/' + CAST(Posts.Id AS varchar) AS Link
FROM Posts
  INNER JOIN Users
    ON Posts.OwnerUserId = Users.Id
WHERE Posts.CreationDate BETWEEN @StartDate AND @EndDate
  -- Questions only
  AND PostTypeId = 1
ORDER BY Posts.CreationDate;

Enter Parameters

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