/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

0 vote192 views1 answer
How to clear all products woocommerce keep category
TypeScript
0 vote225 views2 answers
Angular 8 ts refresh page
TypeScript
1 vote198 views1 answer
Mongodb array not equal to value
TypeScript
0 vote188 views1 answer
Does i5 7th generation processor supports windows 11
TypeScript
0 vote204 views1 answer
Write getter angular
TypeScript
2 votes201 views1 answer
Multer s3
TypeScript
0 vote203 views1 answer
Export const typescript
TypeScript
8 votes235 views6 answers
How to make lists in python
TypeScript
1 vote245 views1 answer
React typescript cheat sheet
TypeScript
0 vote197 views1 answer
Angular modal dismisss
TypeScript