SELECT `ch`.`CoachID`, `cg`.`CoachID`, `ch`.`CoachName`, `cg`.`CoachName`, `ch`.`CountryID`, `cg`.`CountryID` FROM `Match` INNER JOIN `CoachCareer` AS `hc` ON `hc`.`ClubID` = `MatchHomeClub` AND `hc`.`StartDate` < `MatchDate` AND (`hc`.`EndDate` > `MatchDate` OR `hc`.`EndDate` IS NULL) INNER JOIN `CoachCareer` AS `gc` ON `gc`.`ClubID` = `MatchGuestClub` AND `gc`.`StartDate` < `MatchDate` AND (`gc`.`EndDate` > `MatchDate` OR `gc`.`EndDate` IS NULL) INNER JOIN `Coach` AS `ch` ON `ch`.`CoachID` = `hc`.`CoachID` INNER JOIN `Coach` AS `cg` ON `cg`.`CoachID` = `gc`.`CoachID` WHERE `MatchID` = 405693