/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

7 votes137 views3 answers
Convert double list to single list python
TypeScript
0 vote156 views1 answer
Publication only contains dependencies and/or constraints without a version. You need to add minimal version information, publish resolved versions
TypeScript
1 vote140 views2 answers
Subplots matplotlib
TypeScript
1 vote133 views1 answer
:= and = in gdscript
TypeScript
0 vote127 views1 answer
You can initiate objects from a
TypeScript
0 vote137 views1 answer
Angular api rest
TypeScript
0 vote134 views1 answer
Mat-nav-list' is not a known element angular 9
TypeScript
0 vote152 views1 answer
Explode() expects parameter 2 to be string, array given
TypeScript
0 vote136 views1 answer
Python set remove duplicate elements
TypeScript
1 vote142 views1 answer
Typescript as
TypeScript