1
select `labtech`.`clients`.`Name` AS `ClientName`,`labtech`.`licensemanagement`.`Name` AS `Name`,`labtech`.`licensemanagement`.`SearchString` AS `SearchString`,`labtech`.`licensemanagement`.`LicenseCount` AS `LicenseCount`,(select count(0) from `labtech`.`software` where ((`labtech`.`software`.`Name` like `labtech`.`licensemanagement`.`SearchString`) and `labtech`.`software`.`ComputerID` in (select `labtech`.`computers`.`ComputerID` from `labtech`.`computers` where (`labtech`.`computers`.`ComputerID` = `labtech`.`software`.`ComputerID`)))) AS `UsedCount` from (`labtech`.`licensemanagement` join `labtech`.`clients` on((`labtech`.`clients`.`ClientID` = `labtech`.`licensemanagement`.`ClientID`)))