/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

2 votes221 views1 answer
Input event typescript
TypeScript
0 vote215 views3 answers
Code converter from javascript to typescript
TypeScript
3 votes183 views3 answers
E.target.value typescript
TypeScript
-1 vote206 views2 answers
What is a react hook
TypeScript
2 votes214 views1 answer
Number of elements in c++ array
TypeScript
0 vote235 views1 answer
Choose random elements from vector without repetition and adding to another vector c++
TypeScript
0 vote188 views1 answer
Google charts haxis font size
TypeScript
0 vote208 views1 answer
React-native-size-matters npm
TypeScript
-1 vote190 views1 answer
Components of http request
TypeScript
0 vote210 views1 answer
Casting objects in flutter or dart
TypeScript