Wordpress DB Cleanup

gistfile1.sql

/* Delete revisions */
DELETE FROM wp_posts WHERE post_type = "revision";

/**
 * Also set in wp-config.php
 * define( 'WP_POST_REVISIONS', 3 );
 */
 
/* Clean postmeta where the associated post no longer exists */
SELECT * FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;
DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;