SELECT `u` . `FirstName` , `u` . `FSPNumber` , `u` . `LastName` , `u` . `Id` , `u` . `RoleStr` , `a` . `IsActive` , `a` . `IsDeleted` , `u` . `CreatedBy` , `u` . `ParentId` , `u` . `OrgEmailId` FROM `User_Master` AS `u` INNER JOIN `AspNetUsers` AS `a` ON `u` . `Email` = `a` . `Email` WHERE ( ( ( `u` . `RoleStr` = ? ) AND ( `a` . `IsDeleted` = FALSE ) ) AND `a` . `IsActive` ) AND ( ( `u` . `CreatedBy` = ? ) OR ( `u` . `Id` = ? ) ) 