source/Application/Model/ArticleList.php
protected function _getVendorSelect($sVendorId)
    {
        $sArticleTable = getViewName('oxarticles');
        $oBaseObject = $this->getBaseObject();
        $sFieldNames = $oBaseObject->getSelectFields();
        $sSelect = "select $sFieldNames from $sArticleTable ";
        $sSelect .= "where $sArticleTable.oxvendorid = " . \OxidEsales\Eshop\Core\DatabaseProvider::getDb()->quote($sVendorId) . " ";
        $sSelect .= " and " . $oBaseObject->getSqlActiveSnippet() . " and $sArticleTable.oxparentid = ''  ";

        if ($this->_sCustomSorting) {
            $sSelect .= " ORDER BY {$this->_sCustomSorting} ";
        }

        return $sSelect;
    }
protected function _getVendorSelect($sVendorId)
    {
        $sArticleTable = getViewName('oxarticles');
        $oBaseObject = $this->getBaseObject();
        $sFieldNames = $oBaseObject->getSelectFields();
        $sSelect = "select $sFieldNames from $sArticleTable ";
        $sSelect .= "where $sArticleTable.oxvendorid = " . \OxidEsales\Eshop\Core\DatabaseProvider::getDb()->quote($sVendorId) . " ";
        $sSelect .= " and " . $oBaseObject->getSqlActiveSnippet() . " and $sArticleTable.oxparentid = ''  ";

        if ($this->_sCustomSorting) {
            $sSelect .= " ORDER BY {$this->_sCustomSorting} ";
        }

        return $sSelect;
    }
protected function _getVendorSelect ( $ sVendorId ) { $ sArticleTable = getViewName ( 'oxarticles' ) ; $ oBaseObject = $ this -> getBaseObject ( ) ; $ sFieldNames = $ oBaseObject -> getSelectFields ( ) ; $ sSelect = "select $sFieldNames from $sArticleTable " ; $ sSelect .= "where $sArticleTable.oxvendorid = " . \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: getDb ( ) -> quote ( $ sVendorId ) . " " ; $ sSelect .= " and " . $ oBaseObject -> getSqlActiveSnippet ( ) . " and $sArticleTable.oxparentid = ''  " ; if ( $ this -> _sCustomSorting ) { $ sSelect .= " ORDER BY {$this->_sCustomSorting} " ; } return $ sSelect ; }
Builds vendor select SQL statement

@param string $sVendorId Vendor ID

@return string
Builds vendor select SQL statement