delete from portals where portal_id = :portal_id and owner_id is not null