SELECT temperature,humidity,lux,linger,position,activity,presence FROM `userdevices` WHERE DeviceGroupID=101 and DeviceID=1004

SELECT * FROM `msgcommlist` WHERE Groupid=101 and deviceid=1004 and Direction="INBOUND"

SELECT MsgDateTime, Message FROM `msgcommlist` WHERE DeviceID=1004

SELECT Temperature,Humidity,Lux,Linger,Position,Activity,Presence FROM `userdevices` WHERE DeviceGroupID=101