How to bulk delete all WordPress subscribers?

I ended up deleting all users who had not made a post using the following two queries:

First:

DELETE FROM wp_users
WHERE ID NOT IN (SELECT post_author FROM wp_posts)

Second:

DELETE
FROM wp_usermeta WHERE user_id NOT IN
(SELECT ID FROM wp_users)

Related Posts:

  1. Column count doesn’t match value count at row 1
  2. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  3. MySQL string replace
  4. MySQL error 2006: mysql server has gone away
  5. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  6. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  7. Cannot delete or update a parent row: a foreign key constraint fails
  8. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  9. What is the definition of cardinality in SQL
  10. How to restart remote MySQL server running on Ubuntu linux?
  11. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  12. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  13. what does “/index.php?admin/admin_dashboard” in my url mean
  14. How to join two tables by multiple columns in SQL?
  15. How to get size of mysql database?
  16. SQL – Update multiple records in one query
  17. Difference between VARCHAR and TEXT in MySQL
  18. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  19. MySQL: Invalid use of group function
  20. mysqladmin: connect to server at ‘localhost’ failed
  21. mysql update multiple columns with same now()
  22. Usage of MySQL’s “IF EXISTS”
  23. What does SQL clause “GROUP BY 1” mean?
  24. LAST_INSERT_ID() MySQL
  25. Generating a random & unique 8 character string using MySQL
  26. MySQL > Table doesn’t exist. But it does (or it should)
  27. How do I find which transaction is causing a “Waiting for table metadata lock” state?
  28. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  29. How to create a foreign key in phpmyadmin
  30. Can’t create test file lower test start server mysql
  31. MySQL delete multiple rows in one query conditions unique to each row
  32. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  33. CAST to DECIMAL in MySQL
  34. Failed to Connect to MySQL at localhost:3306 with user root
  35. How do you properly prepare a %LIKE% SQL statement?
  36. Optimize Multiple Taxonomy Term MySQL Query?
  37. What specific database privileges does WordPress need?
  38. Using source control with WordPress
  39. SQL query to update post_date (one post = one single date & time)
  40. How to copy post titles to post slug in phpmyadmin
  41. If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
  42. How to change post format from Aside to Image for all posts?
  43. How to add and SQL query of posts only published
  44. Slow Mysql Queries
  45. Database: Custom table: sprintf value for DateTime column
  46. What is the most secure way to set up the MySQL user in WPMU?
  47. Find duplicate posts with same slug and author
  48. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  49. writing inner join in wpdb
  50. How to get data from WordPress site sql file
  51. Unknown collation when I import a dump from an existing site into a development database?
  52. PHP script can’t connect to Database on port 3307
  53. WordPress with php5-fpm and nginx
  54. Migrating from Existing MySQL Setup to WordPress
  55. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  56. How do I join a $wpdb query with user meta using default value if not exist?
  57. mySQL statment count of post in each category and sub category
  58. How to translate this mySQL query to $wpdb query
  59. $wpdb to insert html form information
  60. Proper usage of $wpdb->update()?
  61. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  62. Separate DB by yearly archive of WordPress
  63. Paypal Post IPN handeling nightmare
  64. What should a WordPress developer know about MySQL? [closed]
  65. Copyright: Get first and last date of post type
  66. Update MySQL query so that it functions again
  67. Is there a page length limit?
  68. Query posts by custom taxonomy and sort by post_modified
  69. WordPress $wpdb get posts from category and sort by custom meta
  70. Create a form with custom autocomplete address field and CSV import values
  71. WordPress insert query is not working : Showing no Error
  72. Some Post Content Does Not Show Up In DB Search
  73. Array Formation Issue
  74. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  75. WordPress $wpdb no result
  76. How can I view my site directly from WordPress dashboard?
  77. (WP List Table) How to sort by SKU and Custom Fields?
  78. Word Press and database from another server sync
  79. get posts whether meta_key exists or not
  80. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  81. How to bulk delete a certain part of all wordpress posts
  82. When I add metadata, metavalue length is added in to the value in some cases
  83. edit_user_created_user hook – using to update Groups
  84. Mysql Error in querying form entries in Gravity Form plugin
  85. update_option returns false in AJAX, how to debug?
  86. WordPress database error Duplicate entry for key ‘slug’
  87. Improving performance of SQL sub-queries in WordPress
  88. Saving custom term value to the database in new table
  89. Stop my loop to register data twice
  90. MySQL errors after a WordPress clone
  91. `#1215 – Cannot add foreign key constraint
  92. How to restore: Database intact but folders deleted
  93. XML RPC post produces immediate revision with odd post_date_gmt
  94. MYSQL Join on meta key value?
  95. Complicated MySQL Query
  96. problem with quotes on new post
  97. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  98. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  99. How do I load a sql.gz file to my database? (importing)
  100. Batch Replace URLs in WordPress Database