SELECT
        id,
        hospital_id as warehouse_id,
        dealer_id as customer_id,
        delivery_id as shipment_customer_id,
        NULL as delivery_id,
        trucking_id,
        receiver_name,
        request_time,
        hp_dl_relation_note as note,
        1 as accept_order_trigger_code,
        0 as invalid_flag_code,
        NULL as deleted_at,
        NOW() as created_at,
        NOW() as updated_at
FROM hp_dl_relations
INTO OUTFILE "/tmp/warehouses_customers.csv" FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"';
