public function setSelection(xPDOQuery $c)
{
$c = parent::setSelection($c);
$key = $this->getProperty('subscribe_key');
$c->select(array("{$key}.subscriberid as subscriber_id", "{$key}.rank as rank"));
return $c;
}
public function setSelection(xPDOQuery $c)
{
$c = parent::setSelection($c);
/* Готовим подзапрос на выборку последних комментов */
$sc = $this->prepareSubCriteria();
$c->select(array("Resource.id as resource_id", "Resource.content as last_publication"));
$c->leftJoin('modResource', 'Resource', "\n Resource.createdby = {$this->classKey}.id \n AND Resource.published = 1 \n AND Resource.deleted = 0 \n AND Resource.id IN (" . implode(',', $sc) . ")\n ");
$c->prepare();
//print $c->tosql();
return $c;
}
