/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 vote219 views1 answer
R merge list
TypeScript
7 votes209 views2 answers
Typescript axios
TypeScript
1 vote224 views1 answer
How do you generate test data
TypeScript
1 vote225 views1 answer
How to reset stats in diablo 2
TypeScript
0 vote216 views1 answer
Execution failed for task ':app:lint'. > Lint infrastructure error
TypeScript
7 votes204 views2 answers
Pandas read csv check if column exists
TypeScript
8 votes252 views4 answers
How to check open ports mac
TypeScript
2 votes204 views1 answer
Mat-form-field email validation
TypeScript
11 votes226 views3 answers
Property 'active' has no initializer and is not definitely assigned in the constructor.ts(2564)
TypeScript
0 vote214 views1 answer
How to print selected elements from a list
TypeScript