select oi.order_id,
oi.store_id,
oi.customer_id,
oi.order_status,
od.data_value as shipping_time (дальше включить все нужные поля)
from order_items oi
left join orders_data od on od.order_id = oi.order_id
left join stores st on st.id = oi.store_id
left join customers cu on cu.id = oi.customer_id
where oi.order_status = 'on-hold'
or oi.order_status = 'processing'
and od.data_key = '_shipping_time'