SELECT DISTINCTROW `CONCAT` ( `u` . `FirstName` , ? , `u` . `LastName` ) AS `Title` , `u` . `Id` FROM `AuditSchedule_Application` AS `a` INNER JOIN `User_Master` AS `u` ON `a` . `UserId` = `u` . `Id` WHERE ( ( `a` . `IsActive` AND NOT ( `a` . `IsDeleted` ) ) AND ( `u` . `CreatedBy` = ? ) ) OR ( `u` . `OrgEmailId` = ? ) 