Skip to content

Instantly share code, notes, and snippets.

@LucaRosaldi
Last active February 24, 2022 10:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save LucaRosaldi/7c355bb5798010ff213e5f1a4a9de060 to your computer and use it in GitHub Desktop.
Save LucaRosaldi/7c355bb5798010ff213e5f1a4a9de060 to your computer and use it in GitHub Desktop.
WordPress, WooCommerce, MySQL: Get list of customers with at least one order placed (for email marketing)
SELECT wp_users.user_email as "Email", firstmeta.meta_value AS "First Name", lastmeta.meta_value AS "Last Name", ordermeta.meta_value AS "Orders Placed" FROM wp_users
LEFT JOIN wp_usermeta as firstmeta on wp_users.ID = firstmeta.user_id and firstmeta.meta_key = 'first_name'
LEFT JOIN wp_usermeta as lastmeta on wp_users.ID = lastmeta.user_id and lastmeta.meta_key = 'last_name'
LEFT JOIN wp_usermeta as ordermeta on wp_users.ID = ordermeta.user_id and ordermeta.meta_key = '_order_count'
WHERE wp_users.ID IN (
SELECT user_id FROM wp_usermeta WHERE meta_key = '_order_count' AND meta_value > 0
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment