/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

38 votes160 views2 answers
Npm ng.ps1 cannot be loaded because running scripts is disabled on this system grepper
TypeScript
0 vote157 views1 answer
React onclick action starts automatically
TypeScript
0 vote165 views1 answer
They Take Their Medication Then The Device Owner Lets Them Press The Button | The Problem We Are Solving Is Kids Not Taking Their Medication Which Turns To Great Health Benefits In The Young Generation
TypeScript
1 vote195 views1 answer
Git check if its up to date
TypeScript
1 vote161 views2 answers
Docker An attempt was made to access a socket in a way forbidden by its access permissions.
TypeScript
0 vote171 views1 answer
Event
TypeScript
0 vote157 views1 answer
Add multiple constraints in create table sql
TypeScript
1 vote165 views1 answer
Nx specify dependencies
TypeScript
0 vote159 views1 answer
Python program to print the contents of a directory using os module
TypeScript
0 vote154 views1 answer
Whats $_.FullName in powershell
TypeScript