/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

7 votes162 views3 answers
Convert double list to single list python
TypeScript
0 vote194 views1 answer
Two sets of parentheses after function call
TypeScript
1 vote157 views2 answers
Convert epoch time
TypeScript
0 vote169 views3 answers
Error: Maximum update depth exceeded. This can happen when a component repeatedly calls setState inside componentWillUpdate or componentDidUpdate. React limits the number of nested updates to prevent infinite loops.
TypeScript
0 vote158 views1 answer
Cannot find name 'modalRef'
TypeScript
1 vote179 views1 answer
If exists certain line in sql table java condition
TypeScript
0 vote236 views1 answer
Curl -s "http://google.com?[1-1000]"
TypeScript
0 vote168 views1 answer
Pip install requirements txt not found
TypeScript
0 vote155 views1 answer
W to check whether an image is a broken image or not in typescript angular
TypeScript
0 vote161 views1 answer
Angular no internet detection
TypeScript