SELECT
u.username author,
FROM_UNIXTIME(x.dateCreated) created,
IF(c.changesetID, CONCAT(h.filename, ':', c.lineNumber), null) locus,
c.content comment
FROM differential_revision r
JOIN differential_transaction x ON x.objectPHID = r.phid
JOIN differential_transaction_comment c ON x.commentPHID = c.phid
JOIN phabricator_user.user u ON x.authorPHID = u.phid
LEFT JOIN differential_changeset h ON c.changesetID = h.id
WHERE r.id = <ID>
ORDER BY x.id ASC;