1
select `hp`.`HisID` AS `HisID`,`hp`.`ComputerID` AS `ComputerID`,`hf`.`HotFixID` AS `HotfixID`,`hp`.`QueuedDate` AS `QueuedDate`,`hp`.`FinishedDate` AS `FinishedDate`,`hp`.`Result` AS `Result`,`hp`.`Success` AS `Success`,`hfd`.`kbID` AS `KBID`,`hfd`.`Title` AS `Title`,`hfd`.`Severity` AS `Severity`,`hfd`.`CategoryName` AS `CategoryName`,`hfd`.`PatchType` AS `PatchType`,`hf`.`Installed` AS `Installed`,`hf`.`Approved` AS `Approved`,`hf`.`Pushed` AS `Pushed`,`hfd`.`Ignore` AS `Ignore` from ((`labtech`.`h_patching` `hp` join `labtech`.`hotfix` `hf` on(((`hp`.`ComputerID` = `hf`.`ComputerID`) and (find_in_set(`hf`.`HotFixID`,`hp`.`Patches`) > 0)))) join `labtech`.`hotfixdata` `hfd` on(((`hf`.`HotFixID` = `hfd`.`HotFixID`) and (`hf`.`OS` = `hfd`.`OS`))))