members log
{ts '2025-03-17 10:35:44'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731

{ts '2025-03-17 10:35:44'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731

{ts '2025-03-17 10:35:52'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and loginEnabled = 1
            
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 20 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR

{ts '2025-03-17 10:35:52'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and loginEnabled = 1
            
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where 

	(
	[fspro_userId]
							= '5025731' 	
	)



	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR

{ts '2025-03-17 10:35:52'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and loginEnabled = 1
            
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 20 rows fetch next 20 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR

{ts '2025-03-17 10:35:52'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and loginEnabled = 1
            
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where 

	(
	[fspro_userId]
							= '5025731' 	
	)



	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR

{ts '2025-03-17 10:36:46'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731

{ts '2025-03-17 10:36:46'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731

{ts '2025-03-17 10:36:49'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and loginEnabled = 1
            
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 20 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR

{ts '2025-03-17 10:36:49'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and loginEnabled = 1
            
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where 

	(
	[fspro_userId]
							= '5025731' 	
	)



	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR

{ts '2025-03-17 10:36:49'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and loginEnabled = 1
            
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 20 rows fetch next 20 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR

{ts '2025-03-17 10:36:49'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and loginEnabled = 1
            
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where 

	(
	[fspro_userId]
							= '5025731' 	
	)



	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR

{ts '2025-03-17 10:37:21'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731

{ts '2025-03-17 10:37:22'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731

{ts '2025-03-17 10:37:22'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 4696955 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 4696955

{ts '2025-03-17 10:43:08'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731

{ts '2025-03-17 10:43:09'} SQL
{ts '2025-03-17 10:43:09'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 4696955 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- MFR
-- 5025731

-- 4696955

{ts '2025-03-17 10:43:14'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731

{ts '2025-03-17 10:43:15'} SQL
{ts '2025-03-17 10:43:15'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 4696955 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- 6868
-- MFR
-- MFR
-- 4696955
-- 5025731


{ts '2025-03-17 12:05:14'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731

{ts '2025-03-17 12:05:15'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 4696908 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 4696908

{ts '2025-03-17 12:05:15'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 4696908 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 4696908

{ts '2025-03-17 12:05:34'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731

{ts '2025-03-17 12:05:35'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5105201 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5105201

{ts '2025-03-17 12:05:35'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5105201 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5105201

{ts '2025-03-17 12:05:44'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731

{ts '2025-03-17 12:05:45'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731

{ts '2025-03-17 12:05:45'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 4696913 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 4696913

{ts '2025-03-17 12:06:20'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731

{ts '2025-03-17 12:06:21'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5105201 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5105201

{ts '2025-03-17 12:06:21'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5105201 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5105201

{ts '2025-03-17 13:12:13'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731

{ts '2025-03-17 13:12:13'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731

{ts '2025-03-17 13:13:02'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and loginEnabled = 1
            
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 20 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR

{ts '2025-03-17 13:13:02'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and loginEnabled = 1
            
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where 

	(
	[fspro_userId]
							= '5025731' 	
	)



	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR

{ts '2025-03-17 13:13:02'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and loginEnabled = 1
            
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where 

	(
	[fspro_userId]
							= '5025731' 	
	)



	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
{ts '2025-03-17 13:13:02'} SQL
-- 6868
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and loginEnabled = 1
            
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 20 rows fetch next 20 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- MFR
-- 6868

-- MFR

{ts '2025-03-17 13:14:06'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731

{ts '2025-03-17 13:14:07'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731

{ts '2025-03-17 13:14:07'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5089938 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5089938

{ts '2025-03-17 13:15:28'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with data as (
        select fspro_userId, firstName, lastName, email, title, staffMember, loginEnabled, firstName + ' ' + lastName as fullName
          from tbl_FSPro_members with (nolock)
         where ownerId = @ownerId
           and fsl_tablecode = @ownerType
           and nullif( orgId, 0 ) is null -- make sure we we don't get CRM contacts
           and nullif( email, '' ) is not null -- make sure we only get those with email address

           
            and fspro_userId = ? 
    )


    


, data_mappedData as (

	select *
		
	  from data

)

, data_preData as (

	
	select *
	  from data_mappedData with (nolock)

	
	
	where [fspro_userId] = 5025731 


	)

	, data_data as (

		select * 
		        
		  from data_preData
		  

	)



	, data_return as (
		select * from data_data
		where 1 = 1


	order by fullName
		
		
		 offset 0 rows fetch next 10000000 rows only
	
	)

	
	, data_result as (
		select ( select count(*) from data_data ) as totalCount, 
			   
		       ( select * from data_return for json auto, include_null_values ) as data
		)


	select * from data_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 6868
-- MFR
-- 5025731