IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-01 16:14:17; query SELECT `DeviceLoginName`,`speed`,DATE(ADDTIME(`time`,'0 2:0:0')), TIME(ADDTIME(`time`,'0 2:0:0')),`latitude`,`longitude` FROM `tms_gpsdata_fixed` WHERE `time`>='2024-01-31 22:00:00' AND `time`<='2024-02-01 21:59:59' AND `speed` > 110 AND DeviceLoginName IN ('8984','9011','2590','2725','2820','3072','2698','3163','5080','2492','2494','2597','2654','2701','2727','2757','2807','2844','2846','2874','2888','2913','2950','2966','2720','3086','3099','3141','3147','4959','2535','3125','2557','2633','5072','9375','353173060488002','355234055232561','354836080121006','358021081941837','352353084291100','352353084150330','352353084149035','352353084652467','352353085645312','352353086184659','864866053465679','862531041050148','862531041069957','356078111445637','356078111469876','356078116292406','356078116281466') ORDER BY `time` ASC IP: - 109.201.252.2 - 147.161.138.110; TIME:2024-02-01 16:14:37; query SELECT `DeviceLoginName`,`speed`,DATE(ADDTIME(`time`,'0 2:0:0')), TIME(ADDTIME(`time`,'0 2:0:0')),`latitude`,`longitude` FROM `tms_gpsdata_fixed` WHERE `time`>='2023-12-31 22:00:00' AND `time`<='2024-01-31 21:59:59' AND `speed` > 110 AND DeviceLoginName IN ('8984','9011','2590','2725','2820','3072','2698','3163','5080','2492','2494','2597','2654','2701','2727','2757','2807','2844','2846','2874','2888','2913','2950','2966','2720','3086','3099','3141','3147','4959','2535','3125','2557','2633','5072','9375','353173060488002','355234055232561','354836080121006','358021081941837','352353084291100','352353084150330','352353084149035','352353084652467','352353085645312','352353086184659','864866053465679','862531041050148','862531041069957','356078111445637','356078111469876','356078116292406','356078116281466') ORDER BY `time` ASC