Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, Web40OSName.OSname As OS, tblOperatingsystem.Description, tblUsers.SID, Duplicates.Total, tblComputers.Lastseen, Web40OSName.Compimage As icon From tblComputers Inner Join tblUsers On tblComputers.Computername = tblUsers.Computername Inner Join web40ActiveComputers On web40ActiveComputers.Computername = tblComputers.Computername Inner Join (Select Top 1000000 tblUsers.SID, Count(tblUsers.UserID) As Total From tblComputers Inner Join tblUsers On tblComputers.Computername = tblUsers.Computername Inner Join web40ActiveComputers On web40ActiveComputers.Computername = tblComputers.Computername Group By tblUsers.SID Having tblUsers.SID Like '%-500' And Count(tblUsers.UserID) > 1) Duplicates On tblUsers.SID = Duplicates.SID Inner Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Order By Duplicates.Total Desc, tblUsers.SID, dbo.tblComputers.Computer