Consultation and elimination that returns me the products that do not have the "available for orders" box in Prestashop 1.7

[ivanchu83]

Hello, could someone who knows SQL well tell me how to make a query to be able to do it and then a DELETE in sql to be able to eliminate all the products from the database that are NOT available for orders? Since these products come out without a price and cannot be added to the cart, I have almost 5 thousand products, so looking at them one by one is impossible for me.

Thanks

[Mediacom87]

Merci de respecter la langue du forum ou de poster dans la section correspondant à votre langue.