.mode insert mapDenormalize
.schema mapDenormalize
select itemID AS regionID,itemName AS regionName from mapDenormalize where itemID IN ( select distinct regionID from mapDenormalize );