select distinct territoryId from request.qmd_cdrTerritoryHierarchy where parentTerritoryId in () SELECT top 1 fmid FROM tbl_CDR_Distributors cdr WHERE ownerid = AND fsl_TableCode = AND fmid IS NOT NULL select count(*) enabled from tbl_LIB_ModSettings where companyPKeyId = and companyPType = and moduleId = 86 and settingid = 11 and value = 1 SELECT territoryid, name, territoryName, brokerLevel, Rank, parentTerritoryID, primaryManager FROM request.qmd_userTerritoryHierarchy WHERE brokerLevel = 1 SELECT distinct parentTerritoryId FROM request.qmd_listBrokerMrkts WHERE brokerLevel = 1 SELECT territoryid, name, territoryName, brokerLevel, Rank, parentTerritoryID, primaryManager FROM request.qmd_userTerritoryHierarchy WHERE brokerlevel <> 1 filterChanged = false; applyDistributorContext(); select parentTerritoryId, localMarket, childterritoryids, rank from request.qmd_cdrTerritoryHierarchy where TerritoryId in () if( ListLen( _param, "=" ) gt 1 ) { _paramName = ListFirst( _param, "=" ); _paramValue = ListLast( _param, "=" ); StructInsert( client, _paramName, _paramValue, true ); } else { _paramName = ListFirst( _param, "=" ); if( isDefined( "client.#_paramName#" ) and isNumeric( client[_paramName] )) { StructInsert( client, _paramName, 0, true ); } else { StructInsert( client, _paramName, "", true ); } } select parentTerritoryId from request.qmd_cdrTerritoryHierarchy where territoryid = select parentTerritoryId, localMarket, rank, childterritoryids from request.qmd_cdrTerritoryHierarchy where TerritoryId in () order by localMarket asc, parentTerritoryid asc select parentTerritoryId, localMarket, rank, childterritoryids from request.qmd_cdrTerritoryHierarchy where TerritoryId in () order by localMarket asc, parentTerritoryid desc