1
select distinct sql_no_cache `labtech`.`hotfix`.`ComputerID` AS `ComputerID`,`hfd`.`HotFixID` AS `HotfixID`,`hfd`.`OS` AS `OS`,`hfd`.`IsThirdParty` AS `IsThirdParty`,`hfd`.`Manufacturer` AS `Manufacturer`,`hfd`.`kbID` AS `KBID`,`hfd`.`Bulletin` AS `Bulletin`,`hfd`.`Title` AS `Title`,`hfd`.`Description` AS `Description`,`hfd`.`CategoryName` AS `Category`,`hfd`.`Severity` AS `Severity`,`hfd`.`CVSS` AS `CVSS`,ifnull((to_days(now()) - to_days(`hfd`.`Date_Added`)),-(1)) AS `Age`,`labtech`.`hotfix`.`Approved` AS `ApprovalPolicy`,if((`labtech`.`hotfix`.`Failed` = 0),if((`labtech`.`hotfix`.`Installed` = 0),if((`labtech`.`hotfix`.`Pushed` = 0),0,1),2),3) AS `PatchState`,`labtech`.`hotfix`.`QueuedDate` AS `QueuedDate` from (`labtech`.`hotfix` join `labtech`.`hotfixdata` `hfd` on(((`hfd`.`LTProductKey` = `labtech`.`hotfix`.`HotFixID`) and ((`labtech`.`hotfix`.`OS` = `hfd`.`OS`) or (`hfd`.`IsThirdParty` = 1)))))