受注IDと詳細をCSV出力できるSQL

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

受注IDと詳細をCSV出力できるSQL

O.order_id, O.customer_id, O.order_sex, O.order_birth, O.order_job,
O.subtotal, O.discount, O.deliv_fee, O.charge, O.tax, O.total,
O.payment_total, O.status, O.create_date, O.del_flg,
D.product_id, D.classcategory_id1, D.classcategory_id2,
D.product_name, D.product_code, D.classcategory_name1,
D.classcategory_name2, D.price, D.quantity
FROM dtb_order_detail D
LEFT OUTER JOIN dtb_order O
ON O.order_id = D.order_id
ORDER BY D.order_id ASC, D.product_id ASC