with note as (select 
* from item
where not exists (select 1 from stock where stock.item_code = item.item_code)
)
, nl as (
select item_code from stock where last_delivery_date is null
)
, old as (
select 
item_code
, max(last_delivery_date) as ml
from stock
where item_code not in (select item_code from nl)
group by item_code
)
, dold as (
select item_code from old where ml <= date('2023-06-01', '-6 month')
)
delete from item where stock_management_type = 1 and (item_code in (select item_code from note) or item_code in (select item_code from dold))