delete aa from 0p4_auth_assignment aa left join 0p4_auth_item ai on ai.name=aa.item_name
where ai.name is null