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;