/** * Returns SQL select string with checks if items are available * * @param bool $blForceCoreTable forces core table usage (optional) * * @return string */ public function getSqlActiveSnippet($blForceCoreTable = null) { $sQ = parent::getSqlActiveSnippet($blForceCoreTable); $sTable = $this->getViewName($blForceCoreTable); $sQ .= (strlen($sQ) ? ' and ' : '') . " {$sTable}.oxhidden = '0' "; $sQ .= $this->getAdditionalSqlFilter($blForceCoreTable); return "( {$sQ} ) "; }