source/Application/Controller/Admin/PriceAlarmList.php
protected function _buildSelectString($oListObject = null)
    {
        $sViewName = getViewName("oxarticles", (int) \OxidEsales\Eshop\Core\Registry::getConfig()->getConfigParam("sDefaultLang"));
        $sSql = "select oxpricealarm.*, {$sViewName}.oxtitle AS articletitle, ";
        $sSql .= "oxuser.oxlname as userlname, oxuser.oxfname as userfname ";
        $sSql .= "from oxpricealarm left join {$sViewName} on {$sViewName}.oxid = oxpricealarm.oxartid ";
        $sSql .= "left join oxuser on oxuser.oxid = oxpricealarm.oxuserid WHERE 1 ";

        return $sSql;
    }
protected function _buildSelectString($oListObject = null)
    {
        $sViewName = getViewName("oxarticles", (int) \OxidEsales\Eshop\Core\Registry::getConfig()->getConfigParam("sDefaultLang"));
        $sSql = "select oxpricealarm.*, {$sViewName}.oxtitle AS articletitle, ";
        $sSql .= "oxuser.oxlname as userlname, oxuser.oxfname as userfname ";
        $sSql .= "from oxpricealarm left join {$sViewName} on {$sViewName}.oxid = oxpricealarm.oxartid ";
        $sSql .= "left join oxuser on oxuser.oxid = oxpricealarm.oxuserid WHERE 1 ";

        return $sSql;
    }
protected function _buildSelectString ( $ oListObject = null ) { $ sViewName = getViewName ( "oxarticles" , ( int ) \ OxidEsales \ Eshop \ Core \ Registry :: getConfig ( ) -> getConfigParam ( "sDefaultLang" ) ) ; $ sSql = "select oxpricealarm.*, {$sViewName}.oxtitle AS articletitle, " ; $ sSql .= "oxuser.oxlname as userlname, oxuser.oxfname as userfname " ; $ sSql .= "from oxpricealarm left join {$sViewName} on {$sViewName}.oxid = oxpricealarm.oxartid " ; $ sSql .= "left join oxuser on oxuser.oxid = oxpricealarm.oxuserid WHERE 1 " ; return $ sSql ; }
Modifying SQL query to load additional article and customer data

@param object $oListObject list main object

@return string
Modifying SQL query to load additional article and customer data