MySQL 8.0 - SELECT QUERY
SELECT *
FROM customer c
LEFT JOIN customer_orders co 
    ON c.customer_number = co.customer_number 
   AND co.order_status IN ('preparing', 'prepared')
WHERE c.customer_status='unpaid'
  AND c.order_status = 'unserved'
  AND co.cust_ord_number IS NULL