/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 vote327 views1 answer
Axes3D currently only supports the aspect argument 'auto'. You passed in 'equal'.
TypeScript
0 vote179 views1 answer
Copy text from file to another file in javascript with fs
TypeScript
0 vote180 views2 answers
Filtering objects in django templates
TypeScript
0 vote194 views1 answer
Argument of type '{ query: string; }' is not assignable to parameter of type 'AxiosRequestConfig'.
TypeScript
2 votes178 views1 answer
Typescript type for intervalId
TypeScript
0 vote175 views1 answer
Typescript dynamic array key
TypeScript
23 votes295 views5 answers
Nodemon typescript
TypeScript
0 vote203 views1 answer
Depth-first search that chooses values for one variable at a time and returns when a variable has no legal values left to assign
TypeScript
0 vote188 views1 answer
Does key repeats in hashmap
TypeScript
1 vote180 views1 answer
Moving data between the request in api
TypeScript