I have in a woocommerce shop 69 000 “pending cancelation” subscription.

Is there anyway to make a mass removal of those by SQL ?

Here is the URL settings to display them :

post_status=pending&post_type=wc_user_membership

I’ve tried to display 999 posts per page, & delete them, but i get a NGINX 414 error.

thanks in advance for your precious help.