mysqlクエリー条件に基づいてデータmarkを削除します

DELETEFROMdd_itemWHEREdd_item.id IN (
SELECT * from(

            SELECT
                a.id
            FROM
                dd_item a
            LEFT JOIN dd_item_cat b ON a.class_id = b.id
            WHERE
                b.parent_id=23 and 

(b.name in('オイスター','帯魚','ウナギ'))

        ) as ee

)

//mysql