/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 vote107 views2 answers
Django query to return User whose first name starts with j or last name starts with h
TypeScript
2 votes96 views1 answer
React.children
TypeScript
2 votes100 views1 answer
All elements that begin with r
TypeScript
11 votes99 views6 answers
Localstorage
TypeScript
-1 vote100 views1 answer
Components react to hooks
TypeScript
1 vote94 views1 answer
Why does the Circum-Pacific belt of earthquakes coincide with the Pacific ring of fire
TypeScript
31 votes125 views4 answers
How to see all commits in git
TypeScript
0 vote107 views1 answer
Check runnong ports ubuntu
TypeScript
0 vote99 views1 answer
Delete the last string from file in typescript
TypeScript
0 vote107 views1 answer
Objects all django what is returned
TypeScript