wgstjf
/ delete-orphans-postmeta.sql
Last active
June 12, 2022 20:02
— forked from carlosleopoldo/delete-orphans-postmeta.sql
WP: Delete all orphans post meta in WordPress Raw
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DELETE FROM wp_postmeta | |
| WHERE post_id NOT IN ( | |
| SELECT ID FROM wp_posts | |
| ); |
wgstjf
/ delete-orphans-usermeta.sql
Last active
June 4, 2021 08:39
— forked from carlosleopoldo/delete-orphans-usermeta.sql
WP: Delete all orphans user meta in WordPress
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DELETE FROM wp_usermeta | |
| WHERE NOT EXISTS ( | |
| SELECT * FROM wp_users | |
| WHERE wp_usermeta.user_id = wp_users.ID | |
| ) |