SELECT `a` . `Id` , `a` . `UserId` , `a` . `AuditId` , `a` . `ScheduledId` , `a` . `IsDeleted` , `a` . `IsActive` , `a` . `Createdby` , `a` . `QuestionId` , `a` . `QuestionTitle` , `a` . `QuestionType` , `a` . `Answer` , `a` . `AnswerType` , `a` . `DocumentUrl` , `a` . `Comments` , `a` . `IsStatus` , `a` . `IsEAStatus` , `a` . `IsIAStatus` , `a` . `IA_Id` , `a` . `IA_Answer` , `a` . `IA_DocumentUrl` , `a` . `IA_Comments` , `a` . `EA_Id` , `a` . `EA_Answer` , `a` . `Exposure` , `a` . `Likelihood` , `a` . `Consequence` , `a` . `EA_Comments` , `a` . `EA_DocumentUrl` , `a` . `ComplinaceType` , `CONCAT` ( `CONCAT` ( COALESCE ( `u` . `FirstName` , ? ) , ? ) , COALESCE ( `u` . `LastName` , ? ) ) AS `SelfName` , ( SELECT `CONCAT` ( `CONCAT` ( COALESCE ( `u0` . `FirstName` , ? ) , ? ) , COALESCE ( `u0` . `LastName` , ? ) ) FROM `User_Master` AS `u0` WHERE `u0` . `Id` = `a` . `EA_Id` LIMIT ? ) AS `EAname` , ( SELECT `CONCAT` ( `CONCAT` ( COALESCE ( `u1` . `FirstName` , ? ) , ? ) , COALESCE ( `u1` . 