0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT
    p.Id AS PostId,
    p.PostTypeId,
    p.CreationDate,
    p.DeletionDate,
    p.Score AS Votes,
    p.Body AS FullTextContent,
    p.Title,
    p.Tags,
    p.AnswerCount,
    p.CommentCount,
    u.Id AS UserId,
    u.DisplayName AS UserName,
    u.Reputation AS UserReputation,
    u.CreationDate AS UserCreationDate,
    u.Location AS UserLocation,
    ue.Id AS EditorUserId,
    ue.DisplayName AS EditorUserName,
    ue.Reputation AS EditorUserReputation,
    ue.CreationDate AS EditorUserCreationDate,
    ue.Location AS EditorUserLocation
FROM
    Posts p
LEFT JOIN
    Users u ON p.OwnerUserId = u.Id
LEFT JOIN
    PostHistory ph ON p.Id = ph.PostId AND ph.PostHistoryTypeId IN (4, 5)
LEFT JOIN
    Users ue ON ph.UserId = ue.Id
WHERE
    DATEPART(month, p.CreationDate) = 3
    AND DATEPART(year, p.CreationDate) = 2022
ORDER BY
    p.CreationDate
OFFSET 150000 ROWS FETCH NEXT 50000 ROWS ONLY;

fork query

created jun 27 jon.doe44939