source/Application/Model/ArticleList.php
protected function _getPriceSelect($dPriceFrom, $dPriceTo)
    {
        $oBaseObject = $this->getBaseObject();
        $sArticleTable = $oBaseObject->getViewName();
        $sSelectFields = $oBaseObject->getSelectFields();

        $sSelect = "select {$sSelectFields} from {$sArticleTable} where oxvarminprice >= 0 ";
        $sSelect .= $dPriceTo ? "and oxvarminprice <= " . (double) $dPriceTo . " " : " ";
        $sSelect .= $dPriceFrom ? "and oxvarminprice  >= " . (double) $dPriceFrom . " " : " ";

        $sSelect .= " and " . $oBaseObject->getSqlActiveSnippet() . " and {$sArticleTable}.oxissearch = 1";

        if (!$this->_sCustomSorting) {
            $sSelect .= " order by {$sArticleTable}.oxvarminprice asc , {$sArticleTable}.oxid";
        } else {
            $sSelect .= " order by {$this->_sCustomSorting}, {$sArticleTable}.oxid ";
        }

        return $sSelect;
    }
protected function _getPriceSelect($dPriceFrom, $dPriceTo)
    {
        $oBaseObject = $this->getBaseObject();
        $sArticleTable = $oBaseObject->getViewName();
        $sSelectFields = $oBaseObject->getSelectFields();

        $sSelect = "select {$sSelectFields} from {$sArticleTable} where oxvarminprice >= 0 ";
        $sSelect .= $dPriceTo ? "and oxvarminprice <= " . (double) $dPriceTo . " " : " ";
        $sSelect .= $dPriceFrom ? "and oxvarminprice  >= " . (double) $dPriceFrom . " " : " ";

        $sSelect .= " and " . $oBaseObject->getSqlActiveSnippet() . " and {$sArticleTable}.oxissearch = 1";

        if (!$this->_sCustomSorting) {
            $sSelect .= " order by {$sArticleTable}.oxvarminprice asc , {$sArticleTable}.oxid";
        } else {
            $sSelect .= " order by {$this->_sCustomSorting}, {$sArticleTable}.oxid ";
        }

        return $sSelect;
    }
protected function _getPriceSelect ( $ dPriceFrom , $ dPriceTo ) { $ oBaseObject = $ this -> getBaseObject ( ) ; $ sArticleTable = $ oBaseObject -> getViewName ( ) ; $ sSelectFields = $ oBaseObject -> getSelectFields ( ) ; $ sSelect = "select {$sSelectFields} from {$sArticleTable} where oxvarminprice >= 0 " ; $ sSelect .= $ dPriceTo ? "and oxvarminprice <= " . ( double ) $ dPriceTo . " " : " " ; $ sSelect .= $ dPriceFrom ? "and oxvarminprice  >= " . ( double ) $ dPriceFrom . " " : " " ; $ sSelect .= " and " . $ oBaseObject -> getSqlActiveSnippet ( ) . " and {$sArticleTable}.oxissearch = 1" ; if ( ! $ this -> _sCustomSorting ) { $ sSelect .= " order by {$sArticleTable}.oxvarminprice asc , {$sArticleTable}.oxid" ; } else { $ sSelect .= " order by {$this->_sCustomSorting}, {$sArticleTable}.oxid " ; } return $ sSelect ; }
Builds SQL for selecting articles by price

@param double $dPriceFrom Starting price
@param double $dPriceTo   Max price

@return string
Builds SQL for selecting articles by price