SQL mass removal query for pending subscription

Question

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.

--------------------------------------------------

>>> Share a link to this question, just copy and paste the code bellow on your web page <<<

<a href="https://www.wptricks.com/question/sql-mass-removal-query-for-pending-subscription/">

SQL mass removal query for pending subscription</a>
0
, , Gregory 2 months 0 Answers 54 views 0

Leave an answer