protected function setSelection(xPDOQuery $c) { $c = parent::setSelection($c); $c->leftJoin('modResource', "Parent"); $c->select(array("Product.id as `product_id`", "Parent.id as category_id", "Parent.uri as category_uri", "Parent.pagetitle as category_title")); return $c; }
protected function setSelection(xPDOQuery $c) { $c = parent::setSelection($c); $alias = $c->getAlias(); $c->innerJoin('modUserProfile', "AuthorProfile", "AuthorProfile.internalKey = Author.id"); $c->select(array("Parent.pagetitle as section_title", "AuthorProfile.photo as author_avatar")); # $c->prepare(); # print $c->toSQL(); # # print '<pre>'; # # # exit; return $c; }