select id as id,
       warehouse_id as warehouse_id,
       customer_id as customer_id,
       shipment_customer_id as shipment_customer_id,
       NULL as delivery_id,
       trucking_id as trucking_id,
       receiver_name as receiver_name,
       CASE time_req_code WHEN 830 THEN '8時30分' WHEN 900 THEN '9時' WHEN 1000 THEN '10時' WHEN 1200 THEN '12時' ELSE NULL END as request_time,
       NULL as note,
       1 as accept_order_trigger_code,
       0 as invalid_flag_code,
       NULL as deleted_at,
       created_at as created_at,
       updated_at as updated_at
FROM warehouses_customers
INTO OUTFILE "/tmp/warehouses_customers.csv" FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\';
