IP: - 93.175.194.138 - 147.161.136.92; TIME:2023-12-11 08:42:11; SELECT SELECT t.latitude, t.longitude,t.deviceloginname FROM tmslogistic.tms_gpsdata_fixed t WHERE t.DeviceLoginName IN (2997) AND t.time>='2023-12-11 00:00:00' and t.time<='2023-12-11 06:42:11' and  t.latitude <> 0 and t.longitude <> 0 ORDER BY t.date DESC Limit 1