SELECT Users.Id,
Users.IsActive,
Users.Risk,
Users.Name,
Users.EmployeeID,
Users.OrganizationId,
Users.Username,
Users.IsUser,
Users.WFID,
Organizations.Name AS orgName,
(SELECT MAX(UserTestGroups.ModifiedOn)
FROM UsersInSchedules
LEFT JOIN UserTestGroups ON UsersInSchedules.Id = UserTestGroups.UserInScheduleID
WHERE Users.Id = UsersInSchedules.UserID) AS LastTest
FROM Users
LEFT JOIN Organizations ON Users.OrganizationID = Organizations.Id
WHERE Users.isUser = '0'
AND Users.IsDeleted = '0'
ORDER BY Users.Name ASC
OFFSET 15 ROWS FETCH NEXT 15 ROWS ONLY
SELECT Users.Id,
Users.IsActive,