0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Ubuntu users and developers

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,
    ue.Id AS EditorUserId,
    ue.DisplayName AS EditorUserName,
    ue.Reputation AS EditorUserReputation,
    ue.CreationDate AS EditorUserCreationDate
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) = 6
    AND DATEPART(year, p.CreationDate) = 2024
ORDER BY
    p.CreationDate;

fork query

created jun 20 jon.doe44939