/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

1 vote236 views2 answers
Mongodb update all items in array
TypeScript
-1 vote255 views1 answer
Typescript http get attach headers
TypeScript
17 votes260 views3 answers
Typescript Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
TypeScript
34 votes270 views3 answers
Serverless.ps1 cannot be loaded because running scripts is disabled on this system.
TypeScript
0 vote239 views1 answer
This method can provide higher level of accuarcy in cost estimation based on the given historical data
TypeScript
1 vote330 views1 answer
Dataframe value counts sort
TypeScript
-1 vote259 views1 answer
Whats a company letterhead
TypeScript
0 vote265 views1 answer
Interface with variable key typescript
TypeScript
0 vote253 views1 answer
Common child hackerrank solution
TypeScript
0 vote329 views1 answer
If you meant to render a collection of children use an array instead
TypeScript