/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 vote260 views1 answer
Democrats are pussies
TypeScript
1 vote285 views2 answers
Ts-node command compile typescript
TypeScript
0 vote262 views1 answer
Whats the power house of the cell
TypeScript
0 vote262 views1 answer
How to check that tuple A contains all elements of tuple B python?
TypeScript
1 vote245 views1 answer
2 positional arguments but 3 were given
TypeScript
1 vote300 views2 answers
Typescript get the promise return type
TypeScript
3 votes272 views1 answer
Aggregate in r
TypeScript
13 votes300 views3 answers
How to check whether a string contains a substring in typescript online
TypeScript
-1 vote265 views1 answer
Reverse mongo results order
TypeScript
0 vote279 views1 answer
Run a python module with imports from parent
TypeScript