delete from images where image_id in (select latest_revision from cr_items where parent_id = :comment_id)