SELECT rc.id, CONCAT('http://phabricator.domain.com/r', r.callsign, rc.commitIdentifier) AS CommitUrl, COUNT(*) AS CommentCount, GROUP_CONCAT(tc.authorPHID SEPARATOR ', ')
FROM phabricator_audit.`audit_transaction_comment` tc
JOIN phabricator_repository.repository_commit rc ON rc.phid = tc.commitPHID
JOIN phabricator_repository.repository r ON r.id = rc.repositoryID
WHERE tc.`transactionPHID` IS NULL
GROUP BY rc.commitIdentifier