SELECT Count ([Projects].[Id]) as ProjectCount
        FROM Projects with (NOLOCK)
        INNER JOIN [v_UserVisibleTeams] AS [UserTeams] ON [UserTeams].[UserId] = 2 AND [Projects].[Owning_Team] = [UserTeams].[TeamId]
        INNER JOIN CxEntities.Team as [teamPath] ON [teamPath].[Id] = [Projects].[Owning_Team]
        LEFT JOIN (
            SELECT
                [TaskScans].[ProjectId],
                MAX([TaskScans].[StartTime]) AS LastScanDate,
                COUNT([TaskScans].[Id]) as TotalScans
            FROM [TaskScans] with (NOLOCK)
            WHERE [TaskScans].[is_deprecated] = 0
            AND (1 = 0 OR([TaskScans].[ScanType] = 1))
            GROUP BY [TaskScans].[ProjectId]
        ) AS [TotalProjectData]
        ON [TotalProjectData].[ProjectId] = [Projects].[Id]
        where  [Projects].[is_deprecated] = 0   ;
        select
        [Projects].[Id],
        [Projects].[Path],
        [Projects].[Name],
        [OpenedAt],
        [OpenedBy],
        [Origin],
        [Owner],
        [Owning_Team],
        [Is_Public],
        [Executable],
        [UNCCredentials],
        [Description],
        [LastScanDate],
        [TotalScans],
        [ExcludeFilesPatterns],
        [ExcludeFoldersPatterns],
        [IssueTrackingSettings],
        [ScansToKeep],
        [Projects].[is_deprecated],
        [OpenSourceAnalysisOrigin],
        [PresetId],
        [ConfigurationId],
        [TaskId_Computed],
        [PreScanActionId],
        [ProjectOpenSourceSettings].[LibreriesDirectories] AS OpenSourceSettingsLibreriesDirectories,
        [ProjectOpenSourceSettings].[Username] AS OpenSourceSettingsUsername,
        [ProjectOpenSourceSettings].[Password] AS OpenSourceSettingsPassword
        FROM Projects with (NOLOCK)
        INNER JOIN [v_UserVisibleTeams] AS [UserTeams] ON [UserTeams].[UserId] = 2 AND [Projects].[Owning_Team] = [UserTeams].[TeamId]
        INNER JOIN CxEntities.Team as [teamPath] ON [teamPath].[Id] = [Projects].[Owning_Team]
        LEFT JOIN (
            SELECT
                [TaskScans].[ProjectId],
                MAX([TaskScans].[StartTime]) AS LastScanDate,
                COUNT([TaskScans].[Id]) as TotalScans
            FROM [TaskScans] with (NOLOCK)
            WHERE [TaskScans].[is_deprecated] = 0
            AND (1 = 0 OR([TaskScans].[ScanType] = 1))
            GROUP BY [TaskScans].[ProjectId]
        ) AS [TotalProjectData]
        ON [TotalProjectData].[ProjectId] = [Projects].[Id]
        LEFT JOIN [ProjectOpenSourceSettings] with (NOLOCK)
        ON  Projects.Id = [ProjectOpenSourceSettings].ProjectId
        where  [Projects].[is_deprecated] = 0
        order by  LastScanDate DESC
       OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY;