source/Application/Model/RecommendationList.php
protected function _getSearchSelect($sSearchStr)
    {
        $iShopId = \OxidEsales\Eshop\Core\Registry::getConfig()->getShopId();
        $sSearchStrQuoted = \OxidEsales\Eshop\Core\DatabaseProvider::getDb()->quote("%$sSearchStr%");

        $sSelect = "select distinct rl.* from oxrecommlists as rl";
        $sSelect .= " inner join oxobject2list as o2l on o2l.oxlistid = rl.oxid";
        $sSelect .= " where ( rl.oxtitle like $sSearchStrQuoted or rl.oxdesc like $sSearchStrQuoted";
        $sSelect .= " or o2l.oxdesc like $sSearchStrQuoted ) and rl.oxshopid = '$iShopId'";

        return $sSelect;
    }
protected function _getSearchSelect($sSearchStr)
    {
        $iShopId = \OxidEsales\Eshop\Core\Registry::getConfig()->getShopId();
        $sSearchStrQuoted = \OxidEsales\Eshop\Core\DatabaseProvider::getDb()->quote("%$sSearchStr%");

        $sSelect = "select distinct rl.* from oxrecommlists as rl";
        $sSelect .= " inner join oxobject2list as o2l on o2l.oxlistid = rl.oxid";
        $sSelect .= " where ( rl.oxtitle like $sSearchStrQuoted or rl.oxdesc like $sSearchStrQuoted";
        $sSelect .= " or o2l.oxdesc like $sSearchStrQuoted ) and rl.oxshopid = '$iShopId'";

        return $sSelect;
    }
protected function _getSearchSelect ( $ sSearchStr ) { $ iShopId = \ OxidEsales \ Eshop \ Core \ Registry :: getConfig ( ) -> getShopId ( ) ; $ sSearchStrQuoted = \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: getDb ( ) -> quote ( "%$sSearchStr%" ) ; $ sSelect = "select distinct rl.* from oxrecommlists as rl" ; $ sSelect .= " inner join oxobject2list as o2l on o2l.oxlistid = rl.oxid" ; $ sSelect .= " where ( rl.oxtitle like $sSearchStrQuoted or rl.oxdesc like $sSearchStrQuoted" ; $ sSelect .= " or o2l.oxdesc like $sSearchStrQuoted ) and rl.oxshopid = '$iShopId'" ; return $ sSelect ; }
Returns the appropriate SQL select according to search parameters

@param string $sSearchStr Search string

@return string
Returns the appropriate SQL select according to search parameters