SELECT `a` . `UserId` , `a` . `AuditId` , `a` . `ScheduledId` , `a` . `IA_Id` , `a` . `EA_Id` , `u` . `FirstName` , `u` . `LastName` , CASE WHEN `u` . `FSPNumber` = ? THEN ? ELSE CAST ( `u` . `FSPNumber` AS CHARACTER ) END , `u` . `RoleStr` , `a` . `UpdatedDate` , ( SELECT `CONCAT` ( `u0` . `FirstName` , ? , `u0` . `LastName` ) FROM `User_Master` AS `u0` WHERE `u0` . `Id` = `a` . `IA_Id` LIMIT ? ) , ( SELECT `CONCAT` ( `u1` . `FirstName` , ? , `u1` . `LastName` ) FROM `User_Master` AS `u1` WHERE `u1` . `Id` = `a` . `EA_Id` LIMIT ? ) , CASE WHEN `a0` . `SAAssessmentType` OR `a0` . `SMAssessmentType` THEN CASE WHEN `a` . `IsStatus` = ? THEN ? WHEN `a` . `IsStatus` = ? THEN ? ELSE ? END ELSE ? END , CASE WHEN `a0` . `EAAssessmentType` THEN CASE WHEN `a` . `IsEAStatus` = ? THEN ? WHEN `a` . `IsEAStatus` = ? THEN ? ELSE ? END ELSE ? END , CASE WHEN `a0` . `IAAssessmentType` THEN CASE WHEN `a` . `IsIAStatus` = ? THEN ? WHEN `a` . `IsIAStatus` = ? THEN ? ELSE ? END ELSE ? END FROM `User_Master` AS `u` INNER JOIN `AuditSchedule_Application` AS `a` ON `u` . `Id` = `a` . `UserId` INNER JOIN `Audit_Schedule` AS `a0` ON `a` . 