classifications log
{ts '2025-07-03 08:18:20'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 08:18:29'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 08:19:26'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 08:41:34'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 08:46:44'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 08:47:41'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 08:51:40'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 09:04:57'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 09:08:35'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 09:11:18'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 09:11:19'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 09:11:31'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 09:11:50'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 09:26:30'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 09:26:39'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 09:44:25'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 10:06:40'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 11:10:00'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

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

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO

{ts '2025-07-03 15:00:11'} SQL
declare @ownerId int = ?;
    declare @ownerType varchar(3) = ?;

    with classifications as (

        select c.classificationId, c.name, c.description, c.sortRank, c.abbreviation
        from tbl_OPR_Classifications c with (nolock)
        where ownerId = @ownerId
        and ownerType = @ownerType

    )

    


, classifications_mappedData as (

	select *
		
	  from classifications

)

, classifications_preData as (

	
	select *
	  from classifications_mappedData with (nolock)

	
	
	where ( 1 = 1 ) 


	)

	, classifications_data as (

		select * 
		        
		  from classifications_preData
		  

	)



	, classifications_return as (
		select * from classifications_data
		where 1 = 1


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

	
	, classifications_result as (
		select ( select count(*) from classifications_data ) as totalCount, 
			   
		       ( select * from classifications_return for json auto, include_null_values ) as data
		)


	select * from classifications_result
	for JSON PATH, INCLUDE_NULL_VALUES, WITHOUT_ARRAY_WRAPPER
-- 387
-- BRO