Skip to content

Instantly share code, notes, and snippets.

@kosarlukascz

kosarlukascz/delete add_to_cart&reunds&actions

Last active October 6, 2020 11:00
Show Gist options
  • Save kosarlukascz/40dc40d6529ad7ee7a3498b11bd7d3c8 to your computer and use it in GitHub Desktop.
Save kosarlukascz/40dc40d6529ad7ee7a3498b11bd7d3c8 to your computer and use it in GitHub Desktop.
Download ZIP
delete add_to_cart&reunds&actions
Raw
delete add_to_cart&reunds&actions
delete
FROM `wp_posts`
where `post_type`= 'njt_user_add_to_cart';
delete
FROM `wp_posts`
where `post_type`= 'shop_order_refund';
delete
FROM `wp_posts`
where `post_type`= 'scheduled-action';
DELETE pm
FROM wp_postmeta pm
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
WHERE wp.ID IS NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment