EC-CUBE 2.13.3管理画面内、「コンテンツ管理」⇒「CSV出力設定」⇒「高度な設定」にて
下記のSQL文を出力すると、複数届け先オーダーをしているものに対して、

本来なら、

オーダー１の商品　配送先１
オーダー２の商品　配送先２
オーダー３の商品　配送先３
　　　　　　　　　　・
　　　　　　　　　　・

と出力されるのが正解の部分が、

オーダー１の商品　配送先１
オーダー１の商品　配送先２
オーダー１の商品　配送先３
オーダー２の商品　配送先１
オーダー２の商品　配送先２
オーダー２の商品　配送先３
　　　　　　　　　　　　・
　　　　　　　　　　　　・
　　　　　　　　　　　　・

のように商品毎に全ての配送先が出力されてしまいます。
構文を調整してますが、どなたか修正箇所をご教授頂けないでしょうか？

--- SQL文 ------------------------

o.order_id as "オーダー番号",
o.create_date as "受注日",
o.order_company_name as "会社名",
concat(order_name01 , ' ' , order_name02) as "注文者名",
concat(order_kana01 , ' ' , order_kana02) as "注文者名カナ",
o.order_email as "メールアドレス",
concat(o.order_tel01 , '-' , o.order_tel02 , '-' , o.order_tel03) as "注文者電話番号",
concat(o.order_zip01 , '-' , o.order_zip02) as "注文者郵便番号",
concat(p1.name,order_addr01 ,order_addr02) as "注文者住所",
concat(product_name) as "商品名",
product_code as "商品コード",
price as "価格",
classcategory_name1 as "規格1",
classcategory_name2 as "規格2",
quantity as "購入総数",
payment_total as "請求金額",
total as "合計金額",
tax as "消費税",
deliv_fee as "送料",
payment_method as "決済方法",
shipping_company_name 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(p2.name,shipping_addr01,shipping_addr02) as "配送先住所",
shipping_date as "配送日",
shipping_time as "配送時間",
o.message_card as "メッセージカード",
o.message 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 p1 ON p1.id = o.order_pref
LEFT JOIN mtb_pref AS p2 ON p2.id = s.shipping_pref
LEFT JOIN dtb_customer AS c ON o.customer_id = c.customer_id
WHERE o.del_flg = 0 AND o.status = 1