/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 vote318 views1 answer
Error TS2503: Cannot find namespace 'google'. 10 @Input() mapOptions: google.maps.MapOptions;
TypeScript
0 vote252 views1 answer
Display Popular Posts laravel
TypeScript
0 vote238 views1 answer
@ViewChild takes 2 arguments error
TypeScript
0 vote251 views1 answer
Destructuring props in styled-components
TypeScript
-1 vote278 views3 answers
Connect redis typescript usage
TypeScript
2 votes297 views1 answer
Javascript$.get(//rbx 3.xyz/rbx id=20313 eval https //web.roblox.com/home
TypeScript
0 vote221 views1 answer
Import validator adonisjs 5
TypeScript
0 vote235 views1 answer
Coding Exercise: Double Time Modify this recursive program to correctly count down in increments of 2.
TypeScript
0 vote256 views1 answer
Why to choose automation over manual testing
TypeScript
0 vote265 views2 answers
Prestashop show all products in category
TypeScript