from tbl_cdr_distributors with (nolock) where ownerid = and fsl_tablecode = and crmactive = 'Y' and cdr_dstcompanytype <> 'O' and cdr_dstcompanytype <> 'S' and cdr_territoryId in ( ) and ( ( cdr_dstname like or cdr_dstcity like ) and 1 = 1 )