1
select `labtech`.`mobileiosinstalledapps`.`MobileID` AS `MobileId`,`labtech`.`mobiledeviceinfo`.`DeviceName` AS `DeviceName`,`labtech`.`mobileiosapplookup`.`AppName` AS `AppName`,`labtech`.`mobileiosapplookup`.`AppVersion` AS `AppVersion` from ((`labtech`.`mobileiosinstalledapps` left join `labtech`.`mobiledeviceinfo` on((`labtech`.`mobileiosinstalledapps`.`MobileID` = `labtech`.`mobiledeviceinfo`.`MobileID`))) left join `labtech`.`mobileiosapplookup` on((`labtech`.`mobileiosapplookup`.`AppID` = `labtech`.`mobileiosinstalledapps`.`AppID`)))