12:14:10 - IsConnectionValid True 12:14:11 - IsConnectionValid True 12:14:11 - IsConnectionValid True 13:37:15 - IsConnectionValid True 13:37:20 - IsConnectionValid True 13:37:26 - IsConnectionValid True 13:37:27 - IsConnectionValid True 13:37:29 - IsConnectionValid True 13:37:31 - IsConnectionValid True 13:37:31 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM Projects WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:37:35 - IsConnectionValid True 14:07:55 - IsConnectionValid True 14:07:57 - IsConnectionValid True 14:07:57 - IsConnectionValid True