function init()
    {
        parent::init();

        $masterData = new SC_DB_MasterData_Ex();
        $this->arrPRODUCTTYPE = $masterData->getMasterData('mtb_product_type');
    }
    public function findProducts($where, $arrValues, $limit, $offset, $order, &$objProduct)
    {
        $objQuery =& SC_Query_Ex::getSingletonInstance();
        // 読み込む列とテーブルの指定
        $col = 'product_id
        ,(SELECT product_class_id FROM dtb_products_class WHERE product_id = alldtl.product_id LIMIT 1) as product_class_id
        , name, main_list_image, status, product_code_min, product_code_max, price02_min, price02_max, stock_min, stock_max, stock_unlimited_min, stock_unlimited_max, update_date';
        $from = $objProduct->alldtlSQL();
        $objQuery->setLimitOffset($limit, $offset);
        $objQuery->setOrder($order);
        return $objQuery->select($col, $from, $where, $arrValues);
    }

,(SELECT product_class_id FROM dtb_products_class WHERE product_id = alldtl.product_id LIMIT 1) as product_class_id

<!--{$arrProducts[cnt].product_class_id}-->

<!--{assign var=key value=$arrProducts[cnt].product_class_id}-->