with data as ( select distinct businessOwnerUserId, businessOwnerFirstName, businessOwnerLastName, businessOwnerEmail, businessOwnerFirstName + ' ' + businessOwnerLastName as businessOwnerFullName from tbl_DW_OperatorAgreements#_tableSuffix# with (nolock) where ownerId = and ownerType = and businessOwnerUserId > 0 and businessOwnerUserId in ( ) ) select count(*) over() as fseRowCount, * from data where businessOwnerUserId in ( ) #applyFilter( _dataStore.filter )# and #applyFilter( _dataStore.search )# order by businessOwnerFullName offset #_dataStore.skip# rows fetch next #_dataStore.take# rows only for json auto, include_null_values