2017 Posts


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for people looking to bypass life's everyday problems with simple tricks

WITH Answers AS (
    SELECT Posts.CreationDate, Posts.Id
    FROM Posts
    JOIN PostTypes on Posts.PostTypeId = PostTypes.Id
    WHERE Posts.CreationDate BETWEEN '2017-01-01' AND '2017-12-31' 
      AND PostTypes.Id = 2

SELECT Posts.CreationDate, Posts.Id, Answers.Id
FROM Posts

JOIN Answers on Posts.AcceptedAnswerId = Answers.Id

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results