Database Cleaner and Lookup

WP_OPTION CLEANER

SELECT * FROM `wp_options` WHERE option_name LIKE '%gamipress_cache%'

DELETE FROM `wp_options` WHERE option_name LIKE '%gamipress_cache%' AND autoload=yes

SELECT * FROM `wp_options` WHERE option_name LIKE '%updraft_ %'

DELETE FROM `wp_options` WHERE option_name LIKE '%updraft_ %'

updraft_

WP_POSTS CLEANER

SELECT * FROM `wp_posts` WHERE post_title LIKE '%wc_admin_unsnooze_admin_notes%'

DELETE FROM `wp_posts` WHERE post_title LIKE '%wc_admin_unsnooze_admin_notes%'

SELECT * FROM `wp_posts` WHERE `post_type`='listing' ORDER BY `ID` DESC (Delete Listings)

WP_TERMS CLEANER

DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE count = 0 );

DELETE FROM wp_term_taxonomy WHERE term_id not IN (SELECT term_id FROM wp_terms);

DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy);