/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

30 votes217 views6 answers
Install typescript using npm
TypeScript
14 votes237 views1 answer
Ngbmodal angular 9 yarn install
TypeScript
1 vote214 views2 answers
Distance subplots matplotlib
TypeScript
2 votes212 views1 answer
Coronavirus treatments India
TypeScript
1 vote187 views2 answers
Check if url exists python
TypeScript
76 votes351 views6 answers
Running scripts is disabled on this system
TypeScript
0 vote192 views2 answers
Get string in brackets python
TypeScript
0 vote200 views1 answer
DISTINQUISH BETWEEN THE AVERAGE CASE AND WORSE CASE RUNNING TIME AND THE FACTORS AFFECTING THAT AFFECTS THE RUNNING TIME OF AN ALGORITHM
TypeScript
2 votes187 views1 answer
Type casting in typescript
TypeScript
61 votes310 views6 answers
Ps1 cannot be loaded because running scripts is disabled on this system
TypeScript