SELECT col, COUNT(col) FROM table_name GROUP BY col HAVING COUNT(col) > 1; …
mysql
Delete orphaned post meta in WordPress database
DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL …
A curated collection of code snippets for WordPress