Wordpress Export Users

wp-export-users.sql

SELECT
  u.ID AS id,
  u.user_login AS login_name,
  first_name.meta_value AS first_name,
  last_name.meta_value AS last_name,
  LOWER(u.user_email) AS email,
  created_ip.meta_value AS created_ip,
  u.user_registered AS created_at
FROM
  wp_users u
LEFT JOIN wp_usermeta first_name ON (
  first_name.user_id = u.ID
  AND first_name.meta_key = 'first_name'
  AND first_name.meta_value != ''
)
LEFT JOIN wp_usermeta last_name ON (
  last_name.user_id = u.ID
  AND last_name.meta_key = 'last_name'
  AND first_name.meta_value != ''
)
LEFT JOIN wp_usermeta created_ip ON (
  created_ip.user_id = u.ID
  AND created_ip.meta_key = 'registered_user_IP'
  AND first_name.meta_value != ''
)
WHERE
  u.user_activation_key = ''