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