micaさんは書きました：

"vw_products_allclass" => '
( SELECT
T1.product_id,
product_code_min,
product_code_max,
price01_min,
price01_max,
price02_min,
price02_max,
stock_min,
stock_max,
stock_unlimited_min,
stock_unlimited_max,
T1.del_flg,
status,
name,
comment1,
comment2,
comment3,
main_list_comment,
main_image,
main_list_image,
product_flag,
deliv_date_id,
sale_limit,
point_rate,
sale_unlimited,
T1.create_date,
deliv_fee,
T1.rank,
T4.category_rank,
T4.category_id
FROM
(
SELECT *
FROM
(
SELECT
product_id,
MIN(product_code) AS product_code_min,
MAX(product_code) AS product_code_max,
MIN(price01) AS price01_min,
MAX(price01) AS price01_max,
MIN(price02) AS price02_min,
MAX(price02) AS price02_max,
MIN(stock) AS stock_min,
MAX(stock) AS stock_max,
MIN(stock_unlimited) AS stock_unlimited_min,
MAX(stock_unlimited) AS stock_unlimited_max
FROM dtb_products_class
GROUP BY product_id
) AS T0
LEFT JOIN dtb_products USING (product_id)
) AS T1
INNER JOIN
(
SELECT
T2.product_id,
MAX(T2.category_id) AS category_id,
MAX(T3.rank) AS category_rank
FROM dtb_product_categories T2
INNER JOIN dtb_category T3 USING (category_id)
GROUP BY product_id
) AS T4
USING (product_id)
)',

dtb_products.maker_id,

dtb_products.note,

,
T2.rank AS product_rank