"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)
)',