/TypeScript/Woocommerce bulk product delete

Woocommerce bulk product delete

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: wpfluent.com

Woocommerce bulk product delete

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 vote101 views1 answer
Does not use passive listeners to improve scrolling performance
TypeScript
0 vote92 views1 answer
Migrate to typescript
TypeScript
0 vote104 views1 answer
Check if graphic driver exists ubuntu
TypeScript
0 vote94 views2 answers
--skip tests generate components - Angular 12 - skip-tests vs spec-false
TypeScript
0 vote112 views1 answer
Typescript optional property
TypeScript
0 vote112 views1 answer
C# get all elements from list
TypeScript
0 vote111 views1 answer
Hack roblox account easy
TypeScript
0 vote108 views1 answer
Why important testng xml file
TypeScript
0 vote103 views1 answer
Rust typedef
TypeScript
0 vote98 views1 answer
Typescript type array of interface
TypeScript