/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 vote171 views1 answer
Hong Kong Human Rights and Democracy Act opinion
TypeScript
0 vote174 views1 answer
Upload keystore file to secrets github actions
TypeScript
0 vote160 views1 answer
How to keep only certian objects python
TypeScript
3 votes177 views1 answer
Hosts
TypeScript
0 vote173 views1 answer
Google chrome keyboard shortcuts windows
TypeScript
-1 vote188 views1 answer
Fwrite() expects parameter 2 to be string, array given
TypeScript
9 votes169 views2 answers
Array contains typescript
TypeScript
2 votes176 views1 answer
Enum usage typescript
TypeScript
1 vote158 views1 answer
Binding reference of type discards qualifiers
TypeScript
0 vote175 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