/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

1 vote297 views1 answer
Typescript mix props
TypeScript
0 vote370 views1 answer
Laravel validation exists multiple tables laravel
TypeScript
1 vote330 views2 answers
The server time zone value 'FLE' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more
TypeScript
0 vote353 views1 answer
Upload keystore file to secrets github actions
TypeScript
0 vote392 views1 answer
How to disable piecelabel on certian charts and keep on other chartjs
TypeScript
3 votes321 views1 answer
ERROR in node_modules/rxjs/internal/types.d.ts(81,44): error TS1005: ';' expected.
TypeScript
1 vote313 views1 answer
Nodejs exec exit code
TypeScript
3 votes351 views2 answers
Angular formgroup validate manually
TypeScript
-1 vote302 views1 answer
What are the components of the environment? Explain it along with the examples.
TypeScript
0 vote332 views1 answer
C# copy the elements of a list to another list
TypeScript