update dtb_products a set a.category_id = (select max(b.category_id) from dtb_product_categories b where a.product_id = b.product_id ) ;

//処理にかかわらずfromはこの形
$col = "T1.product_id,"
. "(select min(product_code) from dtb_products_class where product_id = T1.product_id ) AS product_code_min,"
. "(select max(product_code) from dtb_products_class where product_id = T1.product_id ) AS product_code_max,"
. "(select min(price01) from dtb_products_class where product_id = T1.product_id ) AS price01_min,"
. "(select max(price01) from dtb_products_class where product_id = T1.product_id ) AS price01_max,"
. "(select min(price02) from dtb_products_class where product_id = T1.product_id ) AS price02_min,"
. "(select max(price02) from dtb_products_class where product_id = T1.product_id ) AS price02_max,"
. "(select min(stock) from dtb_products_class where product_id = T1.product_id ) AS stock_min,"
. "(select max(stock) from dtb_products_class where product_id = T1.product_id ) AS stock_max,"
. "(select min(stock_unlimited) from dtb_products_class where product_id = T1.product_id ) AS stock_unlimited_min,"
. "(select max(stock_unlimited) from dtb_products_class where product_id = T1.product_id ) AS stock_unlimited_max,"
. "T1.del_flg,"
. "T1.status,"
. "T1.name,"
. "T1.comment1,"
. "T1.comment2,"
. "T1.comment3,"
. "T1.main_list_comment,"
. "T1.main_image,"
. "T1.main_list_image,"
. "T1.product_flag,"
. "T1.deliv_date_id,"
. "T1.sale_limit,"
. "T1.point_rate,"
. "T1.sale_unlimited,"
. "T1.create_date,"
. "T1.deliv_fee,"
. "T1.rank,"
. "T1.category_id as category_id" ;
$from = "dtb_products AS T1";

//表示順序
switch($orderby) {

//価格順
case 'price':
$order = "price02_min, product_id";
break;

//新着順
case 'date':
$order = "create_date DESC, product_id";
break;

default:
$order = "create_date DESC, product_id";
break;

// 規格名一覧
// $arrClassName = $objDb->sfGetIDValueList("dtb_class", "class_id", "name");
// 規格分類名一覧
// $arrClassCatName = $objDb->sfGetIDValueList("dtb_classcategory", "classcategory_id", "name");
// 規格セレクトボックス設定
// if($disp_num == 15) {
// for($i = 0; $i < count($this->arrProducts); $i++) {
// $this->lfMakeSelect($this->arrProducts[$i]['product_id'], $arrClassName, $arrClassCatName);
// // 購入制限数を取得
// $this->lfGetSaleLimit($this->arrProducts[$i]);
// }
// }