cfmod_getPartnerLists.cfm: #gettickcount() - _start#
 cfmod_getPartnerLists.cfm: #gettickcount() - _start#
 select #qryOprList.columnList# from qryOprList union select #qryOprList.columnList# from qryOprList2 order by listName select opr.operatorId, opr.companyName, opr.oprCompanyType, case when lvl.brokerLevel = 1 then 'Y' else 'N' end localAffiliation, ter.name territoryName from tbl_OPR_ClientOperators opr with (nolock) inner join tbl_TER_Territories ter with (nolock) on ter.territoryId = opr.territoryId inner join tbl_TER_TerritoryLevels lvl with (nolock) on lvl.levelId = ter.levelId where opr.ownerId = and opr.fsltablecode = and opr.crmactive = 'Y' and opr.oprCompanyType in ( 'C', 'G' ) order by opr.oprCompanyType, opr.companyName qryAffiliations: #gettickcount() - _start#
 select * from qryAffiliations where oprCompanyType = 'G' select * from qryAffiliations where oprCompanyType = 'C'
checked> checked> checked>
    select mfr_id, mfr_name from tblManufacturers with (nolock) where mfr_id in ( )