Wordpress: Clean up tables / Limpiar tablas

/* Delete Spam Comments */ DELETE FROM wp_comments WHERE comment_approved = 'spam'; /* Delete Unapproved Comments */ DELETE from wp_comments WHERE comment_approved = '0' /* optimizing and clean up the wp_postmeta table */ 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; /* delete sessions */ DELETE FROM wp_options WHERE option_name LIKE '_wc_session_%' OR option_name LIKE '_wc_session_expires_%' /* delet TRANSIENT expirados (Transients API allow developers to store information in your WordPress database with an expiration time. )*/ DELETE FROM `wp_options` WHERE `option_name` LIKE ('_transient_%'); DELETE FROM `wp_options` WHERE `option_name` LIKE ('_site_transient_%');