SELECT ALL USERS WITH NO BILLING FIRST NAME IN WOOCOMMERCE

select-woo-users-no-billing-name.sql

-- SELECT ALL USERS WITH NO BILLING FIRST NAME IN WOOCOMMERCE

SELECT *
  FROM wp_users AS wpu
 INNER JOIN wp_usermeta wpum
    ON wpum.user_id = wpu.ID
 WHERE wpu.ID IN (

    SELECT wp_users.ID
      FROM wp_users
        WHERE NOT EXISTS (
          SELECT 1
            FROM  wp_usermeta
          WHERE meta_key = 'billing_first_name' 
          AND user_id = wp_users.ID
        )
        AND wp_users.user_registered > '2021-01-01'
        AND wp_users.ID NOT IN ('1079', '271')
  )
 GROUP BY wpu.ID