protected function buildJoinClauseParts(AphrontDatabaseConnection $conn)
{
$joins = parent::buildJoinClauseParts($conn);
$join_publisher = $this->fullKeys !== null;
$join_package = $this->fullKeys !== null || $join_publisher;
if ($join_package) {
$package_table = new PhabricatorPackagesPackage();
$joins[] = qsprintf($conn, 'JOIN %T p ON v.packagePHID = p.phid', $package_table->getTableName());
}
if ($join_publisher) {
$publisher_table = new PhabricatorPackagesPublisher();
$joins[] = qsprintf($conn, 'JOIN %T u ON u.phid = p.publisherPHID', $publisher_table->getTableName());
}
return $joins;
}
