src/ShopArticleReviewBundle/objects/db/TPkgShopArticleReviewShopArticleReviewList.class.php
public static function GetReviewsForArticleSortedByRate($iShopArticleId)
    {
        $sQuery = "SELECT * FROM `shop_article_review`
                       WHERE `shop_article_review`.`shop_article_id` = '".MySqlLegacySupport::getInstance()->real_escape_string($iShopArticleId)."'
                         AND `shop_article_review`.`publish` = '1'
                    ORDER BY `shop_article_review`.`helpful_count` DESC , `shop_article_review`.`datecreated` DESC";
        $oList = &TdbShopArticleReviewList::GetList($sQuery);

        return $oList;
    }
public static function GetReviewsForArticleSortedByRate($iShopArticleId)
    {
        $sQuery = "SELECT * FROM `shop_article_review`
                       WHERE `shop_article_review`.`shop_article_id` = '".MySqlLegacySupport::getInstance()->real_escape_string($iShopArticleId)."'
                         AND `shop_article_review`.`publish` = '1'
                    ORDER BY `shop_article_review`.`helpful_count` DESC , `shop_article_review`.`datecreated` DESC";
        $oList = &TdbShopArticleReviewList::GetList($sQuery);

        return $oList;
    }
public static function GetReviewsForArticleSortedByRate ( $ iShopArticleId ) { $ sQuery = "SELECT * FROM `shop_article_review`
                       WHERE `shop_article_review`.`shop_article_id` = '" . MySqlLegacySupport :: getInstance ( ) -> real_escape_string ( $ iShopArticleId ) . "'
                         AND `shop_article_review`.`publish` = '1'
                    ORDER BY `shop_article_review`.`helpful_count` DESC , `shop_article_review`.`datecreated` DESC" ; $ oList = & TdbShopArticleReviewList :: GetList ( $ sQuery ) ; return $ oList ; }
Get reviews for aarticel sorted by positive rate.

@param  $iShopArticleId

@return TdbShopArticleReviewList
Get reviews for aarticel sorted by positive rate .