Woocommerce Get All Users Completed Orders Total Mysql Query, Product names concatenated by | and exported to csv

get_woocommerce_completed_orders_for_all_users.sql

SELECT u.ID,
  u.display_name as fullname,
  GROUP_CONCAT(oi.order_item_name SEPARATOR ' | ') as courses,
  SUM(pm2.meta_value) as order_total
FROM wp_users as u
  INNER JOIN wp_posts as p on p.post_status = 'wc-completed'
  INNER JOIN wp_postmeta as pm on pm.post_id = p.ID
    and pm.meta_key = '_customer_user'
    and u.ID = pm.meta_value
  INNER JOIN wp_postmeta as pm2 on pm2.post_id = p.ID
    and pm2.meta_key = '_order_total'
  INNER JOIN wp_woocommerce_order_items as oi on oi.order_id = p.ID
    and oi.order_item_name NOT LIKE '%specific product name to exclude%'
GROUP by u.ID, u.display_name 
INTO OUTFILE '/var/lib/mysql-files/myorders.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';