with ld as (
select
    ITEM_CODE
    ,date(max(coalesce(LAST_DELIVERY_DATE,"3000-01-01"))) as LAST_DELIVERY_DATE
from
    STOCK
group by
    ITEM_CODE
)
,base as (
select
    i.ITEM_CODE
from
    ITEM as i
    left join
    ld
    on i.ITEM_CODE = ld.ITEM_CODE
where
    i.STOCK_MANAGEMENT_TYPE=1
    and(
        ld.ITEM_CODE is null
        or LAST_DELIVERY_DATE<date("2023-01-01")
    )
)
delete from
    ITEM
where
    ITEM_CODE in (SELECT ITEM_CODE from base)