SELECT usr.personal_details, orders
FROM users_with_orders usr
USE KEYS "Tamekia_13483660"
LEFT NEST orders_with_users orders
ON (KEYS ARRAY s.order_id FOR s IN usr.shipped_order_history END AND orders.deleted=false)
`
SELECT usr.personal_details, ARRAY o FOR o IN orders WHEN o.deleted = false END AS orders
FROM users_with_orders usr USE KEYS "Tamekia_13483660"
LEFT NEST orders_with_users orders ON KEYS (ARRAY s.order_id FOR s IN usr.shipped_order_history END)