1
select `bul`.`LogID` AS `LogID`,`bul`.`ComputerID` AS `ComputerID`,`bul`.`BackupID` AS `BackupID`,concat(`bul`.`BackupID`,'-',`bus`.`JobID`,if((locate('Full',`bul`.`Details`) > 0),'-P','-S')) AS `JobTypeID`,`bul`.`Status` AS `Status`,`bul`.`EventDate` AS `EventDate`,`bul`.`Details` AS `Details`,`bul`.`BackupTime` AS `BackupTime` from (`labtech`.`backuplogs` `bul` join `labtech`.`backupstatus` `bus` on((`bul`.`BackupID` = `bus`.`BackupID`))) order by `bul`.`EventDate` desc