MySQL query to list users who never signed in

What MySQL query can I use to get a list of users who have never logged in to WP?

None. WordPress does not store this information so this is not something you can do, you would need to add code for it but that would also require going back to 2015 to add the code for it to solve your problem.

WordPress doesn’t hold records of previous/first/last logins, only current active sessions. These active session records are destroyed when a user logs out, and when the login expires. They’re also approximate, not accurate. This also means you can’t use them to figure out when a user was last active, when they last logged in, or if they have ever logged in.

At best, you could add code to log when a user logs in to user meta, then wait a few months and see who has and has not logged in. Then you would have the information needed to do this, and you would do it via WP_User_Query and wp_delete_user.

Right now though, you don’t have the information to do this. Note that doing it via SQL would mean stale caches and other broken-ness, you should do it via WordPress APIs, be that the REST API, CLI, or in PHP.

Related Posts:

  1. Automatically delete inactive users after 2 months
  2. How to display custom user meta from registration in backend?
  3. Allowing an email as the username?
  4. Copy a user from one WordPress site to another
  5. Search multiple meta keys at once
  6. Front end user meta options for users
  7. ACF Upload Image in front-end with custom form
  8. How to customize wp_signon()
  9. Log all users out of all locations after 24 hours
  10. Add user data to table when user is created?
  11. Displaying different in-page content to cliente/admin
  12. Should I encrypt the response that triggers an Ajax action? Is nonce sufficient?
  13. How can I attach a user to another user with user meta
  14. Creating user without username and password
  15. WordPress SQL Issue not returning correct reselts
  16. Assign random (and unique) user meta upon registration
  17. Can I Create a Second Admin Level User Role?
  18. Unique password to access a section site
  19. Can I add a unique code for each user based on the location?
  20. Update user role for expired membership
  21. Safely changing UserID’s, re-using deleted UserID’s and automatically using deleted userID’s instead of an increment
  22. How do I change the user via SQL?
  23. Username has been exposed
  24. Let admin users edit member profiles from front end
  25. view and update form only for registered users
  26. Add custom input field in new user page
  27. Wordpres password as plain text in email
  28. WordPress password as plain text in email
  29. get_user_meta() doesn’t include user email?
  30. Whats the best way to share user data across multiple WordPress websites?
  31. Delete all subscribers from wp_users and wp_usermeta a few thousand at a time
  32. Disallowing Users of a Custom Role from Deleting or Adding Administrators?
  33. What the user_status column?
  34. Hide Admin Menu for Specific User ID who has administrator Role
  35. Problem with Hebrew characters in username
  36. Remove email verification when new user register
  37. Grouping users under parent user
  38. Check if specific username is logged in
  39. How we can get the user id by its display_name
  40. WP_User_Query with combined meta query – not working?
  41. LEFT JOIN, INNER OUTER JOIN, LEFT OUTER JOIN is driving me crazy. Please help?
  42. How to add follow functionality to multi-author wordpress site?
  43. Can I hook into the invite user process to verify their email address is from a certain domain?
  44. wp_insert_user is not working for me?
  45. Upload files programmatically to users
  46. How to add country drop down menu to the user profile?
  47. Can I bulk register contributors for a new blog
  48. New user notification doesn’t include activation link
  49. WordPress to use Drupal users’ credentials
  50. Add custom fields to the user profile
  51. stop login if user_status equal zero
  52. WP User Query fails when searching meta queries and search columns
  53. How can i create an array user meta?
  54. Updating user meta
  55. Creating user in Firebase after WordPress user registration
  56. User management system similar to wordpress one?
  57. Restrict access of admin uploads to certain logged-in users?
  58. wordpress user roles are not working
  59. Can i add password field into my wp registration form?
  60. wordpress disable login for unverified user
  61. Problem with automatic role change through cron job
  62. How to create user specific pages (not user role!)?
  63. Reset Password policy
  64. Register user when after filling contact form
  65. How to add a private user page populated from sql?
  66. Is this code true or not
  67. Check for valid email after user inactivity?
  68. User description only displayed for logged user
  69. The Simple and Correct Way to Add User Meta
  70. create new users in db starting at what ID?
  71. How do you manage your pages or functions that require logged-in users?
  72. Associate multiple email addresses with the same user account, so they can log in with either
  73. What is correct way to change user’s email?
  74. Display the line breaks in user bio without using html
  75. how to set default update_user_meta values wordpress
  76. Get user by meta key – WP multi site
  77. Cannot Update user meta in custom field
  78. How to programmatically read the plan text password when user register?
  79. New User Save Filter
  80. Adding more fields to the add user page on dashboard
  81. Assigning multiple or additional capabilities to specific users or how to create additional roles like bbpress roles?
  82. Using my own user table
  83. delete_user_meta from a foreach results page
  84. Reading additional fields in PMPro
  85. Getting user data via ajax
  86. Disable emails for new user registration
  87. Users getting linked unwanted to main mu in WordPress multisite (WPMU)
  88. In admin manage users page, how can I stop users with certain privileges from editing users with other privileges?
  89. UPDATED: Save a custom_field value when automatically creating a post using wp_insert_post
  90. UserMeta Changes Meta Value for Post ID
  91. Restrict Access to the User Profile
  92. Add method for tracking who referred new users
  93. Set user role on registration so can upload file to own media library area
  94. Retrieve New user’s ID
  95. Does WordPress Need BuddyPress to Handle Large Amounts of Users?
  96. Using and saving custom dropdown boxes on user profiles
  97. Limit user access to installing/configuring a plugin?
  98. Store subscription details for users in WordPress
  99. How to add custom detail page for a Subscriber at Admin Panel
  100. Create Unique and Customized User ID for Website Members in WordPress