protected function setSelection(xPDOQuery $c) { $c->leftJoin('modResource', 'Parent'); $c->leftJoin('modResource', "Currency", "Currency.id = Product.sm_currency"); $c->select(array("Product.*", 'Parent.parent as uplevel_id', 'Parent.pagetitle as parent_title', 'Currency.pagetitle as currency_title')); return parent::setSelection($c); }