0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for pro webmasters

SELECT p.Id,
       p.ParentId,
       p.AcceptedAnswerId,
       p.PostTypeId,
       p.CreationDate, 
       p.Score,
       p.ViewCount,
       p.Body,
       p.Title,
       p.Tags,
       p.AnswerCount,
       p.CommentCount,
       p.FavoriteCount,
       t.*
FROM Posts AS p
JOIN PostTypes as t on p.PostTypeId = t.Id
WHERE p.CreationDate >= '2024-01-01'
and p.CreationDate <= '2024-02-01'
and p.PostTypeId = 2
and p.Body LIKE '%documentation%'

fork query

created nov 12 anonymous