1
select `rs`.`ReportScheduleID` AS `ReportScheduleID`,`rs`.`ScheduleTitle` AS `ScheduleTitle`,`rs`.`DateAdded` AS `ScheduleDateAdded`,`usr1`.`Name` AS `ScheduleUserAdded`,`rs`.`DateLastUpdate` AS `ScheduleDateLastUpdate`,`usr2`.`Name` AS `ScheduleUserLastUpdate`,`rs`.`EmailTemplateID` AS `EmailTemplateID`,`et`.`EmailTemplateTitle` AS `EmailTemplateTitle`,`et`.`EmailSubject` AS `EmailSubject`,`et`.`EmailContent` AS `EmailContent`,`et`.`DateAdded` AS `EmailTemplateDateAdded`,`usr3`.`Name` AS `EmailTemplateUserAdded`,`et`.`LastUpdate` AS `EmailTemplateDateLastUpdate`,`usr4`.`Name` AS `EmailTemplateUserLastUpdate`,`rs`.`Description` AS `ScheduleDescription`,`rs`.`RepetitionText` AS `ScheduleRepetitionPattern`,`rs`.`NextScheduledRun` AS `ScheduleNextRun` from (((((`labtech`.`reportschedules` `rs` join `labtech`.`users` `usr1` on((`rs`.`UserIDAdded` = `usr1`.`UserID`))) join `labtech`.`users` `usr2` on((`rs`.`UserIDLastUpdate` = `usr2`.`UserID`))) join `labtech`.`emailtemplates` `et` on((`rs`.`EmailTemplateID` = `et`.`EmailTemplateID`))) join `labtech`.`users` `usr3` on((`et`.`UserIDAdded` = `usr3`.`UserID`))) join `labtech`.`users` `usr4` on((`et`.`UserIDLastUpdate` = `usr4`.`UserID`)))