public function lfGetOrderHistory($customer_id, $startno = -1)
    {
        $objQuery   = SC_Query_Ex::getSingletonInstance();

        $col        = 'order_id, create_date, payment_id, payment_total, status';
        $from       = 'dtb_order';
        $where      = 'del_flg = 0 AND customer_id = ?';
        $arrWhereVal = array($customer_id);
        $order      = 'order_id DESC';

        if ($startno == -1) {
            return $objQuery->count($from, $where, $arrWhereVal);
        }

        $objQuery->setLimitOffset(SEARCH_PMAX, $startno);
        // 表示順序
        $objQuery->setOrder($order);

        //購入履歴の取得
        $query = ' 
		SELECT 
		    order_id, 
		    create_date, 
		    payment_id,
			payment_total, 
		status, 
		( 
		    SELECT
    			GROUP_CONCAT(product_name separator "\n" ) 
			FROM 
                dtb_order_detail 
			WHERE 
			    order_id = dtb_order.order_id 
		) as product_name 
		FROM 
    		dtb_order 
		WHERE 
    		del_flg = 0 AND 
			customer_id = ? 
		ORDER BY 
	    	order_id DESC'; 
return $objQuery->getAll($query,array($customer_id,SEARCH_PMAX, $startno));
    }