初投稿です。初心者のため説明に不十分な点があるかもしれませんが、どうぞお許しください。

------------------------------------------------------------------------------------------
[EC-CUBE] 2.12.2
[レンタルサーバ]ニフティクラウド
[PHP] 5.3.3
[データベース] MySQL 5.1.66
------------------------------------------------------------------------------------------

コンテンツ管理＞CSV出力設定＞高度な設定のSQL設定で

「注文者住所の都道府県」と「配送先住所の都道府県」をそれぞれ出力したいのですが、
両方とも「注文者住所の都道府県」が出力されてしまい、困っています。

SQL設定に詳しい方のアドバイスをお待ちしています。
以下、設定しているSQL文になります。

o.order_id as "オーダー番号",
o.order_email as "メールアドレス",
o.create_date as "受注日",
concat(order_name01,order_name02) as "注文者名",
concat(o.order_tel01 , '-' , o.order_tel02 , '-' , o.order_tel03) as "注文者電話番号",
concat(o.order_zip01 , '-' , o.order_zip02) as "注文者郵便番号",
concat(p.name,order_addr01 ,order_addr02) as "注文者住所",
concat(product_name) as "商品名",
concat(classcategory_name1) as "規格1",
concat(classcategory_name2) as "規格2",
product_code as "商品コード",
price as "価格",
quantity as "数量",
payment_total as "請求金額",
total as "合計金額",
tax as "消費税",
deliv_fee as "送料",
charge as "手数料",
use_point as "利用ポイント",
payment_method as "決済方法",
concat(shipping_name01, shipping_name02) as "宛名",
concat(shipping_kana01,shipping_kana02) as "宛名フリガナ",
concat(shipping_tel01 , '-' , shipping_tel02 , '-' , shipping_tel03) as "配送先電話番号",
concat(shipping_zip01 , '-' , shipping_zip02) as "配送先郵便番号",
concat(p.name,shipping_addr01,shipping_addr02) as "配送先住所",
shipping_date as "配送日",
shipping_time as "配送時間",
o.note as "メモ欄"
FROM
dtb_order AS o
LEFT JOIN
dtb_order_detail AS d
ON
o.order_id = d.order_id
LEFT JOIN
dtb_shipping AS s
ON
o.order_id = s.order_id
LEFT JOIN
mtb_pref AS p
ON
p.id = o.order_pref
LEFT JOIN
dtb_customer AS c
ON
o.customer_id = c.customer_id
WHERE
o.del_flg = 0
AND
o.status = 1

以上