select
    TBL2.*
from
    STOCK as TBL1
INNER join
    ITEM as TBL2 on TBL1.ITEM_CODE = TBL2.ITEM_CODE
where
    STOCK_MANAGEMENT_TYPE = 1 and TBL1.ACTUAL_AMT <> 0 and ifnull(LAST_DELIVERY_DATE,'2023-06-01') > date('2023-06-01', 'localtime', '-6 month')