public function prepareQueryBeforeCount(xPDOQuery $c)
{
$c = parent::prepareQueryBeforeCount($c);
$c->innerJoin('ShopProduct', 'Product');
$c->leftJoin('modTemplateVarResource', 'colortv', "colortv.tmplvarid=2 AND colortv.contentid={$this->classKey}.id");
$c->leftJoin('modTemplateVarResource', 'designtv', "designtv.tmplvarid=3 AND designtv.contentid={$this->classKey}.id");
$c->leftJoin('modTemplateVarResource', 'imagetv', "imagetv.tmplvarid=8 AND imagetv.contentid={$this->classKey}.id");
$c->select(array("{$this->classKey}.parent", "{$this->classKey}.pagetitle", 'colortv.value as color', 'designtv.value as design', 'imagetv.value as image', "{$this->classKey}.id"));
$c->where(array("{$this->classKey}.parent" => (int) $this->getProperty('model_id')));
$c->groupby('color');
$c->groupby('design');
$c->groupby('image');
/*$c->prepare();
print $c->toSQL();
exit;*/
return $c;
}
public function prepareQueryBeforeCount(xPDOQuery $c)
{
$c->innerJoin('ShopmodxProduct', 'Product');
return parent::prepareQueryBeforeCount($c);
}
