1
select `labtech`.`agents`.`AgentID` AS `AgentID`,`labtech`.`computers`.`ComputerID` AS `ComputerID`,`labtech`.`agents`.`Name` AS `AgentName`,`labtech`.`agents`.`AlertMessage` AS `AlertMessage`,`labtech`.`agents`.`interval` AS `interval`,`labtech`.`agents`.`LastScan` AS `LastScan`,`labtech`.`agents`.`LastFailed` AS `LastFailed`,`labtech`.`agents`.`FailCount` AS `FailCount`,`labtech`.`h_agents`.`LastFailDate` AS `LastFailDate`,`labtech`.`h_agents`.`LastSuccessDate` AS `LastSuccessDate` from ((`labtech`.`agents` straight_join `labtech`.`h_agents` on((`labtech`.`agents`.`AgentID` = `labtech`.`h_agents`.`AgentID`))) join `labtech`.`computers` on((`labtech`.`computers`.`ComputerID` = `labtech`.`agents`.`ComputerID`))) where (`labtech`.`agents`.`CheckAction` > 4)