DELETE FROM t_kiroku
WHERE EXISTS
(SELECT 1
FROM engage_data
WHERE engage_data.kanrino = t_kiroku.kanrino
AND engage_data.adddate < '2024-01-01');
REVMRVRFIEZST00gdF9raXJva3UKV0hFUkUgRVhJU1RTCiAgKFNFTEVDVCAxCiAgICBGUk9NIGVuZ2FnZV9kYXRhCiAgICBXSEVSRSBlbmdhZ2VfZGF0YS5rYW5yaW5vID0gdF9raXJva3Uua2FucmlubwogICAgQU5EIGVuZ2FnZV9kYXRhLmFkZGRhdGUgPCAnMjAyNC0wMS0wMScpOw==