select * from request.qmd_userTerritoryHierarchy where localmarket = 1