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, -- Adding geographical information
    ue.Id AS EditorUserId,
    ue.DisplayName AS EditorUserName,
    ue.Reputation AS EditorUserReputation,
    ue.CreationDate AS EditorUserCreationDate,
    ue.Location AS EditorUserLocation -- Adding geographical information for the editor
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) -- Edits
LEFT JOIN
    Users ue ON ph.UserId = ue.Id
WHERE
    DATEPART(month, p.CreationDate) = 7
    AND DATEPART(year, p.CreationDate) = 2021
ORDER BY
    p.CreationDate;

fork query

created jun 20 jon.doe44939