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` . `IsStatus` , `a0` . `Createdby` , `a0` . `SAAssessmentType` , `a0` . `IAAssessmentType` , `a0` . `EAAssessmentType` , `a0` . `SMAssessmentType` , `a0` . `IsCompleted` , `s` . `ScheduleStatus` , `a` . `IA_Id` , `a` . `EA_Id` , `CONCAT` ( `CONCAT` ( COALESCE ( `u0` . `FirstName` , ? ) , ? ) , COALESCE ( `u0` . `LastName` , ? ) ) AS `FapName` , `CONCAT` ( `CONCAT` ( COALESCE ( `u0` . `FirstName` , ? ) , ? ) , COALESCE ( `u0` . `LastName` , ? ) ) AS `IADoneBy` FROM `AuditSchedule_Application` AS `a` INNER JOIN `Audit_Schedule` AS `a0` ON `a` . `AuditId` = `a0` . `Id` INNER JOIN `User_Master` AS `u` ON `a` . `UserId` = `u` . `Id` INNER JOIN `Schedular_Master` AS `s` ON `a` . `ScheduledId` = `s` . `ScheduleId` INNER JOIN 