comment_snippet.sql
ActivePublic
Actions

Authored by epriestley on Oct 28 2015, 1:57 PM.

Tags

None

Referenced Files

	F916881: comment_snippet.sql
	Oct 28 2015, 1:57 PM

Subscribers

None

	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;

epriestley changed the title of this paste from untitled to comment_snippet.sql.

epriestley updated the paste's language from autodetect to autodetect.

comment_snippet.sqlActivePublicActions