1
select `labtech`.`mobileandroidinstalledapps`.`MobileId` AS `MobileId`,`labtech`.`mobiledeviceinfo`.`DeviceName` AS `DeviceName`,`labtech`.`mobileandroidapplookup`.`AppName` AS `AppName`,`labtech`.`mobileandroidapplookup`.`AppVersion` AS `AppVersion` from ((`labtech`.`mobileandroidinstalledapps` left join `labtech`.`mobiledeviceinfo` on((`labtech`.`mobileandroidinstalledapps`.`MobileId` = `labtech`.`mobiledeviceinfo`.`MobileID`))) left join `labtech`.`mobileandroidapplookup` on((`labtech`.`mobileandroidapplookup`.`AppId` = `labtech`.`mobileandroidinstalledapps`.`AppId`)))