規格をCSV出力できるSQL

管理画面＞コンテンツ管理＞CSV出力設定＞高度な設定

dtb_classcategoryとdtb_products_classから規格を出力

D.classcategory_id ,
D.name,
O.product_class_id,
O.product_id,
O.classcategory_id1,
O.classcategory_id2,
O.product_code,
O.stock,
O.stock_unlimited,
O.price01,
O.price02,
O.cancel_price01

FROM dtb_classcategory D
LEFT OUTER JOIN dtb_products_class O
ON (O.classcategory_id1 = D.classcategory_id) OR (O.classcategory_id2 = D.classcategory_id)

WHERE O.product_code = 'A-1TEST'

ORDER BY D.classcategory_id ASC