1
select `cmp`.`ClientID` AS `ClientID`,`cmp`.`ComputerID` AS `ComputerID`,`sched`.`DefScheduleID` AS `DefScheduleID`,`sched`.`Schedule` AS `BackupSchedule`,`sched`.`FirstRun` AS `BackupScheduleFirstRun`,`sched`.`LastRun` AS `BackupScheduleLastRun`,(`sched`.`IsOldSchedule` = 0) AS `BackupScheduleActive`,`job`.`LTJobID` AS `LTJobID`,`lbt`.`JobTypeName` AS `BackupJobType`,`lbs`.`SubTypeName` AS `BackupJobSubType`,`job`.`StartTime` AS `BackupJobStartTime`,`job`.`EndTime` AS `BackupJobEndTime`,`stat`.`StatusName` AS `BackupJobStatus` from (((((`labtech`.`h_backupjobs` `job` join `labtech`.`backupdefinitionschedules` `sched` on(((`job`.`DefinitionGUID` = `sched`.`DefinitionGUID`) and (`job`.`JobTypeID` = `sched`.`JobTypeID`) and ((`job`.`JobSubTypeID` = `sched`.`JobSubTypeID`) or (`sched`.`JobSubTypeID` = 3))))) join `labtech`.`computers` `cmp` on((`job`.`ComputerID` = `cmp`.`ComputerID`))) left join `labtech`.`l_backupjobtype` `lbt` on((`job`.`JobTypeID` = `lbt`.`JobTypeId`))) left join `labtech`.`l_backupjobsubtype` `lbs` on((`job`.`JobSubTypeID` = `lbs`.`SubTypeId`))) left join `labtech`.`l_backupjobstatus` `stat` on((`job`.`JobStatus` = `stat`.`StatusId`))) where ((`job`.`StartTime` >= `sched`.`FirstRun`) and (`job`.`StartTime` <= `sched`.`LastRun`))