Authored By

	epriestley
	Nov 12 2014, 12:37 PM

Size

432 B

Referenced Files

None

Subscribers

None

file
View Options

	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

File Metadata