classifications log
{ts '2025-07-07 11:18: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
-- 2358
-- BRO

{ts '2025-07-07 11:18:48'} 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
-- 2358
-- BRO

{ts '2025-07-07 11:19:06'} 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
-- 2358
-- BRO

{ts '2025-07-07 11:19: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
-- 2358
-- BRO

{ts '2025-07-07 11:23: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
-- 2358
-- BRO

{ts '2025-07-07 12:11: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
-- 2358
-- BRO

{ts '2025-07-07 12:11:48'} 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
-- 2358
-- BRO

{ts '2025-07-07 12:12: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
-- 2358
-- BRO

{ts '2025-07-07 12:12:23'} 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
-- 2358
-- BRO

{ts '2025-07-07 12:12:42'} 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
-- 2358
-- BRO

{ts '2025-07-07 12:12:49'} 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
-- 2358
-- BRO

{ts '2025-07-07 12:19:22'} 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
-- 2358
-- BRO

{ts '2025-07-07 12:19: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
-- 2358
-- BRO

{ts '2025-07-07 15:34:06'} 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
-- 2358
-- BRO

{ts '2025-07-07 15:34: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
-- 2358
-- BRO

{ts '2025-07-07 15:36: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
-- 2358
-- BRO

{ts '2025-07-07 15:37: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
-- 2358
-- BRO

{ts '2025-07-07 15:37:55'} 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
-- 2358
-- BRO

{ts '2025-07-07 18:42: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
-- 2358
-- BRO

{ts '2025-07-07 18:42:05'} 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
-- 2358
-- BRO

{ts '2025-07-07 18:42: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
-- 2358
-- BRO

{ts '2025-07-07 18:42:46'} 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
-- 2358
-- BRO

{ts '2025-07-07 18:43: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
-- 2358
-- BRO

{ts '2025-07-07 18:43:48'} 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
-- 2358
-- BRO

{ts '2025-07-07 18:43:52'} 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
-- 2358
-- BRO

{ts '2025-07-07 18:44: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
-- 2358
-- BRO

{ts '2025-07-07 18:45:32'} 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
-- 2358
-- BRO

{ts '2025-07-07 18:45: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
-- 2358
-- BRO

{ts '2025-07-07 18:45: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
-- 2358
-- BRO

{ts '2025-07-07 18:45:51'} 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
-- 2358
-- BRO

{ts '2025-07-07 18:45:54'} 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
-- 2358
-- BRO

{ts '2025-07-07 18:46: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
-- 2358
-- BRO

{ts '2025-07-07 18:46: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
-- 2358
-- BRO

{ts '2025-07-07 18:46:38'} 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
-- 2358
-- BRO

{ts '2025-07-07 18:46:48'} 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
-- 2358
-- BRO

{ts '2025-07-07 18:46: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
-- 2358
-- BRO

{ts '2025-07-07 18:46:56'} 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
-- 2358
-- BRO

{ts '2025-07-07 18:47: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
-- 2358
-- BRO

{ts '2025-07-07 18:47:14'} 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
-- 2358
-- BRO

{ts '2025-07-07 18:47: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
-- 2358
-- BRO

{ts '2025-07-07 18:47:33'} 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
-- 2358
-- BRO

{ts '2025-07-07 18:47: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
-- 2358
-- BRO

{ts '2025-07-07 18:47: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
-- 2358
-- BRO

{ts '2025-07-07 18:48: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
-- 2358
-- BRO

{ts '2025-07-07 18:48:06'} 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
-- 2358
-- BRO

{ts '2025-07-07 18:48: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
-- 2358
-- BRO

{ts '2025-07-07 18:49: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
-- 2358
-- BRO

{ts '2025-07-07 18:49:06'} 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
-- 2358
-- BRO

{ts '2025-07-07 18:49:54'} 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
-- 2358
-- BRO

{ts '2025-07-07 18:49: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
-- 2358
-- BRO

{ts '2025-07-07 18:50: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
-- 2358
-- BRO