/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 vote135 views1 answer
Combine 2 lists to dataframe python
TypeScript
2 votes143 views2 answers
Constraints in database
TypeScript
4 votes126 views2 answers
Typescript get type
TypeScript
1 vote144 views1 answer
What is test management review
TypeScript
8 votes150 views2 answers
See conda enviroments
TypeScript
7 votes146 views5 answers
Typescript foreach async await
TypeScript
1 vote104 views1 answer
Jquery selector id starts with and ends with
TypeScript
0 vote141 views1 answer
Some of elements are arrays in python
TypeScript
1 vote186 views1 answer
Adonis query delete
TypeScript
0 vote140 views1 answer
How to set value of multiselect dropdown for reactive forms in angular 6
TypeScript