"" as "送り状種別",
"0" as "クール区分",
dtb_order.order_id as "伝票番号",
REPLACE(REPLACE(REPLACE(shipping_time,"時",""),"〜",""),"午前中","0812") as "配達時間帯",
"" as "お届け先コード",
concat(shipping_tel01,"-",shipping_tel02,"-",shipping_tel03) as "お届け先電話番号",
"" as "お届け先電話番号枝番",
concat(shipping_zip01,shipping_zip02) as "お届け先郵便番号",
concat(mtb_pref.name,shipping_addr01) as "お届け先住所",
shipping_addr02 as "お届け先住所(アパートマンション名)",
"" as "お届け先会社・部門名1",
"" as "お届け先会社・部門名2",
concat(shipping_name01, shipping_name02) as "お届け先名",
"" as "お届け先名略称カナ",
"様" as "敬称",
"" as "ご依頼主コード",
concat(order_tel01,"-",order_tel02,"-",order_tel03) as "ご依頼主電話番号",
"" as "ご依頼主電話番号枝番",
concat(order_zip01,order_zip02) as "ご依頼主郵便番号",
concat(mtb_pref.name,order_addr01) as "ご依頼主住所1",
order_addr02 as "ご依頼主住所(アパートマンション名)",
concat(order_name01, order_name02) as "ご依頼主名",
"" as "ご依頼主略称カナ",
"" as "品名コード1",
"" as "品名1",
"" as "品名コード2",
"" as "品名2",
"" as "荷扱い1",
"" as "荷扱い2",
"" as "記事",
total as "コレクト代金引換額(税込)",
"0" as "コレクト内消費税額等",
"" as "営業所止置き",
"" as "営業所コード",
"" as "発行枚数",
"" as "個数口表示フラグ",
"" as "請求先顧客コード",
"" as "請求先分類コード",
"" as "運賃管理番号",
"" as "注文時カード払いデータ登録",
"" as "注文時カード払い加盟店番号",
"" as "注文時カード払い申込受付番号1",
"" as "注文時カード払い申込受付番号2",
"" as "注文時カード払い申込受付番号3",
"" as "お届け予定eメール利用区分",
"" as "お届け予定eメールe-mailアドレス",
"" as "お届け予定eメールメッセージ",
"" as "お届け完了eメール利用区分",
"" as "お届け完了eメールe-mailアドレス",
"" as "お届け完了eメールメッセージ",
"" as "クロネコ収納代行利用区分",
"" as "入力機種"



FROM
mtb_pref , dtb_order JOIN dtb_shipping JOIN dtb_order_detail
ON
dtb_order.order_id=dtb_shipping.order_id=dtb_order_detail.order_id
WHERE
dtb_order.order_pref=mtb_pref.id AND dtb_order.status = 5

ALTER TABLE `dtb_order` ADD INDEX ( `status` )