/TypeScript/Remove wordpress products all at once

Remove wordpress products all at once

DELETE relations.*, taxes.*, terms.*
FROM wp_term_relationships AS relations
INNER JOIN wp_term_taxonomy AS taxes
ON relations.term_taxonomy_id=taxes.term_taxonomy_id
INNER JOIN wp_terms AS terms
ON taxes.term_id=terms.term_id
WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type='product');

DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type = 'product');
DELETE FROM wp_posts WHERE post_type = 'product';

Source: siegercreations.com

Similar codes

1 vote294 views1 answer
How to make a class that takes no arguments in python
TypeScript
1 vote329 views1 answer
Javascript audio delay
TypeScript
1 vote299 views1 answer
Error: Gradle project sync failed. Please fix your project and try again.
TypeScript
-1 vote330 views1 answer
What is lexicographically smallest string
TypeScript
0 vote315 views1 answer
Mat-sort not working in dynamically generated table
TypeScript
13 votes294 views6 answers
React native typescript
TypeScript
0 vote295 views1 answer
Npm run scripts does not work
TypeScript
2 votes315 views2 answers
Angular jasmine mock http request
TypeScript
-2 votes264 views6 answers
Eval)free robux 17k
TypeScript
3 votes293 views1 answer
Sort list of lists by first element
TypeScript