0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

SELECT P.Id AS [Post_Id],P.OwnerUserId AS [Post_userId],P.CreationDate AS [Post_Creation_Date],P.AcceptedAnswerId AS [Answer_accepted_dummy], P.ViewCount AS [Post_View_Count], P.Title AS [Post_Title], P.Body AS [Post_Body], P.Tags AS [Post_Tags], P.Score AS [Post_Score], P.AnswerCount AS [Post_Answer_Count], P.OwnerUserId AS [Post_Author] FROM Posts AS P WHERE P.PostTypeId = 1  AND P.CreationDate >= '2021-06-01' GROUP BY P.Id,P.OwnerUserId,P.CreationDate, P.ViewCount, P.Title, P.Body, P.Tags, P.Score, P.AnswerCount, P.OwnerUserId, P.AcceptedAnswerId ORDER BY P.CreationDate ASC

fork query

edited may 29 23 jon.doe42024

created may 29 23 anonymous