SELECT `a` . `UserId` , `a0` . `UserId` AS `FapId` , `a0` . `ComplianceType` , `CONCAT` ( `CONCAT` ( COALESCE ( `u` . `FirstName` , ? ) , ? ) , COALESCE ( `u` . `LastName` , ? ) ) AS `SADoneBy` , `a` . `UpdatedDate` , `a` . `AuditId` , `a` . `ScheduledId` , `a` . `IsDeleted` , `a` . `IsActive` , `a` . `IsIAStatus` , `a` . `IsEAStatus` , `a` . `IsStatus` , `a0` . `Createdby` , `a0` . `SAAssessmentType` , `a0` . `IAAssessmentType` , `a0` . `EAAssessmentType` , `a0` . `SMAssessmentType` , `a0` . `IsCompleted` , `s` . `ScheduleStatus` , `a` . `IA_Id` , `a` . `EA_Id` , `s` . `StartDate` , `s` . `EndDate` , `a` . `sm_Comments` AS `SM_Comment` , `CONCAT` ( `CONCAT` ( COALESCE ( `u0` . `FirstName` , ? ) , ? ) , COALESCE ( `u0` . `LastName` , ? ) ) AS `FapName` , ( SELECT `CONCAT` ( `CONCAT` ( COALESCE ( `u1` . `FirstName` , ? ) , ? ) , COALESCE ( `u1` . `LastName` , ? ) ) FROM `User_Master` AS `u1` WHERE `u1` . `Id` = `a` . `IA_Id` LIMIT ? ) AS `IADoneBy` , ( SELECT `CONCAT` ( `CONCAT` ( COALESCE ( `u2` . `FirstName` 