1
select `con`.`ContactID` AS `ContactID`,`cmp`.`ClientID` AS `ClientID`,`cmp`.`LocationID` AS `LocationID`,`cmp`.`ComputerID` AS `AssetID`,if(((locate('server',`cmp`.`OS`) > 0) or (locate('linux',`cmp`.`OS`) > 0)),'Server','Workstation') AS `AssetType` from (`labtech`.`contacts` `con` join `labtech`.`computers` `cmp` on((`con`.`ContactID` = `cmp`.`ContactID`))) union select -(1) AS `-1`,`cmp`.`ClientID` AS `ClientID`,`cmp`.`LocationID` AS `LocationID`,`cmp`.`ComputerID` AS `ComputerID`,if(((locate('server',`cmp`.`OS`) > 0) or (locate('linux',`cmp`.`OS`) > 0)),'Server','Workstation') AS `AssetType` from `labtech`.`computers` `cmp` where (`cmp`.`ContactID` <= 0) union select `con`.`ContactID` AS `ContactID`,`mob`.`ClientID` AS `ClientID`,`mob`.`LocationID` AS `LocationID`,`mob`.`MobileID` AS `MobileID`,'Mobile' AS `Mobile` from (`labtech`.`contacts` `con` join `labtech`.`mobiledevices` `mob` on((`con`.`ContactID` = `mob`.`ContactID`))) union select -(1) AS `-1`,`mob`.`ClientID` AS `ClientID`,`mob`.`LocationID` AS `LocationID`,`mob`.`MobileID` AS `MobileID`,'Mobile' AS `Mobile` from `labtech`.`mobiledevices` `mob` where (`mob`.`ContactID` <= 0) union select `con`.`ContactID` AS `ContactID`,`con`.`ClientID` AS `ClientID`,`con`.`LocationID` AS `LocationID`,0 AS `0`,'' AS `Blank` from ((`labtech`.`contacts` `con` left join `labtech`.`computers` `cmp` on((`con`.`ContactID` = `cmp`.`ContactID`))) left join `labtech`.`mobiledevices` `mob` on((`con`.`ContactID` = `mob`.`ContactID`))) where (isnull(`cmp`.`ContactID`) and isnull(`mob`.`ContactID`) and (`con`.`ContactID` <> 0))