Cleaning out WordPress Database in relation to very large comments table

queries.sql

DELETE FROM wp_postmeta
WHERE post_id IN (
	SELECT ID from wp_posts WHERE post_title = 'sfn_followup_emails'
);

DELETE FROM wp_posts WHERE post_title = 'sfn_followup_emails';

DELETE FROM wp_postmeta
WHERE post_id IN (
	SELECT ID from wp_posts WHERE post_title = 'wcs_report_update_cache' and post_status != 'pending'
);

DELETE FROM wp_posts WHERE post_title = 'wcs_report_update_cache' and post_status != 'pending';

DELETE FROM wp_postmeta
WHERE post_id IN (
	SELECT ID from wp_posts WHERE post_title = 'wcs_report_update_cache' and post_status != 'pending'
);

DELETE FROM wp_posts WHERE post_title = 'wcs_report_update_cache' and post_status != 'pending';

DELETE FROM wp_postmeta
WHERE post_id IN (
	SELECT ID from wp_posts WHERE post_title = 'woo_sc_generate_coupon_csv' and post_status != 'pending'
);

DELETE FROM wp_posts WHERE post_title = 'woo_sc_generate_coupon_csv' and post_status != 'pending';

DELETE FROM wp_postmeta
WHERE post_id IN (
	SELECT ID from wp_posts WHERE post_title = 'woo_sc_import_coupons_from_csv' and post_status != 'pending'
);

DELETE FROM wp_posts WHERE post_title = 'woo_sc_import_coupons_from_csv' and post_status != 'pending';

DELETE FROM wp_postmeta
WHERE post_id IN (
	SELECT ID from wp_posts WHERE post_title = 'sfn_send_usage_report' and post_status != 'pending'
);

DELETE FROM wp_posts WHERE post_title = 'sfn_send_usage_report' and post_status != 'pending';

DELETE FROM wp_comments
WHERE comment_type = 'action_log';