SELECT TOP(50000) P.Id, P.CreationDate, P.LastEditDate, P...

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

SELECT TOP(50000) P.Id, P.CreationDate, P.LastEditDate, P.LastActivityDate, P.DeletionDate, P.PostTypeId, P.Score, P.ViewCount, P.AnswerCount, P.CommentCount, P.FavoriteCount, P.Title, P.Body, P.Tags
FROM Posts AS P
JOIN PostHistory AS PH ON P.Id = PH.PostId
-- Filtrage basé sur la colonne PostHistoryTypeId
WHERE P.CreationDate BETWEEN CONVERT(datetime, '2024-02-17') AND CONVERT(datetime, '2024-02-24')
--    AND P.Score >= 0
--    AND P.ViewCount > 10
--    AND P.AnswerCount >= 1
--    AND P.CommentCount IS NOT NULL
--    AND PH.PostHistoryTypeId = 6 
ORDER BY P.CreationDate;

Enter Parameters

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