1
select `md`.`MobileID` AS `MobileID`,`md`.`ClientID` AS `ClientID`,`md`.`LocationID` AS `LocationID`,`md`.`ContactID` AS `ContactID`,`md`.`UDID` AS `UDID`,`md`.`Password` AS `Password`,`md`.`InstallId` AS `InstallID`,`md`.`OsType` AS `OsType`,`md`.`DeviceType` AS `DeviceType`,`md`.`InternalFlags` AS `InternalFlags`,`mdi`.`DeviceName` AS `DeviceName`,`mdi`.`TimeZone` AS `TimeZone`,`mdi`.`OsVersion` AS `OsVersion`,`mdi`.`TotalMemory` AS `TotalMemory`,`mdi`.`MemoryAvail` AS `MemoryAvail`,`mdi`.`MemoryWired` AS `MemoryWired`,`mdi`.`MemoryActive` AS `MemoryActive`,`mdi`.`MemoryInactive` AS `MemoryInactive`,`mdi`.`MemoryFreePhys` AS `MemoryFreePhys`,`mdi`.`DiskTotal` AS `DiskTotal`,`mdi`.`DiskUsed` AS `DiskUsed`,`mdi`.`DiskFree` AS `DiskFree`,`mdi`.`CpuType` AS `CpuType`,`mdi`.`CpuTotal` AS `CpuTotal`,`mdi`.`CpuUsed` AS `CpuUsed`,`mdi`.`CpuKernel` AS `CpuKernel`,`mdi`.`CpuNice` AS `CpuNice`,`mdi`.`CpuUser` AS `CpuUser`,`mdi`.`CpuIdle` AS `CpuIdle`,`mdi`.`CpuFreq` AS `CpuFreq`,`mdi`.`BatteryStatus` AS `BatteryStatus`,`mdi`.`BatteryLevel` AS `Batterylevel`,`mdi`.`BatteryHealth` AS `BatteryHealth`,`mdi`.`CellTechnology` AS `CellTechnology`,`mdi`.`NetworkRoaming` AS `NetworkRoaming`,`mdi`.`VoiceRoamingEnabled` AS `VoiceRoamingEnabled`,`mdi`.`DataRoamingEnabled` AS `DataRoamingEnabled`,`mdi`.`BusFreq` AS `BusFreq`,`mdi`.`PasscodePresent` AS `PasscodePresent`,`mdi`.`PasscodeCompliant` AS `PasscodeCompliant`,`mdi`.`PasscodeProfileComp` AS `PasscodeProfileComp`,`mdi`.`ConfigClasses` AS `ConfigClasses`,`mdi`.`LastContact` AS `LastContact`,`mdi`.`LastInventory` AS `LastInventory`,`mdi`.`AssetDate` AS `AssetDate`,`mdi`.`MAC` AS `MAC`,`mdi`.`DateAdded` AS `DateAdded`,`mdi`.`Flags` AS `Flags`,`mdi`.`AppVersion` AS `AppVersion`,`mdi`.`CallState` AS `CallState`,`mdi`.`CellCid` AS `CellCid`,`mdi`.`CellLocation` AS `CellLocation`,`mdi`.`CellScramble` AS `CellScramble`,`mdi`.`BaseStation` AS `BaseStation`,`mdi`.`BaseStationLat` AS `BaseStationLat`,`mdi`.`BaseStationLong` AS `BaseStationLong`,`mdi`.`NetworkID` AS `NetworkId`,`mdi`.`SystemID` AS `SystemId`,`mdi`.`DataActivity` AS `DataActivity`,`mdi`.`DataState` AS `DataState`,`mdi`.`NetworkCountyIso` AS `NetworkCountyIso`,`mdi`.`NetworkOperator` AS `NetworkOperator`,`mdi`.`NetworkOperatorName` AS `NetworkOperatorName`,`mdi`.`NetworkType` AS `NetworkType`,`mdi`.`SimState` AS `SimState`,`mdi`.`HasIccCard` AS `HasIccCard`,`mdi`.`BuildVersion` AS `BuildVersion`,`mdi`.`ModelName` AS `ModelName`,`mdi`.`Model` AS `Model`,`mdi`.`ProductName` AS `ProductName`,`mdi`.`SerialNumber` AS `SerialNumber`,`mdi`.`IMEI` AS `IMEI`,`mdi`.`MEID` AS `MEID`,`mdi`.`ModemFirmwareVersion` AS `ModemFirmwareVersion`,`mdi`.`ICCID` AS `ICCID`,`mdi`.`BluetoothMAC` AS `BluetoothMAC`,`mdi`.`SIMOperatorName` AS `SIMOperatorName`,`mdi`.`SubscriberOperatorName` AS `SubscriberOperatorName`,`mdi`.`CarrierSettingsVersion` AS `CarrierSettingsVersion`,`mdi`.`PhoneNumber` AS `PhoneNumber`,`mdi`.`SubscriberMCC` AS `SubscriberMCC`,`mdi`.`SubscriberMNC` AS `SubscriberMNC`,`mdi`.`SIMMCC` AS `SIMMCC`,`mdi`.`SIMMNC` AS `SIMMNC`,`mdi`.`CurrentMCC` AS `CurrentMCC`,`mdi`.`CurrentMNC` AS `CurrentMNC`,`mdi`.`HardwareEncryptionCaps` AS `HardwareEncryptionCaps`,`mdi`.`DataInWiFi` AS `DataInWiFi`,`mdi`.`DataOutWiFi` AS `DataOutWiFi`,`mdi`.`DataInCell` AS `DataInCell`,`mdi`.`DataOutCell` AS `DataOutCell`,`mdi`.`Hostname` AS `Hostname`,`mdi`.`PublicIP` AS `PublicIP` from (`labtech`.`mobiledevices` `md` left join `labtech`.`mobiledeviceinfo` `mdi` on((`md`.`MobileID` = `mdi`.`MobileID`)))