WP-Sweep allows you to clean unused data site, the duplicates and much more – what you need to remove to optimize your project. In addition, the plugin optimizes the database tables.
WP-Sweep

The plugin cleans
Fixes
Automatic drafts
Deleted comments
Not approved comments
Spam
Lost the metadata for the posts
Lost metadata for review
Orphaned metadata for users
Lost for metadata terms and user rights
Duplicate metadata for posts
Duplicate metadata for review
Duplicate metadata for users
Duplicate metadata terms and user rights
Timing settings
Optimizes the database tables
Built-in cache to the metadata of the posts
This extension uses WordPress function instead of direct query in database using MySQL.
The following delete function is used
wp_delete_post_revision()
wp_delete_post()
wp_delete_comment()
delete_post_meta()
delete_comment_meta()
delete_user_meta()
delete_term_meta()
wp_remove_object_terms()
wp_delete_term()
delete_transient()
delete_site_transient()

Get – получить