function lfGetRanking(){
    $objQuery = new SC_Query();

    $col = "DISTINCT A.*, name, price02_min, price01_min, main_large_image ";
    $from = "dtb_best_products AS A INNER JOIN vw_products_allclass_detail AS allcls using(product_id)";
    $where = "status = 1";
    $order = "rank";
    $objQuery->setorder($order);

    $arrBestProducts = $objQuery->select($col, $from, $where);

    return $arrBestProducts;
}