v_rc_reportschedulerecipients

select `rsr`.`ReportScheduleRecipientID` AS `ReportScheduleRecipientID`,`rsr`.`ReportScheduleID` AS `ReportScheduleID`,`rsr`.`RecipientName` AS `RecipientName`,elt(`rsr`.`RecipientType`,'Contact','User') AS `RecipientType`,`rsr`.`RecipientEmail` AS `RecipientEmail`,`rsr`.`RecipientTypeID` AS `RecipientTypeID`,`rsr`.`ClientID` AS `ClientID`,`rsr`.`DateAdded` AS `RecipientDateAdded`,`usr1`.`Name` AS `UserAdded`,`rsr`.`LastUpdate` AS `RecipientLastUpdate`,`usr2`.`Name` AS `UserLastUpdate` from ((`labtech`.`reportschedulerecipients` `rsr` join `labtech`.`users` `usr1` on((`rsr`.`UserIDAdded` = `usr1`.`UserID`))) join `labtech`.`users` `usr2` on((`rsr`.`UserIDLastUpdate` = `usr2`.`UserID`)))