0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Drupal developers and administrators

SELECT
    p.Id AS PostId,
    p.CreationDate AS PostCreationDate,
    lh.CreationDate AS LockDate
FROM
    Posts p
JOIN
    PostHistory lh ON p.Id = lh.PostId
WHERE
    lh.PostHistoryTypeId = 14 -- 14 is the PostHistoryTypeId for "Lock"
ORDER BY
    lh.CreationDate DESC

fork query

edited aug 9

created aug 9 anonymous