//おすすめ商品検索
    //※カテゴリー内ランダム表示バージョン
    function lfGetRanking(){
        $objQuery = new SC_Query();
/*
	■元ソース
        $col = "DISTINCT A.*, name, price02_min, price01_min, main_list_image ";
        $from = "dtb_best_products AS A INNER JOIN vw_products_allclass AS allcls using(product_id)";
        $where = "status = 1";
        $order = "rank";
        $objQuery->setorder($order);

	■全商品の中からSELECTする
	select 
	a.product_id, a.name, a.main_image, main_list_image, b.price02, c.product_id, c.category_id
	from
	dtb_products a, dtb_products_class b, dtb_product_categories c
	where 
	a.product_id = b.product_id ;


	■全商品の中から対象カテゴリーのみSELECTする
	select 
	a.product_id, a.name, a.main_image, main_list_image, b.price02, c.product_id, c.category_id
	from
	dtb_products a, dtb_products_class b, dtb_product_categories c
	where 
	a.product_id = b.product_id and b.product_id = c.product_id and a.del_flg = 0 and c.category_id=74;

*/
	$col = "a.product_id, a.name, a.main_image, main_list_image, price02 as price02_min, c.product_id, c.category_id ";
	$from = "dtb_products a, dtb_products_class b, dtb_product_categories c ";
	$where = "a.product_id = b.product_id and b.product_id = c.product_id and a.del_flg = 0 and c.category_id=74 "; //複数カテゴリーの場合はc.category_id=を増やす
	$order = "random()";
	$limit = "24"; //抽出する数
	
	$objQuery->setorder($order);
	$objQuery->setlimit($limit);

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

        return $arrBestProducts;
    }