mysql> SELECT id,name FROM domains WHERE htype='vrt_hst' AND id NOT IN (SELECT dom_id FROM hosting);
mysql> UPDATE domains SET htype='none' WHERE htype='vrt_hst' AND id NOT IN (SELECT dom_id FROM hosting);