Delete all the shop_subscription, Licences and Orders and Users

my.sql

DELETE FROM wp_postmeta where post_id IN (SELECT ID from wp_posts where post_type = 'shop_subscription' );


DELETE FROM wp_comments where comment_post_ID IN (SELECT ID from wp_posts where post_type = 'shop_subscription' );



DELETE from wp_posts where post_type = 'shop_subscription'



TRUNCATE TABLE wp_woocommerce_software_licenses;



DELETE FROM wp_postmeta where post_id IN (SELECT ID from wp_posts where post_type = 'shop_order' );


DELETE FROM wp_comments where comment_post_ID IN (SELECT ID from wp_posts where post_type = 'shop_order' );

DELETE from wp_posts where post_type = 'shop_order'


DELETE FROM wp_usermeta where user_id IN (SELECT ID from wp_users where user_email NOT LIKE '%@buddyboss.com' );

DELETE from wp_users where user_email NOT LIKE '%@buddyboss.com';