1
select `proc`.`ComputerID` AS `ComputerID`,`pl`.`ID` AS `PListID`,`pl`.`Name` AS `PListName`,`pl`.`ProcName` AS `PListProcName`,`proc`.`Name` AS `ProcessName`,`proc`.`ProcPath` AS `ProcessPath`,if((`proc`.`ProcPath` = 'None'),`proc`.`Name`,reverse(left(reverse(`proc`.`ProcPath`),(locate('\\',reverse(`proc`.`ProcPath`)) - 1)))) AS `ProcExt`,`pl`.`Exename` AS `PListExt` from (`labtech`.`processes` `proc` join `labtech`.`processlist` `pl` on((`proc`.`Name` = `pl`.`ProcName`))) where (`pl`.`Status` = 1)