source/Application/Model/ArticleList.php
protected function _getArticleSelect($sRecommId, $sArticlesFilter = null)
    {
        $sRecommId = \OxidEsales\Eshop\Core\DatabaseProvider::getDb()->quote($sRecommId);

        $sArtView = getViewName('oxarticles');
        $sSelect = "select distinct $sArtView.*, oxobject2list.oxdesc from oxobject2list ";
        $sSelect .= "left join $sArtView on oxobject2list.oxobjectid = $sArtView.oxid ";
        $sSelect .= "where (oxobject2list.oxlistid = $sRecommId) " . $sArticlesFilter;

        return $sSelect;
    }
protected function _getArticleSelect($sRecommId, $sArticlesFilter = null)
    {
        $sRecommId = \OxidEsales\Eshop\Core\DatabaseProvider::getDb()->quote($sRecommId);

        $sArtView = getViewName('oxarticles');
        $sSelect = "select distinct $sArtView.*, oxobject2list.oxdesc from oxobject2list ";
        $sSelect .= "left join $sArtView on oxobject2list.oxobjectid = $sArtView.oxid ";
        $sSelect .= "where (oxobject2list.oxlistid = $sRecommId) " . $sArticlesFilter;

        return $sSelect;
    }
protected function _getArticleSelect ( $ sRecommId , $ sArticlesFilter = null ) { $ sRecommId = \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: getDb ( ) -> quote ( $ sRecommId ) ; $ sArtView = getViewName ( 'oxarticles' ) ; $ sSelect = "select distinct $sArtView.*, oxobject2list.oxdesc from oxobject2list " ; $ sSelect .= "left join $sArtView on oxobject2list.oxobjectid = $sArtView.oxid " ; $ sSelect .= "where (oxobject2list.oxlistid = $sRecommId) " . $ sArticlesFilter ; return $ sSelect ; }
Returns the appropriate SQL select

@deprecated since v5.3 (2016-06-17); Listmania will be moved to an own module.

@param string $sRecommId       Recommlist ID
@param string $sArticlesFilter Additional filter for recommlist's items

@return string
Returns the appropriate SQL select