How to filter goods that have been out of stock for a long time and delete it?

[PanzerkampfPL]

Is there any way to pull from Presta a list of products chronologically with the longest "0" status or disabled, e.g. with sql queries or some analytical module? 
Or is there a native function that allows this?  I wants to find products that have been out of stock for a long time and are pointlessly littering the base.   

I can't just remove all with a quantity of '0' because some cyclically come into stock and sell out and others have been sold out for a long time and these are the ones I would like to remove. There are more than 14k products in the database. 

[ps8modules]

Hi,
Prestashop does not save the stock status date "stock movement"  anywhere.
The only option is to find out the date of the last product change in the ps_product table and the date_upd column.
So, theoretically, it would be possible to select products that have 0 quantity and date_upd < your date.

It also depends on how you update the stock. If you use a script or manually in the product administration.

Edited January 11, 2023 by prestashopfree.com (see edit history)