"vw_products_allclass" => '
(SELECT
,pr.product_id
,pl.product_code_min
,pl.product_code_max
,pl.price01_min
,pl.price01_max
,pl.price02_min
,pl.price02_max
,pl.stock_min
,pl.stock_max
,pl.stock_unlimited_min
,pl.stock_unlimited_max
,pr.del_flg
,pr.status
,pr.name
,pr.comment1,
,pr.comment2,
,pr.comment3,
,pr.comment4,
,pr.comment5,
,pr.comment6,
,pr.comment7,
,pr.comment8,
,pr.comment9,
,pr.comment10,
,pr.comment11,
,pr.comment12,
,pr.comment13,
,pr.comment14,
,pr.comment15,
,pr.comment16,
,pr.comment17,
,pr.comment18,
,pr.comment19,
,pr.comment20,
,pr.comment21,
,pr.comment22,
,pr.comment23,
,pr.comment24,
,pr.comment25,
,pr.update_date,
,pr.main_list_comment
,pr.main_image
,pr.main_list_image
,pr.product_flag
,pr.deliv_date_id
,pr.sale_limit
,pr.point_rate
,pr.sale_unlimited
,pr.create_date
,pr.deliv_fee
,pc.rank
,cc.rank AS category_rank
,cc.category_id
FROM
(((SELECT
product_id as product_id_sub
,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 pl
LEFT JOIN dtb_products AS pr ON pl.product_id_sub = pr.product_id) LEFT JOIN dtb_product_categories AS pc ON pr.product_id = pc.product_id) LEFT JOIN dtb_category AS cc ON pc.category_id = cc.category_id) ',