Page MenuHomePhabricator
Paste P1416

(An Untitled Masterwork)
ActivePublic
Actions

Authored by epriestley on Nov 12 2014, 12:37 PM.
Tags
None
Referenced Files
F232811: file
Nov 12 2014, 12:37 PM
Subscribers
None
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

Event Timeline

epriestley edited the content of this paste. (Show Details)Nov 12 2014, 12:37 PM
epriestley updated the paste's language from autodetect to mysql.
epriestley mentioned this in T6531: MySQL syntax highlight doesn't work for Pastes.
Phabricator · Built by Phacility